Skip to content

Friday Feature – The Never Ending Story: Unending Ranges

Sometimes, you want to see everything from TODAY forward, or even TODAY backward, or for that matter, any day forward or backward. Escape Online lets you do this on search pages using the dot-dot feature.
Similar to an ellipsis but with only two periods instead of three, the dot-dot feature lets you specify a date and make it part of an unending range. Since a picture is worth a thousand words, let’s take a look at how this looks!

First, we look to the future. This date range would give you every journal entry with a post date that is today or at any date in the future.

The next graphic is the opposite. It is going to give you every journal entry with a post date of today or at any date in the past.

Now, in most cases, you would enter a fiscal year in this backwards search, but maybe not. Maybe you want to find every journal entry with a particular source that was ever posted. You could do it.

You could also use the dot-dot to create a specific range, like 01/01..01/31 to get only those journal entries posted in the month of January.

This is a never ending story, kind of like the feature list we provide our users!

Friday Feature – W2 Copy Message

Presenting copies of previous W2s is required for many of today’s financial transactions. And, as everyone in HR/Payroll knows, sometimes the employee does not have a copy and they need to get one reprinted. Now, you don’t want “extra” W2s just floating around out there. You want some way to “mark” a W2 as a copy. Escape Online has got you covered with the W2 Copy Message field. Check it out.

In the Organization record, over on the right hand side, several sections down, there is a W2 Overrides section.

Here you can define your contact information, sort option and issue option. This is also where you can define what will appear on the W2 if you go to the HR/Tax Reporting-Employee W2 activity and select the Print Employee Form Copy Option task.

Escape Online uses exactly what you type, including whether you want it all caps or not. You can enter up to 12 characters. A quick peek at our LIVE customer databases and I see that most set up the message to be Reprint, Reprinted, Copy or Duplicate, with some opting for all caps and others not. That is the beauty of the message. It is really up to you.

pic_news_W2_CopyMessageOnW2

pic_news_W2_CopyMessageOnW2

Here is what the wording looks like when you print the W2 copy. It is right next to the tax year and above the SSN, very conspicuous.

Friday Feature – 1099 Print Account Options

Happy New Year! Happy 1099 Processing! Yes, it is that time again and there is always room for a favorite 1099 feature. This year, we are going to take a look at the fantastic Print Account Option, which allows you to print the Vendor ID or your customer account number on the 1099.
This can be a great time-saver when answering questions about 1099s!

pic_news_1099_AcctOption_OrgFlag

pic_news_1099_AcctOption_OrgFlag

In case you forgot since the last time you did 1099s, some of the setup is in the Organization record, in the AP 1099 section on the right of the form.

As you can see, there are some requirements and some optional flags. The Print Account Option is the last field in this section. It allows you to leave the Account Number section on the 1099 (see below) blank or fill it with information that is important to you and the vendor, like your customer account number or their vendor ID.

Let’s select customer account number and see how that plays out.

pic_news_1099_AcctOption_VendorInfo

pic_news_1099_AcctOption_VendorInfo

If you select an option in the Organization record, when Escape Online processes the 1099s, it is going to look to the Vendor record (under the Purchasing activity group in Finance) to see what information you want to print on the 1099.

These are your two options: Vendor ID and Customer Account number. As you can see here, both are filled out for this 1099 vendor.

pic_news_1099_AcctOption_1099

pic_news_1099_AcctOption_1099

Now, when you process the 1099, the customer account number (because that is what we selected) prints automatically on the 1099.

Fantastic!

Friday Features – Dynamic Footers for Work Orders

I am on a roll with footers. We already talked about purchase orders. Now, for the last Friday Feature of 2014, I would like to show the same functionality for work orders. I will start the new year by covering invoices. Woo hoo! Here is a screen shot of the Department record, Work Orders section. The WO Copy Captions lets you set a default, just like the purchase orders. And, of course, you can change it on-the-fly, just like purchase orders.

And, here is a screen shot of the Print Work Orders activity. Notice how I entered only the word “Managers.” This will OVERRIDE the footer from the Department record. There will be only one copy for the manager; the technician doesn’t need one.

That’s it for the 2014 Friday Features. I hope you continue to follow our blog into the new year and that you, your family and your friends have a safe and happy holiday vacation.

Friday Features – Dynamic Footers for Purchase Orders

Last week, we talked about how you can define a footer for a purchase order in the Department record. This week, let’s talk about how you can override that footer, dynamically. What if I want to print some PO copies for a particular vendor, for say the month of November, but I don’t want 6 copies? Escape Online has got you covered there, too. This is a screen shot of the PO Copies activity. Notice how I have entered some search criteria and entered a new footer. The footer I entered will OVERRIDE the footer from the Department record. So when I get my list of purchase orders matching this criteria, “November PO Copies” will print as the footer, instead of Accounting or Receiving or whatever.

