year end closing procedures for 2013 sage 100...

Year End

Closing

Procedures for

Sage 100 ERP

2013

Martin &

Associates

MENU

Best Software, Inc. NEXT TOP MAS 90®

MAS 90•MAS 200 Order of Closing

Order Own Closed Module

1 System Wide Backup

2 B/M – Bill of materials

3 W/o – Work order processing

4 B/C - Bar Code

5 P/O - Purchase Order Processing

6 S/O - Sales Order Processing

7 I/M - Inventory Management

8 M/P - Material Requirements Planning

9 T/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

This chart provides an outline of the processing order for MAS90 applications during Year End. The order logic assures an application that writes to another application is processed first.

FOR EXAMPLE: Sales Order Processing, which can post to I/M, A/R and G/L should be fully processed and closed before I/M, A/R or G/L.

Some applications can send information, in addition to receiving information from another application.

FOR EXAMPLE: J/C can post invoices to A/R; A/R can post invoices to J/C. Therefore, both J/C and A/R should be processed prior to closing either application.

The first step to take in processing Year End is to make a backup of your company data. Year end in MAS90 can only be “reversed” by restoring from a backup.

Show/Hide All

Overview Use Period End Processing to close the current period and cycle the accounting period forward to the next period. Period-end processing is usually performed at the end of each accounting period, on the last business day of each month. Year-end processing takes place automatically when period-end processing is performed for the last period of the fiscal year.

Before You Begin

� Do not close a fiscal year until all adjustments are made and financial statements are produced. Because you can post transactions to future fiscal years, keeping the prior year open does not prevent normal processing.

� For more information about tasks that should be completed before you begin period-end or year-end processing, see Period-End and Year-End Processing Checklist.

� The reports and financial report groups to print during period-end or year-end processing should have already been selected in the Period End Report Selection window.

Use one of the following methods:

� To perform period-end or year-end processing in the General Ledger, Accounts Receivable, Accounts Payable, and Sales Order, Inventory Management, and Purchase Order modules

� To perform period-end or year-end processing in all other modules

To perform period-end or year-end processing in the General Ledger, Accounts Receivable, Accounts Payable, Sales Order, Inventory Management, and Purchase Order modules

NOTE The number of years to retain transaction history after year-end processing is determined in the module's Options window.

1. Select the module's Period End menu > Period End Processing.

2. In the Period End Processing window, verify that the correct period is displayed. If the correct period is not displayed, change the period in the module's Options window.

3. Select the Print Period End Reports check box to print period-end or year-end reports. For more information, see Period End Processing - Fields.

4. Click Proceed.

5. In the General Ledger module, if you have not posted cycle allocations before beginning period-end or year-end processing, you are prompted do to so. Select one of the following options:

� To post allocations before completing period-end or year-end processing, click No. For information about selecting and posting allocations, see Select Allocations for Posting. After you have posted allocations, continue to the next step.

� To continue with period-end processing or year-end processing without posting allocations, click Yes and continue to the next step.

6. If you selected the Print Period End Reports check box in step 3, the Period End Reports window appears. Complete the following steps in the Period End Reports window:

a. At the Report Name and Report Setting/Financial Group fields, verify the reports and financial report groups to print. For more information, see Period End Reports - Fields. The reports and financial report groups displayed were selected in the Period End Report Selection window.

b. At the Copies field, enter the number of copies of each report and financial report group to print.

c. Select the Default Printer check box to print the report to the default printer assigned to the selected report setting.

Perform Period-End and Year-End Processing

Home | FAQs & Troubleshooting

Page 1 of 3Perform Period-End and Year-End Processing

12/9/2010mk:@MSITStore:c:\program%20files%20(x86)\common%20files\sage\common%20comp...

d. Select the Print check box for each report and financial report group to print. Click Print.

NOTE If you select Preview, all reports will be previewed regardless of the saved printer for the report. After the reports are previewed, you are taken back to the menu. You must print the reports to complete period-end processing.

7. You are prompted to confirm that the closing period will be changed to the next open period. Click Yes to complete period-end or year-end processing.

After you perform this procedure, the following occurs:

