How to generate customer aged and overdue sales invoices reports

Summary

Different methods to organize customer balances by days past due in Sage 50 Accounting.

Description

These Accounts Receivable Aging reports list all the customers who have unpaid (or partially paid) invoices. The reports organize balances according to how many days their invoices are past due.

Resolution

Customer Aged Report (all past invoices including paid)

  1. From the Sage 50 home menu, go to ReportsCustomer & Sales (Receivables).
  2. Select Customer Aged to show all invoices.
  3. Select either the Summary or Detail radio button.
  4. Click Select All to include all customers or manually select the required customers.
  5. Ensure the Date: is accurate and click OK.

Aged Overdue Sales Invoices (only due invoices)

  1. From the Sage 50 home menu, go to ReportsCustomer & Sales (Receivables).
  2. Select Aged Overdue Sales Invoices to view all overdue invoices.
  3. Select either the Summary or Detail radio button.
  4. Click Select All to include all customers or manually select the required customers.
  5. Ensure the Date: is accurate and click OK.

Report Centre (no filters)

  1. Go to ReportsReport Centre, Customers & Sales.
  2. Select an aging report type:
    • Customer Aged Summary
    • Customer Aged Detail
    • Aged Overdue Sales Invoices Summary
    • Aged Overdue Sales Invoices Detail
  3. Click Create.
  4. Set the Date field appropriately on the generated report.

Related Solutions

How to change the customer aging periods

Need more help?

Chat now

 

Solution Properties

Solution ID
223924750040049
Last Modified Date
Thu Mar 14 22:42:22 UTC 2024
Attributes
Product Details
Integrated Product: Blueprints
Views
0