How to Record Past Customer Invoices

Overview:

Recording past customer invoices allows businesses to establish outstanding Accounts Receivable (AR) balances from transactions that were created before the cut-off dateor go-live date. This process is commonly performed during system migration, opening balance setup, or when transferring records from a legacy accounting system.

Past customer invoices are typically recorded to reflect unpaid historical sales transactions so that customer balances, aging reports, and collection records remain accurate in the new system.

Depending on business requirements, past transactions may be recorded either as:

• Consolidated balances per customer, or

• Itemized historical documents based on original invoice references

When recording historical transactions, ensure that:

• The transaction date is earlier than the cut-off date or accounting start date

• Outstanding balances are verified against prior accounting records

• Related historical payments, credit notes, or debit notes are also considered to maintain accurate customer balances

The Accounts Receivable opening balance is derived from the net effect of:

• Past Customer Invoices

• Past Customer Debit Notes

Refer to: How to Record Past Customer Debit Notes

• Past Received Payments

Refer to: How to Record Past Received Payments

• Past Customer Credit Notes

Refer to: How to Record Past Customer Credit Notes

Only outstanding balances as of the cut-off date should be recorded.

Scenario:

Your company is migrating from a legacy accounting system to N3 AI Accounting for the January to December 2026 financial year. As part of the migration, the company needs to record all unpaid customer invoices dated before January 1, 2026, so that customer balances and Accounts Receivable reports remain accurate in the new system.

Some customers have a single outstanding balance, while others require individual historical invoices to be recorded for tracking and reconciliation purposes.

Prerequisites:

• Customer master records must already exist in the system.

• The financial year and opening balance period must already be configured.

• Outstanding customer balances must be verified against the previous accounting records before migration.

Procedure:

1. Prepare the list of outstanding customer invoices from the legacy records or prior accounting system.

2. Verify that the invoice balances represent unpaid amounts as of the cut-off date.

3. Review whether the invoices will be recorded as:

• Consolidated balances per customer, or

• Individual historical invoice transactions

4. Confirm that the transaction dates of the past invoices are earlier than the financial period start date or cut-off date.

5. In the navigation pane, go to Account Receivable > Invoices.

6. Click Add to create a new past customer invoice entry for each required customer record.

7. Enter the document date first (must be earlier than the financial period start date or cut-off date). The system automatically changes or classifies the document as a past invoice.

8. Select the customer and applicable historical invoice details, such as:

• Document Number

• Ref No.

• Description

• Balance

• Tax Code

Note:

If Tax/VAT details are entered for historical reference purposes, the VAT portion does not generate a separate posting to the VAT General Ledger account because only the outstanding receivable balance contributes to the Accounts Receivable opening balance.

9. Review the entered amounts carefully and Save the transaction.

10. Repeat the process for all remaining outstanding customer invoices.

11. After all entries are completed, review the reflected opening Accounts Receivable balance in General Ledger > Opening Balances to verify that the recorded balances match the historical records.

Application (General Use Cases):

• Establish opening Accounts Receivable balances during system migration

• Transfer outstanding customer balances from a legacy accounting system

• Maintain customer aging continuity after go-live

• Support historical balance reconciliation

• Help maintain continuity and accuracy of Accounts Receivable reporting

• Retain reference to historical customer invoice records for audit and tracking purposes

System Scope: QNE AI Cloud Accounting / N3 AI Accounting