How to Close the Fiscal Period & Fiscal Year in X3

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 [email protected].

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

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.

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.
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.