Skip to content
Contact Us
الميزان دوت نت للمحاسبة والمستودعات
  • Home
  • About the Software
    • About Us
    • Our Clients
  • Products
  • Services
  • Learning
    • Knowledge Base
    • Video Tutorials
  • Blog
  • Downloads
    • Al Mizan .NET
    • Updates
    • Utilities
  • العربية
  • Home
  • About the Software
    • About Us
    • Our Clients
  • Products
  • Services
  • Learning
    • Knowledge Base
    • Video Tutorials
  • Blog
  • Downloads
    • Al Mizan .NET
    • Updates
    • Utilities
  • العربية
  • Home
  • About the Software
    • About Us
    • Our Clients
  • Products
  • Services
  • Learning
    • Knowledge Base
    • Video Tutorials
  • Blog
  • Downloads
    • Al Mizan .NET
    • Updates
    • Utilities
  • العربية

User Guide

  • Knowledge Base
  • Accounting Menu
    • Chart of Accounts and Account Cards in Al Mizan
    • Define Customer and Supplier Records
    • Budgets and Their Uses
    • Account-Specific Analysis in Al Mizan
    • Transfer Account Transactions in Al Mizan
    • Account Analysis: General Analysis
    • Allocation Accounts in Al Mizan
    • Aggregate Accounts
    • Allocate Accounts to Cost Centers
    • Closing Accounts in Al Mizan
  • Accounting Reports
    • Receivables and Payables Aging Report in Al Mizan
    • Customer Balances Report in Al Mizan
    • Customer Statement Report in Al Mizan
    • General Ledger Report in Al Mizan
    • Trial Balance Report in Al Mizan
    • Most Active Customers Report
    • Inactive Customers Report in Al Mizan
    • Journal Daybook Report in Al Mizan
    • Account Transaction Analysis Report in Al Mizan
    • Budget Report
    • Monthly Account Transactions Report
    • Closing Accounts Report in Al Mizan
    • Cost Center Ledger Report
    • Permissions Report: Options and Uses
    • Chart of Accounts Report
  • Archiving
    • Archiving Module in Al Mizan .NET
  • Definitions Menu
    • Invoice Type Settings in Al Mizan
    • Sales Representative Invoice Commissions in Al Mizan
    • Cost Centers in Al Mizan
    • Define Custom Journal Vouchers in Al Mizan
    • Define Commercial Paper Types in Al Mizan
    • Sales Representatives: Journal Entry Commissions
    • Define Branch Records and Configure Their Options
    • Payment Methods in Al Mizan
    • Define the Currency Exchange-Rate Schedule
    • Define Currencies and Configure Their Options
    • Define Bank Records in Al Mizan
    • Define Warehouse Records and Configure Their Options
  • Features
    • Start Page Settings and Panels in Al Mizan
    • Database Rollover in Al Mizan
    • Processing Import Transactions
    • Use Al Mizan Functions in Excel
    • Configure Perpetual Inventory in Al Mizan
    • Define and Use an Item Independent Unit
    • Use Item Subinventory in Invoices
    • Report Toolbar Options
    • Import Items and Accounts from Excel
    • Audit Log: Options and Uses
    • Task List: Options and Uses
    • Design Page and Report Headers and Footers
    • The Calculator in Al Mizan
  • File Menu
    • Delete a Database in Al Mizan
    • Create and Restore a Database Backup
    • Create and Set Up a New Database
    • Attach Database Files
  • Financial Statements
    • Financial Statements in Al Mizan
  • Fixed Assets
    • Fixed Asset Management in Al Mizan
  • Inventory Reports
    • Detailed Invoice Transactions Report
    • Item Inventory Report: Options and Uses
    • Minimum and Maximum Item Levels Report
    • Customer Transactions by Item Report
    • Item Expiry Dates Report
    • Horizontal Item Inventory Report: Options and Uses
    • Item Transaction Analysis Report: Options and Uses
    • Free Units Inventory Report: Options and Uses
    • Total Transactions Report for Items and Categories
    • Item Transactions Report: Options and Uses
    • Monthly Item Transactions Report
    • Inactive Items Report: Options and Uses
    • Invoice Line Profit Report
    • Most Profitable Items Report
    • Most Active Items Report
    • Invoice Profit Report
    • Invoice Totals Report: Options and Uses
    • Serial Number Inventory Report
    • Item and Category Profit Report
    • Quotation Comparison Report
    • Serial Number Transaction Report
    • Item List Report in Al Mizan
  • Invoices Menu
    • Detailed Invoice Fields and Settings in Al Mizan
    • Manage Invoices
  • Items Menu
    • Item Accounting Groups in Al Mizan
    • Define Item Cards and Categories in Al Mizan
    • Item Barcode Schemas in Al Mizan
    • Invoice Operations in Al Mizan
    • Compare Warehouse Stocktakes
    • Update Item Prices
    • Carried-Forward Item–Branch Statistics
    • Carried-Forward Item–Customer Statistics
    • Manage Items in Al Mizan
    • Transfer Item Transactions
    • Minimum and Maximum Item Levels
    • Arrange Invoices in Al Mizan
    • Update Information for a Group of Items
  • Journal Entries Menu
    • Use Custom Journal Vouchers in Al Mizan
    • Process Commercial Papers in Al Mizan
    • Define and Use Commercial Papers in Al Mizan
    • Manage Currency Exchange Differences
    • Manage Custom Journal Vouchers
    • Manage Journal Vouchers in Al Mizan
    • Journal Operations in Al Mizan
    • Enter Journal Data and Configure Entry Settings
  • Manufacturing
    • Manufacturing Management in Al Mizan
  • Orders
    • Order Management in Al Mizan
  • Permissions Menu
    • Permissions: Options and Uses
    • Posting Policies in Al Mizan
    • Field Permissions in Al Mizan
    • Confidentiality Levels and Password Changes
  • Point of Sale
    • Point of Sale in Al Mizan
  • Real Estate
    • Real Estate Management in Al Mizan
  • Tools Menu
    • General Program Settings in Al Mizan .NET
    • Print Designer in Al Mizan
    • Advanced Print Designer Properties
    • Manage Print Design Groups
  • Training Courses
    • Training Course Management in Al Mizan
