Forum Discussion
Deposit summary report vs. bank statements
Hi, We're trying to create the following project. I would appreciate getting some input on how to program it correctly. As a healthcare billing company, we post all account receivables to the patie...
shlomo08701 Not sure if I fully understood, but you could create a pivot table on the basis of the Deposit Summary (see Sheet1). No complicated formulae needed! Use that pivot table to match the total amount per Deposit# to the DEPOSIT_DATE_ANALYSIS sheet (as demonstrated in column E of that sheet), using a simple VLOOKUP function.
I’m looking for a formula to match the deposit summary report to the bank statements to highlight which deposits in the bank statements are MISSING in the deposit summary report. I would prefer not to use pivot tables at all.