01604 420057



A highly experienced bookkeeping training and IT services team that will go the extra mile

Keeping Your Sage Tidy

Time for a declutter ...


Posted by Alison Mead on 02/01/2024 @ 8:00AM

When you have been running your Sage accounts software for a few years, or when you have a very high volume of transactions, it can be worth having an accounts declutter and a bit of a tidy up session ...

Keeping your Sage accounts tidy can be confusing. Here's an idea, have a hand-holding session with me!

Keeping your Sage accounts tidy can be confusing. Here's an idea, have a hand-holding session with me!

copyright: sifotography / 123rf

This means that your accounts software will speed up running reports, data checks and backups as there will be less data for the system to trawl through.

"Before having a tidy up session, make sure you have a company archive set up, which is part of the year-end process!"

You can access your company archive through File->Open ->Company Archive and just double-check you can see your company archives and that they have been converted correctly to your current version.

A company archive is a snapshot of your data from the time you ran your last Sage year-end process and cleared the audit trail (or old transactions). This data will not be touched so you can use this for reference.

It would be best if you then ran 'Clear Audit Trail' in your current data up to a sensible date for you. Most of my clients keep at least 2-3 years of live data, although if you don't have a considerable number of transactions, you can go back as far as you like. My previous post Spring Cleaning your Sage 50 Accounts Software goes through all the areas you can clean up in Sage after clearing your audit trail.

"Judge it on performance as you can delete and remove one year at a time and see how that improves the speed of your reports!"

To see where you last cleared your data to then go to Help->About and under configuration information you can see the Clear Audit Trail Date. Before running clear audit trail, make sure you match any invoices to prepayments/credit notes in your customer and supplier ledgers otherwise these will not be removed even if they are dated before your clear audit trail date. Unless they are 'matched' in this way, Sage will think they are still outstanding.

Once the audit trail is cleared, you can delete any old customers or suppliers who now have no transactions on their account. To be deleted a record must have a zero balance, no transaction history, and not be associated with a project. If a transaction is 'related' to a transaction after the clear audit trail date, then that will also not be deleted.

So, for example, a customer may have an invoice raised 30th May 2023, but it wasn't paid until 1st January 2024. If the clear audit trail date of 31st December 2023 is chosen, neither of these transactions will be deleted as the payment is after the clear audit trail date and the invoice is 'related' to that payment.

Clear as mud? It's much easier to go through this in a hand-holding session than in a blog post!

Until next time ...



Would you like to know more?

If anything I've written in this blog post resonates with you and you'd like to discover more, it may be a great idea to give me a call on 01604 217365 and let's see how I can help you.

Share the blog love ...

Google AMP  /  Précis  

Share this to FacebookShare this to TwitterShare this to LinkedInShare this to PinterestShare this via Buffer

#IT #Xero #Sage #Training #UK

About Alison Mead ...


Alison loves bookkeeping and supporting bookkeepers. She has been helping clients to be better bookkeepers in Sage 50 for over 24 years and has been Xero Accredited in accounts and payroll for a number of years too.

She specialises in a very unique hand-holding method of training, helping bookkeepers and business owners to use their accounts software as and when they need support in setting up and producing their invoices, reports and financial information.

Alison combines her role at Silicon Bullet with her Forever Living network marketing businesses and is often to be seen at business networking meetings as she likes to keep busy.

You know what they say: if you want something done well ask a busy person!


01604 420057