Resources 2.3 Income & Expense Workbook - Business & Rental- with P&L.xlsx

	A	B	C	D	F	G	H	J	K	L	N	O
1
2
3
4								Expenses
5			CY Totals	PY Totals	INCOME	81,265.00		Description	Amount	Category
6		Advertising	0.00		RETURNS	1,000.00		Example	1,500.00	Rent - Land	Total	10,038.00
7		Car & Truck Expense	670.00					Example	1,134.00	Utilities (cellphone, internet)	Validation	1,083.00
8		Commissions & Fees	0.00					Example	168.00	Taxes & Licenses		⚠ Warning: Item over $2500 detected & may need to be depreciated ⚠
9		Cleaning & Maintenance	0.00		Income Running Total			Example	464.00	Dues & Subscriptions
10		Legal & Professional Services	0.00		Date	Amount In	Returns	Example	99.00	Dues & Subscriptions
11		Management Fees	0.00			81,265.00		Example	160.00	Dues & Subscriptions
12		Depletion	0.00				1,000.00	Example	360.00	Dues & Subscriptions
13		Insurance	0.00					Example	428.00	Meals - Not applicable for Rentals
14		Self-Employed Health Insurance	0.00					Example	272.00	Continuing Education
15		Mortgage Interest	0.00					Example	354.00	Office Expense
16		POINTS PAID	0.00					Example	2,929.00	Merchant Service
17		Office Expense	354.00					Example	670.00	Car & Truck Expense
18		Supplies	0.00					Example	1,500.00	Business Use of Home
19		Taxes & Licenses	168.00
20		Repairs & Maintenance	0.00
21		Utilities (cellphone, internet)	1,134.00
22
23	Other Expenses		CY Totals	PY Totals
24		Total	3,201.00
25		Bank Fee	0.00
26		Shipping/Postage	0.00
27		Continuing Education	272.00
28		Merchant Service	2,929.00
29			0.00
30			0.00
31			0.00
32
33	Employee Benefits		CY Totals	PY Totals
34		Emplyee Health Ins (exlude co-pays)	0.00
35		Other Employee Benefits	0.00
36		Health Insurance Credit	0.00
37		Pension & Profit Sharing Plans	0.00
38
39	Rent or Lease		CY Totals	PY Totals
40		Vehicle, Machines, Equipment	0.00
41		Rent - Land	1,500.00
42
43
44
45	Travel & Meals		CY Totals	PY Totals
46		Travel	0.00
47		Meals - Not applicable for Rentals	428.00
48
49		DEPRECIATION	0.00
50		Total Exp	7,455.00
51		COGS	0.00
52		Business Use of Home	1,500.00
53		TOTAL	8,955.00
54		Meals Addback	214.00
55
56
57		Gross Income	80,265.00
58		Expenses	8,741.00
59		Net Income	71,524.00
60		Per Computer
61		Variance	71,524.00
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100