How to Generate Account Statements by Location, Project, Customer, Supplier, or Product

How to Extract a Customized Account Statement by Location (Branch) or Project

You can extract an account statement for any accounting account so that it displays only transactions linked to a specific location (branch) or project, using the filter options within the account statement report.

This report is useful if you want to know:

• Bank movements for a specific branch

• Expenses for a specific project

• Revenue for a specific location

• Account transactions linked to a project only

Before You Start: Important Points to Understand Filtering

• All accounting transactions in the system can be linked to:

  • A location (branch / warehouse)

  • A project

• Projects are optional for all transactions.

• Locations are mandatory for transactions that depend on inventory, such as:

  • Sales invoices

  • Purchase invoices

• Vouchers and manual accounting entries: linking the location or project is optional.

️ When filtering by location or project:

Any transaction that was not linked to the location or project will not appear in the report.

Steps to Extract an Account Statement by Location or Project

1. Go to Reports from the main menu.

2. Select the Account Statement report.

3. Select:

   • The desired account (for example: bank, expense, revenue).

   • The time period.

4. Go to Filter Type.

5. Choose one of the following filter options only:

   • Projects

   • Branches and Warehouses (Locations)

   • Customers

   • Suppliers

   • Employees

   • Products

   • Fixed Assets

   • Additional Fields

6. After selecting the filter type, you must select the value associated with it:

   • Example: when you select (Projects) → you must select the project.

7. Click Search.

The account statement will appear and contain only transactions:

• Linked to the selected account

• And linked to the specified location or project

Very Important: Why the Report Appears Empty

The report may appear empty in the following cases:

• A filter type was selected (such as customers or projects)
  without selecting a specific value next to it.

• The transactions are not linked to a location or project in the first place.

• A time period was selected that contains no transactions.

Solution:

• Either select the desired value next to the filter type

• Or remove the filter type entirely and search again

How Does Filter Logic Work?

• You can select only one filter type at a time.

• When you select:

  • Location + Project
    → The report displays only transactions linked to both simultaneously.

• Transactions linked to only one of them will not appear.

What Appears in the Account Statement?

The report displays all transactions that were reflected on the selected account, whether they resulted from:

• Invoices

• Vouchers

• Manual accounting entries

• Automatic entries

The account statement appears with the following columns:

• Date

• Account

• Transaction Type

• Transaction Description

• Reference (Invoice / Voucher / Entry Number)

• Debit

• Credit

• Balance

• Project

Example:

If 200 riyal was deposited into the bank account via a customer voucher,
it will appear in the account statement with the transaction date and the voucher reference number.

Permissions and Their Impact on the Report

• The user only needs the permission:
  View Account Statement Report
  from:
  Settings → Users → Manage Roles → Reports → Account Statement

• If the user does not have permission for a specific location or project:

  • The data will appear in the account statement.

  • But the user will not be able to open the invoice or its details.

Exporting the Account Statement

• You can export the report in the format of:

  • Excel

  • PDF

• When exporting:

  • The file is sent to the email address of the user who performed the export.

  • The file contains the same columns visible in the report within the system.

Common Keywords for Inquiries

• I need to know bank transactions from a specific branch

• How do I get an account statement for a specific project

• Why is the account statement showing as empty?

• How do I filter the account statement by branch

• I want to see expenses for a specific project

• How do I pull an account report for one location