Customer statement of account
You can use the Customer Statement report in Wafeq to view all financial transactions related to your customers and see the outstanding balance, whether it's due from the customer or owed to them. This guide walks you through how to access the report, explains the key columns, and shows how to use the report to support collection and follow-up.
Viewing the Customer Statement
Click Reports from the main menu, then click Customer Statement of Account under the Sales section.
You'll find the Customer Statement report showing your customers’ transactions, including the following details:
- Date: The transactions' dates, listed from oldest to newest.
- Serial Number: A system-generated internal reference used to track the transaction within Wafeq.
- Source: Indicates the type of document related to the transaction (such as an "Invoice", "Advance Payment", or "Credit Note"). Clicking on it will open the document.
- Activity: Represents the nature of the transaction and is generated automatically.
- Reference: Shows the reference number entered when creating the related accounting document (like the invoice or payment reference).
- Project: The name of the project linked to the transaction.
- Debit: The amount added as a receivable from the customer, shown in the original transaction currency.
- Credit: The amount paid by the customer or recorded as an advance, considered a liability on your side, is shown in the original currency.
- Debit (SAR): The same "Debit" value, but converted into Saudi Riyals (the account's currency).
- Credit (SAR): The same "Credit" value, converted into Saudi Riyals.
- Balance (SAR): The cumulative running balance after each transaction, indicating what the customer owes (positive value) or what you owe them (negative value).
The cumulative balance evolves with each transaction; every row is considered the most recent at the time of entry. To view the full outstanding balance, refer to the most recent transaction or check the "Total Activity and Balance" row at the bottom of the report.
The cumulative balance evolves with each transaction; every row is considered the most recent at the time of entry. To view the full outstanding balance, refer to the most recent transaction or check the "Total Activity and Balance" row at the bottom of the report.
Filtering the Customer Statement
To control what appears in the report, click on the Filter button, then select a specific date range, project, employee, or any other filtering criteria you wish.
Finally, click Apply.
When you choose a time period using the filter, the report will only show the transactions that occurred during that timeframe. If the customer had any earlier transactions outside the selected range, they will not appear in detail. Instead, a row labeled "Opening Balance" will be shown at the top of the report, reflecting the balance carried forward from previous periods.
When you choose a time period using the filter, the report will only show the transactions that occurred during that timeframe. If the customer had any earlier transactions outside the selected range, they will not appear in detail. Instead, a row labeled "Opening Balance" will be shown at the top of the report, reflecting the balance carried forward from previous periods.
Example:
Example:
Let’s say the customer had an unpaid invoice in January worth SAR 2,000, and you filtered the statement to show only February. You won’t see the original invoice itself, but the statement will show an opening balance of SAR 2,000 at the top—representing the outstanding amount still due at the start of the filtered period.
Viewing a Specific Customer's Statement
To view the statement for a specific customer only, use the Contact field in the filter panel and select the desired customer. The report will then display that customer’s transactions exclusively.
In this example, the customer has two invoices:
In this example, the customer has two invoices:
- The first (older) invoice is for SAR 5,000, and since there were no prior transactions, the customer’s balance becomes SAR 5,000.
- The second (newer) invoice is for SAR 5, bringing the customer’s total outstanding balance to SAR 5,005, as no payments have been recorded yet.
- At the bottom of the report, you’ll find the total activity and balance, which tells you the overall amount owed by the customer (if positive) or to the customer (if negative).
Note the following example:
Note the following example:
There is a large advance payment made by the customer that exceeds their outstanding dues. As a result, the total activity and balance appear as a negative value, indicating that you owe the customer this amount at this point in time.
Exporting the Customer Statement
Click the Export button within the report screen, then choose the desired format from the dropdown menu—whether you want to download the statement as a PDF, Excel, or any other supported format.
![New Product Features [March-2023]](https://firebasestorage.googleapis.com/v0/b/wafeq-docs.appspot.com/o/medias%2Fd68397dc_Help Center - EN Article Cover-22.png?alt=media)
.png?alt=media)
