Archive Locally to Minimize Problems

While users can usually archive data across their network, running the program on their local workstation on the data folder located on the server, this involves pushing and pulling massive amounts of data over your local network, in thousands of operations and processes.  This tends to require much more time to process since pushing and pulling that data over the network is inherently slow. Sometimes networks fail to make a connection reliably, and this can cause the archiving process to fail.

There are two ways to get around these potential problems:

• Perform the archiving process from the server’s desktop, rather than a workstation. This eliminates entirely the network’s effect on the process, or
• Copy the company data folder to your workstation’s C:\MB7 folder.  Perform the archiving process on the copy of the company residing on your C: drive, and then copy the two resulting data folders – the cleaned up current company data folder and the new archive folder—back to the server.

Users working in a cloud configuration typically are not presented with network speed or reliability issues and can ignore this tip.

For assistance with archiving data, give us a call at 480-471-5305 or send an email to walt@mathiesonconsulting.com.

Backup before Archiving!

The archiving process, whether for payroll closing or archiving the general ledger, is a destructive process.  Every discussion of archiving starts with an admonition to back up (twice for safety) your data .

Most users have invested in significant backup systems and processes that they rely on to prevent catastrophic loss of critical data.  Too many of these same users do not regularly test the backup process to ensure that their backups are effective and able to be restored easily and quickly.

Too often we find that users are relying on these overnight backups as their only backups when archiving their data.  If they have a problem with their archiving process—and problems do occur—they must restore from backup and start the archiving process over again. And since they have relied on their outside networking consultant to administer the backup process, they must wait for the networking consultant to restore the data from the overnight backup, losing valuable time in the process.  And this is NOT the time to find out that your overnight backups haven’t been working properly!

The easiest, and most expedient, way to make a quick and restorable backup is to use Windows Explorer to copy the current company data folder and paste it onto your workstation’s desktop or some other location in your network.  To ensure that no one has any files open that may not copy properly, just log into the company with Sage 100 Contractor with Exclusive Access, and then log out to make your “copy and paste” backup.  If the archiving process has any problems, you can easily recover by deleting the file folders affected by the failure and restoring the data folder from the “copy and paste” backup data folder.

Backups when archiving are important to cloud users also.  Check with your cloud hosting provider to ensure that you can make a quick and easy “copy and paste” backup as well.

Give us a call at 480-471-5305 or email walt@mathiesonconsulting.com if you have any questions or need help.

Closing Out the Year

With the introduction of multiyear general ledger functionality in version 19 of Sage 100 Contractor, year-end closings have become much more relaxed.  No longer do we have to worry about closing the general ledger before we can record any transactions relating to the new fiscal year, and no longer do we have to understand how Period 0 postings work.

However, let’s not get too relaxed….  The Payroll Year must still be closed and a 2015 Payroll Archive must still be created! Fortunately, this is not a terribly difficult or time consuming process, but you have to time it correctly.

In December

• Ensure that you have the latest version of the program, currently version 19.6.54, installed.
• Ensure that your employee names, addresses and social security numbers are up-to-date.
• Determine with your tax advisor or benefits administrator whether you will be required to file forms 1094-C and 1095-C to comply with the Affordable Care Act.  If so, ensure that the monthly data is present and up to date on the ACA Tab of the 5-2-1 Employees records.  Doing this before the Close Payroll Year process will help you avoid making entries twice.
• Run 5-3-7 Payroll Audit regularly and ensure that any audit errors are corrected.
• Be aware that you may receive information from payers of Third Party Sick Pay that can affect your payroll tax reporting.  Ensure that any notices received have been properly reflected in your payroll records.
• Determine with your tax advisor that all amounts that should be reported on W-2 forms have been included, including taxable vehicle allowances and certain taxable benefits for owners.  Also review which payroll calculation amounts may have to be reflected on the W-2 forms.

After the Last 2015 Payroll is Processed and Before Any 2016 Payroll Records are Entered

• Run 5-3-7 Payroll Audit and ensure that there are no audit errors.
• Make a complete backup of the current company’s data folder.
• Decide ahead of the closing how you will name the 2015 Payroll Archive folder.
• Decide ahead of the closing whether you want to remove employee records for workers that have left the company.
• Log into the current company as Supervisor with Exclusive Access.
• Run 5-3-8 Close Payroll Year and follow the prompts and instructions carefully. It’s really rather simple!

