Outstanding Balances Migration
Outstanding balances migration is the process of carrying open, unpaid customer invoices and supplier bills from an old accounting system into a new one, invoice by invoice, rather than as a single lump sum. It is done at go-live. It matters because collections, payments and aging must continue seamlessly — a debtor's individual invoices have to exist in the new system so receipts can be matched and reminders sent.
What Is Outstanding Balances Migration?
Outstanding balances migration deals specifically with the open items on the debtor and creditor ledgers — the invoices customers have not yet paid and the bills the business has not yet settled as at the cut-off date. Rather than bring the debtor across as one opening figure, each unpaid invoice is loaded individually, with its date, amount and reference, so the new system can match a later receipt to the right invoice and age the balance correctly.
An Indian business meets this at go-live on a new system. A Thane services firm with ₹18,00,000 owed across forty customer invoices loads each open invoice into the new software, not just the total. When a customer then pays a specific invoice, the receipt matches cleanly, the aging report stays accurate, and GST already accounted for on those invoices is not double-counted. The same is done for unpaid supplier bills on the payables side.
Key terms
- GST History Extraction — Extracting GST already accounted on the open invoices.
- Double-Entry Bookkeeping — The debit-credit basis the opening items post through.
- General Ledger — Where the migrated party balances are summarised.
How Outstanding Balances Migration Works
Open items move across and prove out through a defined sequence:
- 1Extract the open items
The list of unpaid invoices and bills as at the cut-off date is pulled from the old system — the detail to be migrated.
- 2Load each item individually
Every open invoice and bill is entered in the new system with its date, amount, party and reference.
- 3Set the opening against the party
Each item posts to the correct customer or supplier so the party ledger reflects the true open position.
- 4Avoid double-counting GST
Open items are loaded as balances, not re-issued as fresh taxable invoices, so GST already accounted is not repeated.
- 5Reconcile the aging
The migrated debtor and creditor totals and their aging are reconciled to the old system before go-live.
How Outstanding Balances Migration Is Handled in Accounting Software
Each tool lets you load open items as opening documents; the discipline is item-level detail and no GST double-count.
| Software | How it handles outstanding balances | Watch-out |
|---|---|---|
| Zoho Books (India) | Open invoices/bills are entered with the opening-balance date so payments can be matched to them. | Entering them as normal invoices re-triggers GST — load them as opening balances/adjustments. |
| Tally / TallyPrime | Bill-wise details on the ledger opening balance capture each pending reference. | Skipping 'Maintain bill-wise details' collapses open items into one figure and breaks matching. |
| Xero | Outstanding invoices/bills are entered as at the conversion date via the conversion balances/aged detail. | Conversion invoices dated wrongly distort aging from day one. |
| Odoo | Open invoices/bills are imported in their open state so residual amounts remain matchable. | Importing them as paid or as journal-only entries loses the ability to match receipts. |
The test is the same everywhere: party-wise open items and aging in the new system must match the old.
Outstanding Balances Migration: A Practical Example
| Particulars | Amount (INR) | Treatment |
|---|---|---|
| Open customer invoices (40 nos.) | 18,00,000 | Loaded invoice by invoice |
| Open supplier bills (22 nos.) | 11,00,000 | Loaded bill by bill |
| Later receipt against Invoice #A-118 | 65,000 | Matched to the specific open invoice |
| Aging report after migration | reconciled | Ties to old system's aging |
A Thane services firm migrates ₹18,00,000 of receivables across forty customer invoices and ₹11,00,000 of payables across twenty-two bills — each open item loaded individually. When a customer later pays ₹65,000 against invoice #A-118, the receipt matches that exact invoice, keeping the aging accurate. Because the items were loaded as opening balances rather than re-issued, the GST already accounted on them is not counted twice.
item migration goes wrong when detail or GST treatment slips:
Common Mistakes With Outstanding Balances Migration
Open-item migration goes wrong when detail or GST treatment slips:
- Loading debtors as a lump sum — A single opening figure with no invoice detail stops receipts matching → load each open invoice and bill individually.
- Re-issuing open invoices as new — Entering them as fresh taxable invoices double-counts GST → load them as opening balances, not new documents.
- Ignoring bill-wise references — Dropping invoice references breaks reconciliation and reminders → carry the original reference on each item.
- Not reconciling aging — Going live without tying the aging to the old system hides missed items → reconcile party-wise aging before go-live.
Outstanding balances migration is the process of carrying open, unpaid customer invoices and supplier bills from an old accounting system into a new one, invoice by invoice, rather than as a single lump sum. It is done at go-live. It matters because collections, payments and aging must continue seamlessly — a debtor's individual invoices have to exist in the new system so receipts can be matched and reminders sent.
Need help with Outstanding Balances Migration?
Outstanding Balances Migration sits inside your day-to-day books. Patron's CA-led team keeps them accurate, compliant and audit-ready.
Applicable framework: Migration practice; receivables/payables presentation per AS 1 / Ind AS 1; GST accounting under CGST Act 2017. For general information only, not professional advice. Verify the current position for your entity before acting.