I downloaded credit card transactions and imported a csv file. The amounts were in one column - expenses as debits and payments as credits. After importing into QBO I realized that the transactions signs had flipped: expenses as credits and payments as debits. As I had set up rules, many of the transactions have been categorized so now I have expenses in the GL showing credit amounts and the credit card account showing a debit balance. There are also several hundred transactions awaiting review. How can I fix this?
Solved! Go to Solution.
It's my pleasure to help you today, Alnoor55.
To correct the downloaded transactions signs that had flipped, you can batch delete your imported transactions listed under the For Review tab.
Here's how to exclude:
This will move the transactions to the Excluded tab from the For Review tab.
You may find this article handy to learn more about the process of excluding downloaded transactions in QBO.
Once done, you can re-import your transactions anytime you desire. You can read through this article for step-by-step instructions: Manually upload transactions into QuickBooks Online.
Check out this article about categorizing and matching downloaded transactions from your bank: Categorize and match online bank transactions in QuickBooks Online.
In addition to that, you visit these links about reconciliation in QBO:
The Community is always open if you have other questions. I'll be around to help. Wishing you a great day ahead!
Let me jump in to help you with your banking concern, @Alnoor55.
Yes, you'll need to flip the signs (debits and credits) of your transactions before importing the new CSV file. You'll have to tag expenses as debits and payments as credits.
For more insights, please review this article: Format CSV file to get bank transactions into QuickBooks.
Also, you can undo those entries posted to the general ledger. I've got the steps needed to get this done right away.
Here's how to do it:
When you're ready, you can begin importing the file again.
After that, you can categorize and match your entries to put them in the correct accounts and prevent duplicates.
To ensure they match your credit card and bank statements, you can perform your usual reconciliation.
I'm just a post away if you have more banking questions. I'd be glad to lend a helping hand.
It's my pleasure to help you today, Alnoor55.
To correct the downloaded transactions signs that had flipped, you can batch delete your imported transactions listed under the For Review tab.
Here's how to exclude:
This will move the transactions to the Excluded tab from the For Review tab.
You may find this article handy to learn more about the process of excluding downloaded transactions in QBO.
Once done, you can re-import your transactions anytime you desire. You can read through this article for step-by-step instructions: Manually upload transactions into QuickBooks Online.
Check out this article about categorizing and matching downloaded transactions from your bank: Categorize and match online bank transactions in QuickBooks Online.
In addition to that, you visit these links about reconciliation in QBO:
The Community is always open if you have other questions. I'll be around to help. Wishing you a great day ahead!
Thank you Charies. I will delete the pending transactions and re-import them.
Should I flip the signs on the (new) csv file before I import the transactions?
How can I fix the transactions that have already been posted to the general ledger?
Let me jump in to help you with your banking concern, @Alnoor55.
Yes, you'll need to flip the signs (debits and credits) of your transactions before importing the new CSV file. You'll have to tag expenses as debits and payments as credits.
For more insights, please review this article: Format CSV file to get bank transactions into QuickBooks.
Also, you can undo those entries posted to the general ledger. I've got the steps needed to get this done right away.
Here's how to do it:
When you're ready, you can begin importing the file again.
After that, you can categorize and match your entries to put them in the correct accounts and prevent duplicates.
To ensure they match your credit card and bank statements, you can perform your usual reconciliation.
I'm just a post away if you have more banking questions. I'd be glad to lend a helping hand.
Thank you!
You're most welcome, @Alnoor55.
Feel free to get back here in the Community if you need more QuickBooks tips and insights. I'm always around to help you.
Take care and have a great day!
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
These cookies are strictly necessary to provide you with the services and features available through our site. Because these cookies are strictly necessary to deliver the site, you cannot refuse them without impacting how the site functions.
These cookies are used to make advertising messages more relevant to you and your interests. They also perform functions like preventing the same ad from continuously reappearing, ensuring that ads are properly displayed, and in some cases selecting advertisements that are based on your interests.