Free checkbook ledger template

A simple check book register is very useful for keeping track of your account balances for your home business or personal finances. If you'd like a budget-friendly solution, try our free check register template below. It can also be used as an account register for savings accounts and credit card accounts. You can track multiple accounts by making a copy of the Register worksheet.

I moved away from relying on the hand-written check register a long time ago, because of debit and credit cards. I have never liked the idea of somebody being able to see all of my transactions if I happen to lose my checkbook. Instead, I keep track of my account balances and transactions using Excel. License : Private Use not for distribution or resale. We've updated the new checkbook register template to make it even easier to work with, especially in Excel for iPad.

Here are the new features:. In addition to displaying the current balance of your checking account, we've included a "Cleared" balance total.

This is the balance for all transactions marked with an "R" or "c" in the reconcile R column. 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. Fillable Printable Check Register Form 3. Printable Check Register Form Sample 4. Sample Printable Check Register Form 7. Save and Store the Finished Form Step 5.

Compare it with your Bank Statement more. Checks are used in this period due to the dangers and perils —robberies and muggings — that come with the journey that early merchants and pilgrims take, which makes carrying gold in bulk an absolute inconvenience.

Whenever checks are used as payment, such a transaction is then registered in a journal called a Check Register or a checkbook ledger accounts.

These journals register, not just the amount of the transaction itself, but also the names, dates, and places where the transaction was made. Journalizing or registering is an activity of registering transactions and events. This was done to remind us of when, where, and who was involved in such an event or transaction. One of the commercial transactions that are journalized are cash transactions, which are a common occurrence. The journalized transactions are entered in a type of ledger account called a Check Register or a checkbook ledger.

Check Registers or checkbook ledgers are where cash transactions such as payments and purchases are registered, and, is a part of the general journal or ledger. When it comes to checks, we usually think of big commercial transactions. On a personal level, checks can also be used in transactions such as payments and purchases — groceries, utility bills , and rent — and can, absolutely, be used by anyone with checking accounts in their banks.

As mentioned, checks are useful when transactions involve massive amounts. And because of that, we find keeping track of our sales relatively important and often trust our banks to do that for us. However, trusting your bank to track your transactions are not without its dangers as most bank statements are sometimes not up to date.

Thus, it is crucial that we also take it upon ourselves to track our transactions and check it against our bank statements for correctness and accuracy. The best way to keep track of our transactions is to record them on a printable check register form.