Skip to content

Blog

Friday Feature – Budgeting Vacancies

It is that time of year again: time to create next year’s budget. To celebrate, I will be focusing on this most important task for the next few weeks.
One of the more tricky concepts for budgeting is vacancies. But Escape Online makes this easy by determining where vacancies exist, automatically.  How does it do this most wondrous feat?  Check it out.

First, Escape Online looks at your positions to see what is filled and what is not (has available FTE). See how the position list below shows the Data Entry Clerk (position 1455) has 0.125 FTE available.

Position List

Position List

Escape Online determines the available FTE by subtracting the Used FTE from the Authorized FTE. Nice!

Now, let’s  take a closer look at the used FTE.

Position Assignment List

Position Assignment List

Here are the assignments for that position. We see that Celeste has held the position for three years, using 0.25 FTE (or working for 2 hours a day).
Armed with this information, we can now go see what Escape Online loads into next year’s budget, both for Celeste’s position and for the vacancy.

Budgeting Vacancies

Budgeting Vacancies

Check it out!

Escape Online creates FOUR lines in budget to cover all of the information, giving you precise figures. Let’s look at each line:

  • Line 1: This is the Available FTE being budgeted as a vacancy. (Notice the Type is V.)
  • Line 2: Celeste only works for a few days in the first month of the year (August). Escape Online budgets these “pay actual days” separately.
  • Line 3: Celeste works full-time for most of the year (September – May). Escape Online summarizes this monthly activity to make budgeting easier to read and understand.
  • Line 4: Celeste only works for a few days in the last month of the year (June).

I am sure you will agree, Escape Online’s budgeting of vacancies (and salaries) is a truly wondrous feat!

Friday Feature – Auditing Records and Fields

Changes matter. When working with public funding or personal information, it is important to keep an audit trail of field level changes (like a social security number in an employee record or the number of items ordered in a requisition) and processing events (like the denial of a requisition or the generation of a PERS retirement report).
Escape Online has this audit process built-in.  Almost every activity includes a History tab where “old” and “new” field values are stored and processes are documented.  Check it out.

Here is a LIVE example of a completed requisition’s history (with changed user names). Starting from the bottom, we can see that an account amount was changed, precipitating a change notice and a warning that the threshold was exceeded. The requisition went on, though, proceeding through year end processing and (at the very top) having two checks printed for payment of the goods.

Requisition History

On the HR/Payroll side of the software, here is an amusing example for fans of the old TV show, “Alias Smith and Jones,” of how Escape Online keeps track of name changes in the Employee record.

pic_news_ff_emp_history

Depending on the record and where it is in the processing cycle, Escape Online writes history records to help you audit the fields and processes that are important to your district’s integrity and standards.

Now, that’s change you can count on.

Friday Feature – Classifying Receipts

Everybody loves to receive money. School districts are no different.  There are a lot of reasons why schools receive money: insurance payments from retired employees, developer fees, facility use rent, and the ever so lovely – donations.
Receipt Types LookupSchools not only receive a lot of small amounts throughout the year, they also receive them in a variety of ways: checks, cash, bank cards, etc. Escape Online helps the business office receive the money and track the type of receipt.  Check it out!

Here is a graphic of the lookup for all of the receipt types you can use to classify the money you receive. This list was developed with the input of our customers, portraying their real life needs for classifying receipts.

In fact, let’s look at the LIVE data from one organization in one of our county customers. For the fiscal year 2013:

# Receipt Type Amount
1,019 Checks $4,392,494.26
23 EFT $227,170.84
31 Cash $4,652.02
18 Cash/Check $14,381.14
1,901 $4,638,698.26

This classification of receipts allows district offices to quickly accept payments, reconcile deposits, and make corrections if necessary. They can use Escape Online’s list, grid or reports to get detail on their receipt processing, even exporting the data to Microsoft Excel for some in-depth analysis.

And that is something everybody loves.

Friday Feature – Automatic Seniority

Last Friday we discussed how to manually track seniority for employees. While this is a great feature, Escape Online has another great way to track seniority that is automatic. This automated method calculates and creates seniority records every time you process payroll. It is easy to set up and easy to use.  Check it out. Seniority granting is controlled through the employee’s assignments and addons and the job category to which they are associated.

The automated method creates detailed transaction records of an employees’s seniority based on the hours and days of assignments and addons, adjusting for time off due to leave of absences.

Employee Seniority Records

Employee Seniority Records

These are the seniority records for a Child Care Assistant.

They have these records because their job category (Daycare) is setup to track seniority by hours.

Notice how there is a seniority record for each month, tracking the number of hours worked in that month.

If this employee had two assignments that both tracked seniority, you would see two records for each month, one for each assignment.

