These models were created to extract the basic information from system reports.  You may need to modify the model to customize it to your districts' needs.  You must purchase Monarch to use these files.  If you have not purchased Monarch, go to the Monarch Pricing page for further information.

To download files: right click on the link and select "Save Target As..."

Here are some general instructions that may help you in creating your models:

If you have a model or project that you would like to share with other districts, please call Melita Crowell at (909) 386-2700 and we will be happy to post it to the web site.

Payroll
Financial
Personnel
Archive Report Models

 

PAYROLL

DNP Balances Comparison
These models and access file are used to compare the DNP balances between Employee Pay History (PYR830) and the DNP Balance Report (PYR535). Once the models are applied and exported from the Table View into the Access file, it will display the employees DNP balances. There are 2 queries available in Access to ensure that all data from both reports is accessed. If there are employees on one report and not the other, the DNP field will be BLANK and needs to be researched. Also, if the amounts are different, this will also need research.
PYR535 Model
PYR830 Model
DNP Balances Access File

Employer Paid Benefit Distribution
PYR320 Model
This model is to be used on the Employer Paid Benefit Distribution By Account Report (PYR320) to assist the Payroll Technician in finding employees who have a $0 Gross, but who have dollars in the Employer HW in Payroll. These might be employees who terminated, but who have not had their Employer HW dollars deleted. When viewed in the Table format, only employees with $0 Gross, but dollars in the ER HW column will display.

Payroll Exception Report
PYR515 Model
This model is for the Payroll Exception Report (PYR515) to assist Payroll Technicians in finding Errors on the Exception Report. When accessed in the Table format, the Error information will be displayed in an easily viewed format.

Year End Reports
COR960 Model
This model is to be run against the Account Edit Report (COACIN/COR960) that is sent on the year end CD. When the model is applied and used in the Summary View, it will display a listing of Accounts to be linked or changed.

PYU955 Model
This model is to be run against the PYU955 Report sent on the year end CD. When the model is applied and used in the Window View, it will display a listing of employees with errors that occurred during the roll and should be audited.

PYU956 Model
This model is to be run against the PYU956 Report sent on the year end CD. When the model is applied and used in the Window View, it will display a listing of employees with errors that occurred during the roll and should be audited.

Post Roll Gen-Detail Model
This model is to be run against the Generation Reports sent on the year end CD. When this model is applied and used in the Window View, it will display detailed information regarding the employee's Salary Range, Step, FTE, Hours Per Day
and Salary Information.

COR610 Find Gen Earn Flags Model
This model is to be run against an Employee Position Detail Report in MAGIC (COEPIN/COR610). This model will allow the user to quickly identify employees Generate Earn Flag in Employee Position Attachment. There are 2 filters included: 1 will display ONLY employees with a Generate Earn Flag of "Y" and 1 will display ONLY employees with a Generate Earn Flag of "N". This is to assist the Payroll and HR Technicians in determining which employees may need to have the flag modified for the new fiscal year prior to generating.

Employee Tax/Retirement Report
This model is to be applied against the Employee Tax/Retirement Report. It will display a listing of Earning - Benefit Frequencies to assist the Payroll Technician at Year End in determining the correct Roll frequencies.
EQ & BQ in Tax-Ret Report model

Generation Calcs
Below is a Monarch Model to be used against the Generation Reports. This model, when used in the Table View, will display any employees who have a different Salary Calc (Annual calculation at the top of the report) compared to the Cycle Total Calc (the cycle by cycle distribution total). This will enable the Payroll Technicians to check the Mass Generations for potential problems and errors as soon as the Generation Reports are run. If problems are found, the Payroll Technician can contact the Payroll Helpdesk so we can hopefully identify and fix problems sooner and more efficiently. This model MUST be used with the "S"ummary version of the Generation Report only. The "D"etail format will not work with this model.
Generation Salary Calc monarch model

Pers Reduction for New Payroll
This project is used to display the Pers Reduction amount by employee and includes Account numbers. If you do not need the employee information, you can use the PYR335 report from your Payroll CD.
PERS Reduction Instructions
PYR320 Model
PYR320 PERS RED Model

Out of Balance
This model captures the warning when someone is out of balance.
PYR830 Model

New Payroll Retro for Additional Earnings
Instructions
Monarch Model
Version 8 model

Changing Earning & Deduction Frequencies Between Fiscal Years
This process is to be used when District and/or County Offices are changing the Frequencies, or cycles employees are being paid. The documentation file will show step by step the process that must be followed and the models will assist in assuring only the specific Earning/Deduction lines are changed.
Instructions
PYR530 model
PYR630 model

Quarterly Payroll Report Project (Etiwanda)
The Etiwanda School District participates in the Medical Administrative Activities/Billing Option Program through the Department of Health Services. For our quarterly billings, DHS needs to know the total paid and applicable employer benefits by employee, by quarter and by account code (mainly function, object and location). Time survey percentages are then applied to the quarterly payroll totals to arrive at the proper amount to be billed back to Medical/DHS. This model has solved our problem in that the model will combine the monthly PYR320 to quarterly totals (gross paid/er benefits) by employee and by account number. Run the PYR320 for each cycle of the quarter and apply the model. Go to the Summary view for the combined totals for each employee.
Quarterly Payroll Report Model (PYR320)
Other Costs Model (BDX110)
Quarterly Report Instructions
Quarterly Report Excel file for the Detail Invoice

