Navigating the Period-End Process in Sage 100 Accounts Receivable: A Step-by-Step Guide

Managing financial records effectively is crucial for the health and accuracy of any business's accounting system. As a critical component of this process, the period-end processing in Sage 100 Accounts Receivable (AR) stands as a pivotal task for accountants and financial professionals. This procedure ensures that all transactions for the period are accurately recorded and that the accounts are ready for the next cycle. In this article, we delve into the essential steps and best practices for executing a seamless period-end processing in Sage 100 AR. Whether you're a seasoned accountant or new to the Sage 100 platform, this guide will provide valuable insights to streamline your period-end routine, ensuring your financial data remains accurate and reliable.

Sage 100 Accounts Receivable Period End Processing

1. Ensure that all data entry tasks that update to Accounts Receivable are updated:

  • A/R Invoice Data Entry

  • A/R Cash Receipts Entry

  • S/O Invoice Data Entry

  • S/O Shipping Data Entry

2. Ensure that all data files are backed up (optional) and that no users are logged on to the affected company.

3. Expand “Modules”, “Accounts Receivable”, and “Period End”. Double-click “Period End Processing"“.

4. When the prompt to print period end reports appears, print all relevant reports before proceeding with the period-end close. (optional)

6. After the reports are printed and verified, click “Proceed” dialog box.

During month-end close, the program performs the following tasks:

  • Prompts the user to print monthly reports

  • Sets period-to-date balances to zero in Customer Maintenance

  • Removes zero-balance invoices from the A/R open invoice files based on the selection in the Days to Retain Paid Invoices field in Accounts Receivable Options

  • Removes temporary customers with zero balances from the Customer Masterfile if the Retain Temporary Customers with Paid Invoices check box is not selected in Accounts Receivable Options

  • Increments the Current Period value in Accounts Receivable Options

Should you have any questions about module closing in Sage 100 or need other support with managing your Sage 100, we at Ardent Consulting are at your service. Our team of experts is ready and eager to help you navigate your system challenges and optimize your business's potential. We prioritize your business’s health and are committed to supporting your journey every step of the way.

Doug Clark