Talk to an expert

Tell us what you need and we will call you back.

🇮🇳 +91

    Glossary · Accounting & Bookkeeping

    Outstanding Balances Migration

    Definition

    Outstanding balances migration is moving the open, unpaid customer invoices and supplier bills from an old accounting system into a new one, one document at a time, instead of as a single total per party. It is done at go-live, as at a cut-off date. This lets the new system match later receipts and payments to the right invoice and keep the ageing report correct.

    • Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Read the full entry

    At a glance

    Category
    Accounting & Bookkeeping
    In this entry
    Why item by item matters How it works · Example

    In detail

    01 Why item by item matters

    An outstanding balance is the amount still unpaid on an invoice or bill. If a customer's ₹4,00,000 balance is loaded as one figure, the new system cannot tell which invoices are 10 days old and which are 200 days old. Loading each open invoice with its number, date and unpaid amount keeps reminders, collections and supplier payments on track.

    How it works

    02 How it works

    1. Pick the cut-off date

      The start of the financial year (1 April) is simplest because last year's closing figures become the opening balances. A mid-year switch also works if the trial balance on that date is reconciled.

    2. Extract open items

      From the old system as at the cut-off date.

    3. Load each item

      With party, original number, date and unpaid amount. Post the other side to a temporary migration (opening balance) account.

    4. Do not re-issue them as new tax invoices

      GST on these invoices was already accounted for in the old system.

    5. Reconcile

      Party-wise totals and ageing must match the old system, and the temporary migration account must net to zero after the opening trial balance is loaded.

    Worked example

    03 Example

    An example, not advice on your facts.

    A Thane services firm goes live on new software on 1 April.

    Item Count Amount (₹)
    Open customer invoices 40 18,00,000
    Open supplier bills 22 11,00,000

    Each document is loaded separately. In May, a customer pays ₹65,000 against invoice A-118; the receipt is matched to that invoice and the ageing report stays accurate.

    In detail

    04 Balances only or full history?

    Most businesses migrate only open items and opening balances, and keep the old software in read-only mode for past records. Moving every past voucher takes far longer and raises the risk of mismatches.

    Watch out

    05 Common mistakes

    • Loading each customer or supplier as one lump sum.
    • Entering open invoices as fresh sales invoices, which counts GST twice.
    • Dropping original invoice numbers and dates.
    • Going live without reconciling party-wise ageing to the old system.

    Questions

    06 Questions people ask

    What is meant by outstanding balance?
    An outstanding balance is the amount still unpaid on an invoice, bill, loan or account on a given date. For a customer, it is what they still owe; for a supplier, it is what the business still has to pay.
    How to calculate outstanding balance?
    Take the total amount billed, then subtract payments received and any credit notes issued against it. For example, an invoice of ₹1,00,000 with ₹35,000 received and no credit note has an outstanding balance of ₹65,000.

    Need help migrating open balances? See our Migration: Tally to Zoho Books or MIS Reporting. You can also see our Accounts Reconciliation Services and Audit Support.

    Review and sources

    Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Talk to an expert

    Tell us what you need and the right person calls you back.

    🇮🇳 +91

      By sending this form you agree to our privacy policy.

      Get compliance due-date alerts on WhatsApp. Join →