AR Aging by Invoice Date or Accounting Date

We issue our monthly requisitions with an invoice date that differs from the account date as we use accounting date of last day of the month. This seem to cause a problem when running AR Aging by Job, Customer or Contract by accounting date. The payments will not always line up in the correct aging columns to ZERO out the invoice paid.

Would it be Best Practice to use the invoice date as the accounting date or have all invoices dated the last day of each month? I never had this problem using Sage CRE at previous employers and think that the only issue as the accounting/invoice dates we used were the same.

  • 0

    From a financial reporting perspective (General Ledger and Financial Statements) where reporting is monthly, using any accounting date during the month will result in the same monthly revenue. Therefore if you use the actual invoice date as your accounting date, your Aging Report in AR should give you the results you want.  

  • 0 in reply to Art Minds

    The issue is when you run these reports by Accounting Date the partial cash receipts don't appear to be under correct "Aging" column

  • 0

    Hi John -

    When running the AR Aging Detail reports by accounting date, the cash receipt will age using the invoice date.  If the invoice has a different date for the invoice and accounting date, the cash receipt will age in different columns.  If you run the report by invoice date, the cash receipt will line up however it will not reconcile to GL.  If you want to use the AR Aging Detail reports by accounting date and have your cash receipts line up with the invoices, then the invoice date and accounting date on the invoice need to be the same date.  See knowledgebase  article 26237, "How does a cash receipt age on the Aging Detail reports in Accounts Receivable?" for more detail on how cash receipts age on the detail reports.