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.
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
- 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.
- Extract open items
From the old system as at the cut-off date.
- Load each item
With party, original number, date and unpaid amount. Post the other side to a temporary migration (opening balance) account.
- Do not re-issue them as new tax invoices
GST on these invoices was already accounted for in the old system.
- 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.
