Exhibit-C-Reports-Inventory.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
RFP Enterprise Resource Planning Suite and System integrator Services
Solicitation number
RFP 26-00268-AHAC
Issued by
Philadelphia County, Philadelphia City, Pennsylvania

About this file

This is a reports inventory file for SEPTA's (Southeastern Pennsylvania Transportation Authority) Enterprise Resource Planning (ERP) Software and Implementation Services procurement in Pennsylvania. The file catalogs 258 existing reports across four functional areas that need to be replicated or replaced in the new ERP system: Finance (88 reports, FSM-01 through FSM-88), Procurement & Supply Chain Management (12 reports, PSCM-01 through PSCM-12), Projects & Grants Management (83 reports, PGM-01 through PGM-83), and Human Capital Management (85 reports, HCM-01 through HCM-85). The reports cover comprehensive operational requirements including pension interfaces, accounts payable and receivable, payroll processing, asset management, project cost reporting, inventory management, purchasing analysis, budget tracking, employee data interfaces, benefits administration, and regulatory compliance reporting.

The inventory demonstrates the complexity of SEPTA's current reporting environment, with numerous custom reports supporting financial management, federal grant expenditure tracking (Single Audit), cash management, tax reporting (including 1099s), state and local cost reporting for various funding jurisdictions (federal, state, county, and city), union dues processing, pension contributions, employee benefits billing, and vehicle/equipment inventory management. Many reports interface with external systems including pension systems, building access systems, drug testing management, vehicle maintenance information systems (VMIS), and various insurance carriers. The detailed categorization suggests SEPTA requires the new ERP system integrator to either migrate these existing reports, develop equivalent functionality, or provide standard ERP reports that meet the same business requirements across all functional areas.

View the file

Other files

Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Finance SEPTA ERP Software and Implementation Services

