Skip to main content

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

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 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 or bill 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.

​
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 so it exports alongside other close deliverables in a single action.
Last modified on May 28, 2026