Aging Balance

Aging balance is outstanding balances, for your customers or your suppliers.

There are three ways to display aging balances:

1. Customer/Supplier Age Balance
2. Customer/Supplier Statement
3. Multiple Customer Statements

Aging Balance Report

The aging balance report groups current balances by the number of days until due date, relative to today's date. The report displays the aging balance for all customers or suppliers respectively. The aging balances are classified into two main groups:

1. Current Balances
• These are outstanding balances not yet due for payment
2. Overdue Balances
• These are outstanding balances that are due for payment
• Overdue balances are split into intervals, depending on the interval selection for the report.

Using Age Analysis

The aging balance report is one of your most important reports.

The report is used to stipulate how much cash you can expect from your customers in the near future, and how much cash you have to spend on your suppliers in the near future.

Negative Amounts

The report may sometimes show negative amounts for a customer or a supplier. The reason for this is that you have credits that exceed the invoices (for instance, you have received an excess payment from a customer).

If a customer or supplier has a total balance that is negative, it will not be displayed in the report.

Customer or Supplier Statement Age Analysis

The aging balance for a customer or a supplier is displayed on the customer statement or the supplier statement respectively. The Age Analysis on customer/supplier statements is either aged on actual due dates or by month. This depends on the setting in company preferences (see Configuration » Company Administration » X00 Company Preferences » Invoices and Orders)

Age By Month

If Age By Month is the company preference for aging customer statements, the following applies for the aging:

Column	Description
Current	Not due until next month or later
30 Days	Due in current month (based on day of analysis)
60 Days	Due last month
90 Days	Due two months ago
90 Days+	Due three months or more ago
Due Now	Total Due balance

Normal Aging on Actual Due Date

If Age By Month is NOT the company preference for aging customer statements, the following applies for the aging:

Column	Description
Current	Not due on date of analysis
30 Days	1 to 30 days past due
60 Days	31 to 60 days past due
90 Days	61 to 90 days past due
90 Days+	More than 90 days past due
Due Now	Total Due balance