Import/Finance

Emersion Bulk Format

• ACCOUNT_ID (Emersion Account ID e.g 123456)
• PAYMENT_DATE (YYYY-MM-DD)
• PAYMENT_TIME (HH:MM:SS)
• BPAY_BILLER_CODE
• BPAY_REFERENCE
• CUST_REFERENCE
• AMOUNT (INC TAX)
• SURCHARGE_AMOUNT (INC 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 e.g 120 | 230)

PAYMENT_METHOD

• PAYMENT_METHOD ||Description
• DIRECTDEBIT ||Direct Debit
• EFT|| EFT or Direct Deposit
• EFTPOS|| EFTPOS
• CASH|| Cash
• CHEQUE|| Cheque
• MORDER|| Money Order
• BPAY|| BPay
• PAYBYPHONE|| Pay By Phone
• POSTBILLPAY|| Australia Post Bill Pay
• AGENT|| Agent Collected
• INTERNAL|| Internal Charge
• VISA_MC|| Credit Card - VISA/MASTERCARD
• AMEX|| Credit Card - AMEX
• DINERS|| Credit Card - DINERS
• CONTRA|| Contra