Skip to content
Tutorials Center
My learning

Topics

Lesson 32 of 38 ยท Reports and Banking

Bank Reconciliation, Cheque Printing and PDC in Tally Prime

Reconcile bank ledgers with statements in Tally Prime, import bank statements, print cheques, track post-dated cheques and fix common differences, with stand-ins.

Your bank ledger in Tally and the bank's own statement should tell the same story, yet they rarely match at first sight. Cheques are issued but not yet cleared, charges appear that you have not recorded, deposits land a day late. Bank reconciliation is the routine of matching the two and explaining every difference. Tally Prime has a dedicated screen for it, plus tools for cheque printing and post-dated cheques.

Tally is not runnable on this site, so the screens are described and Python stand-ins show the matching logic. All figures are invented.

Why books and statement differ

Reason Effect
Cheque issued, not yet presented Books show payment; bank does not
Cheque deposited, not yet cleared Books show receipt; bank does not
Bank charges, interest, direct debits Bank shows it; books may not
Errors in entry Either side

The goal: balance as per books adjusted for the uncleared items equals balance as per bank.

The Bank Reconciliation screen

  1. Make sure the bank ledger is under Bank Accounts and Maintain balances bill-by-bill is not needed, but Set cheque books / Enable cheque printing is optional.
  2. For each payment or receipt, enter the instrument details in the voucher (instrument number, date, bank name).
  3. Open Gateway of Tally > Banking > Reconciliation (older releases: Display More Reports > Account Books > Bank Reconciliation). Pick the bank ledger and period.
  4. The screen lists all transactions not yet reconciled. For each, enter the bank date (the date it appeared on the statement), or use Auto reconciliation. When you set a bank date, the entry is reconciled.
  5. The Reconciliation Summary at the bottom shows: balance as per books, amount not reflected in bank and balance as per bank.

Press Enter on a line to edit; Alt+U-style shortcuts for Unreconcile may differ by release. Entries with a bank date are reconciled; those without are "pending".

Python Stand-in: reconcile a bank ledger with a statement

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.

The printed expected bank balance is 52250.0 (52,000 - 5,500 + 6,000 - 250).

The bank charge is an item you have not recorded, so also post it in Tally with a Payment (or Journal) voucher to the Bank Charges ledger, and your books move to their correct balance.

Auto-reconciliation by importing a statement

Tally Prime can import a bank statement (Excel or CSV) from Banking > Auto Reconciliation: you pick the file, Tally maps columns for date, description, debit and credit, and matches by amount and cheque number. Matched lines are reconciled; unmatched ones are shown for you to create vouchers (for charges, interest) or investigate. In some releases you can create vouchers directly from the imported lines.

Python Stand-in: auto-match books and statement by amount and date window

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.

Cheque printing

Enable Use cheque printing in the bank ledger (Alter > Ledger > Bank account) and configure the cheque book (Set/alter cheque book: instrument range, cheque layout). In a payment voucher, after saving, press Alt+P (Print) and choose Cheque to print on your bank's format. Tally supports multiple cheque layouts and printing on cheque stationery; adjust the template positions once for each bank.

Post-dated cheques (PDC)

A post-dated cheque is accepted now but valid on a later date. Do not record it as a receipt immediately. In Tally Prime you can enter the voucher with the instrument date in the future (it is a bank allocation detail), then view Post-dated Vouchers (Display More Reports > Account Books > Post-dated Vouchers). When the date arrives the entry is treated as effective. Some businesses enter PDC as optional vouchers until the date.

Other banking tools

  • Contra (F4) for cash deposits and withdrawals and for transfers between banks.
  • Deposit slips printed from the receipt voucher or a dedicated Deposit Slip report.
  • Bank payment advice exports and e-payments in some releases.
  • Banking > Payment/Receipt advice for bulk e-payments, depending on integration.

Common mistakes

  1. Marking entries reconciled by the book date instead of the bank date, which hides timing differences.
  2. Not recording bank charges and interest, so reconciliation never ends.
  3. Entering a PDC as a regular receipt, overstating bank balance until the cheque clears.
  4. Reusing cheque numbers, which makes statement matching ambiguous.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which is a common reason for a difference between the bank statement and the bank ledger?

    Timing differences such as uncleared cheques are the most common reason.
  2. 2. Books balance 52,000. Uncleared cheques issued: 5,500. Uncleared deposits 6,000. No other items. Bank balance is:

    52,000 - 5,500 + 6,000 = 52,500.
  3. 3. When reconciling, you set the:

    The bank date marks when the bank actually cleared the entry.
  4. 4. How should a post-dated cheque be treated?

    A PDC is effective only from its date and is tracked in the post-dated vouchers report.

Summary

  • Reconciliation proves that the bank ledger and the statement agree after explaining every difference.
  • Enter bank dates in the Reconciliation screen, or import a statement for auto-matching.
  • Record bank charges and interest in the books promptly.
  • Print cheques from the payment voucher after configuring a cheque book.
  • Track post-dated cheques separately until their date.

Next: TDS and TCS in Tally Prime