Batch Payment (VDP) lets you import many vendor payments into LocalizeBook at once from an Excel file, instead of entering each payment by hand. Use it to pay bills in bulk or to migrate existing vendor payment data.
Note: For expenses paid immediately without a bill, use Batch Cash Expense. To import unpaid bills, use Batch Purchase & Purchase Return.
Where to find it
Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions, then set Transaction Type to Payment (VDP).
- Record limit: up to 500 records per import. Split larger files into several imports.
- Currency: select the currency of the payments.
- Before you start: the vendors in your file must already exist in LocalizeBook.
How to import vendor payments
Step 1. Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions.
Step 2. Set Transaction Type to Payment (VDP). 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.
)
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 vendor payments.

Template column guide
Payment details
- TRAN_NUMBER – A unique number you create for each payment. All rows that belong to the same payment must use the same TRAN_NUMBER.
- VENDOR – The vendor's name. It must exactly match a vendor that already exists in LocalizeBook.
- DATE – The transaction date, in the format MM/DD/YYYY.
- PAYMENT_METHOD – How the payment is made, for example Cheque, Bank Transfer, or Cash.
- ACCOUNT_CODE – The account code from your Chart of Accounts for this line.
- PAYMENT_AMOUNT – The amount for this line. Leave it blank on rows used for an other charge.
- NUMBER – The vendor's original invoice or bill number.
- CHEQUE_TO – If paying by cheque, the payee name. If left blank, the vendor name is used.
- CHEQUE_NO – If paying by cheque, the cheque number.
- REFERENCE – An internal reference number for your own tracking.
- MEMO – A description for the line. It appears on reports.
- BRANCH_CODE – The branch code for the line.
- CLASS – The class for the line, used for internal tracking.
- EXCHANGE_RATE – The exchange rate, if the payment is in a foreign currency.
- DISCOUNT_AMOUNT – The amount of any discount on the line.
- DISCOUNT_ACCOUNT_CODE – The account code used to record the discount.
Other charges (for example shipping or handling fees)
- MEMO_OTHER_CHARGE – A description of the other charge.
- AMOUNT_OTHER_CHARGE – The amount of the other charge. Leave it blank on the main payment row.
- ACCOUNT_CODE_OTHER_CHARGE – The Chart of Accounts code for the other charge.
- VAT_OTHER_CHARGE – The VAT code or amount for the other charge.
- WHT_OTHER_CHARGE – The withholding tax code or amount for the other charge.
- GROSS_NET_OTHER_CHARGE – Whether the other charge amount is Gross or Net of tax.
- CUSTOMER_PROJECT_OTHER_CHARGE – The customer or project, if the charge is billable to a customer.
- BRANCH_CODE_OTHER_CHARGE – The branch code for the other charge.
- CLASS_OTHER_CHARGE – The class for the other charge.
Common questions
How many vendor payments can I import at once? Up to 500 records per import.
How do I add a shipping or handling fee to a payment? Add a separate row with the same TRAN_NUMBER and fill in the _OTHER_CHARGE columns. Leave PAYMENT_AMOUNT blank on that row.
What does VDP mean? VDP is the transaction code LocalizeBook uses for vendor payments. The matching code for customer payments is CMP (Collection).
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 Payment, click Search, select the transactions, and click Delete Transactions.