Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
K
kencor
December 4, 2018
Question

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

  • December 4, 2018
  • 1 reply
  • 1 view
I have imported a CSV file to new QB fileand all transactions have posted with opposite charge/payment fields. That is, all of the charges made on the credit card are showing as payments and all of the payments made to the credit card company show as charges.

1 reply

J
JamesDuanTQuickBooks Team
QuickBooks Team
December 4, 2018

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. 

K
kencorAuthor
December 4, 2018

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.

 

J
JanyRoseB
Level 5
December 4, 2018

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. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement