Financial Reporting & Reconciliation March 14, 2018 Training - - PowerPoint PPT Presentation

▶
financial reporting reconciliation
SMART_READER_LITE
LIVE PREVIEW

Financial Reporting & Reconciliation March 14, 2018 Training - - PowerPoint PPT Presentation

Jan 05, 2024 154 likes •961 views

Financial Reporting & Reconciliation March 14, 2018 Training Overview Discuss Reconciliation Process and After the Fact Review Run reports in BUworks Business Warehouse Three types of reports Unrestricted Budget to Actual

slide-1
SLIDE 1

Financial Reporting & Reconciliation

March 14, 2018

slide-2
SLIDE 2

Training Overview

  • Discuss Reconciliation Process and After the Fact Review
  • Run reports in BUworks Business Warehouse
  • Three types of reports
  • Unrestricted Budget to Actual
  • Designated / Restricted Balance & Activity
  • Transaction Detail
  • Open and analyze reports in Excel using Pivot Tables
  • View the workflow and attachment of a Journal Entry
slide-3
SLIDE 3

Reconciliation

What does reconciliation mean and entail?

 Reviewing transactions on a monthly basis  Evaluating expenses and revenues versus budget  Ensuring transactions are accurate and complete  Correcting errant transactions  Documenting the reconciliation process for auditing purposes

slide-4
SLIDE 4
  • 1. Appropriate and allowable
  • 2. Recognizable and approved
  • 3. Supported with documentation
  • 4. Reasonable
  • 5. Closed out
  • 6. Resolved

Reconciliation

Six Objectives of Reconciliation Are your transactions?

slide-5
SLIDE 5

After the Fact Review

slide-6
SLIDE 6

After the Fact Review

Tracking Sheet

Accounts* Account Name Reconcile By: Period Reviewed Date Open Issues 1234567890 Any Department 1 Roger Smith 5/1/2016 - 6/15/2016 No 1245678901 Any Department 2 5/31/2016 1256789012 Any Department 3 9091234567

  • Dr. Jones' Designated Account

Sandra Johnson 5/1/2016 - 6/15/2016 No 9098901234

  • Dr. Rogers' Designated Account

5/31/2016

  • If you have a tracking mechanism that works that contains the key data recorded in

this After-The-Fact Review Tracking sheet, continue to use your tracking mechanism.

  • Retain your After-The-Fact Review tracking sheets (or your equivalent tracking

mechanism) in your records for 7 years. This can be in paper or electronic form.

slide-7
SLIDE 7

BUworks – Accepted Browsers

slide-8
SLIDE 8

Monthly Reports - BUworks

 Navigate to bu.edu/buworks  Enter Kerberos password  Choose “Reporting” tab

slide-9
SLIDE 9

Monthly Reports - BUworks

slide-10
SLIDE 10

Account Hierarchy

Funds Management (FM) Module Grants Management (GM) Module

(244)

slide-11
SLIDE 11

Monthly Reports - BUworks

Click the triangle next to “Funds Management”

slide-12
SLIDE 12

Monthly Reports - BUworks

 The three reports covered in the training are highlighted on the left

slide-13
SLIDE 13

Monthly Reports

Designated/Restricted Balance & Activity – GL/CI Detail

Displays a summary view of designated and non-grant restricted accounts for one or more Fund Centers.

Unrestricted Budget to Actual by FC – GL/CI Detail

Displays a summary view of unrestricted accounts for one or more Fund Centers. It provides a snapshot of the budget, income/expense actuals, and commitments.

Transaction Detail

Provides detailed information of each individual transaction and allows the user to view Actual postings as well as Committed Funds for the account.

slide-14
SLIDE 14

Account Hierarchy

Funds Management (FM) Module Grants Management (GM) Module

(244)

slide-15
SLIDE 15

Unrestricted Budget to Actual by FC – GL/CI Detail

 Select “Unrestricted Budget to Actual by FC – GL/CI Detail” from the menu

slide-16
SLIDE 16

Unrestricted Budget to Actual by FC – GL/CI Detail

slide-17
SLIDE 17

FY 2018 Budget

  • Per. 01-08

FY 2018 Actuals

  • Per. 01-08

FY 2018 Commitments

  • Per. 01-08

