Aging Basis If the Aging Basis is by Invoice date, the cash receipt ages based on the Status date of the invoice. The invoice will also age by the status date. If the Aging Basis is by Due date, the cash receipt ages based on the Due date of the invoice. The invoice will also age by the due date. If the Aging Basis is by Accounting Date, the cash receipt ages based on the date returned by the Acctg Date Aging formula. The invoice will age by the accounting date of the invoice. Accounting date aging formula The Acctg Date Aging formula is summarized:
If the cash receipt type is Customer Cash receipt, the activity date is used. Note that the activity date for the deposit can be obtained by going into the Inquiry, Activity, by Customer.
If the transaction type is Cash receipt, the status date is used. This ensures that the invoice cash receipt and the related invoice age together in the same column. If the related invoice's accounting date is different than the invoice date, when the aging report is run by Accounting Date, the cash receipt may not age in the same column as the invoice. This is usually because of a difference of more than 30 days, or dates in different months. Possible issues with the aging Date entered setting This aging issue could occur especially if in Billing, File, Company Settings, BL Settings, your Accounting date usage is set to Date entered. If you do not have a specific reason to have a different accounting date than your invoice date, you may consider switching that from Date entered to Invoice date. An enhancement request was submitted for this issue. Invoice cash receipt If there is an invoice cash receipt showing on the report with an amount in the amount column, but nothing in the current, over 30/60/90/120, this means that the cash receipt accounting/deposit date is before the cut off date but the invoice it is applied to has an accounting date after the date of the cut off date. The amount column is invoices and cash receipts as of the accounting date. The Current, Over/30/60/90/120 use the above dates for aging. This will also occur with retainage released transactions when the invoice where the retainage is held has an accounting date after the cut off date of the report, but the retainage billed invoice has an accounting date prior to the report cut off date, the retainage released transactions will show on the report without the invoice they are attached to. Both of these can make it seem like AR is out of balance to GL. |