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 (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)

Sample record: ACCOUNT_ID,PAYMENT_DATE,PAYMENT_TIME,BPAY_BILLER_CODE,BPAY_REFERENCE,CUST_REFERENCE,AMOUNT,SURCHARGE_AMOUNT,SURCHARGE_PERCENT,PAYMENT_METHOD,PAYMENT_NOTE,INVOICE_LIST,INVOICE_ALLOCATION_LIST,SURCHARGE_IN_AMOUNT,SURCHARGE_AMOUNT_INC_TAX 5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true 5999998,2013-12-01,,,,123456,50.00,,,VISA_MC,IVR,123456|123457,20|30,true,true

Sample file: Media:Payment bulk import sample file.csv

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