1 of 79

Expenditure Transfers & Budget Transfers & Revisions

PRESENTED

January 10, 2022

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

2 of 79

AGENDA

Introductions (10:00 – 10:10 AM)

Budgets (10:10 - 10:30 AM)

General Ledger (GL) String

Chart of Accounts

Colleague Reports

B.O. Forms Overview (10:30 - 10:50 AM) 

Expenditure Transfers

Budget Revisions/Transfers

Check Requests

5 W’s

Accounts Payable/Purchasing (10:50 - 11:30 AM) 

Requisitions

Purchase Orders (Mercury Commerce)

Mercury Commerce

Blanket Purchase Orders

Vendors

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

3 of 79

BUDGETS

GENERAL LEDGER (GL) STRING

CHART OF ACCOUNTS

COLLEAGUE REPORTS

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

4 of 79

BUDGET STRING & CHART OF ACCOUNTS

F-A-L-T-O

Fund – program funding source (2 numbers)

Area – what is the primary function of your program (3 numbers)

Location – where is your program’s primary campus (2 numbers)

Top – program identification number (6 numbers)

Object – categorizes what you are purchasing (5 numbers)

Example budget string:

12 – 300 – 00 – 720000 – 56405

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

5 of 79

OBJECTS

51000 Academic Salaries

52000 Classified Salaries

53000 Benefits

54000 Supplies

55000 Other costs, Contract Services, Program Operations

56000 Capital Outlay

57000 Student stipends, scholarships, Indirect

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

6 of 79

COLLEAGUE BUSINESS REPORTS

    • GLBS - Detailed Budget Status Report
    • GLBR - Year-to-date Budget Summary Report w/ Purchase Orders

Budget Reports:

    • ACBL – GL Account Balance Inquiry
    • VENI - Vendor Activity Inquiry
    • PINQ - Purchase Order Inquiry
    • BINQ – Blanket PO Inquiry

Inquiry Screens:

    • PREG – Purchase Order Register�

Purchase Order Report:

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

7 of 79

FORM OVERVIEW

EXPENDITURE TRANSFERS

BUDGET REVISION/TRANSFER

CHECK REQUESTS

5 W’s

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

8 of 79

EXPENDITURE TRANSFERS

Expenditure transfers are considered reclassification of expenditures

Reclassification of expenditures is an audit finding

Must indicate reason for expenditure transfer, should avoid using words like “mistake” or “error”

When transferring salaries, you must transfer the correlating benefits. If you are transferring a percentage of a salary, the benefits must also be transferred at that same percentage

Please limit expenditure transfers

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

9 of 79

Put the end of the month date example – Submitting expenditure transfer 01/10/22, Period Ending would be 1/31/22

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

10 of 79

Each object should have their own line.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

11 of 79

Debit = where you want to transfer the expense to

Credit = where you want to transfer the expense from

Example- moving $100 supply purchase from one tops to another- $100 purchase original tops in credit, $100 purchase transfer tops debit

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

12 of 79

Detail out the expense that you are transferring - Example, CREDIT line - moving expenditure to TOPS

Debit line - moving expenditure from TOPS

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

13 of 79

These two totals should match, if they are unbalanced check your credits and debits

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

14 of 79

Provide a brief explanation for the request. Example – Moving funds to NEW Tops.

Note: For federal grants, please avoid using words such as wrong account or correction

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

15 of 79

Write the name of who prepared the document

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

16 of 79

Must be approved by the budget manager

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

17 of 79

If the transfer is Fund 12 then the Grant Manager will sign, if Fund 11 then the Controller will sign.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

18 of 79

BUDGET �TRANSFER/�REVISIONS

  • All budget revisions must be board approved
  • Budget revisions are when you change from different categories, example 51000 (Academic Salaries) to 54300 (Supplies).
  • Budget Transfers are when you change budget within a category, example 55100 (Individual Contractor) to 55105 (Company Contractor).
  • Must put an explanation for why the revision or transfer is occurring
  • Must put description of where funds are going or being received from
  • Debit = object without money
  • Credit = object with money

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

19 of 79

Put the end of the month date example – Submitting budget entry on 01/10/22, Period Ending would be 1/31/22

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

20 of 79

Moving money from an object with the same two first numbers is a transfer, two different numbers is a revision example – moving money from 55800 to 54300 is a Revision, moving money from 55800 – 55105 is a Transfer

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

