Friday, 20 May 2016

Bank Recon 4.7 is available

Bank Recon 4.7.1059.3321 is available for download from the Twenty57 website. Thank you to Shivkant for the development work.

New Features

  • Bank Recon now supports Chrome Browser
  • MT940 parser now imports a statement date using the last intermediate (62M) or final (62F) closing balance of the SWIFT message
  • SWIFTMT940/SWIFTMT950 parsers both populate Reference1 with the TransactionTypeIdentifier field and Reference2 with the AccountOwnerReference field


  • Recon rule preview now works correctly when using the Batch processing feature
  • The Recon rule description length has been increased to 300
  • The AutoRecon Batch processing mode now processes all matches of a batch instead of skipping the last one in the batch


  • Login page enhancements + autofocus on the username textbox
  • Display issue affecting the Bank Keys view from the Recon rule test feature has been resolved
  • The AutoRecon Batch processing mode no longer requires GetKeys commands for the left/right datasets


  • The Batch size used for the AutoRecon batch processing mode is now configurable (default: 1000)

Wednesday, 30 March 2016

Bank Recon 4.6 is available

Bank Recon 4.6.1050.3285 is available for download from the Twenty57 website. Thank you to Shivkant for the development work.

New Features

  • There is a new user right applicable to the creation of balancing entries for manual reconciliations:

  • When the setting is off, then any balancing entry created may only be associated to a single GL account:


  • The Manual Recon group detail view bug has been fixed. Selecting "Group By" and manually deselecting columns no longer shows an error when viewing the underlying transactions. Using the "Clear all" function to achieve the same result works as usual
  • The Manual Recon dynamic view filter option bug involving the @Date parameter has been fixed
    • Only the equality / inequality operators are supported at this time
  • AutoRecons configured to run across accounts which also use Helper transactions now work correctly
    • This involves transferring the original cashbook transactions into the target account and creating any missing cashbook transactions in the target account using the helper transactions
  • On the Easy Recon rule screen, the "Other Match" editor now works correctly when using the Reference1 field and any of the Reference10-Reference19 fields
  • The Manual Recon profile list now displays correctly on IE9
  • SWIFT MT950 bank statements with country codes matching Zimbabwe (ZW) / Malawi (MW) now import correctly


  • Open Bank / Cashbook batches can be reordered using the DateCreated column to show earliest / latest entry first

  • Export to Excel functionality has been added to the following screens:
    • Cashbook allocations
    • Grouped Cashbook transactions (Manual Recon)
    • Grouped Bank transactions (Manual Recon)
  • Auto Reconciliation performance improvements have been made for Reconciliations performed across accounts involving transaction transfers.

Tuesday, 2 February 2016

Bank Recon 4.5.1039.3252 is available

Bank Recon 4.5.1039.3252 is available for download from the Twenty57 website. A big thank you to Ashish, Jai and Shivkant for the development work.

  • Import definitions
    • BankRecon can now import transactions from Oracle stored procedures
      • Entering the name of a configured stored procedure will return a parameter list
      • One of the parameters must be selected as the Key value as per regular imports
  • Tagging across accounts
    • Tagging across accounts is now supported to complement searching across accounts
    • In the case that transactions have been tagged from multiple accounts, the account name is added to transaction grid to disambiguate the source
    • Tagged cashbook and bank transactions will open in the account in which they were tagged
  • Public Recon profiles
    • Manual recon profiles can be published to all users on the same account as a public profile
    • Public profiles will appear in other users' Current Profile dropdowns who have access to the same account
    • Any profile can be shown in / hidden from the 'Current Profile' list using the 'Manage Profiles' screen
    • Only the creator of a public profile may edit/delete that profile
  • Export to excel
    • Cashbook and Bank transaction exports now produce Excel (xlsx) files in addition to csv files
    • Reconciliations can now be exported in a single Excel workbook with 3 sheets:
      • Details: Shows the Reconciliation details (ID, Account, Accounting Period, User, Description)
      • Cashbook: Contains the reconciled cashbook transactions
      • Bank: Contains the reconciled bank transactions
      • When exporting reconciliations as a csv file, the 3 datasets are zipped into a single archive
  • Accounting Periods
    • There is a new setting on the Account maintenance screen to allow/deny closing an accounting period prior to the period's end date
  • Adjust Opening Balance
    • Accounting Period opening and closing balances for the Cashbook and Bank are shown
    • A help dialog has been added to explain the functionality
    • The earliest available Bank opening balance is displayed to illustrate the procedure and updating the bank opening balance now correctly propagates to all subsequent periods
  • Manual Recon screen
    • When grouping bank transactions, the filter is now applied to the underlying transactions and not the resulting group
  • Reports
    • Parameterless reports now display correctly in the browser
  • Generic CSV importer
    • The Generic CSV importer no longer attempts to validate the statement number when selected as part of a multiple file import since it does not use the statement number
    • Errors returned by the parser include the transaction number relative to the uploaded file and useful information on how to resolve any errors

  • Classic Recon rules
    • The classic Recon rule editor now supports a batch processing mode, which improves performance by executing the GetKeysCommands for a batch of matches instead of one-by-one processing
    • An example is available in the application to illustrate the procedure and changes required to the Recon rule
  • Auto Recon rule performance logging
    • In Site Configuration, there is a new setting, "AutoRule Log Enabled"
    • When checked, the consolidated duration of the left and right side queries of Recon rules are logged in the 'ReconRuleAuditLog' table, so that any poorly performing queries can be identified

