The two reports are not generally expected to match.

• The A/R Aged Invoice Report is based upon the Invoice Date or Due Date (as set in Accounts Receivable Options) and can also have a Future Transactions setting on the report:
  • Exclude by Invoice Date
  • Exclude by Transaction Date
  • Include All
• The A/R Trial Balance Report prints invoices based on the Transaction Date which is the posting date used to update to the General Ledger module's G/L accounts.

Example: An invoice with an Invoice Date of 09/30/2025, posted with a Transaction Date of 10/02/2025, will display on the Aged Invoice Report (assuming aged by Invoice Date) when printed as of 09/30/2025. The same invoice will not display on the Trial Balance Report when it is printed as of 09/30/2025.

Example: An invoice with an Invoice Date in 09/30/2025 was posted with a Transaction Date of 09/30/2035 (mistakenly posted into the future). A negative adjustment was made to the invoice (via Invoice Data Entry) and updated with a Transaction Date of 09/30/2035. The same invoice was then positively adjusted and updated with a Transaction Date of 09/30/2025. Whether and how the invoice will display on the Aged Invoice Report now depends on the original transaction's Invoice Date and on what option is selected for the Future Transactions setting.