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

• 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