Took on a new client who's accounts were already on Sage. The whole thing is a right mess! The first thing I want to sort out is the bank as there's an issue with reconciling it. There are half a dozen unreconciled transactions dating from 2006 - 2009. Leaving these transactions out means that the bank does (almost!) reconcile but this isn't ideal, I'd much rather they weren't there at all. What's the best way to deal with this?
One of my favourite jobs, as long as the client was paying!!!!! I found the way to deal with it was practice!
I often used to transfer all the transactions into a spreadsheet, where I could sort them, highlight in different colours, hide ones I'd agreed etc. And work off photocopies of bank statements so they got covered in ticks, crosses, different coloured highlight pens etc. Don't forget that a reconciliation that's a penny out could be thousands out one way, and thousands and a penny out the other!
