> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hitaji360.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Aged Receivables & Payables

> The Aged reports show outstanding balances broken down by how long they've been open.

The Aged reports show outstanding balances broken down by how long they've been open. **Aged Receivables** does this for what customers owe you; **Aged Payables** does it for what you owe vendors. Both work the same way and share the same screen, so they're documented together here.

* Aged Receivables: `/accounting/reports/aged-receivables`
* Aged Payables: `/accounting/reports/aged-payables`

> 📷 *Screenshot: Aged Receivables with the per-customer rows, age buckets, and the reconciliation strip — to be added.*

## When to use them

* **Aged Receivables** — to drive collections: see who owes you, how much, and how overdue it is so you can chase the oldest debts first.
* **Aged Payables** — to plan payments: see what's due to whom and how long it's been outstanding so you can manage cash and avoid late penalties.
* At period-end, to confirm the open-item detail agrees with the receivables/payables control balance on the ledger.

## How to run them

Both reports show positions *as of* a date.

* **As of date** — the date you want the ageing calculated to. Each open item's age is measured from its posting date up to this date.
* **Buckets** — choose how the age bands are split. Built-in presets are:
  * **30 / 60 / 90** (the default) → Current, 1–30, 31–60, 61–90, >90 days
  * **7 / 30 / 60 / 90 (delinquency)** → a tighter early band, useful for chasing slippage
  * **15 / 30 / 45 / 60**

The report refreshes automatically; a **Refresh** button re-pulls the latest figures.

> 📷 *Screenshot: The bucket preset chips with "30 / 60 / 90" selected — to be added.*

## Reading the report

Each row is one customer (for Receivables) or one vendor (for Payables), sorted with the largest outstanding balance at the top.

| Column                | Meaning                                                                                                                                                       |
| --------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Customer / Vendor** | The party. Lines with no linked party roll up under **Unassigned**. The party name links to the contact record.                                               |
| **Age buckets**       | The outstanding amount that falls into each age band (Current, then the bands you chose, then the open-ended oldest band). A dash means nothing in that band. |
| **Total**             | The party's total outstanding across all bands.                                                                                                               |

A **Totals** row at the bottom sums each bucket and the grand total.

### How items are aged

The report walks each party's transactions in date order and applies receipts (or payments) to the **oldest** open charge first — standard open-item, first-in-first-out ageing. Whatever remains open is then placed in the band matching its age at the as-of date. Overpayments show as a negative amount under **Current**.

### Reconciliation

Below the table, the report compares its total against the ledger:

* **Ledger balance** — the receivables (or payables) control-account balance from the trial balance at the same as-of date.
* A green **Reconciles** badge confirms the aged total matches the ledger balance. If they differ, a red **Variance** badge shows the gap.

A reconciling report is your assurance that the open-item detail is complete and matches the control account. A variance usually means an entry hit the control account without a matching open item (or vice versa) — worth investigating before the period closes.

> 📷 *Screenshot: The reconciliation strip showing the ledger balance and a green "Reconciles" badge — to be added.*

## Drilling in

Click a customer or vendor name to open that contact, where you can see and act on the underlying documents.

## Exporting

**Export** offers CSV, Excel (.xlsx), and PDF. The export carries each party with its per-bucket amounts and total, then a **Totals** row, the **Ledger balance (TB)**, and the **Reconciliation delta**. The PDF carries your business name and the as-of date in the header.

## Tips and gotchas

* **Receivables vs Payables** are two separate pages with the same layout — make sure you're on the one you intend (the column header reads *Customer* or *Vendor* accordingly).
* Ageing is measured to the **as-of date** — move it back to see how balances looked at a past month-end.
* Items under **Unassigned** are open balances on the control account with no linked party; if you see a large Unassigned figure, some documents may be missing a customer/vendor link.
* The Current bucket holds items not yet past their first age band, plus any customer overpayments (shown negative).
* For a closed/locked period, the figures come from the frozen snapshot taken at close.

## Related

* [Reports overview](/accounting/user/reports/overview)
* [Trial Balance](/accounting/user/reports/trial-balance) — the control balance these reports reconcile to
* [General Ledger](/accounting/user/reports/general-ledger) — the postings behind each party's balance
* [Balance Sheet](/accounting/user/reports/balance-sheet)