What am I looking for? - I need 12 months of transactions reconciling. This includes validating the line items on the bank account statement, reconciling debit and credit card receipts, checking customer payments against invoices, and checking for duplicate payments and any payments we made to suppliers.
What do you need to give me at the end? A spreadsheet in Excel format listing every transaction, its reconciliation status - reconciled and a reference to the supporting evidence; and where it doesn't reconcile, mark it as Query and add a note with what the problem is, i.e not on bank statement/duplicate etc.
By when? - 17:00 GMT London, Saturday, 30 December 2023.
Who are you? - An experienced bookkeeper/accountant who can use Excel and knows how to make it work for you with functions like VLOOKUP(). Don't consider this proposal if you plan on doing this manually line by line. Preferably, you'll also know Xero, as we're looking for someone to help us get that in order - subject to a new proposal through PPH.
Context - The business has implemented Xero; however, the staff have been doing their own thing and using multiple sources to raise invoices, track payments made/received, etc. They have not reconciled their transactions. The result is the closing balance cannot be relied on. They trade in GBP and USD with the odd Euro transaction in there, less than 10 in the year. The conversion rate from USD to GBP was set at the start of each month and changed on the 1st of the following month.
Spreadsheets available - Exchange rates from GBP to USD, balance summary, itemised balance change from activity, itemised payout reconciliation, bank account transactions, sales invoice tracker, supplier invoices paid or owing, outstanding payments schedule and Stripe transactions spreadsheet.
Other - I expect you will have questions and possibly need further information. So, this will probably take a few iterations, which is okay with me, and I will be available. It's more important we get it right, state any assumptions made in the notes and identify any variances.