The footer prints just above the page numbers, like this.

Friday Features – Footers for Purchase Orders

Purchase orders obviously require copies. Sometimes all you have to do is print one for you and one for the vendor. Sometimes you have to send printed copies to a lot of different departments. Whatever your workflow, Escape Online has got you covered.
Escape Online uses “departments” to give organizations the opportunity to control requisitions, journal entries, invoices and purchase orders separately. Many of our customers will have a Business Department, a Purchasing Department, a Maintenance Department, you get the idea.

Along with defining the documents (requisitions, JEs, et al), the Department record has numerous options for the processing of those documents. In today’s Friday Feature, I want to show you how you can customize the footer of purchase orders.

Check it out. You can see that this LIVE example shows a complex footer. The trick here is the comma. When you define a footer for a purchase order in the Department record, the comma means, “make a separate copy.” See how I have pointed out the first two commas, and that the footer has several department names separated by commas. This means that when you print the PO, Escape Online will print two with no footer, one with the footer “RECEIVING,” one with the footer “ACCOUNTING,” and on and on. This particular customer prints 6 copies of each PO. That may seem like a lot, but Escape Online allows each of our customers to define what is appropriate for their workflow.

Pretty cool, but there’s more. Escape Online collates those copies for you, too! If more than one “group” is defined, Escape Online automatically collates the copies for you. That is, all of the receiving copies print first, then all of the accounting copies, and so on.

By defining PO Copy Options, you are setting up a default footer for printing purchase orders. Next week, we’ll talk about how you can override that default, dynamically changing those footers.

What about emailing, you ask?  Great question! While this mini-series of Friday Features will cover printing POs, we will be introducing the ability to email POs in 2015! Stay tuned.

Four Reasons Districts Are Switching to Web-Based Time & Attendance Systems

Odds are you aren’t lighting your hallways with torches. You aren’t using candles in the cafeteria or lanterns in the classrooms; electricity was discovered quite some time ago. And with that discovery came a new era of industry, innovation and opportunity. That era forever changed the way we work and is rivaled only by the innovation of the Digital Age.

Likewise, it’s no surprise that two-thirds of companies have embraced this new digital age by ditching old time and attendance tracking methods in exchange for web-based HR solutions. It is surprising, however, that a disproportionate number of school districts fall into that final one-third — those using outdated and risk-prone paper methods to track their time and attendance.

The good news is that each month, dozens of these school districts dip their toes in the electronic-time-and-attendance water (that sounds more dangerous than it is), and they’re saving a lot of time and money because of it.

Here are four reasons districts are tossing their paper and moving to web-based time and attendance systems.

Reason 1: Accountability

School districts that still use a paper time and attendance system have an unavoidable accountability problem. It’s no secret that employees can and have made mistakes on their timesheets or even intentionally misrepresented their time. Web-based time and attendance software increases the accountability of your employees by tracking the actual time they work. Timesheet approvers can see those actual time punches (and rounded time, if applicable) to get an accurate record of when their employees actually worked as well as what building they clocked in and out of in the case of a crime or emergency.

Unfortunately, school districts’ accountability problem does not end with employees submitting incorrect or falsified timesheets. Perhaps the most prevalent accountability problem districts report is that of their principals, secretaries or other timesheet approvers rubber stamping those erroneous timesheets. This is a people problem, one that no time tracking software can ultimately solve. But that doesn’t mean a time and attendance program can’t improve overall accountability.

Paperless timesheets carry a record of who has edited, submitted or approved a timesheet along with the exact time that action took place. In addition, you can require your approver to certify the validity of the information being approved, as well as to enter a digital signature PIN to confirm he or she is the person making the approvals. These measures can go a long way in ensuring appropriate work is put into evaluating each timesheet.

Reason 2: Compliance

A second problem school districts face is compliance. With the full effects of the Affordable Care Act (ACA, or Obamacare) looming, plus FLSA and FMLA regulations, districts are scrambling to prove their compliance.

The problem? A lot of districts can’t even claim with confidence that they are compliant. With large filing cabinets stuffed with paper records, proving compliance is at best a tedious process.

Dana Lang
A+ Charter Schools

“Before, we were required to keep about seven years of paper records in notebooks, in filing cabinets.”

Then throw in this fact: paper gets lost.

Liz Walton
Contoocook Valley School District

“Two years ago [we were] terrible at using the paper time slips. We would have inconsistency on people reporting their hours. We would have lost time slips that would appear months later because they were in interoffice envelopes that didn’t come to the right person. Time slips would not be signed or approved by the approvers.”

