Skip to content
logo Knowledgebase

Accounts Receivable Year-end

Created on  | Last modified on 


Accounts receivable year-end process

  • Enter all the invoices, orders, receipts, etc. and post to the subledgers and the general ledger.
  • Complete your period end transactions (interest batches, retainage batches, write off batches, recurring transactions).
  • Identify what items need to be completed for your fiscal year end vs. calendar year end.
  •  Back up your databases.
  • In Common Services > Fiscal Calendar, create a new fiscal year (this is only done once).
  • Lock any fiscal periods in current and new fiscal year that are not needed to reduce likelihood of data entry errors.
  • When working in the modules to clear out data, make sure that no one is entering in transactions or working in the module.
  • See the year-end checklist for more information about the entire process. The Sage300ERP_Checklist_YearEnd.pdf is located in the \DOCS\XXA\ENG folder where XX represents the version of Sage 300 you are running.


Under Accounts Receivable periodic processing

The following items are optional parts of the year-end process:

  1. Clear History (optional):
    a. Print reports of the data to save before clearing out since after this activity is performed, data will not be available for access or inquiry.
  2. Delete Inactive records (optional):
    a. Date range refers to the day the record was made inactive.
    b. To mark a customer inactive, the customer must have a zero account balance and there must be no outstanding transactions. The fully paid documents for that customer must first be cleared in the clear history tab before deleting the inactive customer here.
  3. Year-end (optional):
    a. Reset all batch numbers removes transaction history and all drill down capabilities.
    b. Clear activity statistics moves current year activity statistics to last year activity statistics and sets new year totals to 0. Also allows option to clear invoices paid and days to pay counter (found in the statistics tab on the customers screen).
    c. Clear recurring charge year to date statistics is also an option.