Free Check Register Template for Google Sheets (2024 Update)

Google Sheets Check Register Template

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.

How to Make a Check Register in Google Sheets

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: 

Step 1: Create Your Columns

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. 

Step 2: Format Your Columns

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.

Step 3: Enter the Starting Balance

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. 

Step 4: Create the Balance Formula

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.

Step 5: Drag the Formula Down

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.

Step 6: Input Your Transactions

Start entering your transactions row by row:

• Date when the transaction occurred.
• Check Number if it's a check transaction.
• Description of the transaction.
• Withdrawal/Debit amount for money going out.
• Deposit/Credit amount for money coming in.

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.