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

4 steps to changing business systems successfully

12 May 2022

It can be daunting changing your business systems, explore our 4 steps to ensuring a successful system change.

ERP systems vs. CRM systems – What is the difference?

6 May 2022

Discover the key differences in ERP vs. CRM systems and how each can benefit your business.

Mobile ERP technology: How to balance procedure and convenie...

21 April 2022

Mobile ERP technology can help you find a good balance between established business procedures, and convenience. Read more.

SaaS ERP Systems Vs. On-Premise – What’s the difference?

31 March 2022

Exploring the differences between having an on-premise and SaaS ERP system when deciding on an upgrade.

Management Reporting – how much is it costing your business?

21 September 2021