A Customer Statement gives a clean overview of a contact's transactions and outstanding balances within a selected period.
It's available as both a PDF and an Excel (.xlsx) file.
Go to Contacts → Select a Contact → Download Icon → Customer Statement → Choose a period
This generates two files: a PDF and an .xlsx file, both covering the selected period.
Shows currency-wise activity for the selected period. Transactions in different currencies (e.g. PHP, USD) are shown in separate sections.
Each currency section starts with an opening balance: the balance due from outside the selected period.
Lists all invoices, payments made against invoices, credit notes, and refunds that fall within the selected period.
Gives a quick overview of total outstanding balances for each currency.
The Summary of Balances table breaks down outstanding balances into aging periods.
The Outstanding Balances table lists all outstanding invoices and unapplied or partially applied credit notes, along with their original amount and balance due.
Note: The Statement of Balances only appears in the PDF. It is not included in the .xlsx file.
Yes. Regardless of the contact's default currency, all transactions appear in their original currency in the Customer Statement.
Go to Contacts → Select a Contact → Email Icon → Send
The Customer Statement is attached to the email automatically.
Select the contacts you want to send statements to.
Choose Send Email from the bulk actions menu.
