Some background: I took over the books for a small church bc I’m a CPA and they needed the help. I was fresh out of college with no real experience, which I told them. I ended up filing their form 990-EZ for 2023 and 2024. I essentially had to reconstruct their books off of the bank statements, which was a miserable nightmare, and I think I got it substantially correct.
Well as a part of my lack of experience, I got really behind on the monthly bank recs up until recently, and I’ve been trying to straighten everything out. I got 2025 down to $3.xx difference between book and bank since I’ve been preparing to file the form 990. I decided to reconcile January 2026 so I could see if it was off by the same amount so I could plug it in the right place and get the books right moving forward. Well I reconciled January, but it’s off by around $70. So I reconciled February. It’s off by about $120. I thought I was just missing a fee somewhere, but now I’m worried I’m doing it wrong altogether.
We have 3 bank accounts, and we accept donations through Venmo and Cashapp, along with cash, checks, card, and Tithely, so the recon can get a little complicated.
I’ve gone through all our accounts and matched it up to the bank/venmo/cashapp statements, and I’m not missing any transactions. There were some deposits I didn’t have and a couple amounts I fat fingered (all our books are in excel; can really afford much else), but I fixed those. Now I’m really stumped on what the issue could be and very frustrated. Any and all help/advice would be GREATLY GREATLY appreciated!