How to Generate a Customer Statement and Check Balance: Difference Between Account Statements and Customer Reports (with Projects and Currencies)

How to Extract a Customer Statement

You can easily extract a customer statement from the system in two different ways, depending on the type of report and the details you need.

Method 1: Customer Statement Report

This method is suitable if you need invoice and payment details with additional information such as payment method and projects.

Steps to Extract the Report

1. Go to:

   • Dropdown menu → Reports → Customer Statement Report

2. Select Customer

   • You can select only one customer at a time

   • You can search by customer name or reference number

3. Set the start and end dates

4. Click Filter

Data Displayed in the Report

• Document Type

• Transaction Date

• Document Number

• Debit Amount in Local Currency

• Credit Amount in Local Currency

• Remaining Amount in Local Currency

• Debit Amount in Foreign Currency

• Credit Amount in Foreign Currency

• Outstanding Balance

• Payment Method

• Due Date

• Project Name

Totals at the Bottom of the Report

• Total Invoices in Local Currency

• Total Payments in Local Currency

• Outstanding Balance in Local Currency

• Total Invoices in Foreign Currency

• Total Payments in Foreign Currency

• Outstanding Balance in Foreign Currency

Export

• You can export the report to:

  • Excel

  • PDF

Method 2: Account Statement

This method is suitable if you need a comprehensive accounting report or need to extract a statement for multiple customers.

This report shows you all transactions related to the customer during the period you specify, and starts with the opening balance (which is the total balance before the start of the period).

After that, all operations appear in a clear table, such as:

• Vouchers

• Invoices

• Credit Notes

• Manual Entries

And for each operation, it will show you:

• Date

• Operation Type

• Description

• Reference Number

• Amount Debit or Credit

• Balance After Operation (cumulative)

• Project (if any)

And at the end of the report, you will find:

• Total Debit

• Total Credit

• Net Movement During the Period (debit or credit)

• Closing Balance

Steps to Extract the Report

1. Go to:

   • Dropdown menu → Reports → Account Statement

2. Select Account:

   • Accounts Receivable

3. From Filter Type, select:

   • Customers

4. From Filter Options, select the customer name (or multiple customers).

5. You can select the project (optional if you need the report for a specific project)

6. Click Search

7. You can export the report to:

   • Excel

   • PDF

Important Notes

• Customer Reference Number:

  • Does not appear when printing or exporting the account statement

  • Can be added manually when exporting to Excel

• You can extract a statement for multiple customers only through the Account Statement

• In the Account Statement:

  • You cannot use more than one filter type at the same time

  • Example: You cannot filter customer + location together

• Alternative solution to filter customer by location:

  • Go to Sales Invoices

  • Filter by customer name + location

  • Export the results to Excel

• Currency:

  • Account Statement: displays data in the company’s primary currency only

  • Customer Statement Report: displays:

    • Invoices and payments in local currency

    • and invoices and payments in foreign currency

Difference Between Account Statement and Customer Statement Report

1) Financial Data

• Account Statement:

  • Displays the full balance

  • Includes the opening balance

  • Covers all transactions

• Customer Statement Report:

  • Displays transactions during the specified period

  • and if no period is specified, it displays the full balance

2) Type of Transactions

• Account Statement:

  • Manual accounting entries

  • Receipts and disbursement vouchers

  • Invoices

  • Credit notes

• Customer Statement Report:

  • Sales invoices

  • Receipt vouchers

  • Credit notes

  • Does not display manual entries

3) Additional Details

• Customer Statement Report:

  • Payment method

  • Due date

• Account Statement:

  • Does not display these details

4) Currency

• Account Statement: Company currency only

• Customer Statement Report: According to invoice currency (local and foreign)

5) Number of Customers

• Account Statement: Multiple customers

• Customer Statement Report: Single customer only

When Should I Use Each Report?

• Use Account Statement if:

  • You need a comprehensive accounting report

  • You want all transactions (manual and automatic)

  • You track the actual balance accounting-wise

• Use Customer Statement Report if:

  • You need invoice details only

  • You care about payment method and projects

  • You need display according to invoice currency

Search Keywords

• I want a customer statement

• How can I generate a statement for a specific customer?

• I need a report with customer transactions

• Where can I find a customer statement?

• How can I check the current customer balance?

• Can I send a statement to the customer?

• How can I find sales invoices that weren’t assigned to a project?

• Sales report for a group of customers