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 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..
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:
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:
Please see this sample screenshot:
Once done, upload the transactions again.
Here's how:
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!
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?
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:
Once you're done with the transfer of the transaction, you need to match it with the new account. Here's how:
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.
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.
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.
Utilize the trial version of csv2qbo converter to isolate the issue.
https://www.moneythumb.com/?ref=110
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
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!
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.