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.