ABCDEFGHIJKLMNOPQRST
1
2
3
BANK ACCOUNT LEDGER
4
5
Want to keep track of your checking account without purchasing separate software? This spreadsheet gives you a template for tracking your bank account transactions, and it automatically calculates the current balance after you enter each transaction.
6
7
GET STARTED:
8
9
Click on the tab (below) labeled "TEMPLATE: Bank Ledger". Click on the tab again, and a menu will appear. Click "Duplicate" from the menu. To rename the tab, click the tab name again and click "Rename" from the menu.
10
11
This template is set up by default to calculate the current balance using a formula. When you clear out the sample data, do not clear out the cells in gray, which contain that formula.
12
13
Be sure to enter your beginning balance in the yellow highlighted cell.
14
15
Enter negative values for withdrawals and checks, and positive values for deposits. Negative values will show up as red text.
16
17
18
19
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