Hi Andrew,
Unfortunately we don't have GridView. Is there any other way to get this information? I can try going through our backups but I'm not sure how I would know what dates to look at as we haven't been doing our bank recs on any regular schedule. I do have the reconciliation posting journals but they don't seem to be of much use for what I am trying to do. I have been able to determine that some cheques were voided back to prior periods after the reconciliations were completed and have been able to "rebalance" (manually) the bank rec to Aug 31 (and match to GL), but this same logic didn't work for any of the months going forward. I think this is because I don't have the report balance for Sept on so I have tried to calculate it taking the Aug balance and adding/subtracting net cleared transactions in next period, but what I need is net transactions POSTED for each period. Is it possible to calculate this? I have tried to do so using a combination of the bank transaction and bank historical transaction reports, but this still doesn't seem to give me the total posted transactions for a month. I have attached a file so you can see my logic, but without knowing either the report balances at each period end or the total of posted (not just cleared) transactions for each period, I don't see how I can recalculate the balance.