Special Year-End Edition! The Accounting Software Experts   --   Solutions from the Strategists
Year End 2002
A Note from Bob

The end of the year is quickly approaching and there are certain procedures that should be performed regarding MAS 90/200. In our efforts to continue to provide world-class service and keep you, our valued clients, in business, we have created this special edition focusing on Year End and Payroll processing issues. I cannot stress enough the importance of always performing a complete backup of your data before commencing any Period-End or Year-End procedures. Make a backup of your data files by using the SVDATA utilities. Instructions for SVDATA are located in the TRSG under Advanced Features, Copy Data Files Menu. If there are any system or hardware failures, you will be able to restore the backup and start fresh. The following tips should make your year-end close go much smoother. Remember, we are here to help you get through your Year End processing as smoothly as possible, so if you have any questions, please call us.

    Bob Herman, Vice President of Operations    


W-2 and Payroll Helpful Hints

Tax Table Update: If you are on a current Best Software subscription plan, you should automatically receive your tax table update at no charge in late December. Do not load it until after your 2002 W-2s have been run, but before the first payroll of 2003. Timing is critical! (See below for more options.)

Magnetic Media: If you are running W-2s for more than 250 employees and/or form 1099 for more than 100 vendors, the Internal Revenue Service requires that you file this information electronically. There is a module available for the Federal filing process. Contact Trish for more information.

Non-cash Fringe Benefits: In payroll, your non-cash fringe benefits must be calculated at the same time your last payroll for the year is processed. This will correctly calculate your non-cash fringe benefits and appropriate taxes relating to those fringes, for proper reporting to the IRS.

Important Tax Dates: Payroll W-2 and 1099 forms are due to employees and vendors respectively by February 1, 2003.

Payroll Hints: From the Payroll Setup menu, select Payroll options. Then select the "Retain year-to-date check history check box". This will allow printing of year-to-date earnings and withholding information on your employees' paychecks. You should also select the "Retain perpetual payroll history" check box. Quarter-end processing does not affect these field settings, but it is important to have these checked before updating any payroll checks.

W-2 Hints: MAS 90/200 requires that you print your 2002 W-2 forms before performing a year-end closing in the Payroll module, and before processing your first payroll for the new year (2003). This may be difficult if your first payroll for 2003 occurs before you are ready to print and process your W-2s. If you fall into this scenario, just follow these steps to resolve the problem:

  1. Enter and update all 2002 payroll information in your "live" company, making sure you still have the 2002 payroll tax tables installed.
  2. Back up your data!!
  3. Create a new company code in Company Maintenance (Library Master, Utilities) and label the company "2002 Payroll".
  4. Use the SVDATA utility program to copy data files for Payroll, General Ledger and the Magnetic Media modules from the "live" company to the newly created "2002 Payroll" company.
  5. Be certain to have the Quarter 1, 2002 and Quarter 1, 2003 payroll tax tables available.
  6. In the "live" company, perform the year-end processing in the Payroll module. When complete, verify that the Payroll options under the Setup menu reflects Quarter 1, 2003.
  7. Install the 2003 Payroll Tax Tables.
  8. Process your first and any subsequent payrolls for 2003 in the "live" company until ready to print W-2 forms.
  9. When ready to print W-2s and any other year-end reports for 2002, re-install the Quarter 1, 2002 Tax Tables, switch to the "2002 Payroll" company you created, print all W-2 forms and year-end reports.
  10. If applicable, process W-2 Magnetic Media reporting and verify that the file(s) were created.
  11. Re-install Quarter 1, 2003 Tax Tables before switching back to the "live" company to process additional payrolls for 2003.

Tax Forms: Be sure to order all of your tax forms early to ensure you have enough and you have them on time. If you need a source, contact Trish.

Review the Technical Reference & Support Guide (TRSG) under Year-End Procedures for complete detailed instructions on the Order of Closing Chart, Checklist, etc. To access TRSG on your workstation, go to the Start button, Programs, Best or Sage Software or MAS 90, then select TRSG.


General Ledger Helpful Hints

General Ledger Auto Budget: MAS 90/200 General Ledger has an option for an Automatic Budget. If you have this option turned on during year-end processing, your 2003 budgets will be created automatically. However, if you have already entered budget information for 2003, it will be overwritten during the year-end closing process. In order to prevent this from happening, prior to beginning your year-end close in General Ledger, go to General Ledger options and turn the Auto Budget option to "None." This will prevent any budget that was set up for 2003 from being written over.

General Ledger Number of Years to Retain Transaction History: There is an option for Number of Years to Retain Summary History under General Ledger | Options. You want to be sure that both of these are set for at least three years in order to retain the information. Be sure to look at this option prior to beginning your year-end close, as you could unintentionally lose some history.

If you want prior year comparison(s), the two following conditions must be met: The "Number of Years to Retain Transaction History" field in GL options should be set to at least three years, representing the current year and two prior years.

The "Number of years to Retain Summary History" field in GL Options should be set to at least three years. This field can be set as high as "99".  If set to "1", the transaction and summary history will be removed during year-end processing.

In GL options, the Journal Number Reset field defaults to "Year End". If you do not want the Register and entry numbers to be reset to "one" at year-end, set the Journal Number Reset field to "Do not reset."

Congratulations to the following winners of the Fall Newsletter Jumble puzzle:

  • Warren Coleman of Losurdo Foods
  • Norma Bugle of Metrus Group, Inc.

    The Jumble answer was: Disaster Recovery


    Computer Prayer

    Guide my keystrokes,
    Keep my programs alive,
    Protect me from viruses,
    Back up my drive.

  • SSI Holiday Closings

    December 24th at noon
    December 25th
    December 31st at noon
    January 1st


    From all of us to all of you, we wish you a safe, healthy, happy and a very merry!


    Solution Strategists LLC
    312 North Avenue East · Suite 7 · Cranford, NJ 07016
    908.276.2270 · fax: 908.272.5404
    e-mail: info@solstrat.com
    website: www.solstrat.com