Then choose what you need from the window to find the unpresented bank transactions at the y/e say y/e 31/12/2012
Click 'new' so it becomes 'where',chose the field to be nominal code, condition equal to, and value to be says 1200, same principle for next line...
Then click in the box below and chose 'and, then 'date' , then 'is less than or equal to' then 31/12/2012
Then click in the box below and include 'and' , 'bank reconciled date' , is greater than' and 31/12/2012
Anyway, then click on File, choose office integration and then choose microsoft excel and you will fire out these figures into excel for you to print and play about with.
I think that's it . Sorry I've no paperwork at home to check. But hopefully you get the gest and can tweek at your hearts content without messing anything up.
But have a play around with the filtering because you can find all sorts of handy things.
-- Edited by Anniesplace on Friday 17th of May 2013 01:58:28 PM
-- Edited by Anniesplace on Friday 17th of May 2013 02:00:58 PM
My end of year bank reconciliation report has been misplaced (*not to self must take copies) is there anyway I can re generate the report as I cannot print the same report on Sage as I have now reconciled into the new financial year.
HELP my accountant needs the reconciliation urgent.
Hi Charliesmum.... it was the bank rec you were after wasn't it ie the bank balance less o/s cheques etc agreeing to sage balance. My report will just give you the unreconciled items at your y/e.
Michelles report is one I have not used before but I think it shows transactions on a particular day plus the opening balance. Just like the a print of the nominal activity report chosing the bank , date and ticking for the b/f balance to be included.
Why not just tick up the final month of sage to the bank statement and that should give you what you need?
Yep, this is what I'd do too. I always do this anyway (old school !) Print off nominal activity for the bank in question making sure you tick the "include b/f" box and then physically tick off the transactions from the bank statement. Then deduct any payments not on the bank statement and add any receipts.
