Hi Jane
Please see attached excel workings sheet I was able to throw together based solely on the bank statements.
I calculate an annual loss of £3,999.94. This differs to the reconciliation on the sheet which is a loss of £2,433.91. I think there was just missing expenses in the original calculations.
-
Tab 1 (Bank Rec) – full bank reconciliation for the year going through each transaction
-
Tab 2 (Reconciliation) – Loss per bank statements VS Loss per the workings sheet provided in the physical folder. Difference of £1,566.03
-
Tab 3 (Expenses) – a summary of all the expenses categorised based on the bank statements
-
Tab 4 (Breakdown of expenses) – a full breakdown of the four largest expenses for visibility
Based on this, I would be satisfied with the bank reconciliation. Everything seems to be accounted for from the opening balance to the closing balance. All transactions look to be related to the Mens Shed and nothing stands out or looks out of the ordinary.
The only thing I was unable to tell was the petty cash. I think I seen there was a closing balance of £170 cash but didn’t have an opening balance. Although, during this year it looks like most payments were made digitally. Even to Mullins Hardware etc
Thanks Ronan