Customer & Vendor Opening Balances: Preparation
Use a controlled opening-balance process when moving customer receivables and supplier payables into the accounting workflow. This guide focuses on preparation and verification rather than assuming a particular import screen exists in every deployment.
Where to start
Accounting workspace and the approved customer/supplier migration procedure; use Accounting reports for reconciliation.
Agree the cutover date, currency treatment and import or posting method with the finance owner. Confirm which outstanding documents and historical transactions will be migrated.
Follow these steps
- Export the approved outstanding customer and supplier items from the source system as at the agreed cutover date. Retain document references and supporting totals.
- Check customer and vendor identifiers, duplicate records, currency, due dates and unapplied credits before preparing the import data.
- Decide how open invoices, credits, payments on account and supplier balances will be represented in this deployment. Do not combine incompatible methods.
- Use only the supported import or posting workflow approved for the workspace. Start with a controlled sample and inspect its source links and ledger effect.
- Reconcile customer and supplier totals separately to the approved source reports and relevant control accounts. Investigate differences at document level.
- Approve the reconciled result before normal processing starts. Record the cutover boundary so historical imports and new transactions cannot overlap.
Prevent duplicate financial history
An opening balance and the historical invoices that make it up must not both be introduced as new financial value. The migration design should state which records carry balances and which provide reference information only.
A balanced journal alone does not prove that customer-level or supplier-level ageing is correct. Review both the control-account total and the underlying outstanding items.
Check the result
- Customer and supplier totals agree with the approved cutover evidence.
- Credits and payments on account remain associated with the intended party.
- The migration is not repeated and new operational transactions start after the agreed boundary.
Use approved finance access and your organisation’s accounting policy. Do not delete or repost financial history to make a total agree. Investigate the source and obtain approval for corrections, especially in a closed period.
