extoffroad
New Member
2 weeks ago

Trouble Importing Credit Card Transactions into QuickBooks Desktop — QBO File Not Mapping Vendors

Hi there,

I’m having issues importing a large batch of credit card transactions into QuickBooks Desktop.

What I’ve tried:

  • I created a CSV/Excel file with Transaction Date, Vendor, Category, and Amount — all vendors match names already in QuickBooks.

  • QuickBooks Desktop doesn’t allow importing this format directly into credit card accounts.

  • Support had me download a QBO file from my bank, and while it imported, only 20 out of 1,900+ transactions matched to existing vendors.

  • The rest didn’t auto-match, and I can’t assign vendors manually unless QuickBooks recognizes them.

  • From what I can tell, you can’t edit the QBO file to pre-define vendors/categories either.

What I need help with:

  • Is there a way to import all transactions and assign vendors/categories in bulk?

  • Can QBO files be customized or built manually to improve vendor mapping?

  • Are there tools you recommend that can simplify this process without editing 1,900+ lines manually?

Thanks in advance for any help or suggestions.

Reply Join the conversation
Aldren18
QuickBooks Team
QuickBooks Team
2 weeks ago

Payments

I appreciate you sharing all these details, Extoff. Let me break this down and offer tailored solutions to address each of your concerns.

 

You’re correct that QuickBooks Online (QBO) files cannot be directly edited to predefine vendors or categories, as they are an exclusive format designed for seamless use within QuickBooks.

 

While I can’t endorse a specific third-party solution, you can explore our QuickBooks Desktop Marketplace to find tools that enable you to import your credit card transactions efficiently. Navigate to the CATEGORIES section to easily find the app that best suits your needs.

 

Here’s a screenshot for guidance:

 

image (126).png

 

After importing your transactions into Bank Feeds, you can utilize the Bank Rules and Batch Actions feature in the program to assign vendors and categories efficiently.

 

To address your query about why the rest of your imported transactions didn't auto-match, QuickBooks Desktop (QBDT) requires specific conditions to auto-match transactions. Auto-matching occurs when QuickBooks can identify a match for check numbers, amount, date, and who paid you.

 

To learn more about how the match feature works in QBDT, please refer to this article: Add and match Bank Feed transactions in QuickBooks Desktop.

 

Please feel free to revisit this thread with any updates or further questions.

Reply Join the conversation
SIAB
Level 7
2 weeks ago

Payments

@extoffroad 

You can use TP Importer as a workaround. It's a $199 one time license.

https://get.transactionpro.com/qbd

 

If your company is located in the US, you can get the license for free from a partner. You can contact @Fiat Lux - ASIA for details.

 

Reply Join the conversation