How to Create a Bank Ledger

Save

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.

References

Promoted By Zergnet

Comments

Resources

You May Also Like

  • How to Use Excel for Accounts

    You can use Excel to track information for accounts. If you are running a small business and only need to keep track...

  • How to Create a General Ledger

    A general ledger is a file or book in which a business records all of its financial transactions. At the start of...

  • Excel Checking Reconciliation

    Microsoft Excel allows individuals and companies the ability to reconcile debit and credit transactions with spreadsheets. Use Excel spreadsheets to keep track...

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!