Forum Discussion
Best method to find variances between checkbook deposits and GL deposit transactions
There are elegant solutions to finding the subset sum of a given check book deposit total. However, the fact the checkbook date of 8/1, for example, may have GL deposits from multiple dates is the part that makes this difficult. If we disregard the GL dates in your example, both 2500 and 4500 have several ways to arrive at those totals. There must be something in those GL rows that would associate a given entry with the checkbook dates of 8/1 or 8/2, for example.
Thank you for your reply.
There must be something in those GL rows that would associate a given entry with the checkbook dates of 8/1 or 8/2, for example.
Unfortunately, there is not. This is the sad reality of merging data from two different platforms (at least the two we have 😕). While there is technically a partial deposit ID associated with the GL pieces, there is no easy way to connect it to the data and export truncates the ID, removing the unique identifier.
Thanks again for your help.
