How to Import Purchase Invoices into BUSY from Excel

To import purchase invoices into BUSY from Excel, configure an Excel format for Purchase vouchers, map the workbook columns to the fields used by the target BUSY company, and import a small representative sample before loading the full file. Party and item names, voucher grouping, purchase type and GST treatment must agree with that company's setup.

The route is BUSY's native voucher import, not a fixed spreadsheet template. In BUSY, open Administration, choose Data Export/Import, select Import Vouchers from Excel, and choose Purchase as the voucher type. The saved format determines how columns in your sheet correspond to BUSY data fields.

A completed import only means BUSY accepted the data under the selected settings. It does not prove that repeated item rows became the right number of vouchers, that CGST and SGST or IGST were treated correctly, or that the expected purchase ledger and bill sundries were affected. Those outcomes have to be checked against the supplier bills and the company's accounting configuration.

This process is for entering supplier bills as Purchase vouchers. Importing account or item masters is a separate operation. So are sales invoicing, recording an import of goods from overseas, and storing an invoice image without creating a voucher.

Prepare the company and workbook before mapping

Open the company and financial year in which the purchase should be posted. Confirm the intended Purchase voucher type and review the accounts, items, units and bill sundries that the import will reference. BUSY's import troubleshooting specifically calls for party names, item names, units, purchase types and bill-sundry names to use the same spelling and format as the masters in BUSY.

Create missing masters only after deciding that they belong in the company. Enabling master creation simply to make an import pass can leave near-duplicate suppliers, items in the wrong groups or tax categories that do not match the intended treatment.

The workbook also needs a clear division between facts taken from the supplier bill and values determined by the company's books:

From the supplier invoice	From the BUSY company configuration
Supplier invoice number and date	Exact party master name
Supplier identity and GSTIN, when shown	Exact item master name and unit
Item description, quantity and rate	Purchase type and purchase ledger
HSN or SAC, taxable value and printed tax amounts	Bill-sundry treatment and GST report basis
Invoice total and place of supply, when shown	Voucher grouping and new-voucher controls

For a multi-line supplier bill, the workbook will usually contain one row per item. Keep invoice-level identifiers, such as the supplier invoice number, date and party, consistent across those rows. BUSY's saved format then needs to group the rows as intended. Do not assume that a layout which worked in another company will start and end vouchers correctly in yours.

Keep other accounting imports out of the same mapping exercise. If the source file contains statement transactions rather than supplier invoices, use the appropriate workflow to import bank statements into BUSY, where payment, receipt and contra vouchers are relevant instead of Purchase vouchers.

Configure and save the Purchase voucher import format

The BUSY purchase voucher import format is a saved map between one workbook layout and one voucher type. Configure it from the company that will receive the entries:

1. Open Administration, then Data Export/Import.
2. Select Import Vouchers from Excel.
3. Choose Purchase as the voucher type.
4. Select Configure, add a format, give it a recognisable name and save it.
5. Open that format and connect each required BUSY data field to the corresponding Excel column.

Map what your workbook actually contains. If supplier invoice number is in column B and party name is in column E, the saved format should reflect that layout. BUSY does not require every business to rearrange its data into one universal column order. A format name that identifies the source and purpose, such as the client or monthly purchase workflow, also reduces the risk of selecting an unrelated map later.

The import window asks for the Excel file path, sheet number, starting row and ending row. Select the sheet that contains the purchase data and start below the header. Use the ending row to limit the first run to the test sample rather than the whole workbook.

The format configuration also exposes Add New Voucher and GST Report Basis controls. Their correct settings depend on how invoice boundaries are represented in the sheet and where the company maintains the GST details used for reporting. Treat them as accounting decisions within this saved format, not as settings to copy from a demonstration without testing.

Map multi-line invoices and GST according to the purchase type

In a BUSY multi-line purchase invoice import, several spreadsheet rows should become one Purchase voucher when they belong to the same supplier bill. The item descriptions, quantities, rates and line values vary by row, while voucher-level fields such as supplier invoice number, date and party remain stable. Map those identifiers consistently, then use a sample invoice with two or more items to confirm exactly where the saved format starts a new voucher. BUSY exposes an Add New Voucher group in the format configuration, but its official help does not establish one setting that is correct for every workbook structure.