Auditors aren’t going to overlook these problems, and they won’t enjoy a long wait while you track down the records they’ve requested. This is one of the major reasons so many many districts, like A+ Charter Schools, have chosen to implement a web-based time and attendance system.

Dana Lang
A+ Charter Schools

“At this time, they keep it online for us, in the cloud. I don’t keep any paper records. Everything is online and virtual.”

Department of Labor audits are nothing to take lightly, especially once ACA regulations are in full swing. In response, many districts have elected to implement a web-based system along with regular internal audits to ensure they’re ready when the DOL comes knocking.

Reason 3: Efficiency

The third problem school districts face is that of simple efficiency. Managing even a small school district is no simple feat. You’ve got teachers, subs, aides, maintenance, custodians, food service, secretaries, principals and more — each spread across multiple schools — all reporting to your payroll department.

Let’s say you use a paper method for your time and attendance tracking; even in the best of scenarios  where all timesheets are approved and on time, and every location has been appropriately enforcing the same standards  you’re still left with piles of paper that you then need to verify and manually enter into your payroll system. That alone takes a lot of unnecessary manual work, and that’s assuming a best case scenario.

Liz Walton from Contoocook Valley School District says, “Part of our issues in collecting those time slips would be due to a delay of school, or a snow day, or even just because somebody is out. In those particular cases when that happens, I would spend time chasing down people, whether by phone or by email, trying to get a hold of whoever is missing to get me their information as soon as possible, which could also mean a day or two delay of getting it to me.”

Some school districts spend a disproportionate amount of time just tracking records down and reentering information from paper into their payroll system. That time is an expensive resource, and with web-based time and attendance software, you can reallocate that resource to other areas that don’t get enough time.

Dana Lang
A+ Charter Schools

“What used to take us about three weeks to do has now gone down to about three days on my campus users’ part, and when it gets to me, it was only about 15 minutes.”

Finally, and most obviously, a web-based time and attendance program makes your paper consumption more efficient. You’ve probably already figured out how. But does the word paperless scare you? Even if you’re just looking to cut down on your paper use, not get rid of it entirely, time and attendance software can go a long way in optimizing your process.

Lori Hobbs
Millsap ISD

“We were using a paper-based system, and to store the reports for our district, which is a small district, it took a whole file box to store a year’s reports and we had to cram it in there for it to even fit.  Now with the [web-based] system, I have a very nice report, and it probably fits in three inches for a whole year. So the consumption of paper is much better and we don’t have to have the storage that we did, because in small districts we don’t have storage places either.”

Reason 4: Accuracy

The fourth main problem school districts are facing (and one that directly informs the first three problems) is that of accuracy. You already know that paper timesheets require you to manually enter time into your payroll system, which is expensive in regard to time, but do you know how much it’s costing you in errors?

Nucleus Research, the American Payroll Association and the Aberdeen Group have all done studies showing that organizations overpay their employees by an average of 1.2% due to human error representing $120,000 in payroll errors for every $10 million in payroll wages. They have also shown that electronic time and attendance systems can eliminate up to 95% of this cost. How much could you save with 95% more accuracy?

Automatic savings, in combination with accountability, compliance and efficiency, make staying with antiquated paper time and attendance methods a costly mistake. Will you join the thousands of school districts that have already embraced the future of web-based time and attendance systems?

Friday Feature – Retirement Across the County

I want to focus on the reality of people having jobs at more than one district within a county. Just like Escape Online lets you see accounts across districts (and fiscal years), our retirement activities let you see employee retirement information across districts (and across fiscal and calendar years). The Person record in Escape Online ties the employment records of each district to a single individual record for both PERS and STRS processing. From this single activity, you can view employee demographics, assignments, retirement information and pay detail. It is super handy for researching. Check out the Assignments tab of the Person record, which shows all of the assignments and addons for an individual.

First, let’s look at a PERS member with assignments at two districts. Here we see the member has an assignment in the cafeteria at one organization and an assignment in custodial at another. Having assignments at multiple organizations is very common. At one of our LIVE customers, of their 26,748 active employees, over 2,447 had jobs at more than one district.

Of course, it isn’t just PERS members. Lots of substitutes work at multiple districts. Now, they don’t have “regular” assignments, they have what we call Addon Pay, or pay that is not associated with a position. In this example, we see that this person has multiple substitute jobs. She works as a Study Hall Substitute at orgs 618 and 616, and she works as a Substitute Teacher at orgs 603 and 618. And, she has been doing this for years.

It is all there, all the information you need, across the county, making your job easier.

Friday Feature – Dual Retirement

Not all employees fit into specific categories. Take for instance, this real-life employee at one of our customers. The employee is a Behavior Intervention Specialist and a substitute teacher. Now, that may not sound amazing, but it is because those two positions have different retirement plans. The Behavior Intervention Specialist requires membership in PERS and the substitute teacher requires membership in STRS. What is even more amazing is that Escape Online supports this person in being a member of both retirement systems. It is called, “Dual Retirement.” Check it out.

