Overview of Multi Bill Import From Excel in Margbooks Software

Process to Create Import Methord in Margbooks Software

Process to Transaction Import in Margbooks Software

Overview of Multi Bill Import From Excel in Margbooks Software

• In MargBooks, users can seamlessly import data from other software, provided the source application supports data export. The Multi Bill Import functionality is highly beneficial for organizations that need to migrate or consolidate large volumes of data for accounting, inventory management, and operational efficiency.
• This feature also supports the import of various vouchers—including bills, challans, stock issues, stock receipts, quotations, and orders—directly through structured Excel files. Additionally, it enables businesses to import e-commerce invoices in bulk, ensuring smooth integration of online sales data and accurate financial reporting.
• Overall, the Multi Bill Import option minimizes manual data entry, enhances data accuracy, and significantly improves productivity across business operations.

Process to Create Import Methord in Margbooks Software

• Go to Dashboard > Utilities & Tools.

• In other tool user will click on 'Import Method'.

• User will press 'Space' key and 'F2' to create Method Name. 

• The user will click on 'Save' button.

• The user will select ‘Multiple’ to Multi Bill Import.

• In the Import Type field, the user will select the required bill type. Suppose purchase.

• In the Import To option, the user will select where the data should be imported suppose Bill is selected.

• The user will mention the Row and column  from which the data of purchase bill in Excel is being started.

• The user can easily view that the data Starts in Excel from Row 1 and Column A.

• Use will click on 'Upload Your File'.

• User  will select the Excel file from the location where the user has saved the file.

• The user can view that list has been successfully uploaded.

• The user needs to map the excel headings of the bill with the headings of the Marg Books.
• Suppose Column A of the Excel field is 'Date' so the user needs to select 'Date' from the dropdown for the Marg Books heading.

• Click on 'save' button.

• The user can view confirmation alert that 'Import Method Record Saved Successfully'.

Process to Transaction Import in Margbooks Software

• Go to Dashboard > Utilities & Tools.

• In Data Management user will click on 'Transaction Import'.

a. Date :- User will select the bill entry date.

b. Method Name :- If multiple import methods are available, the user needs to select the method name to import.

c. Method Type :- By default Inventory will show .

d. Import Type :- User will select the type of data to import, such as Bill, Stock Received, Order, or Quotation.

e. Select Store :- User will select the store where the stock will be increased.

f. Hold Batch :- If the user wants to hold the batch, select 'Yes'; otherwise, select 'No'.

g. Select Series :- The series will be displayed by default.

h. Party Show Unmatched :- If the user wants to see only unmatched party ledgers, select 'Unmatched.' To view both matched and unmatched party ledgers, select 'All'.

i. Item Show Unmatched :- If the user wants to see only unmatched items, select “Unmatched.” To view both matched and unmatched items, select 'All'.

• Use will click on 'Upload Your File'.

• Select the Excel file from the location where the user has saved the file.

• The user will click on ' Import'.

• User will view the Party Mapping window and see mapped parties.

• If a party is un-mapped, the user can create a ledger by selecting it and clicking the ‘Create Party’ button.

• User will create the ledger as per requirement.
• Click on 'Save' button

• The user will click on 'Import' button or 'F11' Key.

• User will view the Item Mapping window and see mapped items.
• If an item is un-mapped, the user can create it by selecting the item and clicking the ‘Create Item’ button.

• User will create the Item as per requirement.
• Click on 'Save' button

• The user will click on 'Import' or 'F11' Key.

• The user will see the Importing Bills Processing pop-up during the import process.
• Once the process is completed, it will display “Bill Imported Successfully.”
• The user will click on 'Close' button.

After following the above steps, the user can view all purchase bills successfully imported using the Multi Bill Import feature in MargBooks software.