cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - intuit.me/31Nl3My
Oz Player
Level 2

Same transaction header for all bank account imports

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

Solved
Best answer February 06, 2020

Accepted Solutions
GeorgiaC
QuickBooks Team

Same transaction header for all bank account imports

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

5 REPLIES 5
GeorgiaC
QuickBooks Team

Same transaction header for all bank account imports

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
Level 2

Same transaction header for all bank account imports

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
QuickBooks Team

Same transaction header for all bank account imports

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

Oz Player
Level 2

Same transaction header for all bank account imports

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
QuickBooks Team

Same transaction header for all bank account imports

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

 

Anytime Smiley Happy

Need to get in touch?

Contact us