FY 2018 Total (Actual + Commitment) FY 2018 Unexpended Budget w/ Commitments FY 2018 Unexpended Budget w/o Commitments FY 2018 % Budget Expended w/ Commitments Funds Center Revenue/Expense GL/Commitment item $ $ $ $ $ $ % 2440450000 SPH FINANCE & ADMINISTRATION Expense 500210 Prof Staff FT 750,260 475,129.76 475,129.76 275,129.76 275,129.76 (35.7) 2440450000 SPH FINANCE & ADMINISTRATION Expense 510010 SUPPLIES 1,504.00 0.00 1,504.00 (1,504.00) 1,504.00

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 510020 CONS SUPPL-CFF/WTR 154.35 154.35 (154.35) (154.35)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 510030 CONS SUPPL-OFFICE 1,308.35 438.70 1,747.05 (1,747.05) (1,308.35)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 511500 TELECOMM EQUIPMENT 0.00 0.00 0.00 0.00

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 511510 TELECOM USAGE 0.00 0.00 0.00

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 513000 REPRDCTN & PRTG 239.25 239.25 (239.25) (239.25)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 513400 NON-LIB-BKS & PRDCLS 10.93 10.93 (10.93) (10.93)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 513500 TRAVEL - DOMESTIC 3,160.96 506.2 3,667.16 (3,667.16) (3,160.96)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 513510 TRAVEL-DOMES-UNALLW 77.78 77.78 (77.78) (77.78)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 513900 CONF FEES PAID 760.00 760.00 (760.00) (760.00)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 513910 MTG EXP-STF/BUS MTGS 1,230.46 1,230.46 (1,230.46) (1,230.46)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 513920 MTG EXP-UNALLW 1,115.33 1,115.33 (1,115.33) (1,115.33)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 513940 DUES & MEMBERSHIP 628.80 628.80 (628.80) (628.80)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 516010 ADV/PR-UNALLW 234.83 234.83 (234.83) (234.83)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 516080 FLOWERS- UNALLOWABLE 58.42 58.42 (58.42) (58.42)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 516200 SOFTWARE LICENSE 0.00 0.00 0.00

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 518020 CATERING SERVICES 338.50 338.50 (338.50) (338.50)

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 519999 UNCLASSIFIED EXPENSE 15,000 15,000.00 15,000.00

  • 2440450000

SPH FINANCE & ADMINISTRATION Expense 860201 FRINGE ALLOC INTERNL 150,052 93,032.18 93,032.18 57,019.72 57,019.72 62.0 2440450000 SPH FINANCE & ADMINISTRATION Expense Result 915,311 578,984 945 579,929 335,383 339,336 0.63 Overall Result 915,311 578,984 945 579,929 335,383 339,336 0.63

Unrestricted Report Detail

slide-18
SLIDE 18

2440450000 SPH FINANCE & ADMINISTRATION Expense Result 915,311 578,984 945 579,929 335,383 Overall Result 915,311 578,984 945 579,929 335,383

Unrestricted Report Detail

 A right click in a data cell pulls up an action menu  “Goto” allows users to “drilldown” and see transaction detail for Actual or Commitment expenses

Results Row

FY 2018 Budget

  • Per. 01-08

FY 2018 Actuals

  • Per. 01-08

FY 2018 Commitments

  • Per. 01-08

FY 2018 Total (Actual + Commitment) FY 2018 Unexpended Budget w/ Commitments

slide-19
SLIDE 19

FY 2018 Budget

  • Per. 01-08

FY 2018 Actuals

  • Per. 01-08

FY 2018 Commitments

  • Per. 01-08

FY 2018 Total (Actual + Commitment) Funds Center Revenue/Expense GL/Commitment item $ $ $ $ 2440450000 SPH FINANCE & ADMINISTRATION Expense 500210 Prof Staff FT 750,260 475,129.76 475,129.76 2440450000 SPH FINANCE & ADMINISTRATION Expense 510010 SUPPLIES 1,504.00 0.00 1,504.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 510020 CONS SUPPL-CFF/WTR 154.35 154.35 2440450000 SPH FINANCE & ADMINISTRATION Expense 510030 CONS SUPPL-OFFICE 1,308.35 438.70 1,747.05 2440450000 SPH FINANCE & ADMINISTRATION Expense 511500 TELECOMM EQUIPMENT 0.00 0.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 511510 TELECOM USAGE 0.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 513000 REPRDCTN & PRTG 239.25 239.25 2440450000 SPH FINANCE & ADMINISTRATION Expense 513400 NON-LIB-BKS & PRDCLS 10.93 10.93 2440450000 SPH FINANCE & ADMINISTRATION Expense 513500 TRAVEL - DOMESTIC 3,160.96 506.2 3,667.16 2440450000 SPH FINANCE & ADMINISTRATION Expense 513510 TRAVEL-DOMES-UNALLW 77.78 77.78 2440450000 SPH FINANCE & ADMINISTRATION Expense 513900 CONF FEES PAID 760.00 760.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 513910 MTG EXP-STF/BUS MTGS 1,230.46 1,230.46 2440450000 SPH FINANCE & ADMINISTRATION Expense 513920 MTG EXP-UNALLW 1,115.33 1,115.33 2440450000 SPH FINANCE & ADMINISTRATION Expense 513940 DUES & MEMBERSHIP 628.80 628.80 2440450000 SPH FINANCE & ADMINISTRATION Expense 516010 ADV/PR-UNALLW 234.83 234.83 2440450000 SPH FINANCE & ADMINISTRATION Expense 516080 FLOWERS- UNALLOWABLE 58.42 58.42 2440450000 SPH FINANCE & ADMINISTRATION Expense 516200 SOFTWARE LICENSE 0.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 518020 CATERING SERVICES 338.50 338.50 2440450000 SPH FINANCE & ADMINISTRATION Expense 519999 UNCLASSIFIED EXPENSE 15,000 2440450000 SPH FINANCE & ADMINISTRATION Expense 860201 FRINGE ALLOC INTERNL 150,052 93,032.18 93,032.18 2440450000 SPH FINANCE & ADMINISTRATION Expense Result 915,311 578,984 945 579,929 Overall Result 915,311 578,984 945 579,929

Unrestricted Report Detail

Add and Remove Result Line

slide-20
SLIDE 20

FY 2018 Budget

  • Per. 01-08

