Bank reconciliation report to show contact reconciled to
Bank reconciliation - A report that will show each bank transaction and then which invoice it has been reconciled against, as a way of having a quick way to check something has been reconciled incorrectly. Currently, the only way is to view each transaction through the account transaction report.
Catherine Sizer
shared this idea
Good to hear you're aware of how you can run the Account Transactions report to view this information, Catherine - Is there a reason or something missing from this report that would help you when reviewing transactions?
-
Jennifer McWhirter
commented
Sorry to jump on this, the piece of missing information from the account transactions is the narrative from the original statement line.
Often the statement line description includes the details of the payment that will dictate how this should be reconciled, for example, 'John Smith, Invoice no. 3' but this could be incorrectly reconciled against an invoice for 'Bruce Smith' which is for the same amount.
The only way to find this type of error at the moment is to click into each transaction that has been reconciled to make sure the contact matches the description. If we find an error and want to check all of the reconciled transactions for a period, this can take hours.
-
John Pitman
commented
What is missing?: Invoice date and transaction date on the same screen;
Bank narrative and Invoice description on the same screen.
Account coding at the same time would be a useful check
This would save a few cases of RSI through mouse clicking!