Skip to main content

​
Introduction

Orb’s Accounts Receivable Aging (AR aging) report breaks down outstanding receivables invoiced through Orb by how long they’ve been unpaid, helping finance teams manage collections and end-of-month reporting.  Use this report to:
  • Assess and forecast cash flow
  • Monitor customer payment behavior
  • Support bad-debt and allowance calculations
  • Prepare financial statements as part of your month-end close

​
Key components

Standard aging buckets Orb groups your issued but unpaid invoices into 5 buckets:
BucketDefinition
CurrentIssued invoices that are not past the due date
1-30 days past dueIssued invoices that are between 1-30 days past the due date
31-60 days past dueIssued invoices that are between 31-60 days past the due date
61-90 days past dueIssued invoices that are between 61-90 days past the due date
91+ days past dueIssued invoices that are over 91 days past the due date
Date picker Show outstanding invoices issued on or before a specific “as of” date (through the end of the day in the customer’s timezone). Select a historical date to report on AR balances at a point in time for end-of-month close, or select the current date to follow up with customers for collections. Aragingdatepicker2 Pn Multi-currency If you bill in multiple invoicing currencies, select which currency you’d like to see your AR aging report from the currency dropdown. Reporting configurations Pivot or filter data by a customer, invoice, or plan for additional reporting granularity and insights. 
Note: only subscription generated invoices will be attributed to a “Plan”. There is no “Plan” attribute for one-off invoices for ad-hoc charges your customer may incur.
Aragingconfigs Pn Extending the AR aging report Display additional metadata and download your AR aging report from Orb to CSV for further analysis.
Note: invoice status and plan status are only available in the “as of” current date view for collections.
Aragingexport Pn
Column nameDescription
CustomerThe name of the customer.
Customer IDThe Orb ID of the customer.
External customer IDThe external ID of the customer.
InvoiceThe identifying invoice number.
Invoice IDThe ID of the invoice.
Payment failed atThe time the invoice payment failed.
PlanThe name of the plan.
Plan IDThe ID of the plan. This value is null for one-off invoices.
Plan statusThe status of the plan. Available options: active, archived.
CurrentThe total invoice amount in the “current” aging bucket. These are issued invoices that are not past the due date, as of the report date.
1-30 days past dueThe total invoice amount in the “1-30 days past due” aging bucket. These are issued invoices that are between 1-30 days past the due date, as of the report date.
31-60 days past dueThe total invoice amount in the “31-60 days past due” aging bucket. These are issued invoices that are between 31-60 days past the due date, as of the report date.
61-90 days past dueThe total invoice amount in the “61-90 days past due” aging bucket. These are issued invoices that are between 61-90 days past the due date, as of the report date.
91+ days past dueThe total invoice amount in the “91+ days past due” aging bucket. These are issued invoices that are over 91 days past the due date, as of the report date.
TotalThe total invoice amount that has been issued, but not paid.

​
Report methodology

Invoices “as of” Orb shows invoices “as of” a certain date that meet the following criteria:
  • Collectible as of that date (invoice status = issued)
  • Unpaid, or payment failed
  • Created, or backdated with an invoice date as of that date
Payment timing Orb records the paid date of an invoice as:
Invoice type / payment methodPayment timestamp
$0 invoice$0 invoices are automatically marked as paid upon issuance
Auto-collectedPayment is recorded when the default payment method is successfully charged
Manually “marked as paid”Payment is recorded on the payment received date. This field is distinct from the “marked as paid” action date.
Invoices with small amounts below Stripe’s minimum charge thresholdSmall invoice amounts are automatically marked as paid upon issuance (and carried forward as a negative customer balance)
Fully credited invoice (credit note for full amount)If the remaining amount due is $0, they are automatically marked as paid upon credit note issuance
Partial payments are not yet supported in Orb at this time. Invoice details
  • Invoice amounts always represent the final amount due, inclusive of credit notes, tax and adjustments
  • Voided invoices are excluded from the AR aging report relative to the void action date
Sync timing Invoice data in Orb reports is refreshed regularly, and is usually available in the report within 20 minutes. Actual processing times may be longer during high volume periods. Synced invoices For those invoicing outside of Orb, finalized invoices from Orb are synced and issued from your third-party invoicing provider. These invoices have a status of  “synced” in Orb, and are included in the AR aging report. To change the invoice status to “paid” and reflect collections in the Orb AR aging report, you must manually mark these invoices as “paid” in Orb.

​
Access and eligibility

AR aging is available in the Reports tab.
All plans and user roles have access to this report.