Overview-Batch Transaction

Overview of Batch Transactions in LocalizeBook: the 11 transaction types you can import from Excel, record limits, and how a batch import works.

Last updated: Nov 18, 2026

Batch Transactions let you create many transactions in LocalizeBook at once by importing an Excel file, instead of entering each transaction by hand. Use them to bring existing data from another system into LocalizeBook (for example during data migration) or to record a large number of transactions quickly. You can also delete many transactions at once.

Where to find Batch Transactions

  1. Create Transactions (import): Accounting > Bulk Operations > Batch Transactions > Create Transactions
  2. Delete Transactions: Accounting > Bulk Operations > Batch Transactions > Delete Transactions

Transaction types you can import

On the Create Transactions page, choose one of these 11 options in the Transaction Type field:

Transaction Type

What it imports

Max records per import

Other fields on the page

Purchase and Purchase Return

Vendor bills and purchase returns (credits)

500

Account Payable (required), Currency

Invoice and Sale Return

Customer invoices and sale returns (credit memos)

500

Account Receivable (required), Currency

Expense

Cash expenses (paid immediately)

2,000

Currency

Bank Deposit

Bank deposits

2,000

None

Sale Receipt

Sales paid at the time of sale

500

Currency

Journal Entry

Journal entries to the general ledger

2,000

None

Purchase Order

Purchase orders

2,000

Currency

Sale Order

Sale orders

2,000

Currency

Payment (VDP)

Vendor payments

500

Currency

Collection (CMP)

Customer payments (collections)

500

Currency

Stock Issue

Stock issues

500

None

If your file has more rows than the limit, split it into several files and import them one at a time.

How a batch import works

  1. Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions.
  2. Choose the Transaction Type, and fill in any other fields shown, such as Account Payable, Account Receivable, or Currency.
  3. Click Download Template. The template matches the transaction type you selected.
  4. Fill in the template and save the Excel file. Do not change the column names or the structure of the template.
  5. Click Browse File and select your file. The rows are loaded on screen, and any errors are shown so you can fix the file and load it again.
  6. Click Import to create the transactions.

Detailed guides

Each transaction type has its own article with a full template column guide:

  1. Batch Purchase & Purchase Return
  2. Batch Invoice & Sale Return
  3. Batch Cash Expense
  4. Batch Sale Receipt
  5. Batch Journal Entry
  6. Batch Purchase Order
  7. Batch Sale Order
  8. Batch Payment (VDP)
  9. Batch Collection (CMP)
  10. Batch Delete Transactions

Common questions

Which template should I use? Select the Transaction Type first, then click Download Template. Always use the latest template from LocalizeBook.

Why does my import show an error? Common causes are names (vendor, customer, or item) that do not match records in LocalizeBook, account codes that do not exist in your Chart of Accounts, missing required columns, or more rows than the record limit.

How do I remove transactions I imported by mistake? Use Accounting > Bulk Operations > Batch Transactions > Delete Transactions. Deleted transactions cannot be recovered.

Related Articles