Sage Partners
Connect on Twitter & Google+
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • International (Outside U.S.)
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage 500 Partners
        • Sage X3 Partners
        • Sage Intacct Partners
      • Sage Construction Partners >
        • Sage 100 Contractor
        • Sage 300 Construction
      • Sage CRM Partners
      • Sage HRMS Partners
    • Other Products >
      • MIP Fund Accounting
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage HRMS >
      • Sage HRMS System Requirements
    • Sage Fixed Assets
    • Sage 100 Contractor
    • Sage 300 Construction (CRE)
  • Sage Add Ons
  • Resources
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Blog
  • Contact Us

Sage 100 Year End Closing Procedures

1/9/2019

0 Comments

 
Sage 100 Year End Processing Image
We've compiled some of the most popular and important procedures, checklists, FAQs, and other resources that will guide you through Sage 100 Year End processing. Click any of the categories below for more detail on the topic.

Be sure to get in touch with your Sage 100 Partner with specific questions or to request help with Sage 100 Year End Closing.
8 THINGS TO KNOW BEFORE CLOSING THE BOOKS
1. Backup Your Data
Executing a complete backup of your database is one of the most important things you can do before starting any closing process.  You should also test the backup to ensure it was performed successfully and the data is readable.

If you make a mistake, the only way to "reverse" year end processing is to restore data from a backup.

2. Follow the Module Closing Order
A year end process in one module often writes data to another related module. Therefore, closing modules in the proper sequence is extremely important in order to avoid unexpected results or damage to your data.

3. Follow the Module Closing Checklists
Step-by-step checklists are available for most modules.  These checklists provide guidance on the sequence of detailed tasks and procedures that should be performed within each module.

Detailed checklists for each module can be accessed right from within the Sage 100 Help system.

4. General Ledger Closing
While it’s a good idea to close modules in a timely fashion, the General Ledger can remain open for as long as you need while awaiting final processing (or audit adjustments) in other modules.  A GL that’s still open for 2018 will NOT prevent you from entering transactions for the new year.

5. Payroll Planning
Even if your company is on a fiscal year, you’ll need to close out payroll at the end of the calendar year. All W-2’s and quarterly reports must be printed before payroll is closed in order to process the first payroll for the new year.

NOTE: This does NOT apply to the newer Payroll 2.0 which now allows two calendar years to be open so you don't have to run year-end tax reports and W-2's before processing payroll for the new year.

6. Check Your Version Number
Closing procedures can vary depending on which version of Sage 100 you’re currently running.  Do the following to identify both your version number and service pack:

Select Help > About Sage 100

7. Master Console
Once you’re ready to close, you need to make sure all users are out of the system. That’s where the Master Console comes in handy. This utility provides a snapshot of all users currently logged into Sage 100, the workstation being used, what programs/tasks they’re using, and more. You can also broadcast a message to all users or even shut them down remotely.

To launch the Master Console:
Select File > Master Console

8. Get Help When Needed!
Be sure to contact your Sage Authorized partner/reseller if you have any questions before, during, or after you start year end processing. Especially if you have customizations or 3rd party add-on products that are integrated with Sage 100.
MODULE CLOSING ORDER
A year end process in one module often writes data to another module. Therefore, the sequence in which you close your Sage 100 modules is extremely important in order to avoid the risk of damaging your data.
 
Important: Remember to back up your data before starting any module closing procedures. Refer to the “how to backup data” article included in this newsletter for guidance.

  1. Bill of Materials*
  2. Work Order Processing*
  3. Bar Code
  4. Purchase Order Processing
  5. Sales Order Processing
  6. Inventory Management
  7. Material Requirements Planning (MRP)*
  8. Timecard
  9. Electronic Reporting/Magnetic Data*
  10. Payroll (Quarter-end processing)
  11. Accounts Receivable
  12. Accounts Payable
  13. Job Cost
  14. Bank Reconciliation
  15. General Ledger
 
