How to Import Data From ZOHO to BUSY
This guide will help you understand how to import data from ZOHO to BUSY using Excel. Follow the steps mentioned below for an accurate data import to BUSY.
Migrate from ZOHO to BUSY Smoothly
Import your ZOHO data seamlessly and unlock powerful accounting features. Join 6,00,000+ businesses already growing with BUSY.
Preparing Your Excel File
First, create an Excel Sheet and ensure each column has only one type of data:
- The Party Name column should contain only party names
- The GST Number column should include only GST numbers
- Each column should have consistent data type throughout
Step-by-Step Import Process
Create an Excel Sheet and ensure each column has only one type of data. For example, the Party Name column should contain only party names, the GST Number column should include only GST numbers, and so on.
PrepareOpen BUSY on your system 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 Type of 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.
ConfigureSelect the Excel file, sheet number and row numbers where the data starts and ends. Usually, the first row contains headers, so data starts from the second row.
UploadClick the Import button. Once everything is configured, click the Import button. If successful, you'll receive a confirmation message.
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 accurately.
CompleteConfiguring Masters Import
When configuring Masters import, follow these steps:
- Choose whether to add new records or modify 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 configuring Vouchers import, follow these steps:
- Select the voucher type you wish 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
Following these steps, you can import data from Zoho to BUSY Accounting Software, which will help you get started quickly.