Skip to main content
Oz Player
Oz Player
February 6, 2020
Solved

Same transaction header for all bank account imports

  • February 6, 2020
  • 1 reply
  • 0 views

Hi,

 

Problem: When my bank account is linked to my transactions, all transactions are imported using the same header for meaning all my rules don't work. When expanding the transaction there is more detailed information contained with in the bank description that the rule could reference to work, but it only seems to reference the transaction header.

 

Question: Is there a way to change what text qb references to create a transaction header? Or is there a way to make the rule reference the bank description contained with in the transaction?

 

Thanks in advance

Best answer by GeorgiaC

Hello Oz Player,

 

Thanks for getting back to me and adding that detail. 

 

There is no way to change which data is downloaded from the bank itself, this will always contain the transaction heading and description and is not editable on the banks side. 

 

Due to the way the bank rule mechanism works by reading the downloaded script, the only workaround I could advise in the situation given above is to edit the rule to remove TFL from the description and leave (transport for London) so as to not have the Netflix rule apply to this in error. 

 

Thanks

1 reply

G
GeorgiaC
February 6, 2020

Hello Oz Player,

 

Thanks for your post and welcome to the QuickBooks Online Community. 

 

On the bank rule do you have the 'When a transaction meets all of these conditions' drop-down set to 'Description' rather than 'Bank text'?

 

This should then read the bank description rather than transaction heading when applying the rule.

 

Thanks

Oz Player
Oz PlayerAuthor
February 6, 2020

Hi GeorgiaC, thanks for the reply.

 

This hasn't occurred because of "importing" the data. It has occurred when my bank account is 'Connected' to qb and has occurred when the data is automatically pulled into transactions. I have clicked through the web interface and haven't found any options to change the bank rule.

 

I have tried to change some of the transaction rules, unchecking the 'exact' option has helped in some cases but not in others.

 

Here is a real example: All Transactions get added automatically as "Contactless Payments, LLC". In the description TFL (transport for london) transactions are business - travel expense, however all NETFLIX are personal. But, because the letters TFL appear in neTFLix either way the option is selected I have to change one to a different category. Hope this makes sense.

G
GeorgiaCAnswer
February 6, 2020

Hello Oz Player,

 

Thanks for getting back to me and adding that detail. 

 

There is no way to change which data is downloaded from the bank itself, this will always contain the transaction heading and description and is not editable on the banks side. 

 

Due to the way the bank rule mechanism works by reading the downloaded script, the only workaround I could advise in the situation given above is to edit the rule to remove TFL from the description and leave (transport for London) so as to not have the Netflix rule apply to this in error. 

 

Thanks

    Terms & ConditionsAccessibility statement