Bank Account Balance Analysis

The Bank Account Balance Analysis view will let you view all uncleared transactions for a bank account. This can be very helpful for making sure what you have in the bank and what you have in Shepherd's Staff match. Any transactions that have cleared the bank should be cleared through the bank statement reconciliation tool, so what you will see in this view are all the transactions that you did not mark as cleared in your reconciliation, older transactions that have yet to clear, or are transactions from beyond the date range of your bank statement that could appear on your next month's statement.

1. To access the Bank Account Balance Analysis tool, click on the "Plan/Analyze" tab in Finance, and then click "Bank account balance".
2. In the "Bank account" field, select which bank account you want to use in this utility.
3. The Uncleared section will show a sum of all payments, receipts and journal entries that have not been marked as cleared through your bank statement reconciliation, each in their own respective sections. Payments will also be broken down by payment type, showing both Checks and ETFs (Charge accounts are not represented here as they are applied to liabilities).
4. To the right of the uncleared section, you will see a few figures. The first figure, labeled "Current balance in Shepherd's Staff" provides the current balance of the bank account you selected in the "Bank account field" within Shepherd's Staff. The next figure is "Net uncleared activity" and it represents the sum of the three figures shown in the "Uncleared" section, or in other words, the amount your bank account would change if you backed out all uncleared transactions. The figure below that, "Balance expected in the bank" is determined by adding the "Net uncleared activity" to your "Current balance in Shepherd's Staff". This figure represents the balance you would expect if you backed out all transactions in the "Uncleared activity for the selected bank account" grid.
5. The "Uncleared activity for the selected bank account" grid shows all uncleared transactions where the bank account you selected in the "Bank account" field is being used. You can click "Export" to send this grid to a spreadsheet, or, you can click "Print" to get a printed report of this information, including the figures at the top of the view.