DETAIL LISTING OF ACCOUNT ACTIVITY (XDET)

Required fields:

  • Fiscal Year – The Fiscal year is April 1, 2XX1 to March 31, 2XX2. When the university is in-between two reporting periods the fiscal year will need to be changed to the most recent fiscal year.
  • GL UNIT to Report on – The unit is the middle 6 digits of an account# (ie. 632000 of account 11-5-632000-xxxxx)


Comments:

  • Starting/ending transaction date can be changed to limit the results to a specific month(s). This is helpful when reviewing transactions for a single month.


Completing the screen:

  • Click ‘SAVE ALL’

Required Fields:

  • Output Device – leave as ‘H’ which will hold the report to screen. Printing options are available once the report is displayed.


Completing the screen:

  • Click ‘SAVE ALL’

Require Fields:

  • There are no required fields


Completing the screen:

  • Click ‘SAVE ALL’

 

Comments:

  • Check ‘Close automatically when complete’ to automatically close this dialog box and display the report.


Completing the screen:

  • Click ‘Finish’ 

 

  1. Date report was run.
  2. Date range of report. Only transactions within the date range are shown.
  3. Transactions will be included for this fiscal period.
  4. G/L account# and description.
  5. Transaction date.
  6. Transaction source code (see below).
  7. Transaction reference number.
  8. Transaction description.
  9. Budget entries.
  10. Actual amount of postings (ie. invoices, payroll)
  11. Amount of budget available to spend. Negative expenses indicate the account is overspent.
  12. If a PO (purchase order) is outstanding an encumbrance will show indicating the funds have been committed.
  13. Amount of budget available to spend after considering encumbrances.


Sub-totals (each of the sub-totals provides different amounts if the report is run on a period other then April 1 to March 31):

  • Current Period Totals – September 1, 1998 to November 30, 1998
  • To Date Totals – April 1, 1998 to November 30, 1998
  • Future Totals – December 1, 1998 to March 31, 1999
  • Fiscal Totals – April 1, 1998 to March 31, 1999


Transaction Source Codes (Sc):

  • BC/BU = budget entry
  • JE = journal entry
  • PJ = voucher (invoice payment)
  • CR = cash receipt (cash/cheque deposit)
  • IV = invoice
  • PR = payroll
  • EP = encumbrance


Transaction reference numbers (Ref.No):

  • PRI = printshop charges
  • VIS = visa charges
  • XRX = xerox charges
  • COP = copier lease
  • TEL = telephone charges
  • CEL = mobility charges
  • FOO = catering charges
  • FOLL = bookstore charges
  • J = journal entry
  • C = cash receipt (deposits)
  • I = invoice (issued by Acadia)