There are several ways to define seniority:

  • The Single and Academic Department methods calculate the earliest date for paid assignments.

  • The FTE method calculates the earliest date and highest FTE for paid assignments.

  • The Hours method tracks both assignments and addons. For assignments, it compares the pay cycle period dates to the calendar paid days to calculate how many paid days this assignment had during the pay period and then multiplies that by the hours worked. For addons, it checks the employee’s pay detail to get the exact time worked.

Job Class Seniority Setup

Job Class Seniority Setup

No matter which method you select, though, Escape Online factors time worked, cancelled assignments, assignment changes, and backdated assignments.

Every time you process payroll, these records will be created and posted to the Employee record.

No manual intervention necessary!

Friday Feature – Manual Seniority Ranking

The fabulous news this year is that some school districts are hiring again! So, for the next couple of posts, I am going to talk about the Employee record. Escape Online provides great flexibility in the Employee record. As you can imagine, with over 300 organizations tracking over 100,000 employees in Escape Online, we need to have a variety of ways to accommodate employee management tasks.

In particular, we have several ways to track seniority: automatic granting based on assignments and addons or manual tracking by employee, job class or FTE.

In this Friday Feature, we are going to discuss the manual method. Check it out.

Seniority Fields on the Employment Tab

Seniority Fields on the Employment Tab

The simplest way to manually track seniority is to use the Seniority Date field on the Employment tab of the Employee record. You can search and report on this date.

But what if you hired 10 people in one day?

No problem. You can use the Seniority Rank field to qualify each employee for that date.

But what if you want to differentiate between different classes (Teachers versus IT staff versus Administrative Staff versus Management)?

Again, no problem. If you wanted to manually track seniority by job class, then you would bypass the fields on the Employment tab and go straight to the Seniority tab of the Employee record. Check it out.

Defining Seniority on the Seniority Tab

Defining Seniority on the Seniority Tab

As you can see here, the Seniority tab is chock-full of options. I can base seniority on position, FTE, addon, job category/class or academic department.

Then, within those options, I can add a ranking. So if the district has around 500 high school teachers, I can rank the teachers from 1 to 500, using a random or matrix methodology, whatever is defined by the district.

Of course, the manner in which a district implements and uses seniority is unique to each district. It is up to your district standards which manual method you use.

On the other hand, if what I have described here sounds like too much manual data entry, have no fear!  Next week, we will be discussing the automated seniority feature of Escape Online.

Friday Feature – Testing PERS Files

Testing, testing, testing. Escape Online gives you the ability to generate PERS test files for this month, and next month, and the month after that. And, they let you create test files in both the XML format and the older “standard” format. Check it out!

PERS Test File Dialog

All you have to do is select the Generate Test task in the PERS Processing activity and Escape Online is going to prompt you for a reporting period month and organization (optional if you are an all-org user).

As you know, PERS is currently supporting two file formats (XML and standard). So, Escape Online does too! See how Escape Online wrote two history records for my single request, one for each format.

PERS History Records

That means you can use either file, or both, depending on your needs. Nice!

Friday Feature – Testing STRS Files

Last week we talked about testing W2s; this week it is STRS’ turn. With all of the changes coming at you from AB340, now is definitely the time to test your STRS file before uploading the “real” file. And, of course, Escape Online is helping you out with all of this, providing timely updates for AB340.
While you have had the ability to generate STRS test files for many releases, now it is more important than ever.  And, it is so easy. Check it out!

STRS Test Task

All you have to do is select the Generate Test task in the STRS Processing activity and Escape Online is going to prompt you for a reporting period month, type (supplemental or not), and organization (optional if you are an all-org user).

But that’s not all. Escape Online is also going to prompt you for a location to save the file.

But wait there’s more.  Escape Online is going to write a history record listing the period, type, org and user Id of the person who generated the test file.

Once generated, you can upload that file to the STRS web site to make sure everything is perfect, giving you that piece of mind to make the final cut.

As Huell Howser would say, Amazing!”

(Stay tuned for next week, when we discuss PERS test files!)

Friday Feature – Testing W2s

The old saying, “Measure twice. Cut once.” applies to more than just carpentry. It can apply to W2 processing too! As you probably know, the Social Security Administration provides employers with the AccuWage software to identify the most common format errors in wage submissions. And, as you also probably know, Escape Online includes a task that generates a test W2 file you can upload to AccuWage, ensuring that you have “measured twice” before handing out W2s to employees. Check it out!

Generate Test File

Generate Test File

Of course, the testing of your file is at the tail end of your processing.  Once you have verified all of your information is complete, you are ready to select the Generate Test task from the W2 Reporting activity.

It is that easy!

Now you can upload that file (copied from \escapeserver\ InputOutput\ PayrollTaxes\ TEST_EFW2-CalendarYear) to the AccuWage software.

And as the old saying generally works in real life, that second measurement is the same as the first, but now you have the peace of mind to make that final cut (of W2s!).

Friday Feature – Mass Unprint 1099s