If you performed period-end processing The current accounting period is closed, and the accounting period is cycled forward to the next open period. In addition:

If you performed year-end processing The current accounting period is closed, and the accounting period is cycled forward to the next open period.

NOTE If the next fiscal year has not been created, year-end processing will create the next fiscal year and recalculate beginning balances. The Years to Retain General Ledger History field in the General Ledger Options window is used to determine the number of years to retain General Ledger transaction history after year-end processing.

In addition:

To perform period-end or year-end processing in all other modules

1. Select the module's Period End menu > Period End Processing.

2. In the Period End Processing window, select the period end option that you want to perform. The available options depend on the current module. Period end options typically include purging transaction files for any number of periods (up to but not including the current period) to save file space.

If.... Then....

Period End is selected at the Reset Journal Numbers field in the General Ledger Options window

journal numbers are reset.

Period End is selected at the Reset Register Numbers field in the General Ledger Options window

register numbers are reset.

If.... Then....

Year End is selected at the Reset Journal Numbers field in the General Ledger Options window

journal numbers are reset.

Year End is selected at the Reset Register Numbers field in the General Ledger Options window

register numbers are reset.

The Copy Actual to Default Budget at Year End check box is selected in the General Ledger Options window

the actual amounts of the closed fiscal year are copied to the default budget of the current fiscal year.

The Clear Balances at Year end checkbox in the Main Account Maintenance window is selected

balances are cleared for nonfinancial accounts.

There are General Ledger account numbers, main accounts, and/or defined sub accounts that have a status of Delete, and have no activity for the closing fiscal year

the deleted accounts are removed, as well as any memos for those accounts.



NOTE When performing Period End Processing, verify that the accounting date agrees with the period-end date through which you want to clear files.

2. Click Proceed.

3. In the Period End Confirmation window that appears, click Proceed.

4. If you selected the Full Period End Processing or Full Period and Year End Processing options, the Period End Reports window appears. Select the report(s) that to print and click Print.

5. A message dialog box appears prompting you to complete Period End Processing. Click Yes to complete Period End Processing.



Show/Hide All

Overview You can select reports and financial report groups to print for period-end and year-end processing. The selected reports can be printed before or during period-end or year-end processing. When you perform period-end processing, only the reports selected in Period End Report Selection are available for printing. You can also print a listing of all selected reports and report groups.

NOTE This procedure applies only to some modules.

Before You Begin The reports and financial report groups displayed in the Period End Report Selection window have already been defined.

� You can set up a report setting for each report with options and selection criteria for period-end and year-end reporting purposes. For more information, see Create a Report Setting.

� You can set up a financial report group in the Financial Report Group Maintenance window in the General Ledger module. For more information, see Create Financial Report Groups.

To select period-end and year-end reports

1. Select module's Period End menu > Period End Report Selection.

2. In the Period End Report Selection window at the Report Name field, select a report or financial report group. For more information, see Period End Report Selection - Fields.

At the Report Setting field, enter a report setting or financial report group to print. For reports, the report setting must already be defined for the report.

NOTE For financial report groups in the General Ledger module, the financial report group must already be defined in the Financial Report Group Maintenance window.

3. At the Copies field, enter the number of copies of the report or report group to print.

4. If you do not want to use the default printer saved with the report or financial report group, clear the Default Printer check box. Click Accept.

Reports and financial report groups are selected to print during period-end or year-end processing.

Select Period End Reports


Page 1 of 1Select Period End Reports


Select General Ledger Period End menu > Period End Processing.

Use Period End Processing to automatically perform either period-end or year-end processing based on the period entered at the Current Period field in the General Ledger Options window.

Period End Processing allows you to close the current period and cycle the accounting period forward to the next period. Period-end processing is usually performed at the end of each accounting period. Year-end processing takes place automatically when period-end processing is performed for the last period of the fiscal year.

NOTE Fields in the General Ledger Options window are used to determine the current accounting period and number of years to retain transaction history after year-end processing.

The following occurs during period-end or year-end:

� Accounts with a Deleted status can be removed during year-end processing based on activity and the selection to retain history in General Ledger Options.

