> ## Documentation Index > Fetch the complete documentation index at: https://docs.dualentry.com/llms.txt > Use this file to discover all available pages before exploring further. # Aging Reports Reference > Reference for AR and AP aging reports in DualEntry - configurable age buckets, grouping dimensions, drill-down behavior, and export formats. DualEntry produces accounts receivable (AR) and accounts payable (AP) aging reports that break open balances into configurable age buckets. You use AR aging to manage collections and assess credit risk, and AP aging to plan vendor payments and manage cash outflows. ## AR aging The AR aging report shows outstanding customer invoices grouped by how long they have been open. Each invoice falls into an age bucket based on the number of days past its reference date. Default buckets are: **Current**, **1-30 days**, **31-60 days**, **61-90 days**, and **90+ days**. You customize bucket ranges in the report settings. For example, you might add a 91-120 day bucket and change the final bucket to 120+. AR aging drives collection efforts. Invoices in older buckets signal overdue balances that may need follow-up or escalation. The report also supports bad debt provisioning. You apply an allowance percentage per bucket to estimate the reserve. For example, you might set 1% for the 1-30 day bucket, 5% for 31-60, and 20% for 90+, and DualEntry calculates the estimated allowance for doubtful accounts automatically based on the open balances in each bucket. ## AP aging The AP aging report shows outstanding vendor bills grouped by the same bucket structure. Default buckets match the AR aging defaults, and you customize them independently. AP aging supports cash management and vendor payment prioritization. You identify which bills are approaching or past their due dates, helping you schedule [vendor payments](../core-financials/accounts-payable/vendor-payments) and take advantage of early payment discounts. The report highlights bills eligible for early payment terms. If a vendor offers 2/10 net 30, the AP aging report shows which bills are still within the discount window. You use this information to prioritize payments that reduce total cost, while deferring payments where cash flow timing matters more than the discount. ## Aging date By default, DualEntry ages each invoice or bill from its **due date**. You can switch the reference date to the **document date** (the date the invoice or bill was issued). The aging date selection applies to the entire report and changes bucket assignments accordingly. Choosing the right aging date depends on your analysis goal. Due-date aging shows how many days past due each item is, which is useful for collections and payment prioritization. Document-date aging shows how long the item has been outstanding since issuance, which is useful for measuring invoice-to-payment cycle times and identifying slow-moving receivables or payables regardless of payment terms. You switch between the two views without regenerating the report. DualEntry recalculates bucket assignments instantly. ## Dimensions and drill-down You group the aging report by customer or vendor, company, or classification dimension. The report supports two views: * **Summary view**: shows a single row per customer (AR) or vendor (AP) with the total balance in each bucket. * **Detail view**: shows every open invoice or bill as its own row, with the age bucket and amount. Click any row in summary view to expand the underlying open documents. Click any document to navigate to the full [invoice](../core-financials/accounts-receivable/invoicing-and-dunning) or [bill](../core-financials/accounts-payable/bill-management) record. You combine grouping with filters to narrow the report. For example, group by customer and filter to a single entity to see only that entity's receivables. The drill-down preserves all active filters, so the detail rows always reconcile to the summary totals. Aging reports include only open (unpaid or partially paid) documents. Fully paid invoices and bills do not appear. ## Exclude a journal entry from aging Journal entries with a `customer_id` or `vendor_id` on a line feed into AR or AP aging by default. When an entry touches the sub-ledger but shouldn't be treated as an open receivable or payable (for example, a reclass, a bad debt write-off, or a correcting entry), open the [journal entry](../core-financials/general-ledger/journal-entries) and toggle **Exclude from AR aging** or **Exclude from AP aging** on. The entry remains on the customer or vendor sub-ledger and in the General Ledger, but DualEntry omits it from the aging buckets and from the allowance-for-doubtful-accounts calculation. Toggle the setting off at any time to reintroduce the entry to aging. Removing the `customer_id` or `vendor_id` from the line is also an option, but it drops the entry from the sub-ledger entirely. Use the exclude toggle when you want to keep the sub-ledger link intact. ## Export You export the aging report in CSV, Excel, or PDF format. The export respects the current view (summary or detail), all active filters, and the selected dimensions. PDF exports are formatted for direct inclusion in a close package or board presentation. The Excel export includes a separate worksheet for each grouping dimension, making it easy to distribute entity-specific or customer-specific aging data to reviewers. CSV exports produce a flat file suited for importing into external tools or BI platforms. You also add the aging report to a [report group](./exporting-and-report-groups) so it exports alongside other close deliverables in a single action. ## Related pages * [Invoicing and dunning](../core-financials/accounts-receivable/invoicing-and-dunning) - manage the invoices that feed AR aging * [Bill management](../core-financials/accounts-payable/bill-management) - manage the bills that feed AP aging * [Customer payments](../core-financials/accounts-receivable/customer-payments) - record payments that clear AR aging balances * [Vendor payments](../core-financials/accounts-payable/vendor-payments) - record payments that clear AP aging balances