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
  • Receivables and Payables Aging Report in Al Mizan

Receivables and Payables Aging Report in Al Mizan

This report displays debit or credit balances, their age and the transactions to which they relate. Open Reports / Advanced Accounting Reports to request it.

The main criteria window contains the following options:

Illustration: Aging report in Al Mizan

.

Conditions: #

  • Account: Select the account whose balance should be aged.
  • As of Date: Set the cutoff date through which results are calculated.
  • Branch: Select a branch to age transactions within that branch.
  • Cost Center: Select a cost center to age transactions allocated to it.
  • Classification 1, Classification 2, Classification 3, Classification 4Filter accounts by their classifications. For example, if Classification 1 represents Customer Location, selecting Damascus includes accounts classified as Damascus.

Balances from Journal Entries: #

Select the entry sources to include:

  • Opening Entries.
  • Manual Entries.
  • Automatic Entries Generated by: Custom Vouchers, Commercial Papers, Paper Settlement, Bank Portfolio, Exchange Differences, POS Closing, Depreciation Notes, Manufacturing Transactions or Asset Transactions.
  • Account-Specific Analysis: Select an account-specific analysis for the chosen account to age its balance.
  • General Analysis: Select a general analysis to age balances assigned to it.
  • Sales Representative: Select a sales representative to include balances whose journal entries include that representative.

Balances from Invoices: #

Use invoice criteria to restrict the report.

The following report-related options are available:

  •  Sales Representative: select a representative to include balances whose invoices include that representative.
  •  Advanced Filters: set invoice filters based on fields such as payment method or date. Only matching invoices are included.

 Invoice Types: #

Select the invoice types whose customer balances should appear in the report.

Currency and Exchange Rate: #

Select the report currency and its exchange rate relative to the base currency.

Sort Results By: #

Select the ordering of report results. The available options depend on the report type:

Detailed Report: #

Six sorting options are available:

  1. Account Code, then Transaction Date: order by account code, then from oldest transaction date to newest.
  2. Account Code, then Age Ascending: order by account code, then from newest balance to oldest.
  3. Account Code, then Age Descending: order by account code, then from oldest balance to newest.
  4. Transaction Date: order from oldest to newest.
  5. Age Ascending: order from newest balance to oldest.
  6. Age Descending: order from oldest balance to newest.

The following image illustrates these options:

Illustration: detailed report sorting

.

Options: #

This section contains the following settings:

Balance Aging: Two options are available:

  • Debit Balances: Age accounts with debit balances.
  • Credit Balances: Age accounts with credit balances.

Transaction Matching Method: #

Two methods are available:

Automatic Matching: #

By default, the program matches payments against invoices in first-in, first-out order. For example, Tareq’s payments are applied to his oldest invoices first.

Automatic Matching includes two options:

  • Combine Automatic EntriesEnable this option to net the debit and credit entries generated for the account by an invoice. For example, a sale of SYP 3,000 with a SYP 500 discount produces a net receivable of SYP 2,500.

The report before enabling Combine Automatic Entries:

Illustration: automatic matching

.

The report before enabling Combine Automatic Entries:

Illustration: automatic matching

.

  • Match Transactions from Previous PeriodsThis option matches invoices and payments from earlier accounting periods when accounts were rolled forward within the same database. It brings forward unmatched earlier invoices so they can be matched against payments in the current period.

NoteThis option appears only after accounts have been rolled forward within the same database.

To enable it, open Settings / Program Features and select Allow Matching Outside the Current Accounting Period.

The following image illustrates the setting:

Illustration: automatic matching

.

See the Configure Al Mizan Program Settings section.

Manual Matching: #

This method lets you assign payments to specific invoices. For example, Adel’s payment

may settle yesterday’s invoice rather than an older invoice from two weeks ago.

Manual Matching includes Break Down Payments, which displays individual payments and the invoices to which they are matched.

To enable transaction matching, open Settings / Program Features and select Enable Account Transaction Matching.

The following image illustrates the setting:

Illustration: manual matching

.

Report Type: #

Two methods are available:

Detailed: #