� Any accounts with no activity are automatically removed.

� If the Copy Actual to Default Budget at Year End check box is selected in the General Ledger Options window, the actual amounts for the closed fiscal year are copied to the default budget for the current fiscal year.

� Options for resetting journal numbers are performed.

� If the Clear Balances check box in Main Account Maintenance is selected for a main account value, balances are cleared for nonfinancial accounts at year end.

� If retaining transaction history, all current year transaction information is updated and any transaction history with no current year activity is removed based on options selected in General Ledger Options.

If you have not already posted allocations before performing period-end processing, you are prompted to post them. If you have not already printed period-end reports, you can do so during period-end processing. You can also select and print period-end reports without accessing Period End Processing using Period End Report Selection.

WARNING Backing up your data is an important part of your daily and monthly procedures. Back up all General Ledger data before proceeding.

Window Details How Do I...

Navigation Perform Period-End and Year-End Processing

Overview

Fields

Related Topics

Allocation Selection Settings Period End Report Listing

Allocation Selection Complete Period End Processing

Period-End and Year-End Processing Flowchart General Ledger Options

G/L Period End Reports G/L Period-End and Year-End Processing Checklist

Period End Report Selection System FAQs

Navigation

Overview

Fields Print Period End Reports

G/L Period End Processing


Page 1 of 1G/L Period End Processing


Do not close a fiscal year until all adjustments are made and financial statements are produced. Because you can post transactions to future fiscal years without closing the prior year, keeping the prior year open does not prevent normal processing.

Before completing period-end or year-end processing, perform the following steps:

1. If you are performing year-end processing, select the Copy Actual to Default Budget at Year End check box in the General Ledger Options window, and create a new default budget for the next fiscal year. For more information, see Copy Actual Figures to the Next Fiscal Year Budget.

2. Back up the General Ledger files.

3. Verify that all activity and adjustments in modules integrated with General Ledger have been completed for the current period.

4. Print and update the Recurring Journal.

5. Print and review the General Ledger Worksheet.

6. Enter any closing adjustments for the period using General Journal Entry.

7. Print and update the Daily Transaction Register.

8. Make any necessary budget revisions using Budget Revision Entry, and update the Budget Revision Register.

9. Print the Trial Balance and Standard Financial Statements for the period, and verify that the Balance Sheet is in balance.

10. Print the General Ledger Analysis (if necessary).

11. Print the General Ledger Detail Report. If you are closing the year, print the report for all periods.

12. Select allocations to post and decide whether to post all required allocations now or during period-end processing or year-end processing. For more information, see Select Allocations for Posting.

13. Decide whether to print period-end reports now or during period-end processing. For more information, see Select Period End Reports.

G/L Period-End and Year-End Processing Checklist


Page 1 of 1G/L Period-End and Year-End Processing Checklist


Show/Hide All

Overview You can select allocations to post before or during period-end processing. If you do not post allocations before period-end processing, you are automatically prompted to do so during period-end processing. When selecting allocations, you can enter separate source journals for financial and nonfinancial allocation entries, and change the source amount of the allocation distribution. You can also modify the source amount and drill down for more information about individual allocations before posting them.

Allocation entries assigned to period-end cycles in Allocation Entry are automatically selected at the end of each period. Entries with a quarterly cycle are selected at the end of periods 3, 6, 9, and the final period of the fiscal year. Entries with the annual cycle code are selected only at year end. Manual allocations must be selected using General Journal Entry on the Main menu.

Before You Begin

� You must have already defined allocation entries in Allocation Entry, located on the Main menu.

� Only allocation entries assigned an allocation cycle of Period, Quarterly, or Annual in Allocation Entry can be selected in Allocation Selection Settings. Allocations with a Manual allocation cycle must be selected in General Journal Entry on the Main menu. To post manual allocations, see Perform a Manual Allocation.

To select allocations for posting

1. Select General Ledger Period End menu > Allocation Selection. The Allocation Selection Settings window appears.

2. In the Allocation Selection Settings window at the Fiscal Year and Period fields, select the fiscal year and period for posting allocations. Allocations can only be posted to open periods. For more information, see Allocation Selection Settings - Fields.

