|
|
| Line 1: |
Line 1: |
| − | = Bulk Import Payments =
| + | {{DISPLAYTITLE:Bulk Import Payments}} |
| | + | =This Content Has Moved House= |
| | | | |
| − | Emersion provides ways to upload payments into the system quickly and easily. The payments are applied against customer accounts without requiring any manual data entry required when using the the [[Receive_Payment|''Receive Payment'']] or [[Take_Payment|''Take Payment'']] functions.
| + | This article has been moved to our new home for documentation and help content, the new Emersion Knowledge Base. |
| | | | |
| − | Emersion provides two tools for importing payments
| + | We are sorry for the untidiness while we are shifting locations and we appreciate your patience during the transition to out new home. |
| | | | |
| − | # Bulk Import Payments
| + | [https://resources.emersion.com/display/EKB/Ledger+Code+Mapping+with+Xero+Integration Take me to the Emersion Knowledge Base article] |
| − | # Manual Payment Importer
| |
| | | | |
| − | The two importers import different types of payments and handle different payment methods. Ensure you use the correct tool when wanting to import payments.
| + | [[file:new_home_sm.jpg|900px]] |
| − | | |
| − | == Bulk Import Payments ==
| |
| − | | |
| − | '''Nav: Finance > Bulk Import > Import Payments
| |
| − | | |
| − | This importer handles:
| |
| − | * The standard Emersion payments format (.CSV)
| |
| − | * Australian Bankers Association format (.ABA)
| |
| − | | |
| − | # 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.
| |
| − | | |
| − | | |
| − | | |
| − | === Emersion File Format ===
| |
| − | | |
| − | NOTE: The format for the Emersion File Format has recently changed. Please review below carefully.
| |
| − | | |
| − | The Emersion Bulk Payment file is in .CSV format, as follows:
| |
| − | | |
| − | {| border="1" style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000; padding: 0"
| |
| − | |-
| |
| − | |'''Field'''
| |
| − | |'''Description'''
| |
| − | |-
| |
| − | |'PAYMENT_DATE'
| |
| − | |Mandatory. This must be in the format of YYYY-MM-DD.
| |
| − | |-
| |
| − | |'PAYMENT_TIME'
| |
| − | |Mandatory. This must be in the format of HH:MM:SS.
| |
| − | |-
| |
| − | |'ACCOUNT_ID'
| |
| − | |Mandatory. The Emersion account ID of the customer for which the payment belongs.
| |
| − | |-
| |
| − | |'BPAY_BILLER_CODE'
| |
| − | | The BPAY Biller code if the payment method is BPAY
| |
| − | |-
| |
| − | |'BPAY_REFERENCE'
| |
| − | | The BPAY reference number if the payment method is BPAY
| |
| − | |-
| |
| − | |'CUST_REFERENCE' text field for a customer reference if required.
| |
| − | |-
| |
| − | |'AMOUNT'
| |
| − | |Mandatory. The full payment amount '''inclusive''' of tax
| |
| − | |-
| |
| − | |'SURCHARGE_AMOUNT'
| |
| − | |The surcharge amount '''exclusive''' of tax
| |
| − | |-
| |
| − | |'SURCHARGE_PERCENT'
| |
| − | |Enter a whole number e.g. 3% = '3'
| |
| − | |-
| |
| − | |'PAYMENT_METHOD'
| |
| − | |Mandatory. Accepted payment methods are:<br /> *VISA_MC, AMEX, DINERS, CONTRA, AGENT, DIRECTDEBIT, EFT, EFTPOS, CASH, CHEQUE, MORDER, BPAY, PAYBYPHONE, POSTBILLPAY, CREDITCARD, CCOLLECTION, SECUREPAYIVR, XERO<br />
| |
| − | |-
| |
| − | |'PAYMENT_NOTE'
| |
| − | |Record a note against the payment
| |
| − | |-
| |
| − | |'INVOICE_LIST'
| |
| − | |Enter a list of invoice numbers and amounts separated by a colon. For example if you wanted to allocate a $200 payment to invoice number 123456 then enter '''123456:200.00'''.
| |
| − | | |
| − | If you wish to allocate multiple payments to the same account to different invoices for the same customer, delimit the list with a pipe. For example if you have a payment of $500 and wanted to allocate $200 to invoice 999999 and the remainder of the $500 to invoice 445566 then enter '''999999:500.00|445566:300.00'''.
| |
| − | | |
| − | If the field is left blank, the payment will be created as an unallocated payment.
| |
| − | |-
| |
| − | |'INVOICE_ALLOCATION_LIST'
| |
| − | | REDUNDANT. Leave this blank. Do not remove the column.
| |
| − | |-
| |
| − | |'SURCHARGE_IN_AMOUNT'
| |
| − | |If the surcharge is contained in the amount(s) entered in the INVOICE_LIST field, enter 'TRUE'. Otherwise, leave this field blank.
| |
| − | |-
| |
| − | |'SURCHARGE_AMOUNT_INC_TAX'
| |
| − | |If the SURCHARGE_AMOUNT includes tax enter 'TRUE'. Otherwise, leave this field blank.
| |
| − | |}
| |
| − | | |
| − | ===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.
| |
| − | | |
| − | See https://www.cemtexaba.com/aba-format/cemtex-aba-file-format-details
| |
| − | | |
| − | | |
| − | == 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
| |
| − | | |
| − | <mediaplayer MWPlayerConfig="MyCustomConfig" height="400" width="600">http://wiki.emersion.com.au/wiki/media/manual_payment_import.mp4</mediaplayer>
| |
| − | | |
| − | = See Also =
| |
| − | * [[Payments|Payments]]
| |
| − | * [[EPS|EPS]]
| |
| − | * [[BPAY|BPAY]]
| |
| − | * [[Invoicing|Invoicing]]
| |
This article has been moved to our new home for documentation and help content, the new Emersion Knowledge Base.
We are sorry for the untidiness while we are shifting locations and we appreciate your patience during the transition to out new home.
