BankRec 3.4.0 Release Notes
Reconciliation Selected Row Count
The reconciliation window now includes a Selected count to let users know how many records have been selected within the group.
The Selected count also works in a tree data structure, allowing the user to easily track down the selected records within each level.
Reconciliation Group Totals
If records are now grouped together regardless of category it will display the total debits and credits at the bottom of the group.
The group totals will be displayed at every level when multiple group categories are selected.
Reconciliation Select/Deselect All Group Records
The select/deselect functionality has been expanded to allow an entire group and the child groups to be selected/deselected at once. This can be done by highlighting the parent of the child group(s) the user needs to mark as selected/deselected. Once highlighted click the Selected Highlighted or Deselect Highlighted button.
A warning message will be displayed to alert the user on what is about to happen, clicking Yes will proceed with the select/deselect process.
Reconciliation/Batch Entry Add Functionality
Functionality has been added to remember the Bank, Transaction Date, Type when adding multiple records. This functionality is triggered when clicking the Save & New button.
Reconciliation – Void Date
Reconciliation/Ledger Entry Cleared
A Cleared checkbox has been added to the Reconciliation/Ledger Entry when Adding/Editing a transaction. Checking the Cleared checkbox will mark the transaction as selected.
Reconciliation – Void Date
The void checkbox will automatically set the date on the void date when checked. Deselecting the void checkbox will clear the void date.
History – Statement Information
The ending period now displays the End Date instead of the reconciliation date. A new field was added to display the reconciliation date.
Statements Report
Increase Opening/Closing balance font, balances display 2 decimal places, and added comma separators for easier reading.
Reconciliation window font size increase
Font size was increased in the Statement Information section under the Reconciliation window for easier readability.
Bank Import
Bank import now has a field to select a bank to import, it can now process non-check/check transactions at the same time. A BankImportSetting table has been added to the database to configure the reading of the file and match the rows to the database records.
SMIGL – Summarization of Transactions
In the Payables tab within the Disbursements window, logic was added to be able to summarize non-check transactions. If the setting is enabled in the database it will take the non-check transactions and summarize them into one transaction per entity/attorney. The summarization of the transactions helps with manually matching and without this feature auto matching would not work. The functionality is triggered when the Print button is clicked.
Current Period
A current period has been added to use instead of the end date in the statement history. The field is editable in the Bank Edit window. This value should never need to be modified once it has been set correctly, as it will be auto incremented each time a post is done.
The current period field exists in the Reconciliation window as a read-only field. This does allow your end date to be left beyond the actual date that you are trying to balance. Allows you to see transactions incoming at the start of the next month, on occasion you made need to include some transactions from the subsequent month.
In the history window the year/month will be grouped based on the current year. If a current period does not exist, it will default to the end date.
Full mapping of Bank’s electronic CSV statement file (New Bank Import)
We have added user-defined mappings to match all transactions that are in the Bank’s electronic statement file. This allows us to format their statement and show it side-by-side with the SMI transactions. These transactions or groups of transactions can now be either auto-matched or manually cross-checked.
New Bank Statement import
This function allows electronic bank information that has been downloaded from your Bank’s secure web site to be imported into the Bank Rec. The format must be either xlsx or csv for it to be successfully imported into the system.
Note that the data from different banks can be in varying formats and, initially, needs to be mapped and configured by SMI. This data is held in the BankImportSetting table.
Deposit import from Tax
This is a very important tool that allows deposits from the tax system to be imported and manipulated before being inserted into the Bank Rec.
The user can assign a date range and import all non-imported batches within this specified range. These deposits can then be inserted one by one into the system or can be grouped before creating a single deposit. This is useful when multiple batches are shown as just a single total on the bank statement; e.g. Checks may be collected from each station but are deposited as a single deposit.
Advanced Reconciliation
This feature allows the user to reconcile their outstanding Bank Rec. transactions against the imported electronic bank statement using a side-by-side or ‘peeled off’ window to a second monitor.
The ‘Auto Reconcile’ option requires no manual intervention as the software will, automatically, try and match up ‘like’ items from the Bank Rec. to the Bank Statement. It follows these rules in order:
1. Checks where type is check and reference numbers match and amounts equal
2. Match on Date, Reference, DenitAmount, Credit Amount, Sub-Type and Type
3. Match Group total on Date, Type and Sub-Type
4. Match Group total on Date and Type
This would, always, be the first option to choose as all transactions that could, possibly, be matched will be done without any manual intervention. After this point you will go back to manually selecting individual transactions.
All reconciled transactions will be hidden from view with the aim of having NO transactions left in the Bank Statement window.