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

Material Shortages continue in Construction

19 October 2022

Find out more about the materials shortages in construction, what materials are affected and how ERP can help

The emergence of sustainable construction 

13 September 2022

One of the IT solutions that will be invaluable in helping the Construction industry become more sustainable is ERP. Read our blog to find out more

What is Data Warehousing and why do you need it? 

7 September 2022

With Data Warehousing you can enhance your data, save time and make better business decisions. Find out how, read the full blog.

Flexible working in Construction 

3 August 2022

Read more...