Trial balance format generator

Last reviewed: October 2026

What a trial balance is, and why it is prepared

In double-entry bookkeeping every transaction is recorded with equal debits and credits. So when every ledger account is balanced and the balances are listed, the debit balances must add up to the credit balances. That list is the trial balance. It is prepared on a date ("as on 31 March 2026"), at least at year end, and many businesses take one every month.

• Arithmetic check. Equal totals show that the postings and balancing were done without arithmetic errors of the kinds a trial balance can detect.
• Summary of the books. One page shows every ledger balance: what is owed, what is owing, income and expenses so far.
• Base for the final accounts. The trading account, profit and loss account and balance sheet are prepared from it.
• Audit and review. Auditors start from the trial balance; banks sometimes ask for it with provisional figures.

A trial balance is a working paper, not a financial statement. No law prescribes its format, and it is not filed anywhere. What the law does require is the books behind it: section 128 of the Companies Act, 2013 requires companies to keep books on the accrual basis and the double-entry system, and most businesses of any size keep books the same way.

How to prepare a trial balance with this generator

1. Enter the business and dateType the "Business name" and choose the "Trial balance as on" date, usually 31 March.
2. Add one row per ledgerFor each ledger enter the "Ledger account", pick its "Group" (Tally-style groups such as Capital account, Sundry debtors, Duties and taxes, Sales accounts or Indirect expenses), and type its balance in "Debit" or "Credit". "Load example" fills in Mehta Traders.
3. Check the totals and the "Difference"The totals update as you type. If a "Difference" shows, use the hints next to it: a difference divisible by 9 suggests a transposition, half the difference may be a balance on the wrong side, and a ledger equal to the difference may be missing.
4. Add closing stock and read the final accountsEnter the "Closing stock" valued at the year end. "Final accounts from this trial balance" then shows the trading account, the profit and loss account and a horizontal balance sheet built from the groups.
5. Download, print or export"Download PDF" is free and carries a small LuckPanda footer, "Print" prints the A4 page, and "Download CSV" opens in Excel.
6. Keep it live from your booksSign in free to LuckPanda Finance and the trial balance stays up to date from your journal (Finance › Reports), with each total opening to the ledger behind it.

Trial balance format

The heading names the business, the title and the date. The date matters: a trial balance is "as on" a date, not "for the year".

• S. No.: a running number.
• Name of ledger account: every ledger with a balance, including those with very small balances. Accounts that are nil are left out.
• L.F. (ledger folio): the page or account number in the ledger, so a reviewer can trace each figure. Software replaces it with a ledger code or a drill-down.
• Debit balance and credit balance: each ledger appears in one column only, the side its balance falls on.

Many accountants add a "Group" column (Capital account, Sundry debtors, Indirect expenses…) so the trial balance can be sorted into the final accounts. The generator on this page uses Tally-style groups for that.

Three methods of preparing it

Which side does each account go on?

A ledger's balance falls on its "normal" side unless something unusual has happened. Two ways to remember it:

Exceptions are worth noticing, because they are often errors: a credit balance in cash in hand is impossible; a credit balance in a bank account means an overdraft (a liability); a debit balance in a creditor's account means you paid in advance (an asset). The generator accepts either side for "Duties and taxes" and "Suspense", because a tax ledger can be a credit (tax payable) or a debit (input credit), and a suspense balance can fall on either side.

How to prepare a trial balance from the ledgers

1. Post every entryJournal and subsidiary books (sales, purchases, cash book) posted to the ledger up to the date of the trial balance.
2. Balance each ledger accountAdd both sides; the difference is the balance. A ledger with a bigger debit side has a debit balance ("balance c/d" on the credit side to make the sides equal).
3. List the balancesOne row per ledger, the balance in the debit or credit column. Take cash and bank balances from the cash book, and debtors and creditors from the party ledgers or their control accounts.
4. Total both columnsAdd the debit column and the credit column separately.
5. Compare the totalsIf they agree, the trial balance "tallies". If not, find the difference before going further (see below). Do not plug it into the capital account.
6. Note what sits outsideWrite closing stock and any adjustments (outstanding expenses, prepaid expenses, depreciation not yet charged) below the trial balance. They are dealt with in the final accounts.

Example of balancing one ledger: Mehta Traders' cash account received ₹14,62,000 during the year (debits, including the opening balance) and paid out ₹14,26,000 (credits). The difference, ₹36,000, is a debit balance: cash in hand, which is the figure that goes into the trial balance.

Trial balance format with example: Mehta Traders

