A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||
2 | How to use this template? | |||||||||||||||||||||||||
3 | 1) Install LiveFlow here | |||||||||||||||||||||||||
4 | 2) Open LiveFlow -> Go to Extensions -> LiveFlow -> Get started | |||||||||||||||||||||||||
5 | 3) Connect your QuickBooks company to LiveFlow (if you haven't done that already) | |||||||||||||||||||||||||
6 | 4) Head over to the Manage Reports tab in LiveFlow. | |||||||||||||||||||||||||
7 | 5) Click on the Live P&L from QBO Report -> Click "Change Company" -> Change it to your own company | |||||||||||||||||||||||||
8 | Done! | |||||||||||||||||||||||||
9 | ||||||||||||||||||||||||||
10 | Last Updated • | 04/24/2024 06:19:52 | ||||||||||||||||||||||||
11 | ||||||||||||||||||||||||||
12 | Learn how to set up this template in the step-by-step video here 📹 | |||||||||||||||||||||||||
13 | ||||||||||||||||||||||||||
14 | Trailing 12 months P&L | Apr 2023 | May 2023 | Jun 2023 | Jul 2023 | Aug 2023 | Sep 2023 | Oct 2023 | Nov 2023 | Dec 2023 | Jan 2024 | Feb 2024 | Mar 2024 | Total | ||||||||||||
15 | Income | |||||||||||||||||||||||||
16 | 4001 Online Sales | $540,641.30 | $40,190.78 | $707.58 | $40,804.06 | $609.20 | $41,089.86 | $1,256.77 | $40,635.50 | $40,462.26 | $1,164,500.00 | $894,700.00 | $525,150.00 | $3,330,747.31 | ||||||||||||
17 | 40011 Cosmetics sales | $98,400.00 | $98,400.00 | |||||||||||||||||||||||
18 | Total 4001 Online Sales | $540,641.30 | $40,190.78 | $707.58 | $40,804.06 | $609.20 | $41,089.86 | $1,256.77 | $40,635.50 | $40,462.26 | $1,164,500.00 | $993,100.00 | $525,150.00 | $3,429,147.31 | ||||||||||||
19 | 4002 Retail Sales | $943,334.28 | $500,985.19 | $91,669.71 | $80,322.93 | $96,055.44 | $78,971.03 | $85,270.06 | $87,613.49 | $92,128.15 | $4,671,704.00 | $4,989,504.00 | $1,717,204.00 | $13,434,762.28 | ||||||||||||
20 | 4010 Uncategorized Income | $24,628.60 | $19,250.08 | $12,465.30 | $689.30 | $784.18 | $294.48 | $203.52 | $547.10 | $1,009.38 | $99,800.00 | $99,500.00 | $259,171.94 | |||||||||||||
21 | 4012 Sales of Product Income | $38,141.30 | $79,690.78 | $42,207.58 | $40,804.06 | $609.20 | $41,089.86 | $1,256.77 | $40,825.89 | $46,128.03 | $2,276,015.77 | $1,677,415.77 | $663,915.00 | $4,948,100.01 | ||||||||||||
22 | Total Income | $1,546,745.48 | $640,116.83 | $147,050.17 | $162,620.35 | $98,058.02 | $161,445.23 | $87,987.12 | $169,621.98 | $179,727.82 | $8,212,019.77 | $7,759,519.77 | $2,906,269.00 | $22,071,181.54 | ||||||||||||
23 | Cost of Goods Sold | $0.00 | ||||||||||||||||||||||||
24 | 5010 T-Shirts | $127,950.00 | $123,950.00 | $125,950.00 | $127,950.00 | $123,950.00 | $123,950.00 | $125,950.00 | $127,950.00 | $123,950.00 | $180,150.00 | $231,950.00 | $111,850.00 | $1,655,500.00 | ||||||||||||
25 | 5020 Shoes | $170,950.00 | $162,950.00 | $166,950.00 | $170,950.00 | $162,950.00 | $162,950.00 | $166,950.00 | $170,950.00 | $162,950.00 | $310,950.00 | $318,950.00 | $326,950.00 | $2,455,400.00 | ||||||||||||
26 | 5030 Delivery Fees | $9,950.00 | $9,950.00 | $9,950.00 | $9,950.00 | $9,950.00 | $9,950.00 | $9,950.00 | $9,950.00 | $9,950.00 | $9,950.00 | $9,950.00 | $9,950.00 | $119,400.00 | ||||||||||||
27 | Total Cost of Goods Sold | $308,850.00 | $296,850.00 | $302,850.00 | $308,850.00 | $296,850.00 | $296,850.00 | $302,850.00 | $308,850.00 | $296,850.00 | $501,050.00 | $560,850.00 | $448,750.00 | $4,230,300.00 | ||||||||||||
28 | Gross Profit | $1,237,895.48 | $343,266.83 | -$155,799.83 | -$146,229.65 | -$198,791.98 | -$135,404.77 | -$214,862.88 | -$139,228.02 | -$117,122.18 | $7,710,969.77 | $7,198,669.77 | $2,457,519.00 | $17,840,881.54 | ||||||||||||
29 | Expenses | $0.00 | ||||||||||||||||||||||||
30 | 6010 Online Marketing | $688,266.20 | $835,676.58 | $421,518.76 | $417,544.11 | $405,602.28 | $401,629.69 | $424,712.52 | $424,870.60 | $398,076.03 | $2,089,000.00 | $1,927,110.00 | $864,310.00 | $9,298,316.77 | ||||||||||||
31 | 6020 Subscriptions | $266,808.35 | $414,866.73 | $68,844.97 | $71,353.43 | $68,051.93 | $74,843.49 | $65,541.16 | $78,705.12 | $62,371.50 | $953,761.00 | $956,661.00 | $354,661.00 | $3,436,469.68 | ||||||||||||
32 | 6030 Travel Expenses | $182,890.00 | $685,554.00 | $87,560.00 | $89,560.00 | $85,560.00 | $85,560.00 | $87,560.00 | $89,560.00 | $85,560.00 | $1,666,500.00 | $1,179,500.00 | $336,600.00 | $4,661,964.00 | ||||||||||||
33 | 6040 Computers & Equipment | $68,863.38 | $92,967.14 | $46,351.56 | $35,367.32 | $47,557.20 | $41,064.06 | $40,860.36 | $36,699.03 | $40,860.36 | $126,350.00 | $3,950.00 | $134,050.00 | $714,940.41 | ||||||||||||
34 | 6045 Offsite Costs | $25,000.00 | $25,000.00 | |||||||||||||||||||||||
35 | 6050 Payroll | $816,556.80 | $764,560.00 | $774,560.00 | $784,560.00 | $764,560.00 | $764,560.00 | $774,560.00 | $784,560.00 | $764,560.00 | $3,726,700.00 | $3,565,850.00 | $2,356,800.00 | $16,642,386.80 | ||||||||||||
36 | 6060 G&A | $55,560.00 | $145,560.00 | $55,560.00 | $55,560.00 | $55,560.00 | $55,560.00 | $55,560.00 | $55,560.00 | $55,560.00 | $5,950.00 | $5,950.00 | $5,950.00 | $607,890.00 | ||||||||||||
37 | 6065 R&D | $24,000.00 | $24,000.00 | $24,000.00 | $24,000.00 | $953,800.00 | $836,150.00 | $165,200.00 | $2,051,150.00 | |||||||||||||||||
38 | 6070 Professional Services | $128,333.76 | $132,307.28 | $131,781.45 | $124,440.07 | $134,383.79 | $143,361.73 | $141,532.18 | $141,769.03 | $131,989.08 | $1,032,050.00 | $1,033,900.00 | $530,100.00 | $3,805,948.37 | ||||||||||||
39 | 6080 Legal | $3,750.00 | $3,750.00 | $3,750.00 | $3,750.00 | $3,750.00 | $3,750.00 | $3,750.00 | $3,750.00 | $3,750.00 | $1,248,000.00 | $1,363,650.00 | $489,650.00 | $3,135,050.00 | ||||||||||||
40 | 6700 Uncategorized Expense | $52,162.00 | $2,400.00 | $700.00 | $20,615.91 | $1,200.00 | $700.00 | $8,534.45 | $16,395.53 | $24,100.00 | $16,550.00 | $15,200.00 | $158,557.89 | |||||||||||||
41 | Payroll expenses | $0.00 | ||||||||||||||||||||||||
42 | Taxes | $37.57 | $37.57 | |||||||||||||||||||||||
43 | Wages | $260.00 | $260.00 | |||||||||||||||||||||||
44 | Total Payroll expenses | $0.00 | $0.00 | $297.57 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $297.57 | ||||||||||||
45 | Total Expenses | $2,263,190.49 | $3,101,641.73 | $1,590,924.31 | $1,602,750.84 | $1,614,025.20 | $1,595,528.97 | $1,594,776.22 | $1,624,008.23 | $1,583,122.50 | $11,826,211.00 | $10,889,271.00 | $5,252,521.00 | $44,537,971.49 | ||||||||||||
46 | Net Operating Income | -$1,025,295.01 | -$2,758,374.90 | -$1,746,724.14 | -$1,748,980.49 | -$1,812,817.18 | -$1,730,933.74 | -$1,809,639.10 | -$1,763,236.25 | -$1,700,244.68 | -$4,115,241.23 | -$3,690,601.23 | -$2,795,002.00 | -$26,697,089.95 | ||||||||||||
47 | Other Income | $0.00 | ||||||||||||||||||||||||
48 | 4040 Investment Income | $2,054,650.00 | $1,978,500.00 | $599,700.00 | $4,632,850.00 | |||||||||||||||||||||
49 | Total Other Income | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,054,650.00 | $1,978,500.00 | $599,700.00 | $4,632,850.00 | ||||||||||||
50 | Other Expenses | $0.00 | ||||||||||||||||||||||||
51 | 9001 Home G&A | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $400.00 | $400.00 | $5,150.00 | $200.00 | $200.00 | $7,750.00 | ||||||||||||
52 | Total Other Expenses | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $400.00 | $400.00 | $5,150.00 | $200.00 | $200.00 | $7,750.00 | ||||||||||||
53 | Net Other Income | -$200.00 | -$200.00 | -$200.00 | -$200.00 | -$200.00 | -$200.00 | -$200.00 | -$400.00 | -$400.00 | $2,049,500.00 | $1,978,300.00 | $599,500.00 | $4,625,100.00 | ||||||||||||
54 | Net Income | -$1,025,495.01 | -$2,758,574.90 | -$1,746,924.14 | -$1,749,180.49 | -$1,813,017.18 | -$1,731,133.74 | -$1,809,839.10 | -$1,763,636.25 | -$1,700,644.68 | -$2,065,741.23 | -$1,712,301.23 | -$2,195,502.00 | -$22,071,989.95 | ||||||||||||
55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
57 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
59 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
61 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
62 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
63 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
64 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
67 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
69 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
71 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
76 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
78 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
79 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
81 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
82 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
83 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
84 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
86 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
87 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
88 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
89 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
90 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
93 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
95 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
96 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
97 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
98 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||||
99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |