Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI 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?
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:
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:
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.
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.
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.
Thanks for keeping us updated, @cccam1. I'd like to provide additional details so you're able to categorize the transactions seamlessly.
The option to batch categorize the imported transactions is currently unavailable in QuickBooks Online. As a result, you'll have to edit the transactions manually one at a time.
I suggest reviewing the Chart of Accounts to ensure the Credit Card Expense account is already set up. If not, you'll have to add the account. Here's how:
Then, categorize the transaction one more time. This time, you should be able to see the Credit Card Expense account from the drop-down list.
Once you're all set, feel free to read this article to keep your accounts in order: Reconcile an account in QuickBooks Online.
You're always welcome to post back if there's anything else you need help with about banking. We can also assist with any queries about QuickBooks in general. Keep safe!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here