Skip to content

Blog

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!

Friday Feature – Searching for Employees by Name

Shakespeare wrote, “A rose by any other name would smell as sweet.”  But would Shakespeare be able to find that rose in a database if the rose changed its name? He would if he was using Escape Online!
Ok, English major humor aside, let’s seriously take a look at the copious ways you can search for employees by name.

pic_news_ff_NameSearchEmp

In the Employee Management activity, there are four ways to search for an employee by name.

First, there is the employee Id. While at first glance this does not seem like a name field, in reality it is because it is driven by the employee lookup which allows you to enter a few characters of a last name and get a lookup of all employees with a last name beginning with those characters.

This handy-dandy little feature could save you a bunch of time by allowing you to make sure the people you want are in the lookup BEFORE you click GO to create the list.

Of course, last and first name are pretty obvious.  The true genius is in the Include Previous Name flag. It works in conjunction with the Last Name field.

So if we enter Hathaway in the Last Name field and set the Include Previous Name flag to YES, Shakespeare’s wife, Anne Shakespeare (previously Anne Hathaway) would appear on our list because Hathaway was entered in the comma-delimited list of previous last names in her employee record.

Huzzah!

Friday Feature – Account Distribution in Payments

I am a big fan of automation. It makes my job easier because I can be more productive with less effort. That is a win-win for everyone. I especially like automatic mathematical equations. I set them up all of the time in Excel.
That is why I am so excited about the new automatic account distribution for payments. Now, I am not just talking about AP payments to vendors,  I am also talking about payments to employees and direct payments (to a vendor or not!). Check it out.

Auto Account Balance

Auto Account Balance

Here is a requisition with 15 accounts. Yikes! Now, I am no fool.  I could do the math.  But why? With the balancing capability, all I have to do is enter a payment amount, and Escape Online automatically distributes the account amounts to match the payment amount.

That may sound awesome in and of itself, but that’s not all we did.  We also created specific distribution logic for the different payment types.

For employee and direct payments, the accounts are distributed based on the ratio of that account’s current amount to the total of all account amounts.

For AP payments, the distribution method is slightly different. First we subtract non-requisition accounts to determine the amount to distribute, then we use the liability accounts (if they exist), and finally the expense accounts.

Account Balance Manual

Account Balance Manual

Now, I know I said there was no reason why I wouldn’t want to use the auto-balancing, but we all know better.

Indeed, there are reasons why I might want to distribute those amounts myself.

If that is the case, all you have to do is set the Manual Account Distribution flag to YES, and you can enter account amounts the way that you think is best.

AMAZING!!

But that’s not all that is amazing.

This change was  voted by our customers as one of the top CRs for Finance for version 12.03, proving that with Escape Online everyone is a winner.