Frequently Asked
Questions

Find Solutions to Common Issues Related to data-conversion - voucher import export

FAQs

How can I set a single rate for all items in an item group?

To set a single rate for all items in an item group,Steps for Import Master from Excel:
Step 1: go to the Administration tab and click on the Data Export Import.
Step 2: Choose the Import Master from MS Excel option and select the type of master that you want to import, such as Items, Accounts, etc.
Step 3: Here, you need to map the fields in BUSY with the columns in Excel.
Step 4: After mapping all the columns, select the Excel File Path and enter the Starting & Ending Row and Sheet Number of your Excel file. Then, click on the Import button and wait for the import process to complete.

I need to export my accounting data from BUSY, but I can't find the export option. How can I export my data?

If you need to get your accounting information out of BUSY, here's how you can do it:
Step 1: Go to Administration, then Data Export/Import, and choose Data Export Import (XML). From there, click on 'Export Data' and select 'Transaction.' Just follow the instructions on the screen to export the data you want.
Step 2: If the XML format doesn't work for your other accounting software, you can also export the data to Excel. This should include both the Masters and Transactions, and you can do it from the voucher register that's relevant.
These steps should make it easy for you to get the export options you need.

I want to import my bank ledger into BUSY. How can I do that?

To import bank ledger into BUSY, you need to follow these steps :
Step 1 : Open BUSY go to backup data and take backup of your company by mention super user password in company which you want to import bank ledger.
Step 2 : Open company go to administration then data export import
Step 3 : Import voucher from excel select voucher type in which you want to import bank ledger in BUSY.
Step 4 : Now configure format as per excel and select format
Step 5 : Now import all bank vouchers from excel and click on import button.
Step 6 : Once all bank voucher is imported, your bank statement will be ready.

How to troubleshoot errors or warnings encountered during data import/export?

Kindly provide specific details about the error showing during the import process so that we can assist you accordingly.
Further, If you are facing any error like voucher date is out of range while importing voucher then follow the below steps:
Step 1: Open your Excel and verify which financial year the voucher date belongs to.
Step 2: If you have opened the incorrect financial year in the company, you can press the F11 key to change to the correct financial year.
Step 3: Then Go to Administration Menu
Step 4: Click on Data Export Import option
Step 5: You can then proceed with the data import process.

How can i import entries from excel into BUSY?

To import entries from excel into BUSY, follow the below steps:
Step 1: Open your company, then go to the administration tab and click on the data export import.
Step 2: Choose the Import Vouchers from excel or google sheet option and select the voucher type such as Sales, Purchase, etc.
Step 3: Then click on the configure button and Add format then configure it.
Step 4: Map the fields in BUSY with the columns in excel sheet.
Step 5: After mapping select the excel file path, enter the starting & ending row and sheet number of your excel file.
Step 6: Then, click on the Import button and wait for the import process to complete.

I want to save my sales reports in Excel format but BUSY is only showing PDF option. How can I change the file format to Excel before exporting data?

To export data from BUSY, you can go to the respective report (e.g., Accounts, Inventory, etc.), select the desired data, and use the Export (ALT+E) option to export it in a compatible file format such as Excel, CSV, PDF & Google Sheet.
For Import Data.
BUSY offers various ways to import data from different sources. You can find the Data Export Import option under the Administration menu and choose one of the following methods to import data:
1.Import Master / Voucher from Excel
2.Data Export /Import (XML)
3.Import Data from SQL
4.Import Data from Access
You can choose from one of them to import your data in BUSY.

How do I import data from another system into BUSY?

To import data from another system into BUSY, you can follow these steps:
1. Export the data from the other system in a compatible format, as Excel.
2. Open BUSY and go to the module where you want to import the data.
3. Click on the "Import" option or go to the "File" menu and select "Import".
4. Choose the file you exported from the other system.
5. Map the fields in the import file to the corresponding fields in BUSY.
6. Review the mapping and make any necessary adjustments.
7. Click on the "Import" button to start the import process.
8. Wait for the import to complete and verify that the data has been imported correctly.

Which fields or columns are required in the Excel file when importing vouchers into BUSY?

Here are the steps to configure Excel for importing vouchers in BUSY:
Step 1: Open excel
Step 2: In your Excel sheet, designate separate columns for the Voucher series, Voucher/Bill Date, and Voucher/Bill Number
Step 3: Organize the data accordingly within these columns.
Step 4: Then specify Sale/purchase Type, Party name, Material centre Name
Step 5: Then designate separate columns for the Body part of the voucher, including Item Name, Quantity, Unit Name, and Price.
Step 6: Then make separate columns for exclusive Tax apply in voucher
Step 7: Once you have completed the Excel sheet, you can proceed with the data import into BUSY.

How do I import my TCS data into the software?

To import entry with TCS, follow these steps:
Step 1: Take the latest backup of your data.
Step 2: Go to administration then click on Data export iimport.
Step 3: Choose the Import Vouchers from Excel / Google Sheet option and select the voucher type such as Sales, Purchase, etc.
Step 4: Then click on the configure button and Add format then configure it.
Step 5: Map the fields in BUSY with the columns in Excel Sheet.
Step 6: Now, select the Excel File Path and enter the Starting & Ending Row and Sheet Number of your Excel file.
Step 7: Then, click on the Import button and wait for the import process to complete.

Can I export e-way bill audit report data to excel or pdf format?

You can export e waybill audit report to excel or pdf format by following these steps
Step 1 Go to transactions
Step 2 Select GST misc. utilities option
Step 3 Then E way bill management & e invoice and select e waybill audit report
Step 4 Select date range and open the report
Step 5 Then on top of report select export and select format as excel and export on selected path in local drive or you can change the path
Step 6 And to export in pdf,select on print and select from BUSY or as it is from grid
Step 7 Select export and then format as pdf and export on selected path