Skip to main content
Skip table of contents

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.

  1. The spreadsheet must be saved in comma-delimited (.csv) format and contain the following columns:

    ColumnDescription
    AThis column is to contain the line/sequence number.
    BThis column must contain a valid GL account code.
    CThis column must contain a detailed description to be attached to this line item.
    DThis column can optionally contain an analysis description to be attached to this line item.
    EThis column must contain the amount to be debited against the nominated GL code.
    FThis column must contain the amount to be credited against the nominated GL code.
    GThis 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'.
  2. For each journal to be uploaded, the sum of the debit amounts must equal the sum of the credit amounts.
  3. At the line item level, if the debit amount is greater than 0, the credit amount must be 0 and vice-versa.
  4. 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 .csv file created within Microsoft Excel® and saved to your local workstation or elsewhere on your network.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.