Month End Procedures
Jeremy Johnson avatar
Written by Jeremy Johnson
Updated over a week ago

The Business Edge allows you the flexibility to begin work in a new month while you are still finishing off a previous month. You also have the ability to enter transactions or make adjustments in previous months if needed. This flexibility is made possible using the Posting Date Ranges.

At the start of each new month the system administrator must Advance the Date and Change the Posting Date Ranges. The Date is advanced in the System Administrator System. When you Advance the Date the system will change the System Date on the Main Menu to the current date. If your System Date is currently more than a month behind you may need to Advance the date more than once.

After you have advanced the date you can then change your Posting Date Ranges. This can be done in the System Administrator System or through General Ledger File Maintenance. The Posting Date Ranges is how you can control the dates in which transactions can be done. You can change them all at once by using the function keys to Advance Beginning Dates and Advance Ending Dates. You also have the ability to change them individually. At any time you can also go back and change them if you need to open up a prior period.

The system will allow you to open the Posting Date Ranges up to the end of the month following the System Date on the Main Menu i.e. If the System date is 5-01-01, the Latest Posting Date ranges can be set as far as 6-30-01. This is helpful if the System Administrator is not going to be available on the first of the month, the dates can be advanced anytime during the previous month.

When users are processing daily transactions such as Orders, Invoices, Purchase Orders etc. the system will always suggest the actual date (today’s date) as long as it is within the Posting Date Ranges. You can always see the actual date on the screen on the top left hand corner.

Reports

There are no mandatory reports that must be run at the end of each month. You also have the ability to run your Accounts Receivable and Accounts Payable Aged reports back in time. This means that you can run an accurate report in June for last January.

Each company must check with their accountant to see what they would like you to print. Below are some typical reports companies may run.

Accounts Receivable Aging – Located in Accounts Receivable Reports, Aged Analysis Reports, Aging by Customer or Salesperson.

Sales Journal – Located in Accounts Receivable Reports, Sales Journals. There is a wide range of Sales Journals to Choose from.

Sales Tax Report – (based on Sales) Located in Accounts Receivable Reports, Sales Journals, Sales Journal Tax Report. If you make adjustments to sales tax during cash receipts you must also run the next report to obtain a listing of deductions.

Sales Tax Report – (based on Receipts) Located in Accounts Receivable Reports, Cash Receipts Reports, Cash Receipts Tax Report.

Accounts Payable Aging – Located in Accounts Payable Reports, Vendor Aged Analysis. (This should be run by Posting Date to match the General Ledger)

Accrued Payable Report – Located in Accounts Payable Reports, Accrued Payable Reports. These reports are actually more of a notepad to help you reconcile open accrued P.O.s. These reports do not tie directly to the General Ledger and do not go back in time. You can select any date range and the system will present all P.O.’s that have been received within that date range that are still waiting for invoices to be posted against. them. We recommend that you reconcile this account on a regular basis

Check Register – Located in Accounts Payable, Check Routines.

Disbursement Journal – Located in Accounts Payable Reports, Disbursement Journals.

Purchases Journal – Located in Accounts Payable Reports, Purchase Journals.

Inventory Cost Status – Located in Inventory System, Inventory Reports, Balance Status Reports, Cost Status Report.

Summary Trial Balance – Located in General Ledger Reports

Income Statement – Located in General Ledger Reports, Financial Reports

Balance Sheet – Located in General Ledger Reports, Financial Reports.

This is certainly an abbreviated list of available report in The Business Edge. These are among the most commonly requested “End of Month” reports.


Did this answer your question?