Atrieve Finance

GST/HST File Additions, Changes, Deletions, Inquiry

The GST/HST Additions, Changes, Deletions, Inquiry programs are provided as an emergency method of correcting errors. This program should only be used when no other facility contained in atrieveFinance can affect the necessary corrections. Use of this program only modifies records in the GST/HST history file. No accounting entries are made as a result of any changes. The programs maintain status codes on the file to identify the type of record, expense or revenue and the action that the programs have taken against the file so that if you add, change or delete a record, the status is modified so that you can identify what programs were used in the creation and maintenance of the file. These status codes are identified for your use and for ours when it is necessary to track errors.

System Name

  • Enter the identifying package name whose GST/HST records you want to access. To enter transactions related to the Budgetary Accounting System, enter atrieveFinance. Valid system names are ATS, atrieveFinance, BPS, CRS, FAS, MAR, WOS, OPS, POM and WIS.

Vendor / Customer No

  • Enter the vendor, customer or CRS number (used to identify the record for access).

The vendor number for GST/HST records created by the journal entry program is JE00000000.

Invoice No:

  • Enter the invoice number used for entry of the document. This is part of the key for accessing the proper record.

Batch No:

  • This number is supplied in Change, Inquiry or Delete mode but must be entered in Add mode.

GL Account :

  • Enter a valid GL account number which is to be identified as the target for the charges, which are recorded in this record. This number is used for the final point of access to records which exist in the file and is used to be able to resolve and select the proper record when multiple distributions have been entered on a single vendor number/invoice number combination from either the invoice program or the journal entry program.

Percent Exempt

  • This field is supplied from the general ledger account information on existing records. During add mode, it is supplied from the general ledger account entered. It may be overridden during the entry process.

Tax Code

  • The tax table code from the GL account number is displayed. In the add mode, this may be overridden. In change mode, it can be altered.

GST/HST Tax Factor

  • The tax factor entered from the GST/HST database will be displayed based on the GL account number. This can be altered in the Add and Change mode.

Rebate Percentage

  • The rebate percentage will be displayed from the selected GL code. In add and change mode you can alter this value during the entry process.

GL Charge AMT

  • This is the amount of GST/HST charged to the expense general ledger code listed in Field 5 above. This amount is added to the expense distribution to make up the amount recorded in the journal entry file.

Rebate AMT

  • This is the amount of the rebate to be claimed from Revenue Canada as a result of the rebate percentage applicable to the particular GL.

Refund AMT

  • This is the amount that is an input tax credit and will only occur in situations where the account is partially taxable, and an input tax credit is appropriate.

Invoice GST/HST AMT

  • This is the total amount of tax on a given invoice. Note: Since there may be multiple GL's attached to a specific invoice, each GST/HST record will show the GST/HST total for the invoice in this field. (Used for reference only.)

GL Account GST/HST AMT

  • This is the total amount of GST/HST applicable to this account based on the expense amount charged to the particular GL. This is the amount before rebate or ITC deduction (i.e. Account GST/HST = GL charge + rebate + refund).

Expense/Revenue Category

Specify whether expense or revenue

Status

  • You cannot enter information for this field. It will present the status indicating whether it is revenue or expense record and whether it has been changed or added using this maintenance program.

Accumulation Run Number

  • This number cannot be entered during file maintenance but is added by the GST/HST payment recovery run program. When the field contains a number, it indicates the register number that was used for the payment recovery run to file the report with Revenue Canada. Refer to the GST/HST Payment Recovery Run documentation for additional information.