Year End Preparation and Reporting

There are a few reports which are "date sensitive", thus requiring to run these as that last thing PRIOR TO the first calendar date of the new year. This are particularly important in the event you plan to input Vendor Invoices/Credits or Customer Invoice/Credits in the new year but post to the prior year. After completing all transaction processing on the last day of the current year, perform these steps.

Prerequisites

  • Insure all sales order shipments are posted, and their related Sales Invoices are printed and posted.
  • Insure that all selected vendor payments have been fully posted through Bank Withdrawal.


Refresh Balances and Agings

  • Go to Transactions - Accounts Receivable. Click "Refresh Customer Aging".
  • Go to Transactions - Accounts Payable. Click "Refresh Vendor Aging".
  • Go to File Maintenance - General Ledger - Chart of Account. From Action menu, click "Refresh Account Balances"


Run Reports

The reports listed below will be ran from Report Manager. You will be saving an Excel version of the report and a PDF version. Once the report data appears on screen:

  1. Click the drop-down box "Select a format" and choose "Excel".
  2. Click the Export icon to the right of the box. Save the report in a known location or folder.
  1. Click the drop-down box "Select a format" and choose "PDF".
  2. Click the Export icon to the right of the box. Save the report in a known location or folder.

These are the date-sensitive reports that you must print to file (PDF and Excel), as they cannot be ran at a later date back for a prior date cutoff.

  • AR Detail Aging
  • AP Detail Aging
  • Unmatched Receipts - Purchase Order
  • Unmatched Receipts - Vendor Direct Orders
  • Unmathced Receipts - Rework Orders
  • Unmatched Receipts - Land Cost Details
  • Inventory Valuation Report - Detail
  • Inventory Valuation Report - Virtual Stock

 I found this article helpful. (0)