3. At the Posting Date field, enter the date when allocations will be posted.

4. In the Financial Allocations section, at the Source Journal and Starting Journal Number fields, enter the source journal and starting journal number to use for financial allocations.

5. In the Non-Financial Allocations section, at the Source Journal and Starting Journal Number fields, enter the source journal and starting journal number to use for nonfinancial allocations.

6. Click Proceed. The Allocation Selection window appears.

7. In the Allocation Selection window, view and edit allocations as necessary using any of the following options:

� To change the source amount for an allocation to a manual amount, enter an amount at the Source Amount field. To change the source amount to the current balance or current activity of the source account, select the allocation and then click the Current Balance or Current Activity buttons. For more information, see Allocation Selection - Fields.

� To change the posting comment for an allocation, enter a new amount at the Comment field.

� To reset the selected Allocation Selection fields, click Reset Row. To reset all Allocation Selection fields, click Reset All Rows.

NOTE Clicking Reset will not update the allocations with any source amount changes that have occurred since they were selected. To update all allocations for the selected period, you must click Clear and then select the allocation settings again in the Allocation Selection Settings window.

� To return to the Allocation Selection Settings window without saving your changes, click Clear. This clears all allocation selections, including any changes made to source amounts.

Select Allocations for Posting


Page 1 of 2Select Allocations for Posting


� To view details about an allocation, select the allocation and then click the Allocation Detail button to display the Allocation Drill Down window. Click OK to return to the Allocation Selection window. For more information, see Allocation Drill Down - Fields.

8. Click Accept to save your allocation selections.

Allocation entries that were assigned a period-end, quarter-end, and/or year-end allocation cycle in Allocation Entry are selected for posting, and allocation amounts are calculated. For information about posting the allocations, see Post Allocations.

Page 2 of 2Select Allocations for Posting


Show/Hide All

Overview You can post allocations before or during period-end processing; however, only allocations for the fiscal year and period selected in the Allocation Selection Settings and Allocation Selection windows can be posted. If you do not post the selected allocations before period-end processing, you are prompted to post them during period-end processing.

Before You Begin

� You must have already selected allocations for posting in the Allocation Selection Settings window and Allocation Selection windows. For more information, see Select Allocations for Posting.

� Only allocation entries assigned an allocation cycle of Period, Quarterly, or Annual in Allocation Entry can be posted using the Allocation Journal. Allocations with a Manual allocation cycle must be posted in General Journal Entry on the Main menu. To post manual allocations, see Perform a Manual Allocation.

To post allocations

1. Select General Ledger Period End menu > Allocation Journal.

2. In the Allocation Journal window, select the Print Full Comments check box to print the comments entered at the Comments field on the Allocation Entry Header tab and Lines tab. For more information, see Allocation Journal - Fields.

3. Click the Print button to print the Allocation Journal.

4. When you are prompted to post the allocation entries, click Yes.

The allocation entries that were selected in the Allocation Selection window are posted.

Post Allocations


Page 1 of 1Post Allocations


Select Accounts Payable Period End menu > Period End Processing.

Use Period End Processing to automatically perform either period-end or year-end processing based on the period entered at the Current Period field in Accounts Payable Options.

Period End Processing allows you to close the current period and increment the accounting period to the next period. Period-end processing is usually performed at the end of each accounting period. Year-end processing takes place automatically when period-end processing is performed for the last period of the fiscal year.

NOTE Fields in Accounts Payable Options are used to determine the current accounting period and the number of years to retain vendor purchase history, check history, and 1099 payment history after year-end processing.


� Temporary vendors with zero balances are automatically purged unless you selected to retain the temporary vendor in Vendor Maintenance.

� Check history information is cleared as of the period-ending date.

� Vendor electronic payment history is removed based on the number of years set up to retain electronic payment history in Accounts Payable Options.

� Vendor purchase history is removed based on the number of years set up to retain purchase history in Accounts Payable Options.

� Open invoices with zero balances are removed based on the number of days to retain paid invoices in Accounts Payable Options.

