Exhibit-C-Reports-Inventory.xlsx
XLSX spreadsheet 31 KB Posted
- 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
| File | Type | Posted |
|---|---|---|
| Response-Form-1-QA-Submission.xlsx | XLSX spreadsheet | |
| Attachment-03B-Software-Price-Proposal.xlsx | XLSX spreadsheet | |
| RFP-26-00268-AHAC-for-ERP-Software-and-Implementation-Services.pdf | ||
| Appendix-2B-Exit-Services.pdf | ||
| Response-Form-3-Functional-Requirements.xlsx | XLSX spreadsheet | |
| Attachment-03A-Price-Proposal-for-SI-Services.xlsx | XLSX spreadsheet | |
| Invitation-to-Propose-ERP-SI.pdf | ||
| Response-Form-2-Proposer-Information.xlsx | XLSX spreadsheet | |
| Appendix-2C-Performance-Management.pdf | ||
| Exhibit-B-Key-Personnel.pdf | ||
| Response-Form-4-Non-Functional-Requirements.xlsx | XLSX spreadsheet | |
| Exhibit-A-Applications-Interfaces-Inventory-1.xlsx | XLSX spreadsheet |
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-01 | ANA-035 Interface Pension - GL |
| FSM-02 | ANA-034 Interface Pension - GL |
| FSM-03 | ANA-033 Interface Pension GL |
| FSM-04 | ANA-032 Interface Pension - GL |
| FSM-05 | GA - Build Custom Obsolescence / Inventory Report |
| FSM-06 | AR - Custom Aging Report to include Division and Receivables Codes |
| FSM-07 | AR - Customer List |
| FSM-08 | AP - Stale Dating And Escheatment Report |
| FSM-09 | FA - 3-Way Reconciliation |
| FSM-10 | AR - Recurring Rent |
| FSM-11 | AR - View Customer Recurring Charges (Single Month) |
| FSM-12 | AR - View Customer Recurring Charges (All Months) |
| FSM-13 | GA - Reporting / Escheatment |
| FSM-14 | AR & GA - Annual List of Federal Grant expenditures (Single Audit) |
| FSM-15 | GA - Financial Statement / Footnotes |
| FSM-16 | GA - 703 Expense by Function |
| FSM-17 | GA - 702 Expense by Mode |
| FSM-18 | FA - Custom Report for Retirement - View Assets by Funding Source YTD |
| FSM-19 | View AR Subledger Report |
| FSM-20 | M&S Feeder Report -- P77AW005-2 Issues From Storeroom |
| FSM-21 | M&S Feeder Report -- P77AW005-1 M&S Project Detail |
| FSM-22 | Reports needed for indirect cost calculation |
| FSM-23 | AP Feeder – P38AW002-3 SUMMARY J/E GLIR0410 |
| FSM-24 | AP Feeder – P38AW002-4 Batch Proof List |
| FSM-25 | AP Feeder – P38AW002-1 AP Project Detail |
| FSM-26 | AP - 1099 Tax Reporting |
| FSM-27 | AP - Liability Account Analysis |
| FSM-28 | AP - Outstanding Liability |
| FSM-29 | Weekly Tax Summary Report for Cash Management |
| FSM-30 | Personalized Payroll Error Report |
| FSM-31 | FA - View Asset Retirement Detail |
| FSM-32 | Payroll - Prepaid Vacation report |
| FSM-33 | Payroll - Headcount TM600 for Pension, OPEB |
| FSM-34 | Time Keeping - Headcount and Work Hours by Function |
| FSM-35 | Payroll - P04TM069 - Employee Pension Contributions |
| FSM-36 | Payroll - P04RQ600 (quarterly) - RUI creditable amount |
| FSM-37 | Payroll - P04RM600 (monthly) - RUI creditable amount |
| FSM-38 | Payroll - P04BW701 - Payroll summary (monthly amts.) |
| FSM-39 | Payroll - P04BW701 - Check refunds |
| FSM-40 | Payroll - P04BW701 - ACH Doe (ACH credits) |
| FSM-41 | Payroll - P04BW430 - Voided direct deposits |
| FSM-42 | Payroll - P04BW430 - Voided check list |
| FSM-43 | Payroll - P04BW430 - DAC report (Summary of month's activity) |
| FSM-44 | Payroll - P04BW430 - 8B voids (checks cancelled for month) |
| FSM-45 | Payroll - P04BW430 - ARP Payroll |
| FSM-46 | Payroll - P04BW420 - Check Restart |
| FSM-47 | Payroll - P04BW420 - Prepays |
| FSM-48 | Payroll - P04BW420 - Check Reversals |
| FSM-49 | Payroll - P04BW420 - All DOE codes |
| FSM-50 | Claims - related reports (All) |
| FSM-51 | PO/VEMIS - SMART Fuel Report |
| FSM-52 | Cash Flow by Source/Event Code |
| FSM-53 | GA - Payroll Report by function by Cost Center |
| FSM-54 | FA - View GL contributed capital Accounts |
| FSM-55 | FA - View GL Amortization Accounts |
| FSM-56 | AR - Cash Inputs Report |
| FSM-57 | AR Monthly Report |
| FSM-58 | AR - Purchase Order Report |
| FSM-59 | FA - View Capital Asset Footnote Report |
| FSM-60 | Fringe Rate Calculation Report |
| FSM-61 | PR Feeder Reports -- Part 1 Project Detail |
| FSM-62 | ANA-090 Budget Headcount Report |
| FSM-63 | Completed Details Report |
| FSM-64 | GA - Passengers Monthly Report |
| FSM-65 | GA - Miles Monthly Report |
| FSM-66 | GA - View and Send Stale Dating And Escheatment Report |
| FSM-67 | GA - View Interface Data |
| FSM-68 | GA - General Cash Account Balances |
| FSM-69 | CM - Current Day Cash Report |
| FSM-70 | CM - Reconcile GL Entries |
| FSM-71 | CM - Account Analysis |
| FSM-72 | CM - View AP Check Register |
| FSM-73 | AR Code Report |
| FSM-74 | GA - GAAP Income Statements |
| FSM-75 | GA - Monthly Balance Sheet (Internal Package) |
| FSM-76 | GA - Single Audit Reporting |
| FSM-77 | AP / CM - Cash Payment Register |
| FSM-78 | Check Register Report |
| FSM-79 | AP Invoices Report |
| FSM-80 | AR - Aging Report |
| FSM-81 | Revenue Accounting Feeder Report Data Fields |
| FSM-82 | GA - Inventory |
| FSM-83 | GA - Monthly Income Statement |
| FSM-84 | GA - Quarterly Balance Sheet (GAAP Statements) |
| FSM-85 | GA - Trial Balance |
| FSM-86 | Custom Report Identification |
| FSM-87 | MTD DETAIL RECON Report |
| FSM-88 | RA - Trial Balance Reporting |
Procurement & Supply Chain SEPTA ERP Software and Implementation Services
| Reports Inventory | |
| # | Summary |
| PSCM-01 | Requisition Report |
| PSCM-02 | Sourcing Event Analysis Report |
| PSCM-03 | Bid Details Report |
| PSCM-04 | Inventory Manager Dashboard |
| PSCM-05 | Inventory By Fleet |
| PSCM-06 | PO Report |
| PSCM-07 | Buyer Performance Report |
| PSCM-08 | Sealed Bid Report |
| PSCM-09 | DBE Awards |
| PSCM-10 | Purchasing Analysis |
| PSCM-11 | Spend Analysis report/dashboard |
| PSCM-12 | Open Requisitions Report |
Projects & Grants Mgmt SEPTA ERP Software and Implementation Services
| Reports Inventory | |
| # | Summary |
| PGM-01 | FA - Build Custom Reporting for Amortization |
| PGM-02 | Operating Consolidated Details Report |
| PGM-03 | FA - Reporting (All Asset Summary Expense Report) |
| PGM-04 | ANA-095 Budget Headcount Report |
| PGM-05 | ANA-093 Budget Headcount CHET Report |
| PGM-06 | ANA-092 Budget Headcount Report |
| PGM-07 | ANA-091 Budget Headcount Report |
| PGM-08 | Project Control ProjCtrl_Rpt_006 Company 4000 Procurement Report Request |
| PGM-09 | FA - Generate Vehicle/Equipment Inventory |
| PGM-10 | Project Cost Report P10PM008-1 Main PCR Report |
| PGM-11 | Project Detail P04RW074-1 P04TW050-1 PR Feeder |
| PGM-12 | Project Billing Status Report - P10PM001-3 Company 6000 |
| PGM-13 | County Cost Report P10LW201-5 County Contributed Capital Summary Report |
| PGM-14 | Payroll Weekly Report P03LW027 Fed Letter of Credit portion |
| PGM-15 | View Funding Source Rates by Project and Fund |
| PGM-16 | County Cost Report P10LW201-3 Contrib Cap SEPTA, RRCTD, RRSTD AR_PGA_017 |
| PGM-17 | State Cost Report P10SW201-6 Not on P10 |
| PGM-18 | View Posting Project Detail Report |
| PGM-19 | Local Match Breakdown Report |
| PGM-20 | Capital Budget and Expenses Reporting |
| PGM-21 | View Existing Projects & Funding Reports |
| PGM-22 | View GL Accounts Report |
| PGM-23 | Operating Funding Sources Report |
| PGM-24 | Pass Through Funds Report |
| PGM-25 | Operating Subsidy Consolidated Statements Report |
| PGM-26 | Subsidies Account Analysis Report |
| PGM-27 | Purchase Order Report |
| PGM-28 | Local Cost Detail Report |
| PGM-29 | Fringe Adjustment Report |
| PGM-30 | State Cost Report P10SW201-8 State Exceptions Report |
| PGM-31 | State Cost Report P10SW201-7 S-X |
| PGM-32 | State Cost Report P10SW201-5 Not on P10 |
| PGM-33 | State Cost Report P10SW201-4 Act 3 & Act 26 State Contributed Capital Summary Report |
| PGM-34 | State Cost Report P10SW201-3 State Contributed Capital Summary Report |
| PGM-35 | City Cost Report P10CW201-7 City Exceptions Report |
| PGM-36 | City Cost Report P10CW201-6 C-X |
| PGM-37 | City Cost Report P10CW201-4&5 Not on P10 |
| PGM-38 | City Cost Report P10CW201-2 City Contributed Capital Detail Report |
| PGM-39 | County Cost Report P10LW201-9 County Exceptions Report |
| PGM-40 | County Cost Report P10LW201-8 L-X Report |
| PGM-41 | County Cost Report P10LW201-6 Not on P10 Report |
| PGM-42 | County Cost Report P10LW201-4 County Contributed Capital Summary Report |
| PGM-43 | Project Cost Report P10PM008-8 ITD Detail Accruals Only Report |
| PGM-44 | Project Cost Report P10PM008-7 ITD Detail w/o Accruals Report |
| PGM-45 | Project Cost Report P10PM008-6 ITD Account Summary Report |
| PGM-46 | Project Cost Report P10PM008-5 YTD Detail Accruals Only Report |
| PGM-47 | Project Cost Report P10PM008-4 YTD Detail w/o Accruals Report |
| PGM-48 | Project Cost Report P10PM008-3 YTD Account Summary Report |
| PGM-49 | Project Billing Status Report - P10PM001-2 Local Only |
| PGM-50 | Final (Monthly) Letter of Credit Report -- P10LM001-2 User File Info |
| PGM-51 | Detailed Age Trial Balance Report |
| PGM-52 | PR Feeder Reports -- Part 5 Source Sys Detail of JE 0201-060521 |
| PGM-53 | PR Feeder Reports -- Part 4 Batch Proof List Report |
| PGM-54 | PR Feeder Reports -- Part 3 JE Summary |
| PGM-55 | PR Feeder Reports -- Part 2 JE Detail |
| PGM-56 | M&S Weekly Report P03LW028-2 |
| PGM-57 | State Cost Report P10SW201-2 State Contributed Capital Detail Report |
| PGM-58 | State Cost Report P10SW201-1 Main State PCR Report |
| PGM-59 | County Cost Report P10LW201-2 County Contributed Capital Detail Report |
| PGM-60 | City Cost Report P10CW201-3 City Contributed Capital Summary Report |
| PGM-61 | County Cost Report P10LW201-1 Main County PCR Report |
| PGM-62 | City Cost Report P10CW201-1 Main City PCR Report |
| PGM-63 | M&S Weekly Report -- P03LW028-1 |
| PGM-64 | Payroll Weekly Report -- P03LW027 |
| PGM-65 | AP/AR Weekly Report -- P03LW026 |
| PGM-66 | Project Billing Status Report - P10PM001-1 Fed, State, & Local |
| PGM-67 | The 300 Report -- P03GM032 |
| PGM-68 | Final (Monthly) Letter of Credit Report -- P10LM001-1 |
| PGM-69 | Project Cost Report P10PM008-2 Retainage Detail/Summary Report |
| PGM-70 | Mode Report JR-P10PR002-4 Non-Federal Totals by Mode & Fund w/i Mode Report |
| PGM-71 | Mode Report JR-P10PR002-3 Federal Totals by Mode & Fund w/i Mode Report |
| PGM-72 | APPROVED BUD RATES BY FUND Report P10PR060 |
| PGM-73 | Mode Report JR-P10PR002-1 Federal Totals by Fund Report |
| PGM-74 | Mode Report JR-P10PR002-2 Non-Federal Totals by Fund Report |
| PGM-75 | AP Feeder – P38AW002-2 AP Transactions Paid |
| PGM-76 | ANA-096 Budget Headcount Report |
| PGM-77 | ANA-097 Budget Headcount Report |
| PGM-78 | View AP Feeder Report |
| PGM-79 | Print Fixed Assets Details |
| PGM-80 | View Asset Details (By Period) |
| PGM-81 | View a Fixed Asset |
| PGM-82 | MTD SUM RECON ACCT Report |
| PGM-83 | MTD SUM RECON FUND Report |
| PGM-84 | MTD SUM RECON SERIAL Report |
Human Capital Mgmt SEPTA ERP Software and Implementation Services
| Reports Inventory | |
| # | Summary |
| HCM-01 | ANA-044 Interface Arrears Process |
| HCM-02 | ANA-113 Interface |
| HCM-03 | Vacation request view for managers |
| HCM-04 | OG asking to view report showing unpaid amounts for a PO |
| HCM-05 | ANA-132 Interface Employee data to Vehicle Maintenance Information System |
| HCM-06 | ANA-094 Budget Headcount Report |
| HCM-07 | ANA-011 Interface Pension Contribution History |
| HCM-08 | ANA-010 Interface Pension Contribution History |
| HCM-09 | Lost time report |
| HCM-10 | ANA-068 Report STD Monthly Billing |
| HCM-11 | ANA-060 Interface Dual Coverage |
| HCM-12 | ANA-022 Interface 65 Over |
| HCM-13 | ANA-002 Interface Missing hours |
| HCM-14 | ANA-144 Report TWU234 ZERO deduction |
| HCM-15 | ANA-142 Report TWU234 Detail |
| HCM-16 | ANA-109 Interface SEPTA_DrugTestMGTCTR |
| HCM-17 | ANA-108 Interface SEPTADrugTesting_Personnel_Report |
| HCM-18 | ANA-062 Interface Monthly Billing Medical, Dental, Vision |
| HCM-19 | ANA-061 Interface Monthly Billing CVS Caremark Prescription |
| HCM-20 | ANA-027 Interface AFLAC Census |
| HCM-21 | ANA-026 Interface AFLAC Changes |
| HCM-22 | ANA-023 Interface SEPTAMedicalOptOutPaid |
| HCM-23 | ANA-126 Interface retiree search |
| HCM-24 | ANA-125 Interface Employee Lookup |
| HCM-25 | ANA-123 employee lookup by last 4 of SSN |
| HCM-26 | ANA-119 Interface VMIS M5 Employee File |
| HCM-27 | ANA-118 Report RDXTRAIN |
| HCM-28 | ANA-089 Interface Atlas Building Access |
| HCM-29 | ANA-088 Interface Conduent Atlas System |
| HCM-30 | ANA-087 Interface Atlas Building Access |
| HCM-31 | ANA-041 Interface ACA Compliance |
| HCM-32 | ANA-025 Interface Pension Processing |
| HCM-33 | ANA-007 Interface Sick Usage Double Dip Report |
| HCM-34 | ANA-006 Interface 150 Days Report |
| HCM-35 | ANA-066 Interface Monthly Billing - Met Life |
| HCM-36 | ANA-065 Interface Monthly Billing LTD & ADD |
| HCM-37 | ANA-131 Interface VMIS M4 Employee Data |
| HCM-38 | ANA-080 Interface Union (6 year) pension earnings |
| HCM-39 | ANA-079 Interface SAM 3 Year Pension Earnings |
| HCM-40 | ANA-155 Interface FOTP Union Dues |
| HCM-41 | ANA-153 Interface Term Report for IBTB |
| HCM-42 | ANA-152 Interface Zero Deduction report for IBTB |
| HCM-43 | ANA-151 Report - IBTB Summary Report |
| HCM-44 | ANA-150 Report IBTB Union Detail |
| HCM-45 | ANA-145 Report TWU234 TERM |
| HCM-46 | ANA-143 Report TWU234_Summary |
| HCM-47 | ANA-105 Interface DMV - PA Census |
| HCM-48 | ANA-103 Interface DMV - DE Census |
| HCM-49 | ANA-086 Interface Atlas Building Access |
| HCM-50 | ANA-075 Interface Retirees report |
| HCM-51 | ANA-074 Report Pension 5YR QTR Pension Ext |
| HCM-52 | ANA-073 Report Pension Master file for Pension Manager |
| HCM-53 | ANA-071 Interface SAM Optout file |
| HCM-54 | ANA-069 Interface Employee Master File |
| HCM-55 | ANA-064 Report Monthly Billing - IBX |
| HCM-56 | ANA-054 Report Metlife Eligibility |
| HCM-57 | ANA-052 Report Life Events Change Files for Intranet |
| HCM-58 | ANA-051 Report Life Events P04.HEALTH.RX.RATES |
| HCM-59 | ANA-050 Report Life Events P04.ESS.OTHER.PLANS |
| HCM-60 | ANA-049 Report Life Events P04.ESS.HEALTH.PLANS |
| HCM-61 | ANA-047 Interface Duplicate Canceled |
| HCM-62 | ANA-043 Report - Benefits Reporting BENE 2001 |
| HCM-63 | ANA-029 Interface 457b - Loan |
| HCM-64 | ANA-024 Interface Pension |
| HCM-65 | ANA-019 Interface Dental |
| HCM-66 | ANA-012 Interface 457b - Loan |
| HCM-67 | Tax Levy Garnishment Deduction Report |
| HCM-68 | Bankruptcy Garnishment Deduction Report |
| HCM-69 | Court Order Garnishment Deduction Report |
| HCM-70 | Women's Way Deduction Report |
| HCM-71 | United Way Deduction Report |
| HCM-72 | ANA-NEW GHR List for Union Employee Opt-outs |
| HCM-73 | ANA-130 Interface Mass Supervisor Maintenance |
| HCM-74 | ANA-128 Report Anniversary Awards |
| HCM-75 | ANA-124 Emp SS Lookup |
| HCM-76 | ANA-117 Report DECEASED EMPS RPT |
| HCM-77 | ANA-116 Report MONTHLY TERM RPT |
| HCM-78 | ANA-115 Interface MONTHLY TREAS (term code) RPT |
| HCM-79 | ANA-114 Interface Historical HR Reporting |
| HCM-80 | ANA-078 Student Verification Report |
| HCM-81 | ANA-077 Student Verification Report for Fall Roster |
| HCM-82 | ANA-076 Student Verification Report |
| HCM-83 | ANA-005 Interface |
| HCM-84 | ANA-147 TWU234 Union COPE Deduction Report |
| HCM-85 | ANA-146 Report Interface BLE Dues |
File details come from the government source that posted it. Updated .