cancel
Showing results for 
Search instead for 
Did you mean: 
lmargolis
Level 1

automatic entry expense account in downloaded transactions

I download transactions from credit cards. I know how to use the renaming rules for payee. What I don't know how to do is have a particular vendor always automatically post to the an expense account in the last column on the downloaded transaction page. Sometimes it happens, and sometimes not so I don't know how to make it work all the time. 

5 Comments 5
GlinetteC
Moderator

automatic entry expense account in downloaded transactions

Hello there, lmargolis.

 

QuickBooks is dependent on the information transmitted to us by your financial institution.

 

When you download transactions into your Bank Feeds, they are usually categorized as (Auto) Matched and (Need Your Review) Unmatched. You'll have the option to change the category to the correct one.

 

You can use this article for additional reference: Use renaming rules for Bank Feeds.

 

Also, you can check out this link on adding and matching bank transactions in QBDT for Mac: Add and match transactions in QuickBooks Desktop for Mac.

 

Tag me in a comment below if you have any other concerns about managing your account. I'll be sure to help you more.

lmargolis
Level 1

automatic entry expense account in downloaded transactions

Thanks for your quick response.

I understand how matched transactions work and they are working well. What I am asking about is the automatic entry of the Account Name, like an expense account. For instance, if the payee is Safeway Grocery, then automatically the Account Name of Groceries in filled in in the last column for Account Name. I have had it work in the past and it does work on some other credit card accounts. I'm not sure how or why it works.

I just set up a new credit card and downloaded a years worth of transactions. It will save time to have the account names filled in automatically when connected to the payee. How do I set that up for this new credit card. 

AlexV
QuickBooks Team

automatic entry expense account in downloaded transactions

Hello lmargolis!


Allow me to assist you in categorizing the downloaded bank transactions.


QuickBooks Desktop for Mac remembers the last selected account when categorizing the downloaded bank transactions. For example, if the name of the last account used for Safeway Grocery's transactions is Groceries, then it'll automatically appear in the Account column.


This is the reason why it's not yet working on the newly added credit card account. However, the next time you're categorizing the transactions on this account, you can be certain that the last selected accounts will also reflect.


I added this link if you need help in creating or editing a renaming rule for payee names: Manage renaming rules for payee names in QuickBooks Desktop for Mac.


Comment again here if you need more assistance in handling bank transactions. Stay safe!

lmargolis
Level 1

automatic entry expense account in downloaded transactions

Thanks for your reply. Yes usually when the payee says Safeway, the account name Groceries is automatically entered if it has been done once. then the other automatically fill in Groceries. However with this new credit card, that isn't working. I have to enter Groceries each time in the Account name column. Do you know how I can change that or fix it? 

AlexV
QuickBooks Team

automatic entry expense account in downloaded transactions

Hi lmargolis!


Thanks for the update. 


Ideally, it should automatically remember your last selected account. I suggest you reach out to our Support Team so they can take a look at it and see what's causing the change.


I added this link if you need detailed steps in reconciling your accounts: Reconcile an account in QuickBooks Desktop.


Keep on posting here if you have other concerns. Thanks!

Need to get in touch?

Contact us