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
  • Features
  • Use Al Mizan Functions in Excel

Use Al Mizan Functions in Excel

Al Mizan provides Excel functions that retrieve database information without opening the main program. These include account codes, Arabic and Latin account names, account balances, opening balances, balances excluding opening entries, and item inventory. You can use them to build customized reports and apply Excel calculations to data retrieved from the database.

Enable the Excel Add-in: #

Complete this setup once after installing Al Mizan .NET on the computer:

  • Open Excel.
  • From Customize Quick Access Toolbar, choose More Commands, as shown below:
Illustration: enable the Excel add-in
  • Open the Add-ins section, then click Go, as shown below:
Illustration: enable the Excel add-in
  • In the Add-ins window, click Browse, as shown below:
Illustration: enable the Excel add-in
  • Select the MizanNet.xla add-in file in the Al Mizan installation folder. The default path is usually C:\Program Files\HadaraSoft\Mizan .NET, as shown below:
Illustration: enable the Excel add-in

The MizanNet add-in now appears in the list, as shown below:

Illustration: enable the Excel add-in

After enabling the add-in, Al Mizan .NET accounting and inventory functions appear in Excel’s User Defined function category, as shown below:

Illustration: enable the Excel add-in

Basic Functions Available in Al Mizan: #

Illustration: basic Al Mizan functions

A Simple Example and Important Notes: #

To display the Cash account balance in an Excel worksheet, enter “Cash Balance” in a cell. In the next cell, insert MNGetAccountBalance and click OK. The function arguments window contains the following fields:

Illustration: function example and important notes

Account CodesEnter the required account code. This argument is mandatory.

Period CodeEnter the accounting period code if you want the balance for a specific period.

From DateEnter a starting date to retrieve the balance for transactions after that date.

To DateEnter an ending date to retrieve the balance for transactions up to that date. 

Branch CodesEnter a branch code to retrieve the balance for transactions within that branch.

Cur CodeSelect the reporting currency.

Cur RateEnter the exchange rate for the selected currency.

Click OK to open the database server connection window. Select the server hosting the required database and click Connect. Then select the database on that server, as shown below:

Illustration: function example and important notes
Illustration: function example and important notes

After connecting, the function returns the Cash account balance from the Hadara Company database on the local server.

Save the worksheet and reopen it later to retrieve the balance based on the latest database transactions.

Note 1: #

MNGetAccountBalance prompts for the server and database rather than fixing them in the formula. This is useful when working with several databases. To specify a fixed connection, use MNGetAccountBalanceDB. Its arguments include an additional DBConnection field, as shown below:

Illustration: subinventory note 1

Configure DBConnection using the connection parameters required by the add-in:

The parameters identify the server, database, authentication method, SQL login and SQL password. Follow the argument order shown by your installed add-in.

Create and Set Up a New Database

Server NameThe computer or SQL Server instance hosting the database.

Database NameThe database from which the account balance will be retrieved.

Server Authentication MethodUse 0 for Windows authentication.

Use 1 for SQL authentication.

SQL UsernameUse a dedicated SQL login with only the permissions required for the reports. Avoid using the administrator account sa.

SQL PasswordThe password for the selected SQL login, which is distinct from a user password inside the accounting application. Protect the workbook because saved connection details may expose database access.

The following legacy screenshot illustrates the connection fields. Its credentials are examples and should not be reused:

Illustration: subinventory note 1

Acc1\sql2008: example server instance.

Al Mizan .NET: example database name.

1: SQL authentication.

SA: administrator login shown in the legacy example; use a restricted reporting login instead.

Use a strong, nonempty password for the selected SQL login. Do not reuse the legacy example password.

Note 2: #

These functions can create financial statements, including the statement of financial position, income statement and cash flow statement. They can also calculate financial analysis ratios. An Excel workbook can illustrate how the functions are combined to build these statements.

Note 3: #

If an account code starts with a zero, enclose it in double quotation marks to preserve the leading zero, as in the following example:

 012351

Enter it as follows:

“012351”

Note 4: #

Use the 32-bit edition of Excel for compatibility with this add-in.

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
Processing Import TransactionsConfigure Perpetual Inventory in Al Mizan

Powered by BetterDocs

Contents
  • Enable the Excel Add-in:
    • Basic Functions Available in Al Mizan:
    • A Simple Example and Important Notes:
      • Note 1:
    • Note 2:
      • Note 3:
      • Note 4:
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