cancel
Showing results for 
Search instead for 
Did you mean: 
marts
Level 1

Why are my credit card transactions imported from .csv in the opposite direction?

I had my chart of accounts and everything set up with Live Bookkeeping for 2019. Then everything was fine but when I try to now upload my credit card transactions from 2020 then somewhy all the transactions are displayed oppositely. I upload the transactions to my credit card account but all my credit card expneses are displayed as CC-Credit and all credit card refunds are displayed as Expenses. Yes, I understand that the credit card transactions work "in an opposite way" to checking account but that is not the issue at the moment. I still have the last year's .csv file for credit card payments and the +/- values were the same then as well..

8 Comments 8
RenjolynC
QuickBooks Team

Why are my credit card transactions imported from .csv in the opposite direction?

I hope you're doing fine today, marts.

 
When importing bank transactions in QuickBooks Online, let's make sure the data is in the correct format. Here's how to check the format of bank transactions in a CSV file:

  • 3 column format: This format has a Date, Description, and Amount column.
  • 4 column format: This format has a Date, Description, Credit, and Debit column.

You can check this article for reference: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Since your transactions are displayed incorrectly, you'll want to exclude them by following these steps:

 

  1. From the Banking page, go to the For Review tab.
  2. Select the transactions you want to remove by putting a check mark on the box before the date.
  3. Click the Exclude button.

Please see this sample screenshot:

 

 

Once done, upload the transactions again. 

 

Here's how:

 

  1. In QuickBooks Online, go to the Banking menu or Transactions menu. Then select the Banking tab.
  2. Select the blue tile for the account you want to upload the transactions into. Then, click the Link account drop-down and choose Upload from file.
  3. Select Browse and then select the file you downloaded from your bank. Hit Next.
  4. In the QuickBooks account drop-down, choose the account you want to upload the transactions into. Then click Next.
  5. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Next.
  6. When you're ready, press Let's go.

I'm also adding these articles to guide you with the process: 

 

If you need to accomplish other tasks in QuickBooks, please let me know in the comments below. I'll be around to help you out again. Take care!

marts
Level 1

Why are my credit card transactions imported from .csv in the opposite direction?

Thank you for the response.

Unfortunately this is what I have done multiple times but does not solve the problem. When I upload them then the transactions are all there but the value sign is wrong - credit card expenses are listed as CC-Credit and credit card refunds as well as reimbursement from the checking account are listed as expenses. What I did to resolve the issue is that I manually changed the value signs in the .csv and now they are categorized correctly.

 

However, I have an additional question. How should I "link" the monthly transactions between checking account and credit card (for using the credit card)? I suppose they should not be labelled as Expenses. What Live Bookkeeping did last year is that they are journal entries. Therefore would I have to manually make a journal entry every month?

JenoP
Moderator

Why are my credit card transactions imported from .csv in the opposite direction?

Joining the thread to offer help with your banking transactions, marts. 

 

Are you referring to the credit card bill payments that were taken out of checking account? If so, you can make a transfer of the record the payment to link them  together. 

 

Here's how:

 

  1. Go back to the Banking tab.
  2. Look for the checking account and click on it.
  3. Select the credit card payment, then select the Record as transfer radio button.
  4. Go to the Transfer account ▼ drop-down menu and select credit card account.
  5. Click Confirm.

Once you're done with the transfer of the transaction, you need to match it with the new account. Here's how:

 

  1. Go to the Recognized tab and locate the transaction.
  2. Under the Action column, select Match.

Although, you can still create a Journal Entry every month similar to what was created by QuickBooks Live Bookkeeping. Here's an article as a guide: Create A Journal Entry In QuickBooks Online.

 

Let me also share this article just in case you need more reference and guidance with your year-end tasks: QuickBooks Online Year-end Guide And Checklist.

 

Please don't hesitate to add another reply below if you still need more help with banking. We're always here to offer our assistance. 

kwinters07
Level 1

Why are my credit card transactions imported from .csv in the opposite direction?

I don't see where this was ever answered.   This was not about the payment, this was about the credit card charges.   Every time I imported from a csv file, they came in as credit card credits, instead of credit card charges.  I changed the "sign" of the amounts in the csv file but it still imported them as a credit card credit.  I feel like I am making some silly error but I can't figure out what it is.    I know how to exclude transactions on the feed - that's not the question either.     

JoesemM
Moderator

Why are my credit card transactions imported from .csv in the opposite direction?

I'm here to share details about importing CSV files in QuickBooks, @kwinters07.

 

When you import a CSV file to QuickBooks, it follows the details of the file. Thus, showing the credit card credit instead of credit card charges.

 

That said, I'd recommend asking for a valid CSV file from your bank or downloading a new one through their website. After that, try importing the file again.

 

 Also, I'd suggest opening your CSV or TXT file in Excel to determine exactly what information your bank exported and how it is formatted. For more information on how to check the format, please refer to the following article: Import Bank Transactions Using Excel CSV Files.

 

If you get the same result, I suggest contacting our QBO Support Team. They'll be able to pull up your account and review the CSV file. They can also provide further troubleshooting steps to get this fixed.

 

I've also attached an article you can use to manage downloaded transactions in QuickBooks: Match and Categorize Bank Transactions.

 

If you have other questions about importing bank transactions please let me know by clicking the Reply button below. I'm always here to help you out. Stay safe, @kwinters07.

Fiat Lux - ASIA
Level 15

Why are my credit card transactions imported from .csv in the opposite direction?

@kwinters07 

Utilize the trial version of csv2qbo converter to isolate the issue.

https://www.moneythumb.com/?ref=110

 

lfernandez2004
Level 1

Why are my credit card transactions imported from .csv in the opposite direction?

Hello, I had the same issue and QuickBooks never provided a solution. Don’t buy a program to change your file. I did this and it worked.

 

1. download your Transacrions

2. Save them as CVS

3. Open CVS and move or add columns to make the file to have only 4 columns. Like this 

    Date  Descripción Receipt  Charge

4. You can rename the columns if you want

 

5. Move the credit cards credits to the column “receipt” 

6. Leave charges in column 4 

select Columns with amounts and click on format, make sure it has style currency and accounting style. 

7. Currency will put a dolar sign before each transaction 

8. Accounting Style will put you credits in parentheses “to make it Money Inn” 

 

Save it and upload to QuickBooks. 

You will notice that charges have a “-“ sign as a negative amount and credits do not have that. 

 

Good Luck 

    

adyson
Level 1

Why are my credit card transactions imported from .csv in the opposite direction?

I just had the same problem.  To fix the issue you have to manipulate your .csv data.  All charges need to be negative numbers and credits have to be positive numbers.  Your credit card company probably provides the data in the opposite format like mine does.  I created a new column using a formula wherein I multiplied all the original amounts by NEGATIVE ONE ex: (50 x -1)  and copy/pasted the formula all the way down the length of the column.  I then replaced the original amounts column with the new negative numbers by choosing paste values.  After I did this I then tried my QB import again and all the negative numbers are now in the "spent" column of my credit card register and all credits are in the "received" column so this has worked for me!

Need to get in touch?

Contact us