Batch Journal Entry lets you import many journal entries into the general ledger in LocalizeBook at once from an Excel file. Use it to migrate historical journal transactions from another system, post opening balances, or record a large number of adjustments.
Each journal entry must balance: the total debits must equal the total credits.
Where to find it
Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions, then set Transaction Type to Journal Entry.
- Record limit: up to 2000 records per import. Split larger files into several imports.
- There is no Currency or account field on this page. All accounts are set in the template.
How to import journal entries
Step 1. Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions.
Step 2. Set Transaction Type to Journal Entry.
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.
)
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 journal entries.

Template column guide
Journal details
- DATE (required) – The journal date.
- NUM – The journal entry number.
- MEMO – A note for the journal entry. Leave blank if not needed.
- CLASS – The class for the journal entry.
- ADJUST-ENTRY – Enter TRUE for an adjusting entry or FALSE for a general entry. If left blank, the entry is treated as a general entry.
Journal lines
- ACCOUNT CODE – The Chart of Accounts code for the line.
- DEBIT – The debit amount.
- CREDIT – The credit amount.
- MEMO DETAIL (required) – A description of the line.
- NAME (required) – The name (customer, vendor, or other name) for the line.
- CLASS DETAIL – The class for the line.
Common questions
How many journal lines can I import at once? Up to 2,000 records per import. Split larger files, for example one file per year or per month.
Why is my journal entry rejected? The most common cause is that the debits and credits for the same journal entry do not add up to the same total. Also check that every account code exists in your Chart of Accounts.
How do I mark a journal as an adjusting entry? Enter TRUE in the ADJUST-ENTRY column.
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 Journal Voucher, click Search, select the transactions, and click Delete Transactions.