• Go to Books > All Ledgers (ALT+L).

• A 'Ledger Accounts' window will appear.
• The user will press 'F2' key on a particular Ledger whose opening and closing report needs to be viewed.
• Suppose select 'Ahuja Medicine Centre'.

• A 'Month' window will appear.
• The user will select month up to which report needs to be view.
• Suppose select 'May'.

• A 'Select' window will appear.
• In 'From Date and Upto Date', the user will mention the date range as per the requirement.
• Suppose mention '01-04-2023' to '31-05-2023'.

• In 'With Opening' option, the user will select 'Yes/No' as per the requirement.
• Suppose select 'Yes'.

• The user can view selected range of data will get generated.
• Click on Excel icon to generate a report in Excel Format.

An 'Export to Excel' window will appear.

a. File Name: The user can view the path where the file is saved (Path can be changed if it's required).

b. Formated: Select the option if a formatted report is required.

c. Balance Only: Select the option if balance is required in the report.

d. Blank Row: Mention the number of rows if required blank.

The user will select 'Format-1/Format-2' as per the requirement.

Suppose select 'Format-1'.

After following the above steps, the user can view Ledger Opening and Closing Balance report will get generate in Marg Software.