Reconcilable Blog

Accounting and Reconciliation

  • Reconciliation problems you don't want to have

    Oct 27, 2015

    Some organizations get into quite a mess by not doing their reconciliations. Take a look at a couple of recent news reports to see what I mean:

    Other concerns raised by the assessment include … errors that were discovered while trying to perform a bank reconciliation.

    Read More…

  • World's best Excel Workbook for Fixed Assets

    Oct 22, 2015

    It’s been 7 or 8 years since I finished constructing my fixed assets workbook. It’s still in regular use and continues to do its job of recording assets, calculating depreciation and providing the reports for my accounts.

    A long stretch of accurate operation without any need for tinkering or correcting, in the field of fixed asset workbooks at least, is cause for satisfaction. I’ve used some less successful designs in the past, as you may have too, so I’m making mine publicly available now in case you want to make use of it.

    Read More…

  • Easy batch matching and reconciliation

    Nov 26, 2012

    Recently, I wrote about matching batches of records using Reconcilable’s Match Finder feature.

    Here’s a 1.7 minute video to show just how this works.

    Read More…

  • Manual selection and inspection of unmatched records

    Nov 5, 2012

    This is the fourth entry in my series on aiming to make the best reconciliation software in the world. Previous ones were on sorting reconciliation items, useful filters when matching and finding transactions that sum to a value.

    Status Bar Sum

    When reconciling in Excel, a feature that many accountants use is the Sum value shown in the Status Bar:

    Sum value shown in Excel's status bar

    Read More…

  • Finding transactions that sum to a value

    Oct 29, 2012

    This is the third entry in my series on making the best reconciliation software in the world. Previous ones were on sorting reconciliation items and useful filters when matching.

    This is surprisingly hard

    Match these transactions by value:

    Subset-sum unmatched

    Read More…

  • Extracting a code from some text

    Oct 17, 2012

    Calculation functions in Reconcilable

    I’ll be the first to admit that Reconcilable’s column calculation function has ’til now been basic. In fact I originally developed it to solve a single problem:- calculate the net of values from separate debit and credit columns so that the net value could easily be used for matching.

    Read More…

  • Reconciliation-specific transaction filtering

    Oct 12, 2012

    The Edit workspace in Reconcilable is used to browse through reconciliation data and to edit matches one-by-one. (The reconciliation data itself can’t be edited of course.) This post is part of the series the best reconciliation software in the world.

    Being determined to make Reconcilable the world’s best software for matching and reconciling, I want to make sure that each element of the user interface works as well as possible. So how could I make something mundane such as transaction filtering really fantastic? To answer that requires thinking about what it’s used for.

    Read More…

  • Sorting your reconciliation items

    Oct 2, 2012

    Reviewing reconciliation data and searching for matching items are where most user’s time is spent when using reconciliation software, so for a great user experience it’s vital that these tasks are efficient. Since making great reconciliation software is my aim, I’ve gone to great lengths to perfect Reconcilable’s Edit workspace.

    Read More…