- Overview
- Frequently Asked Questions
- Accessing the Transaction Monitoring Dashboard
- Navigating the Segment Transaction Monitoring Screen
- Updating the State of Transactions
- Reviewing the List of Monitored Object Codes
- Updating the List of Approved Object Codes and Monitored Object Codes
- Reviewing Transactions Outside of the Award Period
- Transaction Monitoring Rules
Overview
Transaction monitoring occurs throughout the post-award lifecycle, as part of the financial management of an award. The department has the primary responsibility for ensuring all expenditures are allowable, allocable, reasonable, and in accordance with the terms of each award. The processes and internal controls to monitor transactions differ across each department. As a result, a standard University-wide approach to monitoring transactions is performed by the Office for Sponsored Programs, Research Finance (OSP RF) group based on a standard list of Cost Accounting Standard (CAS) object codes and/or the financial terms of each award. Transactions against these object codes can be monitored in GMAS for review by departments. OSP RF will review these transactions and include any transaction as part of the Compliance Checklist that are still “pending review” by the department. Departments must provide justification for allowability or designate transactions for correction from the award, if unallowable. Checklists are routed by OSP RF to departments based the following financial milestones of an award*:
- At award end
- Upon submission of a Final Invoice or Final Financial Report
- Upon completion of an Interim or Final Review
- In other instances, as required (i.e. budgetary restrictions, sponsor templates, etc.)
*Note: Transactions should be monitored throughout the award and OSP RF recommends that departments monitor and approve/remove transactions on a monthly basis, or at least quarterly to avoid cost transfer implications or record retention issues.
Key features
Transaction Monitoring Dashboard
- Provides a summary by project of any accounts with transactions monitored for review
- Each project is linked to the Segment Transaction Monitoring screen for users to access the detailed list of monitored transactions
Segment Transaction Monitoring
- Allows users to customize the list of monitored object codes, based on award terms
- Provides a detailed list of monitored transactions for review
- Approved transactions and transactions designated for removal are recorded with a username and date/time stamp
Who can access the Transaction Monitoring Dashboard
Anyone with access to the project can see the projects in the transaction monitoring dashboard and access the transaction monitoring screen. Editing is limited to Department Administrators, Interfaculty Involvement Department Administrators, and OSP RF staff.
All roles on the project administrative team:
- See all transactions (belonging to any account) on the project that are listed in the segment transaction monitoring screen
Department Administrators:
- See all transactions (belonging to any account) on the project that are listed in the segment Transaction Monitoring screen
- Update the state of all transactions (belonging to any account on the project) in the segment Transaction Monitoring screen
Interfaculty Involvement Department Administrator (this role is added in the segment administrative team by department administrators):
- See all transactions (belonging to any account) on the project that are listed in the segment transaction monitoring screen
- Update the state of transactions in the segment transaction monitoring screen where the org of the account transacted to matches an org where the individual also plays the Department Administrator role on a standing team
Roles and responsibilities
Department Administrators/Interfaculty Involvement Department Administrators
- Set and update the list of monitored object codes based on the financial terms of the award
- Assume primary responsibility for monitoring any transactions that appear on the Transaction Monitoring Dashboard
- Assume primary responsibility for reviewing transactions--at the segment level--by providing justification for allowability or designating transactions for correction, prior to completing the OSP RF Compliance Checklist
- Upload any supporting documentation to validate allowability
OSP RF Staff
- Monitor the Transaction Monitoring Dashboard in preparation for client meetings and alert departments prior to financial milestones of an award
- At financial milestones, review the Segment Transaction Monitoring page to ensure approved transactions have sufficient justification for allowability, that unallowable transactions have been designated for correction/removal, and that no transactions are “pending review”
- Notify departments of any transactions that are “pending review” or that require additional justification, by referencing them on the OSP RF Compliance Checklist
- Have the ability to clear monitored transactions and update object codes for flagging, but this is the primary responsibility of the department since the posting of expenditures to the GL occurs locally by each department
Prerequisites
It is expected that all users of the Transaction Monitoring Dashboard and Segment Transaction Monitoring screen are familiar with general GMAS functionality and navigation, and have an understanding of Harvard’s Sponsored Expenditure Guidelines and the individual terms of each award.
What is covered in this document
The purpose of this document is to outline the general workflow and navigation of the Transaction Monitoring Dashboard and the Segment Transaction Monitoring screen. It highlights the purpose of the dashboard and screen, and what data and functionality is available.
What is NOT covered in this document
The processes and decision-making required to make a determination of whether or not expenditures are allowable, allocable, reasonable, and in accordance with the terms of each award.
Frequently Asked Questions
Click on any of the questions below, which will link to the areas of the business process that provide additional details.
- How does GMAS determine which transactions should be monitored?
- How can the list of monitored object codes be customized?
- What if a transaction was updated in error? Can transaction statuses be changed?
- Who is responsible for reviewing and clearing “pending transactions” in GMAS?
- Is there a way to view all transactions, across all statuses (pending review, pending correction, approved)?
- If an award is receiving an extension, can the monitoring of transactions be delayed so that transactions do not continue to be flagged as “pending review”?
Accessing the Transaction Monitoring Dashboard
1. On the GMAS Homepage, click the Transaction Monitoring Dashboard tab on the right-hand side of the screen.
2. The Transaction Monitoring Dashboard is displayed.
3. The Transaction Monitoring Dashboard is populated with data based on a user’s GMAS security for each project and account(s):
- Each row represents an account string within a project that has transactions that have been flagged for monitoring
- A count of monitored transactions is included to help users prioritize the review of transactions
- The dashboard can be sorted and filtered to assist with prioritization
-
To view the financial detail of individual transactions, click the “Project no.” to navigate to the Segment Transaction Monitoring screen
- The Segment Transaction Monitoring screen can also be accessed by using the “Transaction Monitoring” box on the left side of a Segment homepage
Navigating the Segment Transaction Monitoring Screen
The following is a general overview of the navigation and general information available on the Transaction Monitoring Screen (see screenshot below). The screen is comprised of multiple “panels”. Additional information about each “panel” is detailed in subsequent sections.
Note: It is the primary responsibility of department users to review and update any transactions that are “pending review”.
When reviewing the transaction panels, transactions can be filtered using the Account(s) dropdown and/or entering a period using the “Trx date from” and “to” prompts. These filters will be applied across all four “transaction” panels:
- Transactions pending review
- Transactions pending correction
- Approved transactions
- Transactions with object codes that net to 0
Transactions will display in each of the panels based on the account(s) and periods that are entered. Otherwise, the default is for all transactions to display when no prompts are entered.
1. The “Transactions pending review” panel displays all transactions that have been flagged for review based on the monitoring rules set for the award. Transactions are monitored based on the following rules.
- Transactions posted against a “Monitored Object Code”
- Animal Costs with an Expired IACUC Approval
- Human Subject Costs with an Expired IRB Approval
- Equipment Costs Posted within 90 Days of account end date
- Transactions coded to incorrect subcontract object codes
- Sale transactions to Cost of Goods Sold or Inter/Intratub Sales object codes
-
Transactions outside of the award period
- Pre-award expenses without approval in GMAS
- Expenses after the account end date
Note: If an award is pending an extension and there are monitored “transactions outside of the award period," reference the “Reviewing Transactions Outside of the Award Period” section for instructions on how to “approve” the current transactions and delay future transactions from being monitored for 30 days using the “Manage transactions outside of the period” panel.
2. The “Transactions pending correction” panel lists any monitored transactions that have been designated for correction/removal from the GL.
Note: Adjustments still need to be processed in the GL. Marking transactions as pending correction is just an indicator that the transaction will or has been corrected in the GL.
3. The “Approved transactions” panel lists any transactions meeting any of the monitoring rules that are acceptable on this award.
4. The “Transactions with object codes that net to 0” panel lists transactions where there are offsetting debit/credits to the object code and account that net to zero. If transactions were designated as “pending correction”, "approved", or "pending review", and entries were posted in the GL to offset the original expenditures, both the original transaction(s) and the offsetting transaction(s) will appear in the “Transactions with object codes that net to zero” panel. The original transaction will automatically be moved down to the “Transactions with object codes that net to zero”, as long as the object code offsets to zero.
This panel only displays if there are transactions that fall into this category.
Note: This panel helps to facilitate the reconciliation of transactions pending correction. There are limitations to the nets to 0 rule since adjustments cannot be systematically associated with their original transactions in the GL. In those cases, transactions will remain in the "Transactions pending correction" panel.
1. The “Monitored object codes” panel identifies the list of object codes that are being monitored for review anytime a transaction is posted against that object code in the GL. The list of object codes can be customized by account by approving (excluding from being monitored) object codes, removing, or by adding object codes to the list.
2. The "Manage costs outside of the period" panel lists all accounts that currently have an active account with an end date in the past. This panel only displays if there are accounts that fall into this category.
The Transaction monitoring screen also includes a document repository for uploading supporting documentation to validate the allowability of monitored transactions and a download option to export the full list of all transactions that are included in the transaction panels.
Updating the State of Transactions
Transactions are updated in GMAS daily from the prior business day. When transactions match an object code or rule that is being monitored, the transaction will appear in the "Transactions pending review" panel. The expanded view of the "Transactions pending review" panel will show the full list of transactions on the project that require review.
- To facilitate the review of transactions, each column can be filtered or sorted.
- Additional transaction line descriptions can be accessed or hidden using the “+/-” button to the far right of each transaction.
- To record the approval of transactions or to mark transactions for correction, click the "Update" button.
Note: Any filters applied to the panel, or to the screen will also be applied to the window that opens when selecting the "Update" button. If reviewing transactions on a project where you play the Interfaculty Involvement Department Administrator role, only transactions under your authorized orgs will be listed in the window (even though all transactions are visible on the view screen).
a. When reviewing transactions, only one action can be taken at a time, by selecting the “Update selected transactions to” dropdown to designate transactions as either:
- Transactions pending correction –expenses to be adjusted in the GL
- Approved transactions – expenses deemed allowable
b. Transactions can then be selected individually or in bulk by object code/rule using the check boxes. (Check boxes will be disabled for selecting until step a is complete.)
c. Once a transaction(s) is selected, a comment can be entered to indicate why the transaction is pending correction, or what action will be taken on the transaction to correct it.
Note: Individual transactions can be selected, requiring a comment for each. The entire object code or rule can also be selected, requiring one comment that can be applied across that object code or rule; allowing users to update “in bulk”.
d. At the bottom of the window, click “Update selected transactions” to save the changes.
Once done, the selected transactions will move to the "Transactions pending correction" panel with additional information about who updated the transaction, the date the transaction was updated, and the comment provided when the transaction was updated.
Note: It is the responsibility of the individual designating transactions for correction to ensure that the appropriate and corresponding entries are made in the GL. Updates to the GMAS Transaction Monitoring screen do not feed to the GL and all adjustments in the GL still need to be processed for any transactions marked as “pending correction”.
All of the steps above can be repeated for updating transactions in the "Approved transactions" and "Transactions pending correction" panels. Options of which panels you can move the transactions to will be based on which panel you are updating. Comments are required when moving transactions to "Approved" and a dropdown with pre-set comments is available. Comments are not available if moving transactions to "Pending review."
Note: Anytime a transaction is updated to appear in a new panel, previous comments and approver will be deleted.
IMPORTANT: If any transaction statuses are being updated and impact a previously submitted financial deliverable, please alert the OSP Financial Analyst, as this may require a revision to the original financial deliverable.
Reviewing the List of Monitored Object Codes
The list of monitored object codes will vary by award and can be reviewed using the following steps. For Federal awards, the monitored object codes are pre-selected using a standard set of Cost Accounting Standard (CAS) object codes. Please see the “Updating the List of Approved Object Codes and Monitored Object Codes” section for instructions to modify the list of monitored object codes.
Note: in this example, object code 6570 is being monitored for all subactivities except subactivity 3601 because it was set as approved for that subactivity.
1. The “Monitored object codes” panel provides a summary of any object codes that have been designated as:
- Approved – any transactions posted to these object codes will not be listed as pending review will automatically be placed in the “Approved transactions” panel and will not require any further action to be taken
- Monitored – any transactions posted to these object codes will automatically be placed in the "Transactions pending review" panel and will require action to be taken
To view and edit the full list of monitored object codes, the panel must be expanded (open).
2. The first section in the panel (which only displays if any object codes meet the criteria) is "Approved object codes". This section will display any object codes that have been approved for a specific account(s). Any transactions that post against an approved object code/account will not be listed as pending review and the transactions will automatically appear in the “Approved transactions” panel. The "Approved object codes" section includes detail for:
- Accounts – list of any or all accounts that the object code is approved for
- Approved by – the person that designated the object code for approval
- Date – the date the approval was designated
- Comments – details for why the object code was approved
3. The list of "Monitored object codes" will display any object codes designated for monitoring. Any transactions against a monitored object code/account will appear in the “Pending review” panel. This section includes detail for:
- Object code – name associated with the GL
- Accounts – list of accounts that an object code is being monitored for
- Reason – explanation for why the object is being monitored
Updating the List of Approved Object Codes and Monitored Object Codes
Based on the terms of each award, the list of monitored object codes can be customized by adding or approving (excluding from being flagged as pending review) object codes.
- If any object codes have been designated as “Approved object codes,” any future transactions to these object codes will not be listed as pending review and will automatically appear in the “Approved transactions” panel.
- Clicking the “Remove” button will open a new window allowing the object code to be taken off of the approved list for the accounts selected.
a. Select the account(s) that should no longer be approving transactions under the object code.
b. Click "Remove accounts" to save the changes.
Note: Once the account is removed from the approved list for that object code, all future transactions will be monitored and will automatically appear in the "Transactions pending review" panel.
1. If any object codes have been designated on the “Monitored object codes” list, any future transactions posted to these object codes will be monitored for review and will appear in the “Transactions pending review” panel. NOTE: all Federal awards will have a pre-set list of monitored object codes.
2. If there are object codes and accounts that should not be monitored based on the account setup and financial terms of the award, they can be designated as approved using the “Approve” button.
a. Select the account(s) that should no longer be moniored for that object code.
b. Select an appropriate comment to describe why the object code is allowed for the account(s) selected or select the "Other" option in the dropdown to enter a customized comment. The comment field is required when approving object codes on accounts to justify/validate the allowability.
c. Click "Approve" to save the changes.
Note: Once the account is added to the approved list for that object code, all future transactions will not be monitored and will automatically appear in the "Approved transactions" panel.
Adding Object Codes to be Monitored
An object code that is not allowed for an award and is not currently listed as a monitored object code can be added for future monitoring.
1. Selecting the "+ Add object code" button at the bottom of the expanded "Monitored object codes" panel will open a new window.
a. Look-up the object code to be monitored. Object codes that are already being monitored will not appear in the search results. Object codes can be searched by number or descriptor.
b. Select the account(s) that should be monitoring for that object code going forward.
c. Add a comment to describe why the object code is being monitored for the account(s) selected. The comment field is required when adding object codes to be monitored on account.
d. Click "Add object code" to save the changes.
Note: Once the account is added to the monitored list for that object code, all future transactions will be monitored and will automatically appear in the "Transactions pending review" panel.
Reviewing Transactions Outside of the Award Period
Appropriate expenditures to a sponsored award should be incurred and posted to the GL within the award period obligated by the sponsor. If expenses are posted before the start date or after the end date, these transactions will appear in the “Transactions pending review” panel and can either be: “Approved” or marked for “Pending correction” (see the “Updating the State of Transactions” section of this document for instructions.
However, there are cases where transactions post after the end of the award (account) period, but the end date is in the process of being extended by the sponsor. The "Managing costs outside of the period" panel assists with acknowledging that expenses to this account were incurred after the account end date, but there is a pending increment of funding that is not set up in GMAS yet.
1. Navigate to the “Manage costs outside of the period” panel and click the “+” button to view the list of accounts that have ended, and their current end dates.
2. Selecting the "Update" button will open a new window.
a. Accounts that are expected to receive an extension can be selected using the “Approve account for 30 days (through “date”)” checkbox.
b. Comments are required to be entered and should indicate why the late charges will be approved for the account over the next 30 days.
c. For accounts that have been previously approved for late transactions, in place of a check box will be a trashcan. Selecting the trashcan removes the approval of late charges for that account.
d. Click “Save” to commit the changes.
Note: In addition to delaying future transactions outside of the award period from being monitored for 30 days, saving these changes will also move all monitored late charges to the “Approved transactions” panel.
IMPORTANT: If the extension is not processed within the 30 day window, any new transactions outside of the award period will appear in the “Transactions pending review” panel. Additionally, any “Approved transactions” for costs outside the award period will need to be reviewed again for allowability and OSP may move the “approved” transactions into the “Transactions pending review” panel.
Transaction Monitoring Rules
These tables provide a summary of the rules and logic being used by GMAS to populate the transactions on the Transaction Monitoring screen.
Notes:
a. Transactions posted to overhead or fringe object codes will never be flagged for monitoring
b. It is the primary responsibility of departments to customize the monitored object codes based on the financial terms of each award.
c. It is recommended that the monitored object codes be set at award (upon receipt of first action memo) to assist with the financial management throughout the life of the award.
d. GMAS Transaction Monitoring serves as a supplement to, and not a replacement for, the regular and ongoing account reconciliations by departments.
e. Upon receipt of an "approved" Compliance Checklist from a department, all monitored transactions must either be:
1. Approved, or
2. Marked for Correction
Pre-set Monitored Object Codes (customizable by award) | ||||
---|---|---|---|---|
Federal | Stipends: 6440, 6450, 6452, 6455 | Supplies: 6640, 6660, 6670, 6750 | Telecomm: 8510, 8511, 8512, 8513, 8514m 8515, 8516 | Postage/Shipping: 8700, 8701, 8702, 8705, 8706, 8707, 8708 |
Food/Beverage: 6570 | Catering: 8060 | Ineligible for Feds: 8450-8459 | Dues/Memberships: 8680 | |
Books/Subscriptions: 6630 | Parking: 8267 | Printing: 8540, 8550 | ||
Non-Federal | No object codes are currently pre-set for Non-Feds |
Pre-set Transaction Monitoring Rules (not customizable) | |
Sales Transactions | Object codes with the following keywords in their description: INTERTUB, INTRATUB, Sales, Cost of Goods Sold |
Animal Object Codes (with open GMAS approvals) | Animal-related object codes 6520-6522, 6530-6532, and 8030-8032 when there is not an "Approved" or "Exempt" IACUC approval in GMAS |
Human subjects Object Codes (with open GMAS approvals) | Human Subject-related object codes 8266 and 8271-8273 when there is not an "Approved" IRB approval in GMAS |
Equipment Object Codes (within 90 days of account end date) | Equipment-related object codes 6500, 6740, 6750, 6760, 6780, 6800-6816, 6870-6875, 8187 for transactions that post within 90 days of the account end date |
Subcontract Object Codes (Not on Main or Part-of and $25K on 8190) |
SubK object codes 8190, 8191, 8192, 8193 with transactions to Main and Part-of accounts SubK transactions >$25K on object code 8190 SubK transactions to 8191 and 8192 when 8190 has not met $25K |
Pre-Award Expenses and Expenses After End Date |
Expenses posted before the account start date without a pre-award IDC rate with an effective date prior to the expense date Expenses posted after the account end date |
Unallowable Object Codes on Sponsored Awards | Any expenses posted with object codes 8921-8930 |
Questionable Participant Support Cost Charges | Expenses posted to participant support cost type accounts with object codes in the "Salary" category, object code 8060, and any objects codes that have the following super objects: S680, S869, and S646 |