R-Work
Sheet1
| Jan 31, 21 | Feb 28, 21 | Mar 31, 21 | Apr 30, 21 | May 31, 21 | Jun 30, 21 | |||||||||||
| ASSETS | ||||||||||||||||
| Current Assets | ||||||||||||||||
| Checking/Savings | ||||||||||||||||
| Lead Money Market | 98,322.99 | 98,345.62 | 98,372.30 | 98,396.56 | 98,419.21 | 40,432.75 | ||||||||||
| Petty Cash | 72.78 | 72.78 | 72.78 | 72.78 | 72.78 | 72.78 | ||||||||||
| Lead Checking (5324) | 59,287.20 | 45,049.96 | 47,971.61 | 49,512.13 | 20,743.56 | 108,124.88 | ||||||||||
| Total Checking/Savings | 157,682.97 | 143,468.36 | 146,416.69 | 147,981.47 | 119,235.55 | 148,630.41 | ||||||||||
| Accounts Receivable | ||||||||||||||||
| Accounts Receivable | 59,314.39 | 80,031.47 | 53,914.65 | 103,254.98 | 162,781.76 | 118,868.30 | ||||||||||
| Total Accounts Receivable | 59,314.39 | 80,031.47 | 53,914.65 | 103,254.98 | 162,781.76 | 118,868.30 | ||||||||||
| Other Current Assets | ||||||||||||||||
| Undeposited Funds | 0.00 | 0.00 | 5,000.00 | 0.00 | 0.00 | 0.00 | ||||||||||
| Total Other Current Assets | 0.00 | 0.00 | 5,000.00 | 0.00 | 0.00 | 0.00 | ||||||||||
| Total Current Assets | 216,997.36 | 223,499.83 | 205,331.34 | 251,236.45 | 282,017.31 | 267,498.71 | ||||||||||
| Fixed Assets | ||||||||||||||||
| Computers | 48,480.06 | 48,480.06 | 48,480.06 | 48,480.06 | 48,480.06 | 48,480.06 | ||||||||||
| Accumulated Depreciation | -76,175.30 | -77,496.89 | -78,818.48 | -80,140.07 | -81,461.66 | -82,783.25 | ||||||||||
| Leasehold Improvements | 78,115.94 | 78,115.94 | 78,115.94 | 78,115.94 | 78,115.94 | 78,115.94 | ||||||||||
| Office Furniture & Equipment | 37,524.89 | 37,524.89 | 37,524.89 | 37,524.89 | 37,524.89 | 37,524.89 | ||||||||||
| Total Fixed Assets | 87,945.59 | 86,624.00 | 85,302.41 | 83,980.82 | 82,659.23 | 81,337.64 | ||||||||||
| TOTAL ASSETS | 304,942.95 | 310,123.83 | 290,633.75 | 335,217.27 | 364,676.54 | 348,836.35 | ||||||||||
| LIABILITIES & EQUITY | ||||||||||||||||
| Liabilities | ||||||||||||||||
| Current Liabilities | ||||||||||||||||
| Accounts Payable | ||||||||||||||||
| Accounts Payable | 8,077.79 | 11,296.53 | 8,499.25 | 12,626.72 | 9,533.20 | 4,927.31 | ||||||||||
| Total Accounts Payable | 8,077.79 | 11,296.53 | 8,499.25 | 12,626.72 | 9,533.20 | 4,927.31 | ||||||||||
| Credit Cards | ||||||||||||||||
| Capital One VISA | 2,507.17 | 1,221.78 | 3,477.50 | 2,886.71 | 954.28 | 2,425.35 | ||||||||||
| Total Credit Cards | 2,507.17 | 1,221.78 | 3,477.50 | 2,886.71 | 954.28 | 2,425.35 | ||||||||||
| Other Current Liabilities | ||||||||||||||||
| Payroll Liabilities | ||||||||||||||||
| SIMPLE Retirement Payable | 2,588.16 | 2,877.65 | 4,136.17 | 2,965.83 | 2,965.83 | 3,955.83 | ||||||||||
| Disability Ins Clearing | 0.00 | 4.02 | -364.58 | 4.02 | 4.02 | 4.02 | ||||||||||
| Health Insurance Clearing | 0.00 | 2,855.38 | 0.00 | -2,855.65 | 0.27 | 0.27 | ||||||||||
| MO WH Payable | 772.00 | 968.00 | 1,408.00 | 908.00 | 988.00 | 2,151.00 | ||||||||||
| KCE Payable | 1,079.10 | 486.75 | 870.90 | 251.85 | 533.93 | 1,038.54 | ||||||||||
| FUTA Payable | 147.11 | 233.90 | 252.00 | 252.96 | 271.40 | 300.53 | ||||||||||
| SUTA Payable | 215.76 | 434.34 | 547.33 | 19.29 | 61.92 | 104.65 | ||||||||||
| Payroll Clearing | -2,180.93 | -2,180.93 | -2,180.93 | -2,180.93 | -2,180.93 | -2,180.93 | ||||||||||
| Total Payroll Liabilities | 2,621.20 | 5,679.11 | 4,668.89 | -634.63 | 2,644.44 | 5,373.91 | ||||||||||
| Total Other Current Liabilities | 2,621.20 | 5,679.11 | 4,668.89 | -634.63 | 2,644.44 | 5,373.91 | ||||||||||
| Total Current Liabilities | 13,206.16 | 18,197.42 | 16,645.64 | 14,878.80 | 13,131.92 | 12,726.57 | ||||||||||
| Total Liabilities | 13,206.16 | 18,197.42 | 16,645.64 | 14,878.80 | 13,131.92 | 12,726.57 | ||||||||||
| Equity | ||||||||||||||||
| ER Shareholder Contributions | 41,186.47 | 41,186.47 | 41,186.47 | 41,186.47 | 41,186.47 | 41,186.47 | ||||||||||
| ER Shareholder Distributions | -22,105.13 | -22,105.13 | -22,105.13 | -22,105.13 | -22,105.13 | -22,105.13 | ||||||||||
| Retained Earnings | 282,580.08 | 282,580.08 | 282,580.08 | 282,580.08 | 282,580.08 | 282,580.08 | ||||||||||
| Net Income | -9,924.63 | -9,735.01 | -27,673.31 | 18,677.05 | 49,883.20 | 34,448.36 | ||||||||||
| Total Equity | 291,736.79 | 291,926.41 | 273,988.11 | 320,338.47 | 351,544.62 | 336,109.78 | ||||||||||
| TOTAL LIABILITIES & EQUITY | 304,942.95 | 310,123.83 | 290,633.75 | 335,217.27 | 364,676.54 | 348,836.35 | ||||||||||
&"Arial,Bold"&8 3:48 PM &"Arial,Bold"&8 07/19/21 &"Arial,Bold"&8 Accrual Basis &"Arial,Bold"&12 Rosin Preservation, LLC &"Arial,Bold"&14 Balance Sheet &"Arial,Bold"&10 As of June 30, 2021
&"Arial,Bold"&8 Page &P of &N