Feel free to make a copy of this check register and customize it as you see fit. Do not request for permission to edit, simply go to File > Make a copy.
Creating a check register in Google Sheets allows you to track your checks, deposits, and current balance in a simple and organized manner. Here's how you can do it:
In the first row, type the following column headers, each in a separate cell starting from A1:
A1: Date
B1: Check Number (Optional, can be skipped if not needed)
C1: Description
D1: Withdrawal/Debit
E1: Deposit/Credit
F1: Balance
Tip: Use the toolbar to customize your headers.
Click on the column letters to highlight entire columns. Go to Format > Number.
For Date (A), choose the "Date" format.
For Withdrawal/Debit (D), Deposit/Credit (E), and Balance (F), you can choose the "Currency" format.
In F2, enter your starting balance. For example, if your account starts with $1,000, type "1000" (without quotes) and press Enter.
Input the date and label this Starting Balance in C2. You can highlight this row to make it stand out from the rest using the Fill color tool.
Click on cell F3.
Enter the formula to calculate the balance after each transaction. Assuming your starting balance is in F2, the formula should look like this: =F2+E3-D3.
Press Enter to apply the formula.
Click on F3 where you just entered the formula. Click on the small blue circle at the bottom-right corner of the cell. Drag this down as many rows as you think you'll need. The formula will automatically adjust for each row, calculating the new balance after each transaction.
Start entering your transactions row by row:
The balance will update automatically based on your inputs.
Below are some sample values:
Google Sheets automatically saves your work, but make sure to revisit and update your check register regularly with new transactions.
We hope that this article has helped you and given you a better understanding of how to make a check register in Google Sheets. If you enjoyed this article, you might also like our articles on what to do if Google Sheets is unable to load a file and how to use the GROWTH formula in Google Sheets.
