If you have an existing data of Collection (CMP) and you want entry to the Localizebook system you can use the Batch Collection (CMP) function.

Go to Batch Collection (CMP) transaction into system:

1. Go to the Accounting menu.
2. Click on Batch Transaction.
3. Choose Transaction Type “Collection (CMP)”
4. Click on the Click this link to download the working template.

1. Fill in the information for each function and save your excel file:
2. CUSTOMER: The name of the Customer. This must exactly match a customer name that already exists in the system.
3. DATE: The date the payment was received. Check your system’s required format (e.g., DD/MM/YYYY).
4. PAYMENT_METHOD: The method the customer used to pay (e.g., Cheque, Bank Transfer, Cash).
5. BRANCH_CODE: The branch code associated with this transaction for internal tracking.
6. CLASS: The class associated with this transaction for internal tracking.
7. DEPOSIT_ACCOUNT_CODE: The account from your Chart of Accounts where the funds will be deposited (e.g., ‘Chequing Account’ or ‘Undeposited Funds’).
8. SALE_PERSON: The salesperson associated with this customer or sale.
9. NUMBER: A reference number for the payment, such as the customer’s cheque number.
10. MEMO: A general description for the entire payment transaction.
11. EXCHANGE_RATE: If the payment is in a foreign currency, enter the exchange rate.
12. DISCOUNT_ACCOUNT_CODE: If a discount is given, specify the account code for that discount.
13. DISCOUNT_PROJECT: If a discount applies to a specific customer project, enter it here.
14. TRAN_NUMBER: A unique identifier you create for this collection. All rows for the same payment must have the same TRAN_NUMBER.
15. DISCOUNT_AMOUNT: The value of any early payment discount taken by the customer.
16. PAYMENT_AMOUNT: The principal amount received from the customer. Do not fill this if the row is for an “Other Charge”.
17. MEMO_OTHER_CHARGE: A description for the adjustment (e.g., Bank Fee, Processing Charge).
18. AMOUNT_OTHER_CHARGE: The value of the adjustment. This is often a negative value if it’s a fee. Do not fill this if the row is for the main payment.

1. After filling all the information please back to the system:
2. Click on Browse File and select the template with the collection data. If data is loaded, you are ready to import. But if there is any error, messages will be shown.
3. Click on Import to take all your collection data into Localize.