� If retaining invoice history, all current year invoice information is updated to the Last Year fields, and any invoice history with no current-year activity is removed based on options selected in Accounts Payable Options.

If you have not already printed period-end reports, you can do so during period-end processing. You can also select and print period-end reports without accessing Period End Processing by using Period End Report Selection.

WARNING Backing up your data is an important part of your daily and monthly procedures. Back up all Accounts Payable data before proceeding.



Overview

Fields

Related Topics

A/P Period End Reports Accounts Payable Sales Tax Report

Period End Report Selection Accounts Payable Options

Period End Report Listing A/P Period-End and Year-End Processing Checklist

Complete Period End Processing System FAQs

Vendor Maintenance

Navigation

Overview

Fields

Print Period End Reports

A/P Period End Processing


Page 1 of 1A/P Period End Processing


Use the following checklist to perform period-end and year-end processing activities.

WARNING Backing up your data is an important part of your daily, weekly, and period-end procedures. For more information, see System FAQs.

1. Back up the Accounts Payable files onto a monthly set of backup disks or tapes.

2. Verify that all invoices and checks are recorded for the current month.

3. If you are performing period-end processing for the month of December (the end month of the calendar year), print, verify, and clear all 1099 forms (if your company prints 1099 forms for vendors).

4. Perform period-end or year-end processing. For more information, see Perform Period-End and Year-End Processing.

5. Select the reports to print for the period end. Print at least the Accounts Payable Aged Invoice Report and the Check History Report.

6. Complete period-end processing after all the selected reports have been printed.

7. Back up the Accounts Payable files using a separate set of disks or tapes from the set used to back up the system in step 1.

A/P Period-End and Year-End Processing Checklist


Page 1 of 1A/P Period-End and Year-End Processing Checklist


Select Accounts Receivable Period End menu > Period End Processing.

Use Period End Processing to automatically perform either period-end or year-end processing based on the period entered at the Current Period field in the Accounts Receivable Options window.

Period End Processing allows you to close the current period and increment the accounting period forward to the next period. Period-end processing is usually performed at the end of each accounting period. Year-end processing takes place automatically when period-end processing is performed for the last period of the fiscal year.

NOTE Fields in the Accounts Receivable Options window are used to determine the current accounting period and number of years to retain customer sales history, salesperson history, and cash receipts history after year-end processing. Additionally, you can also determine the number of days to retain credit card history during period-end processing.


� Temporary customers with zero balances are automatically purged unless you selected to retain temporary customers in Accounts Receivable Options during period-end and year-end.

� Monthly sales, cash receipts, and salesperson history is retained based on the selections made in the Accounts Receivable Options window only during year-end processing.

� Open invoices with zero balances are removed based on the number of days to retain paid invoices in Accounts Receivable Options during period-end and year-end.


WARNING Backing up your data is an important part of your daily and monthly procedures. Back up all Accounts Receivable data before proceeding.



Overview

Fields

Related Topics

A/R Period End Reports Accounts Receivable Sales Tax Report

Period End Report Selection Accounts Receivable Options

Period End Report Listing A/R Period-End and Year-End Processing Checklist

Complete Period End Processing System FAQs

Navigation

Overview

Fields


A/R Period End Processing


Page 1 of 1A/R Period End Processing


Use the following checklist to perform period-end processing activities.

1. Back up the Accounts Receivable files onto a monthly set of backup disks or tapes.

2. Ensure that all invoices and cash receipts are recorded for the current month.

3. Perform Finance Charge Calculation to apply finance charges to past due customers. Use Finance Charge Entry to make any manual adjustments, print the Finance Charge Journal, and update.

4. Print statements for the appropriate customers.

5. Print the Accounts Receivable Sales Tax Report as of the appropriate date (monthly, quarterly, etc.) as required by your taxing jurisdiction, and purge from period end.

6. Perform period-end or year-end processing. For more information, see Perform Period-End or Year-Processing.

7. Select the reports you want to print for period end. It is recommended that you print at least the Accounts Receivable Aged Invoice Report.


9. Back up the Accounts Receivable files using a separate set of disks or tapes from the set used to back up the system in step 1.