FY 2018 Actuals

  • Per. 01-08

FY 2018 Commitments

  • Per. 01-08

FY 2018 Total (Actual + Commitment) Funds Center Revenue/Expense GL/Commitment item $ $ $ $ 2440450000 SPH FINANCE & ADMINISTRATION Expense 500210 Prof Staff FT 750,260 475,129.76 475,129.76 2440450000 SPH FINANCE & ADMINISTRATION Expense 510010 SUPPLIES 1,504.00 0.00 1,504.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 510020 CONS SUPPL-CFF/WTR 154.35 154.35 2440450000 SPH FINANCE & ADMINISTRATION Expense 510030 CONS SUPPL-OFFICE 1,308.35 438.70 1,747.05 2440450000 SPH FINANCE & ADMINISTRATION Expense 511500 TELECOMM EQUIPMENT 0.00 0.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 511510 TELECOM USAGE 0.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 513000 REPRDCTN & PRTG 239.25 239.25 2440450000 SPH FINANCE & ADMINISTRATION Expense 513400 NON-LIB-BKS & PRDCLS 10.93 10.93 2440450000 SPH FINANCE & ADMINISTRATION Expense 513500 TRAVEL - DOMESTIC 3,160.96 506.2 3,667.16 2440450000 SPH FINANCE & ADMINISTRATION Expense 513510 TRAVEL-DOMES-UNALLW 77.78 77.78 2440450000 SPH FINANCE & ADMINISTRATION Expense 513900 CONF FEES PAID 760.00 760.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 513910 MTG EXP-STF/BUS MTGS 1,230.46 1,230.46 2440450000 SPH FINANCE & ADMINISTRATION Expense 513920 MTG EXP-UNALLW 1,115.33 1,115.33 2440450000 SPH FINANCE & ADMINISTRATION Expense 513940 DUES & MEMBERSHIP 628.80 628.80 2440450000 SPH FINANCE & ADMINISTRATION Expense 516010 ADV/PR-UNALLW 234.83 234.83 2440450000 SPH FINANCE & ADMINISTRATION Expense 516080 FLOWERS- UNALLOWABLE 58.42 58.42 2440450000 SPH FINANCE & ADMINISTRATION Expense 516200 SOFTWARE LICENSE 0.00 2440450000 SPH FINANCE & ADMINISTRATION Expense 518020 CATERING SERVICES 338.50 338.50 2440450000 SPH FINANCE & ADMINISTRATION Expense 519999 UNCLASSIFIED EXPENSE 15,000 2440450000 SPH FINANCE & ADMINISTRATION Expense 860201 FRINGE ALLOC INTERNL 150,052 93,032.18 93,032.18

Unrestricted Report Detail

Add and Remove Result Line

slide-21
SLIDE 21

Unrestricted Report Detail

Add Result Line  Right click Funds Center in left hand column  Click Properties  Click Characteristics  Choose your preference for the “Display Results” option

slide-22
SLIDE 22

Unrestricted Report Detail

Free Characteristics  Drag and drop the characteristic into the “Rows” area  Place cursor over a Free Characteristic

slide-23
SLIDE 23

Unrestricted Report Detail

Free Characteristics  To remove a Free Characteristic, drag the characteristic out of the “Rows” area or select and drag the column out of the dataset

slide-24
SLIDE 24

Account Hierarchy

Funds Management (FM) Module Grants Management (GM) Module

(244)

slide-25
SLIDE 25

Designated/Restricted Balance & Activity – GL/CI Detail

Tip  Designated/Restricted account activity does not get captured in Unrestricted Account reports and vice versa

slide-26
SLIDE 26

Designated/Restricted Report Detail

FY 2018 Beginning Balance FY 2018 Revenue

  • Per. 01-08

FY 2018 Expenses

  • Per. 01-08

FY 2018 Ending Balance as of Per. 08 FY 2018 Commitments

  • Per. 01-08

FY 2018 Net w/ Commitments as of Per. 08 % Balance Expended (Exp+Comm) / (Bal+Rev) Funds Center Funded Program Type Funded Program GL/Commitment item $ $ $ $ $ $ % 2440450000 SPH FINANCE & ADMINISTRATION Designated General Funds 9090358713 SPH Fin Discretionary 399001 FM FUND BALANCE (2,019.10) 2440450000 SPH FINANCE & ADMINISTRATION Designated General Funds 9090358713 SPH Fin Discretionary 399001 FM FUND BALANCE (5,868.92) 2440450000 SPH FINANCE & ADMINISTRATION Designated General Funds 9090358713 SPH Fin Discretionary 510030 CONS SUPPL-OFFICE 50.00 2440450000 SPH FINANCE & ADMINISTRATION Designated General Funds 9090358713 SPH Fin Discretionary 513500 TRAVEL - DOMESTIC 2,310.94 2440450000 SPH FINANCE & ADMINISTRATION Designated General Funds 9090028712 SPH Rsrch/Ed 399001 FM FUND BALANCE (367.53) 2440450000 SPH FINANCE & ADMINISTRATION Designated General Funds 9090028712 SPH Rsrch/Ed 479999 TRANSFER IN - OPERAT (2,000.00) 2440450000 SPH FINANCE & ADMINISTRATION Designated General Funds 9090038714 Ieraci Rsrch/Educ 513940 DUES & MEMBERSHIP (1,059.27) 5836.66 2440450000 SPH FINANCE & ADMINISTRATION Endowment Spendable 9250002130 Veronica Byam 399001 FM FUND BALANCE (594.60) 2440450000 SPH FINANCE & ADMINISTRATION Endowment Spendable 9250002230 Joshua Buckno 431100 ENDOW INC DISTR-SP (174.57) 2440450000 SPH FINANCE & ADMINISTRATION Gift 9300012346 Melanie Gilreath FUND 500450 NWS GRAD HOURLY 4,352.30 Overall Result (9,909.42) (2,174.57) 12,549.90 465.01 0.00 465.01 103.9

