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.

Table of Contents hide

Download Practice Workbook

2 Steps to Make Trial Balance in Excel

Step-01: Making Ledger

Step-02: Preparing Trial Balance

Things to Remember

Conclusion

Download Practice Workbook

Making Trial Balance.xlsx

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.

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.

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.

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.

Conclusion

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.