Examples for business, study, careers, love, and more...
Examples :: Excel Templates :: Check Book Register Excel Template

Check Book Register Excel Template

Download Excel Version of Check book register example
Checkbook Register Name____________________________
Opening Balance: $10,000.00 Account Number____________________________

Date Check
Number
Payee Name Transaction
Description
Withdrawals
Payments
Debits (-)
Deposits
Credits (+)
Balance Reconciled
01/24/2010 160 First Mutual Mortgage Company Home Mortgage Payment $1,500.00 $8,500.00 Yes
02/02/2010 161 Local Power and Light Company Power Bill $150.00 $8,350.00 Yes
02/12/2010 Rose's Floral Shop Employer, Paycheck $1,000.00 $9,350.00
02/17/2010 162 Pizza Shop Pizza Delivery $24.67 $9,325.33
02/20/2010 Clothing Boutique Clothing Refund $100.00 $9,425.33


Notes on Check Book Register Template Example


To use this Example Checkbook Register simply fill in the information in the correct feilds.
Filling in your name and account number is optional, but a good way to keep multiple checking and savings accounts organized.
Opening Balance: Your current account balance.
The date the payment or deposit was made or the date the check was written.
Check Number: The check number.
Transaction Description: Briefly describe the transaction details.
Withdrawals, Payments, Debits (-): This column is for money spent from the account, any cash withdrawals, payments made, etc.
Deposits, Credits (+): This column is for money deposited into the account.
Balance: Displays the current balance of the account after each transaction.
Reconciled: Use this column to show that the transaction is correct and matches your bank statement.


  • To add additional rows, copy an empty existing row and paste below the last transaction.
  • All rows must be filled in, in order for the balance formula to work correctly,do not skip any rows between transactions.
  • If you need to completely delete a row, right click on the ROW NUMBER and choose "Delete Row".
  • Simply deleting the contents will delete all information including the balancing formula.


Download Excel Version of Check book register example
Disclaimer: Examplesof.com makes every effort to ensure the functional integrity of all downloadable materials posted on the site. The information, methodologies and processes contained in these materials are provided according to built-in software and formulas. We are unable to guarantee that these materials will necessarily be suitable for individual purposes. We are unable to guarantee that these materials will necessarily be free of functional issues which may affect their performance. Important: These materials are offered for purchase and use in good faith in "as is" condition. Full disclaimer is here disclaimer

End User License Agreement

Limited Use Policy

These templates provided by ExamplesOf.com, may be downloaded and customized for your personal or company use only. You may download copies, make archival copies and customize the template to be distributed and used within your company. This template or any document produced from this template may NOT be sold, redistributed, or uploaded to the internet for distribution.

DO not remove, replace or alter any logo, copyright information, trademark, disclaimer or Terms of Use from this template.