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

The Role of Machine Learning in ERP Data Analytics

23 October 2024

ERP data analytics have never been faster or smarter. Find out how machine learning is transforming ERP.

Metaltex Ltd Partners with Xperience for Enhanced ERP Soluti...

4 October 2024

Find out how we solved Metaltex's challenges with a bespoke ERP solution - Microsoft Dynamics 365 Business Central.

How to create a new user in Sage 50

21 June 2024

Discover how to create a new user in Sage 50 with our instruction guide.

How do I correct a mistake in Sage 50?

18 June 2024

This guide covers editing, deleting, reversing, or unallocating transactions on Sage 50 Accounts to save you time and ensure accuracy.

How to allocate a credit note or payment on account to an in...

18 June 2024

Read more...