Show Categories
  • Home
  • Knowledge Base
  • User Guide
  • Accounting Reports
  • Customer Statement Report in Al Mizan

Customer Statement Report in Al Mizan

This report provides detailed transactions for customers and suppliers. Unlike the General Ledger, which shows invoice totals, it can display the invoice item lines affecting the customer or supplier account. The criteria window also provides the following options:

Illustration: Customer Statement report in Al Mizan

.

Conditions: #

  • Customer AccountSelect the customer or supplier account to report. You can enter a
  • subaccount such as Tareq or a parent account such as Customers, as described in the General Ledger guide.
  • Customer: Instead of selecting the account directly, choose the customer name from its customer record. The list includes names for accounts with customer records.
  • Cost Center: Select a cost center to include customer account transactions allocated to it.
  • From Date / To Date: Specify the report date range.
  • From Reconciliation Date: Enable this option to display a detailed statement beginning on the day after the reconciliation date recorded in the account record.
  • Description Contains, Description Does Not ContainThese filters apply to invoice and journal entry descriptions, as described in the General Ledger guide.

Data Sources: #

Select the transaction sources to include. For example, selecting only Invoices displays the account’s invoices without journal entries, commercial papers or other sources.

Branches: #

Select the branches to include, such as Tareq’s transactions in the Aleppo branch.

Transaction Currencies: #

Select the currencies to include, such as Tareq’s transactions recorded in Syrian pounds.

Currency: #

Select the currency in which the report should be displayed.

Exchange Rate: Specify the exchange rate relative to the base currency. This is available only for a secondary currency and offers two choices.

  1. Use the Exchange-Rate Schedule: Retrieve exchange rates automatically from the schedule, using the rate applicable on each transaction date.
  2. Use a Specified Exchange Rate: Enter a rate in the field that appears and use it to display the report.
  • Use the Scheduled Currency Rate Instead of the Transaction Rate: Use the rate from the exchange-rate schedule instead of the original transaction rate. This option is used when requesting the report in the base currency.

Customer Fields: #

Customer record fields such as name, telephone and fax can be displayed in the report header, separately from the main transaction fields.

Invoice Fields: #

Select invoice line fields such as quantity and unit price, and invoice header fields such as number, subnumber and date.

Item Fields: #

Select fields from the item record, such as item name, category and accounting group.

Options: #

The options include:

  • Show Sequence Number: Enable this option to display sequential transaction numbers.
  • Finalized Invoices, Unfinalized Invoices: Enable the required options to choose which invoices appear in the statement.
  • Posted Entries, Unposted Entries: Enable the required options to choose which journal entries appear in the statement.
  • Ignore Opening Entries: Enable this option to exclude opening entries. For example, an opening entry balance for the customer will be omitted from the report.
  • Hide Cash InvoicesMost customer account transactions involve credit invoices. A cash invoice may identify the customer while its accounting entry uses Cash rather than the customer account. Such invoices can still appear in the customer statement without changing the customer’s balance. Enable this option to hide them.
  • Show Previous Balance: Enable this option to bring forward the balance of transactions preceding the report’s start date when reporting from a date after the accounting period began.
  • Show Balance: Enable this option to display a running Balance column after every invoice, journal entry or other transaction.

Currency Options: #

  • Show Original Currency (Debit, Credit, Currency, Exchange Rate): This option displays four columns showing each transaction’s debit amount, credit amount, currency and exchange rate as originally recorded.
Illustration: currency options

.

  • Use Account Nature for the Balance Sign: By default, debit balances are positive and credit balances are negative. Enable this option to display balance signs relative to the nature defined in the account record.

Note: Account Nature has three options: Debit, Credit or Both. If the user selects Both, its balance sign is treated in the same way as Debit.