A/R Period-End and Year-End Processing Checklist


Page 1 of 1A/R Period-End and Year_End Processing Checklist


Select Inventory Management Period End menu > Period End Processing.

Use Period End Processing to automatically perform either period-end or year-end processing based on the period entered at the Current Period field in the Inventory Management Options window.



� The year-to-date sales and issue information are cleared for each item based on the years to retain history in Inventory Management Options.


WARNING Backing up your data is an important part of your daily, period-end, and year-end procedures. Back up all Inventory Management data before performing period-end processing.


Navigation Correct Negative Tiers

Overview Perform Period-End and Year-End Processing

Fields

Related Topics

I/M Period End Reports Inventory Management Options

Period End Report Selection I/M Period-End and Year-End Processing Checklist

Period End Report Listing System FAQs

Complete Period End Processing

Navigation

Overview

Fields


I/M Period End Processing


Page 1 of 1I/M Period End Processing




1. Back up the Inventory Management files onto a monthly set of backup disks or tapes.

2. Verify that all inventory sales, receipts, transfers, issues, and adjustments are recorded for the current period.

3. If you have LIFO, FIFO, lot, or serial items, print the Inventory Negative Tier Report to check for negative tiers. If negative tiers exist, they must be corrected.

4. Perform period-end processing. For more information, see Perform Period-End and Year-End Processing.

5. Select the reports to print for the period.

� For period end, print at least the Inventory Stock Status Report, Inventory Detail Transaction Report, and Inventory Trial Balance.

� For year end, print at least the Inventory Sales Analysis, Inventory Sales History Report, Inventory Receipts History Report, and the Inventory Trial Balance.


7. Back up the Inventory Management files using a separate set of disks or tapes from the set used to back up the system in step 1.

8. To purge Inventory Management data files, see the Inventory Management Utilities menu. For more information, see Purge Inventory Management Data.

Period-End Processing Checklist


Page 1 of 1Period-End Processing Checklist


Show/Hide All

Overview The issue or sale of an item is allowed, even if there is not enough quantity on hand. This situation results in a negative cost tier for LIFO or FIFO valued items. The last cost for an item is used for the posting of the sale when the negative (over distributed) tier is created.

To clear negative cost tiers

1. Select Inventory Management Period End menu > Inventory Negative Tier Adjustment.

2. In the Inventory Negative Tier Adjustment window, click Print. The register prints all LIFO/FIFO items that have a negative cost tier for which there is one or more corresponding positive cost tiers that can be used to adjust the quantity.

3. After printing the Negative Tier Adjustment Register, click Yes to proceed with the update. If there is a difference in cost, print and update the Daily Transaction Register to post the entry to the general ledger.

Clear Negative Cost Tiers


Page 1 of 1Clear Negative Cost Tiers


Select Sales Order Period End menu > Period End Processing.

Use Period End Processing to automatically perform either period-end or year-end processing based on the period entered at the Current Period field in the Sales Order Options window.


NOTE Fields in the Sales Order Options window are used to determine the current accounting period and number of years to retain sales history after year-end processing.


� The Sales Order Recap is purged based on options selected in Sales Order Options during period-end and year-end.

� Expired master and repeating orders are automatically purged as of the period-ending date during period-end and year-end.

� Sales history is purged based on the number of years to retain sales history in Sales Order Options only during year-end processing.


WARNING Backing up your data is an important part of your daily and monthly procedures. Back up all Sales Order data before proceeding.



Overview

Fields

Related Topics

S/O Period End Reports Sales Order Options

Period End Report Selection S/O Period-End and Year-End Processing Checklist



Navigation

Overview

Fields


S/O Period End Processing


Page 1 of 1S/O Period End Processing


To ensure that the Sales Recap reports from Sales Order are in sync with the sales history maintained for both the Customer and Inventory master files, you must perform Accounts Receivable and Inventory Management period-end processing in conjunction with the Sales Order period-end processing. Make sure to perform Accounts Receivable and Inventory Management period-end processing before performing a daily sales update for the next month's invoices.

