i Want to Upload Accouting data from Excel to BUSY Software
for Upload Accounting data from excel follow the step
Step 1: To use the utility, click Administration then Data Export/Import click on Import Voucher From Excel option. On clicking the Import Voucher From Excel option, an Import Voucher From Excel window appears.
Step 2: Select the voucher type whose vouchers you want to import. For example, if you want to import Sales voucher then select the Sales option.
Step 3: Select the format according to which vouchers will be imported. Next to this data field, a Configure button is given to create and configure a format. On clicking the Configure button, a Format Configuration for Import Voucher From Excel window appears. Given here is a screenshot of Format Configuration for Import Voucher From Excel window.
Step 4: Click this button to add a new format for the voucher type. On clicking the button, an Import Excel Format - Add window appears. In the window, specify the format name and click the Save button.
Step 5: To configure format for a voucher type, select the required voucher type from the left hand side of the Format Configuration for Import Vouchers from Excel window and further select the required format. After selecting the required format, click the Configure button. On clicking the Configure button, a Configuration for Importing Vouchers from Excel window appears.
Step 6: Under this group following options and sub groups appear Add New Voucher
Step 7: GST Report Basis
Under this group, following sub groups appear
As Per Party Master Select this option if you want to generate GST Report as per details entered in Party Master.
Billing/Shipping Details Select this option if you want to generate GST Report as per details entered in Billing/Shipping Details.
Step 8:
Excel File Info.
Under this group, you have to specify details about the Excel file from which you are importing the data. Various data fields that appear under this group are:
Excel Sheet Specify the path of the Excel file from which data is to be imported.
Starting Row Specify the starting row number from which data is to be imported.
Ending Row Specify the ending row number up to which data is to be imported.
Sheet No. Specify the Excel sheet number from which data is to be imported