How do I fix Charge/Payment notation on cc transactions?

Hello Ken,

When importing a CSV file to Quickbooks, the program follows the details of the file. Thus, showing the charges and payments in the Banking page.

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

If you encountered the same issue, you can contact our QuickBooks Customer Care 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'd also appreciate any additional details (such as bank name, error messages or codes, and etc.) so I can give you a hand. 

Thanks, James

It's an AMEX credit card CSV file that I downloaded from AMEX. After receiving an error for the date format, I modified the CSV so that the date is in mm/dd/yyyy. The AMEX CSV file has three fields:

Date

Payee

Amount

Importing into QB, I match up the fields as follows:

QB date = AMEX date

QB description = AMEX payee

QB amount = AMEX amount

The AMEX CSV file has both positive (charges) and negative (payments), so I select the option "1 column: both positive and negative numbers".

There is no error during the upload. All of the transactions load. However, the positive amounts (which were charges on the AMEX -- so corporate expenses and payments to a vendor) are uploaded to the QB "Received" column. Negative amounts (which are company payments made to AMEX to pay the charged amounts) are uploaded to the QB "Spent" column.

This is the exact opposite of what I was expecting. I was expecting charges made on the AMEX card to be imported as "Spent" on the AMEX register, and payments made to AMEX to be recorded as "Received" on the AMEX register.

I cannot change the amounts so that they are in the correct QB column.

Hi there, kencor.

Thanks for getting back to us. I'm here to help and provide some additional information about importing bank transaction in QuickBooks Online (QBO). 

QuickBooks Online can import CSV files that use either a 3-column or 4-column format. In this case, you'll need to use the 4-column template which has a Date, a Description, and both a Credit and a Debit column. This way, you can categorize the transactions in the right columns. 

But before doing so, you'll need to exclude those imported transactions that were categorized in the incorrect column on the banking page. Here's how: 

1. On the left navigation tab, select Banking.
2. In the For Review tab, put a check mark on the transactions you want to exclude.
3. Select Batch actions drop-down arrow.
4. Click Exclude selected. 

Once done, you can now start importing bank transactions using CSV files with the 4-columns template. You may also check this article for your additional reference: How to import bank transactions using Excel CSV files.

If the issue still persists, I encourage you to contact our QuickBooks Online Support Team. They have additional tools to pull up your account and do a remote session so they can investigate this further. 

You can contact our support through this link: Get help with QuickBooks Online.

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. 

OK, thanks. Not an ideal solution because I will have to edit the CSV file manually to separate out the positive and negative numbers, but I can try this method.

you can make a new column and multiple all the amounts by -1 

E.g. if col C has the amounts, then in D1 formula is =C1*-1 which takes the amount from C1 and flips it. Then copy that all the way down column D and all of col C is flipped. Then copy all of col D and paste values into Col E. Then delete cols C and D and zappa do. Way easier than splitting out the negs and positives

Awesome fix. I just had the same problem and your fix worked like a charm, Steve. Thxs.

Perfect fix!

I'm having the same problem but I'm not importing a csv file, i'm doing direct download from the bank, but often (not always) it imports the amounts in the wrong columns and it won't let me edit. Has anyone else had this issue? 

TIA

I checked our records and I can't see any similar cases at the moment, o2enquiries.

The data shown in your Banking page is exactly the same from what was sent to us by your bank. I'd suggest reaching out to them and check why some of the amounts are placed in the wrong column. 

In the meantime, you can exclude the transactions in the For Review tab. Then, manually record them in QBO so everything is tracked. Here's how to exclude transactions:

1. Select the boxes of all transactions that you need to exclude in the For Review tab.
2. Click the drop-down list for Batch actions.
3. Click Exclude Selected.

Don't hesitate to visit us again and post questions anytime you need help. 

I'm having the same issues here except mine is not cc but bank feed. So I have debits and credits which I imported a csv file of the bank feed manually. Column 1 date, column 3 description column 4 amount and selected Both positive and negative amount. Now when it was uploaded everything went into received column if the debit amount. So now my rent expense is been classified as bank deposit and showing a negative amount in the P&L as if I deposited money for rent instead taking money out. I cant seem to delete this or even fix the problem. In the future should i make all the debit a negative amount? or should I pick to columns and manually input the Received and spent? But for now how do i fix the problem at hand.

You have me to help you fix this issue, vasante01.

When we manually import transactions into QuickBooks, we have two options on how to do it. We can either use 3 columns or 4 columns.

In your case, since you have credit and debit, we'll have to use the 4 columns option. Then, make sure to map the transactions to the correct field.

We can fix this issue by deleting the downloaded transactions and then import them again. Let me guide you with these steps:

1. From the Banking tab, select Banking.
2. Go to the For Review tab.
3. Select the transactions.
4. In the Batch actions drop-down, select Exclude selected.
5. Go to the Excluded tab.
6. Tick the transactions and then select Delete in the Batch actions drop-down.

Afterward, we'll have to import them again.

1. Click File Upload in the Banking page.
2. Select Browse and then locate the file.
3. Select Open, and then Next.
4. Choose which account you want to upload the transactions.
5. Click Next.
6. Under CSV file has amount in: link, select Column 2.
7. Filter the Date and Description.
8. In the Money Spent field, select your rent expense.
9. Select a debit in the Money Received drop-down.
10. Click Next.
11. Review the transactions, and then Next.
12. Select Yes.

Then, you're good to categorize and reconcile them.

I'm just a post away if there's anything that I can help. Stay safe!

Thank you, I got it figured out. I had also previously before you posted used a 3 column rule except I put negative(-) infront of the debits and that seemed to have worked also.  

I now have another problem. When i log in to quickbooks online and click on banking i get 3 options Banking, Rules, Receipts. I'm able to click on Rules, Receipts however I click on banking and nothing happens. It doesnt take me to the banking feed. I don't know if its a bug or whats happening but cant access my banking feed tab. Is there something I clicked for this to have happened?

Thank you for getting back here, @vasante01.

There can be some browsing issues why you're unable to click the banking option.

Let me guide you to do some troubleshooting steps.

• You can use a private browser or incognito.
• If you still got the same problem, you can follow the steps to Clear cache and cookies.
• And if the problem persists, you can use another browser to open your QuickBooks.

You can check out our QuickBooks help website to learn some articles that can help you for future reference: QuickBooks Support .

If you have additional queries, don't hesitate to go back to this thread. Keep safe and healthy.

Can you please you change the behavior of the import to what users expect, rather than making us perform Excel gymnastics? This seems to be a common problem among those trying to import CC transactions.

In excel (csv) you can copy paste values and switch the signs very easy.

Copy the entire row then right click paste special

On paste special menu (windows office) you click values on the top and subtract on the bottom. 

Now the entire column will have the opposite signs.