Data Import/Payments - Revision history

Scarpenter at 01:29, 5 February 2018

2018-02-05T01:29:03Z

Scarpenter: Replaced content with "{{DISPLAYTITLE:Bulk Import Payments}} =This Content Has Moved House= This article has been moved to our new home for documentation and help content, the new Emersion Know..."

2017-10-13T04:11:54Z

Replaced content with "{{DISPLAYTITLE:Bulk Import Payments}} =This Content Has Moved House= This article has been moved to our new home for documentation and help content, the new Emersion Know..."

Dcowan: added aba file format link

2016-09-28T05:07:45Z

added aba file format link

Scarpenter: /* Emersion File Format */

2015-12-21T03:56:55Z

‎Emersion File Format

Scarpenter: /* Emersion File Format */

2015-12-21T03:45:44Z

‎Emersion File Format

Scarpenter: /* Emersion File Format */

2015-12-21T03:40:07Z

‎Emersion File Format

Scarpenter: /* Bulk Import Payments */

2015-12-21T01:08:45Z

‎Bulk Import Payments

Medge: /* Emersion File Format */

2015-12-03T00:23:34Z

‎Emersion File Format

Medge: /* Emersion File Format */

2015-12-03T00:20:35Z

‎Emersion File Format

Medge: /* Emersion File Format */

2015-12-03T00:19:51Z

‎Emersion File Format

@@ Line 6: / Line 6: @@
 We are sorry for the untidiness while we are shifting locations and we appreciate your patience during the transition to out new home.
-[https://resources.emersion.com/display/EKB/Ledger+Code+Mapping+with+Xero+Integration Take me to the Emersion Knowledge Base article]
+[https://resources.emersion.com/display/EKB/Payments Take me to the Emersion Knowledge Base article]
 [[file:new_home_sm.jpg|900px]]

@@ Line 1: / Line 1: @@
-= Bulk Import Payments  =
+{{DISPLAYTITLE:Bulk Import Payments}}
-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]
-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]]

← Older revision		Revision as of 05:07, 28 September 2016
Line 90:		Line 90:
	===ABA File Format===		===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.	+	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

@@ Line 74: / Line 74: @@
 |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, delimited 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 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.

@@ Line 54: / Line 54: @@
 | The BPAY reference number if the payment method is BPAY
 |-
-|'CUST_REFERENCE'
+|'CUST_REFERENCE' text field for a customer reference if required.
 |-
 |'AMOUNT'
@@ Line 73: / Line 72: @@
 |-
 |'INVOICE_LIST'
