Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
kvwarren65
Level 1

Credit Card Import ... QBD

Topic:  Changing the account that credit card imports “dumps” to.

Transactions that were previously imported, QBD knows where to categorize them but isn’t giving me the option to edit the account before it imports to.  It’s putting them in the wrong category.  How do I change that import to a new account?

2 Comments 2
4Gal
Level 11

Credit Card Import ... QBD

You can prepare your CC Statement data with the following template

Credit Card AccountTransaction DatePayeeRefNumberAccountAmountMemoClassBillableBillable Entity
QuickBooks Credit Card01/10/2020Hampton Inn1234Travel:Lodging150  YJohn Doe
QuickBooks Credit Card12/10/2020Staples123465Office Supplies-15Return N 

 

then use an importer tool to proceed. It's a one time license

https://get.transactionpro.com/qbd

 

AnneMariee
QuickBooks Team

Credit Card Import ... QBD

In addition to what @4Gal has mentioned, you can also manually change the categories where your imported transactions fall under, @kvwarren65.

 

When manually importing transactions in QuickBooks Desktop, there is no option to edit the account where it imports. This is because QuickBooks automatically detects which accounts to post the transactions based on the information from your imported file. So, if you notice that your transaction isn't under the correct account, you can just manually edit it. This way, you can guarantee that your records stay accurate.

 

Here's how to change a transaction's category in the Advanced bank feed mode:

  1. Go to the Banking menu.
  2. Select Bank Feeds and select Bank Feeds Center and review the transactions in each category.
  3. Click the dropdown of the transaction you want to edit. Then, View details.
  4. Select the right category for your transaction.

 

Moving forward, you can create bank rules to make categorizing transactions easier. If you're using the Express bank feed mode, you can create rules only for renaming and categorizing transactions. But if you're using the Advanced bank feed mode, you can automatically assign a class and a payee. 

 

For additional info on reviewing your transactions, check this out: Add and match Bank Feed transactions in QuickBooks Desktop.

 

For future reference, here's an article about reconciliation in QB: Learn the reconcile workflow in QuickBooks.

 

Please don't hesitate to return to this thread if you have further questions about categorizing your transactions. I'm just one post away to help you out.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us