slide-27
SLIDE 27

Designated/Restricted Report Detail

Amount Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR Number Vendor Vendor Invoice PO Number SC Number Doc Control No $ 2440450000 SPH FINANCE & ADMINISTRATION 9090358713 513500 TRAVEL - DOMESTIC 07/06/2017 Italia Ieraci/ Hyatt Concur Invoice 2100052766 # HYATT 0000000000117960

  • 327.67

2440450000 SPH FINANCE & ADMINISTRATION 9090358713 513500 TRAVEL - DOMESTIC 07/12/2017 SPH GUEST/Melanie Gilreath Concur Invoice 2100053250 # Reimburse Vendor 0000000000118490

  • 20170712

586.47 2440450000 SPH FINANCE & ADMINISTRATION 9090358713 513500 TRAVEL - DOMESTIC 07/27/2017 SPH GUEST/Josh Buckno Concur Invoice 2100054821 # Reimburse Vendor 0000000000120772

  • 20170727

498.40 2440450000 SPH FINANCE & ADMINISTRATION 9090358713 513500 TRAVEL - DOMESTIC 07/27/2017 SPH GUEST/Veronica Byam Concur Invoice 2100054821 # Reimburse Vendor 0000000000120772

  • 20170727

898.40 Overall Result 2,310.94

Transaction Detail of GL Code 513500 – Travel - Domestic

slide-28
SLIDE 28

Account Hierarchy

Funds Management (FM) Module Grants Management (GM) Module

(244)

slide-29
SLIDE 29

Transaction Detail

 Tip Click the Check button to validate the date range and Fund Center before selecting OK

slide-30
SLIDE 30

Transaction Detail Report

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR Number Vendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087426 #

  • 20,574.47

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087428 #

  • 12,647.21

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087429 #

  • 18,269.31

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087430 #

  • 15,823.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089571 #

  • 21,872.64

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089573 #

  • 13,752.90

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089574 #

  • 18,326.87

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089575 #

  • 15,543.68

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 09/30/2017 M1-09-2017-20170929Payroll Posting 2200125471 #

  • 18,517.24

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 07/13/2017 AMAZON

  • P. Card

1003257423 # AMAZON MAR

  • 432.04

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 08/21/2017 STAPLES

  • P. Card

1003542912 # STAPLES

  • 193.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/12/2017 AMAZON

  • P. Card

1003678291 # AMAZON MAR

  • 523.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/21/2017 OFFICE DEPOT

  • P. Card

1003860317 # OFFICE DEPOT

  • 355.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 11/15/2017 VBYAM 11/12/17 10:09 Invoice - Gross 5110584125 # WB Mason Company I50237839 8500354784 1000752147 XML Invoice 57.45 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 12/21/2017 IIERACI 12/19/17 11:02 Invoice - Gross 5110585312 # WB Mason Company I50346838 8500362712 1000752147 XML Invoice 21.35 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONS SUPPL -OFFICE 9/25/2017 Copier Invoice - Gross 1004598755 # Ricoh USA, Inc. 5049711841 8500421468 1000687412 XML Invoice 197.24 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONS SUPPL -OFFICE 10/01/2017 AMAZON

  • P. Card
1004068767 # AMAZON MKT
  • 0000268670000
241.46
slide-31
SLIDE 31

Transaction Detail Report

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR Number Vendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087426 #

  • 20,574.47

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087428 #

  • 12,647.21

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087429 #

  • 18,269.31

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087430 #

  • 15,823.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089571 #

  • 21,872.64

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089573 #

  • 13,752.90

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089574 #

  • 18,326.87

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089575 #

  • 15,543.68

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 09/30/2017 M1-09-2017-20170929Payroll Posting 2200125471 #

  • 18,517.24

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 07/13/2017 AMAZON

  • P. Card

1003257423 # AMAZON MAR

  • 432.04

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 08/21/2017 STAPLES

  • P. Card

1003542912 # STAPLES

  • 193.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/12/2017 AMAZON

  • P. Card

1003678291 # AMAZON MAR

  • 523.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/21/2017 OFFICE DEPOT

  • P. Card

1003860317 # OFFICE DEPOT

  • 355.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 11/15/2017 VBYAM 11/12/17 10:09 Invoice - Gross 5110584125 # WB Mason Company I50237839 8500354784 1000752147 XML Invoice 57.45 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 12/21/2017 IIERACI 12/19/17 11:02 Invoice - Gross 5110585312 # WB Mason Company I50346838 8500362712 1000752147 XML Invoice 21.35 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONS SUPPL -OFFICE 9/25/2017 Copier Invoice - Gross 1004598755 # Ricoh USA, Inc. 5049711841 8500421468 1000687412 XML Invoice 197.24

