---
title: "Statement"
slug: "statement-report"
updated: 2026-03-03T04:13:30Z
published: 2026-03-03T04:13:30Z
canonical: "zenoplesupport.aqore.com/statement-report"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://zenoplesupport.aqore.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Statement

# **Summary**

The **Statement** Report provides a customer-level view of all outstanding invoices, helping finance, billing, and branch teams monitor unpaid balances and manage accounts receivable effectively. By organizing open invoices by customers and categorizing balances into aging buckets, the report makes it easy to identify past-due accounts, track payment behavior, and prioritize collection efforts.

Its standout feature is the flexible **Include** filter, which allows teams to view **all invoices with outstanding balances**, **past-due only**, or **all invoices including zero balances,** without running separate reports. Combined with the optional **Unapplied Cash** section, it ensures complete AR visibility in a single run.

This report is essential for:

1. **Finance & Accounting:** validating invoice balances, finance charges, and unapplied payments before financial close.
2. **Payroll & Billing Teams:** reconciling billing and accounts receivable totals.
3. **Branch Managers:** identifying overdue customer accounts and managing customer collection follow-ups.

By using this report, staffing companies gain complete visibility into accounts receivable, enabling faster collections, more accurate financial reporting, and stronger client payment accountability.

# **Report Overview**

| **Attribute** | **Details** |
| --- | --- |
| **Purpose** | Provides a customer-level view of all outstanding invoices organized by the customer. It can be filtered for a specific customer, filtered to show only past-due invoices, or include all invoices with balances, with an option to include unapplied payments for accurate reconciliation. |
| **Classification** | Business-Critical Report |
| **Who Should Use This Report** | Finance and Accounting, Payroll and Billing Teams, Branch Manager |
| **Business Problem Solved** | Helps monitor unpaid customer balances by clearly displaying all open invoices organized by the customer. Teams can quickly identify overdue accounts, prioritize collection efforts, and maintain accurate accounts with receivable records. |
| **Run Frequency** | Weekly, bi-weekly, or monthly to review outstanding customer balances and enhance collection efforts. |
| **Related Reports** | Customer Invoice Summary, Customer AR Payment, Client Billing |

## **Business Value**

| **Category** | **Description** |
| --- | --- |
| **Accounts Receivable Overview** | Review outstanding customer balances by clearly displaying all open invoices grouped by customer, including invoice amount, amount paid, and balance due. |
| **Aging & Past-Due Analysis** | Identify past-due accounts using aging buckets: Current, 1–30, 31–60, 61–90, and Above 90 days — so teams can prioritize collections effectively. |
| **Payment Behavior Monitoring** | Assist branch managers and finance teams in monitoring customer payment behavior, tracking overdue trends, and reducing outstanding receivables. |
| **Customer-Level Financial Visibility** | Provide customer-specific financial views by filtering the report for a single customer, past-due invoices only, all balances, or all including zero-balance invoices. |
| **Payment Reconciliation** | Reconcile unapplied payments against outstanding invoices to ensure accurate accounts receivable reporting and prevent reconciliation gaps. |

## **Known Issues or Limitations**

| **Issues** | **Description** |
| --- | --- |
| Statement Report does not reflect updated payment terms from the customer's service profile | When payment terms are updated in the Service Profile, previously issued invoices (e.g., originally showing Due on Receipt) do not automatically update to the new terms (e.g., Net 30). As a result, regenerated invoices and Statement Reports continue to display the outdated terms. |
| Finance charges are not included in Invoice Amount | Finance charges are tracked separately. The Balance Due formula accounts for them (Invoice Amount + Finance Charge − Amount Paid), but the Invoice Amount column displays only the original billed amount. |

## **Troubleshooting Guide**

| **Issues** | **Problem Reason** | **Solution** |
| --- | --- | --- |
| Missing Invoice or Customer Data | Data visibility may be impacted by restrictive filters or limited user access. | Review the selected office and customer filters and confirm that you have the appropriate access to the relevant office or customer. |
| Past Due values showing as negative | Negative past due days mean the invoice is not yet overdue — the due date is in the future. | Shows how overdue an item is**.** A negative number means it’s not due yet, zero means it’s due today, and a positive number means it is past due. It simply counts the days between the due date and today. |
| Unapplied payment not showing | The 'Include Unapplied Cash' parameter is set to No. | Set the Include Unapplied Cash parameter to Yes to display unapplied payment amounts. |
| Zero Balance invoices not visible | The Include filter may be set to All (balances only) or Past Due Only. | Change the Include parameter to 'All with Zero Balance' to include fully paid invoices in the report. |

