Frequently Asked
Questions
Find Solutions to Common Issues Related to data-conversion - master import export
Can I import/export data for my registered business/farm in BUSY?
If you want to import data for your registered bussiness then please follow the
given steps
Step 1: Go to adminstration then data export import.
Step 2: Then impot voucher from excel select voucher type which you want
to import then click on configure format. then select again voucher type
which you have already selected then add format then configure.
Step 3: Then enter format in select format field then select excel file path
where you have data file which you want to import then sheet no then
starting raw and ending row and import.
Furhter for export data please follow the given steps
Step 1: open the report that you want to export.
Step 2: Then click on export option.
Step 3: Then select data format and location where the file will be exported.
Step 4: Then ok to export.
Error Showing While importing Master From Excel, how to fix it.
Here are some common reasons for errors while importing Masters from Excel and their solutions:
Reason 1 : No MS Excel Installed.
Solution: Install MS Excel compatible with your Windows and BUSY.
Reason 2 : Compatibility Issues with MS Excel.
Solution: Repair MS Excel or Office from the Control Panel -> Program Feature. If the issue persists, install a compatible version of MS Excel.
Reason 3 : Junk Characters in Excel.
Solution: Remove any junk characters from your Excel data.
Reason 4 : Data Field Length is Too Big.
Solution: Store data according to the standard size of BUSY.
Reason 5: Huge Data on a Single Sheet (More Than 33 Thousand Records).
Solution: Install the latest version of BUSY (BUSY21 9.6 and above).
Following these steps should help resolve errors during the Excel data import process.
What is the process for exporting and importing opening balances?
To export and import opening balances in BUSY, you can use export / import data option of BUSY.
Please follow then belwo steps to use this option:
1: Go to Administration Menu
2: Click on data export/import options
3: Then click on Data Export Import XML or Export/Import Master From Excel
4: Then select export option master in xml/excel then select master range and tick opening balance and specify then ecport file path and export
5: Click on import option from xml/excel and select the file and with excel you have to select field which you want to import e.g. op_amount for opening balance etc and specify the excel column in which same column details is available & then import.
Make sure you have a latest backup of your data.
Can I modify the item list directly on Excel and upload it to the software?
Yes, you can modify the item list directly on Excel and upload it to the BUSY. To know how to import item's list from excel, follow these steps:
Step 1: Open your company, then go to the Administration tab and click on the Data Export Import.
Step 2: Choose the Import Masters from Excel / Google Sheet option and select the master type such as Items.
Step 3: Click on Modify Existing Masters and map the master fields with excel field as per the sheet.
Step 4: Select the key field then mention excel file path, sheet no., starting and ending row and click on import button and wait for the importing process.
Note: Take backup of your data before making any modification in BUSY.
How do I create an item master in BUSY with item alias, hsn code, mrp, purchase price and sales price through ms excel?
To create item master with item name, alias, group, hsn code, purchase price and sales price data through excel, follow these steps:
Step 1: Take the latest backup of your data.
Step 2: Go to administration section then click on Data export import
Step 3: Choose import master from excel and Google sheet then select item.
Step 4: Select import from Excel option then tick on add new item.
Step 5: Select the required master fields like item name, item group, item alias, hsn code, sales price, purchase price etc. and select excel field as per data in excel sheet.
Step 6: Specify the excel file path with excel sheet number and starting and ending row then click on import tab.
How to import Bill Of Materials master by excel in BUSY?
To import Bill Of Materials master by excel in BUSY, follow these steps:
Step 1: Prepare the excel sheet with Bill Of material details like BOM Name, item to produce, qty produced, raw material name, raw material qty, raw material unit etc.
Step 2: Go to the Administration section then click on Data export import option.
Step 3: Now, Select Import master from MS Excel option then click on Bill Of Materials.
Step 4: To create a BOM master, choose the necessary fields for BOM details and tag with excel field, select the Excel sheet with the starting and ending rows of data, and import the sheet.
Note: Take the latest backup of data before any process.
Can I add a Bill of Material master for a new company in Bulk? What is the process in BUSY?
Yes, you can add a Bill of Material master for a new company in Bulk.
To add a Bill of Material master in Bulk, follow these steps:
Step 1: Open your company, then go to the Administration tab and click on the Data Export Import.
Step 2: Choose the Import Masters from Excel / Google Sheet option and select the Bill of Material master type.
Step 3: Map the master fields with excel field as per the sheet.
Step 4: Now, mention excel file path, sheet number, starting and ending row and click on import button and wait for the importing process.
Note: Take the latest backup of your data before any process.
How can I clear the balance of accounts and import the opening balance again from excel?
When you import opening balance of accounts from excel, the previous balance will be clear automatically. To know how to import, follow the below steps:
Step 1: Go to administration section then click on Data export import
Step 2: Choose import master from excel or google sheet then select from account.
Step 3: Tick on excel option then tick on modify existing masters.
Step 4: Select the required master fields and map them with excel sheet column.
Step 5: Specify the excel file path with excel sheet number and starting and ending row then click on import button.
Step 6: Opening balance can be modified in the begging financial year of company.
How to add opening balances and migrate data from old software?
To migrate data from any other accounting software to BUSY, you can import data through Excel.
Steps to import Mater with opening balance through BUSY:
Step 1: Go to administration then click on Data export import
Step 2: Now click on Import master from excel and select the required field like master name, master group , opening amount and so on.
Step 3: select the configured excel sheet in import master from excel window and import the data.
Further Feel free to contact our customer support helpline at 8282828282 for any related queries.
Note- In BUSY, you can import Tally data directly through the Tally2BUSY utility.
Is it possible to use an excel sheet for update details in multiple items at once?
Yes, it is possible to use an excel sheet for update details in multiple items at once in BUSY. To do this follow the below steps:
Step 1: Take backup of your company.
Step 2: Go to administration section then click on Data export import
Step 3: Choose import master from excel or google sheet then select from item.
Step 4: Tick on excel option then tick on modify existing masters.
Step 5: Select the required master fields which you want to update and map them with excel sheet column.
Step 6: Specify the excel file path with excel sheet number and starting and ending row then click on import button.
