Squared Away - Assignment
Batman007
SquaredAwayJune2021Financials.xlsxBalance Sheet
| Squared Away Partners, LLC | ||
| Balance Sheet | ||
| As of June 30, 2021 | ||
| As of June 30, 2021 | As of May 31, 2021 (PP) | |
| ASSETS | ||
| Current Assets | ||
| Bank Accounts | ||
| Bank of America Business Checking | 681,455 | 637,167 |
| Total Bank Accounts | $ 681,455 | $ 637,167 |
| Other Current Assets | ||
| Prepaid Expense | 7,356 | 8,567 |
| Stripe Receivable | 33,012 | 55,200 |
| Total Other Current Assets | $ 40,368 | $ 63,767 |
| Total Current Assets | $ 721,823 | $ 700,934 |
| TOTAL ASSETS | $ 721,823 | $ 700,934 |
| LIABILITIES AND EQUITY | ||
| Liabilities | ||
| Current Liabilities | ||
| Credit Cards | ||
| American Express | - 0 | - 0 |
| Ramp | 539 | 408 |
| USAA Business Credit Card | - 0 | - 0 |
| Total Credit Cards | $ 539 | $ 408 |
| Other Current Liabilities | ||
| Accrued Assistant Payroll | 135,796 | 73,859 |
| Accrued Contractor Pmts | 33,195 | 81,294 |
| Due to Michelle | - 0 | - 0 |
| Total Other Current Liabilities | $ 168,991 | $ 155,153 |
| Total Current Liabilities | $ 169,529 | $ 155,561 |
| Total Liabilities | $ 169,529 | $ 155,561 |
| Equity | ||
| Daniel Equity | 17,453 | 17,453 |
| Daniel Distributions | (19,966) | (15,443) |
| Total Daniel Equity | $ (2,513) | $ 2,010 |
| Kelsey Equity | 10,463 | 10,463 |
| Kelsey Distributions | (10,948) | (8,235) |
| Total Kelsey Equity | $ (485) | $ 2,228 |
| Michelle Equity | 226,882 | 226,882 |
| Michelle Distributions | (251,004) | (209,981) |
| Total Michelle Equity | $ (24,122) | $ 16,901 |
| Retained Earnings | 0 | 0 |
| Shane Equity | 104,696 | 104,696 |
| Shane Distributions | (117,385) | (90,249) |
| Total Shane Equity | $ (12,689) | $ 14,447 |
| Net Income | 592,103 | 509,787 |
| Total Equity | $ 552,294 | $ 545,373 |
| TOTAL LIABILITIES AND EQUITY | $ 721,823 | $ 700,934 |
&9These statements have not been subjected to an audit, review, or compilation and no assurance is provided. Substantially all disclosures required by accounting principles generally accepted in the United States are not included.
P&L YTD
| Squared Away Partners, LLC | ||||
| Profit and Loss - YTD | ||||
| January - June, 2021 | ||||
| Jan - Jun, 2021 | Jan - Jun, 2020 (PY) | Change | % Change | |
| Income | ||||
| SA Store Income | 156 | 156 | ||
| Squared Away Client Plans | 2,416,262 | 835,761 | 1,580,501 | 189.11% |
| Addtl Hours Squared Away Client Plans | 90,450 | 16,800 | 73,650 | 438.39% |
| Contract Buyouts | 51,700 | 51,700 | ||
| Referral & Other Discounts | (10,770) | (6,645) | (4,125) | -62.08% |
| Refunds | (11,149) | (18,798) | 7,649 | 40.69% |
| Total Squared Away Client Plans | $ 2,536,493 | $ 827,118 | $ 1,709,375 | 206.67% |
| Total Income | $ 2,536,649 | $ 827,118 | $ 1,709,531 | 206.69% |
| Cost of Goods Sold | ||||
| SA Store Costs | 2,257 | 2,257 | ||
| Squared Away Contractors | ||||
| Assistant Payments | 910,953 | 491,073 | 419,880 | 85.50% |
| Bonus (Time Zone, Max Hours) | 13,640 | 10,550 | 3,090 | 29.29% |
| Client Connections Salary | 4,444 | |||
| Coverage Pay | - 0 | - 0 | - 0 | |
| Extra Hours Pay | 41,085 | 9,936 | 31,149 | 313.50% |
| Managerial & Lead Pay | 40,090 | 28,684 | 11,406 | 39.76% |
| Training & Dynamic Resourcing | 19,986 | 18,275 | 1,712 | 9.37% |
| Wages - Assistants | ||||
| Assistant Bonus | 8,050 | 8,050 | ||
| Assistant Extra Hours Pay | 17,865 | 17,865 | ||
| Assistant Managerial & Lead Pay | 21,317 | 21,317 | ||
| Assistant Payroll Taxes | 54,776 | 54,776 | ||
| Assistant Wages | 469,105 | 469,105 | ||
| Training & DR | 14,655 | 14,655 | ||
| Total Wages - Assistants | $ 585,768 | $ - 0 | $ 585,768 | |
| Total Squared Away Contractors | $ 1,615,966 | $ 558,517 | $ 1,057,449 | 189.33% |
| Total Cost of Goods Sold | $ 1,618,223 | $ 558,517 | $ 1,059,706 | 189.74% |
| Gross Profit | $ 918,425 | $ 268,601 | $ 649,825 | 241.93% |
| Expenses | ||||
| Accounting | 9,000 | 7,806 | 1,194 | 15.30% |
| Advertising & Marketing | 1,053 | 1,321 | (269) | -20.34% |
| Bank Charges & Fees | 51 | (28) | 78 | 283.55% |
| Blog Post Pay | 400 | (400) | -100.00% | |
| Insurance | 2,180 | 1,114 | 1,066 | 95.72% |
| Legal Fees | 1,805 | (1,805) | -100.00% | |
| Meals & Entertainment | 60 | 80 | (21) | -25.98% |
| Office Software Expense | 49,089 | 14,187 | 34,902 | 246.02% |
| Office Supplies | 3,322 | 1,513 | 1,809 | 119.57% |
| Office/General Administrative Expenses | 206 | (206) | -100.00% | |
| Other Business Expenses | 487 | 1,326 | (840) | -63.31% |
| Payroll Service Fees | 14,527 | 6,107 | 8,419 | 137.86% |
| Personnel Expenses | ||||
| Employee Salaries | 79,931 | 36,667 | 43,264 | 117.99% |
| Officer Compensation | 60,375 | 57,500 | 2,875 | 5.00% |
| Payroll Taxes | 15,249 | 7,832 | 7,417 | 94.70% |
| Professional Development | 3,950 | 3,950 | ||
| Referral Bonus - Commissions | 13,500 | 2,700 | 10,800 | 400.00% |
| Total Personnel Expenses | $ 173,004 | $ 104,698 | $ 68,306 | 65.24% |
| Rent & Lease | 817 | (817) | -100.00% | |
| Shipping and postage | 3 | 3 | ||
| Stripe Fees | 63,469 | 24,979 | 38,491 | 154.09% |
| Taxes & Licenses | 10,188 | 1,135 | 9,053 | 797.25% |
| Travel | (190) | 1,185 | (1,375) | -116.03% |
| Website Expense | 80 | 400 | (320) | -79.99% |
| Total Expenses | $ 326,322 | $ 169,053 | $ 157,268 | 93.03% |
| Net Operating Income | $ 592,103 | $ 99,547 | $ 492,556 | 494.80% |
| Net Income | $ 592,103 | $ 99,547 | $ 492,556 | 494.80% |
&9These statements have not been subjected to an audit, review, or compilation and no assurance is provided. Substantially all disclosures required by accounting principles generally accepted in the United States are not included.
Chart1
Squared Away
Income, COS, Expenses and Net Income
Trailing 12 Months
Total Income
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 164805 180860.5 195625 259768.08000000002 266171.67000000004 279001.84000000003 313919.02 356278.72 421489.05 485674.68 459466.94 499820.21 Total Cost of Goods Sold
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 149538.16 115113.19 116980.27 149115.81 170607.19 189100.9 194529.69999999995 229071.12999999998 249135.32 282662.56999999995 316109.89000000007 346714.68000000005 Total Expenses
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 35393.51 39518.07 35973.369999999988 44221.159999999996 40991.920000000006 48148.97 50538.61 46891.69 47835.200000000004 56995.9 53271.25 70789.260000000009 Net Income
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 -20126.670000000006 26229.239999999998 42671.360000000008 66431.110000000015 54572.560000000034 41751.97000000003 68850.710000000065 80315.899999999994 124518.52999999997 146016.21000000005 90085.79999999993 82316.26999999996 Income
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 SA Store Income
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 20 21 Apr 2021 May 2021 June 2021 32 109.99 0 23 23 Squared Away Client Plans
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 160040 177460.5 189605 251796.13 256971.67 270869.84000000003 305429.03000000003 336578.72 410316.05 422442.2 447766.94 493728.88 Addtl Hours Squared Away Client Plans
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 4890 4050 6900 9150 9350 8250 10500 20550 14550 15450 13350 16050 Referral & Other Discounts
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 -280 0 -150 -150 -1870 -850 -3400 -2300 -750 -1600 Refunds
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 -125 -650 -600 -1178.05 -250 0 0 -1640.52 -900 -8358.67 Total Squared Away Client Plans
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 164805 180860.5 195625 259768.08000000002 266171.67000000004 278969.84000000003 313809.03000000003 356278.72 421466.05 485651.68 459466.94 499820.21 Cost of Goods Sold
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 SA Store Costs
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 98.03 26.49 2230.66 Squared Away Contractors
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 Assistant Payments
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 136051.25 105588.16 105510.31 135802.75 154282 169842.65 149237.57999999999 170514.28 195500.34 185812.2 147144.23000000001 62744.55 Bonus (Time Zone, Max Hours)
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 17.5 100 300 1300 1000 3450 4000 3000 890 #REF!
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 1 Extra Hours Pay
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 3836 3120 2664 4995 5850 5490 5760 10650 8820 10440 3645 1770 Managerial & Lead Pay
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 6842.5 3760 4915 5225 7525 8911.36 7955 7900 7995.27 7776.08 6095 2368.1799999999998 Wages - Assistants
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 20 21 May 2021 June 2021 #REF!
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 1 Bank Charges & Fees
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 1 3.99 5 8.25 1 23.77 1.28 4 12.25 Blog Post Pay
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 Insurance
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 338.58 338.58 338.58 338.58 338.58 338.58 338.58 338.58 403.48 366.58 366.58 366.58 Legal Fees
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 2421.23 Meals & Entertainment
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 59.5 Office Software Expense
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 3267.82 3849.7 3579.03 5000.7 5401.85 4285.34 4652.7 4172.28 4464.8 5600.25 9400.32 20798.560000000001 Office Supplies
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 80.45 100.77 25.59 1183.58 3265.54 13.57 43.09 Office/General Administrative Expenses
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 594.1 365.56 250 Other Business Expenses
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 83.5 70 70 140.83000000000001 70.83 1710.28 70.83 70.83 70.83 132.47999999999999 70.84 70.849999999999994 Payroll Service Fees
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 1251 1395 1383 1575 1743 1791 1923 2199 2091 2283 2715 3315.56 Personnel Expenses
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 Employee Salaries
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 10000.01 11666.68 12282.06 13583.35 11916.68 14000.02 14124.65 14365.61 14000.02 12641.04 10799.18 14000.02 Officer Compensation
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 9583.32 9583.32 9583.32 9583.32 9583.32 10062.5 10062.5 10062.5 10062.5 10062.5 10062.5 10062.5 Payroll Taxes
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 1526.79 1678.97 1742.64 1938.94 1800.14 1807.45 4504.5200000000004 2509.4 2601.21 2003.69 1685.82 1943.86 Professional Development
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 500 658.33 658.33 658.33 658.29 658.29 658.29 Rent & Lease
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 Stripe Fees
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 4894.07 5101.32 4664.2299999999996 6380.81 6670.12 6643.51 7343.79 8281.59 9315.26 11634.54 12759.63 14134.67 Taxes & Licenses
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 10.220000000000001 225 8009.25 803 1140.5 Travel
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 1057.26 2009.18 0 -190 Website Expense
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 16.72 16.72 614.38 16.72 316.72000000000003 316.22000000000003 16 16 16 16 16 Net Operating Income
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 -20126.670000000006 26229.239999999998 42671.360000000008 66431.110000000015 54572.560000000034 41751.97000000003 68850.710000000065 80315.899999999994 124518.52999999997 146016.21000000005 90085.79999999993 82316.26999999996 #REF!
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 1 #REF!
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 1 #REF!
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021 1
Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 June 2021
Monthly Profit and Loss
| Squared Away Partners, LLC | ||||||||||||||||
| Profit and Loss - Monthly | ||||||||||||||||
| July 2020 - June 2021 | ||||||||||||||||
| Jul 2020 | Aug 2020 | Sep 2020 | Oct 2020 | Nov 2020 | Dec 2020 | Jan 2021 | Feb 2021 | Mar 2021 | Apr 2021 | May 2021 | June 2021 | Total | ||||
| Income | ||||||||||||||||
| SA Store Income | $ 32 | $ 110 | $ - 0 | $ 23 | $ 23 | $ 188 | $ - 0 | ERROR:#DIV/0! | ||||||||
| Squared Away Client Plans | 160,040 | 177,461 | 189,605 | 251,796 | 256,972 | 270,870 | 305,429 | 336,579 | 410,316 | 422,442 | 447,767 | 493,729 | 3,723,005 | $ 45,962 | 9% | |
| Addtl Hours Squared Away Client Plans | 4,890 | 4,050 | 6,900 | 9,150 | 9,350 | 8,250 | 10,500 | 20,550 | 14,550 | 15,450 | 13,350 | 16,050 | 133,040 | $ 2,700 | 17% | |
| Contract Buyouts | 51,700 | 51,700 | ||||||||||||||
| Referral & Other Discounts | (280) | 0 | (150) | (150) | (1,870) | (850) | (3,400) | (2,300) | (750) | (1,600) | (11,350) | $ (850) | 53% | |||
| Refunds | (125) | (650) | (600) | (1,178) | (250) | 0 | 0 | (1,641) | (900) | (8,359) | (13,702) | $ (7,459) | 89% | |||
| Total Squared Away Client Plans | $ 164,805 | $ 180,861 | $ 195,625 | $ 259,768 | $ 266,172 | $ 278,970 | $ 313,809 | $ 356,279 | $ 421,466 | $ 485,652 | $ 459,467 | $ 499,820 | $ 3,882,693 | $ 40,353 | 8% | |
| Total Income | $ 164,805 | $ 180,861 | $ 195,625 | $ 259,768 | $ 266,172 | $ 279,002 | $ 313,919 | $ 356,279 | $ 421,489 | $ 485,675 | $ 459,467 | $ 499,820 | $ 3,882,881 | $ 40,353 | 8% | |
| Cost of Goods Sold | $ - 0 | |||||||||||||||
| SA Store Costs | 98 | 26 | 2,231 | 2,355 | $ - 0 | ERROR:#DIV/0! | ||||||||||
| Squared Away Contractors | $ - 0 | |||||||||||||||
| Assistant Payments | 136,051 | 105,588 | 105,510 | 135,803 | 154,282 | 169,843 | 149,238 | 170,514 | 195,500 | 185,812 | 147,144 | 62,745 | 1,718,030 | $ (84,400) | -135% | |
| Bonus (Time Zone, Max Hours) | 18 | 100 | 300 | 1,300 | 1,000 | 3,450 | 4,000 | 3,000 | 890 | 14,058 | $ (2,110) | -237% | ||||
| Client Connections Salary | 1,111 | 3,333 | - 0 | 4,444 | ||||||||||||
| Extra Hours Pay | 3,836 | 3,120 | 2,664 | 4,995 | 5,850 | 5,490 | 5,760 | 10,650 | 8,820 | 10,440 | 3,645 | 1,770 | 67,040 | $ (1,875) | -106% | |
| Managerial & Lead Pay | 6,843 | 3,760 | 4,915 | 5,225 | 7,525 | 8,911 | 7,955 | 7,900 | 7,995 | 7,776 | 6,095 | 2,368 | 77,268 | $ (3,727) | -157% | |
| Training & Dynamic Resourcing | 2,791 | 2,645 | 3,891 | 3,093 | 2,850 | 4,459 | 2,136 | 4,121 | 4,785 | 4,717 | 3,135 | 1,092 | 39,715 | $ (2,044) | -187% | |
| Wages - Assistants | $ - 0 | |||||||||||||||
| Assistant Bonus | 50 | 350 | 1,050 | 2,800 | 3,800 | 8,050 | ||||||||||
| Assistant Extra Hours Pay | 630 | 1,890 | 180 | 1,530 | 5,355 | 8,280 | 17,865 | $ 2,925 | 35% | |||||||
| Assistant Managerial & Lead Pay | 1,500 | 1,500 | 1,234 | 2,529 | 4,517 | 10,036 | 21,317 | $ 5,519 | 55% | |||||||
| Assistant Payroll Taxes | 2,380 | 2,946 | 2,055 | 6,338 | 10,955 | 30,101 | 54,776 | $ 19,146 | 64% | |||||||
| Assistant Wages | 23,598 | 28,483 | 22,535 | 55,845 | 122,090 | 216,555 | 469,105 | $ 94,465 | 44% | |||||||
| Training & DR | 6 | 17 | 1,513 | 4,041 | 9,078 | 14,655 | $ 5,037 | 55% | ||||||||
| Total Wages - Assistants | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 28,114 | $ 34,886 | $ 26,354 | $ 68,806 | $ 149,757 | $ 277,850 | $ 585,768 | $ 128,093 | 46% | |
| Total Squared Away Contractors | $ 149,538 | $ 115,113 | $ 116,980 | $ 149,116 | $ 170,607 | $ 189,003 | $ 194,503 | $ 229,071 | $ 246,905 | $ 282,663 | $ 316,110 | $ 346,715 | $ 2,506,324 | $ 30,605 | 9% | |
| Total Cost of Goods Sold | $ 149,538 | $ 115,113 | $ 116,980 | $ 149,116 | $ 170,607 | $ 189,101 | $ 194,530 | $ 229,071 | $ 249,135 | $ 282,663 | $ 316,110 | $ 346,715 | $ 2,508,679 | $ 30,605 | 9% | |
| Gross Profit | $ 15,267 | $ 65,747 | $ 78,645 | $ 110,652 | $ 95,564 | $ 89,901 | $ 119,389 | $ 127,208 | $ 172,354 | $ 203,012 | $ 143,357 | $ 153,106 | $ 1,374,202 | $ 9,748 | 6% | |
| Gross Profit Percentage | 9% | 36% | 40% | 43% | 36% | 32% | 38% | 36% | 41% | 42% | 31% | 31% | 35% | |||
| Expenses | $ - 0 | |||||||||||||||
| Accounting | 1,500 | 1,500 | 1,500 | 3,350 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 19,850 | $ - 0 | 0% | |
| Advertising & Marketing | 599 | 243 | 212 | 212 | 225 | 225 | 203 | 203 | 203 | 87 | 87 | 270 | 2,769 | $ 183 | 68% | |
| Bank Charges & Fees | 1 | 4 | 5 | 8 | 1 | 24 | 1 | 4 | 12 | 61 | $ 8 | 67% | ||||
| Blog Post Pay | - 0 | $ - 0 | ||||||||||||||
| Insurance | 339 | 339 | 339 | 339 | 339 | 339 | 339 | 339 | 403 | 367 | 367 | 367 | 4,212 | $ - 0 | 0% | |
| Legal Fees | 2,421 | 2,421 | $ - 0 | |||||||||||||
| Meals & Entertainment | 60 | 60 | $ - 0 | ERROR:#DIV/0! | ||||||||||||
| Office Software Expense | 3,268 | 3,850 | 3,579 | 5,001 | 5,402 | 4,285 | 4,653 | 4,172 | 4,465 | 5,600 | 9,400 | 20,799 | 74,473 | $ 11,398 | 55% | |
| Office Supplies | 80 | 101 | 26 | 1,184 | 3,266 | 14 | 43 | 4,713 | $ (43) | ERROR:#DIV/0! | ||||||
| Office/General Administrative Expenses | 594 | 366 | 250 | 1,210 | $ - 0 | |||||||||||
| Other Business Expenses | 84 | 70 | 70 | 141 | 71 | 1,710 | 71 | 71 | 71 | 132 | 71 | 71 | 2,632 | $ 0 | 0% | |
| Payroll Service Fees | 1,251 | 1,395 | 1,383 | 1,575 | 1,743 | 1,791 | 1,923 | 2,199 | 2,091 | 2,283 | 2,715 | 3,316 | 23,665 | $ 601 | 18% | |
| Personnel Expenses | $ - 0 | |||||||||||||||
| Employee Salaries | 10,000 | 11,667 | 12,282 | 13,583 | 11,917 | 14,000 | 14,125 | 14,366 | 14,000 | 12,641 | 10,799 | 14,000 | 153,379 | $ 3,201 | 23% | |
| Officer Compensation | 9,583 | 9,583 | 9,583 | 9,583 | 9,583 | 10,063 | 10,063 | 10,063 | 10,063 | 10,063 | 10,063 | 10,063 | 118,354 | $ - 0 | 0% | |
| Payroll Taxes | 1,527 | 1,679 | 1,743 | 1,939 | 1,800 | 1,807 | 4,505 | 2,509 | 2,601 | 2,004 | 1,686 | 1,944 | 25,743 | $ 258 | 13% | |
| Professional Development | 500 | 658 | 658 | 658 | 658 | 658 | 658 | 4,450 | $ - 0 | 0% | ||||||
| Referral Bonus - Commissions | 600 | 1,200 | 0 | 2,000 | 1,400 | 1,500 | 2,000 | 2,500 | 2,200 | 2,000 | 2,300 | 2,500 | 20,200 | |||
| Total Personnel Expenses | $ 21,710 | $ 24,629 | $ 23,608 | $ 27,106 | $ 24,700 | $ 27,370 | $ 31,350 | $ 30,096 | $ 29,522 | $ 27,366 | $ 25,506 | $ 29,165 | $ 322,127 | $ 3,659 | 13% | |
| Rent & Lease | - 0 | $ - 0 | ||||||||||||||
| Shipping and postage | 109 | 3 | 112 | $ - 0 | ERROR:#DIV/0! | |||||||||||
| Stripe Fees | 4,894 | 5,101 | 4,664 | 6,381 | 6,670 | 6,644 | 7,344 | 8,282 | 9,315 | 11,635 | 12,760 | 14,135 | 97,824 | $ 1,375 | 10% | |
| Taxes & Licenses | 10 | 225 | 8,009 | 803 | 1,141 | 10,188 | $ 338 | 30% | ||||||||
| Travel | 1,057 | 2,009 | 0 | (190) | 2,876 | $ - 0 | ERROR:#DIV/0! | |||||||||
| Website Expense | 17 | 17 | 614 | 17 | 317 | 316 | 16 | 16 | 16 | 16 | 16 | 1,377 | $ - 0 | |||
| Total Expenses | $ 35,394 | $ 39,518 | $ 35,973 | $ 44,221 | $ 40,992 | $ 48,149 | $ 50,539 | $ 46,892 | $ 47,835 | $ 56,996 | $ 53,271 | $ 70,789 | $ 570,569 | $ 17,518 | 25% | |
| Net Operating Income | $ (20,127) | $ 26,229 | $ 42,671 | $ 66,431 | $ 54,573 | $ 41,752 | $ 68,851 | $ 80,316 | $ 124,519 | $ 146,016 | $ 90,086 | $ 82,316 | $ 803,633 | $ (7,770) | -9% | |
| Net Income | $ (20,127) | $ 26,229 | $ 42,671 | $ 66,431 | $ 54,573 | $ 41,752 | $ 68,851 | $ 80,316 | $ 124,519 | $ 146,016 | $ 90,086 | $ 82,316 | $ 803,633 | $ (7,770) | -9% | |
&9These statements have not been subjected to an audit, review, or compilation and no assurance is provided. Substantially all disclosures required by accounting principles generally accepted in the United States are not included.
Statement of Cash Flows
| Squared Away Partners, LLC | |||||||||||||
| Statement of Cash Flows | |||||||||||||
| July 2020 - June 2021 | |||||||||||||
| Jul 2020 | Aug 2020 | Sep 2020 | Oct 2020 | Nov 2020 | Dec 2020 | Jan 2021 | Feb 2021 | Mar 2021 | Apr 2021 | May 2021 | June 2021 | Total | |
| OPERATING ACTIVITIES | |||||||||||||
| Net Income | (20,127) | 26,229 | 42,671 | 66,431 | 54,573 | 41,752 | 68,851 | 80,316 | 124,519 | 146,016 | 90,086 | 82,316 | 803,633 |
| Adjustments to reconcile Net Income to Net Cash provided by operations: | |||||||||||||
| Prepaid Expense | (2,463) | 454 | (166) | (938) | 525 | 525 | (6,716) | 1,184 | (3,151) | 1,212 | 1,212 | 1,212 | (7,111) |
| Stripe Receivable | 5,481 | (7,971) | (6,693) | (2,842) | (16,537) | 31,979 | (38,211) | (21,654) | 35,324 | (2,973) | (15,048) | 22,188 | (16,957) |
| Accounts Payable | 3,060 | (3,060) | - 0 | ||||||||||
| American Express | 4,993 | (1,186) | 980 | (4,054) | 2,324 | (288) | (790) | (821) | 1,158 | ||||
| Ramp | 40 | 3,275 | (3,020) | 26 | 77 | 130 | 529 | ||||||
| USAA Business Credit Card | 90 | (90) | - 0 | ||||||||||
| Accrued Assistant Payroll | 13,033 | 22,089 | 38,737 | 61,937 | 135,796 | ||||||||
| Accrued Contractor Pmts | 26,579 | 31,422 | 681 | 18,277 | 7,961 | 6,323 | 9,940 | 13,886 | (1,607) | (5,041) | (27,127) | (48,100) | 33,195 |
| Due to Michelle | (2,504) | (14) | (15,059) | (15,059) | (15,045) | (47,680) | |||||||
| Total Adjustments to reconcile Net Income to Net Cash provided by operations: | $ 32,087 | $ 22,719 | $ (5,198) | $ 10,443 | $ (5,727) | $ 38,539 | $ (35,662) | $ (18,367) | $ 27,669 | $ 268 | $ (5,210) | $ 37,367 | $ 98,929 |
| Net cash provided by operating activities | $ 11,961 | $ 48,949 | $ 37,473 | $ 76,874 | $ 48,846 | $ 80,291 | $ 33,189 | $ 61,948 | $ 152,188 | $ 146,284 | $ 84,876 | $ 119,683 | $ 902,562 |
| FINANCING ACTIVITIES | |||||||||||||
| Daniel Equity | 15,554 | 15,554 | |||||||||||
| Daniel Equity:Daniel Distributions | (1,206) | (3,250) | (544) | (5,976) | (4,523) | (15,499) | |||||||
| Kelsey Equity | 9,332 | 9,332 | |||||||||||
| Kelsey Equity:Kelsey Distributions | (723) | (1,950) | (326) | (3,586) | (2,713) | (9,298) | |||||||
| Michelle Equity | 192,868 | 192,868 | |||||||||||
| Michelle Equity:Michelle Distributions | (14,961) | (40,295) | (21,798) | (74,103) | (41,023) | (192,180) | |||||||
| Retained Earnings | (311,077) | (311,077) | |||||||||||
| Shane Equity | 93,323 | 93,323 | |||||||||||
| Shane Equity:Shane Distributions | (7,239) | (19,497) | (3,261) | (35,856) | (27,136) | (92,989) | |||||||
| Net cash provided by financing activities | $ - 0 | $ - 0 | $ (24,129) | $ - 0 | $ - 0 | $ (64,992) | $ (25,929) | $ - 0 | $ - 0 | $ - 0 | $ (119,521) | $ (75,395) | $ (309,966) |
| Net cash increase for period | $ 11,961 | $ 48,949 | $ 13,344 | $ 76,874 | $ 48,846 | $ 15,299 | $ 7,260 | $ 61,948 | $ 152,188 | $ 146,284 | $ (34,645) | $ 44,288 | $ 592,596 |
&9These statements have not been subjected to an audit, review, or compilation and no assurance is provided. Substantially all disclosures required by accounting principles generally accepted in the United States are not included.
