Import/Finance

Emersion Bulk Format

• ACCOUNT_ID (Emersion Account ID)
• 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
• PAYMENT_NOTE
• INVOICE_LIST (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

PAYMENT_METHOD

• ID|| PAYMENT_METHOD ||Description
• 1|| DIRECTDEBIT ||Direct Debit
• 2|| EFT|| EFT or Direct Deposit
• 3|| EFTPOS|| EFTPOS
• 4|| CASH|| Cash
• 5|| CHEQUE|| Cheque
• 6|| MORDER|| Money Order
• 7|| BPAY|| BPay
• 8|| PAYBYPHONE|| Pay By Phone
• 9|| POSTBILLPAY|| Australia Post Bill Pay
• 11|| AGENT|| Agent Collected
• 12|| INTERNAL|| Internal Charge
• 13|| VISA_MC|| Credit Card - VISA/MASTERCARD
• 14|| AMEX|| Credit Card - AMEX
• 15|| DINERS|| Credit Card - DINERS
• 16|| CONTRA|| Contra