1. Back up the Sales Order files onto a monthly set of backup disks or tapes.

2. Make sure all invoices are recorded for the current month.

3. Print the Open Sales Order Report.

4. Perform period-end or year-end processing. For more information, see Perform Period-End or Year-End Processing.

5. After completing period-end or year-end processing, back up the Sales Order files using a separate set of disks or tapes from the set used to back up the system in step 1.

Period-End and Year-End Processing Checklist


Page 1 of 1Period-End and Year-End Processing Checklist


Select Purchase Order Period End menu > Period End Processing.

Use Period End Processing to automatically perform either period-end or year-end processing based on the period entered at the Current Period field in the Purchase Order Options window.


NOTE Fields in the Purchase Order Options window are used to determine the current accounting period and number of years to retain purchase history after year-end processing.


� Expired master and repeating orders are automatically purged as of the period-ending date.

� Completed purchase orders are automatically purged based on the number of days to retain completed purchase orders in Purchase Order Options.

� The purchase order recap is automatically purged if selected in Purchase Order Options.

� Receipt history is automatically purged based on the selection made in Purchase Order Options.

� All purchase history and miscellaneous charge year-to-date balances are set to zero as of the year-ending date.


WARNING Backing up your data is an important part of your daily and monthly procedures. Back up all Purchase Order data before proceeding.



Overview

Fields

Related Topics

P/O Period End Reports Purchase Order Options

Period End Report Selection P/O Period-End and Year-End Processing Checklist



Navigation

Overview

Fields


P/O Period End Processing


Page 1 of 1P/O Period End Processing



Warning Backing up your data is an important part of your daily, weekly, and period-end procedures. For more information, see System FAQs.

1. Back up the Purchase Order files onto a monthly set of backup disks or tapes.

2. Verify that all receipts, invoices, returns, and issues are recorded for the current month.

3. Perform period-end processing. For more information, see Perform Period-End and Year-End Processing.

4. Select the reports you want to print for the period end. Print at least the Open Purchase Order Report.


6. Back up the Purchase Order files using a separate set of disks or tapes from the set used to back up the system in step 1.

P/O Period-End and Year-End Processing Checklist


Page 1 of 1Period-End and Year-End Processing Checklist


Select Payroll Period End menu > Period End Processing.

Use Period End Processing to automatically perform either quarter or year-end processing based on the quarter entered at the Current Quarter field in the Payroll Options window.

Period End Processing allows you to close the current quarter and cycle the accounting period forward to the next period. Quarter-end processing is usually performed at the end of each quarter. Year-end processing takes place automatically when period-end processing is performed for the last quarter of the fiscal year.

NOTE Fields in the Payroll Options window are used to determine the current quarter, if retaining year-to-date check history and perpetual payroll history, and the number of years to retain eFiling check history after year-end processing.

The following occurs during quarter-end or year-end:

� Quarter-to-date or year-to date information is cleared.

� Check history is cleared if not retaining check history in the Payroll Options window.

� The Quarterly Tax Recap is purged.

� Workers' compensation information is purged.

� All terminated employees are removed at year end.

� All employee deductions with met goals are removed at year end.

� Benefit accruals for each employee are reset based on the options selected in the Payroll Options window at year end.

WARNING Backing up your data is an important part of your daily, quarter-end, and year-end procedures. Back up all Payroll data before proceeding.



Overview

Fields

Related Topics

Payroll Options Period End Confirmation

P/R Period-End, Quarter-End, and Year-End Processing Checklist

System FAQs

Navigation

Overview

Fields

Quarter End Processing Only Consolidate Check History

Quarter and Year End Processing Purge Perpetual Payroll History

P/R Period End Processing


Page 1 of 1P/R Period End Processing


Use the following checklist to perform weekly (pay period) processing activities.

WARNING Backing up your data is an important part of your daily, weekly, quarterly, and period-end procedures. For more information, see System FAQs.

1. Set the Payroll accounting date to the quarter-ending date.

2. Print the Quarterly Tax Report, Payroll Check History Report, and Quarterly Pay Period Recap. Verify that all checks and adjustments have been entered for the current quarter.

