cancel
Showing results for 
Search instead for 
Did you mean: 
Alnoor55
Level 2

Credit card downloads

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
Best answer January 06, 2021

Best Answers
Charies_M
Moderator

Credit card downloads

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:

 

  1. Go to the Banking menu and choose the For Review tab.
  2. Select the transactions you want to exclude.
  3. Click the Batch Actions drop-down arrow and select Exclude Selected.

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!

View solution in original post

ReyJohn_D
Moderator

Credit card downloads

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:

 

  1. Go to the Banking menu, and then choose the Categorize tab.
  2. Tick the checkbox for the transactions you want to batch undo. You can also manually click the Undo link under the Action column as another option.
  3. Click Undo, and then Continue to confirm.
    d938.PNG

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.

View solution in original post

5 Comments 5
Charies_M
Moderator

Credit card downloads

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:

 

  1. Go to the Banking menu and choose the For Review tab.
  2. Select the transactions you want to exclude.
  3. Click the Batch Actions drop-down arrow and select Exclude Selected.

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!

Alnoor55
Level 2

Credit card downloads

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?

ReyJohn_D
Moderator

Credit card downloads

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:

 

  1. Go to the Banking menu, and then choose the Categorize tab.
  2. Tick the checkbox for the transactions you want to batch undo. You can also manually click the Undo link under the Action column as another option.
  3. Click Undo, and then Continue to confirm.
    d938.PNG

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.

Alnoor55
Level 2

Credit card downloads

Thank you!

ReyJohn_D
Moderator

Credit card downloads

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!

Need to get in touch?

Contact us