PAC - Upload Charges and Credits
This program provides a convenient method to upload charge and credit transactions from a correctly formatted comma-delimited file. This is an alternative to entering charge and credit transactions individually through Finance > Parent Accounts > Charges and Credits > Charges and Credits.
The comma-delimited upload file can be easily created from a Microsoft Excel® spreadsheet.
Important!
For this charge and credit upload to be successful, the spreadsheet must conform to the following specifications:
The spreadsheet must be saved in comma-delimited (CSV) format and contain the following columns:
Column | Field Name | Field Type/Size | Field Description |
|---|---|---|---|
A | Trans. Type | char(1) | '1' = Charge '3' = Credit |
B | Parent Code | char(8) | Must be a valid TASS Parent Code. |
C | Student Code | char(8) | This can be left blank if the charge or credit is 'parent' based. If the charge or credit is 'student' based then this must be a valid student code. |
D | Trans. Date | date | Transaction date in the format dd/mm/yyyy |
E | Fee Code | char(4) | Must be a valid TASS Fee Code. Important! All Fee Codes in the upload file must be active. Use Finance > Parents Accounts (PAC) > PAC - Setup Information > Parent Accounts Setup > Fees Tab to change the Active status of a Fee Code. |
F | Tax Code | char (3) | Transaction tax code must be a valid TASS Tax Code. |
G | Tax Percentage | decimal (5,2) | Transaction tax percentage must be a value greater than or equal to '0'. |
H | GL Code | char(18) | Must be a valid TASS GL Account Code. |
I | Trans. Amt. | money | Transaction amount, the value must be greater than '0'. |
J | Tax Amt. | money | Tax amount must be at a value of greater than or equal to '0'. |
K | Total Amt. | money | Total amount must be a value greater than '0'. Important! Column K must equal columns I + J. |
L | Comment | char(30) | Transaction Comment. Up to 30 chars of free-form text (with no embedded comma's). |
- The sheet must NOT have header or footer rows.
- All formats must be removed from this sheet (Within Microsoft Excel® go Edit > Clear > Formats).
- Money amounts must be formatted to display two digits after the decimal point.
- Remove all other formats from money amounts including '$' and ',' separators for thousands.
- All fields cannot be at a 'NULL' value.
When the CSV file has been saved, select the 'Browse' button to locate and attach the file.
Select the 'GO' button to proceed with uploading the charges and credits file.