ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
📋 TRIAL BALANCE — DATA ENTRY
2
Enter account balances here. Balance Sheet auto-updates.
3
AccountDebit ($)Credit ($)Type
4
── ASSETS ──
5
Cash on Hand / Bank $ 13,000.00 Current Asset
6
Accounts Receivable $ - Current Asset
7
Inventory / Supplies $ 3,500.00 Current Asset
8
Prepaid Expenses $ - Current Asset
9
Equipment $ - Fixed Asset
10
Vehicles $ - Fixed Asset
11
Other Fixed Assets $ - Fixed Asset
12
── LIABILITIES ──
13
Accounts Payable $ 3,500.00 Current Liability
14
Taxes Payable $ - Current Liability
15
Short-Term Loans $ - Current Liability
16
Long-Term Loans $ - Long-Term Liability
17
── EQUITY ──
18
Owner's Capital $ 20,000.00 Equity
19
Net Income / (Loss) $ 10,500.00 Equity Adjustment
20
Owner's Drawings $ - Equity Adjustment
21
TOTALS $ 27,000.00 $ 23,500.00 ← Must match ↑
22
Trial Balance Check (Debit − Credit): $ 3,500.00
23
24
💡 Blue = input cells. Enter amounts as positive numbers. Net Loss goes in Debit column. Net Income goes in Credit column.
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