ABCDEFGHIJKLMNOPQRSTUVWXYZ
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&LApr 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
000000000000$0.00
56
000000000000$0.00
57
000000000000$0.00
58
000000000000$0.00
59
000000000000$0.00
60
000000000000$0.00
61
000000000000$0.00
62
000000000000$0.00
63
000000000000$0.00
64
000000000000$0.00
65
000000000000$0.00
66
000000000000$0.00
67
000000000000$0.00
68
000000000000$0.00
69
000000000000$0.00
70
000000000000$0.00
71
000000000000$0.00
72
000000000000$0.00
73
000000000000$0.00
74
000000000000$0.00
75
000000000000$0.00
76
000000000000$0.00
77
000000000000$0.00
78
000000000000$0.00
79
000000000000$0.00
80
000000000000$0.00
81
000000000000$0.00
82
000000000000$0.00
83
000000000000$0.00
84
000000000000$0.00
85
000000000000$0.00
86
000000000000$0.00
87
000000000000$0.00
88
000000000000$0.00
89
000000000000$0.00
90
000000000000$0.00
91
000000000000$0.00
92
000000000000$0.00
93
000000000000$0.00
94
000000000000$0.00
95
000000000000$0.00
96
000000000000$0.00
97
000000000000$0.00
98
000000000000$0.00
99
000000000000$0.00