Title
Aged Receivables
Tags
Aged Payables
Cash Flow
VAT Report

Aged Receivables Page Manual

The Aged Receivables , also known as Accounts Receivable Aging, provides a breakdown of customer payments based on how long they have remained unpaid. This helps businesses assess overdue accounts and manage collections effectively.

Features

1. Aged Receivables Table

The table includes key columns:

  • Label: Reference details (e.g., invoice number).
  • Date: Transaction date of the receivable.
  • Journal: Indicates the journal type (e.g., Customer Invoices).
  • Account: The account name (e.g., Accounts Receivable).
  • Aging Categories:
    • 1–30 Days
    • 31–60 Days
    • 61–90 Days
    • 91–120 Days
    • Older: Overdue by more than 120 days.
  • Total: Cumulative amount due for each entry.
Aged Receivables Table

3. Export to Excel

Download the report as an Excel file for offline analysis or sharing.

Export to Excel Button

A. How to Apply Filters

  1. Access the Filters: Locate the filter section at the top of the page.
  2. Enter Criteria: Provide values such as label, date range, or journal type.
  3. Search: Click the search button to filter the data.
Filters UI

Frequently Asked Questions

Q: Can I update payment status from this page?

A: No. You must update it through the Customer Invoices page.

Q: What should I focus on in the report?

A: Pay attention to amounts in the Older category, which indicate long overdue balances.