Aging Receivables

Receivables Aging report lists unpaid customer invoices with date ranges. This is a primary tool to determine which sales invoices are overdue for payment.

Purpose of the Report

The primary purpose of the Aging Receivables report is to categorize your company's accounts receivable according to the length of time an invoice has been outstanding. It helps the management and collection teams to:

• Track Outstanding Balances: Identify exactly how much money is owed by each customer.
• Assess Credit Risk: Recognize which customers are regularly delaying payments or exceeding their credit terms.
• Prioritize Collections: Focus collection efforts on accounts with heavily overdue balances (e.g., invoices that are over 60 or 90+ days past due).
• Forecast Cash Flow: Estimate upcoming cash inflows based on the breakdown of current and short-term outstanding amounts.

Key Information Displayed

For each customer, the report breaks down transactions into detailed columns to show:

• Customer Details & Transaction Metadata: Customer name, category, sales number, date delivered, and document reference.
• Payment Status: The original amount due, current remaining balance, payment status (Unpaid or Partially Paid), and the due date.
• Aging Buckets: The unpaid balance distributed across time frames based on age: Current, 1-30 Days, 31-60 Days, 61-90 Days, and 91 Days +.

Step-by-Step Guide

Follow these steps to navigate, generate, and export the Aging Receivables report in AccuBooks Plus:

Step 1: Navigate to the Report

1. Open the main navigation sidebar on the left side of your dashboard.
2. Scroll down to the MAIN section and click on the REPORTS dropdown menu.
3. Under REPORTS, click on the Sales & Collections sub-menu to expand it.
4. Select Aging Receivables from the list.

Step 2: Filter by a Specific Date

1. Locate the As of date field near the top left of the report page.
2. Click inside the date field box or use the calendar icon to select the target cut-off date for your aging evaluation.
3. Click the Go button next to the date input to refresh the report data for that specific period.

Step 3: Analyze Customer Balances

1. Scroll through the generated list to view individual customer groups.
2. Check the Status column to instantly see whether an invoice is entirely Unpaid or Partially Paid.
3. Review the Sub Total line under each customer to see their total exposure.
4. Look at the rightmost columns (Current up to 91 Days +) to evaluate how long specific funds have been tied up.
5. Review the Grand Total row at the bottom of the page for an aggregate summary of your company's entire receivables ledger.

Step 4: Export the Documentation/Data

1. If you need to print the report or analyze it further in a spreadsheet software, locate the Export button in the top right corner of the report workspace.
2. Click Export to download the report in your preferred document format (such as Excel or CSV).