Check and deposit register template

The template enables you to make an electronic checkbook register in MS excel to record your checking account activities and account balance. It could be a convenient resource for you to keep proper track of activities and transactions made via personal or professional bank account. Checkbook register is a handful accounting tool that allows a user to have a complete summary of all account transactions and entries in an organized manner for record keeping purposes.

A user of the excel checkbook register only need to record all withdrawals, deposits and other account entries in the checkbook and available current balance will automatically be calculated due to formulas added in the template. Checkbook register provides its users variety of different benefits and advantages.

This information can be customized depending on your own personal account and preferences. The spending summary pane automatically generates the data from your check register table. This pane shows the spending summary per category, which includes Deposit, Groceries, Entertainment, School, Utilities, etc.

This is useful when balancing your checkbook and comparing it to your latest statement. To make entering transactions faster, we have created an Excel drop down list for the Date column so that you can select the current date. The drop-down list for the Num field will show you the next check number and other options.

You can customize this list in the new Settings worksheet. We have included a list of categories from our money management template that you can edit within the Settings worksheet.

A user also requested we add a customizable Payee list, so we've done that as well. You can edit Payees that show up in the drop-down by editing the list in the Settings worksheet. Note: You do not have to use the values in these drop-down lists. They are just for convenience. You can still add a unique value by typing it. To: End date. In addition to the above, it consists of the summary section. It displays all balances automatically as it contains predefined formulas.

Opening Balance: This will reflect the opening balance from the Balance section. Closing Balance: This will reflect the closing balance from the Balance section. Reconciliation Amount: This will reflect the opening balance from the Balance section.

If the reconciliation of any entry pending, this section will display it in the outstanding column. Current Balance: This cell will display the ending Balance of account as per the data entered by the user.

Difference: This cell displays the difference if any. In this section, the user needs to enter the transaction details as and when they occur during the period. You can select the type of transaction from the drop-down menu. Balance: Balance will show you the balance after each transaction by adding or deducting the deposits and withdrawals. Balance and Outstanding: No entries are to be made. These cells are given predefined formulas. The balance column shows the end balance and the Outstanding column shows the non-reconciled entries.

Click here to download the Printable version of the Checkbook Register.