Receipts Import Interface

Overview

The receipts interface is used to import receipts received from various banking and other payment channels. It is a generic format, (not in the format of any specific bank) and has the core information required to create a receipt.

This interface is typically used every day to import the previous days receipts.  The "Interfaces\Receipts Import" folder is polled at 12pm each day.

1. If the file is successfully processed it is placed in "Interfaces\Receipts Import\Archive".
2. If it is not able to be processed it is placed in the "Interfaces\Receipts Import\Error" folder with an error file explaining why.

This interface can also be manually run at any time from the Scheduled Tasks screen in the Utilmate CRM.

File Format

Must be a CSV file with the following columns (Bold = Mandatory):

batch_type - Must be one of CHEQUE, DIRECT, CASH, EFT, CRDCARD, WEB, DRECTDEBIT

account_number - Either the account number or sales customer number can be used.  The account number does not need to be a valid account number in Utilmate. However, if the account number cannot be found, the receipt will be loaded against the suspense debtor account (999999).  If the account number is longer than 10 digits, the interface expects the last digit to be the BPAY check digit and will remove this before processing.

date - The date must not be in the future and must be in DD/MM/YYYY format.

amount - Must be numeric with any $ or "," separators for thousands.

reference - Optional reference field.

Note:  The receipt interface file name must be unique. The same filename will not be processed twice.

Note: DIRECT DEBIT RECEIPTS DO NOT NEED TO BE IMPORTED AS THE SYSTEM HAS AUTOMAITCALLY CREATED THESE.

Tip:  Please see attached sample receipts import file