How to Make a Bank Ledger in Excel (with Easy Steps)

A Bank Ledger is the bank account balance computed by a bank for each account every business day. It includes all kinds of deposits and withdrawals. In this tutorial, we’ll demonstrate how to easily create a Bank Ledger in Excel. We have used Microsoft Excel 365 for this article, but you can use any other version at your convenience.

⭐ Step 1 – Create an Outline

Create a space for Opening Balance in cell C4.
Make column headings for Date, Transaction Description, Cash Deposit, Cheque Deposit, Online Deposit, Cash Withdrawal, Cheque Return, and Balance like in the below screenshot.

⭐ Step 02 – Insert Necessary Data

The data we input here are opening balance, date, transaction description, cash deposit, cheque deposit, online deposit, cash withdrawal, and cheque return.

Insert the opening balance.
Insert the other data according to their date in the respective columns.

⭐ Step 03 – Using a Formula to Calculate Balance

Let’s use an Excel formula to calculate the balance after all the transactions for each date.

Select cell I8 and insert the following formula:

=$C$4+D8+E8+F8-G8-H8

Here, cells I8, D8, E8, F8, G8, and H8 are the first cells of the columns Balance, Cash Deposit, Cheque Deposit, Online Deposit, Cash Withdrawal, and Cheque Return respectively. Cell C4 indicates the Opening Balance.