Tax mapping follows the purchase type configured in the company. With item-wise treatment, tax calculation is tied to the items. For a multi-rate purchase type, BUSY's import troubleshooting says the bill-sundry name, percentage and amount fields must be maintained in both the Excel import template and the workbook. Omitting those fields can produce a voucher that imports but does not reproduce the intended tax allocation. Confirm whether the selected purchase type and import settings calculate tax or use amounts mapped from the workbook, then compare that behaviour with the sample bill.

The GST Report Basis setting also affects which data BUSY uses. Choose As Per Party Master when reporting should use the details held in the party master, or Billing/Shipping Details when the relevant details are supplied there. This is why a BUSY GST purchase import cannot be reduced to mapping printed tax amounts alone.

For inter-State supplies, registered persons must state the place of supply and the name of the State on the tax invoice, as set out in CBIC's guidance on place of supply for inter-State invoices. Map and verify place of supply alongside GSTIN, HSN or SAC, taxable value and IGST. For local purchases, compare CGST and SGST with the source bill. The broader field rules belong in India GST invoice requirements under Rule 46; the import task is to preserve the applicable values and apply the company's chosen accounting treatment.

Test a representative sample before the full import

Take a current backup of the BUSY company before importing. Build the first test from a few invoices that exercise the format: a bill with multiple item rows, a local purchase with CGST and SGST, and an inter-State purchase with IGST if those cases occur in the file. Set the starting and ending rows so the import contains only that sample.

After the import, open each resulting Purchase voucher and compare it with the source invoice. Check:

• Invoice boundaries: all rows for one bill are in one voucher, and the next bill starts a new voucher.
• Voucher identity: voucher date, supplier invoice number and party are correct.
• Items: item master, unit, quantity, rate and line amount match the source.
• GST: taxable value, HSN or SAC, CGST and SGST or IGST, and place of supply are consistent with the invoice and intended treatment.
• Accounting effect: purchase ledger, bill sundries and any item-wise or voucher-level tax allocation are correct.
• Totals: taxable value, tax and gross voucher total agree with the bill.

Reconcile control totals outside the individual vouchers as well. The number of source invoices should equal the number of intended Purchase vouchers. Sum the sample's taxable values and each tax component in Excel, then compare those figures with the imported entries. This catches a duplicated row or split invoice that can be missed when each voucher is viewed in isolation.

If BUSY reports an error, correct the workbook, master name or saved mapping that caused it. If the import completes but the vouchers are wrong, treat that as a failed test too. Remove or correct only the test entries through a controlled process, adjust the format, and repeat the same limited row range before expanding the import.

Use modification and overwrite controls only for intended changes

Importing new Purchase vouchers and correcting existing vouchers are different jobs. For the normal first import, the intended result is a defined set of new entries. If those entries are wrong, first determine whether the correction belongs in the workbook, a master, the saved import format or the vouchers themselves.

BUSY provides a Modify Existing Vouchers option and can present overwrite behaviour when previously imported data is re-imported. Use these controls only when the identified vouchers are meant to change. They are not a general fix for an import whose matching, grouping or tax result is not yet understood.

Before a corrective re-import, take another backup and record the voucher range or references affected. Correct the source rows or configuration, restrict the import to a small known range, and inspect the result before applying the same change more widely. Rerunning all rows without confirming how BUSY will match them can create duplicate purchases or alter entries that were already valid.

---

When supplier invoices are PDFs or scans

If the source is already a clean workbook, use BUSY's native import directly. When the source consists of supplier PDFs or scans, a PDF invoice to BUSY workflow has two stages: create structured invoice rows, then apply the saved BUSY format and the target company's accounting decisions.

Invoice Data Extraction lets you upload PDF, JPG or PNG supplier bills, describe the fields and row structure you need, and download the result as XLSX or CSV. For purchase imports, you can request one row per line item with invoice-level details such as invoice number, date and supplier repeated on every row. When a specific extracted result needs manual verification, the output can include Review Needed guidance identifying what to check.

Use the column names and structure required by your saved BUSY mapping when you extract supplier invoice data to Excel. Review the flagged values and compare a representative group of rows with the original bills before importing them.

The extracted spreadsheet is an input to BUSY, not a native BUSY connector. It does not post Purchase vouchers, select the correct purchase type or ledger, decide the GST treatment, or guarantee acceptance by an importer that has not been configured for the workbook. Those decisions remain in the BUSY company and still require the same limited test and voucher-level checks.