-|Enter an invoice number, or a pipe delimited list of invoice numbers. If the field is left blank, the payment will be created as an unallocated payment. If using a pipe delimited list, the invoice numbers must be in the same order as the corresponding payments in the INVOICE_ALLOCATION_LIST field.
+|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'''.
 |-
 |'INVOICE_ALLOCATION_LIST'
@@ Line 79: / Line 82: @@
 |-
 |'SURCHARGE_IN_AMOUNT'
-|If the surcharge is contained in the amount entered in the INVOICE_ALLOCATION_LIST field, enter 'TRUE'. Otherwise, leave this field blank.
+|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'

@@ Line 76: / Line 76: @@
 |-
 |'INVOICE_ALLOCATION_LIST'
-| Enter an amount in dollars (ex/inc TAX), or a pipe delimited list of dollar amounts.
+| REDUNDANT. Leave this blank. Do not remove the column.
 |-
 |'SURCHARGE_IN_AMOUNT'
@@ Line 85: / Line 84: @@
 |If the SURCHARGE_AMOUNT includes tax enter 'TRUE'. Otherwise, leave this field blank.
 |}
 ===ABA File Format===

@@ Line 1: / Line 1: @@
-= Bulk Import Payments =
+= Bulk Import Payments  =
-The ''Bulk Import'' function allows you to import payment details received from external sources, e.g. [[BPAY|BPAY]] etc. The payments are then applied against customer accounts without requiring manual entry using the [[Receive_Payment|''Receive Payment'']] or [[Take_Payment|''Take Payment'']] functions.
+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.
-Emersion supports two import file formats: Emersion Format Comma Separated Value file (.CSV), and Australian Bankers Association format (.ABA).
+Emersion provides two tools for importing payments
-==Emersion File Format==
+# Bulk Import Payments
-NOTE: The format for the Emersion File Format has changed. Please review the below carefully.
+The two importers import different types of payments and handle different payment methods.  Ensure you use the correct tool when wanting to import payments.
 The Emersion Bulk Payment file is in .CSV format, as follows:
@@ Line 17: / Line 40: @@
 |-
 |'PAYMENT_DATE'
-|(YYYY-MM-DD)
+|Mandatory. This must be in the format of YYYY-MM-DD.
 |-
 |'PAYMENT_TIME'
-|(HH:MM:SS)
+|Mandatory. This must be in the format of HH:MM:SS.
 |-
 |'ACCOUNT_ID'
-|(Emersion Account ID e.g 123456)
+|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'
@@ Line 35: / Line 58: @@
 |-
 |'AMOUNT'
-|(INC TAX)
+|Mandatory. The full payment amount '''inclusive''' of tax
 |-
 |'SURCHARGE_AMOUNT'
-|(EX TAX)
+|The surcharge amount '''exclusive''' of tax
 |-
 |'SURCHARGE_PERCENT'
-|(As a whole Number e.g 3% = '3')
+|Enter a whole number e.g. 3% = '3'
 |-
 |'PAYMENT_METHOD'
-|(See Below Ref Table)
+|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'
-|Pipe Delimited 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.
+|Enter an invoice number, or a pipe delimited list of invoice numbers. If the field is left blank, the payment will be created as an unallocated payment. If using a pipe delimited list, the invoice numbers must be in the same order as the corresponding payments in the INVOICE_ALLOCATION_LIST field.
 |-
 |'INVOICE_ALLOCATION_LIST'
-|Pipe Delimited list if $ amounts in the same order as the Invoices in the Invoice List.
+| Enter an amount in dollars (ex/inc TAX), or a pipe delimited list of dollar amounts.
 |-
 |'SURCHARGE_IN_AMOUNT'
-|(true - when the surcharge is contained in the amount)
+|If the surcharge is contained in the amount entered in the INVOICE_ALLOCATION_LIST field, enter 'TRUE'. Otherwise, leave this field blank.
 |-
 |'SURCHARGE_AMOUNT_INC_TAX'
-|(true - when the surcharge (amount) already includes tax)
+|If the SURCHARGE_AMOUNT includes tax enter 'TRUE'. Otherwise, leave this field blank.
 |}
-==ABA File Format==
+===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.
 == Manual Payment Imports ==

@@ Line 12: / Line 12: @@
 {| border="1" style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000; padding: 0"
-|-|'''Field'''|'''Description'''
+|-
-|-|'PAYMENT_DATE'|(YYYY-MM-DD)
+|'''Field'''
-|-|'PAYMENT_TIME'|(HH:MM:SS)
+|'''Description'''
-|-|'ACCOUNT_ID'|(Emersion Account ID e.g 123456)
+|-
-|-|'BPAY_BILLER_CODE'|
+|'PAYMENT_DATE'
-|-|'BPAY_REFERENCE'|
+|(YYYY-MM-DD)
-|-|'CUST_REFERENCE'|
+|-
-|-|'AMOUNT'|(INC TAX)
+|'PAYMENT_TIME'
-|-|'SURCHARGE_AMOUNT'|(EX TAX)
+|(HH:MM:SS)
-|-|'SURCHARGE_PERCENT'|(As a whole Number e.g 3% = '3')
+|-
-|-|'PAYMENT_METHOD'|(See Below Ref Table)
+|'ACCOUNT_ID'
-|-|'PAYMENT_NOTE' |
+|(Emersion Account ID e.g 123456)
-|-|'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)
+|'BPAY_BILLER_CODE'
 |-|'SURCHARGE_IN_AMOUNT'|(true - when the surcharge is contained in the amount)
-|-|'SURCHARGE_AMOUNT_INC_TAX'|(true - when the surcharge (amount) already includes tax)
+|-
 |}