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

Tuesday, 12 August 2014

Bank Reconciliation 4.2.917.2930 is available

It can be downloaded from the Twenty57 website.

Release Notes:
  • If a bank statement belongs in an accounting period that has closed, it will be created in the next open period instead of failing
    • It is best practice to ensure all transactions for a period have been imported before closing the period but you won't be punished if it happens
  • Work has been done to ensure BankRecon works correctly with different Server Date and Number formats
  • Install won't fail if the Reports cannot be inserted into the Database. This usually happens when the database was not selected as part of a clean install

Monday, 21 July 2014

Bank Recon 4.2.910.2909 is available

Bank Recon 4.2.910.2909 can be downloaded from the Twenty57 website. It contains the following features and fixes.

  • Update the SWIFT MT940 parser for slightly different file formats
  • Bug Fix: Ensure the correct GL Account is shown when viewing the Cashbook Transaction Allocation
  • Bug Fix: Search across Accounts and Group By on the Manual Recon Screen
  • Bug Fix: Search across accounts on the Bank Transaction Screen
  • Performance issues when Manually Reconciling across accounts have been addressed

Friday, 27 June 2014

Bank Recon 4.2.902.2893 is available

Bank Recon 4.2.902.2893 is available and can be downloaded from the Twenty57 website. It contains the following features and fixes

  • When a new statement type is imported into an existing account we don't verify the batch number for the first statement, only the balances and statement date
    • This is applicable when you change banks or your bank provides you with a different format
  • Changes to the BAI parser to support a different time format, additional fields in the Group Header row, commas in the text field in an 88 continuation record and files which only contain a Closing Balance, no Opening Balance
  • Bug preventing the Suggest Process from running
  • Bank Details Import Definition Test functionality now works when the query includes a Temp Table
  • Easy Rules Group By working when there is filter on a field not included in the Group By clause
A big thank you to Jai for the development work