To help you get a jump start on closing the year out smoothly, here are some of the most Frequently Asked Questions and answers related to the General Ledger in Sage 100.
At a high level, here are 4 things to consider as you begin closing the books on 2017 and start fresh in the new year.
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.
The following tips and tricks will help you get ready to close out the old year (2017) in Sage 500 and ring in the New Year (2018)!
This article will give you pointers about common reconciliation issues, tips and tricks, and a little information on what may be different for you this year vs. previous years.
“What’s the quickest way to ensure we have posted every batch in a module?” Good question! Almost every module has a “Post xx Batches” task on the module’s Activities menu, where xx represents the 2-letter abbreviation for the module (IM = Inventory Management, PO = Purchase Order, etc.). That task gives you a list of all pending batches for the selected company and module. The task will display whether the register has been printed, posted, the process status, the batch ID, the post date, the batch status, the user who created the batch, and a checkbox for whether the batch is flagged as “private” for the user who created it or those with Supervisory access to the task, like this screen-shot:
Procedures for closing Sage 100 Payroll Period End
Sage 100 Payroll Period end occurs each quarter and at the end of the calendar year. We will walk you through the steps to close your 2017 Payroll and move into 2018. When the payroll period end processing is run, QTD and or YTD data is purged from the system and can only be recovered by restoring to a backup so it is imperative that a database backup is performed as well as a backup company created.
ERP Leaders Join Forces to Accelerate Strategic Growth and Add New Resources to Support Clients and Partners Coast to Coast
We’re excited to announce that RKL eSolutions has merged with Arxis Technology which will take effect January 1, 2018. The combination of RKL eSolutions and Arxis Technology will include 100 employees across 20+ states focused on providing market-leading expertise, solutions, and services to their valued clients.
- General Ledger Closing – While it’s a good idea to close modules in a timely fashion, your General Ledger can remain open for as long as you need while awaiting final processing in other modules (or audit adjustments). A GL that’s still open for 2017 will NOT prevent you from entering transactions for the new year.
- 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. It’s a good idea to begin reconciling all of your payroll tax reports to the general ledger in early December. This gives you a chance to catch errors early and avoid filing an amended payroll tax return. Note: All W-2’s and quarterly reports must be printed before processing the first payroll for 2018. Learn more about Payroll Period Close Procedures.
- Check Your Version Number – Closing procedures can vary depending on which version of Sage 100 you’re currently running. Contact us if you need help determining your version number.
- Get All the Answers – We’ve compiled an extensive packet of checklists, closing procedures, and FAQ’s related to your core modules including General Ledger, Accounts Payable, Accounts Receivable, and Payroll.
Have Questions or Need Help?
As you begin year end closing in Sage 100 and prepare to start fresh in 2018, be sure to contact us if you need assistance during this important time of year. As your software and technology partner, we’re always here to help.
New in Sage 100
A long time in the making, Sage 100 Payroll 2.0. (aka “Payroll 2018”) is the next-generation payroll module that has been modernized to improve performance and user experience. Since it represents a significant change, we wanted to introduce you to a few how-to videos that should help you with a smooth transition from the legacy payroll module.
This is the twelfth lesson in the series Learning Sage X3. When adding new customers in Sage X3, it is convenient to use auto-numbering. In this lesson I am going to go over how to configure auto-numbering on customers.
Before getting further, I wanted to further explain Business Partners (BP for short) from the first blog post. A BP can be a customer as well as other alliances you may have. They can be multiple BP types at the same time. Please refer to Figure 1 to view the field we will be adding the functionality too.
Soon after Sage acquired Intacct, the industry leading Cloud financial management solution, RKL eSolutions jumped at the opportunity to add the newly branded Sage solution product to our portfolio. Several of our long-time customers have wondered how we position Sage Intacct in our portfolio and if they should consider a switch to Sage Intacct. In this blog, I’ll provide the most common triggers that cause Sage 100 and Sage 500 users to evaluate Sage Intacct as its next solution.
No Update Required to Generate Sage 500 ERP 1099s
There is Good News for any Sage 500 ERP users that need to generate 1099s this coming January. If you are on a current version* of Sage 500 ERP, there will be no update required this year!
Last year, Sage introduced the integration from Sage 500 ERP to Aatrix for 1099 filing. With this change, Aatrix will now manage any changes to the forms and eFiling requirements for 1099s. The 1099 Form eFile and Reporting task within Sage 500 ERP provides the data currently needed for Aatrix. As there are no changes to the information needed for Tax Year 2017, there is no update needed to the software at this time.