How to Create a Bank Ledger

A bank ledger is a running list of transactions to and from a bank account. It contains columns for the date, description, amount and leftover balance. The format is similar to a basic accounting ledger book. Your bank provides a ledger for you to read online or on your monthly printed statement. If you want to keep your own bank ledger you can do so with a financial or accounting software program.

Use Microsoft Excel to create a bank ledger. The basic format of an Excel worksheet (columns, rows and cells) is similar to the format of a bank ledger that you would see in your online account. You can assign a heading to each column to represent the details of each bank transaction. Excel also offers formatted ledger templates that you can download to the program for use.

Form your own bank ledgers using SpeedLedger. This tool is web-based — you must create an account and log in to create bookkeeping accounts and manage your ledgers in a security platform. It is designed specifically to help small businesses. Link the tool to your banks (including Internet-based banks) to see all various account ledgers in one location. Compile and print reports on your ledger activities.

Create a bank ledger with Medlin General Ledger. This bookkeeping software generates simple bank account ledgers that list as many fields as you need. It offers a convenient “point and click” format for accessing and editing each entry. Manage ledgers from different years or periods and print reports. Pull up the bank ledger, run a search for the contents and edit as needed.