Change Funded Program Properties of Characteristic

slide-32
SLIDE 32

Transaction Detail Report

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR Number Vendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087426 #

  • 20,574.47

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087428 #

  • 12,647.21

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087429 #

  • 18,269.31

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087430 #

  • 15,823.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089571 #

  • 21,872.64

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089573 #

  • 13,752.90

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089574 #

  • 18,326.87

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089575 #

  • 15,543.68

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 09/30/2017 M1-09-2017-20170929Payroll Posting 2200125471 #

  • 18,517.24

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 07/13/2017 AMAZON

  • P. Card

1003257423 # AMAZON MAR

  • 432.04

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 08/21/2017 STAPLES

  • P. Card

1003542912 # STAPLES

  • 193.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/12/2017 AMAZON

  • P. Card

1003678291 # AMAZON MAR

  • 523.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/21/2017 OFFICE DEPOT

  • P. Card

1003860317 # OFFICE DEPOT

  • 355.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 11/15/2017 VBYAM 11/12/17 10:09 Invoice - Gross 5110584125 # WB Mason Company I50237839 8500354784 1000752147 XML Invoice 57.45 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 12/21/2017 IIERACI 12/19/17 11:02 Invoice - Gross 5110585312 # WB Mason Company I50346838 8500362712 1000752147 XML Invoice 21.35 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONS SUPPL -OFFICE 9/25/2017 Copier Invoice - Gross 1004598755 # Ricoh USA, Inc. 5049711841 8500421468 1000687412 XML Invoice 197.24

Change Funded Program Properties of Characteristic

slide-33
SLIDE 33

Transaction Detail Report

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR Number Vendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087426 #

  • 20,574.47

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087428 #

  • 12,647.21

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087429 #

  • 18,269.31

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087430 #

  • 15,823.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089571 #

  • 21,872.64

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089573 #

  • 13,752.90

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089574 #

  • 18,326.87

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089575 #

  • 15,543.68

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 09/30/2017 M1-09-2017-20170929Payroll Posting 2200125471 #

  • 18,517.24

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 07/13/2017 AMAZON

  • P. Card

1003257423 # AMAZON MAR

  • 432.04

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 08/21/2017 STAPLES

  • P. Card

1003542912 # STAPLES

  • 193.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/12/2017 AMAZON

  • P. Card

1003678291 # AMAZON MAR

  • 523.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/21/2017 OFFICE DEPOT

  • P. Card

1003860317 # OFFICE DEPOT

  • 355.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 11/15/2017 VBYAM 11/12/17 10:09 Invoice - Gross 5110584125 # WB Mason Company I50237839 8500354784 1000752147 XML Invoice 57.45 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 12/21/2017 IIERACI 12/19/17 11:02 Invoice - Gross 5110585312 # WB Mason Company I50346838 8500362712 1000752147 XML Invoice 21.35 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONS SUPPL -OFFICE 9/25/2017 Copier Invoice - Gross 1004598755 # Ricoh USA, Inc. 5049711841 8500421468 1000687412 XML Invoice 197.24

Change Funded Program Properties of Characteristic

slide-34
SLIDE 34

Transaction Detail Report

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR Number Vendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087426 #

  • 20,574.47

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087428 #

  • 12,647.21

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087429 #

  • 18,269.31

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087430 #

  • 15,823.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089571 #

  • 21,872.64

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089573 #

  • 13,752.90

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089574 #

  • 18,326.87

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089575 #

  • 15,543.68

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 09/30/2017 M1-09-2017-20170929Payroll Posting 2200125471 #

  • 18,517.24

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 07/13/2017 AMAZON

  • P. Card

1003257423 # AMAZON MAR

  • 432.04

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 08/21/2017 STAPLES

  • P. Card

1003542912 # STAPLES

  • 193.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/12/2017 AMAZON

  • P. Card

1003678291 # AMAZON MAR

  • 523.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/21/2017 OFFICE DEPOT

  • P. Card

1003860317 # OFFICE DEPOT

  • 355.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 11/15/2017 VBYAM 11/12/17 10:09 Invoice - Gross 5110584125 # WB Mason Company I50237839 8500354784 1000752147 XML Invoice 57.45 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 12/21/2017 IIERACI 12/19/17 11:02 Invoice - Gross 5110585312 # WB Mason Company I50346838 8500362712 1000752147 XML Invoice 21.35 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONS SUPPL -OFFICE 9/25/2017 Copier Invoice - Gross 1004598755 # Ricoh USA, Inc. 5049711841 8500421468 1000687412 XML Invoice 197.24

Change GL/Commitment item Properties of Characteristic

slide-35
SLIDE 35

Transaction Detail Report

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR Number Vendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087426 #

  • 20,574.47

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087428 #

  • 12,647.21

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087429 #

  • 18,269.31

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087430 #

  • 15,823.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089571 #

  • 21,872.64

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089573 #

  • 13,752.90

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089574 #

  • 18,326.87

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089575 #

  • 15,543.68

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 09/30/2017 M1-09-2017-20170929Payroll Posting 2200125471 #

  • 18,517.24

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 07/13/2017 AMAZON

  • P. Card

1003257423 # AMAZON MAR

  • 432.04

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 08/21/2017 STAPLES

  • P. Card

