Running Year End with Sage 200cloud from DB Computer Solutions – Some Tips

Running Year End with Sage 200cloud from DB Computer Solutions – Some Tips

For some of us, the end of the calendar year is also the end of our Fiscal Year. Which means it’s once again time to run year end. If you’re using Sage 200cloud from DB Computer Solutions, here are a few things to consider:

The Year End That’s In It:

Companies usually organise their accounts over a specific period of time, known as the financial year. This is usually a 12-month period, which is why Sage 200c is set up this way.

At the end of each financial year you need to make sure your accounts are up to date, get any information you need for statutory and compliance submissions, and move Sage 200c into a new year.

When to run your year end

You should decide this with your accountant. Ideally, you should run your year end when you’ve posted all the transactions for your current year and completed all the year-end tasks and checks. This doesn’t have to be on or near the date that your current year ends. In Sage 200c, you can process transactions that are dated in your new year, before running the year end process.

Things to consider

  1. You can only run the year end once, so make sure that you’re ready.
  2. You don’t have to run the year end on the last day of your financial year.

You can run the year end process at any time. For example, if your financial year ends on the 31st December, you may not be ready to move your accounts to your new financial year until the end of January.

  1. You can post transactions dated in your new financial year before you run the year end.

This is just the same as posting transactions into any Future period. The transactions will update your customer and supplier accounts but they are not posted to your nominal accounts until the period is opened. You can’t open a period in a future year until you have run the year end.

This mean that you can start processing for your new year whilst waiting to finish off the old one.

  1. You can’t post usual transactions into a previous financial year.

This is because all the accounting periods in your current year must be closed before you can move to a new financial year. Any transactions that are dated in your previous financial year will be posted to the first open period in the new year and therefore accounted for in your new year.

We recommend that your make sure all your current year transactions are posted before you run the year end.

  1. If you do need to make adjustments to a previous year, you can post a previous year journal which updates the closing balances.

These are likely to be adjustments provided to you by your accountant.

  1. This process may take some time to complete, depending on the amount of data you have.

We recommend that you run the year end process at a quiet time or after hours.

  1. Are you consolidating several subsidiary companies into a single parent company? If so there are extra steps that you need to complete as part of the year end process. Contact DB Computer Solutions for more information.


Running the year end is a straight forward process as long as your accounts are up to date and you have completed the recommended tasks and checks.

The tasks and checks we’ve outlined below are those we recommend and are common to most businesses. However, you’ll need to check with your accountant or auditor in case there are other things you need to do for your business.

Make sure your accounts are up to date

  1. Post all day to day transactions and allocate as much as possible.

You don’t have to allocate everything before the end of the year, although it is good practice. You can still allocate transactions even when they’re posted in different financial years.

  1. Remember to post any transactions that you normally enter at the end of a period such as prepayments and accruals.
  2. Process your standing orders and direct debits up to the end of the year.

You can’t close a period until you’ve done this.

  1. If you use foreign currencies, revalue your bank accounts. This makes sure that your balance sheet reflects the correct bank balances and that any gains or losses due to currency fluctuations are reported on your profit and loss.
  2. Enter any correction journals that your accountant has given you. Don’t forget you must do this before you close the relevant period.
  3. Reconcile your bank accounts. Although this is not essential, it is good practice.

Print and check your reports

Your accountant or auditor will usually let you know which reports you require. We recommend that you check the following as a minimum:

  1. Your final Trial Balance.
  2. Your Profit and Loss, and Balance Sheet.
  3. Your Aged Debt and Aged Credit reports and reconcile them with your Debtors Control and Creditors Control
  4. Print any other reports that you want to keep for your records. You may want to check with your accountant or auditor which reports are required.

Year end process

  1. Close your accounting periods.

All accounting periods in the current year must be closed before you can move into the next financial year.

  1. Back up your data.
  2. Run the year end option.

What does the year end do?

  1. Transfers your profit (or loss) for the year to the Accumulated Profit nominal account.

A report is produced that shows how this has been calculated.

  1. For profit and loss nominal accounts:
    1. The Year to date balance is set to zero.
    2. The Balance this year is set to zero.
  2. For balance sheet accounts:
    1. The Year to date balance is carried forward to the new year.
    2. The Balance this year figure is moved to the Balance last year.
  3. Moves your financial year forward.
  4. Resets your current periods to 1.

For more information or advice, we’re right here to help.              061 480980              

Leave a Comment

Your email address will not be published. Required fields are marked *