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

• The user will press 'F2' key on a particular Ledger whose opening and closing report needs to be viewed.
• Suppose select 'Apollo Medisales'.

• The user will select month up to which report needs to be viewed.
• Suppose select 'April'.

• In 'From Date and Upto Date', the user will mention the date range as per the requirement.
• Suppose mention '01-04-2026' to '30-04-2026'.

• 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 be generated.
• Click on the Excel icon to generate a report in Excel Format.

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

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

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

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

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 the Ledger Opening and Closing Balance report will be generated in Marg ERP Software.