Batch Purchase Order

Import many purchase orders into LocalizeBook at once from an Excel template using Batch Purchase Order.

Last updated: Nov 18, 2026

Batch Purchase Order lets you import many purchase orders into LocalizeBook at once from an Excel file. Use it to migrate open purchase orders from another system or to create a large number of purchase orders in one go.

Where to find it

Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions, then set Transaction Type to Purchase Order.

  1. Record limit: up to 2000 records per import. Split larger files into several imports.
  2. Currency: select the currency of the purchase orders.
  3. Before you start: the items and units in your file should match the items and units set up in LocalizeBook.

How to import purchase orders

Step 1. Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions.

Step 2. Set Transaction Type to Purchase Order. Select the Currency.

Step 3. Click Download Template to download the template for this transaction type.

Step 4. Fill in the template (see the column guide below) and save the Excel file.

Image

Step 5. Back in LocalizeBook, click Browse File and select your completed file. The rows are loaded on screen. If any row has a problem, an error message is shown so you can fix the file and load it again.

Step 6. When there are no errors, click Import to create the purchase orders.

Template column guide

Order details

  1. TRAN TYPE (required) – Enter PURCHASE_ORDER.
  2. DATE (required) – The order date.
  3. VENDOR (required) – The vendor's name.
  4. NUM – The purchase order reference number.
  5. STATUS – The order status. If left blank, it is set to ISSUED.
  6. LOCATION – The warehouse for the order. If left blank, the default location is used.
  7. CLASS – The class for the whole purchase order.
  8. MEMO – A description of the order. Leave blank if not needed.

Item lines

  1. ITEM CODE – The item's unique code. Leave blank if the item has no code.
  2. ITEM NAME (required) – The item name, exactly as set up in LocalizeBook.
  3. UNIT NAME – The item's unit name, as set up in LocalizeBook. If the item has no unit, enter N/A.
  4. QTY (required) – The quantity.
  5. COST (required) – The purchase price per base unit.
  6. AMOUNT (required) – The total amount for the line.
  7. VAT – If the item is taxable, enter the sales tax name. Otherwise leave blank.
  8. DISCOUNT AMOUNT – The discount amount. If left blank, the discount is 0.
  9. CLASS DETAIL – The class for the item line. Leave blank if not needed.

Common questions

How many purchase orders can I import at once? Up to 2,000 records per import.

What status do imported purchase orders get? The value in the STATUS column. If it is blank, the status is ISSUED.

Does importing a purchase order affect my accounts? No. A purchase order is a non-posting document. Your accounts change only when you receive the goods or record the bill.

Why does my import show an error? Common causes are a name (vendor, customer, or item) that does not exactly match an existing record in LocalizeBook, an account code that does not exist in your Chart of Accounts, a missing required column, or a file with more rows than the record limit.

How do I delete transactions that were imported by mistake? Go to Accounting > Bulk Operations > Batch Transactions > Delete Transactions, set the Transaction filter to Purchase Order, click Search, select the transactions, and click Delete Transactions.

Related Articles