Display the balance as separate components according to its underlying transactions. The following options are available:

  • Show Outstanding Balances: Include balances that are not zero.
  • Show Settled Balances: Include balances that have been fully settled and are zero.
  • Show Transaction Branch: Display the company branch associated with each transaction.
  • Show Transaction Description: Display the transaction description in a detailed report.
  • Show Entry Number: Add a column showing the journal entry number.
  • Show Entry Subnumber: Add a column showing the journal entry subnumber.
  • Print Each Account on a Separate Page: When aging a parent account such as Customers, the report includes every subaccount. Enable this option to print each account on a separate page rather than sharing pages.
  • Show Running Balance: Add a column showing the cumulative balance for each account.
  • Show Subtotals for Each Account: Add a subtotal row beneath each account for original amounts and remaining balances.
  • Show Monthly Totals: Add monthly total rows for each account, as shown below: 
Illustration: detailed report

.

  • Show Customer Accounts Only: Enable this option to include only accounts converted to customer-type accounts. Disable it to include all account types.

Grouped by Period: #

Divide each balance into aging periods according to the dates of its underlying transactions. The following settings are available:

  1. Number of Periods: Set the number of aging periods.
  2. Period Length: Set the duration of each aging period.
  • Show Sequence Number: Display sequential numbers for report rows.
  • Show Account Code: Add a column showing the account codes.
  • Merge Account Name with Account Code: Show account code and name in one column.
  • Show Last Payment Date: Add a column showing the most recent payment date for each account.
  • Show Last Payment Amount: Add a column showing the most recent payment amount for each account.
  • Show Collection Days: Add a column showing the elapsed time between the underlying transaction and its settlement.

A Practical Aging Example: #

Assume the customer Tareq has the following transactions:

Sales Invoice — 1 January 2021 — SYP 10,000

Payment — 3 January 2021 — SYP 1,000

Sales Invoice — 5 January 2021 — SYP 15,000

Payment — 10 January 2021 — SYP 6,000

Tareq’s remaining balance is SYP 18,000.

Two matching scenarios are possible:

Scenario One: #

Payments settle the oldest invoices first. Both payments are applied to the invoice dated 1 January, so the remaining balance is:

First Invoice − Both Payments + Second Invoice 

= 10000 – ( 1000+6000 ) +15000 

= 3,000 + 15,000 = SYP 18,000

The aging report explains the SYP 18,000 balance as SYP 3,000 remaining on the 1 January 2021 invoice plus SYP 15,000 on the 5 January 2021 invoice.

To obtain this result, select Tareq as Account and choose Detailed without enabling other options, as shown below:

Illustration: scenario one
Illustration: scenario one

.

Alternatively, select Grouped by Period to divide Tareq’s balance by age using the chosen number and length of periods, as shown below:

Illustration: scenario one
Illustration: scenario one

.

Scenario Two (Manual Matching): #

Payments are assigned to specific invoices rather than always settling the oldest first. Assume the first payment settles part of the first invoice and the second settles part of the second invoice. The remaining balance includes part of each invoice:

Balance = (First Invoice − First Payment) + (Second Invoice − Second Payment)

        =  ( 10000  – 1000  )    +   (  15000  – 6000 )

= 9,000 + 9,000 = SYP 18,000

To obtain this breakdown, match the first payment to the first invoice and the second payment to the second invoice in the Account Transaction Matching window. Enable this feature in Settings / Program Features, as illustrated below:

Enable the window through Tools / Settings:

Illustration: scenario two using manual matching

.

Right-click the payment and open the matching window to assign it to an invoice:

Illustration: scenario two using manual matching
Illustration: scenario two using manual matching
Illustration: scenario two using manual matching

.

Request a Detailed report with Use Manual Matching enabled, as shown below:

Illustration: scenario two using manual matching

.

The resulting report appears as follows:

Illustration: scenario two using manual matching

.

Practical examples of information available from the Aging report:

  • Unpaid customer sales invoices using automatic matching, applying payments to the oldest invoices first.
  • Unpaid customer sales invoices using manual matching, assigning each payment to selected invoices.
  • A breakdown of Tareq’s balance showing each unpaid invoice’s original amount, remaining amount and age.
  • Tareq’s balance divided into three aging groups: 1–30 days, 31–60 days and more than 60 days.

.

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
Chart of Accounts ReportCustomer Balances Report in Al Mizan

Powered by BetterDocs

Contents
  • Conditions:
  • Balances from Journal Entries:
  • Balances from Invoices:
  •  Invoice Types:
  • Currency and Exchange Rate:
  • Sort Results By:
  • Detailed Report:
  • Options:
    • Transaction Matching Method:
      • Automatic Matching:
      • Manual Matching:
  • Report Type:
    • Detailed:
    • Grouped by Period:
      • A Practical Aging Example:
        • Scenario One:
        • Scenario Two (Manual Matching):
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