PAC - Electronic Receipts Parameters (SU)
Overview
The Electronic Receipts Parameters program is used to set up the merchant parameters that you will be using to upload electronic receipt information using Finance > Parent Accounts > Receipting > Electronic Receipts Processing.
Fields that require further explanation | |
|---|---|
Merchant ID | Enter the Merchant ID Number provided by your financial institution. |
Merchant Description | The Description provided by your financial institution. |
Merchant Username / Password | This field is now redundant. It was used for Smartapay functionality that is no longer supported. |
There are three prescribed TASS.web file formats that must be adhered to for a successful file upload:
Fee Account Payments.
Sundry Payments.
Enrolment Payments.
Fee Account Payments
The upload file provided by electronic payment service providers to TASS schools should be in CSV format with the following 10 fields (in this order):
Field Name | Field Type (Size) | *Constraint | Details |
|---|---|---|---|
submit_time | date/time year to seconds | M | The date and time of payment |
trans_amt | money(10,2) | M | The total amount of the payment received – this must be equal to the sum: (fee_amt + build_amt + other_amt – discount_amt). |
merchant_id | char(30) | O | The merchant ID code. |
batch_num | integer | M | This is critical for TASS and must be a unique identifier for the settlement batch to which the payment belongs. |
receipt_num | char(12) | O | Vendor generated receipt reference number for audit trail. |
par_code | char(8) | M | The parent's account code at the school — this will need to be validated at the point of capture. |
fee_amt | money(10,2) | M | The amount of the payment allocated to the fee account. Must be > 0. |
build_amt | money(10,2) | M | The amount of the payment allocated to the building fund. Must be >= 0. |
other_amt | money(10,2) | M | The amount of the payment allocated to the GL Account setup in 'Usual Receipt Distribution Area 1' in program Finance > Parent Accounts > Setup Information > Parent Accounts Setup on the 'Receipting' tab. Must be >= 0. |
discount_amt | money(10,2) | M | The amount of the discount to be given against the fee account. Must be >= 0. |
*Constraints: M = Mandatory, O = Optional.
Example Sample Record
2007-07-11 08:10:10,1500.00,ABCDE371,20070711,657575,COLL001,1212.00,250.00,50.00,12.00
2007-07-11 08:55:30,2000.00,ABCDE371,20070711,657576,COTT001,2000.00,0.00,0.00,0.00
2007-07-11 22:36:19,2000.00,ABCDE371,20070712,657577,DAVE001,1800.00,0.00,200.00,0.00
2007-07-11 23:36:19,430.00,ABCDE371,20070712,657578,DAVE002,400.00,30.00,0.00,0.00
Important!
Records must contain 10 fields and optional fields should be represented by null or zeros as a place holder.
Sundry Payments
The upload file provided by electronic payment service providers to TASS schools should be in CSV format with the following 21 fields (in this order):
Field No. | Field Name | Field Type (Size) | Field Description |
|---|---|---|---|
1 | Date/Time of Payment | Date/Time year to seconds | Mandatory. The date or date/ time of the payment. Data Example for 15 July 2011 at 3:45 p.m. = '2011-07-15 15:45:00'. Data Example for 15 July 2011 = '2011-07-15'. |
2 | Payment Amount | Money(10,2) | Mandatory. It must be greater than $0.00. The total amount of the payment. It must be equal to Distribution Amount + Tax Amount. |
3 | Merchant ID | Char(30) | Optional. The Merchant's ID Code. |
4 | Batch Number | Integer | Mandatory. This is critical for TASS and must be a unique identifier for the settlement batch to which the payment belongs. |
5 | Receipt Reference | Char(12) | Optional. Vendor generated receipt reference number for audit trail. |
6 | Received From | Char(30) | Mandatory. The full name of the payer. |
7 | Address Line 1 | Char(30) | Optional. Address Line 1 of the payer. |
8 | Address Line 2 | Char(30) | Optional. Address Line 2 of the payer. |
9 | Address Line 3 | Char(30) | Optional. Address Line3 of the payer. |
10 | Town/Suburb | Char(30) | Optional. Town/Suburb of the payer. |
11 | State | Char(3) | Optional. State of the payer. |
12 | Postcode | Char(10) | Optional. Postcode of the payer. |
13 | Country | Char(20) | Optional. Country of the payer. |
14 | Comment Text | Char(30) | Mandatory. Information about the Payment. (Added to Comment Line 1 when receipt is generated.) |
15 | GL Account Code | char(18) | Mandatory. It must be a valid account code that is 'open'. |
16 | Nett Distribution Amount | Money(10,2) | Mandatory. It must be greater than or equal to $0.00. The tax exclusive amount distributed to the GL Account. |
17 | Tax Amount | Money(10,2) | Mandatory. It must be greater than or equal to $0.00. The tax amount of this payment. |
18 | Tax Code | char(3) | Mandatory. It must be a valid tax code. |
19 | Donor Number | Integer | If there is an entry in this field it must be a valid Donor Number from the TASS.web Fundraising module. The field becomes mandatory if:
|
20 | Appeal Code | Char(4) | If there is an entry in this field it must be a valid Appeal Code from the TASS.web Fundraising Module. The field becomes mandatory if:
|
21 | Pledge Number | Integer | Optional. If present, it must be a valid Pledge Number for the Donor Number in field 19 above (Field 19 must be not null). |
|
Important! Records must contain 21 fields and optional fields should be represented by null as a place holder. | |||
Enrolment Payments
The upload file provided by electronic payment service providers to TASS schools should be in CSV format with the following 21 fields (in this order):
Field No. | Field Name | Field Type (Size) | Field Description |
|---|---|---|---|
1 | Date/Time of Payment | Date/Time year to seconds | Mandatory. The date or date/ time of the payment. Data Example for 20 November 2017 at 3:45 p.m. = '2017-11-20 15:45:00'. Data Example for 20 November 2017 = '2017-11-20'. |
2 | Payment Amount | Money(10,2) | Mandatory. The total amount of the payment. It must be greater than $0.00. It must be equal to Distribution Amount + Tax Amount. |
3 | Merchant ID | Char(30) | Optional. The Merchant's ID Code. |
4 | Batch Number | Integer | Mandatory. This is critical for TASS and must be a unique identifier for the settlement batch to which the payment belongs. |
5 | Receipt Reference | Char(12) | Optional. Vendor generated receipt reference number for audit trail. |
6 | Received From | Char(30) | Mandatory. The full name of the payer. |
7 | Address Line 1 | Char(30) | Optional. Address Line 1 of the payer. |
8 | Address Line 2 | Char(30) | Optional. Address Line 2 of the payer. |
9 | Address Line 3 | Char(30) | Optional. Address Line3 of the payer. |
10 | Town/Suburb | Char(30) | Optional. Town / Suburb of the payer. |
11 | State | Char(3) | Optional. State of the payer. |
12 | Postcode | Char(10) | Optional. Postcode of the payer. |
13 | Country | Char(20) | Optional. Country of the payer. |
14 | Comment Text | Char(30) | Mandatory. Information about the Payment. (Added to Comment Line 1 when receipt is generated.) |
15 | GL Account Code | Char(18) | Mandatory. It must be a valid account code that is 'open'. |
16 | Nett Distribution Amount | Money(10,2) | Mandatory. It must be greater than or equal to $0.00. The tax exclusive amount distributed to the GL Account. |
17 | Tax Amount | Money(10,2) | Mandatory. It must be greater than or equal to $0.00. The tax amount of this payment. |
18 | Tax Code | Char(3) | Mandatory. It must be a valid tax code. |
19 | Enrolment Receipt Type | Char(1) | Mandatory. It must be a valid type flag. The valid values are G, A or D. |
20 | Parent Code | Char(8) | Mandatory. It must be a valid Enrolled Parent Code. |
21 | Student Code | Char(8) | Mandatory. It must be a valid Enrolled Student Code and does not have a cancelled status. The Parent Code defined on the Enrolled Student Record must match the Parent Code entered in field 20. |
|
Important! Records must contain 21 fields and optional fields should be represented by null as a place holder. | |||