What schedules should I prepare for the year-end?

At your business year end it’s important to have clear and concise figures that both you and your accountant can decipher. You need to understand your financial status as does your accountant, so that you can make important business decisions. You need to be able to back up, substantiate, verify or validate all of your figures that you hand over.

If you’re unsure of what schedules you should prepare for your period end or year end then take a look at our Sage 50 Management Accounts Excel Schedules. 

We have seven plug-and-play template Excel files for you to download, which you can start using straight away, and tutorials to guide you through how to use each schedule.

We teach you how to prepare the schedules and reconcile them against your Sage 50 Accounts and walk you through what reports to run and check that they agree.

It doesn’t matter what stage you’re currently at, if you’re already comfortable with some journals such as prepayment and accruals but not all, then you can start off using some of the schedules and use others when you become more confident in doing so. 

What’s included?

✅ Intro Video with explanations

Learn more about why we have included these schedules and what you will get from them

✅ Accruals Schedule Template & Tuition

Learn how to compile this schedule, where to get your data from, how to easily update it and how to reconcile it back to your accounts.

✅ Prepayments Schedule Template & Tuition

Probably my favourite schedule. Understand how to use this detailed schedule to keep on top of what makes up your prepayment figure

✅ Staff Accrued Holiday & Bonuses Schedule & Tuition

Something a lot of people don’t do, but accountants we work with request, is a schedule which calculates the staff holiday values and any bonuses relating to the year-end period. We give you a detailed walk-through of what to prepare and calculate.

✅ Fixed Asset Summary Schedule

A fixed asset summary example which shows each pool of assets and how hey can be represented together to provide this summary to the accountant at year-end.

✅ Office Equipment Asset Schedule & Tuition

Learn more about why asset references are helpful, more detailed around managing disposals and why this is a useful schedule even if just for your internal recordings.

✅ Computer Equipment Asset Schedule & Tuition

Learn how to use the schedule and monitor depreciation methods and rates for you postings a well as how to cross reference and reconcile them to your Trial Balance and Balance Sheet.

✅ Plant/Freehold Improvements Schedule & Tuition

A summary schedule with guidance on details breakdowns and an example of depreciation methods. This is a good supplementary schedule especially if you need to recalculate the new financial year depreciation based on the prior years net book value (NBV) or written down value (WDV)

Whether you’re a business owner doing your own books or if you’re a bookkeeper helping clients with theirs, these schedules will transform the way you do your bookkeeping in Sage 50 Accounts.

We have also built a community for Sage 50 Accounts users, where you can turn to for support at any time of the day, and no question is a silly question. 

We’re a community of like minded people offering that extra bit of support. Join us on Facebook now…

I look forward to seeing your in the group


“Any advice relating to accounts or tax should be sought from your tax accountant. Sage Accounts Solutions Limited will not be held responsible for any loss or damage caused as a result of the information contained herein.”

Share this...

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.