MyFloridaMarketPlace

MyFloridaMarketPlace Invoice Training

Agenda • MFMP Overview • System Basics • Defining an Invoice Reconciliation • Creating an Invoice Reconciliation • Reconciling an IR • Approving an IR • Disputing an IR • Change Orders to Update Accounting • Helpful Processing Tips • Various FA eForms • System Searches • Failing FLAIR Integration Page - 2

MFMP Overview MyFloridaMarketPlace (MFMP) is the State of Florida’s source of e-procurement (procure to pay) for agency’s purchasing and sourcing. Started operation July 1, 2003. One-stop shop for accessing on-line catalogs and information about vendors that provide goods and services to the State. More Choice: MFMP provides online access to the system’s registered vendors, State Term Contracts, quoting, and sourcing. Reduced Error Rates: More validation of purchasing and F&A information. Faster order processing time: By automating the transactions, contracts, and approvals; the time for requisition to payment is reduced. Reduction in the cost of goods and services: MFMP allows State Purchasing visibility into agency spending thus giving them better leverage when negotiating State Term Contracts which leads to lower costs for agency customers. Page - 3

MFMP Overview With the Requester group, customers will have the ability to: Create and Submit a Requisition Initiate change orders Initiate receipts against their orders Create and Submit an Invoice eForm Search and copy their purchase orders Create folders and file items within them With the Invoicing group, customers will have the ability to: Create and Submit an Invoice eForm Edit all accounting fields Initiate change orders Reconcile, Approve and Reject Invoice Reconciliations Conduct agency-wide searches for Requisitions, Orders, Invoice Reconciliations, etc. Additional information can be found on the MFMP Toolkit available on the DMS website http://myfloridamarketplace.com/training. Page - 4

Agenda MFMP Overview System Basics Defining an Invoice Reconciliation Creating an Invoice Reconciliation Reconciling an IR Approving an IR Disputing an IR Change Orders to Update Accounting Helpful Processing Tips Various FA eForms System Searches Failing FLAIR Integration Page - 5

System Basics You will sign on with your user name and password You can select “where” you want to goby clicking on your option in the dropdown box Page - 6

System Basics Remember to log out by clicking the Logout button. Don’t click the “X” on your Explorer screen. Page - 7

System Basics When your session has been idle for 14 minutes, the Logout Warning popup will appear with a countdown of 60 seconds. If you want to continue with your work in MFMP, click on the Cancel Logout and your session will remain open Page - 8

System Basics Dropdown boxes hold your last five choices. If your choice is not listed, click “Other” to search by entering all or part of the name or item you wish to select. This feature works the same throughout To expand your view, you can collapse the navigation pane. Page - 9

System Basics When the calendar box has been selected, to move forward by one month, click the single arrow. To move forward by one year, click the double arrow. Once you have found the appropriate date, click on the date and it will populate onto your requisition Page - 10

System Basics To Change your Password, Delegate Approval Authority, or Email notifications, click on your Preferences link Page - 11

System Basics • Passwords must be a minimum of 7 characters and a maximum of 8 characters and are case sensitive. This is secure and should not be shared. If you forget your password, contact your system administrator for assistance • Delegate Approval prior to Leave to ensure the IR process continues in your absence • Preferences can be set to change the frequency in which you receive email notifications • With immediate notification, customers will receive emails as soon as an item requiring their approval becomes active in the workflow • Email summaries are sent once a day and contain a list of all items requiring the customer’s approval Page - 12

Defining an Invoice Reconciliation • An IR is created when MFMP matches an invoice to its purchase order and receipt • MFMP handles services differently than commodities • MFMP performs a 3 way match for commodities: invoice compared to the order and the receiving report • MFMP performs a 2 way match for services: invoice compared to the order • Discrepancies or differences are listed on the IR as exceptions • All exceptions must be reconciled before the IR can be approved for payment Page - 14

Defining an Invoice Reconciliation On Behalf Of (OBO) Exception Handler Invoice Manager DFS Audit (if applicable) FLAIR • Services invoices require the requester to approve the invoice prior to the Exception Handler. • By approving the IR, the requester is approving that the services were received. • A PO with a “9” series commodity code is an order for services. Page - 15

Defining an Invoice Reconciliation Exception Handler Invoice Manager DFS Audit (if applicable) FLAIR • Commodity invoices are routed to the Exception Handler (or F&A Gatekeeper) for approval first. • OBO’s do not need to approve the invoice prior to approval by the F&A Office. • OBO’s approve the payment by documenting the goods were received via the receiving process. Page - 16

Exception Handler Normally the first F&A Approver Responsible for reconciling all exceptions Ensures that the invoice matches to the terms of the order Ensures goods were received or services were approved Ensures that the transaction date is accurate Invoice Manager Ensures the invoice should be approved FLAIR username and password are recorded in FLAIR when the IR is approved Last agency approver of the invoice If DFS returns the IR for additional information, the Invoice Manager is added to the approval flow Defining an Invoice Reconciliation Page - 17

