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.

Instructions

1

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.

2

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.

3

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.