Reports Inventory
#Summary
FSM-01ANA-035 Interface Pension - GL
FSM-02ANA-034 Interface Pension - GL
FSM-03ANA-033 Interface Pension GL
FSM-04ANA-032 Interface Pension - GL
FSM-05GA - Build Custom Obsolescence / Inventory Report
FSM-06AR - Custom Aging Report to include Division and Receivables Codes
FSM-07AR - Customer List
FSM-08AP - Stale Dating And Escheatment Report
FSM-09FA - 3-Way Reconciliation
FSM-10AR - Recurring Rent
FSM-11AR - View Customer Recurring Charges (Single Month)
FSM-12AR - View Customer Recurring Charges (All Months)
FSM-13GA - Reporting / Escheatment
FSM-14AR & GA - Annual List of Federal Grant expenditures (Single Audit)
FSM-15GA - Financial Statement / Footnotes
FSM-16GA - 703 Expense by Function
FSM-17GA - 702 Expense by Mode
FSM-18FA - Custom Report for Retirement - View Assets by Funding Source YTD
FSM-19View AR Subledger Report
FSM-20M&S Feeder Report -- P77AW005-2 Issues From Storeroom
FSM-21M&S Feeder Report -- P77AW005-1 M&S Project Detail
FSM-22Reports needed for indirect cost calculation
FSM-23AP Feeder – P38AW002-3 SUMMARY J/E GLIR0410
FSM-24AP Feeder – P38AW002-4 Batch Proof List
FSM-25AP Feeder – P38AW002-1 AP Project Detail
FSM-26AP - 1099 Tax Reporting
FSM-27AP - Liability Account Analysis
FSM-28AP - Outstanding Liability
FSM-29Weekly Tax Summary Report for Cash Management
FSM-30Personalized Payroll Error Report
FSM-31FA - View Asset Retirement Detail
FSM-32Payroll - Prepaid Vacation report
FSM-33Payroll - Headcount TM600 for Pension, OPEB
FSM-34Time Keeping - Headcount and Work Hours by Function
FSM-35Payroll - P04TM069 - Employee Pension Contributions
FSM-36Payroll - P04RQ600 (quarterly) - RUI creditable amount
FSM-37Payroll - P04RM600 (monthly) - RUI creditable amount
FSM-38Payroll - P04BW701 - Payroll summary (monthly amts.)
FSM-39Payroll - P04BW701 - Check refunds
FSM-40Payroll - P04BW701 - ACH Doe (ACH credits)
FSM-41Payroll - P04BW430 - Voided direct deposits
FSM-42Payroll - P04BW430 - Voided check list
FSM-43Payroll - P04BW430 - DAC report (Summary of month's activity)
FSM-44Payroll - P04BW430 - 8B voids (checks cancelled for month)
FSM-45Payroll - P04BW430 - ARP Payroll
FSM-46Payroll - P04BW420 - Check Restart
FSM-47Payroll - P04BW420 - Prepays
FSM-48Payroll - P04BW420 - Check Reversals
FSM-49Payroll - P04BW420 - All DOE codes
FSM-50Claims - related reports (All)
FSM-51PO/VEMIS - SMART Fuel Report
FSM-52Cash Flow by Source/Event Code
FSM-53GA - Payroll Report by function by Cost Center
FSM-54FA - View GL contributed capital Accounts
FSM-55FA - View GL Amortization Accounts
FSM-56AR - Cash Inputs Report
FSM-57AR Monthly Report
FSM-58AR - Purchase Order Report
FSM-59FA - View Capital Asset Footnote Report
FSM-60Fringe Rate Calculation Report
FSM-61PR Feeder Reports -- Part 1 Project Detail
FSM-62ANA-090 Budget Headcount Report
FSM-63Completed Details Report
FSM-64GA - Passengers Monthly Report
FSM-65GA - Miles Monthly Report
FSM-66GA - View and Send Stale Dating And Escheatment Report
FSM-67GA - View Interface Data
FSM-68GA - General Cash Account Balances
FSM-69CM - Current Day Cash Report
FSM-70CM - Reconcile GL Entries
FSM-71CM - Account Analysis
FSM-72CM - View AP Check Register
FSM-73AR Code Report
FSM-74GA - GAAP Income Statements
FSM-75GA - Monthly Balance Sheet (Internal Package)
FSM-76GA - Single Audit Reporting
FSM-77AP / CM - Cash Payment Register
FSM-78Check Register Report
FSM-79AP Invoices Report
FSM-80AR - Aging Report
FSM-81Revenue Accounting Feeder Report Data Fields
FSM-82GA - Inventory
FSM-83GA - Monthly Income Statement
FSM-84GA - Quarterly Balance Sheet (GAAP Statements)
FSM-85GA - Trial Balance
FSM-86Custom Report Identification
FSM-87MTD DETAIL RECON Report
FSM-88RA - Trial Balance Reporting

Procurement & Supply Chain SEPTA ERP Software and Implementation Services

Reports Inventory
#Summary
PSCM-01Requisition Report
PSCM-02Sourcing Event Analysis Report
PSCM-03Bid Details Report
PSCM-04Inventory Manager Dashboard
PSCM-05Inventory By Fleet
PSCM-06PO Report
PSCM-07Buyer Performance Report
PSCM-08Sealed Bid Report
PSCM-09DBE Awards
PSCM-10Purchasing Analysis
PSCM-11Spend Analysis report/dashboard
PSCM-12Open Requisitions Report

Projects & Grants Mgmt SEPTA ERP Software and Implementation Services

Reports Inventory
#Summary
PGM-01FA - Build Custom Reporting for Amortization
PGM-02Operating Consolidated Details Report
PGM-03FA - Reporting (All Asset Summary Expense Report)
PGM-04ANA-095 Budget Headcount Report
PGM-05ANA-093 Budget Headcount CHET Report
PGM-06ANA-092 Budget Headcount Report
PGM-07ANA-091 Budget Headcount Report
PGM-08Project Control ProjCtrl_Rpt_006 Company 4000 Procurement Report Request
PGM-09FA - Generate Vehicle/Equipment Inventory
PGM-10Project Cost Report P10PM008-1 Main PCR Report
PGM-11Project Detail P04RW074-1 P04TW050-1 PR Feeder
PGM-12Project Billing Status Report - P10PM001-3 Company 6000
PGM-13County Cost Report P10LW201-5 County Contributed Capital Summary Report
PGM-14Payroll Weekly Report P03LW027 Fed Letter of Credit portion
PGM-15View Funding Source Rates by Project and Fund
PGM-16County Cost Report P10LW201-3 Contrib Cap SEPTA, RRCTD, RRSTD AR_PGA_017
PGM-17State Cost Report P10SW201-6 Not on P10
PGM-18View Posting Project Detail Report
PGM-19Local Match Breakdown Report
PGM-20Capital Budget and Expenses Reporting
PGM-21View Existing Projects & Funding Reports
PGM-22View GL Accounts Report
PGM-23Operating Funding Sources Report
PGM-24Pass Through Funds Report
PGM-25Operating Subsidy Consolidated Statements Report
PGM-26Subsidies Account Analysis Report
PGM-27Purchase Order Report
PGM-28Local Cost Detail Report
PGM-29Fringe Adjustment Report
PGM-30State Cost Report P10SW201-8 State Exceptions Report
PGM-31State Cost Report P10SW201-7 S-X
PGM-32State Cost Report P10SW201-5 Not on P10
PGM-33State Cost Report P10SW201-4 Act 3 & Act 26 State Contributed Capital Summary Report
PGM-34State Cost Report P10SW201-3 State Contributed Capital Summary Report
PGM-35City Cost Report P10CW201-7 City Exceptions Report
PGM-36City Cost Report P10CW201-6 C-X
PGM-37City Cost Report P10CW201-4&5 Not on P10
PGM-38City Cost Report P10CW201-2 City Contributed Capital Detail Report
PGM-39County Cost Report P10LW201-9 County Exceptions Report
PGM-40County Cost Report P10LW201-8 L-X Report
PGM-41County Cost Report P10LW201-6 Not on P10 Report
PGM-42County Cost Report P10LW201-4 County Contributed Capital Summary Report
PGM-43Project Cost Report P10PM008-8 ITD Detail Accruals Only Report
PGM-44Project Cost Report P10PM008-7 ITD Detail w/o Accruals Report
PGM-45Project Cost Report P10PM008-6 ITD Account Summary Report
PGM-46Project Cost Report P10PM008-5 YTD Detail Accruals Only Report
PGM-47Project Cost Report P10PM008-4 YTD Detail w/o Accruals Report
PGM-48Project Cost Report P10PM008-3 YTD Account Summary Report
PGM-49Project Billing Status Report - P10PM001-2 Local Only
PGM-50Final (Monthly) Letter of Credit Report -- P10LM001-2 User File Info
PGM-51Detailed Age Trial Balance Report
PGM-52PR Feeder Reports -- Part 5 Source Sys Detail of JE 0201-060521
PGM-53PR Feeder Reports -- Part 4 Batch Proof List Report
PGM-54PR Feeder Reports -- Part 3 JE Summary
PGM-55PR Feeder Reports -- Part 2 JE Detail
PGM-56M&S Weekly Report P03LW028-2
PGM-57State Cost Report P10SW201-2 State Contributed Capital Detail Report
PGM-58State Cost Report P10SW201-1 Main State PCR Report
PGM-59County Cost Report P10LW201-2 County Contributed Capital Detail Report
PGM-60City Cost Report P10CW201-3 City Contributed Capital Summary Report
PGM-61County Cost Report P10LW201-1 Main County PCR Report
PGM-62City Cost Report P10CW201-1 Main City PCR Report
PGM-63M&S Weekly Report -- P03LW028-1
PGM-64Payroll Weekly Report -- P03LW027
PGM-65AP/AR Weekly Report -- P03LW026
PGM-66Project Billing Status Report - P10PM001-1 Fed, State, & Local
PGM-67The 300 Report -- P03GM032
PGM-68Final (Monthly) Letter of Credit Report -- P10LM001-1
PGM-69Project Cost Report P10PM008-2 Retainage Detail/Summary Report
PGM-70Mode Report JR-P10PR002-4 Non-Federal Totals by Mode & Fund w/i Mode Report
PGM-71Mode Report JR-P10PR002-3 Federal Totals by Mode & Fund w/i Mode Report
PGM-72APPROVED BUD RATES BY FUND Report P10PR060
PGM-73Mode Report JR-P10PR002-1 Federal Totals by Fund Report
PGM-74Mode Report JR-P10PR002-2 Non-Federal Totals by Fund Report
PGM-75AP Feeder – P38AW002-2 AP Transactions Paid
PGM-76ANA-096 Budget Headcount Report
PGM-77ANA-097 Budget Headcount Report
PGM-78View AP Feeder Report
PGM-79Print Fixed Assets Details
PGM-80View Asset Details (By Period)
PGM-81View a Fixed Asset
PGM-82MTD SUM RECON ACCT Report
PGM-83MTD SUM RECON FUND Report
PGM-84MTD SUM RECON SERIAL Report

Human Capital Mgmt SEPTA ERP Software and Implementation Services

Reports Inventory
#Summary
HCM-01ANA-044 Interface Arrears Process
HCM-02ANA-113 Interface
HCM-03Vacation request view for managers
HCM-04OG asking to view report showing unpaid amounts for a PO
HCM-05ANA-132 Interface Employee data to Vehicle Maintenance Information System
HCM-06ANA-094 Budget Headcount Report
HCM-07ANA-011 Interface Pension Contribution History
HCM-08ANA-010 Interface Pension Contribution History
HCM-09Lost time report
HCM-10ANA-068 Report STD Monthly Billing
HCM-11ANA-060 Interface Dual Coverage
HCM-12ANA-022 Interface 65 Over
HCM-13ANA-002 Interface Missing hours
HCM-14ANA-144 Report TWU234 ZERO deduction
HCM-15ANA-142 Report TWU234 Detail
HCM-16ANA-109 Interface SEPTA_DrugTestMGTCTR
HCM-17ANA-108 Interface SEPTADrugTesting_Personnel_Report
HCM-18ANA-062 Interface Monthly Billing Medical, Dental, Vision
HCM-19ANA-061 Interface Monthly Billing CVS Caremark Prescription
HCM-20ANA-027 Interface AFLAC Census
HCM-21ANA-026 Interface AFLAC Changes
HCM-22ANA-023 Interface SEPTAMedicalOptOutPaid
HCM-23ANA-126 Interface retiree search
HCM-24ANA-125 Interface Employee Lookup
HCM-25ANA-123 employee lookup by last 4 of SSN
HCM-26ANA-119 Interface VMIS M5 Employee File
HCM-27ANA-118 Report RDXTRAIN
HCM-28ANA-089 Interface Atlas Building Access
HCM-29ANA-088 Interface Conduent Atlas System
HCM-30ANA-087 Interface Atlas Building Access
HCM-31ANA-041 Interface ACA Compliance
HCM-32ANA-025 Interface Pension Processing
HCM-33ANA-007 Interface Sick Usage Double Dip Report
HCM-34ANA-006 Interface 150 Days Report
HCM-35ANA-066 Interface Monthly Billing - Met Life
HCM-36ANA-065 Interface Monthly Billing LTD & ADD
HCM-37ANA-131 Interface VMIS M4 Employee Data
HCM-38ANA-080 Interface Union (6 year) pension earnings
HCM-39ANA-079 Interface SAM 3 Year Pension Earnings
HCM-40ANA-155 Interface FOTP Union Dues
HCM-41ANA-153 Interface Term Report for IBTB
HCM-42ANA-152 Interface Zero Deduction report for IBTB
HCM-43ANA-151 Report - IBTB Summary Report
HCM-44ANA-150 Report IBTB Union Detail
HCM-45ANA-145 Report TWU234 TERM
HCM-46ANA-143 Report TWU234_Summary
HCM-47ANA-105 Interface DMV - PA Census
HCM-48ANA-103 Interface DMV - DE Census
HCM-49ANA-086 Interface Atlas Building Access
HCM-50ANA-075 Interface Retirees report
HCM-51ANA-074 Report Pension 5YR QTR Pension Ext
HCM-52ANA-073 Report Pension Master file for Pension Manager
HCM-53ANA-071 Interface SAM Optout file
HCM-54ANA-069 Interface Employee Master File
HCM-55ANA-064 Report Monthly Billing - IBX
HCM-56ANA-054 Report Metlife Eligibility
HCM-57ANA-052 Report Life Events Change Files for Intranet
HCM-58ANA-051 Report Life Events P04.HEALTH.RX.RATES
HCM-59ANA-050 Report Life Events P04.ESS.OTHER.PLANS
HCM-60ANA-049 Report Life Events P04.ESS.HEALTH.PLANS
HCM-61ANA-047 Interface Duplicate Canceled
HCM-62ANA-043 Report - Benefits Reporting BENE 2001
HCM-63ANA-029 Interface 457b - Loan
HCM-64ANA-024 Interface Pension
HCM-65ANA-019 Interface Dental
HCM-66ANA-012 Interface 457b - Loan
HCM-67Tax Levy Garnishment Deduction Report
HCM-68Bankruptcy Garnishment Deduction Report
HCM-69Court Order Garnishment Deduction Report
HCM-70Women's Way Deduction Report
HCM-71United Way Deduction Report
HCM-72ANA-NEW GHR List for Union Employee Opt-outs
HCM-73ANA-130 Interface Mass Supervisor Maintenance
HCM-74ANA-128 Report Anniversary Awards
HCM-75ANA-124 Emp SS Lookup
HCM-76ANA-117 Report DECEASED EMPS RPT
HCM-77ANA-116 Report MONTHLY TERM RPT
HCM-78ANA-115 Interface MONTHLY TREAS (term code) RPT
HCM-79ANA-114 Interface Historical HR Reporting
HCM-80ANA-078 Student Verification Report
HCM-81ANA-077 Student Verification Report for Fall Roster
HCM-82ANA-076 Student Verification Report
HCM-83ANA-005 Interface
HCM-84ANA-147 TWU234 Union COPE Deduction Report
HCM-85ANA-146 Report Interface BLE Dues

File details come from the government source that posted it. Updated .