Run Your Year-End For Sage 200 Seamlessly With Our Guide

Published: 24 February 2022

Is the end of your financial year fast approaching? This can seem like an overwhelming task to some, however, to make this process as easy and stress-free as possible, we have compiled a list of preparation steps. Follow this Sage 200 guide, and feel free to bookmark it for future reference.

Bringing it back to basics, what is a financial year-end? 

Year-end is the act of closing a financial year and opening a new one for the coming year.  The process will also roll up your P&L Nominal Transactions to your Retained Profit/Loss in the Balance Sheet.  Some companies align their year-end with January to December, others align with the tax year in April, but there is no rule as to when you can start and end your financial year. 

You need to ensure your accounts are up to date and get any information you need for statutory submissions. 

Xperience Day 1

Our Year-End Guide For Sage 200:

  1. In preparation for running your year-end, enter all your outstanding transactions leading up to the end of the year.  Make sure that your journal adjustments have been entered, and that all Standard Cost Variances, accruals, prepayments, POP accruals, and any stock journals and adjustments have been entered.
  2. Update any waiting postings and pending transactions in all ledgers.
     
  3. Post any outstanding standing orders and direct debits.
  4. You should post all outstanding invoices on sales and purchase orders up to the year-end date, any invoices dated after can wait until the new financial year has started.  Year-End is also a good time to conduct a full stock take.
     
  5. Run any foreign revaluations for Sales, Purchase and Bank accounts.
     
  6. Run all your Sales Ledger Statements for all account customers.
     
  7. Run any management reports such as your Balance Sheet, Trial Balance, Stock Valuation, Profit and Loss, Aged Debtors and Creditors Reports.  Then export this these reports as a PDF so then you can keep them in your Year-End pack for future reference
     
  8. Make sure that your creditors and aged debtors’ reports are reconciled up to the end of your financial year for purchase and sales ledgers.  Again, this report should be exported for future reference.
     
  9. Reconcile all your bank accounts.
     
  10. Check any suspense accounts for values which should be journaled out.
     
  11. Make sure that you close all accounting periods for the year in Accounting System Manager > Accounting Periods > Maintain Accounting Periods.
     
  12. Make sure that the number and dates of all periods are correctly specified on the Future Financial Year tab.
     
  13. Remove any Disconnected Logins.
     
  14. Balance Ledgers.
     
  15. Take a backup of the data.
     
  16. Process Year End.
     
  17. Run a Trial Balance for period one.  Save a copy, and export this for future reference.
     
  18. Open the required number of accounting periods you need for the new financial year.
     
  19. Update waiting postings. This process updates the Nominal Ledger with transactions from the waiting postings file. Just be aware that this could take a while if there are many transactions to process.

Still need support?  Get in touch!

We have a wealth of knowledge around ERP software, Sage 200 is our speciality, all of our support staff have worked with Sage products for years and are Sage accredited.  Should you require any further support or wish to review your existing Sage 200 support provider get in touch with us and we can have a chat! 

About the Author

This article was published by Nicole Cowell, Senior Content Marketing Executive

Read More

How to use your ERP platform as a game changer for company g...

17 January 2024

Want to find out how you can utilise your ERP platform to accelerate growth? One of our expert's Simon shares his tips and insights.

Construction ERP: How to level up with Microsoft Teams

17 January 2024

Let's take a look at how you can use Microsoft Teams integration with your construction ERP solution, to streamline communications.

Business Central Streamlines finance for Boiswood

7 December 2023

Our latest client Boiswood adopt Business Central to streamline their financial processes.

Dynamics 365 Business Central and finance management

4 December 2023

Read more...