FINANCIAL REPORT TEST.xlsx

	A	B	C	D	E
1	ACCOUNT	NORMAL SIGN	TYPE	CASH FLOW CAT	DESCRIPTION
2	CASH	POS	BS	CASH	CASH MONEY IN BANK OR IN YOUR POCKET
3	ACCOUNTS RECEIVABLE	POS	BS	OPS	WHAT YOUR CUSTOMER OWE YOU NOT RECEIVED YET
4	INVENTORY	POS	BS	OPS	STUFF YOU SELL ON THE SHELF NOT SOLD
5	PREPAID EXPENSES	POS	BS	OPS	PAYMENTS MADE BUT FOR FUTURE PERIODS
6	EQUIPMENT	POS	BS	INVEST	MACHINERY, CARS ETC. USED IN BUSINESS THAT WILL LAST MORE THAN A YEAR
7	DEPRECIATION RESERVE	NEG	BS	OPS	ACCUMULATED PROVISIONS TO RECORD USE OR LOST VALUE OF EQUIPMENT
8	ACCOUNTS PAYABLE	NEG	BS	OPS	WHAT YOU OWE YOUR SUPPLIERS BUT YOU HAVE NOT PAID YET
9	INCOME TAX PAYABLE	NEG	BS	OPS	WHAT YOU OWE THE GOVERNMENT FOR TAX BUT NOT PAID YET
10	SHORT TERM LOANS	NEG	BS	FIN	TOTAL PAYMENTS ON YOUR LOANS YOU OWE BUT ONLY FOR NEXT 12 MONTHS OR LESS
11	LONG TERM LOANS	NEG	BS	FIN	TOTAL PAYMENTS ON YOUR LOANS YOU OWE BUT ONLY FOR GREATER THAN 12 MONTHS
12	EQUITY	NEG	BS	FIN	AMOUNT INVESTED IN THE BUSINESS BY THE OWNERS
13	RETAINED EARNINGS	NEG	BS	FIN	AMOUNT OF PROFIT/LOSS FROM PRIOR YEARS RETAINED IN THE BUSINESS (NOT DISTRIBUTED)
14	SALES	NEG	PROF	OPS	MONEY BILLED TO CUSTOMERS FROM WHATEVER TO SELL OR SERVICES YOU PROVIDE
15	COGS	POS	PROF	OPS	COST OF THE PRODUCTS YOU SELL
16	SALARIES	POS	PROF	OPS	SALARIES YOU PAY TO EMPLOYEES
17	DEPRECIATION PROVISION	POS	PROF	OPS	PROVISION AMOUNT TO RECORD USE OR LOST VALUE OF EQUIPMENT
18	SUPPLIES	POS	PROF	OPS	COST OF SUPPLIES USED BY BUSINESS
19	RENT	POS	PROF	OPS	RENT COST FOR YOU SPACE TO RUN YOUR BUSINESS
20	INCOME TAX PROVISION	POS	PROF	OPS	PROVISION FOR THE INCOME TAXES YOU WILL PAY TO GOVERNMENT
21
22
23
24
25	TIME PERIODS
26	JAN
27	FEB
28	MAR
29	APR
30	MAY
31	JUN
32	JUL
33	AUG
34	SEP
35	OCT
36	NOV
37	DEC
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
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