General Module Closing For Sage ERP MAS 90 And 200

Here we provide general module closing procedures for the most common modules. For your convenience we indicate the version that a module was updated to the Business Framework. Modules that have not been updated to the Business Framework maintain buckets of data by year (year-to-date, prior-year, etc.). These data receptacles are initialized during year-end processing, so year-end processing is time sensitive and must be performed in the first month of the new year. Regardless of your version, the Payroll module is the most time sensitive when it comes to year-end processing because there is no future period. Use this document as a guide. If you are using Paperless Office, we highly recommend that you save time, paper, and filing cabinet space by using the Period End feature to electronically archive the reports.

Purchase Order

To Business Framework in Version 4.4

Ideally, Sage ERP MAS 90 and 200 Purchase Order Year-End Processing should be performed before any transactions are updated for the new year. If that is not possible, remember that for Versions 4.3 and prior that the future posting capability for Purchase Order is limited to one accounting period beyond the current period. Failure to close Purchase Order before the end of that one future period will cause the summarized totals for the current or future period to not match the transaction detail reports. If you have upgraded to Version 4.4, the limit of one future accounting period no longer applies.

1. Before closing the Purchase Order module for the year, be certain that:

• All purchase orders for the prior year have been entered.
• All receipts, invoices, returns, and issues have been entered and updated.
• The current Purchase Order date agrees with the period-end date.
• A backup of Purchase Order files is made.

2. From the Reports Menu the following reports should be created and retained:

• Open Purchase Order
• Open Purchase Order by Item (optional)
• Purchases Clearing by Item and by Product Line Reports (should reconcile to the General Ledger Control account)
• Cash Requirements (optional)
• Receipt History
• Purchase History
• Purchase Order Recap (optional)

3. The Purchase Order Full Period and Year-End Processing performs the following housekeeping tasks:

• Sets the PTD and YTD quantity and dollars purchased fields to zero.
• Removes completed purchase orders according to the number of days designated in the Purchase Order Setup options.
• Removes master and repeating orders that have expiration dates on or prior to the period-end date from the open purchase order file.
• Advances current period in Purchase Order Setup Options to the next period and year.

 

Sales Order

To Business Framework in Version 4.1

Ideally, Sales Order Year-End Processing should be performed before any invoices are updated for the new year. If that is not possible, remember that for Versions 4.0 and earlier the future posting capability for Sales Order is limited to one accounting period beyond the current period. Failure to close Sales Order before the end of that one future period will cause the summarized totals for the current or future period to not match the transaction detail reports. Sales orders may be entered with a date of the new year without adverse consequence.

1. Before closing the Sales Order module for the year, be certain that:

• All Sales Order invoices for the current year have been entered and updated.
• The current Sales Order date agrees with the period-end date.
• A backup of the Sales Order data files has been made.

2. From the Reports Menu the following reports should be created and retained:

• Open Sales Orders
• Open Orders By Item (optional)
• Back Order (if applicable)
• Customer Sales History (optional)
• Monthly Recap (optional)

3. The Sales Order Full Period and Year End Processing performs the following housekeeping tasks:

• Resets the PTD and YTD Sales, Cost of Goods Sold, and Quantity Sold fields in the daily and monthly Sales Recap files to zero.
• Resets the periods for current year, quantity shipped, dollars sold, and cost of goods sold; and moves current year Quantity Sold to Prior Year Quantity Sold in the Sales Order Customer Sales History file.
• Removes master and repeating orders from the open sales order file that have expiration dates on or prior to the period-end date.
• Advances current period in Sales Order Setup Options to the next period.

Inventory Management

To Business Framework in Version 4.4

Ideally, Inventory Year-End Processing should be performed before any transactions are updated for the new year. If that is not possible, remember that for Versions 4.3 and prior that the future posting capability for Inventory Management is limited to one accounting period beyond the current period. Failure to close Inventory Management before the end of that one future period will cause the summarized totals for the current or future period to not match the transaction detail reports. If you have upgraded to Version 4.4, the limit of one future accounting period no longer applies.

The Inventory year-end process should occur immediately after Purchase Order and Sales Order year-end processing and before Accounts Receivable year-end processing.

1. Before closing Inventory for the year, be certain that:

• All adjustments have been entered and registers updated.
• Current Inventory date agrees with period-end date.
• A backup of Inventory files has been made.

2. From the Reports Menu the following reports should be created and retained:

• Inventory Trial Balance (should tie to the inventory accounts on the G/L Trial Balance for the same period).
• Stock Status (quantities reflect day printed).
• Inventory Valuation (it should tie to G/L inventory account as of the day it is printed).
• Inventory Negative Tier Adjustment (from Period-End Menu). Be certain to update this report.

Note: Any negative tiers should be resolved before closing and making any new year entries.

3. The Inventory Full Period End and Year End Processing performs the following housekeeping tasks:

• Calculates beginning average cost (by item by warehouse) and average on-hand quantity.
• Resets PTD and YTD quantity sold and issued, quantity returned, dollars sold, and cost of goods sold.
• Moves current year information to prior year fields in the Inventory Item Warehouse Detail file.
• Removes any zero quantity costing tiers for LIFO, FIFO, Lot, or Serial items (if applicable).
• Advances current period in Inventory Setup Options to next period and year.

To perform year-end processing, select the option Full Period End Processing. This ensures that the ending period is the last period of your year.

Payroll

The Payroll module is based on a calendar year. There is no future period in Payroll. You cannot post a payroll with a check date in a future quarter until the current quarter is closed by selecting Quarter and Year End Processing from the Period End menu. Before proceeding with year-end processing, make sure the Quarterly Governmental Report, Quarterly 941 Form, and employee W-2 forms have been printed. Consider creating a company to archive your 2011 information and review yearend update information (see page 3).

1. Before closing the Payroll module for the year, be certain that:

• All payroll cycles have been entered and updated for the quarter.
• All checks written during the quarter (including manual) have been entered and updated.
• Payroll System Date is set to the last day of the calendar year.
• Proper year tax tables are installed (2011 for 2011 Year-End Processing).
• W-2 forms are printed and verified.
• Electronic Reporting files, if applicable, are processed and created.
• A backup of the payroll files has been made. Check and double-check the backup.

2. The following reports should be created and retained:

• Quarterly Tax
• Payroll Check History
• Quarterly Pay Period Recap
• Earnings
• Deductions
• Quarterly Governmental
• Quarterly 941 Form
• Benefit Accrual
• Workers’ Compensation

3. Be certain to reconcile QTD and YTD totals on all reports.

4. Payroll Period-End Processing performs the following housekeeping tasks:

• Resets the QTD and YTD employee fields to zero.
• Increments the current year to the next year.
• Changes the current quarter from 4 to 1.
• Resets employee benefit limits according to Payroll Options Setup.
• Resets Pension Plan, Cafeteria Plan Deduction, Allocated Tips, Fringe Benefits, Non-Qualified Plan, and Dependent Care Benefits fields to zero.
• Sets all quarterly/yearly reports to zero.
• Removes check history and perpetual history depending upon your system settings.
• Purges terminated employees.
• Purges standard deductions that have met goals.

Once you have completed year-end processing for Payroll, be certain to install the Q1 2012 TTU (tax table update) for 2012 before the first payroll run of the year.