Remember – prepare your 4^th quarter payroll returns and your W-2 and W-3 forms from your 2015 Payroll Archive company.

Contact us at 480-471-5305 or walt@mathiesonconsulting.com for additional information or assistance with closing your payroll year.

Current Version Information

The latest version of Sage 100 Contractor is version 19.6.54, the release of which was announced on October 1, 2015. In addition to getting the most up to date tax tables, there are changes to the program to accommodate compliance with the Affordable Care Act.

Fall Maintenance

Look at the calendar! The end of the calendar year is fast approaching. There are a few things that Sage 100 Contractor users should start working on so that the end of the calendar year goes smoothly.

Affordable Care Act Compliance
Make sure you know what your responsibilities are for reporting and compliance with the Affordable Care Act. Check with your tax accountant and your benefits provider to get the best information about your responsibilities. Current versions of Sage 100 Contractor will generate the data and forms required.

Form W-2 Wage Statements
Make sure that your employee data is up to date. Verify employee addresses and social security numbers. Make sure your payroll account bank reconciliations are current and complete (and thus all payrolls are recorded), and investigate why payroll checks are still outstanding long past the time you would expect. Run the Payroll Audit (menu 5-3-7) and ensure that all errors are corrected. Discuss with your tax accountant what payroll calculations should be shown in which boxes on the W-2s.

I am a huge fan of the built-in Aatrix E-File feature, especially for W-2s. Aatrix will print and mail all employee copies of W-2s and will submit electronically the data to the Federal and State governments. All you need to print is the employer copy for your records and that can be printed to plain paper. With Aatrix E-File, you don’t have to order preprinted forms and special envelopes. The cost of the Aatrix E-File W-2s is so reasonable when you consider the cost of acquiring the forms, applying postage, and the manual labor of stuffing special envelopes, I strongly endorse E-Filing.

If you do not wish to use the Aatrix E-File feature, you should order now the forms and envelopes required from Sage Checks and Forms. DO NOT plan on getting your forms from Staples or other office supply stores as the paper (4-up perforated paper) and envelopes are not typical.

Form 1099 Statements to Recipients
Make sure that your vendor data is up to date. Obtain W-9s from all vendors so that you can verify addresses, federal identification numbers and legal status, such as corporations, individuals, limited liability companies, partnerships, etc. With this information, you can then ensure that each vendor has the correct 1099 Type assigned. Use report 4-1-1-61 Vendor 1099 Report to see the 1099 Type of each vendor and whether or not you have a federal identification number for those vendors to whom you may be required to provide a 1099.

The built-in Aatrix E-File feature also works for 1099s! As you might guess, I’m a big fan of this feature as well. The comments above about W-2 E-Filing also apply to 1099 E-Filing.

If you do not wish to use the Aatrix E-File feature, you should order now the forms and envelopes required from Sage Checks and Forms. DO NOT plan on getting your forms from Staples or other office supply stores as the paper (4-up perforated paper) and envelopes are not typical.

If you have any questions or concerns, don't hesitate to send us a note or give us a call.

Current Version Information

The latest recommended version of Sage 100 Contractor is version 19.6.54, the release of which was announced on October 1, 2015. Give Mathieson Consulting a call if you have a current support contract and want assistance with the update.

Don’t Forget to Audit Payroll!

All too often, I find that clients forget to run 5-3-7 Payroll Audit before preparing to pay their payroll tax liability or preparing payroll tax returns.  Payroll Audit is a handy utility that compares amounts actually withheld and accrued for FICA and Medicare Taxes with what should have been withheld.  It also identifies payroll records that have not been completely processed or processed with conflicting payroll quarters compared to payroll check dates. If you use the Repair option, the system will reconstruct the control totals on the employee records – this will correct any misposted or partially posted payroll records before it actually audits the payroll records. The Repair option takes longer than just running the Payroll Audit (this makes sense because it performs both the reconstruction of control totals and the auditing of payroll), but the extra time is usually worth it.  Always run the Payroll Audit with Repair and resolve any issues indicated, before computing the amount of payroll taxes to deposit or preparing payroll tax returns.

Since we’re talking about preparing payroll tax data, remember to always run your payroll tax reports by check date, not by period ending date.  The tax authorities want all of their payroll data reported by check date.

If you find that payroll audit errors exist, contact Sage Tech Support or call Mathieson Consulting at 480-471-5305 for assistance.