How do I remove two lines from the AR Aging Summary?

The A/R Aging Summary report displays any customer profile with an open balance. The Adjustments and Blue lines appear because they are likely set up as customer profiles with unsettled transactions.

To remove them, you must settle these balances to zero. Click the amount next to Adjustments or Blue line to view the A/R Aging QuickZoom report, which will show you the specific open invoices or journal entries causing the lines to persist. However, the balance that is from a journal entry (such as the 2020 JE), you may need to create a reversing journal entry to offset the original, or create a Bad Debt if the amount is uncollectible.

Once identified, use the Receive Payments to offset and close these entries. After the transactions are settled and the report is refreshed, these lines will no longer appear, removing the need for manual Excel edits.

If you have questions or clarification, please let us know below. We're here to help.