Blog/Tally workflow
Two balances, one explainable difference

Your supplier statement and Tally balance don't agree.

Don't start by posting the difference. Start by finding the invoice, credit or payment that one side has and the other side doesn't.

₹1,000 is a difference, not an entry

In a fictional example, your ledger shows ₹28,000 payable. The supplier statement shows ₹29,000. Someone suggests a ₹1,000 adjustment to close the account. I would ask which document supports it before approving any entry.

The difference could be an unapplied credit. It could be a short payment the supplier disputes. Or one report could describe a different cutoff date. The same number can arise from different facts, and the correct response depends on those facts.

Statement reconciliation

Supplier statement reconciliation compares a supplier's account statement with your ledger over an agreed period. It explains missing invoices, credits, payments and allocations without treating every difference as a new transaction. The output is a document-linked exception list and resolved balance, not an unsupported balancing entry.

This is different from GSTR-2B reconciliation. A supplier statement describes an account relationship. It may contain payments and commercial adjustments that are not a list of invoices furnished on the GST portal.

It is also different from checking a single invoice against a PO. Those controls can supply evidence to this review, but the supplier's closing balance needs the full account story.

Agree on what the reports describe

Use the same account identity and cutoff date. Check whether the statement covers one GST registration or several, and whether your report covers the same supplier ledger. A shared trading name does not guarantee the same scope.

Keep the original statement file and your dated ledger export. If the supplier sends a revised version, retain the earlier copy with a note. A reconciliation should be reproducible from the versions actually compared.

Start with the opening balance. If it differs, isolate that difference before walking the new transactions. Otherwise an old unexplained amount follows every monthly close while the current month's rows appear to match.

Compare invoice numbers exactly, using supplier identity and date where needed. Prefixes, slashes and financial-year series matter. Do not assume invoice 84 belongs to the current year or to the supplier account you happen to have open.

The vendor master identity check is useful here. If two legal suppliers or registrations were merged under one ledger name, balance reconciliation will expose a master-data problem rather than a missing document.

Walk the fictional account

Our example starts at zero. A ₹59,000 invoice is recorded on both sides. Your records show a ₹30,000 payment and a supplier credit of ₹1,000, leaving ₹28,000. The statement recognises the payment but not the credit, so it shows ₹29,000.

Where the ₹1,000 difference livesFictional ledger bridge
YOUR LEDGER
₹59,000 − ₹30,000 − ₹1,000
₹28,000
Credit included
SUPPLIER STATEMENT
₹59,000 − ₹30,000
₹29,000
Credit not shown

Find the credit document and its acceptance. Do not post another ₹1,000 simply because that makes the balances agree.

First establish that the credit is genuine and belongs to this invoice or account. Then ask why it is absent from the statement. The supplier may have issued it after the cutoff, applied it to another account or not agreed it at all.

If your ledger entry reflects an expected credit rather than an issued one, the difference is not automatically the supplier's mistake. Return to the agreement and the accounting review. A tidy internal entry cannot establish an external settlement.

A payment difference needs a bank reference and remittance allocation. “Paid last week” does not prove which invoice was settled. One transfer can cover several bills; one bill can have several transfers.

For a withholding or other deduction, retain the appropriate supporting trail. Don't ask the supplier to guess why the remittance was lower. The TDS and GST discussion explains why separate tax tracks should not be collapsed into a vague discount label.

Build the worksheet, then chase from it

You can download the blank reconciliation worksheet. It contains headers only, with no supplier records or tax formulas. It is a working aid, not a connection to Tally or your bank.

For each unmatched item, record which side has it, the source reference and the next action. An owner and a review date make the item usable. Avoid a single comments column full of “follow up,” which gives nobody a document to find.

DifferenceEvidence to request
Invoice missing in your ledgerOriginal bill, receipt/approval trail and duplicate check
Credit missing on one sideIssued note, linked bill and agreed treatment
Payment not recognisedBank reference and remittance allocation
Opening balance differsPrior agreed statement and unresolved older items

An invoice on the supplier statement is not automatically authority to post it. Obtain the original, check whether it was already recorded under another reference and run the required approval process. The duplicate check still matters when you are trying to clear an exception.

A credit note is not a negative number with no story. Establish what it changes and how it affects the original supply. Our later discount guide separates a commercial settlement from a tax adjustment.

When an item resolves, note what changed and retain the evidence. “Closed” should mean the identified issue was settled, not that someone deleted it from the working file to make the count smaller.

Carry unresolved items honestly

Agree the resolved balance where possible and keep the remaining differences explicit. Some issues take longer than a month. A disputed invoice should carry forward with its identity and owner, not reappear as an unexplained opening-balance gap.

Do not silently net unrelated amounts. A supplier's credit for one legal entity may not settle another entity's invoice. Check the authorised treatment rather than letting a spreadsheet make the relationship.

Age unresolved payment allocations as well as invoices. They can affect the payment-linked ITC review if nobody can establish which bill was paid. A supplier-level zero balance is not always a complete invoice-level allocation story.

EntryLedger extracts and validates invoices; it does not ingest supplier statements, maintain payment balances or perform this reconciliation. Its reviewed source records can help identify a missing bill, but the worksheet remains your accounts process.

Tally remains the ledger you compare, subject to your own posting and review controls. EntryLedger's XML handoff is a preview, not a qualified statement-reconciliation or import result.

The next time the two closing balances differ, write the difference on the exception sheet. Give it a source document to find. Post only the transaction you can explain.

Sources and scope
  • Tally Help
    Official Tally import help

    Check actual postings and the destination company; a file handoff is not a reconciled ledger.

  • EntryLedger
    Invoice-level validation

    Document checks do not maintain supplier balances or settle statement differences.

  • EntryLedger
    Review and export scope

    The worksheet is a suggested accounts control, not a shipped reconciliation feature.

Frequently asked questions
Is a supplier statement the same as GSTR-2B?+

No. A supplier statement describes your account, often including payments and credits. GSTR-2B is a GST portal statement with a different role. Reconcile each for its own purpose rather than using one as a substitute for the other.

Should I post the difference to close the supplier account?+

Not without supporting evidence and approved treatment. First identify the invoice, credit, payment or scope difference behind it. An unexplained balancing entry hides the cause and can create another incorrect transaction.

What should I do with an invoice missing from my ledger?+

Obtain the original and check the receipt, approval and duplicate trail before posting. A line on the supplier statement is an investigation prompt, not automatic posting authority. It may already exist under another reference or remain disputed.

Does EntryLedger reconcile supplier statements?+

No. EntryLedger extracts and validates invoice records. It does not maintain supplier account balances or bank allocations. The downloadable blank worksheet is a separate working aid for your accounts team.

Find the original behind an unmatched bill

Try invoice extraction and source review. Reconcile supplier balances in your accounts process, with the supporting documents retained.