Prepare an open-item customer statement in Acumatica

Confirm the customer uses Open Item statements before preparing their statement in Acumatica. An open-item statement reflects items open at the statement date, so payments posted later can explain a difference from today’s balance.
Upload a case

Key facts

For one Open Item customer, use Generate on Demand. In Statement History, select the dated On-Demand Statement and use Print Statement to inspect it.

Confirm the statement type and the account

Open the customer record. Check Statement Type on the Billing tab and Statement Cycle ID on the Financial tab. Open Item reflects the documents open at the statement date. Balance Brought Forward starts with the previous statement balance. Acumatica’s Customers form reference describes the options.

Prepare and inspect the statement

For a scheduled run, open Prepare Statements (AR503000), set Prepare For, select the statement cycle and choose Process. Check the customer name, statement date and document references from Statement History before processing the batch in Print Statements (AR503500). See Acumatica’s scheduled statement activity.

Explain a missing invoice before emailing

If payment closed an invoice on or before the statement date, the open-item statement can omit that closed document. If the buyer asks why the current balance differs from the statement, send the statement date and the matching later transactions or a short reconciliation. Use the receivables reconciliation template if there are several differences.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.