Forum Discussion
Best method to find variances between checkbook deposits and GL deposit transactions
I'm looking for a way to find variances between checkbook deposits and General Ledger deposit transactions. Single checkbook deposits post to the GL as multiple entries (deposits are exported to the...
=IFNA(INDEX($B$2:$B$5,MATCH(SUM($F$2:F2),$C$2:$C$5,0)),"")This returns the expected result in my sample sheet.
=SUM($B$2:B2)This is the formula in cell C2 that creates a helper column.
The assumption is that each checkbook deposit is fully distributed to the general ledger account before the next deposit is distributed to the general ledger.
Thank you. I was excited to try the formulas, but I am finding that the GL pieces are exported randomly and arranged by date. It does not appear that a deposit is fully distributed to the GL before the next deposit is distributed. However, I will keep this in mind for other applications.
Thanks for your help!
