This report shows you cash in and cash out across all bank accounts for each client, as well as the count and value of unreconciled bank statement lines. This report contains 6 pages, each with a different view of the report. The page menu is located across the bottom of each page.
You can also use the filters on each page's left and right corners to view the metrics with a more specified look.
The first page of this report is an overview of banking summary metrics for each of your clients. Here you can see: (in order)
Client
Last sync for the client
Bank account currency
Amount of unreconciled bank statements, amount of reconciled bank statements, total amount of bank statements
Monthly average of bank statements, percentage of unreconciled statements, percentage of reconciled statements
Amount at risk from unreconciled statements, amount from reconciled statements, total amount
Cash in, cash out
From-to (date range)
Platform (Xero, QuickBooks, MYOB)
The second page, Banking per Day, shows you the banking summary metrics for your clients filtered by day.
The third page, Banking per Role, shows you the banking summary metrics for your clients filtered by role.
The fourth page, Unreconciled per Role, shows you the unreconciled bank statement lines for your clients by role.
The fifth page, Bank Accounts per Client, shows you the bank accounts per client and its statistics.
The sixth page, Bank Accounts for Client, shows you the bank accounts for each client and similar stats to the fifth page with an additional chart of total cash movement.
