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
  • Database Rollover in Al Mizan

Database Rollover in Al Mizan

To roll the database forward, follow these steps:

First: Steps in the Old Database #

Back up the database. #

Make sure all invoices are posted and finalized usingProcess Invoicesfrom theInvoices“. #

Illustration: Verifying Posted and Finalized Invoices in Process Invoices

See Processing Invoices.

Re-finalize Invoices: #

Run Re-finalize Invoices fromItems” -” Invoice Operations” -” Re-finalize Invoicesto verify item cost calculations.

Illustration: Re-finalizing Invoices

See: Re-finalize Invoices

Process Journal Vouchers: #

Make sure all journal entries are posted using Journal Entries and Process Journal Vouchersas shown below.

Illustration: Processing Journal Vouchers

See Processing Journal Vouchers.

Recalculate Balances: #

  1. Request Recalculate Balances fromAccounting” -” Journal Entry Operations” -” Recalculate Balances“.
Illustration: Recalculating Balances

See Recalculating Balances.

Item Inventory Report: #

Request an inventory report for each warehouse. Verify stock quantities and resolve any negative inventory. If program quantities differ from the physical count, useCompare Warehouse Inventoryfrom theItemsto correct each warehouse’s stock. The window displays all items and quantities. Enter the physical counts for items with differences, then generate receipt invoices to increase understated stock and issue invoices to reduce overstated stock.

Process Exchange Rate Differences: #

If the database uses multiple currencies, process exchange rate differences. See the corresponding guide for details. Update exchange rates in the Exchange Rate Bulletin because the new database’s opening entry uses those rates.

See Processing Exchange Rate Differences.

Closing Inventory Invoice: #

Make sure a Closing Inventory invoice type exists.

Open its type card and ensure its category is specifically Closing Inventory and that it does not generate a journal entry, as shown below.

Illustration: Closing Inventory Invoice

.

Opening Inventory: #

Make sure an Opening Inventory invoice type exists, its category is Opening Inventory and it also does not generate a journal entry.

Generate Closing Inventory Invoices: #

After verifying inventory, generate closing inventory invoices fromItemsin theInvoice Operations” -” Generate Closing Inventory Invoicewindow, creating one closing inventory invoice for each warehouse.

Illustration: Generating Closing Inventory Invoices

See Generating Closing Inventory Invoices.

Define a Retained Earnings Account #

In the chart of accounts, define Retained Earnings alongside Capital within the applicable equity grouping and classify its final account under the Balance Sheet, as illustrated below.

Illustration: Defining a Retained Earnings Account

Note:

If multiple branches exist, use a single Retained Earnings account to combine their profits, or define a separate account for each branch to keep their profits separate.

Create a database backup. #

Create a New Database: #

Create a new database fromFile” -” Create New Databaseusing the
Empty type and a suitable name for the new financial year, for exampleDATA2022“.

Second: Steps in the New DatabaseSecond: Steps in the New Database #

Connect to the database newly created. #

Open Tools, select Database Rollover and click Next, as shown below.

Illustration: Connecting to the Newly Created Database

Select the old database whose accounts will be rolled forward, enter its password if one exists and click Next, as illustrated below.

Select the Database to Import: #

Illustration: Selecting the Database to Import

Select the information to import. Enable Import Item Data and, if users exist, Import Users and Permissions. Enable Import Manufacturing Templates if the company uses them. Enable Import Statistical Information to carry forward item statistics by branch and customer. Enable Import Attachments to transfer archived attachments from item, account and customer cards.

 Then click Next, as shown below.

Import Options: #

Illustration: Import Options

.

Accounting Period: #

Set the new database’s accounting period, particularly its start and end dates, as shown below.

Illustration: Accounting Period

.

Currency Exchange Rate Bulletin: #

This read-only window displays the latest exchange rates from the old database’s bulletin. To change a rate, return to the old database and update it there. The following illustration shows the window. 

Illustration: Currency Exchange Rate Bulletin

See the Exchange Rate Bulletin.

Opening Journal Voucher: #

Choose whether to generate an opening journal voucher, as shown below.

Illustration: Opening Journal Voucher

.

Balance Sheet Accounts: #

 Select the final account classifications whose account balances should be transferred to the new database, usually Balance Sheet, as illustrated below.

Illustration: Balance Sheet Accounts

If the old database contains multiple company branches, select the branches whose data should be rolled forward.

Opening Journal Voucher Accounts: #

 Select the profit or loss account, such as the Retained Earnings account defined earlier, into which the previous year’s net profit or loss will be closed. Select the Opening Inventory account and enter its value, equal to the total closing inventory invoices generated in the old database. Click Fetch Closing Inventory Invoice Value to fill it automatically, then click Next, as shown below.

Illustration: Opening Journal Voucher Accounts

.

Opening Inventory Invoices: #

Choose whether to generate opening inventory invoices in the new database. Selecting Yes — Generate Opening Inventory Invoices transfers the old database’s closing inventory invoices into the new database as opening inventory invoices, as illustrated below.

Illustration: Opening Inventory Invoices

.

Confirm Rollover: #

A confirmation window appears. Click Next to complete the rollover, as shown below.

Illustration: Confirming Rollover
  1. Once rollover finishes, open Journal Entries and Opening Entry to view the generated opening voucher. It contains Balance Sheet account balances, Opening Inventory and Retained Earnings, forming the company’s opening balance sheet based on the previous year.
  2. Open Invoices and Opening Inventory to view warehouse item balances and cost prices transferred from the previous year’s closing inventory invoices.
  3. If you change item quantities or costs in an opening inventory invoice, adjust Opening Inventory in the opening entry by the same amount. The total of opening inventory invoices must equal the Opening Inventory balance in that entry.

Important Note: #

If an old database account has a balance that is not carried forward, check its final account classification in the account card. Customer accounts should normally be classified under the Balance Sheet. If a customer is incorrectly classified under Trading or Profit and Loss, its balance is closed into Retained Earnings like income and expense accounts instead of being carried forward.  

Note: #

For fixed assets, the Opening Journal Voucher step in the Database Rollover wizard includes a Carry Forward Fixed Assets option, as shown below.

Illustration: Rollover Notes
Note: To carry general or account-specific analyses into the new year, enable Carry Forward General Analysis and Carry Forward Account-Specific Analysis in the account card. Also select the corresponding rollover options when generating the opening journal voucher.

The following image illustrates the setting:

Illustration: Rollover Notes
To carry cost center balances into the new year, enable the option in each Cost Center card.

The following image illustrates the setting:

Illustration: Rollover Notes

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
Start Page Settings and Panels in Al MizanProcessing Import Transactions

Powered by BetterDocs

Contents
  • First: Steps in the Old Database
    • Back up the database.
    • Make sure all invoices are posted and finalized usingProcess Invoicesfrom theInvoices".
    • Re-finalize Invoices:
    • Process Journal Vouchers:
    • Recalculate Balances:
    • Item Inventory Report:
    • Process Exchange Rate Differences:
    • Closing Inventory Invoice:
    • Opening Inventory:
    • Generate Closing Inventory Invoices:
    • Define a Retained Earnings Account
    • Create a database backup.
    • Create a New Database:
  • Second: Steps in the New DatabaseSecond: Steps in the New Database
    • Connect to the database newly created.
    • Select the Database to Import:
    • Import Options:
      • Accounting Period:
    • Currency Exchange Rate Bulletin:
    • Opening Journal Voucher:
    • Balance Sheet Accounts:
    • Opening Journal Voucher Accounts:
    • Opening Inventory Invoices:
    • Confirm Rollover:
  • Important Note:
  • Note:
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