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

Categorize Bank feeds

Help! Each month we pay off our Bank of America Mastercard credit card from our Bank of America Checking account. This shows up in our MC credit card register as one lump sum, some QB seems to have cleared and others get left in review. My first of many questions is how to import these credit card transactions broken down into their individual charges, or how do I make this happen? For example if I had a January Mastercard bill for a total of $1,000 but this consisted of payments to multiple different expenses; as you see it on your credit card monthly statement, how do I have it appear in QuickBooks like this. I inherited this format from a previous employee and my previous work had this set up. All the videos and help threads I read on transactions, bank feeds, categorizing, etc. provides examples of 'how to categorize the credit card transaction that paid Apple $X etc." but nothing from what I'm seeing. Help please! We need to get control of our books. 

3 Comments 3
Charies_M
Moderator

Categorize Bank feeds

Welcome to the Community, DocTalkerFamMed.

 

In QuickBooks Online (QBO), you can match one bank transaction to multiple QuickBooks transactions but you can't match one QuickBooks transaction to multiple bank transactions.

 

In your case, you'll want to exclude the online banking transactions on the Banking page. Here's how to exclude transactions:

  1. In the Banking page, put a checkmark on the box of the duplicate transactions.
  2. Click the Batch actions drop-down menu.
  3. Select Exclude Selected.

Check out this guide for additional insight on how to match transactions in QBO: Add and Match Downloaded Banking Transactions.

 

Want more details about this? Check out this guide: Categorize and match online bank transactions in QuickBooks Online.

 

I'm also attaching this link here in case you need help with other banking tasks. Just look for responses that fit your concern.

 

Be sure to drop me a reply if you have additional questions. I'd be more than happy to help. Stay safe and have a good one.

DocTalkerFamMed
Level 1

Categorize Bank feeds

Thank you for your response, I had been through all of those FAQ's and links prior to posting. I am a little confused on why I would exclude. I have attached a screen shot to maybe help explain. If you look at the review for our credit card if I categorize or match these as the credit card payments. How do I then account for the individual charges to vendors for expenses? QuickBooks has determined to categorize and match some and not others and one as a transfer vs credit card payment? The checking account pays down the credit card bill every month, so I would understand that I would need to categorize this as credit card payment? If I try this method it asks for the vendor- which I cannot provide one vendor for the full credit card statement? Is there a way that the credit card monthly charges can be imported into QuickBooks individually? I hope this makes sense because I'm rather confused myself. 

JoesemM
Moderator

Categorize Bank feeds

Thanks for getting back to us, @DocTalkerFamMed. Allow me to chime in and share additional insights so you can categorize your credit card transactions.

 

As mentioned by my colleague above, you can exclude your online banking transactions since it shows as a lump sum in your credit card statement. Then you can manually add those charges individually and match them to your records.

 

To add charges to your bank register, here's how:

 

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Find the account register you want to review and click View register from the Actions column.
  3. From the Add transaction drop-down menu, then select the transaction type you want to add.
  4. Fill in the necessary fields and click Save.

 

For more information about the process, see this article: Add transactions to account registers in QuickBooks Online.

 

Also, when matching your manually created transactions in QuickBooks to your bank feeds, you'll want to make sure that the date, amount, and payee of the transactions are the same. And ensure the bank account showing is correct. I've added this article for future guide: Categorize and match online bank transactions in QuickBooks Online.

 

To properly categorize your transactions to their specific account, I'd suggest consulting with your accountant so you will be guided accurately and ensure your books are accurate.

 

Once done matching your transactions, you can now process reconciling your bank account. This way, we can review your accounts in QuickBooks to make sure they match your real-life bank and credit card statements. For more information, feel free to check out this article:  Learn the reconcile workflow in QuickBooks.

 

Let me know if you need anything else by commenting below, @DocTalkerFamMed. I'll be right here to help ensure you're able to correctly record your credit card transactions in QuickBooks. Take good care!

Need to get in touch?

Contact us