FacebooktwitterlinkedinmailFacebooktwitterlinkedinmail

It’s that special time of year again–the new year (and year-end for many businesses). Below is an outline of the steps required for period and year closing as well as period and year opening in Sage x3. The same steps will apply to all versions of the product. Please keep in mind that the steps outlined below are intended for users of x3 that have familiarity with the product. First year end or period end procedures should be supported by your certified X3 business partner. For more information on support for closing and/or opening processes contact your business partner or x3support@xkzero.com.

Closing a Fiscal Period in X3

  • Open the new fiscal period
  • Open all the journal codes for this new period
  • Ensure all Deliveries are validated
  • Ensure all Deliveries are invoiced
  • Ensure all purchase receipts for the period are entered
  • Ensure all inventory adjustments / counts are validated
  • Ensure all customer returns are validated
  • Ensure all supplier returns are validated
  • Run the stock accounting interface
  • Close the ‘STOCK’ journal code
  • Record all work order production tracking transactions
  • Close and Finalize all work orders that have been completed
  • Run ‘In Process Postings’
  • Close the ‘WIPCO’ journal code
  • Close the stock status on the fiscal period that you are closing
  • Ensure all Sales invoices are validated
  • Ensure all Customer BP invoices are validated
  • Close the SALES journal code
  • Ensure all Purchase Invoices for the period are entered and validated
  • Ensure all Supplier BP invoices are validated
  • Close the PURCH journal code
  • Ensure all AP and AR payments are recorded and validated
  • Ensure all Banks are reconciled
  • Close all the Treasury Journal Codes
  • Perform all additional account reconciliations (AR, Inventory, Work in Process, AP, RNI, etc.)
  • Run the Final Validation function to change the status on all the journal entries in the closing period from Temporary to Final
  • Close the General status on the Fiscal Period

Closing a Fiscal Year in X3

  • Create and Open the New Fiscal Year
  • Open the first fiscal period in the new year
  • Open all the journal codes for this new period
  • All the Fiscal Periods in the Fiscal Year need to be Closed
  • Have all users log off the system – this step was mandatory in earlier versions of x3, but is still considered by many to be a good practice.
  • Shut Down the Accounting Tasks
  • Shut Down the Batch Server
  • Run the Year End Simulation – This is oftentimes referred to as the soft close because this function does not formally flag the fiscal year as closed, but it will roll forward your balance sheet accounts and reset your income statement accounts. This function is oftentimes used to initially perform the closing before the auditor’s adjustments are recorded into the system
  • Run the Fiscal Year End – This closing function is used to formally close out a fiscal year, again this function typically is not executed until after any year end audit adjustments are booked in the system.
  • Restart the Batch Server
  • Restart the Accounting Tasks

Guiding Principles & Helpful Hints for Performing the Close

  1. Remember that x3 is an integrated accounting system so the majority of the journal entries are going to be automatically generated for you by the system. The Lion’s share of the closing exercise is ensuring that ALL OF The transactions in the period validated. Establish the discipline within your user base to perform these validations on a daily basis.

Examples

  • Make sure the shipping manager is validating the deliveries as they leave the facility every day.
  • Make sure the production manager is closing and finalizing the work orders as they are completed.
  • Ensure the Accounting Managers are performing the bank postings on their AR and AP batches every day.

 

  1. Get in the habit of closing the subledgers (journal codes) and fiscal periods in a timeframe shortly after the end of the period. X3 can automatically generate accrual entries for inventory purchases and expenses so there is not a need to leave the period open for invoicing purposes. As a general rule the sooner your period is closed, the less likely you are to have errant activity to make its way into the period.
  2. Many organizations will perform the Year End Simulation step shortly after the end of the fiscal year so that their opening figures on their trial balance are updated for the new year, but will defer the execution of the fiscal year end until after the audit is performed because the Audit may not occur for a month or two. Continue the discipline of closing the periods in the new fiscal year. When ready to formally close the year, run the “Re-open Period” function to open up all months back to the last period of the last fiscal year. Once this is done, book the audit adjustment journal entry, finalize the entry, reclose the month, and proceed to rerun the Year End Simulation and then the Fiscal Year End function. The ‘Fiscal Year End’ function will formally close the year. The batch server and accounting tasks should be reactivated after the close is complete so that journal entries generated by the system will post into the new period. Finalize the new period journal entries that were booked in period 1, and then the months can be reclosed.