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
- Create Transactions (import): Accounting > Bulk Operations > Batch Transactions > Create Transactions
- 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
- Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions.
- Choose the Transaction Type, and fill in any other fields shown, such as Account Payable, Account Receivable, or Currency.
- Click Download Template. The template matches the transaction type you selected.
- Fill in the template and save the Excel file. Do not change the column names or the structure of the template.
- 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.
- Click Import to create the transactions.
Detailed guides
Each transaction type has its own article with a full template column guide:
- Batch Purchase & Purchase Return
- Batch Invoice & Sale Return
- Batch Cash Expense
- Batch Sale Receipt
- Batch Journal Entry
- Batch Purchase Order
- Batch Sale Order
- Batch Payment (VDP)
- Batch Collection (CMP)
- 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.