Batch Sale Receipt

Import many paid sales (sale receipts) into LocalizeBook at once from an Excel template using Batch Sale Receipt.

Last updated: Nov 18, 2026

Batch Sale Receipt lets you import many sale receipts into LocalizeBook at once from an Excel file. A sale receipt records a sale where the customer pays at the time of sale, so no invoice is left open. Use it to migrate or record a large number of paid sales.

Note: For sales the customer will pay later, use Batch Invoice & Sale Return. To record payments against existing invoices, use Batch Collection (CMP).

Where to find it

Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions, then set Transaction Type to Sale Receipt.

  1. Record limit: up to 500 records per import. Split larger files into several imports.
  2. Currency: select the currency of the sale receipts.

How to import sale receipts

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

Step 2. Set Transaction Type to Sale Receipt. 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

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 sale receipts.

Template column guide

Transaction details

  1. TRAN TYPE – The transaction type. Use one of the values allowed in the downloaded template.
  2. DATE (required) – The transaction date.
  3. NUM (required) – The sale receipt number.
  4. CUSTOMER (required) – The customer's name.
  5. DEPOSIT_ACCOUNT CODE (required) – The Chart of Accounts code of the account the money is deposited into.
  6. DISCOUNT_ACCOUNT_CODE (required) – The Chart of Accounts code used for discounts.
  7. PAYMENT_METHOD – How the customer paid.
  8. LOCATION – The warehouse for the sale. If left blank, the default location is used.
  9. SALE_PERSON – The salesperson's name.
  10. TRUCK_NO – The truck number, if applicable.
  11. CLASS – The class for the transaction.
  12. MEMO – A note for the sale receipt.

Item lines

  1. ITEM CODE – The item's unique code. Leave blank if the item has no code.
  2. ITEM NAME (required) – The product name.
  3. UNIT NAME – The item's unit name. Do not include symbols. If the item has no unit, enter N/A.
  4. QTY (required) – The quantity.
  5. PRICE (required) – The sale price per base unit.
  6. AMOUNT (required) – The total amount for the line.
  7. VAT – The VAT amount.
  8. DISCOUNT AMOUNT – The discount amount.
  9. CLASS ITEM – The class for the item line.

Common questions

How many sale receipts can I import at once? Up to 500 records per import.

What is the difference between a sale receipt and an invoice? A sale receipt is paid at the time of sale. An invoice is paid later, so it stays in Accounts Receivable until the customer pays.

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 Sale Receipt, click Search, select the transactions, and click Delete Transactions.

Related Articles