United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
adilam
Level 1
posted
‎May 20, 2020 06:39 AM
last updated ‎May 20, 2020 6:39 AM

How to age journal entries that reflect on a customer balance summary and supplier balance summary ?

when extracting an ageing summary it reflects those customers/suppliers with zero balances which include no invoices/bills only deposits/cheques/payments/journal entries which cannot be matched and cleared / aged. Kindly advise how to clear these allowing for it to be removed from the ageing analysis.
Reply
1 Comment 1
Rasa-LilaM
QuickBooks Team
QuickBooks Team
‎May 20, 2020 08:50 AM

How to age journal entries that reflect on a customer balance summary and supplier balance summary ?

Welcome aboard to the Community, adilam.


Let’s filter the reports so customers/suppliers with zero balances will not show on the aging analysis. Customising it should only take a couple of minutes.


Here’s how:

 

  1. Tap the Reports menu on the left panel to enter A/P Aging Summary or A/R Aging Summary in the field box.
  2. On the report’s page, set the correct date range in the Report period drop-down.
  3. Go to the Show non-zero or active only section and then click the drop-down to choose Non-zero.
    ag.png
  4. Click Run report to view the changes.

Let me share the Customise reports in QuickBooks Online guide for additional resources. It provides an overview of how to personalize the data on a report as well as instructions on how to perform this task.


If there’s anything else I can help you with, leave a comment below. I’ll be right here to assist further. Have a great rest of the day.

Reply