3. Print the Quarterly Governmental Report.

4. Print the Quarterly 941.

5. If performing quarter end for the fourth quarter (year end), print and verify the W-2 Forms.

6. Back up the Payroll files onto a quarterly set of backup disks or tapes.

7. Select the Quarter End Processing task in Period End Processing. If performing period-end processing for the fourth quarter, select the Quarter and Year End Processing task.

8. Select the reports to print for the period end. Print at least the Quarterly Tax Report and the Payroll Check History Report.

9. Complete period-end processing after all of the selected reports have been printed.

10. Back up the Payroll file using a separate set of disks or tapes from the set used to back up the system in step 6.

P/R Period-End, Quarter-End, and Year-End Processing Checklist


Page 1 of 1Period-End, Quarter-End, and Year-End Processing Checklist


Select Job Cost Period End menu > Period End Processing.

Use Period End Processing to automatically perform either period-end or year-end processing based on the period entered at the Current Job Cost Period field in the Job Cost Options window.

Use Period End Processing to close the current period and increment the accounting period to the next period. Period-end processing is usually performed at the end of each accounting period, on the last business day of each month. Year-end processing takes place automatically when period-end processing is performed for the last period of the fiscal year.

NOTE Fields in the Job Cost Options window are used to determine the current accounting period and if retaining job cost history after year-end processing.

WARNING Period End Processing cannot be performed if job billing is in progress (if the Job Billing Register has not been printed and updated), if the Daily Overhead Allocation Register or Monthly Overhead Allocation Report has been printed but not yet updated, or if the Daily Transaction Register has not been updated for all outstanding job transactions.


� The year-to-date actual cost, invoice billed, and payment received totals are cleared and set to zero, along with the year-to-date dollar and unit totals.

� Job information is removed if the Retain Job Cost History check box is cleared in Inventory Management Options.

� Closed jobs are archived to history files instead of purged during period-end processing if the Retain Job Cost History check box is selected in the Job Cost Options window.

� If the Retain Transaction Detail check box is cleared in the Job Masterfile Maintenance window, transaction jobs are summarized. If selected, transaction jobs are retained until the job is closed.

Before performing period-end processing, the Job Close-Out Report must be printed and updated to the files. This report provides a final audit trail of all unit and cost information. If you are using Work-in-Process accounting, the job close-out update also clears outstanding work-in-process amounts and makes the necessary postings to the General Ledger module. The Work in Process Report and Job Transaction Detail Report should always be printed before performing either period-end or year-end processing.

WARNING Backing up your data is an important part of your daily, period-end, and year-end procedures. Back up all Job Cost data before performing period-end processing.



Overview

Fields

Related Topics

Job Close-Out Report Job Cost Options

Job Cost History Purge Utility/Job Cost History Restore Utility

J/C Period-End and Year-End Processing Checklist

J/C Period End Reports Job Cost FAQs

Period End Confirmation System FAQs

Navigation

Overview

Fields

Full Period End Processing Summarize Billed Cost Transactions

Full Period and Year End Processing Purge/Archive Closed Jobs

J/C Period End Processing


Page 1 of 1J/C Period End Processing




1. Back up the Job Cost files onto a monthly set of backup disks or tapes.

2. Verify that all change orders; job billing invoices; and direct cost, billing, and cash receipt transactions are recorded for the current month. Also, verify that all integrated modules (Accounts Payable, Payroll, etc.) have posted all transactions for the current month.

3. If monthly calculation of overhead is selected in the Job Cost Options window, print the Monthly Overhead Allocation Report and update. Print and update the Daily Transaction Register.

4. If any jobs have been completed during the current period, print the Job Close-Out Report and update.

5. Perform period-end or year-end processing. For more information, see Perform Period-End and Year-End Processing.

6. Select the reports to print for the period end. Print at least the Work in Process Report and Job Transaction Detail Report.


8. Back up the Job Cost files using a separate set of disks or tapes from the set used to back up the system in step 1.

J/C Period-End and Year-End Processing Checklist


Page 1 of 1J/C Period-End Processing Checklist


year end closing procedures for 2013 sage 100...

Documents