Friday, 6 November 2015

Bank Recon 4.4.1019.3187 is available

Bank Recon 4.4.1019.3187 is available for download from the Twenty57 website. A big thank you to Ashish, Jai and Shivkant for the development work.

  • Process Queuing has been implemented. This will ensure only one process log item runs at a time, minimising concurrent calls to the database
    • The process items will execute in the order they have been kicked off 
    • An item will remain in pending state until it is first in the queue
  • Speed improvements to the Cashbook Import process
  • Bank Statement support for a number of Zimbabwean banks. See the help site for a complete list
  • You can now sort the transactions in the Matched section of the Manual Recon screen
    • The sorting is independent of the transactions list and you can only sort on one column at a time
    • The sort order is saved to profiles
  • Bank Recon now installs on Windows 10/IIS 11 successfully
  • Better error messages and an easier to read error pop-up if something goes wrong during the install
  • All errors are written to the log file and the log file can be opened from the msi directly in the case of install failure
  • You can read more on the msi logging functionality here
  • Swift parser now handles a file padded with spaces to make it fixed length
  • Process Log message time stamp is now saved in 24-hour format
  • The release notes have been moved to a page (Release Notes) in this blog. The Release notes link under the Help Menu will direct you to this page
  • Test Oracle Import definition now works correctly when the KeyValue type is Date
  • Ensure Across account recons don't cause table locking issues
  • Ensure the SMTP password isn't overwritten with no value every time you Save the Site Configuration settings
  • Ensure the SMTP password value is stored encrypted in the database. PLEASE NOTE:  This change requires us to clear any existing SMTP password value out of the database. If you have added SMTP settings to Bank Recon please update the password again after installing this version

Thursday, 27 August 2015

Bank Recon 4.2.983.3100 is available

Bank Recon 4.2.983.3100 is available for download from the Twenty57 website. Thank you to Shivkant and Ashish for the dev work

  • Bank Account currency column displayed on the Account List page
  • Bank Account Id displayed on the Account List page. This is to help with writing Easy Recon Rules
  • SWIFT MT940 Statement parser enhancements - process Statement Number Tag 28 instead of 28C
  • BAI Parser enhancements - process Custom Codes correctly, better handling of post-dated transactions on a statement, handle a comma in the 16 tag text field
  • Only allow an across account recon if at least one of the transactions in the match belongs to the selected account 
  • Accounting Periods: Allow editing of last accounting period name if manually added and allow delete of last accounting period if no data linked to it

  • Multiple Import of Bank Statements now shows Error Status and details if the import fails for some reason (files written to the Failed folder)
  • A Daily Process Schedule log item shows error Status if one of the processes inside of it fails
  • Use the correct Cashbook Transaction Type when transferring transactions between accounts
  • Display correct Batch Create User when viewing cashbook batch details through the All Batches screen
  • Group by in Easy Recon rules is creating the GetKeysCommand correctly
  • Same side cashbook transactions created by the Helper rule process are being moved to the Unreconciled tables
  • Ensure correct columns appear in the Manual Recon Cashbook filter view. Tag Name was being incorrectly shown and Account Name when searching in a single account
  • Alignment of grids and columns on the Daily Process Setup and Run Screens is fixed
  • Apply an Order by RowNumber clause to the query that generates the manual recon screen to ensure text fields are ordered correctly in all instances

We're taking a look at Bank Recon performance over the next couple of months. Improving the speed of cashbook imports, ensuring processes run efficiently, and updating queries to generate the screens faster. We'll also be looking at better management of concurrent users to make sure users on different domains and accounts don't block each other.

Tuesday, 10 February 2015

Bank Recon version 4.2.963.3056 is available

