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

Imported credit card transaction in QB accounts shows adverse debit and credit.

Spend and received in quickbooks account is not correct
1 Comment 1
ChristieAnn
QuickBooks Team

Imported credit card transaction in QB accounts shows adverse debit and credit.

Hi there, reza1.

 

It could be the fields or columns were mapped incorrectly. That's why the credit card transactions in QB accounts are showing in reverse.

 

To successfully import your bank transactions, I suggest reviewing and re-formatting the mapped fields.

 

Here are some formatting restrictions for CSV files:

 

  • Special characters are not allowed:

 

  1. Characters such as #, %, and & anywhere in the file.
  2. Using brackets ( ) for negative amounts: (234) should be -234.
  3. Currency symbols: $234 should be 234.
  4. Commas to separate thousands (2, 111 should be 2111).

 

  • Remove zeros (0) from the file and leave those cells blank.
  • Correct any transactions that display a number in the Description column.
  • Remove the word amount if it appears in the name of the Credit or Debit column (Credit amount and Debit amount are incorrect).
  • MAC users must save the file as a Windows CSV file.
  • Correct and standardize the Date format to a single format (for example, dd/mm/yyyy).
  • Some banks provide the day of the week and include it in the Date column (for example, 20/11/2018 TUE), which is not an acceptable format. To correct this, split the date and the day of the week into two separate columns:

 

  1.  Highlight the column that contains the date.
  2.  Go to Data then select Text to Columns.
  3. Follow the Convert Text to Columns Wizard, choosing the following:
  • Original data type: Delimited
  •     Delimiters: Space
  •     Column data format: General

 

       4. Select Finish.

 

Importing your credit card accounts from CSV files may display transactions in reverse. For example, deposits may appear as negative amounts because paying your credit card reduces your balance.

 

To make sure credit card transactions post correctly to your company file, be sure to select a corresponding credit card account (not a bank account) in QuickBooks Online.


For additional information about importing bank transactions to QuickBooks Online, please check this article: Import bank transactions using Excel CSV files.

 

Please check this article on how to review, add, or match each transaction to avoid duplicates: Download, match, and categorize your bank transactions in QuickBooks Online.


Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us