Cash receipts don't age into the same column as the invoice

• If the invoice has different accounting and status dates, the invoice and related cash receipts can age differently
• If the invoice has different accounting and invoice dates, the cash receipt ages differently when using Accounting Date
• You voided the invoice and the accounting date of the void is different than the invoice date
• You edited the invoice and the transactions have a different accounting date than the original invoice

To stop future invoices from aging in different columns than cash receipts, have the invoice date and accounting date of the invoice be the same. In BL Settings, change the Accounting date usage to be Invoice date. When entering invoices in Accounts Receivable manually, the system will initially make the invoice date match the accounting date. If you change the accounting date, you must go back and change the invoice date.

The cash receipt and invoice eventually age together in the over 120 column when you run the report far enough in the future. If you can’t run the aging in the future, correct the dates or run by invoice date.

Running by Invoice Date won’t match General Ledger or other applications because they use the accounting date. Other entries can also age in different periods due to the change in how the report calculates those columns.

Choose an option below to resolve for existing invoices.

Correct the invoice

1. Unapply the cash from the invoice.
2. Void the invoice.
3. Reenter the invoice using the same date for both Invoice Date and Accounting Date.
4. Reapply the cash receipt.

Run the aging by Invoice date

You can't run this report by invoice date if using the report to reconcile to General Ledger or other applications. This only works for Accounts Receivable reporting purposes.

1. From the Aging basis dropdown list, select Invoice Date.
2. Print the report as usual.

When you pay the invoice in full and bill all retainage, the invoice will drop from the aging.

Correcting edited invoices

1. Unapply the cash from the invoice.
2. Use Edit Invoice to reverse the prior changes and revert the invoice to its original dates.
3. Void the invoice.
4. Reenter the invoice with the correct information.
5. Reapply the cash receipt.

How does a cash receipt age on the Aging Detail reports?