Accounts Receivable (AR) Aging Report
Problem Statement:
Currently, Pelcro does not provide an Accounts Receivable (AR) Aging Report. This limits finance teams’ ability to track outstanding balances by aging buckets (e.g., 0–30, 31–60, 61–90 days), which is a standard practice in accounting and critical for collections, cash flow forecasting, and financial audits.
💡 User Story
As an Accounts Receivable (AR) manager,
I want to generate an AR Aging Report from Pelcro with all relevant invoice, subscription, customer, and payment details,
So that I can track overdue balances, categorize them by aging buckets, and take appropriate collection actions.
🎯 Definition of Done (DoD)
A feature is done when:
Add the new report AR aging report under the reports page in Accounting.
The report must include a single “As of Date” filter that determines the cutoff date for aging calculations and which invoices are considered “open.”
Industry Standards for AR Aging Report Time Filters
Type: A single date selector (e.g., “As of 31 July 2025”).
Why it’s standard:
Aging is always calculated relative to a single reference date.
Easy to reproduce accounting cutoffs and match financial statements.
Reduces confusion vs. having “from–to” ranges.
All open invoices as of that date are shown.
Aging buckets (0–30, 31–60, etc.) are calculated based on that date.
Only invoices with a balance due as of the selected date should appear in the report.
The report must include the following data points:
Invoice ID
Invoice Number
Invoice Created At
Invoice Status
Invoice Total
Subscription Created At
Subscription Started At
Subscription Period Start
Subscription Period End
Subscription Status
Customer ID
Customer First Name
Customer Last Name
Customer Email
Product Name
Plan ID
Plan Name
Plan Term
Plan Amount
Accounts Receivable
Invoice Due Date
Amount Not Yet Due
Amount 1 to 30 Days
Amount 31 to 60 Days
Amount 61 to 90 Days
Amount 91 to 120 Days
Amount Over 120 Days
Plan Auto Uncollectible Days - For each invoice, identify the Plan attached to the invoice and export the Plan level Auto Uncollectible Days value. This will allow computing the days (based on Invoice Due Date + Override Uncollectible Days) remaining before the invoice would become uncollectible.
Sales rep name attached to the Subscription for which the Invoice is generated.
Aging buckets (Not Yet Due, 1–30, 31–60, 61–90, 91–120, Over 120) must calculate dynamically based on the selected As of Date.
Accounts Receivable per invoice equals the total of all aging buckets for that invoice.
Only invoices created on or before the As of Date and still open as of that date are displayed.
Log in to comment and vote
Comments6
Rana Haleem
Dec 2, 2025
This is now live, please check our docs here for more details:
https://docs.pelcro.com/docs/accounting-reports-1#/accounts-receivable-ar-aging-report
Michael Ghattas
Nov 18, 2025
Should we group invoices by customer in this report?
Manish Patel
Nov 14, 2025
•Merged request
•3 votes
Accounts Receiveable (AR) Export - Add additional fields
🔍 Problem Statement
As a finance admin, I experience the AR export missing key fields needed for collections follow-up on corporate subscribers, which requires manual cross-referencing across multiple reports.
💡 User Story
As a finance admin, I want the AR export to include billing contact, due date, and plan details, so that I can work the collections queue without supplementary data pulls.
🎯 Definition of Done
- Given the AR Export, when downloaded, then it includes: billing email, invoice due date, plan name, and subscriber contact name.
- This change impacts the API (AR export endpoint) and admin export UI.
- Limitations: fields are added to the existing CSV format; no new export type is created.
Problem Statement: We rely on the Accounts Receivable (AR) Export in order to perform collections on our Corporate Subscribers. However, this export is missing a few key fields that would allow us to proactively address resulting downstream issues that we currently face. Key points to understand: At a Global setting level we allow a 30 day time period before a invoice goes uncollectible. For Corporate Subscriptions, each subscription typically carries a distinct plan (as it is a custom price point). The Days Before Uncollectible has an override of 180 days for each plan pertaining to a Corporate Subscription. Thus Corporate subscribers enjoy a total of 210 days before the Invoice moves to an “Uncollectible Status” and Subscription gets cancelled. In 80% of the cases where the subscription has gone uncollectible we end up reinstating the subscription by creating a new plan because the customer pays. This creates a lot of misleading and error prone accounting/finance entries. Requested Solution: Add the following fields to the Export Invoice Due Date - The Date the current Invoice will be due. We need this to help us identify when an invoice is due and help us prioritize our collection efforts based on the age of the invoice. Plan Auto Uncollectable Days - For each invoice, identify the Plan attached to the invoice and export the Plan level Auto Uncollectible Days value. This will allow us to compute the days (based on Invoice Due Date + Overide Uncollectible Days) remaining before the invoice would become uncollectible. Further, it gives us an opportunity to adjust the plan auto-uncollectible days value so that the invoice doesn’t go uncollectible and more vigorous follow up with the Customer and Sales Rep can be done to collect the money. This would also avoid downstream problems with reinstatement or payment application that we mentioned above. It would also allow us to identify if a Sales Rep has missed adding the Plan Level override for Auto-uncollectible days. Plan ID : The plan id attached to the invoice. This allows us to quickly identify which plan needs to be modified if needed (see 2. above). Sales rep name attached to the Subscription for which the Invoice is generated. — This allows our AR team to consult with the sales rep about upcoming invoices that are at a risk of going uncollectible and also identifying which Sales Reps are neglecting to ensure the Auto Uncollectible Days value and quickly correct those plans.Rana Haleem
Nov 14, 2025
Hey @Manish Patel ,
We’ve added these fields under the Aging Report feature Accounts Receivable (AR) Aging Report and added you to its watchlist.
Let us know if you need anything else!
Michael Ghattas
Sep 25, 2025
What are the columns and rows or export?
I think columns should be aging range, total, and rows are customer info, and it should be sorted top to bottom by total AR outstanding
Asingdahlsen
Sep 26, 2025
I shared a file by email with format that is typical for AR Aging report