It can be downloaded from the Twenty57 website.


  • New PNB Paribas statement parser. It will accept the csv format
  • Changes to MT940 statement to apply a less strict statement number check. It will import a statement with a greater than number, not just the next sequential number
  • Ensure that the MT940 statement number reset in a new year works when statements are not generated daily. Any statement numbered 1,2 or 3 will be accepted
  • Remove a binary null character if present in a CATS Statement to prevent any errors in viewing the transactions on the UI
  • Automatically create the next accounting period if the expected accounting period for a bank statement is closed. eg. the statement Date is December, but the December period is closed. January will be created and the batch created in it
  • New column on Account table: Bank Account Currency. Allows null and accepts any text value up to 50 characters long
  • Email Tags can now be used with Forms Authentication. There needs to be a valid email address specified for the user sending the tag. Email is now an additional field on the user table
  • Explanations for some of the Site Config General Settings
  • Ensure General Ledger Export rights are persisted correctly to the Database when assigned to a User Group
  • Ensure the correct accounting period is used when a bank statement contains a backdated transaction and there are multiple open periods
  • Test Cashbook Import Definition now works when the query has an inner select statement
Thank you to Jai, Shivkant  and Ashish for the dev work!

Thursday, 6 November 2014

Bank Recon 4.2.949.3024 is available

A bumper release full of fixes and tweaks to existing functionality to make BR even easier to use as well as a couple of cool new features. Bank Recon 4.2.949.3024 can be downloaded from the Twenty57 website. Thank you to Jai for all the development work!


  • MT940 parser enhancements - Statement check ensures the current statement is the next sequential statement, Multiple import supported, Parser strips out newline characters in the details fields, all characters in the 86 continuation record are not imported (split over Reference 3, 4 ( and 5 if needed)
  • BAI Report - Statement Date included in the statement correctness check to help prevent duplicate imports of accounts which always have a zero balance
  • Allow Remove Setting on the Batch Type is honoured when deleting a Cashbook Batch
  • Rollback of Bank Statements removes empty statements
  • Rollback Cashbook imports has been implemented. Only the last import per definition can be rolled back. This will delete the transactions from any tags, remove all reconciliations and delete all the transactions and batches created as part of the import
  • Prevent duplicate Cashbook import running. If there is a process already running for the selected import, the current one won't run
  • Manual Recon across accounts process has been enhanced. Instead of creating a balancing entry and reconciliation for every transaction that needs to be transferred in order to make the match, the transactions are bulked and one transaction and recon is made per account. Because Recons across accounts are now linked (since version 4.2.877.2832 from April 2014), you can still easily see what the details of the source transactions are. This has resulted in significant performance gains when reconciling many transactions across accounts
  • Additional information fields have been added to the user table (First Name, Surname, Email and Last Logged in DateTime). If you are using Windows Authentication the name and email values will be synced directly from your Active Directory. The Last Logged in DateTime is updated every time a user logs into Bank Recon
  • If there is a First Name value for the user, this will be displayed instead of the login name in the Welcome message
  • Suggest Configuration settings have been moved out of Site Config and are now accessible by Admins and Site Admins (and other users if they have the appropriate rights)
  • SMTP settings are now in the Site Configuration page and saved to the Database rather than in the web.config file. We first check in the Db, if  no smtp settings are found there, the web.config file is checked. If no smtp settings are found at all then user won't be able to email a tag. You need to be using Windows Authentication to send emails from tags
  • Included Cashbook Batch Type and Cashbook Transaction Type in the CashbookTransactionUnreconciledView for writing Recon Rules. Both these fields are available in the Easy and the Advanced Recon Rule Editor
  • Setup and Admin tables styling improved to distinguish between columns more clearly


  • Test Import Definitions with >/>= and a Date value now works. Remember, BR always adds on 1 day to the last key value for a Date type when running the process so make sure you don't miss any transactions if you use these operators with a Date Value
  • Errors when trying to email a tag have been fixed
  • Better error messages are shown when manually reconciling transactions and the Balancing Entry and Transfer Transactions Domain Settings have not been configured. 
  • The schedule user now has all the necessary rights to import and reconcile data
  • Expanded menu items are not closed when the Dashboard automatically refreshes
  • Test Oracle import definitions now working correctly. You need to add the following settings to your config files
    • appSettings section of the web.config file: <add key="OracleImporterURL" value="tcp://localhost:8087/OracleImporter" /> 
    • services section of the ProcessService.exe.config file: <wellknown type="Twenty57.BankRecon.API.OracleImporterProxy, Twenty57.BankRecon.API" mode="SingleCall" objectUri="OracleImporter" />
  • The Framework version check is working correctly on the install. If you don't have .net Framework 4 installed, you won't be able to install Bank Recon