Difference between revisions of "Data Import/Payments"
(→Emersion File Format) |
(→Emersion File Format) |
||
| Line 12: | Line 12: | ||
{| border="1" style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000; padding: 0" | {| border="1" style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000; padding: 0" | ||
| − | |-|'''Field'''|'''Description''' | + | |- |
| − | |-|'PAYMENT_DATE'|(YYYY-MM-DD) | + | |'''Field''' |
| − | |-|'PAYMENT_TIME'|(HH:MM:SS) | + | |'''Description''' |
| − | |-|'ACCOUNT_ID'|(Emersion Account ID e.g 123456) | + | |- |
| − | |-|'BPAY_BILLER_CODE'| | + | |'PAYMENT_DATE' |
| − | |-|'BPAY_REFERENCE'| | + | |(YYYY-MM-DD) |
| − | |-|'CUST_REFERENCE'| | + | |- |
| − | |-|'AMOUNT'|(INC TAX) | + | |'PAYMENT_TIME' |
| − | |-|'SURCHARGE_AMOUNT'|(EX TAX) | + | |(HH:MM:SS) |
| − | |-|'SURCHARGE_PERCENT'|(As a whole Number e.g 3% = '3') | + | |- |
| − | |-|'PAYMENT_METHOD'|(See Below Ref Table) | + | |'ACCOUNT_ID' |
| − | |-|'PAYMENT_NOTE' | | + | |(Emersion Account ID e.g 123456) |
| − | |-|'INVOICE_LIST' |(Pipe Delimited list e.g 123456 | 1234466)(If blank will be Unallocated Payment. Where INVOICE_LIST and INVOICE_ALLOCATION_LIST are pipe delimited fields including which invoices are to be paid, and how much is meant to be allocated.) | + | |- |
| − | |-|'INVOICE_ALLOCATION_LIST'|(Pipe Delimited list if $ amounts in the same order as the Invoices in the Invoice List e.g 120 | 230) | + | |'BPAY_BILLER_CODE' |
| − | |-|'SURCHARGE_IN_AMOUNT'|(true - when the surcharge is contained in the amount) | + | | |
| − | |-|'SURCHARGE_AMOUNT_INC_TAX'|(true - when the surcharge (amount) already includes tax) | + | |- |
| + | |'BPAY_REFERENCE' | ||
| + | | | ||
| + | |- | ||
| + | |'CUST_REFERENCE' | ||
| + | | | ||
| + | |- | ||
| + | |'AMOUNT' | ||
| + | |(INC TAX) | ||
| + | |- | ||
| + | |'SURCHARGE_AMOUNT' | ||
| + | |(EX TAX) | ||
| + | |- | ||
| + | |'SURCHARGE_PERCENT' | ||
| + | |(As a whole Number e.g 3% = '3') | ||
| + | |- | ||
| + | |'PAYMENT_METHOD' | ||
| + | |(See Below Ref Table) | ||
| + | |- | ||
| + | |'PAYMENT_NOTE' | ||
| + | | | ||
| + | |- | ||
| + | |'INVOICE_LIST' | ||
| + | |(Pipe Delimited list e.g 123456 | 1234466)(If blank will be Unallocated Payment. Where INVOICE_LIST and INVOICE_ALLOCATION_LIST are pipe delimited fields including which invoices are to be paid, and how much is meant to be allocated.) | ||
| + | |- | ||
| + | |'INVOICE_ALLOCATION_LIST' | ||
| + | |(Pipe Delimited list if $ amounts in the same order as the Invoices in the Invoice List e.g 120 | 230) | ||
| + | |- | ||
| + | |'SURCHARGE_IN_AMOUNT' | ||
| + | |(true - when the surcharge is contained in the amount) | ||
| + | |- | ||
| + | |'SURCHARGE_AMOUNT_INC_TAX' | ||
| + | |(true - when the surcharge (amount) already includes tax) | ||
|} | |} | ||
Revision as of 10:19, 3 December 2015
Contents
Bulk Import Payments
The Bulk Import function allows you to import payment details received from external sources, e.g. BPAY etc. The payments are then applied against customer accounts without requiring manual entry using the Receive Payment or Take Payment functions.
Emersion supports two import file formats: Emersion Format Comma Separated Value file (.CSV), and Australian Bankers Association format (.ABA).
Emersion File Format
NOTE: The format for the Emersion File Format has changed. Please review the below carefully.
The Emersion Bulk Payment file is in .CSV format, as follows:
| Field | Description |
| 'PAYMENT_DATE' | (YYYY-MM-DD) |
| 'PAYMENT_TIME' | (HH:MM:SS) |
| 'ACCOUNT_ID' | (Emersion Account ID e.g 123456) |
| 'BPAY_BILLER_CODE' | |
| 'BPAY_REFERENCE' | |
| 'CUST_REFERENCE' | |
| 'AMOUNT' | (INC TAX) |
| 'SURCHARGE_AMOUNT' | (EX TAX) |
| 'SURCHARGE_PERCENT' | (As a whole Number e.g 3% = '3') |
| 'PAYMENT_METHOD' | (See Below Ref Table) |
| 'PAYMENT_NOTE' | |
| 'INVOICE_LIST' | 1234466)(If blank will be Unallocated Payment. Where INVOICE_LIST and INVOICE_ALLOCATION_LIST are pipe delimited fields including which invoices are to be paid, and how much is meant to be allocated.) |
| 'INVOICE_ALLOCATION_LIST' | 230) |
| 'SURCHARGE_IN_AMOUNT' | (true - when the surcharge is contained in the amount) |
| 'SURCHARGE_AMOUNT_INC_TAX' | (true - when the surcharge (amount) already includes tax) |
ABA File Format
The Australian Bankers Association (ABA) file format is used by many banks for batch transactions. Though not an Australian standard, many banks have adopted this format (e.g. Bank of Queensland, NAM, Westpac etc). The ABA file format is also known as a Direct Entry file or Centrex file. It has the file extension .ABA and is a standard ASCII file. Please contact your bank or financial institution for further information about obtaining your payment information in ABA format.
Bulk Import
- Select Finance > Bulk Import from the Menu. The Import Payments page will appear.
- Select the file type of the payment file to import by clicking the required file type option button, either Emersion Bulk Format, or ABA. You can click the Sample Format File link beside the file option to display the file format.
- Click the Browse button beside the * CSV File to Import field. A File Upload window will appear.
- Navigate to and select the required payment file and click the Open button. The selected file name will appear in the * CSV File to Import field.
- Click the Upload File and Verify button. The system will verify the file is in the correct format. Once verified, the Import Payments – Preview File & Confirm page will display.
- Click the Confirm Import button. A window will appear to prompt you to confirm the upload.
- Click the Yes button to confirm the file upload. The system will process the payments in the file, and update the accounts’ payment details with the payment information.
- Click the No button to cancel the file upload.
Manual Payment Imports
There is an additional feature that allows a user to bulk import payments that are sourced from the following providers;
* Secure Pay IVR * Aust Post Bill Pay * Commbiz Bpay
The media player is loading...
