The A/R Aging Detail report shows unpaid invoices and statement charges in accounts receivable, grouped and summed by Customer/Project, and then summed for the period and shows transactions based on the date they are closed, as opposed to the date they are applied.
A/R Register Report lists all posting sales to and payments from the customers. These transactions are assets representing amounts owed by customers for the purchase of inventory, goods or services.
A/P Aging Summary Report shows all unpaid bills and the amounts owed to vendors for the current billing period and what is still owed from previous billing periods.
A/P Register report shows all posting purchases from or payments to vendors.
The main reason for discrepancy is, Trial Balance is considered as Financial Reports while A/P Aging and A/R Aging are not tagged as Financial Reports in NetSuite. Discrepancies between the Report amounts may be due to the Report by Period preference when the company allows entering transactions outside the Posting Period. So, there can be transaction date – posting period mismatch.
The Report by Period is a user Preference found by going into Home > Set Preference > Analytics Subtab > Reporting Portlet. This preference defines when a transaction will appear on a report. We can set this to All Reports, Financials Only and Never.
If Report by Period = Financials Only, then the Balance Sheet report captures transactions based on posting period whereas the Aging reports capture from transaction dates.
When set to Financials Only, the Aging Reports will use the actual Transaction Dates While, Balance Sheet and Trial Balance will look at the month set on Posting Period.
So, when we give Report by Period as ‘Never’ it allows both financial and non-financial reports will use transaction date reporting and ‘All Reports’, it allows both financial and non-financial reports will use posting period reporting.
