How to Make Trial Balance in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for how to make Trial Balance in Excel, then you are in the right place. In our practical life we often need to make trial balance to get a legit statement of the financial state of our companies. If we do it in Excel it becomes easier. In this article we’ll try to discuss trial balance and how to make trial balance in Excel.

Download Practice Workbook

2 Steps to Make Trial Balance in Excel

We need to first understand what Ledger and Trial balance are. Both of these things have significant use in accounting and have use in Excel.

Step-01: Making Ledger

Basically, an accounting ledger is an account or record which we use to store bookkeeping entries for balance-sheet and income-statement. Accounting ledger journal entries can include accounts like cash, accounts receivable, investments, inventory, accounts payable, accrued expenses, customer deposits, etc.
Eventually, we made a dataset of an arbitrary Ledger named Making Ledger. It has column headers as SL No., Particulars and Amount. Here, we have included all the financial statements of a company. It covers almost all of the included topics of the ledger. The dataset is like this.

how to make trial balance in excel

Read More: How to Make Flashcards in Excel (2 Suitable Ways)

Similar Readings

Step-02: Preparing Trial Balance

Eventually, after making a ledger the next step is Preparing a Trial Balance.
Firstly, we need to know about Trial Balance. Mainly, Trial Balance shows the information on each ledger balance in a tabular style. Every organization must assess its financial condition over a specific time period, thus it includes transactions made during the year as well as the opening and closing balances of ledgers. The Trial Balance aids in analyzing the position and transactions made during such a time period. Importantly, we do this with trial balances by listing all the accounts with both debit and credit balances in one location.
Generally, the trial balance has three columns. One is the Ledger column. The other two are the Debit and Credit columns. We have made the Trial Balance with a column header Preparing Trial Balance. Here, some of the particulars in Ledger are Debit Balance and the others are Credit Balance. The Trial Balance is like this.

preparing trial balance

Finally, we can see from the trial balance that the individual Total Debit Balance and Credit Balance are equal i.e. our Trial Balance is correct.

Read More: How to Create Money Management Excel Sheet for Trading

Things to Remember

The total Debit Balance and Credit Balance in the Trial Balance should be equal. If it is not then there might be some calculation mistake while preparing it.


We can make Trial Balance very easily if we study this article properly. Please feel free to visit our official Excel learning platform ExcelDemy for further queries.

Related Articles

Shajratul Alam Towhid

Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF