Size: 113 staff members Funding Sources Attorney - 63 - PowerPoint PPT Presentation

 Budget: $14+ million  Accounting Software: CYMA  Size: 113 staff members  Funding Sources  Attorney - 63  Federal: 10  Paralegals- 16  State & Local government : 12  Other staff- 34  Contracts: 10  Volunteers- 60+  Foundations: 30+  Non LSC funded  Other : Law Schools, Private Bar; Individual contributions, Attorney Fees  Union: & Cy Pres awards  Timekeeping System: Hybrid  Attorney Union  Staff Union  Manual Timesheets  Outsourced Payroll: ADP  ADP payroll information extraction  Excel database allocation  Case Management: Lotus Notes  Manual journal entry into General Ledger

Employee X  Manual timesheets submitted semi- monthly by employees  Semi-monthly 77 hours per pay period (11 days at 7 hours)  Accounts for all time between fringe time taken and work  Breakout funded work between grant funded and unfunded  Each unit has list grants sources for their unit  Section for tracking lobby time  Signed off by employee

 Individual timesheets summarized into one unit timesheet  Unit timesheet signed off by Unit Manager  Both employee and unit timesheets are submitted to payroll for processing Employee X Sign off by unit manager

 Snap shot of Timetracking Excel database with tabs used by Payroll to allocate salaries

Payroll is extracted and downloaded from ADP and saved in Timetracking spreadsheet under the ADP extract tab Employee X

Sample of Employee x time allocation Standard Allocation for unfunded work  All fringe time taken is allocated to grants worked on in that time period  77 hours in pay period  14 hours fringe time taken  Allocation % based on 63 hours worked  All unfunded time worked is allocated to unrestricted funds using a standard allocation formula

Sample Timetracking spreadsheet PIVOT Table Reports:  Funding Report by Employee: How did Employee X  Payroll Summary which is used to manually journal spend their time? entry allocated payroll information into the General Ledger. Employee X Note: Categories have been eliminated for illustration purposes  Sample Grant Report for Rosie’s Place highlighting Employee X’s time worked on grant. Employee 123 Employee 345 Employee 567 Employee X Employee 789 Employee 543 Employee 321 Employee 451 Employee 678

Questions?