Check out the monthly recent updates here!
The term review is: "an evaluation of metrics and performance over a previous period". Today, it means a department will review transactions that meet certain business rules, as well as some additional transactions selected via random sampling.
Virginia Tech is no longer requiring traditional reconciliations to be performed and is now taking a risk-based approach by implementing reviews. A department/ organization can review all transactions if desired, however, the required review covers a large majority of the dollars. The Controller's Office is only requiring the flagged transactions to be reviewed.
FINTRACS takes a risk-based approach, utilizing business rules to determine which specific transactions are required for review each month and eliminates required review of all transactions. However, the tool also allows for review of all transactions, if desired by a department.
FINTRACS will populate all transactions for the month. Transactions flagged by the business rules will be marked for review daily, and a random sample of un-flagged transactions will be marked at the end of each month for review.
Review can be performed throughout the month or within 30 business days after the final day of the month.
Transactions marked for further review are carried forward to the following month for future resolution.
For example, September reviews must be completed by October 31st. Corrections must be completed within 60 days from the posting of the original transaction.
When an outstanding transaction is flagged for review/correction from the previous month, the transaction must be reviewed again to verify resolution. Once resolved, the transaction will no longer roll forward.
What training is available?
To learn more about FINTRACS explore the training options below.
Find answers to FINTRACS common inquiries
You may also need MicroStrategy Reports for additional financial reviews such as communicating Research fund balances to Principal Investigators. Reports could include the Fund by Account, Transaction Detail, or the Snapshot by Organization. Help directions by report and topic can be found using the links in the resource section below:
MicroStrategy Frequently Asked Questions can be found on the Controller's Website
What training is available?
To learn more about MicroStrategy complete the following training:
The rule codes below are commonly seen in the Transaction Detail report.
CNEI - Cancel Check - Invoice w encumbrance
CNNC - Cancel check - C/M w/o encumbrance
CNNI - Cancel Check - Invoice w/o encumbrance
CR2 - Department Deposits - HigherOne
CR7 - Cash Receipts-Banner AR Application
CRR - Cash Receipts-Banner AR Application
ICEI - Cancel Invoice with Encumbrance
INEI - Invoice with Encumbrance
INNC - Credit Memo without Encumbrance
INNI - Invoice without Encumbrance
JE2 - Journal Voucher-Banner AR Interface
JE4 - Journal Voucher-ISR
JE5 - Journal Voucher - AP Distribution
JE6 - Journal Voucher Encumbrance Liquid
JE8 - Cost Overrun - Journal Voucher
JE9 - Journal Voucher
JEE - Journal Voucher - Clear Error Fund
JEI - JV Encumbrance Liquid-Dept
JEO - Journal Voucher-ISR Override
JER - Journal Voucher-Dept ISR
JEX - Journal Voucher-AMEX Charges
CORD - Establish Change Order
E010 - Post Original Encumbrance
E032 - Encumbrance Liquidation
E090 - Year End Encumbrance Roll
E15 - Encumbr Liq. allow chgs (FZAISRP)
E17 - Encumbr Liq allow chgs (Manual Ent)
EC15 - Central Off.-Encumb. Adj. (FGAJVCD)
EC16 - Post Batch encumbrance - Allow Chg
JEG - Journal Voucher-No NSF Checking
PCLQ - Cancel PO - Reinstate Request
PCRD - Cancel Purchase Order
POBC - Purchase Order Batch Close
POCL - Purchase Order Close (FPAEOCD)
POLQ - Purchase Order-Request Liquidation
POPN - Purchase Order Open (FPAEOCD)
PORD - Establish Purchase Order
RCQP - Cancel Requisition
REQP - Requisition - Reservation
RQCL - Requisition close (FPAEOCD)
BBO - One-time Budget Transfer (User)
BCO - One-time Budget Transfer (Central)
Questions to Ask yourself:
Do departmental procedures ensure a monthly reviews are completed, are comprehensive, and timely?
Is the supporting documentation comprehensive and adequate?
Is the review effective and timely?
Are records maintained in accordance with guidelines?
Are record maintenance requirements clearly established and the responsibility communicated?