1003542912 # STAPLES

  • 193.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/12/2017 AMAZON

  • P. Card

1003678291 # AMAZON MAR

  • 523.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/21/2017 OFFICE DEPOT

  • P. Card

1003860317 # OFFICE DEPOT

  • 355.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 11/15/2017 VBYAM 11/12/17 10:09 Invoice - Gross 5110584125 # WB Mason Company I50237839 8500354784 1000752147 XML Invoice 57.45 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 12/21/2017 IIERACI 12/19/17 11:02 Invoice - Gross 5110585312 # WB Mason Company I50346838 8500362712 1000752147 XML Invoice 21.35 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONS SUPPL -OFFICE 9/25/2017 Copier Invoice - Gross 1004598755 # Ricoh USA, Inc. 5049711841 8500421468 1000687412 XML Invoice 197.24

Change GL/Commitment item Properties of Characteristic

slide-36
SLIDE 36

Transaction Detail Report

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR Number Vendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087426 #

  • 20,574.47

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087428 #

  • 12,647.21

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087429 #

  • 18,269.31

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 07/31/2017 M1-07-2017-20170731Payroll Posting 2200087430 #

  • 15,823.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089571 #

  • 21,872.64

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089573 #

  • 13,752.90

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089574 #

  • 18,326.87

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 08/31/2017 M1-08-2017-20170831Payroll Posting 2200089575 #

  • 15,543.68

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Prof Staff FT 09/30/2017 M1-09-2017-20170929Payroll Posting 2200125471 #

  • 18,517.24

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 07/13/2017 AMAZON

  • P. Card

1003257423 # AMAZON MAR

  • 432.04

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 08/21/2017 STAPLES

  • P. Card

1003542912 # STAPLES

  • 193.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/12/2017 AMAZON

  • P. Card

1003678291 # AMAZON MAR

  • 523.40

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 09/21/2017 OFFICE DEPOT

  • P. Card

1003860317 # OFFICE DEPOT

  • 355.28

2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 11/15/2017 VBYAM 11/12/17 10:09 Invoice - Gross 5110584125 # WB Mason Company I50237839 8500354784 1000752147 XML Invoice 57.45 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONS SUPPL-CFF/WTR 12/21/2017 IIERACI 12/19/17 11:02 Invoice - Gross 5110585312 # WB Mason Company I50346838 8500362712 1000752147 XML Invoice 21.35 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONS SUPPL -OFFICE 9/25/2017 Copier Invoice - Gross 1004598755 # Ricoh USA, Inc. 5049711841 8500421468 1000687412 XML Invoice 197.24

Change GL/Commitment item Properties of Characteristic

slide-37
SLIDE 37

Transaction Detail Report

Updated view

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR NumberVendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 7/31/2017 M1-07-2017-20170731 Payroll Posting 2200087426 #
  • 20,574.47
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 7/31/2017 M1-07-2017-20170731 Payroll Posting 2200087428 #
  • 12,647.21
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 7/31/2017 M1-07-2017-20170731 Payroll Posting 2200087429 #
  • 18,269.31
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 7/31/2017 M1-07-2017-20170731 Payroll Posting 2200087430 #
  • 15,823.40
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 8/31/2017 M1-08-2017-20170831 Payroll Posting 2200089571 #
  • 21,872.64
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 8/31/2017 M1-08-2017-20170831 Payroll Posting 2200089573 #
  • 13,752.90
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 8/31/2017 M1-08-2017-20170831 Payroll Posting 2200089574 #
  • 18,326.87
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 8/31/2017 M1-08-2017-20170831 Payroll Posting 2200089575 #
  • 15,543.68
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 9/30/2017 M1-09-2017-20170929 Payroll Posting 2200125471 #
  • 18,517.24
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 7/13/2017 AMAZON
  • P. Card
1003257423 # AMAZON MAR
  • 432.04
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 8/21/2017 STAPLES
  • P. Card
1003542912 # STAPLES
  • 193.28
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 9/12/2017 AMAZON
  • P. Card
1003678291 # AMAZON MAR
  • 523.4
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 9/21/2017 OFFICE DEPOT
  • P. Card
1003860317 # OFFICE DEPOT
  • 355.28
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONSUMABLE SUPPLIES - COFFEE/WATER SERVI 11/15/2017 VBYAM 11/12/17 10:09 Invoice - Gross 5110584125 # WB Mason CompanyI50237839 8500354784 1000752147 XML Invoice 57.45 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONSUMABLE SUPPLIES - COFFEE/WATER SERVI 12/21/2017 IIERACI 12/19/17 11:02 Invoice - Gross 5110585312 # WB Mason CompanyI50346838 8500362712 1000752147 XML Invoice 21.35 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONSUMABLE SUPPLIES - OFFICE 9/25/2017 Copier Invoice - Gross 1004598755 # Ricoh USA, Inc. 5049711841 8500421468 1000687412 XML Invoice 197.24
slide-38
SLIDE 38

Save View

Tip  Make sure that the name is identical in the Description and Technical name fields.  The report name should be original, identifiable, and concise  Suggested format is: School – Dept. – What the report is showing

slide-39
SLIDE 39

Transaction Detail Report

