Bank Ledger Template

Presenting statistical information in financial statements of the company is now possible with bank ledger template excel. It acts as a rulebook that is utilized to record exchanges.

Company organization and accounting is affected by the records, therefore, ledgers are becoming important than ever!  As a matter of fact, all of the company account information is available at single place with help of this excel spreadsheet.

Keeping up a ledger template is urgent for evaluating remaining balance, project budgets, under an overbalance in the certain accounts and for quick preparation of trial balance. It additionally keeps helps you and showing additional ways of managing money. There are uncommon events when the balance differs in the balance sheet and trial balance, how to fix it?

Bank Ledger Template Template Name:- Ledger Account

Template Size/Format:- 54KB XLSX

Format of Bank Ledger Template Excel

You can now keep track of the personal and business expenses and track all the expenses by downloading this sheet. Let’s have a look at its format:

Column 1

Before filling up the template, start by putting some of your company information on the top. Enter your company logo and the company name.

 Date  Account  Debit/Credit  Balance
1/13/2018 Payment From IBF 5000/5000 0
21/4/2018 Payment From URF 2890/3000 110
  • Each of the minor or major transaction in your company is given a specific number. Start by hitting the number in column 1.

Column 2

  • Check out when a certain transaction is made by filling up this column. It required you to add the date of the transaction.

Column 3

What type of expense is this? Enter the description of the expense in column 3 consisting of description.

Column 4

If the certain transaction results in withdrawal of amount, enter the amount here. Don’t forget to check the amount twice to prevent any error.

Column 5

What is the effect of the transaction? If it results in adding money to your bank account enter the amount in this section of the template.

General Ledger Reconciliation Template Excel

For more sample about bank ledger template excel, just contact Accounting124.com team and download your desired template according to your financial plan.

About The Author

Leave a Reply

Your email address will not be published. Required fields are marked *