21 of 79

Each object should have their own line.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

22 of 79

The object should start with a 5, you cannot move revenue between objects, which starts with a 4

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

23 of 79

The Tops should match, you cannot transfer money from one fund to another, you can only transfer expenditures

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

24 of 79

Debit = where you want to transfer the money to

Credit = where you want to take the money from

Example- moving $100 from 55800 – 54300, Debit 54300 $100, and Credit 55800 $100

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

25 of 79

Detail out where the money is moving to. Example, moving $100 from 55800 to 54300, description would be To 54300, and on the 54300 lone, description would be From 55800

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

26 of 79

These two totals should match, if they are unbalanced check your credits and debits

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

27 of 79

Provide a brief explanation for the request. Example – Moving funds to cover purchasing of supplies.

Note: All Budget Revisions are Board Documents and are submitted to the Board for approval

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

28 of 79

Write the name of who prepared the document

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

29 of 79

Must be approved by the budget manager

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

30 of 79

If the transfer is Fund 12 then the Grant Manager will sign, if Fund 11 then the Controller will sign.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

31 of 79

Example of Budget Revision

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

32 of 79

Example of Budget Transfer

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

33 of 79

CHECK REQUESTS

Dues/Memberships

Subscriptions

Reimbursements

Conference Registrations

Travel (ALL - includes hotels, airfare, car rentals, etc...)

Student Stipends (all students must have a non-service agreement on file to process their stipends), & Student Sponships

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

34 of 79

CREDIT CARD REQUESTS

The Business Office has a college credit card to use for the following: 

    • Virtual conference registration
    • Purchases in which the vendor does not accept payment by check or a purchase order. 

Send Completed Credit Card Request form to Lucy.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

35 of 79

If you would like to use the College Credit Card, please check this box

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

36 of 79

Date that the form is being submitted

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

37 of 79

Information of person filling out the form in case there are questions

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

38 of 79

Colleague ID of the person being reimbursed

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

39 of 79

Name and Address of who is being paid through the check request

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

40 of 79

Put a description of each item you are purchasing and which Account it should be paid out of, you can use multiple accounts on one check request. Be sure that the budget manager for each account has signed.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

41 of 79

Provide any additional information, such as where check should be mailed to or made out to if different than vendor information in Colleague. Or if there are any notes needed in the memo of the check, such as invoice number or membership number

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

42 of 79

Budget Manager should sign the Check Request before it can be processed, if the Budget Manager is the payee, then the Dean or VP will need to sign. You cannot sign your own reimbursement. For purchases over $5,000 the VP need to sign, if it is over $10,000 the President must sign the check request as well.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

43 of 79

5 Ws

  • Required for all food purchases
  • Must be done for each event that food was purchased for
  • Must be submitted along with requisition
  • Must submit when purchasing any food, including when cafeteria services are used

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

44 of 79

Date that the form is being submitted

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

45 of 79

Name of person filling out the form

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

46 of 79

Department where purchase was made

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

47 of 79

Who attended the event

Students

Faculty

Staff

Community Members

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

48 of 79

Event title, formal or informal, why did you hold the event. Example - Staff meeting

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

49 of 79

Where the event was held, please be specific

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

50 of 79

Date of Event

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

51 of 79

What funding source paid for the event, and what the event was held for.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

52 of 79

Signature and printed name of who submitted the form

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

53 of 79

ACCOUNTS PAYABLE/PURCHASING

REQUISITIONS

PURCHASE ORDERS

BLANKET PURCHASE ORDERS

RECEIVING

VENDORS

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

54 of 79

REQUISITIONS

Requisitions for Purchase Orders are required for:

    • Tangible Goods
    • Services (except entertainment/speakers)
    • Food/Catering Services

Purchase Orders must be created before placing orders for goods or services.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

55 of 79

PURCHASE ORDERS

Purchase Orders (or regular POs) are for defined purchases and are valid for one use only. Product, quantities and unit pricing are known, and are listed as line items on the PO when the request is converted.

�Requests for Purchase Orders (regular POs) are processed through Mercury Commerce.

There are some exceptions to using a Purchase Order: 

See Check Request & Credit Card Guidelines

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

56 of 79

REQUISITIONS IN MERCURY COMMERCE

  • Mercury Requisitions are for defined, one-time purchases.

  • All requisitions must have supporting documentation attached.

  • The requisition items, quantities, and pricing should match the supporting document.

  • When in doubt, contact Purchasing.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