Creating an Invoice Reconciliation • There are two ways to create an IR: • Invoice eForm (Agency creation) • Using the paper invoice, the invoice is entered into MFMP by the agency • A scanned image of the invoice and supporting documentation should be attached to the Invoice eForm • Electronic Invoice (Vendor creation) • Also known as a PO flip or ASN invoice • Vendors have the ability to submit invoices electronically • A paper copy of the invoice is not needed Page - 19

Creating an Invoice Reconciliation From either of these links you can select a variety of eForms including the Invoice eForm Page - 20

Creating an Invoice Reconciliation Select Invoice eForm to create an Invoice Reconciliation. Depending on your assigned groups you may have additional eForms Page - 21

Creating an Invoice Reconciliation • Enter an appropriate Title following your agency’s standard titling convention. This field allows numbers, letters, and special characters • Supplier Invoice # field can contain a maximum of 30 characters, and becomes part of the IR #. The last 9 digits will be sent to FLAIR and will be recorded on the warrant so the number should reflect the vendor’s invoice. Should a number not be provided please refer to your agency’s practices. Page - 22

Creating an Invoice Reconciliation • Supplier Invoice Date: This is the date of your vendor’s invoice as provided by the vendor • Invoice Received Date: Record the date the invoice was received by the office notated in the Bill To section of the purchase order • Services Start Date & Services End Date: DFS requires that services start and end dates are entered for all services invoices Page - 23

Creating an Invoice Reconciliation • Select the Vendor Location by clicking on the drop down box • This must be the exact Vendor Location that is on the purchase order • The last five vendors will be displayed. If the vendor you need to invoice is not displayed, select other Page - 24

Creating an Invoice Reconciliation • To choose a vendor, type in your vendor’s name and click Search • You can also search utilizing other options. You can search by any one of the fields listed in the box to the left • Click on the dropdown to change your search options. The headers correspond to the available search options • When you have multiple returns, you can sort by the header column of your choice When you locate your vendor, press the Select button Page - 25

Creating an Invoice Reconciliation Supplier Name will populate with the Vendor Location choice Enter the total amount of the invoice in the Subtotal field Press the Next button to select an Order to invoice against Page - 26

