Skip to main content
A
Alnoor55
January 6, 2021
Solved

Credit card downloads

  • January 6, 2021
  • 1 reply
  • 0 views

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?

Best answer by Charies_M

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!

1 reply

C
Charies_MAnswer
January 6, 2021

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!

A
Alnoor55Author
January 6, 2021

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?

R
ReyJohn_D
January 6, 2021

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.

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.

Terms & ConditionsAccessibility statement