Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Aug 13, 2022 5:15 PM UTC
Question

Expense vs CC expense

I have imported some transactions that were done on a credit card, and are in a credit card account as well as classified under a GA account. Some of my transactions are also not done on credit card so I want to use the "type" to differentiate this. 

 

When going in to adjust this, it doesn't let me change a transaction from "Expense" to "Credit card expense". Is there any way to get past this?

4 replies

DivinaMercy_N
Moderator
Aug 13, 2022 8:06 PM UTC

Hi there, @cccam1. I want to ensure you'll be able to change the type of the imported transactions. Let's work together to achieve this. 

 

I appreciate you sharing details about your concern. Before we begin, let me first discuss some info about performing the process.

 

When importing credit card transactions to QuickBooks Online (QBO), below are the few things you need to consider to ensure they will upload correctly. Refer to the following:

 

  • The transactions in the CSV files for credit card accounts may display in reverse. For instance, the deposits may show as negative amounts since paying your credit card to reduce your balance.
  • To ensure that transactions will be imported accurately, you'll have to select the corresponding credit card account (not a bank account) when you upload the file.

 

For more information, please visit this article: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Also, the option to change the transaction type is unavailable in QBO. As a workaround, you'll have to exclude the Expense transactions and recreate them to Credit card expenses. Here's how:

 

  1. In your QBO account, navigate to the Bookkeeping menu and select Transactions.
  2. Then, choose Banking.
  3. From there, go to the For Review tab and select the checkbox of the transactions to exclude.
  4. Next, click Exclude.
  5. Once done, recreate the transaction as a Credit Card expense. 

 

The program also allows you to easily categorize transactions by creating bank rules. These speed up the review process and automatically put the entries into the right accounts.

 

Please let me know how the steps go. I'd love to hear any details about this. If you have additional questions about managing your credit card transactions, please don't hesitate to post a reply below. I'm always around and ready to lend a hand. Have a great day ahead. 

cccam1Author
Aug 27, 2022 5:10 PM UTC

Hi, Thanks for your response.

 

Due to the number of transactions, it's not an option for me to manually recreate every single one.

 

The transactions are all categorized under this credit card account (see image for details) but still nowhere allows me to change it to a credit card expense.