GL - Journal Upload
This program provides the facility to upload a General Journal batch directly into the TASS.web database, using a text file populated with the line detail of each journal to be uploaded. It includes various validations at the field level, overall batch validation and exception reporting.
The file may be prepared in Microsoft Excel® spreadsheet as an alternative to entering journals manually through Finance > General Ledger > Account & Journal Information > Journals.
Important!
For this journal upload to be successful, the spreadsheet must conform to the following specifications:
This journal upload facility is available for General Journals only.
The spreadsheet must be saved in comma-delimited (
.csv
) format and contain the following columns:Column Description A This column is to contain the line/sequence number. B This column must contain a valid GL account code. C This column must contain a detailed description to be attached to this line item. D This column can optionally contain an analysis description to be attached to this line item. E This column must contain the amount to be debited against the nominated GL code. F This column must contain the amount to be credited against the nominated GL code. G This column must contain the source of the journal line item. This is a maximum of 10 characters. If there is no source information you could add something like 'Upload'. - For each journal to be uploaded, the sum of the debit amounts must equal the sum of the credit amounts.
- At the line item level, if the debit amount is greater than 0, the credit amount must be 0 and vice-versa.
- All formats must be removed from this sheet (Within Microsoft Excel® go Edit > Clear > Formats).
Upon entry to this program, the 'Upload Journal' screen will be displayed.
When satisfied with your entry, click on the 'Save' button to commit your changes to the TASS.web database.
Fields that require further explanation | |
---|---|
Year/Period | The year and period into which this journal is to occur. |
Control Amount | The control amount is to hold the journal total (total debits/credits). |
Comment 1 / 2 | Any comment you would like attached to this journal. |
File Name | The |