Reports
Customer statement of account
Last updated Tuesday, October 15, 2024
A customer Statement of Account shows a history of invoices issued and payments received from a customer.
What this report shows
A customer statement of account allows you to:
- See all the transactions that took place between you and your customer for a given period of time.
- Provide your customer with a summary of the product and services you have billed them.
- Confirm customer payments that have been made in the chosen time frame.
- Send reminders for amounts that your customer still owes you for sales that were placed on credit in that period of time.
Step-by-step instructions
To see a customer's Statement of Account:
- Go to
Reports
in the left side menu, then go toAll Reports
. - Choose
Customer Statement of Account
under theSales
section. - From the
Filter
drop-down, choose the date range. - Download the statement in PDF or Excel to share it with your customer.
Meaning of each column in the report
Column | Description |
---|---|
Currency | The currency of the transactions. |
Account | The names of the accounts you filtered by. |
Date | The dates of the transactions are sorted from oldest to newest. |
Activity | The details of the transactions such as an invoice creation or payment. |
Debit | This shows the amount debited to the account during a transaction. |
Credit | This shows the amount credited to the account during a transaction. |
Balance | This shows the cumulative balance of the amounts credited or debited. Since the Accounts Receivable account is an asset account, a positive balance represents the amount that the customer owes you, and a negative balance shows the amount of money you owe the customer. |
Debit/Credit/Balance in the base currency | When you issue transactions to your customer in a foreign currency, you will be able to see the statement of account in the chosen foreign currency and their equivalence in the base currency. |
A contact that is your vendor and customer simultaneously
To view your sales and purchases with a contact, filter your Account
list with both the Account Receivable
and the Account Payable
accounts. This will allow you to see transactions of sales and purchases made with the same contact.
Exporting the Statement of Account
To export the Statement of Account, click on Export results and choose the format of your export.