Two New Opportunities for EPM Data Warehouse Users

Open Labs

Are you a savvy user of the standard SWIFT reports found in the EPM Data Warehouse? Want to further customize your reports to meet your unique business needs but are unsure how to approach it? Join the SWIFT training team for open labs intended to foster collaboration and problem solving. Beef up your reporting skills while helping others enhance theirs. The shared goal is to access the SWIFT information you require to solve real state data needs. 

Labs will run approximately 90 minutes and will cover 1 or 2 topics nominated by you. The more topics, the more labs! Email us at [email protected]. Send us your topic, including the parent report/subject area (sorry, SWIFT-related only), the desired outcome, and any issues you’ve encountered. 

New Lab Offered - SWIFT EPM Formatting Your Report

Join us for an informal lab to learn about formatting a saved report in the EPM Data Warehouse. This lab is for agency staff with EPM Data Warehouse and SWIFT permissions and roles. Work alongside the instructor as we explore various ways to format and customize the display of your reports. You will learn how to format headers and values, rearrange columns, add formulas, actions, views and other objects, and customize with color. Please have a saved report to access in My Folders.

General Accounting Supervisor – Finance Accounting Supervisor

This position closes end of day today!

Minnesota Management and Budget (MMB) is hiring a Finance Accounting Supervisor. The position supervises the staff and operations of the General Accounting unit in the Statewide Accounting Section of Minnesota Management and Budget, Accounting Services Division. This unit is responsible for maintaining the chart of accounts and the statewide reconciliations for SWIFT, and preparing the budgetary statements, the Legal Level of Budgetary Control Report, and the Statewide indirect cost plan.

This position will have the flexibility to telecommute, work a hybrid schedule, or work in the office. The incumbent may be expected to work in the office on occasion.

Working for the State of Minnesota means a great work-life balance, affordable benefits, and many great opportunities for advancement in 100 State agencies. Job ID is 68502.

Prepare for Major Tax Updates

New taxes included in this notice may have significant impact to SWIFT transactions financially and in terms of the number of transactions affected. If possible, try to get the taxable items delivered no later than September 30, 2023. Taxable items delivered on or before September 30, 2023, benefit from the lower tax rate and these purchase orders do not need to be updated. Sales and use tax rates are based on the agency’s Ship To Location listed on the purchase order.

Notice on New Local Tax

The Minnesota Department of Revenue will be administering the following new sales and use taxes effective October 1, 2023:

• https://www.revenue.state.mn.us/sites/default/files/2023-07/general-notice-metro-area-transportation-tax.pdf
• https://www.revenue.state.mn.us/sites/default/files/2023-07/general-notice-metro-area-tax-housing.pdf
• https://www.revenue.state.mn.us/sites/default/files/2023-07/general-notice-fergus-falls.pdf

The sales and use tax rate changes apply to sales made on or after October 1, 2023. They will be in addition to all other taxes in effect. Local sales tax applies to retail sales made and taxable services provided within the local taxing area (county/city limits). The tax applies to the same items that are taxable under the Minnesota sales and use tax law.

Agencies entering purchase orders for the new fiscal year, prior to the October 1, 2023 tax effective date, will have the old rate calculated and will need to update their purchase orders.

Purchase orders entered in SWIFT on or after October 1, 2023, will calculate the new tax rates for each county/city. Existing purchase orders and/or their vouchers will need to be adjusted to pay the correct tax if delivery occurs after various dates. Please note that the dates will be different based on whether goods or construction materials are being delivered. Check the tax notice for the affected city for the correct dates.

For assistance in changing the sales tax on a purchase order, please consult the Update the Sales Tax Settings on an Existing Purchase Order quick reference guide. You can also view the Update Sales Tax on an Existing Purchase Order video.

Impact of New Local Tax

Please see the Minnesota Department of Revenue tax notice for the appropriate city for guidance in handling purchase orders and payments during the transition period.

Impact on Accounts Payable

Vouchers entered in SWIFT on or after the tax effective date will calculate the new tax rates for each county/city if the Invoice Date is on or after the tax effective date. If the Invoice Date is before the tax effective date, SWIFT will exclude the new tax rates. Please review the tax calculation carefully prior to payment on all vouchers with Ship To locations within these jurisdictions.

Impact on Purchase Orders

SWIFT will be updated with the new tax codes for all existing Ship To addresses located in the affected cities. New purchase orders, created on or after October 1, 2023, will calculate the new rate of tax for the ship to addresses within those counties/cities. Existing purchase orders may or may not need to have the tax code updated on the PO if payment can be processed during any allowed grace period(s), again, see the general notice for each county/city. Previously any Ship To addresses in affected cities may have used the tax code of 0000, State Tax only. To calculate the new combined rate, state and local tax rate, the tax code(s) on the purchase order must be updated to the new tax code(s) from the 0000 tax code. Because of the various transition rules, these codes will not be updated by SWIFT and must be updated by the purchase order buyer.