The first button on the left of all ribbons have a Timekeeper On / Off toggle button which allows BalanceWare to track time by client. See the
TimeKeeper Dashboard help topic for details.
Beginning Balances Form
The Chart of Accounts must be built before entering Beginning Balances manually. If the option to roll balances forward during the Year-End Closing process is selected in the Client Profile, the Beginning Balances will be populated automatically.
The chart of accounts cannot be edited on the History form. Open the Chart of Accounts form to make required edits and then return to the Beginning Balances form.
Notes & Attachments (Collapsible)
Use the Engagement Documentation dashboard to associate client s 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 (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.
BalanceWare will import a Trial Balance from QuickBooks, saved as an Excel sheet. Imports can also be done directly from a user created Excel sheet or a BalanceWare template.
All images in BalanceWare Help can be enlarged by clicking on the image.
The Beginning Balances Form
The Beginning Balances can be reset to -0- using the Clear Beg Bal's button or the F12 key. Account history for the selected account is available via the History button or the F2 key.
Navigation and Editing
Function Keys F5 (first record), F6 (last record) and F7 (new record) are used on continuous forms and continuous sub forms.
F8 can be used on any field to select or de-select the field contents.
To undo any edits use the ESC key before navigating away from the field.
All amount fields can be evaluated by terminating an expression with an equals sign.
TAB will change the focus to a sub-form and or the next sub-form.
Import BB
Beginning Balances can be imported from a manually prepared Excel sheet or a BalanceWare template.
Instead of creating your own Excel import worksheet, click on the Use a Template button to open a template for pasting data. The Excel template file contains instructions to produce an import with data integrity. Using a template is a good option for first time users.
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.
Beginning Balances Import Form
As with all imports, the account column must be formatted as text. After importing, remember to assign Statement Sections to new accounts.
The Beginning Balances 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.
Importing A QuickBooks Trial Balance
BalanceWare can import a QuickBooks Trial Balance. The QuickBooks Trial Balance should be saved as a CSV file or an Excel workbook.
A video on this Help Topic is available on our Video Page.
Saving as a CSV file is a straight-forward process. Simply select the Excel Button/Create New Worksheet on the top of the Trial Balance report. Then select Create a comma separated values (.csv) file from the available options. Pressing Export will open a file explorer where you can designate a location for your export. We suggest the clients document folder.
QuickBooks CSV Export Dialog
If saving as an Excel sheet. click on the Advanced button in the QuickBooks export dialog, and make sure the option for "Include QuickBooks Export Guide" is NOT selected. It is best to have all of the options turned-off in the Advanced selections.
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.