Mehta Traders is a trading firm in Nagpur owned by Rohan Mehta. Its books for 2025-26 give the following ledger balances. These are the default figures in the generator; press "Load example" to see them.

Additional information: closing stock on 31 March 2026 was valued at ₹3,10,000. The totals agree at ₹43,50,000, so the books are arithmetically in order.

• Opening stock is inside the trial balance because it is the balance brought forward from last year. Closing stock is outside, because it is counted and valued at the year end and has not been entered in the books yet.
• Both GST ledgers are in "Duties and taxes": GST payable has a credit balance and input GST a debit balance. They are not netted, because the March return that sets one off against the other is filed in April.
• Depreciation of ₹60,000 has already been charged, so machinery and furniture are at their written-down values.

From trial balance to final accounts

Every ledger in the trial balance goes to exactly one place: the trading account (direct items), the profit and loss account (indirect items) or the balance sheet (assets, liabilities, capital). Closing stock, from outside the trial balance, goes to two: the credit side of the trading account and the assets in the balance sheet. In the generator, enter it in "Closing stock" and open "Final accounts from this trial balance".

Gross profit = ₹28,60,000 + ₹3,10,000 − (₹2,60,000 + ₹18,40,000 + ₹1,20,000 + ₹45,000) = ₹9,05,000, a gross margin of 31.6% on sales.

Net profit = ₹9,05,000 + ₹15,000 − (₹2,40,000 + ₹1,44,000 + ₹38,000 + ₹52,000 + ₹60,000) = ₹3,86,000, 13.5% of sales.

Both sides total ₹16,81,000. The generator places each balance-sheet ledger on the side of its balance, so input GST (a debit balance in Duties and taxes) shows under current assets, and GST payable (a credit balance) under current liabilities. For the vertical company format of the same statement, and the ICAI format that proprietors and firms move to from 2026-27, see the balance sheet format page.

Errors a trial balance reveals, and errors it does not

Equal totals only prove that debits equal credits. Errors that affect both sides equally, or neither side, leave the trial balance in agreement.

How to find the difference when the trial balance does not tally

Work through these checks in order. The generator shows the "Difference" and the same hints next to it.

1. Re-add both columnsMost differences are addition errors in the trial balance itself.
2. Look for a ledger equal to the differenceIf the difference is ₹36,000 and cash in hand is ₹36,000, the cash balance was probably left out.
3. Halve the differenceA balance written on the wrong side changes the difference by twice its amount. If Mehta's discount received of ₹15,000 were put in the debit column, debits would be ₹43,65,000 and credits ₹43,35,000: a difference of ₹30,000. Half of it, ₹15,000, points straight to the discount ledger.
4. Divide by 9A transposition (digits swapped) or a slide (a misplaced decimal or zero) always makes a difference divisible by 9. Rent of ₹1,44,000 written as ₹1,40,400 gives a difference of ₹3,600 = 9 × 400.
5. Check opening balancesCompare each opening balance with last year's balance sheet. A missing opening balance is a common cause in the first year on new software.
6. Check the subsidiary books and postingsRe-add the sales, purchase and cash books, and tick each posting to the ledger. Check the debtors and creditors schedules against their control accounts.

The suspense account

If the difference cannot be found before the accounts are needed, it is parked in a suspense account so the trial balance agrees, and each error is corrected (rectified) as it is found. Suppose Mehta's accountant could not find the ₹30,000 difference above. A suspense account with a credit balance of ₹30,000 makes both columns ₹43,65,000. When the error is found, the rectification entry is:

The suspense account is now nil. A suspense balance should never be left in final accounts if it can be avoided; an auditor will ask about it. In the generator, a ledger in the "Suspense" group is carried into the draft balance sheet, so that it is visible rather than hidden.

Unadjusted, adjusted and post-closing trial balance

Adjusted trial balance: a small example

Suppose that at year end Rohan Mehta finds March salaries of ₹20,000 still unpaid, and that ₹12,000 of the rent paid relates to April 2026. These adjustments are only for this illustration; the generator's example has none. The adjusting entries are:

Debits rise by ₹20,000 + ₹12,000 − ₹12,000 = ₹20,000 and credits by ₹20,000, so the adjusted trial balance agrees at ₹43,70,000. Net profit would fall to ₹3,86,000 − ₹20,000 + ₹12,000 = ₹3,78,000.

Post-closing trial balance

After the trading and profit and loss accounts are closed and the profit and drawings are transferred to capital, only the balance sheet accounts remain. Without the illustrative adjustments:

