- First, create an Excel Sheet and ensure each column contains only one data type. For example, the Party Name column should contain only party names, the GST Number column should contain only GST numbers, and so on.
- Open BUSY on your computer and open the company where you want to import the data.
- Next, go to the Import Section. Navigate to Administration > Data Export/Import>Import Master/Voucher from Excel. Determine whether to import Masters (like accounts, items, etc.) or Vouchers (like sales, purchases, etc.).
- Now, select the data you want to Import. For instance, if importing Masters (e.g., Party, Item), select the relevant master type or select the relevant voucher type if importing Vouchers (e.g., Purchase, Sales).
- Next, configure the Data Import Format.
For Masters: - Select whether to add new records or change existing ones.
- Map each column in your Excel sheet with the corresponding field in BUSY. For example, map the Party Name column in Excel to the Account Name field in BUSY.
For Vouchers - Select the type of vouchers you want to import (e.g., Purchase).
- Map the Excel columns to the relevant fields in BUSY, such as Voucher Date, Voucher Number, Party Name, Item Name, etc.
- Now, select the Excel file, sheet, and row numbers where the data begins and ends. Typically, the first row contains headers, so data starts from the second row.
- Once everything is configured, click the Import button. You’ll receive a confirmation message for the successful import of data
- Next, verify the imported data. Go to the relevant section in BUSY (e.g., Masters > Account List or Transactions > Purchase List) to ensure the data has been imported correctly.
Follow these steps to import data from Vyapar to BUSY Accounting Software, saving time and reducing manual errors.
