How to Import Data From Vyapar to BUSY
This is a step-by-step guide for importing data from Vyapar to BUSY using an Excel. Follow the steps below for an accurate data import to BUSY.
Upgrade from Vyapar to BUSY Effortlessly
Seamlessly migrate your business data and unlock advanced GST, inventory, and accounting features trusted by 6,00,000+ businesses.
Preparing Your Excel File
First, create an Excel Sheet and ensure each column contains only one data type:
- The Party Name column should contain only party names
- The GST Number column should contain only GST numbers
- Each column should have consistent data type throughout
Step-by-Step Import Process
Create your 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.
PrepareOpen BUSY on your computer and open the company where you want to import the data.
Launch
Navigate to the Import Section.
Go 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.).
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).
SelectConfigure the Data Import Format. Map each column in your Excel sheet with the corresponding field in BUSY.
ConfigureSelect 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.
UploadClick the Import button once everything is configured. You'll receive a confirmation message for the successful import of data.
ImportVerify 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.
CompleteConfiguring Masters Import
When importing Masters, follow these configuration steps:
- Select whether to add new records or change existing ones
- Map each column in your Excel sheet with the corresponding field in BUSY
- Example: Map the Party Name column in Excel to the Account Name field in BUSY
Configuring Vouchers Import
When importing Vouchers (Sales, Purchases, etc.), follow these configuration steps:
- 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.
Verifying Your Imported Data
After importing, verify that your data has been transferred correctly:
- Go to Masters > Account List to verify imported party accounts
- Check Masters > Item List for imported items and products
- Verify transactions in Transactions > Purchase List or Sales List
Follow these steps to import data from Vyapar to BUSY Accounting Software, saving time and reducing manual errors.