How to import Ledger Master from Excel in Marg Software ?

What's New

Welcome to - Marg ERP 9+

Home > Margerp > Copy > How to import Ledger Master from Excel in Marg Software ?

How to import Ledger Master from Excel in Marg Software ?

4538

Ans.1

Overview/Introduction of the Import ledgers From Excel in Marg Software

Steps to Create Method to import Ledgers from Excel in Marg Software

Steps to import Ledgers from Excel in Marg Software

OVERVIEW/INTRODUCTION OF THE IMPORT LEDGERS FROM EXCEL IN MARG SOFTWARE

With the help of Marg ERP software, user can easily import the multiple ledgers from the Excel sheet (only through method according to the excel sheet).

This options saves lot of time to create each and every separate ledger in the software.

It facilitates user to import the group of ledger, balancing method along with the name & additional details of the ledger (as per your requirement).

STEPS TO CREATE METHOD TO IMPORT LEDGERS FROM EXCEL IN MARG SOFTWARE

Suppose the user has prepared an excel sheet containing Ledger's Name, Group Code (As shown below).

Note : As in the excel sheet user has mentioned group codes beside the ledger's name, Therefore, user also need to add this column in the excel sheet because it specify the group of the ledger whether it is 'Debtor' or 'Creditor'.

To Import debtor's Ledger : Use code 'C6'.

To Import Creditor's Ledger: Use code 'D31'.

In order to create the method to import ledger master from the excel, follow the given steps:

Firstly, Go to Reports > Management Reports > Utilities > Copy > Import Masters from Excel .

An'Import Master' window will appear.

The user will now select ‘Party Master Method’.

A 'Party Master Method' window will appear.

The user will select 'Method'.

In the next window, enter the name for this method.

Suppose enter ‘AB’.

An alert window will appear ‘Not found. Want to create’, the user will click on ‘Yes’.

In 'File Identifier', the software will automatically pick that file name which have been imported previously in the software.

In the excel sheet, the user can view that the data starts from line 2.

So, in ‘Data from the line’, the user will enter ‘2’.

Then select other options as per the requirement and keep pressing 'Enter' key on this window.

An 'Import Method' window will appear. Press 'Enter' key.

A 'Format Variables' window will appear.

The user will now search the heading to be imported from the Excel sheet.

Suppose select 'Party Name'.

In the excel sheet, the user can view that Ledger's Name is in column A.

Then, in the Import method window the user will enter ‘A’ in the Excel field.

Press 'Enter' key twice.

Again, 'Format Variables' window will appear.

The user will search the heading to be imported from the Excel sheet.

Suppose now select City.

In the excel sheet, the user can view that city is in column B.

Then, in Import method window the user will enter ‘B’ in Excel field.

Press 'Enter' key twice.

Similarly, the user will select all the headings to be imported from the Excel sheet.

Then Press the 'Tab' key to save the details.

STEPS TO IMPORT LEDGERS FROM EXCEL IN MARG SOFTWARE

Again, Go to Reports > Management Reports > Utilities > Copy > Import Masters from Excel.

An 'Import Master' window will appear.

The user will now select ‘Party Master Import’.

A 'Purchase Import' window will appear.

Click on 'Directory'.

Then the directory will get opened and select the location where user has saved excel of the ledgers.

Suppose select 'Desktop'.

Now click on 'OK'.

Now all the files of the selected location will get displayed.

Now select the Excel file which needs to be imported.

Then click on 'Select'.

Then the software will pick the selected path.

An 'Item Import' window will appear.

a. Method: Select the created method. Suppose select 'AB'.

b. Sundry Debtor: Mention the Group Code to import debtor (C6 only).

c. Sundry Creditor: Mention the Group Code to import Creditor (D31 only).

d. Bill by Bill: Select 'Yes' if user need to set ledger's balancing method to 'Bill by Bill' and if the balancing method is needed as 'On account' then select this option 'No'.