Your MAS90 & MAS200 Accounting Software Experts




 

 

Tech Notes - Year End Closing

The Mariner - December 2003

Order of Closing

 

This chart provides an outline of the processing order for MAS 90/200  applications during year end. The order logic assures an application that writes to another application is processed first.

 1System Wide Backup

 2B/M – Bill of Materials

 3W/O - Work Order

 4B/C - Bar Code

 5P/O - Purchase Order

 6S/O - Sales Order

 7I/M - Inventory Management

 8M/P - MRP

 9T/C - Timecard

10. M/R - Magnetic Media

11. P/R - Payroll

12. A/R - Accounts Receivable

13. A/P - Account Payable

14. J/C - Job Cost

15. G/L - General Ledger

1099s: Some Hints & Facts

For information on printing 1099s with a laser printer, review the document AP3000-ABC on BOSS.

  • MAS 90/200 only supports 1099-Misc, 1099-Div, and 1099-Int.
  • MAS 90/200 does not support the 1096 Summary and Transmittal of U.S. Information Returns.
  • MAS 90/200 does not support the 945 Annual Return of Withheld Federal Income Tax.

Accounts Payable Year End

Make a backup of your Accounts Payable data files prior to performing End of Year processing. If there are any system or hardware failures, you will be able to restore the backup and start fresh.

To preserve data integrity, such as “period to date” and “year to date” information, do not post to more than 2 periods. For example, if you are on a calendar year, you will want to close the year before posting to February.

The following settings adversely affect vendor detail history for invoices and checks:

Number of days to retain Paid Invoices: The system purges paid invoices from the A/P Open Invoice file and the A/P Invoice Transaction History file that have a payment date prior to the specified number of days.

You can retain a maximum of 999 days (2.74 years) of paid invoices.

Number of months to retain Check History: The system purges the A/P Check History file of any checks dated prior to the specified number of months. You can retain a maximum of 99 months (8.25 years) of check history.

General Ledger Year End

  • Make a backup of your General Ledger data files prior to performing End of Year processing. If there are any system or hardware failures, you will be able to restore the backup and start fresh.
  • If you want prior year comparison(s), the two following conditions must be met.
    1. The “Number of years to Retain Transaction History” field in G/L Options must be set to at least "2".
    2. The “Number of years to Retain Summary History” field in G/L Options must be set to at least “2”.

This field can be set as high as “99”. If set to “1”, then transaction and summary history will be removed during Year-End Processing.

Note: 1 year is the current year only, 2 years is the current year

and 1 prior year.

  • 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.”
  • In GL options, the Auto Budget Option field defaults to “Current Year”. If you have already entered budget information for the future year, make sure the Auto Budget Options field gets set to “None.”

Payroll Year End

  • The Payroll module is based on a calendar year. There is no future period in Payroll. You cannot post a payroll in process with a check date in a future quarter until the current quarter is closed by selecting Quarter/Year-end Processing from the Period End menu.
  • Payroll Year-end Processing in MAS 90 can only be “reversed” by restoring data from a current backup.
  • Reopening a year is not allowed. Data for the current year is cleared during Year-end Processing with the exception of Perpetual History files. Always keep a current back up.
  • Do not perform Payroll Period-end Processing until the W-2s are printed and Magnetic Media has been processed. Keep a backup of the data for future use prior to closing, if needed.
  • Tax tables are system-wide files. PR_09.SOA, PRU.SOA, PRV.SOA, AND PRW.SOA are stored in the PR directory with the Payroll module program files. All companies on one MAS 90 system use the global tax table files. The only exceptions to this are the following Tax Table Maintenance fields:

Company Tax ID Number (federal, state, and local)

G/L Accrual Account (federal, state, and local)

Unemployment Tax (state and local)