Creating an Invoice Reconciliation . • Invoicing without Order/ Release?: • For invoices against orders select “No”. • For invoices directly against a contract (MA###), select “Yes” Purchase Order: Press the select button the search for your Order Page - 27

Creating an Invoice Reconciliation Once you have found the correct Order, press the Select button If you have selected the wrong vendor location, the purchase order will not return. Page - 28

Creating an Invoice Reconciliation Once the Order has been selected. Press the Generate Invoice button to display all the lines of the order

Creating an Invoice Reconciliation Enter in the quantity and amount that is being invoiced Note: Ensure the appropriate line number is in the Line # box, or it will become an unmatched item on the IR If your order has multiple lines and you are not invoicing against the entire order, check the item that you’d like to delete and press the Delete button Page - 30

Creating an Invoice Reconciliation Press the Next button to complete the invoice If another line item needs to be added (i.e. for shipping), you can add a new line item which will need all information to be populated NOTE: Although you have the option to copy a line item, it is not recommended Page - 31

Creating an Invoice Reconciliation • To add a copy of the invoice as required by DFS, or any other attachment: • Read the disclaimer and Check the checkbox indicating your compliance • Click the Add Attachment button Review the eForm for accuracy. If no changes are necessary, press the Submit button to create your IR

Creating an Invoice Reconciliation • If confidential information is attached to the IR an Confidential Information Removal Request Form must be completed and submitted to the Customer Service Desk by the appropriate agency liaison • For more information on your Agency’s Confidential Policy, contact your agency MFMP Security Administrator • Further information on Scanning and Attachment Guidelines can be located in the MFMP Toolkit • Scanning & Attachment Guidelines Scanning and File Attachment Guidelines .doc • Confidential Information Purging Confidential Information Purge Request Process PUR 3785 - Confidential Information Purge Request Form

Creating an Invoice Reconciliation • Benefits of Electronic Invoicing • An Invoice eForm will not need to be created • No need to scan attachments • Reduce invoice data entry requirements for State Agencies • Vendors will be notified systematically if an invoice is rejected and will see the comments that the agency includes as to the reason for rejection • Reduction of paper flow • Improved data accuracy (no keying mistakes) • Disputed line item comments will be transmitted to the vendor Page - 34

Creating an Invoice Reconciliation • VF Imagewear • Marpan Supply Company, Inc. • Colamco, Inc. • Mac Papers • TYBRIN Corporation • Ronco Communications & Electronics, Inc. • Information Builders, Inc. • Currently Utilizing e-Invoicing (8-1-09) • Office Depot BSD • Grainger Industrial Supply • Hayes E-Government • Resources • Lewis Digital, Inc. • Gulf Ice Systems, Inc. • Computer Tutors USA • Dell Marketing L.P • Leitz & Reed Office • Products, Inc. • Stanbio Laboratory • Bay Systems, Inc • Law Enforcement Targets, Inc • Alston & Bird LLP • BMC Software Distribution Inc. • Thermal Tech, Inc • The Canopy of Technology, Inc. • CLASSIC PRINTING COMPANY • Sysco Food Services of South Florida, Inc Page - 35 For an updated list of all eInvoicing vendors is available on the MFMP Toolkit

Practical Exercise 1 If you have questions, please raise your hand for assistance Page - 36

Reconciling an IR From your Reconcile queue in the shortcut menu, you can see the invoices that require your attention. Notice that the number displayed shows how many items are pending your approval Page - 38

Reconciling an IR • You can group items by status, supplier, etc. This can be helpful when prioritizing your work • By Clicking the Table Options Menu, you can group, export and Show / Hide fields within your queue • NOTE: • The IR number is comprised of two parts: the invoice number that was entered on the invoice eForm (eInvoice) and a 6 digit sequence number • When referring to the IR, use the sequence number Page - 39

Reconciling an IR • Choose the IR that you are going to work on • Any Row can be sorted by clicking on the Header • The status of the IR indicates what state the item is in: • Approving status means the IR has been reconciled and requires approval • Reconciling status means the IR requires reconciliation Page - 40

Reconciling an IR Typical Audit Steps Receive invoice Compare invoice to terms in contract document Approve invoice Key into FLAIR Verify receiving report/ services were approved MFMP Audit Steps • The IR will pre-audit your invoice against the order and receipt (if a commodity) • All exceptions/discrepancies will be displayed and you will be required to reconcile and resolve these • Reconciling is “auditing” the invoice • By approving the invoice, you are bypassing the requirement to enter the information into FLAIR. Page - 41

Reconciling an IR • Once the IR is created, MFMP will conduct a match against the order, invoice, and receipt (if applicable) • The discrepancies will be listed as exceptions • Click an Exception to see additional details about the exception Page - 42

Reconciling an IR The Exception Details define what the exception is Notice the Received Quantity Variance between what has been received and what has been invoiced Page - 43

Reconciling an IR • An IR is comprised of 6 components • Exceptions: Performs the match and displays the discrepancies • Approval Flow: Defines who is required to approve and who has approved • Invoice: Details the invoice • Order: Offers direct access to the purchase order • Receipt: Captures all receiving reports (If PO is for service, this tab will be blank) • History: Details and records all activity on the IR Page - 44

Reconciling an IR Header Level Exceptions: Exceptions for the entire invoice • Amount Variance: The total cost of the invoice is different than the total cost of the purchase order. This variance will occur when you have a partial payment for an order • Invoice Reconciliation Already Exists: An Invoice Reconciliation with the same Invoice Number and Supplier already exists. This could be a result of the vendor having already sent an electronic invoice. *This is not a common Exception Line Item Exceptions: Exceptions for a line • Accounting Verification Exception: Every IR will have this exception. Accounting information must be verified before accepting this exception • Quantity Variance: The quantity on the invoice line item is different from the quantity left to invoice on the order line item • Price Variance: The price on the invoice line item is different from the price on the order line item • Received Quantity Variance: The quantity field on the invoice line item is different from the quantity left to invoice on the receipt line item Page - 45

Reconciling an IR • Validate the Transaction Date. This date is used to calculate your prompt payment compliance • MFMP selects the date based on the information that is available in the system at the time the IR is generated • If the receiving report has not been created, MFMP will not take the received date into consideration • View the receipts tab to see when the commodity was received Page - 46

Reconciling an IR IR matches items to the line item of the order Page - 47

Reconciling an IR • You can click on the Invoice eForm link to view the scanned invoice attachment • If the invoice was received electronically the Invoice eForm link will not be available The purchase order’s amount reflected here indicates how much is left to bill on the invoice. This does not reflect any IR’s in Reconciling or Approving Status Page - 48

Reconciling an IR • Remember: • An IR will escalate if it has been pending in a “CUSTOMER” queue for 10 business days. Items pending a role do not escalate. If you have a business need to have another approver review the IR, you can manually add an approver Page - 49

Reconciling an IR • To add an approver select a customer by pressing the Select button and search for the appropriate approver • Select “Approver” or “Watcher” • Provide a reason This field is optional, however, it will be included on the approval flow You can select where the added approver will fall in the approval flow Page - 50

MyFloridaMarketPlace