Financial Transactions Feed Policy

Overview

The University’s accounting ledger or ‘set of books’ against which financial transactions are posted, is contained within the Banner Financial Information System (FIS).

A feed is defined as transactions that are uploaded as opposed to originated online by a user.

Any unit or department submitting a feed (whether automatically generated or coming from a periphery business process/system) into the systems listed below is bound by this Policy as the resulting postings in FIS are not subject to the same scrutiny as transactions originating from on-line processing:


- Feed submitted to Student and/or Finance Accounts Receivable
- Feed submitted to Accounts Payable
- Feed submitted directly to the FIS Accounting Ledger

This Policy is not applicable to:

  • Feeds generated by credit/debit card merchants that fully integrate with the McGill E-Payment Gateway. Refer to Links to Related Documentation below for details.
  • Feeds to the budget module (i.e. for 1A and 1B fund types).

Refer to the Procedures for details regarding the implementation and interpretation of the Policy.

Policy

P1. to P3.

P1.
It is the responsibility of these system and feed ‘owners’ to ensure the appropriate controls are in place and to ensure their transactions are accurate, legitimate, valid, timely and properly documented. This, in turn, ensures the integrity and accuracy of the University’s accounting ledger.
P2.
Within the context of this Policy, the types of feeds include but are not limited to:
  • Accounts Receivable (Student and Finance): Transactions originating in periphery business processes/systems (e.g. student dial access service and lab charges, student residence long distance and telephone equipment charges, telecom charges, computer store charges, etc.) and ultimately posted to the University’s accounting ledger in summary.
  • Accounts Payable: Transactions originating in periphery business processes/systems and fed to the Accounts Payable sub ledger (e.g. invoice documents) for the remittance of payments.
  • Accounting Ledger: Transactions originating in periphery business processes/systems and fed to the accounting ledger (e.g. cash/credit card receipts, journals and interdepartmental charges (IDCs)).
P3.
In order to process a financial feed to FIS, Financial Services must approve the use of the feed mechanism via a Memorandum of Agreement to be signed by both the Originating Unit Head and the Controller.

Procedures

PR1. Administrative Process

a)
The Originating Unit must submit a Business Case to Financial Services explaining the purpose of the feed. Please use the “Access to Banfeed” form.
b)
Units requesting feeds related to sales of goods and services to external entities must ensure they abide by the Merchant (PCI) Policy and Procedures and must complete the Merchant Questionnaire.
c)
Financial Services will review the Business Case and if appropriate, approve it before the subsequent steps take place:
  • Financial Services will establish a system ID, network access to Banfeed directory and document number range.
  • The Requesting Unit will provide a test file.
  • Financial Services and the Requesting Unit will test the file and provide dual sign off.
  • The Requesting Unit will sign the Memorandum of Agreement.
  • When applicable, Financial Services will publish the document number range, feed purpose and contact information on their website so the transactions are identifiable to the community.

PR2. Roles and Responsibilities

d) Originating Units
  • Are responsible for the transactions generated from periphery business processes/systems and consequently must ensure that adequate controls are in place for the transactions generated in the feed.
  • Ensure all FOAPAL element combinations are supported.
  • Ensure transaction documentation is provided for every document/item within the feed file.
  • Follow up on any rejected records or feed files to ensure they are rectified/adjusted on a timely basis.
  • Cannot modify the purpose or nature of an existing feed without approval from their unit head and Financial Services. A new business case may be required from the unit who owns the feed if the modification is significant (i.e. change in volume of transactions, change in monetary value, etc.).
  • Process feeds on a timely basis (i.e. monthly at a minimum).
  • Ensure that all transactions meet University policies and guidelines.
  • Notify Financial Services if any changes are made to the processes or applications from which their feed transactions are generated.
  • Must review and sign the Memorandum of Agreement.
  • Respond to Financial Services’ annual confirmation that the original business case is unchanged (including the employees authorized to submit the feed files).
  • Remain responsible for any explanations to the customer regarding the nature of the transaction where more detail is required, and must deal with customer complaints and discrepancies.
e) Financial Services
  • Owns the accounting ledger and is responsible for the recording and reporting of information received relating to the financial activities of the University’s units, and the high-level monitoring of the integrity of financial transactions.
  • Reviews and approves the form ““Access to Banfeed”.
  • Reviews, updates and signs the Memorandum of Agreement.
  • Requests the unit to re-confirm on an annual basis that the business case is unchanged (including the employees authorized to submit the feed files).
  • Is authorized to refuse a feed to FIS that does not comply with University policies and the Memorandum of Agreement.
  • Monitor and maintain system feed IDs, document numbers, user access, key contacts and system controls.

PR3. Memorandum of Agreement

 
A signed Memorandum of Agreement covering a period of no longer than three (3) years is required before any new feed is processed.

Special provisions exist for Banner to Banner interfaces within Financial Services.

Access to Banfeed form

Merchant (PCI) Policy and Procedures

Merchant Questionnaire

Procedures on Sales Taxes - Financial Services Knowledge Base:
Category: Sales Tax: http://kb.mcgill.ca/fskb


Publication Date: November 25, 2009
Revision Date: January 16, 2017 - V1.1

Related Memorandums, Announcements, and Revision Notes

January 16, 2017 - Version 1.1: Replaced the labeling convention "1., 2., etc." in the Procedures section to "PR1., PR2., etc."

November 25, 2009 - Memorandum from Albert Caponi, Assistant Vice-Principal (Financial Services) about Financial Transactions Feed Policy and Procedures - PDF icon PDF version