Reports
Customer statement of account
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
Reportsin the left side menu, then go toAll Reports. - Choose
Customer Statement of Accountunder theSalessection. - From the
Filterdrop-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.