Reports used to Reconciliation AR Receivables with General Ledger

List of Reports used to Reconciliation AR Receivables with General Ledger 

Sales Journal By Customer – Use to review all transactions.

Transaction Register – Use to check that all items that can be posted are reflected on the Sales Journal. The Sales Journal balance should match the total of the transactions here after adding the credit memo total twice (because it is a negative on the Transaction Register and a positive on the Sales   Journal).

Receipts Register – Use to review a list of receipts.

Sales Journal By GL Account – Use to ensure that the Transaction Register matches the Sales Journal.

Journal Entries Report – Use to review the details that make up the general ledger journal entries.

Receipts Journal Report – Use to review details of receipts that appear in the Journal Entries report.

Aging Report – Use the last day of the prior month to get the outstanding opening balance.

Transaction Detail Report – Use to identify transactions that increase the outstanding opening balance.

Adjustments Register – Use to identify any adjustments that affect the transactions for the month.

Unapplied Receipts Register – Use to determine customer balance after taking into account all on-account and unapplied amounts

Applied Receipts Register – Use to identify receipts that reduce the outstanding opening balance.

Invoice Exceptions Report – Use to identify transactions that reduce the outstanding opening balance. This report shows all transactions where the Open Receivables flag is set to No. Therefore, the transactions do not display on the aging but do show in the Transaction Register. This can occur when an item can be ordered in Order Management but not invoiced, such as an internal item.