Aging 7 Buckets

Overview

The Aging 7 Buckets report helps businesses track unpaid invoices by organizing overdue payments into different periods, like 1-30 days, 31-60 days, or beyond. It provides details on who owes money, the amount owed, and how long the payments have been overdue. With customer information and transaction details, the report gives a clear picture of outstanding balances. It also allows filtering by specific customers, amounts, or company segments, allowing you to focus on key areas. This report is essential for managing cash flow and prioritizing collections to ensure timely payments.

Report

Column Description
Division Division or business unit associated with the record.
Customer Name Name of the customer.
Account Number Unique identifier of the customer's bank account number.
City City specified in the customer’s address.
State State or province specified in the customer’s address.
Invoice Number System-generated bill identification number.
Transaction Number Reference number linking to the order number, adjustment number, or reconciliation number depending on the transaction type.
Transaction Type Specifies the nature of the transaction, such as bill, adjustment, or payment.
Due Date Date when the payment is due.
Transaction Date Date and time when the transaction was executed in the system.
GL Date Date when the transaction is posted to the general ledger system.
Outstanding Amount Total unpaid amount associated with the account.
1-30 Days Past Due Outstanding amount for transactions that are 1 to 30 days past the due date.
31-60 Days Past Due Outstanding amount for transactions that are 31 to 60 days past the due date.
61-90 Days Past Due Outstanding amount for transactions that are 61 to 90 days past the due date.
91-120 Days Past Due Outstanding amount for transactions that are 91 to 120 days past the due date.
121-150 Days Past Due Outstanding amount for transactions that are 121 to 150 days past the due date.
Over 151 Days Past Due Outstanding amount for transactions that are more than 150 days past the due date.
Currency Currency used for the transaction.

Filters

You can filter the report using the following parameters:

  • Division
  • Customer Name
  • Due Date