Skip to content
Tutorials Center
My learning

Topics

Lesson 13 of 38 ยท Masters and Ledgers

Opening Balances and the Trial Balance

Enter opening balances correctly in Tally Prime, understand the Difference in Opening Balances suspense line, and verify your setup with the trial balance.

If you start Tally in the middle of a business's life, the books do not begin at zero: there is cash in the till, money in the bank, customers who owe you and suppliers you owe. These balances on the books beginning date are the opening balances. Getting them right is the foundation for everything that follows, and the trial balance is how you prove that you did.

Where opening balances come from

Gather them from the last closed books: the previous year's balance sheet and trial balance, or, if the business is new, from a list of what the owner put in and any assets and loans on day one. You need:

  • Cash and bank balances (bank balances from the bank book, not the passbook, if they differ).
  • Each customer's balance and each supplier's balance, split into pending bills if you use bill-wise tracking.
  • Fixed assets at their written-down values, loans, capital and reserves.
  • Opening stock (for inventory companies, entered on stock items, covered in the inventory chapter).
  • Accumulated profit or loss, which belongs in the Profit & Loss A/c ledger or in reserves.

Entering them

You can enter an opening balance in two places:

  1. When creating or altering a ledger: the Opening Balance field takes an amount with Dr or Cr. Tally shows the sign you should expect for the group.
  2. In bill-wise details: for debtors and creditors with bill-wise tracking, accepting the opening balance opens a list where you enter each pending bill (name, date, credit period, amount). The bills must add up to the balance.

Assets and expenses normally carry Dr balances, and liabilities, capital and incomes carry Cr balances. Opening balances on income and expense ledgers are only meaningful when the books begin mid-year, because they represent the year-to-date position.

The balancing rule and the suspense line

Because of double entry, the total of all opening debit balances must equal the total of all opening credit balances. If they do not, Tally does not stop you. It adds a balancing line called Difference in Opening Balances to the Balance Sheet, which shows the gap (debit or credit). This line is a warning sign: the opening position is incomplete or wrong. Your job is to find the missing ledger, correct a sign, or fix a typo until the difference disappears.

Never leave a Difference in Opening Balances in the books "to sort out later". It flows into every period's balance sheet and makes the figures untrustworthy.

flowchart TD
    A["Enter all opening balances"] --> B["Open Balance Sheet"]
    B --> C{"Difference in Opening Balances?"}
    C -- "None" --> D["Start vouchers"]
    C -- "Yes" --> E["Find missing or wrong ledger"]
    E --> B

Check the balance sheet right after setting up; fix any difference before the first voucher.

Verifying with the trial balance

Open Gateway, Reports, Display More Reports, Trial Balance (or Go To, "trial balance"). It lists every ledger group with its debit and credit balances. For the opening position you want:

  • Total debit = total credit.
  • No unexpected balances: a customer with a credit balance, a bank with an overdraft you do not have, a negative cash balance.
  • Closing stock equals the opening stock you entered.

Press Enter on a group to open its ledgers, and on a ledger to see its vouchers. Because the opening balances have no vouchers, drill-down shows the opening line only.

Opening balance steps

Gather Last year's closing figures.
Enter On each ledger, Dr or Cr.
Bills List pending bills.
Check Trial balance must agree.
1 / 2

Common causes of a difference

  1. A forgotten ledger: the sum of what you entered is simply incomplete.
  2. A Dr/Cr slip: a creditor entered as debit changes the totals by twice the amount, which is a handy clue. If the difference is exactly twice some ledger's balance, check that ledger's side.
  3. A transposed number: 4,590 typed as 4,950 differs by 360, a multiple of 9. A difference divisible by 9 suggests a transposition.
  4. Bills not matching: bill-wise details that do not add up to the ledger.
  5. Stock or profit omitted: opening stock or accumulated profit missing from the list.

A stand-in: opening trial balance with difference

This stand-in lists opening balances, calculates the difference and prints it as Tally's Balance Sheet would show it.

Python Opening balances and the difference line (stand-in)

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

With these figures you will see a difference of 12,000. Add a missing 12,000 credit (for example an unpaid expense) or correct an amount and run it again until it balances.

A stand-in: diagnosing the difference

This stand-in applies the clues from above to suggest what might be wrong: twice a balance (wrong side), divisible by 9 (transposition) or equal to a ledger (missing).

Python Suggest causes for a difference (stand-in)

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Common mistakes

  • Entering opening balances as vouchers. Use the ledger opening balance (or bills); do not post fake journal entries.
  • Wrong date. Opening balances belong to the books beginning date; changing it later shifts all of them.
  • Using the passbook balance for bank. Use the book balance and list unreconciled items.
  • Skipping bills for debtors and creditors. Without bills, bill-wise tracking cannot start.
  • Ignoring the difference line. Fix it first.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What does the 'Difference in Opening Balances' line mean?

    Tally balances the books with a suspense line and shows the gap so you can find the error.
  2. 2. A ledger is entered on the wrong side, and the difference is 60,000. What balance might that ledger have?

    Putting an amount on the wrong side changes the difference by twice that amount.
  3. 3. For a debtor with bill-wise tracking, what must the pending bills total?

    The list of bills explains the whole opening balance.
  4. 4. Which report do you use to check the opening position?

    The trial balance shows all ledger balances with debit and credit totals.

Summary

  • Opening balances come from the last closed books and are entered on ledgers (and bills) as at the books beginning date.
  • Total debits must equal total credits; otherwise Tally shows Difference in Opening Balances.
  • Use the trial balance to verify; hunt down missing ledgers, wrong sides and transpositions.
  • Fix the difference before entering the first voucher.

Next: Voucher Types and Voucher Entry