FinMAC hosts a variety of events. Some are meetings by invitation-only, others are working sessions for those involved in specific areas when specific needs arise. FinMAC's subcommitee for the Financial Systems User Network coordinates presentations or discussions that are of broader interest and open to everyone in the finance community at the University.
The Financial Systems User Network (FSUN) is an organization comprised of over 700 University employees who have finance-related job duties. Group activities are planned by the FSUN subcommittee of FinMAC. Suggestions welcome! FSUN wants to facilitate sessions people find useful, timely, and intersting. Email us at firstname.lastname@example.org.
2018 Spring Membership Meeting
The 2018 Spring Membership Meeting was held on April 24, 2018 at the Great Hall of Coffman Memorial Union.
Fiscal Year-End Procurement Cleanup
Criteria that causes POs to be ineligible to roll at FYE
- List of Active POs with $0 Lines (xlsx)
- List of Active POs with Partial Receipts (xlsx)
- List of POs in Budget Error (xlsx)
Current requisition data to help with cleanup
- Requisitions in budget error (xlsx)
- Aged requisitions (active requisitions that have not sourced to a PO) (xlsx)
- Requisitions with sourcing errors (xlsx)
PO reduction criteria (xlsx) will be closed at FYE to decrease large PO volumes that will jeopardize the roll jobs
- Tab 1: POs that haven't had a payment in 15 months
- Tab 2: Old Blankets that are less than $50K and more than three years old
Accounts Receivable Collections
Finance Reporting Strategy
Back to Basics on Department Deposits
- Account Budget Status for Non-Sponsored Funds demonstration
- Transaction Detail demonstration
- Chartfield String Budget Report demonstration
- Sponsored Dashboard demonstration
- RRC Dashboard demonstration
- How to build a query demonstration
Mondale Hall, RM 35
November 21, 2017, Noon-1pm
Angela Downin, Assistant General Counsel for the Office of the General Counsel and FSUN are hosting a brown bag on Contracts that need special pre-approvals. This presentation is geared for those situations where the supplier has their own contract or a supplier changes the University standard contract.
Discussion will include the following topics:
- What contract/terms and conditions to use
- Where to find terms and conditions
- Submitting a contract to the OGC
- Business vs. legal terms and what to look out for with business terms
- Timing of contract review
- Delegations of Authority
September 12, 2017
Financial Systems User Network (FSUN) hosted the 2017 General Membership Meeting
Great Hall, Coffman Memorial Union.
To view the recording of each presentation click the links below.
Fund Accounting presented by Sherrie Kutzler
FUNCTION, why is it so important? presented by Terri Hall and Sherrie Kutzler
Reconciling presented by Sherrie Kutzler
AR/Billing Q&A Panel presented by David Laden
Payroll Accounting presented by Sherrie Kutzler
“Color of Money" presented by Mike Volna
Requisitions and Suppliers presented by Kristen Berning
Things never to do when receiving against a Purchase Order presented by Kristen Berning
Paying foreign nationals presented by Amy Granlund and Sherrie Kutzler
What are the electronic payment formats used by the University? Presented by Amy Granlund
Really, what's hospitality/special expenses and what's just an excuse to try to get the U to pay for my lunch? Presented by Sue Paulson
UM Analytics report content showcase, live demo presented by Sue Paulson and Rob Howieson
Demonstration of the prepaid debit card presented by Alicia Theisen
AR Billing Best Practices handout
May 10, 2017
Fical Year End Brown Bag
FSUN hosted a brown bag on the Fiscal Year End process.
Some of the topics include-
* Overview of Year End close- what it means and why we do it
* Rules for PO Rollover and Close out ---what's changing this year
* Purchasing Rules and tips when requisition deadline has passed.
This event will be held on Wednesday May 10, 2017, Noon-1pm at the Humphrey School of Public Affairs, RM 25.
Amazon Business Account
FSUN had Tim Bray, Director of Purchasing Services speak about the University's Amazon Business Accont.
Watch recording (21 minutes)
General Membership Meeting
The 2016 Fall General Membership Meeting was held on October 19, 2016, 1:00pm - 3:00pm in the Mississppi Room, Coffman Memorial Union.
Thank you for attending our event! Please take the few minutes to take our online event evaluation.
June 28, 2016
Sales Tax on Catering Purchases
Session Slides (pptx)
Watch online (WebEx 45 minutes)
Due to technical difficulties, we were not aware that there were questions from on-line participants during the sales tax training on catering services held on June 28, 2016. Following are the questions that were submitted along with our answers. Please feel free to contact the Tax Management Office or me directly with any follow-up questions. Thanks for participating.
Q: How is tax assessed when you purchase something "on-line" and it is delivered locally?
A: When you order items on-line and they are delivered to the U, the sale occurs at the shipped-to address. If the item is taxable for the U because it is excluded from our exemption - such as for candy - the seller may or may not charge tax on the item (depending on whether the seller has nexus with the State of MN and has a filing requirement in MN.) If the seller does not charge tax, the U buyer needs to self-assess use tax so that the tax due is remitted to MN. The tax rate of the jurisdiction where the sale occurs applies to the sale. There are many on-line sellers that do not collect and remit MN sales tax, so this need to self-assess the use tax can make purchasing from those sellers less appealing.
Q: Are there best practices for retroactively removing sales tax, after perhaps a year or so has passed since the catering service was used?
A: If you find that you have over-paid sales tax, you first should consider whether the dollars involved warrant the time it will take to request a refund from the caterer. You may decide to watch current and future invoices and work with your supplier to get those correct versus asking for refunds of prior tax charged in error. However, if you have significant overpayments and you want to take the maximum action allowed, sales tax laws leave the tax periods open for three and one-half years. Technically, a supplier could file an amended return for periods going back three and one-half years to get back the overpayment from the State of MN. This can involve significant administrative work, so again, consider whether the impact is worth the work.
There were two questions related to gratuities:
Q: What are the gratuity suggestions?
Q: If we have catered services for an event at the U, can we give tips?
A: There are situations where it is appropriate and expected that a gratuity will be given to a caterer or a delivery person for a restaurant delivering prepared food. If the facts support that a tip would be appropriate, the general guideline at the U is a tip not to exceed 20% may be added. If the U adds the tip, the tip is not subject to sales tax. If there is a non-optional tip added by the caterer, that tip is subject to sales tax.
There were also two questions dealing with late submissions for reimbursements of expenses:
Q: Can you elaborate on how a late travel reimbursement MAY be deemed taxable income? This is noted in the travel policy.
A: When a request for reimbursement of travel expenses is made after the allowed 60 day period and there are no approved extenuating circumstances, the reimbursement may still be made to the traveler, but it will be made on a taxable basis. If the traveler's college/unit/department decides to make this type of taxable reimbursement, they must inform Payroll so the amount is added to the taxable income of the traveler. The Traveling on University Business Administrative Policy has been written to ensure that when reimbursements are made through the University's accountable plan, those reimbursements are excludable from income for the traveler pursuant to the Internal Revenue Code. When a reimbursement claim is not made timely, the IRC exclusion from income does not apply. Consequently, any reimbursement made after the 60 day period without approved extenuating circumstances is treated as additional wages and subject to income tax.
Q: When a non-employee travel reimbursement comes in after the 60 days, do we treat that as taxable income as we do with employee travel reimbursements that come in after 60 days?
A: Yes, generally reimbursements should follow the 60 day time frame ( unless the request is for miscellaneous out of pocket, non-travel status expenses which may be requested on an infrequent basis.) Non-employees working under a Contract for Professional Services are subject to a provision in that contract stating that travel expenses must be consistent with the U's travel policy. That contract also states that the U will generate a Form 1099-MISC for fees and reimbursed expenses to individuals, sole proprietors, partnerships and LLCs, and will report such amounts to the IRS. So, they should be making requests within the 60 day period, but the amounts are going to be reported as income on the 1099 whether or not the reimbursement claim is timely made.
Presented by Heather Broneak, Assistant Tax Director, University Tax Office
Learn how to ensure that the University is paying the correct sales tax when purchasing catering services. Topics include:
- Taxable versus exempt catering purchases
- Applicable tax rate - where does the sale occur?
- Gratuities - optional versus required
- Special local taxes
- Self-assessing use tax
You're welcome to bring your questions on other sales tax issues to be answered or discussed as time allows.
June 22, 2016
Session Recording (WebeX 52 minutes)
University Records Retention presented by Susan McKinney, Director Records and Information Management
With year end coming up, do you wonder what documentation you need to keep and for how long? With system upgrades and more documentation becoming automated do you wonder if policy has changed on retention of records? Join us on June 22 when we will delve into the University record retention policy--in time to clean up our offices.
May 11 & 18 2016
Presented by Sherrie Kutzler – Director, Accounting Services
Both sessions contain great information for both Finance & HR staff; please share this information with your colleagues!
Payroll Accounting – Session I
Session slides (pptx)
Session recording (WebEx 51 minutes)
Session to provide information on the link between HR and Finance, Additional Pay, Retro Distributions, and Graduate Assistant payroll.
Payroll Accounting – Session II
Session slides (pptx)
Session recording (WebEx 53 minutes)
Continuation of Session I, will include Payroll Encumbrances and Reporting.
April 22, 2016
Hospitality and Special Expenses
Friday - April 22, 2016, noon - 1:00 pm, 50B HHH Center
Session slides (pptx)
Session recording (WebEx 1hr 7 min)
A review of the University's Hospitality and Special Expense policy and opportunity to ask questions. Presented by Mike Volna, Associated VP & Controller and Beth Tapp, Travel/PCard Manager, Purchasing Services.
April 20, 2016
HRMS Appointment Entry Overview
Session recording (WebEx 59 minutes)
High level overview of the HRMS appointment entry process. Relationship between HR appointment entry and Payroll Accounting. How information entry at one point in the system affects entry later in the process. This is in preparation for later Brown Bag sessions on Payroll Accounting Presented by Patricia Samberg, HRMS Specialist 2, and Instructional Designer - ESUP.
April 18, 2016
The University - Coca Cola contract
Coke Products handout (pdf)
Session recording (WebEx)
Questions about the Coke contract can be directed to Missy Ek in UDS Contract Admin and Vending at 612-624-9048
Did you ever wonder why the University only uses Coke products? Or what benefits to the University the Coke contract provides? Leslie Bowman, Executive Director-Contract Administration and Jerry Taintor, Category Manager, Purchasing Services will conduct an informational session on the University's contract. We plan to offer online viewing as an option and plan to record this session.
February 3, 2016
Have you ever wondered what happens after you enter an invoice to be paid? Or, the best way to find a Supplier? LaCretia Bell, Director Disbursement Services, hosted a brown bag session to review those topics and more, like: What are the various ways a supplier is paid; Why do some payment route to Accounting Services & Payroll?
Recording of the presentation. (WebEx)
January 27, 2016
Things NOT to do when creating Requisitions
Kristen Berning from Purchasing Services presented a session to review the most important things that you should NOT do when creating the five types of requisitions: U Market, CPS, blanket order, standard purchase, and VCPS. In addition, she review the "don'ts" of entering comments, justifications, and uploading attachments (these are also common culprits behind EFS requisition errors). There was discussion on the most common requisition errors we've seen with this version of PeopleSoft Financials (errors since April 2015). Many of these errors cause re-work between preparers and approvers, or confuse suppliers. Some errors can even cause the system processes for procurement in all of EFS to fail!
RECORDING: Play recording (1 hr 19 min)
- How to Change a General PO to Be Received by Amount Instead of Quantity (pdf)
- How to Establish Amount Only Vs. Quantity Receiving on a Requisition. (pdf)
- Overview document for comments and attachments. (docx)
- The "short version" of attachments/comments that was posted to the message board. (pdf)
- How to image a VCPS voucher. (pdf)
- Slide presentation for the session. (pptx)
August 13, 2015
Kristen Berning hosted a Brown Bag session about Receiving Purchases. It was held August 13, 2015 11:30am - 12:30pm Nicholson Hall, RM 35.
Did you know that almost 1,000 purchase orders had to be force closed during the fiscal year end 2015 cleanup process due to receiving-related errors? FSUN and Kristen Berning from Purchasing Services will host a brown bag session on receiving. We will give a quick refresher on receiving basics, discuss the the most common errors, and provide best practice tips on how you and your cluster can be more proactive in resolving discrepancies between the PO, receipt, and voucher processes.
PowerPoint presentation: FSUNReceivingBrownBagFinalAug12th.pptx
Kristen also handed out several job aids:
- Receiving through Manage Requisitions job aid (pdf)
- Receiving using Purchasing -> Receipts -> Add/Update Receipts job aid (pdf)
- Receiving using the Receive Items Page job aid (pdf)
- Resolving Match Exceptions job aid (pdf)
- Establish Amount Only Vs. Quantity Receiving job aid (pdf)
- How to Change a General PO to be Received by Amount (Procurement Specialists) job aid (pdf)
Watch the recorded presentation using WebEx: https://umn.webex.com/umn/lsr.php?RCID=e461d0a0663347a7ba4f75725fc1b5d3
July 23, 2015 My Wallet & Expense Report
Beth Tapp hosted a Brown Bag session about My Wallet and Expense Report process. It was held on Thursday, July 23rd, noon-1:00pm, 315 Peik Hall.
Watch the recorded presentation using WebEx: https://umn.webex.com/umn/lsr.php?RCID=d1c267ac072c439a928be84fcfdd9823
Slides for the presentation: MyWalletExpenseReports7-23-2015.pptx
April 14, 2015 Effort Certification 101
Don Hammer, a Grants and Contract Professional in SPA, spoke from 10-11am on 4/14/15 about Effort Certification. It was held at Anderson Hall RM 270. Some topics to be discussed include:
- Basic Introduction: Effort 101
- Updated salary cap information
- Three email warning policy around effort certification
Watch the recorded presentation using WebEx: https://umn.webex.com/umn/lsr.php?RCID=ccf141f2932a4b5f9412f5fe737f4027
April 14, 2015 Accounts Receivable
David Laden, Director of Nonsponsored Accounts Receivable, spoke from 1:30-2:30pm on 4/14/15 about Accounts Receivable. It was held at Molecular and Cellular Biology RM 2-122. Some topics to be discussed include:
- Accounts Receivable tips and reminders
- Best practices
- Accounts Receivable monitoring
- Collection process
- How up-front EFS entries affect the entire Accounts Receivable process.
- Upgrade changes
Watch the recorded presentation using WebEx: AR_BrownBag.mp4
Scholarship Management & Fund Utilization Brown Bag
FSUN hosted two brown bags on Scholarship Management & Fund Utilization, presented by Mary O’Brien.
Mary O’Brien from the Foundation presented two brown bags on the Foundation fund use for scholarship funding through STAR and Spending Plans. Topics covered a review of the system, including reporting and various tools to help maximize use of resources available for scholarships.
They were held on August 13, 2014 10:30am 11:30am in the Labovitz School of Business & Economics 129-LSBE in Duluth and on Thursday August 14, 2014 at 11am - 12pm in the Molecular and Cellular Biology RM 2-120.
Payroll Accounting Brown Bag
FSUN hosted a brown bag on Payroll Accounting, presented by Kelly Krattiger.
Topics covered included: a review covering retro salary adjustments post-ESUP upgrade, funding at position/pool level, position data, and a brief summary of the portal.
It was held on Wednesday July 30, 2014 at 10:30am - 11:30 in the Molecular and Cellular Biology RM 2-122.
If you would like to view the presentation:
Spring General Membership Meeting 2014
The Spring General Membership meeting was April 23, 2014.
This event covered the latest information on The Upgrade, including Procurement Card changes, Portal, Payroll accounting and financial reporting. The full agenda is available.
Wiew a recording of the presentation:
Sales Tax Brown Bags
FSUN hosted brown bags both in person and via UM Connect on Sales Tax. Topics covered will include: a review of property and services subject to sales tax; the U's status as a seller versus a buyer; the U's filing structure; exempt customers and necessary documentation; sales tax in other states; and updates on recent legislative changes and proposals.
Presentation slides: SalesTaxPresentationUMConnect.pptx