Forumla to reconcile receipts and bank account transactions

Try to explain this is a little tricky as it gets complicated but here goes ...

Within the spreadsheet there are two sheets, one for Bank Transactions and another for receipts.

I would like to match the receipts to the bank transactions depending on the amount and also the date of transaction. I am aware that due to the delays of bank statements I may need to add something to look for dates within 5/10 days either side of the receipt date.

Using these two criteria I would like to be able to return the matching receipt/transaction along with which bank account its from (Column of the Bank transactions sheet.)

I apologise for asking but have been trying for a few days now and coming up stuck.

Thanks Richard, my browser is not letting upload the workbook, any ideas ?

I have now uploaded the document, hopefully it will appear here ....