Its totals equal the balance sheet total, and these balances become the opening balances of 2026-27.

GST ledgers in the trial balance

• Output tax (output CGST, SGST, IGST) is a credit balance in Duties and taxes: tax collected on sales and owed to the government. Mehta Traders: ₹30,000.
• Input tax credit (input CGST, SGST, IGST) is a debit balance: tax paid on purchases that can be set off. Mehta Traders: ₹18,000. Credit that is blocked or ineligible should not sit here; it belongs in the cost of the purchase. See the input tax credit guide.
• Set-off happens in GSTR-3B, which for March is filed in April. After it, Mehta Traders would pay ₹30,000 − ₹18,000 = ₹12,000 in cash (assuming the credit matches its GSTR-2B and the heads allow the set-off).
• Sales and purchases are recorded net of GST when the credit is available, so GST never reaches the trading account. Use the GST calculator to split a GST-inclusive amount.
• TDS payable and other statutory dues are also credit balances in Duties and taxes.

Trial balance in Tally

• Open it: in TallyPrime, Gateway of Tally > Display More Reports > Trial Balance, or Alt+G (Go To) and type "Trial Balance".
• Groups or ledgers: it opens group-wise; press F5 (Ledger-wise) to list every ledger, and F5 again to go back. Alt+F5 shows the detailed format.
• Opening balances and movements: F12 (Configure) has options such as "Show Opening Balance", "Show Transactions" and "Nett Transactions".
• Closing stock is not shown in Tally's trial balance; it appears in the Balance Sheet and Profit & Loss A/c from the stock summary or a stock ledger.
• "Difference in opening balances" appears when the opening balances entered on ledgers do not agree. Correct the ledger's opening balance with Alt+G > Alter Master, checking it against last year's balance sheet.
• Export: press Alt+E (Export) to save the report as Excel.

Tally's group names (Capital Account, Sundry Creditors, Duties & Taxes, Direct Expenses, Indirect Incomes…) are the same kinds of groups this generator uses, so a ledger-wise Tally trial balance can be typed in row for row. LuckPanda does not import from or export to Tally.

Trial balance format in Excel

1. Columns: A S. No., B Ledger account, C Group, D Debit, E Credit. Enter each balance in one column only.
2. Totals: =SUM(D2:D23) and =SUM(E2:E23) under the last row.
3. Difference: =D24-E24, which must be 0.
4. A hint cell: =IF(D24=E24,"",IF(MOD(ABS(D24-E24),9)=0,"Divisible by 9: look for a transposition","Look for a missing ledger or a wrong side")) points you to the likely cause.
5. For the final accounts, add a column that says Trading, P&L or Balance sheet, and SUMIFS each statement from it.

"Download CSV" in the generator gives the same columns with your totals, ready to open in Excel; "Download PDF" gives a printable A4 of the trial balance and the final accounts.

Trial balance vs balance sheet

Common mistakes

• Forcing the totals by changing the capital figure or adding a balancing entry without a suspense account.
• Netting GST input and output before the return is filed, or leaving blocked credit in the input ledger.
• Including closing stock in the trial balance and again in the trading account.
• Listing debtors and creditors twice: once as the control account and again party by party.
• Putting drawings on the credit side or treating them as an expense. Drawings are a debit and reduce capital.
• Calling a tallied trial balance "correct". Check for omissions, wrong accounts and capital-revenue mix-ups.
• Carrying a suspense balance into the final accounts without explaining it.

Key terms

Trial balance

A list of all ledger balances on a date, in debit and credit columns, prepared to check that total debits equal total credits.

Ledger folio (L.F.)

The page or account number of a ledger, used to cross-reference entries.

Normal balance

The side on which an account's balance usually falls: debit for assets, expenses and drawings; credit for liabilities, capital and incomes.

Suspense account

A temporary account holding an unexplained trial balance difference until the errors are rectified.

Transposition error

Digits written in the wrong order, such as ₹1,44,000 as ₹1,40,400; the difference is always divisible by 9.

Compensating error

Two or more errors whose effects cancel out, so the trial balance still agrees.

Error of principle

Recording a transaction against accounting principles, such as treating a revenue expense as a capital asset.

Adjusting entry

A year-end entry for items not yet recorded, such as outstanding expenses, prepaid expenses, depreciation and closing stock.

Post-closing trial balance

A trial balance taken after closing entries, listing only balance sheet accounts.

Final accounts

The trading account, profit and loss account and balance sheet prepared from the trial balance.

Questions people ask