The Accounts Receivable report tracks your customers’ outstanding balances and credit balances. This report breaks down outstanding balances into invoiced amounts, payments, and refunds. Similarly, credit balances break down into prepayments balances and unapplied credits. The CSV export allows you to see all of these elements and their corresponding details, including customer information, transaction dates, days outstanding, and days overdue.
Your Accounting team can use the Accounts Receivable report to measure outstanding balances and make provisions for doubtful accounts.
Your RevOps team can use the Accounts Receivable report in tandem with the Revenue Retention report to manage overdue accounts and to identify unpaid invoices that can be paid by allocating existing balances.
Please note that this report is only available for sites using Relationship Invoicing.
To open the Accounts Receivable report go to the Insights tab and click the “Accounts Receivable” link.
- Outstanding Balance - any invoice where the customer owes the merchant (you); calculated as invoice amount less net payments (gross payments less refunds) where the result is a positive value
- Outstanding Balances are split into Current and Overdue based on whether it’s past the due date.
- Credit Balance - any balance where the merchant owes the customer. These come in the form of unapplied prepayments and unapplied credits.
- Days Outstanding - the number of days that have passed since the invoice was issued. (Note: this CSV export also uses the Days Outstanding column to also show the number of days that have passed since the creation of a service credit or prepayment. For certain reporting, you may want to filter service credits and prepayments by setting aging_category = ‘Invoice’.)
- Days Overdue - the number of days that have passed since the invoice was due. Invoices that have not yet come due will show a negative for Days Overdue. Days Overdue serves as the input for the Aging Period.
The CSV export will serve as your tool of choice for your close-the-books process and any in-depth analysis.
You can export the CSV by clicking the download icon in the upper-right corner.
Each line in the CSV export represents one of the following: invoices with an outstanding balance (calculated as invoice amount less net payments), unapplied prepayments, and unapplied credits. You can filter on or sort by the aging_category field to identify which of these a line represents.
We have ordered CSV export columns from left to right beginning with reference IDs, followed by customer information, then aging category and invoice status, key dates, amounts, aging buckets, and ending with totals.
All amounts (e.g. billed_amount, payment_amount) are shown in their billed currency and also in the Site primary currency after fx rate conversion (e.g. converted_billed_amount, converted_payment_amount).
For a complete list of the columns in the CSV export, please view the export documentation.
The Accounts Receivable UI provides an overview of your customers’ outstanding balances and helps you quickly discover balance details for specific customers or invoices.
All metrics, graphs, and tables are driven by the filters at the top of the UI.
The UI provides several at-a-glance metrics you can find in the top left of the UI:
- Outstanding Balance - sum of invoice balances where the customer owes the merchant
- Customers Outstanding - distinct count of customers with outstanding invoices
- Outstanding Invoices - count of invoices with outstanding balances
The top right of the UI contains the Aging Period graph which breaks down your outstanding balances by aging bucket. You can toggle between seeing a sum of the balance or a count of invoices.
If you are using multicurrency, Outstanding Balance at-a-glance and the Aging Period graph are shown in the Site primary currency.
Further down, you will find the Invoice List which details all of your outstanding invoices.
We show any unapplied credits or prepayments at the end of the row. To apply it, you need to open the invoice page and “Record Payment”. You can navigate to an invoice by clicking on the invoice number (e.g. INV-123).