Overview Of Bill Import In Marg Software

Process To Set GST Standard In Ledger In Marg Software

Process Of GST Standard Bill Import In Marg Software

OVERVIEW OF BILL IMPORT IN MARG SOFTWARE

• Transaction Import option is basically used to Import the Purchase list from any outer source like Excel file, CSV file, etc.

• With the help of Marg ERP Software, the user can Import the received file of the invoice in Marg ERP Software without doing any manual entry.

• ‘GST Standard Bill Import’ feature of transaction import does not require any method to import the transaction

• There is a condition in this method of purchase import i.e. the bill must be exported in standard format and also needs to be imported in the same.

• Standard formats were used at the time of ‘VAT’ and they were designed accordingly i.e. they doesn’t contain HSN Column and do not have bifurcated tax column (SGST/CGST).

PROCESS TO SET GST STANDARD IN LEDGER IN MARG SOFTWARE

• Firstly, the user needs to select the format in other details of party for whom the transaction is been made.
• Suppose select 'Ranbaxy India Ltd.', the user needs to select ‘GST Standard’ in the Other Details of the Party.

PROCESS OF GST STANDARD BILL IMPORT IN MARG SOFTWARE

• Go to Transactions > Transaction Import > GST Standard Bill Import.

• An 'Import-from' window will appear.

• The user will select the location and file i.e, from where the user needs to import the transaction.

• Click on 'Select'.

• An 'Import Standard' window will appear.
• In ‘Import in Type’ field, the user will select which type of transaction needs to be import.
• Suppose select 'Purchase'.

• In ‘Save In Bill/Challan’ field, the user will select whether to save in Bill or in Challan.

• Suppose select ‘Bill’.

• In 'Hold Purchase', the user will select 'Yes' if needs to hold purchase Item and don't want to sale other wise keep it as 'No'.
• Suppose select 'No'.

• In ‘Import From’ field, the user will select that whether the import needs to be done from wholesale / Retail / Company.

• Suppose select ‘Wholesale’.

• In ‘Entry Date’ field, the user will mention the entry date. 

• Suppose enter ’31-08-2023’.

• In ‘Item Search Base’ field, the user will select the base for searching the item.

• Suppose select ‘Name’.

• In ‘Show Un-Matched’ field, the user will select option as per the requirement.
• Suspected: Select the option to view item those have some changes only because of some symbol.
• UnMatched: Select the option to view item those are not mapped.
• All: Select the option to view all items wheather they are mapped or not or have some difference in name.
• Suppose select ‘Un-matched’.

• In 'Replace A-Rate/Replace G-Rate' field, the user will select that with which rate the user needs to replace A/G- Rate.
• If the user don't need to replace rates then select 'Don’t change' option from the dropdown.
• Click on 'Accept'.

• A ‘Purchase Type’ window will appear.

• The user will select the Purchase type as per the requirement.

• Suppose select ‘Local’.

• A 'Ledgers' window will appear.

• The user will select the ledger for which Purchase needs to be Import.

• Suppose select ‘Ranbaxy India Ltd.’

An ‘Item Mapping Total Records’ window will appear.

Here, all the items of the bill will get displayed which needs to be imported in the software.

a. Item Not Created: If item not created in data then the user needs to press '+' key and can create Item on same window.

b. Item Already Created: The software will automatically map the existing items.

c. Map Item / Change Map Item: If the user needs to map it with other items then press 'Enter' key on it and select item by which item needs to be map.

Suppose the user has already created the item then software has automatically map the item.

Press 'ESC' Key.

• A ‘Save Changes’ window will appear in which the user will click on ‘Yes’.

• A 'Start Import' window will appear where the user will click on ‘Accept’ to start importing the data.

• The user can view bill will get Import, now press 'Ctrl+W' key.
• A ‘Save Changes’ window will appear where the user will select ‘Yes’ to save the changes.