Trial balance template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Trial balance upload
2
3	Instructions
4	Account Type must be one of: - Assets: "Bank", "Fixed Asset", "Current Asset", "Other Asset" - Liabilities: "Credit Card", "Current Liability", "Other Liability" - Equity: "Equity" - Revenue: "Income", "Other Income" - Expenses: "Expense", "Cost of Sales" "Account Name" must be unique "Account Code" is optional and can be text, number or mixed NB: - The balances must SUM TO NIL for each period - The months must be contiguous (you can't skip months!) - Dates must be FIRST of the month, eg 1 May 2024
5			Balance checks	0	0	0	0	0	0	0	0	0	0
6
7	Account Type	Account Name	Account Code	1/10/2023	1/11/2023	1/12/2023
8	Bank	MyBank	Bank	0	0	0
9	Fixed Asset	Buildings	740	100	100	100
10	Current Asset	Inventory	630	250	250	250
11	Other Asset	Other	699	100	100	100
12	Credit Card	HSBC Card	899	-500	-500	-500
13	Current Liability	Salaries Owed	814	-400	-400	-400
14	Other Liability	Loan	900	0	0	0
15	Equity	Retained Earning	960	50	50	50
16	Income	Bookkeeping	200	-200	-200	-200
17	Other Income	Statutory	210	-50	-50	-50
18	Cost of Sales	Cost of goods	310	600	600	600
19	Expense	Entertaining	420	50	50	50
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
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