Description Options: #

  • Append Transaction Description: Enable this option to add a column showing the invoice, journal entry or other transaction description.
  • Append Entry Header Description: Enable this option to add the journal entry header description to the Transaction Description column.
  • Merge Transaction Description with Description: This option combines transaction and entry header descriptions with the main Description field in one column. It saves printing space while preserving the information, as shown below: 
Illustration: description options

.

  • Show Invoice Sales Representative: Enable this option to display the representative associated with the invoice.

Merge Options: #

  • Combine Gifts with Quantity: Enable this option to combine the main quantity and free units in the Quantity column.
  • Merge Discount with Total: Assume Mahmoud buys fabric for 30,000 lira and receives a discount of 3,000. Without this option, the discount appears separately in Credit because it reduces the customer’s debit balance, as shown below:
Illustration: merge options

.

With this option enabled, the discount is deducted from the invoice total, as shown below:

Illustration: merge options

.

  • Merge Addition with Total: Assume Mahmoud buys fabric for 29,950 lira and the invoice is rounded up to 30,000. Without this option, the 50-lira addition appears separately in Debit because it increases the customer’s debit balance. With this option enabled, the addition is included in the invoice total.
  • Merge VAT with Total: The same display principle applies to VAT.
  • Combine Item Code and Name: When Item Code and Item Name are both selected, enable this option to combine them in one field, as shown below:
Illustration: merge options

.

Show Unpaid Invoice Amount: For a credit invoice, the customer may pay part of the amount through the invoice’s Payment field. Enable this option to display the remaining unpaid amount. 

Print Each Account on a Separate Page: When reporting on a parent account such as Customers, all customer accounts appear in one report. Enable this option to print each account on a separate page rather than sharing pages.

Commercial Paper Options: #

Use Commercial Paper Due DateEnable this option to display commercial papers by due date rather than issue date. If disabled, their issue date is used.

Show Commercial Paper Due Date: Enable this option to display the paper’s due date.

Hide Collected Papers: Enable this option when collected customer papers should be omitted.

Display Options: #

Show Accounts with No TransactionsEnable this option when reporting on a parent account to include accounts that have never had transactions.

Show Zero-Balance Accounts: Enable this option when reporting on a parent account to include accounts that have had transactions but now have a zero balance.

Show Branch: Enable this option to display the branch associated with each transaction.

Use Item Print NameEnable this option to use the item’s print name in the Description field instead of its standard name.

Hide Customer Account Code: Enable this option to hide the account code from the statement header.

Hide Invoice Payment MethodEnable this option to omit the payment method from the Description field.

 Show Monthly TotalsEnable this option to add a month-end row showing each month’s total debits, credits and balance.

Show Since Last Zero Balance: Enable this option to display transactions after the customer account’s most recent zero balance.

Merge Additional Taxes with Total: Assume Mahmoud buys fabric for 30,000 lira with additional taxes of 3,000. Without this option, the taxes appear separately in Debit because they increase the customer’s balance. With this option enabled, they are included in the invoice total.

Report Footer: #

Show: Display the report using the preceding conditions.

Print: Click this button to print the final report.

Close: Close the report conditions window.

Practical examples of information available from the Customer Statement report:

  • A detailed customer or supplier statement through the current balance.
  • Sales invoices issued to a particular customer.
  • Purchase invoices from a particular supplier.
  • Print statements for all customers in one operation.
  • Payments received from a particular customer.
  • Payments made to a particular supplier.
  • A statement from the start of April with the balance from the first three months brought forward.
  • A customer statement for transactions with a particular company branch.
  • A statement in the base currency or another currency defined in the database.
  • A customer statement from the most recent reconciliation date recorded in the account.
  • A detailed statement of transactions allocated to a specified cost center.

.

See the General Ledger report section.

Follow our YouTube channel

Share This Article

  • Facebook
  • X
  • LinkedIn
  • Pinterest
Could not find what you need? Contact us

How can we help you?

Updated on October 2, 2026
Customer Balances Report in Al MizanGeneral Ledger Report in Al Mizan

Powered by BetterDocs

Contents
  • Conditions:
  • Data Sources:
  • Branches:
  • Transaction Currencies:
  • Currency:
  • Customer Fields:
  • Invoice Fields:
  • Item Fields:
  • Options:
    • Currency Options:
    • Description Options:
    • Merge Options:
    • Commercial Paper Options:
    • Display Options:
  • Report Footer:
Mizan logo black1

Al Mizan .NET Accounting and Inventory: take the next step toward more effective business management

Quick Links

  • Knowledge Base
  • Privacy Policy (Arabic)
  • Terms and Conditions (Arabic)
  • Contact Us

Stay Informed

Get the latest news and offers from our website 

  • Abdurrahman Nafiz Gürman, No:05
    Güngören/İstanbul
  • +905360652643
  • info@hadarasoft.net
© 2026 Hadarasoft
Instagram Facebook-f Youtube
Need help? Contact us