Excel Checkbook Register
If you are looking for a quick and reliable solution for tracking expenses, recording transactions or simply for managing your personal or home business finances, our check book register can be of help. Although the spreadsheet is pretty simple, it includes a columns for recording and categorizing expenses, recording the type of transaction from drop down menu that includes a list of customizable transactions, more over the formula used to calculate Balance and other formulas for the Reconciliation Data column makes it easy to add or delete rows.
Free Check Book Register
for Excel®, OpenOffice & Google Docs
This template is a simple check register spreadsheet for Excel, OpenOffice and Google Docs. It can be used for keeping track of a single or multiple accounts such as checking account, credit card account, savings account or loan accounts (yes loan accounts too), pretty much any account that has money inflows and outflows by making a copy of the Book Register worksheet.
by Alex Bejanishvili of Spreadsheet123.com
ECT 1.01
Requirements
Microsoft Excel® 2002(XP) or Later
License
User License Agreement
Help & Questions?
Contact Us
Using Check Book Register
Use white cells in "ENTRIES" section to enter your financial data into this worksheet. Register worksheet already contains few transactions entered as an example, which you can simply delete, before entering your own transactions. This template includes couple of different customizable transaction types, to use when logging transactions.
Using register worksheet with different accounts
The spreadsheet can be used for tracking various accounts, for instance if the account you're dealing with uses credits and debits, or deposits and withdrawals (which in fact is pretty much every account known to man), then this spreadsheet can be used to track it.
Tracking Cash and Checking Account: Using checkbook register to track your cash spendings and spendings off your checking account is pretty simple, enter the balance of any cash held and balance of your checking account at the beginning of a period, record any transaction as they occur, at last before reconciling your checkbook enter your final cash and bank account balance. Remember that your final balance should be 0 if your checkbook is accurately reconciled.
Credit Card Accounts: The spreadsheet can be used for tracking credit-card accounts, where purchases and any spendings off the account including interest charges and fees recorded as debits, as would. Payments are entered as credits.
Tracking Loan Accounts: Although the template won't compute any interest rate, charges or anything close to it, checkbook register template can still be used to track your loan account, where interest charges and fees are recorded as debits when loan payments are entered as credits.
Just a thing to remember when tracking your credit card or loan accounts, you'll not be able to balance your checkbook to 0 unless your outstanding account balance is paid in full.
Why Should I Balance my Checkbook?
It may seem like a tedious task to balance your checkbook, but it's an absolute necessary element of managing your money wisely.
Here are a few reasons why you should know how to manage a checkbook:
- To track your income and expenses.
- To cross-check your calculations with the bank statement to see if they made a mistake.
- To track your cash spendings.
- To check if there is an error in your checkbook register.
- To know exactly where to look if you have to recheck your records.
- To keep track of the current balance in one or several accounts.
When you need more than Excel Checkbook ...
The Checkbook Register provides a very simple way to track your income and expenses, but if you need something more for instance the spreadsheet that can help to categorize your income and expenses and create a budget, then you might want to try using our budget spreadsheets, designed specifically for this purpose.
More Budget Spreadsheets
- Family Budget Planner A Yearly version that does offer more than just budget planning.
- Monthly Budget The monthly version of the above spreadsheet.
- Household Budget (monthly) Includes additional categories.
- Budget Worksheet Yearly budget worksheet for home budgeting.
Professional Budgeting Software
- You Need a Budget Professional budgeting software when you need more than Excel.
- Clear Checkbook Offers professional money management applications for your mobile devices, with some very nice features.
Share Our Check Book Register
If you run a website or blog related to Excel, Household, Family or Personal Budgeting please link to this page to share it with others on your blog, website, Facebook or Twitter, please use the HTML code below.
Disclaimer - The spreadsheet and information on this page is intended for educational an illustrative purposes only. Use information at your own risk. It is strongly advised to consult the qualified professionals regarding financial decisions.
