Transaction Rules have stopped working

Libbi
Libbi Member Posts: 1
edited March 2017 in Reckon One

Hi, new to Reckon One. I set up transaction rules for a Westpac account, and they were working fine (automatically applied) for the first few months feed, but have stopped working on the new feed coming through. Any ideas? Many thanks

Comments

  • John Lacey
    John Lacey Member Posts: 2
    edited January 2017
    Libbi,
    Check these settings (this is what Reckon sent to me). Hope this helps you out..


    What reporting basis (cash or accrual) is specified for you book?

    To check this, select the Administration menu (the cog icon in the top right) > Settings > General > Report settings.


    In the scenario where you have an open (unpaid) bill.
    * Accrual basis reporting will report the open bill as 'money out'. 
    * Cash basis reporting won't report the open bill as 'money out'. Cash basis reporting will only show the bill as 'money out' once it's paid.

    In the scenario where you have an open (unpaid) invoice.
    * Accrual basis reporting will report the open invoice as 'money in'. 
    * Cash basis reporting won't report the open invoice as 'money in'. Cash basis report will only show the invoice as 'money in' once it's paid.

    This also assumes the that...
    * You are using expense accounts or items linked to expense accounts on your bills.
    * You are using income accounts or items linked to income accounts on your invoices.

    Why?

    The net position dashboard widget uses the profit & loss report. The profit & loss report looks at income & expense accounts (excludes asset, liability & equity accounts). 
    The top income dashboard widget looks at income accounts. 
    The top expenses dashboard widget looks at expense accounts. 

    The dashboard widgets can be configured to report certain periods. So make sure you have configured the widget periods as per your requirements. You can configure the widgets by clicking the spanner icon in the top right of the widget.


    One more thing on the cash vs accrual reporting. There is a separate setting to configure the reporting basis for tax reports. To access this setting select the Administration menu (the cog icon in the top right) > Settings > Tax settings > General.
  • Qwerty
    Qwerty Member Posts: 261
    edited March 2017
    22 Dec 2016

    Hi Libbi,

    My suggestion would be to review the rules that aren't working & ensure they are configured so that a match can be detected.

    If your rules are setup to itentify a match based on description data then ensure that you are only including the necessary word(s) required.

    I use an example to explain. Let say I regularly make purchases from Woolworths & I want to setup a money out rule that creates a payment for my Woolworths purchases.

    In the screen shot below I have a Woolworths money out transaction for $28.80 dated on the 14/11/2016 in my feed.

    image

    Because I make varied purchases at Woolworths I don't want my rule to identify these transactions by amount or date as these would vary. I want to configure my rule to use the description data to identify a match.

    The description data for this transaction is
    V1396 11/11 WOOLWORTHS 1251 BE BERALA 05193179001

    This description includes the store location (Berala). I shop multiple Woolworths locations so I don't want to use all of this description data. I only want to use the minimum words in my rule to identify a match for Woolworths transactions.

    I am going to configure my rule to search based on description data using the word Woolworths

    image

    image


    Another thing to keep in mind is that rules setup to search based on description data search for whole worlds & not text within words.

    Example
    image

    This transaction uses the description
    NABATM CSH 15th08:01GREENWOOD PLAZA

    Notice there is no spacing between the text NABATM
    Notice there is no spacing between the text 15th08:01GREENWOOD

    If I had a transaction rule setup to locate the following words
    NAB
    ATM
    Greenwood

    Then no match would be found because these three words can't be located as they are not whole words (separated by spaces) in the feed data.


    Hopefully this information assists you with your issue. If it doesn't then i'd suggest that you include some more information & example screen shot of a transaction in your feed that you believe should be picked up by a rule & an example screen shot of the rule configuration.