The Bank Reconciliation Dashboard provides assistance with reconciling cash accounts. Importing cleared checks should be performed prior to using the dashboard and any changes made via the dashboard will be lost upon importing cleared checks.

   

Use the Engagement Documentation dashboard to associate client documents and notes with objects in BalanceWare.

Notes and documents can be linked to the following items (on a per client basis):

• Any journal entry (no icon, double click on preparer notes instead)
• Any cash disbursement batch (no icon, double click on preparer notes instead)
• Any other document (using the Documents button from the Client tab)
• Any BalanceWare form (using the icon, below)

 Look for the Engagement Documentation icon on BalanceWare forms.

 

Clicking the icon will open the Engagement Documentation dashboard. In the case of journal entries and cash disbursement batches, double-clicking on the Preparer Notes field accomplishes the same. Once open, click on any attachment to open the document.

Engagement Documentation Dashboard (with callouts)

See the Review Notes button on the Client Tab for reviewing notes from all sources within BalanceWare. 

Note: to maintain link integrity, do not manage documents from Windows Explorer. Moving or deleting client documents may break links. Documents can be edited and documents can be added using Windows Explorer, but do not delete or move documents or folders. Broken links will be placed in a special folder in the Documents treeview called "Orphans" and can be relinked from this special folder.

The Bank Reconciliation dashboard provides the ability to manage clearing discrepancies, clear a check, unclear a check, add and delete checks, etc. Other useful Bank Rec Helper tools include the Bank Rec Helper report and the ability to export the bank reconciliation data to Excel.

The Bank Reconciliation Dashboard

The Bank Reconciliation Dashboard 

Bank Account

Select an account from the dropdown field. Disbursement accounts assigned to cash disbursement journals will be populated in the dropdown box. Use the F12 key to quickly navigate to the Bank Account field.

A video on this Help Topic is available on our Video Page.

View 

There are 3-views in the Bank Reconciliation Dashboard. The default view is All Checks, but the view can be limited to Current Year Checks or Outstanding Checks. Use the F11 key to toggle the view setting. 

Edit P/Y Outstanding

The prior year outstanding check list is created during the year-end close based upon the prior year bank reconciliation. This information can be edited by clicking on the Edit P/Y Outstanding button or pressing Ctl-E.

Bank Reconciliation Totals 

In the upper right-hand corner to the Bank Reconciliation Dashboard are the totals for various lines of a traditional bank reconciliation.  

Bank Reconciliation Continuous Sub Forms

The BR Dashboard has 4-continuous sub forms, as follows: Discrepancies, Un Cleared, Un Issued and Cleared. The buttons in the footer of each sub form are tools for managing the reconciliation process.

Clearing Discrepancies

The two tools (buttons) allow for:

• Check Edits via the Cash Disbursements Form 
• Un Clearing the Check

Uncleared Checks

The two tools (buttons) allow for:

• Check Edits via the Cash Disbursement Form
• Mark the Check Cleared

Unissued Clearing Items

The tool for un issued's is a Delete Item button. These items would originate from an import of cleared charges.

Cleared Checks 

The two tools (buttons) allow for:

• Check Edits via the Cash Disbursements Form
• Unclearing the check 

Import Cleared Charges 

Many clients will have online banking with the ability to download cleared charges. BalanceWare can import this data and as a result, the bank reconciliation is almost completely automatic. Clearing discrepancies may exist and BalanceWare locates all discrepancies on the Bank Rec Dashboard, making it a simple task to finish the reconciliation.

The column headings must be as shown in Row 1 on the illustration below. There can be additional columns on the spreadsheet which will be ignored. Elimination of unwanted rows is recommended to avoid extraneous data which may create strange results. The worksheet to be imported must be the first tab of a multi-sheet workbook.

Import Cleared Charges Form

Cleared Checks & Charges Import Template

After completing and saving the Excel import workbook, return to the BalanceWare import form and click on Proceed and a Windows Explorer will open. To complete the process, select the import workbook.

Export Bank Rec 

The bank reconciliation data can be exported to Excel by clicking on Export Bank Rec in the ribbon. A Windows Explorer window will open. Select a location and name the Excel file. The default folder is the client's folder.

Bank Reconciliation Excel Export

Support Ticket 

Submitting a support ticket is the best way to expedite your issue. The support ticket automatically includes information we need to service your installation properly. By submitting a support ticket, we won't have to ask you all the preliminaries and, if you add a brief description, we will be better prepared to get to the heart of the matter ! We receive your ticket immediately upon submission and will respond ASAP; usually within minutes. Submit your support ticket from the About form on the Help tab.

Download AeroAdmin remote desktop software here.