Same transaction header for all bank account imports

Oz Player · ‎February 06, 2020

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

GeorgiaC · ‎February 06, 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

View solution in original post

GeorgiaC · ‎February 06, 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 · ‎February 06, 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.

GeorgiaC · ‎February 06, 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

Oz Player · ‎February 06, 2020

This is frustrating as it is something my bank has changed as of November 2019, before then it worked fine. I guess another work around would be to un connect my bank account and import the transaction every month from my statement.

Thanks again for your help.

GeorgiaC · ‎February 06, 2020

That is frustrating, but that's also a great workaround and would allow you to edit the description or transaction line before importing.

Anytime :)

Topics

Training

Community

Resources

Same transaction header for all bank account imports