Customers & Sales

Aged Receivables

The Aged Receivables screen analyses outstanding customer balances aged by overdue period. It operates in two distinct modes: All Customers (summary view) and One Customer (transaction detail view). Each mode has two tabs — Debits (amounts owed to you) and Credits (overpayments or return credits). Access from Sales › Aged Receivables.

Two Views, Same Screen: The radio buttons at top switch between All Customers (one row per customer, summary totals) and One Customer (one row per transaction, individual invoice/payment detail). Double-clicking a customer row in All Customers mode automatically switches to One Customer mode for that customer.

Filters

All Customers

Summary view showing one row per customer. Enables the Type, Group, and Pat Group filters. Disables the Customer field.

One Customer

Transaction detail view for a single customer. Enables the Customer lookup. Disables the Type, Group, and Pat Group filters.

Date

The "as at" date for the aging calculation. All transactions are aged relative to this date. If left blank, defaults to today. Use a past date to view what the aging looked like on a specific historical date — payments posted after this date are excluded from the calculation.

Store

Optional store filter. When set, only transactions from this store are included. Leave blank for all stores.

All Customers Mode — Filters

These filters are only active when "All Customers" is selected:

Type

Filter by customer account type (e.g. Retail, Wholesale, Government). Only customers of the selected type are included.

Group

Filter by customer group. Only customers belonging to the selected group are included.

Pat Group

Filter by patronage group. Only customers belonging to the selected patronage group are included.

One Customer Mode — Filter

This filter is only active when "One Customer" is selected:

Customer

Customer lookup. Select the specific customer to analyse. All unpaid transactions for this customer are loaded.

Debits & Credits Tabs

The results are split into two tabs: Debits (amounts customers owe) and Credits (overpayments or return credits). Click a tab to switch views.

▶ All Customers View

Shows one row per customer with their total outstanding balance broken down by aging period. Click any column header to sort.

Results List

The main list view showing customers or transactions depending on the selected mode. Double-click a row to drill down or open the source transaction.

Debits Tab

Customers who owe money (positive balances). Each row is a customer summary:

Column	Description
Customer	Customer name.
Number	Customer account number.
Balance	Total outstanding balance across all periods.
Current	Amount not yet due (within payment terms).
30 days	Amount 1–30 days past due.
60 days	Amount 31–60 days past due.
90 days	Amount 61–90 days past due.
120+ days	Amount more than 90 days past due.

Credits Tab

Customers with a credit balance (overpayments, unapplied return credits). Same columns as Debits but showing negative balances. Credits that partially offset debits in older periods are cascaded forward (120+ → 90 → 60 → 30 → Current) so that the oldest amounts are reduced first.

Double-Click Action

Double-clicking a customer row switches to One Customer mode for that customer and automatically refreshes to show their individual transactions.

▶ One Customer View

Shows one row per unpaid transaction for the selected customer. The first column changes from "Customer" to "Id Number" (the transaction number).

Debits Tab

Individual unpaid invoices and other debit transactions:

Column	Description
Id Number	Transaction number (right-aligned). This is the invoice or debit memo number.
Number	Customer account number.
Balance	Remaining unpaid balance on this transaction.
Current – 120+	The remaining balance placed in the appropriate aging bucket based on the transaction's due date relative to the "as at" date.

Credits Tab

Individual unallocated credit transactions (returns, overpayments). Same columns showing the credit amount in the appropriate aging bucket.

Double-Click Action

Double-clicking a transaction row opens the transaction in its master screen (e.g. Invoice, Customer Return, Receipt) for viewing or editing.

Totals Area (Both Modes)

Below each tab is a summary area with two rows:

Row	Balance	Current	30 days	60 days	90 days	120+ days
Total	Sum of each aging column across all rows in the tab.
Percent	Each column as a percentage of the total Balance. Shows at a glance how much of the receivables are current vs. overdue.

Example: If Total Balance is $10,000 and 30 days is $3,000, the 30 days Percent shows 30.00%.

Aging Logic

Aging is calculated based on the due date of each transaction relative to the "as at" date:

Bucket	Condition
Current	Due date is on or after the "as at" date (not yet due).
30 days	Due date is 1–30 days before the "as at" date.
60 days	Due date is 31–60 days before the "as at" date.
90 days	Due date is 61–90 days before the "as at" date.
120+ days	Due date is more than 90 days before the "as at" date.

Credit Cascade: When a customer has both debits and credits, credits are initially placed in the 120+ bucket. If 120+ goes negative, the excess cascades into 90 days, then 60, then 30, then Current. This ensures credits reduce the oldest outstanding amounts first.

Historical "As At" Date: When a date is entered, the system excludes payments posted after that date from the paid totals. This lets you reconstruct what the aging report looked like on any past date.

Buttons

Refresh

Reloads all data based on the current filter settings. You must click Refresh after changing filters to update the display.

Print

Prints the currently visible tab (Debits or Credits) as a report. The printed report includes all rows from the tab plus footer totals for each aging bucket. The report title includes the selected filters (customer type, group, customer name, as-at date).

Close

Closes the Aged Receivables window.

Workflow

Review all customers:
1. Select All Customers. Optionally filter by Type, Group, or Pat Group.
2. Click Refresh.
3. Review the Debits tab for overdue accounts. Sort by the 90 days or 120+ columns to find the most delinquent.
4. Check the Credits tab for customers with unapplied credits that could be applied to open invoices.
5. Double-click a customer to drill into their individual transactions.

Investigate one customer:
1. Select One Customer and choose the customer.
2. Click Refresh.
3. Review each unpaid invoice on the Debits tab to see which are overdue.
4. Double-click a transaction to open it for editing or to record a payment.

Related Screens