How to Import Data From MyBillbook to BUSY
This guide will walk you through the process of importing data from MyBillbook to BUSY accounting software using Excel. Follow these simple steps to ensure a smooth data import.
Make the Switch to BUSY in Minutes
Seamlessly import your MyBillbook data and unlock powerful GST, inventory, and accounting features. Get started with a free demo.
Why Import Data from MyBillbook to BUSY?
Importing data saves time, reduces errors, and improves efficiency by eliminating the need for manual data entry. With BUSY's powerful import features, you can quickly transfer your masters (accounts, items) and vouchers (sales, purchases) from MyBillbook using simple Excel files.
Preparing Your Excel File
Before you begin the import process, make sure your Excel sheet is properly formatted:
- Each column should contain only one type of data
- The Party Name column should have only party names
- The GST Number column should contain only GST numbers
- Keep headers in the first row and data starting from the second row
Step-by-Step Import Process
Create your Excel sheet and make sure each column comprises only one type of data. For example, the Party Name column should have only party names, the GST Number column should contain only GST numbers, and so on.
PrepareOpen BUSY Accounting Software on your machine 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. Decide whether to import Masters (like accounts, items,
etc.) or Vouchers (like sales, purchases, etc.).
Select the data type 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 and specify the sheet number and the 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 will receive a confirmation message that the data import was successful.
ImportVerify the imported data. Go to the relevant section in BUSY (e.g., Masters > Account List or Transactions > Purchase List) to make sure the data has been imported correctly.
CompleteConfiguring Masters Import
When importing Masters (Accounts, Items, etc.), follow these configuration steps:
- Determine 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 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, it's essential to 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
- Cross-check GST numbers, amounts, and quantities for accuracy
Following these steps, you can quickly import data from MyBillbook to BUSY Accounting Software, saving time and effort while ensuring accuracy.