From the Persons record in Retirement, you see the employee has defined addons for these positions. (Addons are Escape Online’s way of tracking work that is not related to a position, like substitutes.)

In that same record, you see two retirement records, one for each retirement system. It is really that simple.  Just a few setup records and Escape Online does the rest. (You can see all of this setup from the Employee record, too!)

Finally, if we look at the employee’s payroll snapshot, we can see that Escape Online keeps track of each of the retirement systems separately, but completely.

Maybe say something like although not many employees are in multiple systems, those that are cause quite a headache for retirement techs. We go the distance for all our users.

Now, that really is amazing!

Friday Feature – Retirement Matrix Errors Built In

You know the old adage, “measure twice, cut once.” Well, I think that also applies to uploading files to retirement agencies. I mean why wait until AFTER you have generated a file to find out if there are errors?
There is no need to wait with Escape Online. We have built the STRS and PERS error matrices into the software, giving you a heads up, so you can fix those errors BEFORE you generate the file and upload it to the reporting agency.

Check it out.

pic_news_ff_PERSEditorMatrixErrorWhen you are in the PERS (or STRS) Editor activity, you can see that there is an error.

And, if you hover over the error, you can see what the error is.

Nice!

This type of error management is also built into Payroll Processing and the PERS and STRS Import activities (for importing retirement files from offline districts). This is a great time saver!

But, wait, there’s more.

pic_news_ff_PERSEditorMatrixErrorSearchNot only does the column on the list make it easy to find and fix the error, you can actually build a list that ONLY has errors.

The Has Errors flag on the search page allows you to focus your list on only those employees that have errors, making your list shorter and easier to manage.

Just think of the time savings, especially considering there were 1,712,404 retirement (PERS and STRS) lines processed in Escape Online in 2013.

Friday Feature – Editing Retirement Lines

When it comes to retirement, you want to make sure that the data you give to the PERS or STRS people is right. Sometimes that means that you have to make changes after payroll has been processed. Thank goodness, Escape Online gives you the ability to edit the retirement lines after payroll has been processed. In fact, not only does Escape Online allow specific users to edit the lines, it graphically displays the editing so that you can recognize it straight away.
Take this LIVE example as a case in point. There are two areas I want to point out on this screen capture. Let’s start with the giant red arrow. It is pointing to the last line, which is crossed out, the universally recognized font for deletion.

So, you guessed it. That last line item was deleted.  But why, you ask?

pic_news_ff_PERSEditorCrossedOutLines

Great question. Let’s focus on the highlighted area. We can see that the first highlighted line has the dates 3/1-3/31, and the second line has 3/24-3/31. The pay was correct so the error was not caught by the payroll technician, but the eagle-eyed retirement specialist caught it.

To change a retirement line is easy. All you have to do is edit it.  But, wait, you say, that seems kind of reckless.  No, not in Escape Online. If you edit a payroll-generated line, Escape Online automatically “copies” the line with the new information and “crosses out” the line with the old information for historical purposes.

Of course, you noticed that the screen capture was from PERS. Well, STRS works exactly the same way with one fabulous addition. If you move earnings forward (i.e., create a supplemental), Escape Online automatically crosses out the “original” information, alerting you that it has been moved forward.

Happy editing!

Friday Feature – Merging Resources

With LCFF (local control funding formula) a reality, you need an easy way to merge resources and other account components.  Escape Online has got you covered. We first started blogging about LCFF back in August of 2013, with Jacque’s LCFF, Changing Accounts, and You article.
Having been on the front lines of the SACS implementation in the late 1990s, we know how important it is to get your accounting right! We learned all we could then (and now) and worked with our customers to create software that provided an easy way to track and change account components.

Check it out.

First, we made it easy to change one component from one fiscal year to the next.  All you have to do is link the components with the Next and Prior fields. When you roll accounts forward at year end, Escape Online creates all of the correct accounts and updates requisitions, invoices, positions, etc., with the new accounts.

Under the hood, we have an “account link” that gives you the ability to get detailed historical information. So, if you want to see what happened over the last 10 years to an account with resource 0258, Escape Online can show that to you, automatically linking to the previous accounts with resource 6258.

But, wait, you say. That doesn’t seem so hard. The hard part is that LCFF requires us to merge multiple components (restricted) into one (unrestricted).

Ok. That does “sound” hard, but it isn’t. You simply enter the same number in the Next field for several components.

It is exactly the same as changing one. When you roll accounts forward at year end, Escape Online creates all of the correct accounts and updates requisitions, invoices, positions, etc., with the new accounts.

It’s that easy!