online banking > transaction rules > bug

  • 1
  • Problem
  • Updated 3 years ago
I have a FOOD account which is listed as NCG in the chart of accounts as most expenses I make are inclusive of GST. Here in Australia, some foods are GST exempt and require the code NCF.

I have created a TRANSACTION RULE in ONLINE BANKING so certain food payments are coded as below. Unfortunately, the software IGNORES MY RULE and instead uses the tax code listed in the chart of accounts (as against the codes listed in my transaction rule).

This means that when I apply the rule, I get two line entries, both with the NCG tax code. The TRANSACTION RULE should override any other settings. I'm looking forward to the IT team resolving this oversight in the coding.

Photo of Jay Garland

Jay Garland

  • 2,250 Points 2k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Charles van Rotterdam

Charles van Rotterdam

  • 9,886 Points 5k badge 2x thumb

Not sure but if you only have 1 line item called food then the NCG code on that line item will override.

If you create another line item called say Food2 and put the NCF code against that, and then point the NCF food to that line item perhaps that will work

(Edited)
Photo of Jay Garland

Jay Garland

  • 2,250 Points 2k badge 2x thumb
Yes, I could have two accounts: FOOD - GST and FOOD - GST EXEMPT. I want to track everything under the one account so your option isn't going to work in my case. It's something for the IT people to look into and resolve. I'd classify it as a coding error / bug.
Photo of Charles van Rotterdam

Charles van Rotterdam

  • 9,886 Points 5k badge 2x thumb

That depends on how you set up your chart of accounts. You could have FOOD as the header account and FOOD-GST and FOOD-GST EXEMPT as sub-accounts and when you collapse the P&L report you only see the Header Account FOOD and everything is tracked under the one header account.

I don't see it as a coding issue at all. What you are asking is for 1 line item that can only have 1 Tax Code allocated to it to do 2 things at once when it can only do the one. Don't forget that all accounting packages are not computer programs but just big glorified databases. It's like asking a vehicle with a manual gear shift to be able to change gears without human input.

I see that you are trying to automate the process from the online banking into the accounting package as much as possible. My solution would be to set up the Chart of Accounts as I've suggested to accommodate what you want to bring across from the online banking and then just collapse the P&L report into what you want to see. 

If you like you can call me on 0266834083 and I can run you though it.

(Edited)
Photo of Jay Garland

Jay Garland

  • 2,250 Points 2k badge 2x thumb
If that's the case though and the tax code is pulled across from the chart of accounts, there's no need to have a tax column in TRANSACTION RULES. I can create workarounds - my preference is not to. Since there is a tax column in TRANSACTION RULES, what use does it serve if the software ignores it and looks at the tax code used in the chart of accounts? Personally, I'd classify it as a software bug that needs addressing.
Photo of John G

John G, Information Support Analyst

  • 27,530 Points 20k badge 2x thumb
Hi Jay,

I've tested your parameters and have not been able to replicate your results - the transaction was processed as expected.

Please carry out some maintenance on your file - Resort your lists; Rebuild; Verify and follow up on any errors and try again.

If the problem persists please call Technical Support for further assistance.


regards,
John
Photo of Jay Garland

Jay Garland

  • 2,250 Points 2k badge 2x thumb
Yes. I did another test and it worked.

However, it doesn't appear to work when the tax code is left blank (because you don't want to report that line).

In the example shown below, the second line defaults to NCG (even though the tax code is left blank). It seems the system hasn't allowed for a blank tax code to stay blank.

Photo of John G

John G, Information Support Analyst

  • 27,530 Points 20k badge 2x thumb
Hi Jay,

The tax code selection here on Transaction Rules will override any tax code entered in on the Tax Code field on the Account's setup screen.  If no tax code is selected here then the tax code in the setup will be used.

Create a custom tax code set to 0% to use for situations in Transaction Rules where you'd like no tax on accounts that have a tax code in their setup.  (Make sure you do not include it in tax reports like your BAS)

Hope this gets around this issue for you.


regards,
John
Photo of Jay Garland

Jay Garland

  • 2,250 Points 2k badge 2x thumb
Great idea! Thanks.
Photo of Jay Garland

Jay Garland

  • 2,250 Points 2k badge 2x thumb
I've created a tax code NT (for No Tax). How can I run a report to see which transactions have this code assigned to them?
Photo of John G

John G, Information Support Analyst

  • 27,530 Points 20k badge 2x thumb
Hi Jay, 

In your Tax Code List, right click your NT code and select FastReport.  Adjust the date range as needed.

In other reports that allow a Tax code column to be added, you can then filter for your NT.tax code to show only those transactions.  



regards,
John