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

​