As part of our new year celebrations, we must report to the Feds all 1099 payments made in 2012.
Escape Online automates the process by finding all vendors that are marked for 1099s and finding all payments to any vendor with a particular object code.  Escape Online takes that information and creates a fully stocked list of vendors for you to review, including a column that states if the amount is great enough to deserve a 1099, if the vendor is set up correctly, and other important tidbits to help you in your 1099 party planning.

As all of us party planners know, sometimes you think you are done but you come to find out that another department made a payment you didn’t know about or one of your vendors has changed their address.

Escape Online has you covered here as well. Happy days!

If a 1099 has been printed and it needs to be changed, you have to unprint it. No worries. Escape Online gives you three ways to unprint.

Unprint All

Unprint All

For all organizations (the entire county): Select Unprint ALL 1099 from the Task menu at the top of the form of the 1099 Reporting activity.

Unprint Org

Unprint Org

For a single organization (district): Highlight an organization and then select Unprint 1099 Vendor Forms from the Task menu in the Organizations section of the 1099 Reporting activity.

Unprint Vendor

Unprint Vendor

For a single vendor: Open the individual 1099 in the Vendor 1099 activity and select Unprint from the Task menu.

Once unprinted, you can make those last-minute changes and print again, making for a very happy new year!

Friday Feature – Reloading W2s

While most people think of “tax time” as happening in April, we all know that there is really an earlier tax time, like right now, when we are processing W2s! Working your W2 list in Escape Online is especially easy because of three helpful search options: changes, problems and reload.  Check it out.

W2 Search

W2 Search

So this is the search criteria for W2s. It has all of the usual suspects, but the bottom three options are pretty slick.

If you set the With Changes flag to YES, you get a list of employees with changes (as created using the Edit task) to their W2 information.

If you set the With Problems flag to YES, you get a list of employees with problems (errors).

If you set the Reload Now flag to YES, Escape Online reloads employee data that has changed or was not previously loaded. This is the coolest one!  Let’s talk about it some more.

There are lots of reasons why you might edit employee data: they changed their name or their address. Or, they may have lost a check. Or, you are working this list in December before the final pay date and their pay is changing.

If you make any of these changes, you need to “reload” your list. This flag makes it so simple!

All you have to do is change it to YES and click GO. Now that isn’t taxing at all.

Friday Feature – Retirement Matrix Errors

Retirement is one of the most complex parts of a school business employee’s pay. Both STRS and PERS had major changes recently and both are undergoing even more changes with the signing into law of AB340.
When Escape Technology first implemented retirement processing into our payroll system (way back in the mid-90s), we knew users were going to need help staying in the game, keeping on top of all these rule changes, so we built in the Error Matrix released by STRS and the Payroll Reporting Element Relationships chart from PERS.

This is an awesome strategy! Check it out.

PERS Error Msg

This is the PERS Editor where you can see the error and all of the information you need to fix it. Of course, we have this same type of functionality in the STRS Editor.

PERS Error Search

Both the STRS/PERS Editors also have the ability to find ONLY those employees with errors. Sweet!

AND, Escape Online regularly checks for errors: when you are processing payroll, when you are importing persons, and of course when you are editing retirement lines.

Now that’s keeping you ahead of the game!

Friday Feature – Employee Favorites

Most often HR/Payroll users just need the basics, like opening an individual employee record or getting a list of employees. Mostly, they use last name or an employee Id, or sometimes job class (all of the teachers).

But we all know that sometimes you need to target a very specific group of employees. When that happens, Escape Online has almost 200 searchable fields to help you out!

And, if you are one of those users that is frequently doing similar complex searches, employee search favorites are a huge time saver! I know, I know, I have written a lot about favorites, but this activity is my favorite for favorites!

Let’s take a closer look.

Employee Favorites

Employee Favorites

Check out the values (circled in red). Sure, it is only a couple of fields to fill out, but with employee search favorites I can continually shave seconds off of entering search criteria.  And, you know me, every second counts.

Now take a look on the left, where I have defined the “favorite” searches that a typical user might run on a regular basis.  There are 14 shown, but I can save up to 20!  Now we are talking about a real time saver.

It is so easy to set up favorites: enter your criteria and click Manage under the Favorites. From there all you have to do is decide whether or not you want your search to be automatic (Auto Go) or if you want Escape Online to load the defined search criteria and WAIT for you to add more.

The other wonderful feature about Favorites is that you can call them from Quick Starts.  For example, I could enter EM F2 to run the favorite I created for the location search.  The reason it is F2 is because it is the second favorite on the list. (Favorites are saved and numbered sequentially. Of course, you can also rearrange them using the arrows at the side of the Favorites list box.)

So, by that standard, if I wanted a list of employees with less than 1.0 FTE, all I would have to do is type EM F10 in the quick start.

Indeed, the time-savings is fabulous!