*Note: While there is no formal closing procedure in the Bill of Materials, Work Order, MRP, and Electronic Reporting modules, all transactions in those modules should be posted before starting any closing procedures in the modules that follow them (i.e. Post transactions in Work Order before closing Purchase Order, Sales Order, and Inventory).
 
Remember, this is just a general guideline.  If you own modules that aren’t listed above or you run any third party add-on products, please contact your Sage 100 partner to discuss specific closing procedures for your company.
CREATING A Company/database BACKUP
At year end, it’s important to create an archive company using the Copy Company feature. This provides a readily accessible copy (and backup) of the current year’s data even after you perform year end processing in your live company.

To use the copy company feature, go to:

Library Master > Main Menu > Company Maintenance

For full instructions including a video demonstration, click the button below:
Sage 100 Backup Instructions
Year End FAQs for General Ledger
Here are answers to a handful of the most Frequently-Asked Questions (FAQs) regarding General Ledger and Reporting when it comes to year end processing. 

Can I print financial statements for the NEXT fiscal year PRIOR to performing year end processing?

YES. In the Fiscal Year field within the applicable report window, simply select the fiscal year to print.  

DO NOT manually change the fiscal year in General Ledger Options in order to print financial statements for the next fiscal year.

After year end processing, can I delete accounts that will no longer be used in the new fiscal year and still run comparison statements?

Information about prior fiscal years is stored by account number. These account numbers must be retained for as long as you require comparisons. 

Instead of deleting, you can set the status of an account to Inactive which prevents future postings but still retains the account number for comparisons.  On the Main Tab in Account Maintenance, select Inactive in the Status field and click Accept.

Can I open a closed fiscal year to make General Ledger postings/adjustments?

YES. If you retained detail history for a prior fiscal year by entering the ‘Years to Retain General Ledger History’ field in GL Options, you can reopen and post to a closed fiscal year. 

TO POST TO A CLOSED FISCAL YEAR:
1. Select General Ledger Setup menu > GL Options

2. On the Main tab, in the Current Fiscal Year field, select the past fiscal year to reopen

3. In the Current Period field, select the accounting period to post to and click Accept 

4. In General Journal Entry or Transaction Journal Entry, enter the transaction to the reopened fiscal year and period and update the journal entry.

5. Reprint year end reports when you’re finished

6. Go back to General Ledger Options Main tab and select the current year in the Current Fiscal Year field, and the current period in the Current Period field. Click Accept.  

You’ve just re-opened the closed fiscal year, posted a journal entry, and reverted back (in step 6) to the current fiscal period and year.

Note: Closed fiscal years can only be reopened in the General Ledger module. 

Can I process year end in General Ledger before I’m finished with the other modules?

NO.  General Ledger should be the very last module you close. Refer to the Module Closing Order article earlier in this newsletter for details on the proper closing sequence.
How to correct an out-of-balance General Ledger
There are a variety of reasons that your general ledger can get out of balance. 
​In the video below, you’ll learn how to discover and correct the out-of-balance situation including instructions for making one-sided journal entries.
Sage 100 supported Versions
Sage officially supports the current plus 3 prior versions of Sage 100. With the release of Sage 100 2018, here’s the updated list of supported versions and retirement dates ...
sage 100 supported versions
Full Support Details
Sage 100 Year End videos
Overview of Period and Year-End Processes
How to Reconcile the Trial Balance​​
Year End: Filing 1099s
Payroll 2.0+ - Federal and State Tax Reporting

Have a Question or Need Help?

Ask a Sage 100 Partner
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Picture
    Scanforce WMS for Sage

    Categories

    All
    General CRM
    General ERP
    Guest Posts
    MIP Fund Accounting
    Sage 100 Contractor
    Sage 100 Erp
    Sage 300 Construction
    Sage 300 Erp
    Sage 500 Erp
    Sage 50 Accounting
    Sage Accounting Software
    Sage CRM
    Sage Erp
    Sage Erp X3
    Sage Hrms
    Sage Intacct
    Sage Intelligence
    Sage News & Events
    Sage Tips & Tricks
    Sage X3


©2018 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy