370 likes | 380 Views
Learn why closing the month in SAGE 300 CRE is crucial for financial accuracy. From data backup to module-specific tasks, ensure a smooth month-end process through this comprehensive guide.
E N D
Closing the Month in SAGE 300 CRE Glenn Klein, MBA Senior SAGE Consultant, Aronson LLC April 4th, 2019 *Information contained in this presentation may have been obtained by the use of the SAGE Knowledgebase and printed training materials provided by SAGE.
Backup your data - Using File Tools • Before starting the backup you have to ensure that everyone has exited all SAGE 300 CRE applications. • In any accounting application, from the Tools menu, select File Tools. In any estimating application, from the File menu, select File Tools. • Select Backup and click Next.
Backup your data using File Tools (continued) • Additional data folders or files can be added to the backup that File Tools creates. • Click Next • In the Destination box, type the path to the location where you want to save the .tszip archive file that the backup process creates. Click Browse to browse to the location where you want to save the .tszip file.
Check to make sure that all of the company’s financial transactions have posted
Close the month in all the modules except the General Ledger Cash Management Job Cost
Month-End tasks that should be completed in Accounts Payable
Month-End tasks that should be completed in Accounts Receivable
Suggested Accounts Receivable reports that may be run at Month-End
Closing the month in Contracts - What Happens? • Advances the Current Month in the Contract Settings • When you close the month in the Contracts application, the Next Month totals on the Billed Totals, Adjustment Totals, Retainage Totals & Miscellaneous tabs of the contract and contract item are cleared and those amounts move to the Month-to-Date totals • If the new month is the first month of a new year, the Next Year totals clear and move to the Year-to-Date totals • Moves the totals in the next month total fields to the month to date fields on the contract and contract item records • If the new month is the first month of the new year, it moves the totals in the Next Year total fields to the year to date total fields on the contract and contract item records
Steps to Closing the month in Job Cost • Have everyone log out of the software • Do a full backup of the company data • Go to Tasks>Close Month • A journal is produced which lists all jobs and shows whether each job is in balance • Review the JC Close Month to verify that the totals on the jobs are in balance • Note—The JC Close Month processing is not reversible. Be sure to process all monthly reports and backup the Job Cost Master file before selecting this command. The JC Close Month journal can’t be reproduced. It is a report generated internally only when the Close Month task is run
Print all of the Month-End reports (continued) Trial Balance
Print all of the Month-End reports (continued) Current Ledger
Print all of the Month-End reports (continued) Year-to-Date Ledger
Print all the Month-End reports-continued Balancing Reports
Questions? Contact Info: Glenn Klein, MBA Senior SAGE Consultant Aronson LLC gklein@aronsonllc.com 240-364-2675