Models by Leonard Villagomez=
Instructions
Summary of Earn Type by PTY PYR530 Model
(more models under Financial)

Negative Pay Lines
This model will use the PYR510 report to find negative salaries.
Instructions
PYR510 Negative Pay model

Pers Gross for New Payroll
The purpose of this model is to give the financial user a method for calculating PERS gross amounts.  You will need to run a PYR320 report then apply the model. The Table view is listed by employee and the Summary view is summarized by account.
Pers Gross Model

Paralleling Old Payroll with New Payroll
http://it.sbcss.k12.ca.us/it_payroll.htm

 

FINANCIAL

Board of Trustees Payment Report Merge Project
This project merges the information from the APY250 report with a more detailed description from the Board of Trustees Payment Report. The result is a spreadsheet with the information from both reports that can be sorted, filtered or summarized in a variety of ways to meet the needs of your Board members.
Instructions
APY250 Model
Board of Trustees Payment Report Model
Board Payment Excel File

Models by Leonard Villagomez (Chino Valley USD)
Instructions
Salary & Benefit Projection COR610 Model
Examining the Cost of Interim Vacancies COR610 Model
FTE by Goal for Interim Reporting COR610 Model
(PYR530 model under Payroll)

Analysis of Revenues, Expenditures and Beginning Balance by Resource by Jesus Holguin (SBCSS)
Instructions
BDX110 Model
GLD115 Model

GLD410 Out of Balance Resources
The Monarch model developed will trap and report out in table format the individual resources that are triggering the out-of-balance message.
Instruction
GLD410 model

Budget Models shared by Laura Carevic (Hesperia USD)
BDX110 instructions
BDX110 model
BDO510 instructions
BDO510 model
SAR655 instructions
SAR655 model

GLD110 Searching the General Ledger
Instructions
GLD110 model

Scattergram & J90
The Scattergram is used to give total dollars spent and number of employees on each Range/Step of specified salary schedules. This information is used on interim reporting for certificated employees and is also commonly used in negotiations.

The model is used against the 00-1 Version of the COR610 (D)etail format. Include All Eff Dates, Vacancies, Earnings =(N)o. You may 'Include Accounts' but the template is not trapping the account information.

The end product is found in the Summary View titled "Scattergram". If you have extracted your report by a single salary schedule or designed a filter for one single salary schedule, there is a second summary titled "1 Schedule" that formats report the information horizontally rather than vertically. This model can also be used with the J90 report.

Scattergram & J90 Model

FAR311
The purpose of this model is to give the financial user a method for
reporting Accruals to the State. You will need to run a Receivables/Payables Financial Activity Report (FAR311) and apply the model.
Instructions
FAR311 Model

 

PERSONNEL

Notice of Assignment
The Notice of Assignment project is used on an annual basis as a way for districts to quickly generate notifications to send out to employees each year which includes information on their annual assignment. This process uses Reports 2000 for the employee information and a COR610 in Reflections for salary information. You will need to have Reflections, Monarch, Microsoft Word and Microsoft Access already installed on your computer before you begin this process.
Instructions
COR610 model
Access file for Office 2000 or greater
Sample NOA Word Merge file
Sample TB Expiration Letter

Health & Welfare Census
Occasionally Personnel departments are asked to give a census report to insurance providers and brokers for insurance quotes.
Instructions
COR410 model
COR414 model
PYR630 model
Query model
Access Database

Vacation Tracking
This project uses the ABS100 and COR610 reports to show which employees have exceeded their vacation limits.
Instructions
ABS100 model
COR610 model
Access database

FTE Vacancies Bug
This model is designed to identify the problems with partial FTE vacancies not reporting in COR/SAMS reports therefore creating a possible understatement of earning/benefit dollars in budget development. It is used against the 00-1 version COR610, (D)etail format, sorted by position, 'Include accounts'='Y', 'All Empe Eff Dates'='N', 'Include Earnings'='N', 'Include Vacancies'='N', with a specific date in the 'As of Date' field--recommended 6/30 of the current fiscal year.

The model includes a summary that will summarize the Employee FTE against the Position FTE per position. If the FTE is NOT equal for employee and position, then a partial vacancy exists and should be reviewed to see if these vacancy dollars need to be included in the budget year. Once identified, the user may use SAMS Additional Account Detail Program to enter in the dollars, FTE, tax type, and 3xxx accounts associated with with these partial vacancies.
FTE Model

 

ARCHIVE REPORT MODELS

  


For additional information, please call (909) 386-2700 or email the web master.
The California Educational Computer Conosrtium c/o San Bernardino County Superintendent of Schools
601 North E Street • San Bernardino, California 92410