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 Set Intervals on Excel Charts (2 Suitable Examples)
- How to Remove Last Modified By in Excel (3 Ways)
- If a Value Lies Between Two Numbers Then Return Expected Output in Excel
- How to Move Up and Down in Excel (5 Easy Methods)
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.
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.
- How to Add Trailing Zeros in Excel (2 Easy Ways)
- Calculate WACC in Excel (with Easy Steps)
- How to Make a Box Plot in Excel (With Easy Steps)
- Make a Forest Plot in Excel (2 Suitable Examples)
- How to Calculate Cost of Funds in Excel (with Easy Steps)
- Make Sankey Diagram in Excel (with Detailed Steps)
- How to Calculate APR in Excel (3 Simple Methods)
- Make a Venn Diagram in Excel (3 Easy Ways)