--- title: Sage 100 Year-End Processing Procedures | BCS ProSoft description: It’s that time of year again and we’ve put together a comprehensive guide to making closing the books a little easier in your Sage 100 system. Before we get started, I’d like to start by […] image: https://blog.bcsprosoft.com/hs-fs/hubfs/Sage-100-Year-End-Processing-Procedures-BCS-ProSOft-10.jpg?width=1324&quality=high --- Questions? Give us a a call at [**(855) 982-9336**](https://www.bcsprosoft.com/contact/) - [Facebook](https://www.facebook.com/bcsprosoft) - [Linkedin](https://www.linkedin.com/company/bcs-prosoft) - [Twitter](https://twitter.com/bcsprosoft) - [Email](https://www.bcsprosoft.com/contact/) [![BCS-logo-white-red-2](https://blog.bcsprosoft.com/hs-fs/hubfs/BCS-logo-white-red-2.png?width=700&name=BCS-logo-white-red-2.png)](https://www.bcsprosoft.com/) - Products - Deltek - [Deltek](https://www.bcsprosoft.com/deltek/) - [Deltek Vantagepoint](https://www.bcsprosoft.com/deltek/vantagepoint/) - [Deltek Cloud](https://www.bcsprosoft.com/deltek/cloud/) - [Deltek PIM](https://www.bcsprosoft.com/deltek/pim/) - [Deltek CRM](https://www.bcsprosoft.com/deltek/crm/) - Sage - [Sage Intacct](https://bcsprosoft.com/sage-intacct/) - [Sage 100cloud](https://www.bcsprosoft.com/sage-100/cloud/) - [Sage CRM](https://www.bcsprosoft.com/sage-crm/) - [Sage HRMS](https://www.bcsprosoft.com/sage-hrms/) - [NetSuite](https://www.bcsprosoft.com/netsuite/) - [Automated Rental (ARM)](https://www.armsoftware.com/?utm_source=bcsprosoft.com&utm_medium=referral) - [Services](https://www.bcsprosoft.com/services/) - Resources - Blog - [Deltek Blog](https://blog.bcsprosoft.com/tag/deltek/) - [Sage Blog](https://blog.bcsprosoft.com/tag/sage) - [NetSuite Blog](https://blog.bcsprosoft.com/tag/netsuite) - Whitepapers - [Deltek Whitepapers](https://www.bcsprosoft.com/resources/deltek-whitepapers/) - [Sage Whitepapers](https://www.bcsprosoft.com/resources/sage-whitepapers/) - [NetSuite Whitepapers](https://www.bcsprosoft.com/resources/netsuite-whitepapers/) - Product Guides - [Deltek Product Guides](https://www.bcsprosoft.com/resources/deltek-product-guides/) - [Sage Product Guides](https://www.bcsprosoft.com/resources/sage-product-guides/) - [NetSuite Product Guides](https://www.bcsprosoft.com/resources/netsuite-product-guides/) - Webinars - [Deltek Webinars](https://www.bcsprosoft.com/resources/deltek-webinars/) - [Sage Webinars](https://www.bcsprosoft.com/resources/sage-webinars/) - [NetSuite Webinars](https://www.bcsprosoft.com/resources/netsuite-webinars/) - Company - [About Us](https://www.bcsprosoft.com/about/) - [Industries](https://www.bcsprosoft.com/industries/) - [Events](https://www.bcsprosoft.com/events/) - [Careers](https://www.bcsprosoft.com/careers/) - [Support](https://www.bcsprosoft.com/support/) - [Referral Program](https://www.bcsprosoft.com/bcs-referral/) - [Contact Us](https://www.bcsprosoft.com/contact/) ![Sage-100-Year-End-Processing-Procedures-BCS-ProSOft-10](https://blog.bcsprosoft.com/hs-fs/hubfs/Sage-100-Year-End-Processing-Procedures-BCS-ProSOft-10.jpg?width=1324&quality=high "Sage-100-Year-End-Processing-Procedures-BCS-ProSOft-10") # Sage 100 Year-End Processing Procedures By [BCS ProSoft](https://blog.bcsprosoft.com/author/bcs-prosoft) | Dec 3rd, 19 | Categories: [Sage](https://blog.bcsprosoft.com/tag/sage) It’s that time of year again and we’ve put together a comprehensive guide to making closing the books a little easier in your Sage 100 system. Before we get started, I’d like to start by addressing the four things to do before closing the books and starting fresh in the new year: #### **1. Backup Your Data ** Executing a complete [backup of your database](https://support.na.sage.com/selfservice/viewContent.do;jsessionid=55388B45719F45B498E2EA2AB9AC91DB.worker1g?externalId=20262&sliceId=1) 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. For more detail and guidance, refer to the **Module Closing section **below. #### **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. Get Help When Needed!** Be sure to [contact us](https://www.bcsprosoft.com/contact/) 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, we can help you plan a closing process for your specific system/installation. ### Creating a Copy Company for Archive/Backup At year-end, it’s useful 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 make a copy company, go to: **Library Master > Main Menu > Company Maintenance** 1. Create a new **company code** and **company name** (description) that’s easy to identify and distinguish from the live/active company that you’re copying. 2. Click the **Copy** button and enter the Company Code of your current year live (or “Source”) company. 3. **Select the modules** you want to copy to your archive company. To create a complete archive/backup, you’ll want to copy all modules. Click **Proceed**. Once the process is finished, click **Accept**. **Note:** For good measure, you might run a trial balance in each module and do a quick spot check to make sure all the data that came over is balanced and accurate. ### Module Closing: Keeping Things In 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 us to discuss specific closing procedures for your company. ### 4 Tips for a Successful Year-End Here are just a few tips to keep in mind as you begin year-end processing in Sage 100. #### **1. 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. #### **2. 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 2019.**NOTE:** This does ***NOT*** apply to the ***new*** 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 2018.\] #### **3. Check Your Version Number** Closing procedures can vary depending on which version of Sage 100 you’re currently running. For Version 4.0 or above, do the     following to identify both your version number and service pack:Select **Help** > **About** Sage 100 #### **4. 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** ### Year-End FAQ’s for General Ledger & Reporting 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. #### TIP: 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.   ### Affordable Care Act (ACA) Reporting & Processing When it comes to the Affordable Care Act (ACA), there are a variety of questions about how to track and report data in order to remain in compliance. That’s why Sage has put together an [ACA Resource Center](http://sagecity.na.sage.com/p/aca/) to help you understand the provisions and how to comply using your Sage 100 software. Here are some popular ACA resources to consider reviewing. **How to Set Up ACA Tracking in Sage 100** Step-by-step instructions for setting up Sage 100 for ACA tracking and reporting. [Review Setup Procedure](https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=62495&sliceId=1&dialogID=84243&cmd=displayKC&docType=kc&noCount=true&stateId=84244&isLoadPublishedVer=&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.BaseView) **How Do I Generate the Required Forms?** Instructions for generating and printing required ACA forms including 1094 and 1095. [Generating ACA Forms in Sage 100](https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=71048&sliceId=1&dialogID=84243&cmd=displayKC&docType=kc&noCount=true&stateId=84244&isLoadPublishedVer=&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.) **How to Report Employer-Sponsored Healthcare Coverage on the W2 Using   Sage 100** Setting up Sage 100 Payroll to track and report the cost of coverage under an employer-sponsored group health plan. [Review Instructions](https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=19289&sliceId=1&cmd=&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl) **ACA Video Gallery** A collection of “How-To” videos for ACA setup, generating forms, and more using Sage 100. [Video Gallery](https://sagecity.na.sage.com/support_communities/sage100_erp/sage100-yearend/m/aca-mediagallery) The resources and articles above are designed to provide general guidance on using Sage 100 for ACA compliance. Be sure to consult with your accountant or tax advisor for legal advice or guidance that’s personalized to your company-specific requirements. ## Sage 100 Year-End Center Sage has created a [Year-End Center](https://sagecity.na.sage.com/support_communities/sage100_erp/sage100-yearend) that provides valuable resources to guide you through a smooth year-end closing process in Sage 100 including: - Year-End Tips and Checklists - Video Tutorials and How-to Articles - Live Chat With Tech Support - Tax Forms, Payroll, and Report Guidance - Take advantage of this free and valuable resource! ## Sage 100 Supported Versions Update Sage officially supports the current plus 3 prior supported versions of Sage 100. We do our best to keep you updated here, however, sometimes it’s best to double check with the source. As always, [contact your Sage 100 Account Manager](https://www.bcsprosoft.com/contact/) or give us a call at (800) 882-6705. The Sage Customer Success team here at BCS ProSoft is standing by and ready to help throughout your Year-End close process. Photo by [Matt Botsford](https://unsplash.com/photos/TgjSku4-g6Q?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText) on [Unsplash](https://unsplash.com/search/photos/year-end?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText) #### Share this post with a friend or coworker! - - - - [mailto:?subject=Sage%20100%20Year-End%20Processing%20Procedures&body=https://blog.bcsprosoft.com/sage-100-year-end-processing-procedures](mailto:?subject=Sage%20100%20Year-End%20Processing%20Procedures&body=https://blog.bcsprosoft.com/sage-100-year-end-processing-procedures) ### Related posts ![7 Ways Dimensional Accounting Can Help You Manage Your Multi-Entity Business](https://blog.bcsprosoft.com/hs-fs/hubfs/Dimensional_Accounting_image.png?width=200&name=Dimensional_Accounting_image.png) [7 Ways Dimensional Accounting Can Help You Manage Your Multi-Entity Business](https://blog.bcsprosoft.com/dimensional-accounting) Jun 16th, 22 ![We’re Ready When You Are: 3 Things Sage 100 Customers Need to Know about Sage Intacct](https://blog.bcsprosoft.com/hs-fs/hubfs/Sage_SI_hero-3.jpg?width=200&name=Sage_SI_hero-3.jpg) [We’re Ready When You Are: 3 Things Sage 100 Customers Need to Know about Sage Intacct](https://blog.bcsprosoft.com/3-things-sage-100-customers-need-to-know-about-sage-intacct) Apr 14th, 21 ![BCS ProSoft Chosen as one of Bob Scott’s VAR Stars 2020!](https://blog.bcsprosoft.com/hs-fs/hubfs/How-to-Integrate-NetSuite-Forms-with-Recaptcha-BCS-ProSoft-03.jpg?quality=high&width=200&name=How-to-Integrate-NetSuite-Forms-with-Recaptcha-BCS-ProSoft-03.jpg) [BCS ProSoft Chosen as one of Bob Scott’s VAR Stars 2020!](https://blog.bcsprosoft.com/bcs-prosoft-chosen-as-var-stars-2020) Jan 5th, 21 ![5 Signs You've Outgrown Your Business Software](https://blog.bcsprosoft.com/hs-fs/hubfs/5-Signs-Youve-Outgrown-Your-Business-Software-BCS-ProSoft-12.jpg?quality=high&width=200&name=5-Signs-Youve-Outgrown-Your-Business-Software-BCS-ProSoft-12.jpg) [5 Signs You've Outgrown Your Business Software](https://blog.bcsprosoft.com/has-your-company-outgrown-business-software) Oct 8th, 20 ![BCS ProSoft Named to Bob Scott’s 2020 Top VAR List](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/Top-100-VARS-2020-logo.jpg?width=200&name=Top-100-VARS-2020-logo.jpg) [BCS ProSoft Named to Bob Scott’s 2020 Top VAR List](https://blog.bcsprosoft.com/bcs-prosoft-named-to-bob-scotts-2020-top-var-list) Jun 4th, 20 ![Sage Summit 2020 is Coming! Will You Be There?](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/SageSummit2020.jpg?width=200&name=SageSummit2020.jpg) [Sage Summit 2020 is Coming! Will You Be There?](https://blog.bcsprosoft.com/sage-summit-2020-is-coming-will-you-be-there) Feb 19th, 20 This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. ### Recent Posts ### Who is BCS ProSoft? We’re a business technology provider and consulting firm specializing in NetSuite, Deltek and Sage software systems. We’re a Top 30 VAR and ready to get started on your project. Need help? [Let’s talk.](https://www.bcsprosoft.com/contact/) ![BCS-logo-white-red-2](https://blog.bcsprosoft.com/hs-fs/hubfs/BCS-logo-white-red-2.png?width=211&name=BCS-logo-white-red-2.png) BCS ProSoft is a leading business management technology provider and professional services firm specializing in Sage, Deltek, and NetSuite ERP systems. Based out of San Antonio, Texas, BCS ProSoft serves more than 1,500 clients from its offices in Houston, Denver, Honolulu, and Monterrey, Mexico. ### **Products** - [Deltek](https://www.bcsprosoft.com/deltek/) - [Sage Intacct](https://www.bcsprosoft.com/sage-intacct-overiew/) - [Sage 100](https://www.bcsprosoft.com/sage-100/cloud/) - [NetSuite](https://www.bcsprosoft.com/netsuite/) - [Automated Rental (ARM)](https://www.armsoftware.com/) ### **Company** - [About Us](https://www.bcsprosoft.com/about/) - [Industries](https://www.bcsprosoft.com/industries/) - [Events](https://www.bcsprosoft.com/events/calendar/) - [Careers](https://www.bcsprosoft.com/careers/) - [Support](https://www.bcsprosoft.com/support/) - [Referral Program](https://www.bcsprosoft.com/resource/bcs-referral/) © Copyright 2008-2021, BCS ProSoft, LLC. All rights reserved. | [Legal](https://www.bcsprosoft.com/legal) | [Privacy Policy](https://www.bcsprosoft.com/privacy/) - [Facebook](https://www.facebook.com/bcsprosoft) - [Linkedin](https://www.linkedin.com/company/bcs-prosoft) - [Twitter](https://twitter.com/bcsprosoft) - [Email](https://www.bcsprosoft.com/contact/)