Thanks for your response.
The deposits are made to the bank automatically from the donations offline. Each donation does not have a deposit. It is a collection of donations that make up a deposit. Some of the donations are from subscriptions and some are live from the website (via plug in).
The challenge we have is that we do not when a deposit is made to the bank, which donations the deposit is for. Sometimes it is just one donation but a lot of times it is a sum of multiple donations, and it gets complicated to manually figure out the donations that deposit is for.