Reports

Pelcro provides an Accounting Reports section that helps you review customer's activity and reconcile transactions over specific time periods. You can locate these reports from Accounting > Reports.

Customer Summary Balance Report

The Customer Summary Balance Report provides a snapshot of each customer’s balance — including their current balance, balance as of a chosen date, and all transactions that occurred within a specified reporting period.

This report helps finance teams verify ledger accuracy and perform month-end or audit reconciliations.

Main Report Fields

Field Name	Definition	Example
Current Ending Balance	The customer’s balance as of the time the data is downloaded. This reflects the most up-to-date amount currently shown in the system.	If the customer’s balance is 900 at the time you download the data, the current ending balance will be 900.
Ending Balance as of [Selected Date]	The customer’s balance as of the end of the selected reporting period. It excludes any transactions that occurred after that date.	If the selected period ends on 1 August and the balance at that date was 900, the ending balance as of that date is 900.
Balance Transactions Summation	The total value of all transactions (payments, adjustments, etc.) that occurred within the selected date range.	If the customer’s balance was 1000 at the start of July, and a 100 transaction occurred during August, then the transaction summation for the selected August period is 100.

Example Scenario

Field	Value	Explanation
Balance as of June	1000	Opening balance at the start of the reporting period.
Transaction Applied (July)	100	Applied balance to invoice in July.
Report Selected Period	1 July – 1 August	Reporting range selected by the user.

Calculated Report Output:

Field	Value	Explanation
Current Ending Balance	900	Current balance as of the time of report download.
Ending Balance as of Selected Period	900	Balance at the end of the selected period (1 August).
Balance Transactions Summation	100	Total transactions applied during July.

How It Works

The report aggregates all customer balance transactions (invoices, payments, refunds, and adjustments).
For each customer, it computes:
- The balance at the start of the selected period
- The total movement (sum of transactions) during the specified period
- The ending balance as of the selected period’s end date
When the report is downloaded, Pelcro recalculates the Current Ending Balance to reflect the most recent activity in the system.

Use Cases

Month-end or quarterly reconciliation
Customer balance verification before billing runs
Audit reviews and balance movement tracking

Accounts Receivable (AR) Aging Report

The AR Aging Report provides a complete snapshot of all open invoice balances and categorizes them into industry-standard aging buckets (0–30, 31–60, etc.) based on a selected As of Date.
This report is essential for finance, accounting, and collections teams who need to monitor overdue invoices, forecast cash flow, and perform accurate reconciliation.

Overview

The AR Aging Report allows you to:

View all open invoices as of a chosen cutoff date.
Understand how overdue each invoice is based on aging buckets.
Analyze invoice-level financial data along with related subscription, customer, and plan metadata.
Support collection workflows, audit needs, and financial statement alignment.

All aging values are calculated relative to a single As of Date, which follows standard accounting practice.

As of Date Logic

The As of Date determines:

Which invoices appear in the report (only invoices created on or before this date and still open as of that date).
How the aging buckets are calculated.
Which balances are considered overdue or not yet due.

If an invoice has no due date, the system will automatically use the invoice creation date for aging calculations.

Aging Buckets

Every open invoice is categorized into one of the following buckets:

Not Yet Due
1–30 Days Past Due
31–60 Days Past Due
61–90 Days Past Due
91–120 Days Past Due
Over 120 Days Past Due

The sum of all these buckets equals the invoice’s Accounts Receivable balance.

Report Fields

Each row in the report includes detailed invoice, customer, subscription, and plan information:

Invoice Details

Invoice ID
Invoice Number
Invoice Created At
Invoice Status
Invoice Total
Due Date
Accounts Receivable
All aging bucket values (Not Yet Due → Over 120 Days)

Subscription Details

Subscription Created At
Subscription Started At
Subscription Period Start
Subscription Period End
Subscription Status

Customer Details

Customer ID
First/Last Name
Email
Customer Title
Customer Organization

Product & Plan Details

Product Name
Plan ID
Plan Name
Plan Term
Plan Amount
Plan Auto Uncollectible Days (Used to compute time remaining before the invoice becomes uncollectible)
Sales Rep Name associated with the subscription

How It Works

For each invoice:

Confirm it is open as of the selected As of Date.
Determine the correct aging bucket based on the Due Date.
- If no Due Date exists, fallback to Invoice Created Date.
Calculate Accounts Receivable as the sum of all aging buckets.
Combine the invoice details with related subscription, customer, and plan metadata.

Only open invoices with outstanding balances are included.

Use Cases

Tracking overdue customer balances
Collections follow-up and prioritization
Cash flow forecasting
Month-end and quarter-end reconciliation
Audit support and financial statement tie-outs
Monitoring trends in aging to identify risk accounts

📘
Next Steps:

Learn more about Accounting

Contact [email protected] for questions about report data.