## **FAQ**

| **Questions** | **Answers** |
| --- | --- |
| Can I see a statement for just one customer? | Yes. Enter the Customer Id or Customer name parameter to filter the report to a single customer. The Customer Id takes precedence when provided. |
| What is the difference between the three 'Include' options? | 'All' shows all invoices with an outstanding balance. 'All with Zero Balance' shows all invoices including fully paid ones. 'Past Due Only' shows only invoices where the due date has passed and a balance remains. |
| How is the aging bucket determined? | Aging buckets are based on the number of days between the invoice Due Date and today. Current = 0 or fewer days past due; 1–30, 31–60, 61–90 = overdue ranges; Above 90 = severely overdue. |

## **Reference Video/Screenshot**

![](https://cdn.document360.io/f6cab4f2-9572-4cd7-96b4-39b941f22824/Images/Documentation/statement-image-dg923dxk.png)

# **Report Details**

| **Category** | **Value** |
| --- | --- |
| **Parent Category** | Back Office |
| **Category** | Invoice |
| **Report** **Type** | Paginated Report |
| **Report runs from Application** | RMS |
| **Report** **Category**: | Shareable |
| **Report Level** | Invoice |

## **Report Parameters**

| **Report Parameter** | **Description** | **Parameter Options** | **Default** | **Required** |
| --- | --- | --- | --- | --- |
| Customer Id | Filters records by the internal Customer Id (Organization Id). When provided, it takes precedence over Customer name. | Free text to enter numeric value | 0 | Yes |
| Customer | Filters records by customer name using a wildcard match. | Text wildcard | % | No |
| Include | Determines which invoices are included in the report based on balance status. | All / All with Zero Balance / Past Due Only |  | Yes |
| Include Unapplied Cash | When enabled, the report shows a separate section per customer for payments received but has not yet applied to any invoice. | Yes / No | Yes | Yes |

## **Report Grouping**

The report is not grouped, as the statement report is generated for a single client and includes only that client’s details.

## **Report Columns**

| **Report Column** | **Description** | **Definition/Logic** |
| --- | --- | --- |
| Invoice Date | Date the invoice was issued. | The date the invoice was created. |
| Due Date | Date payment is due for the invoice. | The date the payment is due, based on the customer’s payment terms when the invoice was created. |
| Past Due | Number of days from the due date. Positive = overdue; 0 = due today; negative = not yet due. | How many days have passed since the due date. If the invoice is fully paid, this is shown as 0. |
| Invoice Number | Unique identifier for the invoice. | The unique number assigned to the invoice. |
| Invoice Amount | Total amount billed on the invoice. | The total amount billed on the invoice, not including finance charges. |
| Amount Paid | Total amount paid against the invoice. | Calculated as Invoice Amount – Balance. |
| Balance Due | Outstanding amount remaining on the invoice. | Invoice Amount + Finance Charge − Amount Paid. The remaining amount still owed on the invoice. This includes any finance charges and subtracts payments made. |
| Current | Invoice balance that is not yet overdue (past due days ≤ 0). | Balance Due where Age ≤ 0; otherwise, 0. |
| 1–30 Days | Balance overdue by 1 to 30 days. | Balance Due where Age BETWEEN 1 AND 30; otherwise, 0. |
| 31–60 Days | Balance overdue by 31 to 60 days. | Balance Due where Age BETWEEN 31 AND 60; otherwise, 0. |
| 61–90 Days | Balance overdue by 61 to 90 days. | Balance Due where Age BETWEEN 61 AND 90; otherwise, 0. |
| Above 90 Days | Balance overdue by more than 90 days. | Balance Due where Age > 90; otherwise, 0. |
| Total | Total outstanding balance for the invoice. | Sum of due balances — equivalent to the sum of all aging buckets for the invoice. |
| Payment Date | The date where payment was received against the invoice. | Pulled from the payment/receipt record associated with the invoice. |
| Unapplied Payment | Payment amount received but not yet applied to any invoice. | Displayed only when Include Unapplied Cash = Yes. Pulled from cash receipts where the payment has not been matched to an invoice. |

## **Additional Notes**

| The report pulls the most recent finance charge record per invoice (ranked by Finance Charge Date DESC). If no finance charge exists, it defaults to 0 and is added to the balance calculation. |
| --- |
| When a corrected invoice exists, the report populates the balance from the corrected invoice record even if the original invoice has a zero balance — ensuring an accurate outstanding balance of reporting. The Remit To section on the statement uses the Funding Organization if one is linked to the customer; otherwise, it defaults to the customer's own organization and address. |