57 of 79

RECEIVING

Receiving needs to occur before an invoice can be paid.

This task is primarily done by the warehouse, however not everything is handled by the warehouse. Services, and any goods that bypass the warehouse (such as deliveries direct to Alisal or King City), need to be received by the department/requester.

  • Mercury Commerce (regular POs):
    • Use the Receive tab.

Receiving and Closing are NOT the same - Depts receive; Purchasing closes.

  • Colleague (Blanket POs):
    • Send the invoice with payment authorization to Accounts Payable.
  • Colleague (regular POs):
    • Warehouse has access and should do the receiving.�

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

58 of 79

RECEIVING

Once you have received the item in Mercury Commercy, you must submit the invoice, with reference to the Purchase Order and signature of the Budget Manager to accountspayable@hartnell.edu for payment

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

59 of 79

BLANKET PURCHASE ORDERS

  • Blanket POs are for multiple payments to the same vendor throughout the fiscal year for a single project/service, or for undefinable goods purchases.�Example: A service contract for quarterly maintenance.
  • Blanket POs are requested using the Purchase Requisition form (not through Mercury Commerce) and processed directly in Colleague.

Purchase Requisition forms may be obtained from Purchasing or the Business Office.

  • Approval logic is the same as Mercury Commerce; approval signatures must be obtained on the Requisition Form.

Signature Guidelines can be found on the Purchasing website.

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

60 of 79

BLANKET PURCHASE ORDERS

Name of the department submitting the Blanket Purchase Order

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

61 of 79

BLANKET PURCHASE ORDERS

Name of the Vendor and address of the vendor you are creating the Blanket Purchase Order for

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

62 of 79

BLANKET PURCHASE ORDERS

Date you are submitting the requisition

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

63 of 79

BLANKET PURCHASE ORDERS

Account number that you are opening up the Blanket Purchase Order under, please include your full GL along with the object

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

64 of 79

BLANKET PURCHASE ORDERS

Vendor ID number, you can find the Vendor ID number by looking it up in the Colleague report VENI

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

65 of 79

BLANKET PURCHASE ORDERS

For contracts put scope of work that contractor will be doing, or put the items you would like to purchase, please be as detailed as possible

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

66 of 79

BLANKET PURCHASE ORDERS

If applicable please add the unit price

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

67 of 79

BLANKET PURCHASE ORDERS

Please indicate the complete total amount, you are not exceed this amount and this is the amount that will be encumbered on your account

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

68 of 79

BLANKET PURCHASE ORDERS

The person submitting the paperwork should sign the form

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

69 of 79

BLANKET PURCHASE ORDERS

The Budget Manager should sign here

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

70 of 79

BLANKET PURCHASE ORDERS

If the amount is over $5,000 then the VP will need to sign

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

71 of 79

BLANKET PURCHASE ORDERS

If the amount is over $10,000 then the President will need to sign

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

72 of 79

BLANKET PURCHASE ORDERS

If you want to increase your Blanket Purchase Order do the following:

  • Check the box indicating BO Increase
  • Add Blanket Purchase Order number given, starting with B
  • Write the original amount the Blanket Purchase Order was set for
  • Write the additional amount needed
  • Add the two together and write the total in the final line
  • Process for signature

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

73 of 79

VENDORS

Before using a vendor they must submit a New Vendor Form and W-9

Use colleague report “VENI” to determine is vendor is established

New vendors require at least 2 weeks to be entered into the system

Do not use services of a vendor until they are established in colleague

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

74 of 79

NEW VENDOR FORM

Vendor must check one of the boxes to indicate what they are providing to the College

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

75 of 79

NEW VENDOR FORM

If they will be on-campus they must submit a certificate of insurance

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

76 of 79

NEW VENDOR FORM

Please make sure this matches the W-9 the vendor submits exactly, if they are doing business as a different name, please put that here

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

77 of 79

NEW VENDOR FORM

This is where we will send completed POs, please make sure to fill in with contact information

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

78 of 79

NEW VENDOR FORM

If this is different than their business address or if they have separate address to mail checks, please indicate that here

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu

79 of 79

NEW VENDOR FORM

The vendor must sign here before it is submitted

GROWING LEADERS Opportunity. Engagement. Achievement. www.hartnell.edu