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
  • 9 views
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.

 

Adrian_A
Adrian_A
Level 8
April 2, 2020

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!

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