Export to Excel

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR NumberVendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 7/31/2017 M1-07-2017-20170731 Payroll Posting 2200087426 #
  • 20,574.47
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 7/31/2017 M1-07-2017-20170731 Payroll Posting 2200087428 #
  • 12,647.21
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 7/31/2017 M1-07-2017-20170731 Payroll Posting 2200087429 #
  • 18,269.31
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 7/31/2017 M1-07-2017-20170731 Payroll Posting 2200087430 #
  • 15,823.40
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 8/31/2017 M1-08-2017-20170831 Payroll Posting 2200089571 #
  • 21,872.64
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 8/31/2017 M1-08-2017-20170831 Payroll Posting 2200089573 #
  • 13,752.90
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 8/31/2017 M1-08-2017-20170831 Payroll Posting 2200089574 #
  • 18,326.87
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 8/31/2017 M1-08-2017-20170831 Payroll Posting 2200089575 #
  • 15,543.68
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 9/30/2017 M1-09-2017-20170929 Payroll Posting 2200125471 #
  • 18,517.24
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 7/13/2017 AMAZON
  • P. Card
1003257423 # AMAZON MAR
  • 432.04
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 8/21/2017 STAPLES
  • P. Card
1003542912 # STAPLES
  • 193.28
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 9/12/2017 AMAZON
  • P. Card
1003678291 # AMAZON MAR
  • 523.4
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510010 SUPPLIES 9/21/2017 OFFICE DEPOT
  • P. Card
1003860317 # OFFICE DEPOT
  • 355.28
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONSUMABLE SUPPLIES - COFFEE/WATER SERVI 11/15/2017 VBYAM 11/12/17 10:09 Invoice - Gross 5110584125 # WB Mason CompanyI50237839 85003547841000752147 XML Invoice 57.45 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510020 CONSUMABLE SUPPLIES - COFFEE/WATER SERVI 12/21/2017 IIERACI 12/19/17 11:02 Invoice - Gross 5110585312 # WB Mason CompanyI50346838 85003627121000752147 XML Invoice 21.35 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 510030 CONSUMABLE SUPPLIES - OFFICE 9/25/2017 Copier Invoice - Gross 1004598755 # Ricoh USA, Inc. 5049711841 8500421468 1000687412 XML Invoice 197.24
slide-40
SLIDE 40

Transaction Detail Report

1. Select the entire spreadsheet 2. Unclick “Wrap Text” and “Merge & Center”

Formatting in Excel

slide-41
SLIDE 41

1. Select header row in spreadsheet 2. Select the “Sort & Filter” icon in the Home ribbon 3. Choose Filter

Transaction Detail Report

Add Filter in Excel

slide-42
SLIDE 42

Transaction Detail Report

Filter in Excel

Each column now has a Filter for sorting data

slide-43
SLIDE 43

Transaction Detail Report

Filter in Excel

 Click the Filter symbol  A pop up window shows options for sorting and filtering data  Clear the check box from “Select All”  Select the check box for “510010” to display all GL items for Supplies

slide-44
SLIDE 44

Transaction Detail Report

Filter in Excel

 More than one filter can be used at time  Navigate to “Document type” and select P.Card  The dataset displays all transactions on the P.Card coded to GL 510010 Supplies

slide-45
SLIDE 45

Transaction Detail Report

Filter in Excel

 The dataset displays all transactions on the P.Card coded to GL 510010 Supplies

Funds Center Funded Program GL/Commitment item Posting date Text Document type FI doc.number FSR/ISR Number Vendor Vendor Invoice PO Number SC Number Doc Control No Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR FUNDED_PROGRAM_NR 510010 SUPPLIES 07/13/2017 AMAZON
  • P. Card
1003257423 # AMAZON MAR
  • 432.04
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR FUNDED_PROGRAM_NR 510010 SUPPLIES 08/21/2017 STAPLES
  • P. Card
1003542912 # STAPLES
  • 193.28
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR FUNDED_PROGRAM_NR 510010 SUPPLIES 09/12/2017 AMAZON
  • P. Card
1003678291 # AMAZON MAR
  • 523.40
2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR FUNDED_PROGRAM_NR 510010 SUPPLIES 09/21/2017 OFFICE DEPOT P. Card 1003860317 # OFFICE DEPOT -
  • 355.28
slide-46
SLIDE 46

Excel – Pivot Tables

Flexible display Dynamic analysis Quickly updated Clean presentations

slide-47
SLIDE 47

Fill in Blank Header Cells

Actuals Commitments Funds Center Funded Program GL/Commitment item Posting date $ $ 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR500210 Professional Full Time 7/31/2017 20,574.47

Excel – Pivot Tables

Clean Dataset

Actuals Commitments Funds Center Fund Center Name Funded Program GL/Commitment item GL/Commitment Name Posting date Actuals Commitments 2440450000 SPH FINANCE & ADMINISTRATION FUNDED_PROGRAM_NR 500210 Professional Full Time 7/31/2017 20,574.47

slide-48
SLIDE 48

Excel – Pivot Tables

Pivot Table Template

 Open Reconciliation template Excel sheet (provided)  Select the data from downloaded dataset and only highlight the columns with detail in them (in this case columns A-R)  Press “Ctrl + C” buttons together to copy the data

slide-49
SLIDE 49

Excel – Pivot Tables

Pivot Table Template

 Place your cursor in cell B1 in the reconciliation file  Press “Ctrl +V” buttons together to paste the data  The GL Category column will populate automatically with descriptions

slide-50
SLIDE 50

Excel – Pivot Tables

Create Pivot Table Dataset

 Click “OK”  Place the cursor in a cell in the data table  Select “PivotTable”  Choose “Insert” from the ribbon

slide-51
SLIDE 51

Excel – Pivot Tables

Add Row Data

Select data by placing a check mark next to the following fields in order Tip  If a field populates the “∑ Values” box, drag the field name into the “Rows” box  Funds Center  Funds Center Name  GL Group  GL Commitment item  GL/Commitment item Name

slide-52
SLIDE 52

Excel – Pivot Tables

Add Row Data

slide-53
SLIDE 53

Excel – Pivot Tables

Add Value Data

 Locate the “Actuals” and “Commitments” fields using the scroll bar

slide-54
SLIDE 54

Excel – Pivot Tables

Add Value Data

 Highlight the “Actuals” field with your cursor  Drag into the ∑ Values box  Repeat the step for the “Commitments” field

slide-55
SLIDE 55

Excel – Pivot Tables

Change Value Field Settings

 Columns for “Actuals” and “Commitments” appear in the Pivot Table  The value displayed is the Count  We will change the displayed values to Sums

slide-56
SLIDE 56

Excel – Pivot Tables

1) Click on “Count of Actuals” 2) Select Value Field Settings 3) Select “Sum” and click “OK”

Change Value Field Setting

slide-57
SLIDE 57

Excel – Pivot Tables

Change Value Field Setting

 The “Actuals” and “Commitments” column headers and data set automatically update to reflect the dollar amount for each group

slide-58
SLIDE 58

Excel – Pivot Tables

Formatting

 Choose any cell within the Pivot Table  “Pivot Table Tools” will appear in the upper ribbon  Choose “Design”

slide-59
SLIDE 59

Excel – Pivot Tables

Formatting

 Choose “Subtotals”  “Show All Subtotals at Bottom of the Group”  Choose “Report Layout”  “Show in Tabular Form”

slide-60
SLIDE 60

Excel – Pivot Tables

Formatting

 Select the drop down button on the PivotTable Styles menu

slide-61
SLIDE 61

Excel – Pivot Tables

Formatting

 Choose a style from the menu  Excel automatically updates the PivotTable when the cursor is above a style

slide-62
SLIDE 62

Excel – Pivot Tables

Formatting

 Select all the cells by clicking the green triangle in the upper left corner  Place the cursor between columns A and B and double click  Column widths will automatically resize to fit contents

slide-63
SLIDE 63

Excel – Pivot Tables

Formatting

slide-64
SLIDE 64

Excel – Pivot Tables

 When you drag the posting date, years, quarters and posting date will be added.  You can click and drag out the items you do not want. For example drag

  • ut years and posting date and keep

quarters

Posting Period

slide-65
SLIDE 65

Excel – Pivot Tables

Posting Period & Drill Down

slide-66
SLIDE 66

Excel – Pivot Tables

Drill Down

slide-67
SLIDE 67

Excel – Pivot Tables

Adding Funded Programs

slide-68
SLIDE 68

Excel – Pivot Tables

Adding Funded Programs

slide-69
SLIDE 69

Excel – Pivot Tables

 Open Reconciliation template Excel sheet

Reconciliation Template using Unrestricted Budget to Actual

 Go to the Reconciliation template and press “Ctrl + V” in cell B1  Download the Unrestricted Budget to Actual Detail (pages 15-23) and clean the data set  unwrap  unmerge & uncenter  Add headers to all columns with no data in the cells  Select the data from downloaded dataset and only highlight the columns with detail in them (A-O in this case)  Press “Ctrl + C” buttons together to copy the data

*for a visual, please see pages 47-63

slide-70
SLIDE 70

Excel – Pivot Tables

Reconciliation Template using Unrestricted Budget to Actual

slide-71
SLIDE 71

Excel – Pivot Tables

slide-72
SLIDE 72

Journal Entry

 Access WebGUI in BU Works Tab  Click ECC System  Type FB03 in the text box  Click FB03 if it is in the Favorites list

Display Journal Entry

slide-73
SLIDE 73

Journal Entry

 Type the FI Doc Number and hit Enter. (for practice let’s type in 1000013554)

Display Journal Entry

slide-74
SLIDE 74

Journal Entry

Attachments

slide-75
SLIDE 75

Journal Entry

Attachments

slide-76
SLIDE 76

Journal Entry

Attachments

 Select “New”  Select “Create Attachment

slide-77
SLIDE 77

Journal Entry

Create an Attachment

 Navigate to supporting documentation in the browser  Click Open  The file will appear in the attachment list  Click the green check mark to upload the file

slide-78
SLIDE 78

Journal Entry

View Workflow

 Click the Menu button in the upper right corner  Click Workflow -> Workflow Overview

slide-79
SLIDE 79

Resources

SPH Finance and Administration

Veronica Byam Assistant Director of Finance vbyam@bu.edu 617.358.3223 Italia Ieraci Senior Financial Analyst iieraci@bu.edu 617.358.0912 Josh Buckno Senior Financial Analyst jbuckno@bu.edu 617.358.2327

bu.edu/tech/support/buworks

BU Tech