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:
Characters such as #, %, and & anywhere in the file.
Using brackets ( ) for negative amounts: (234) should be -234.
Currency symbols: $234 should be 234.
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:
Highlight the column that contains the date.
Go to Data then select Text to Columns.
Follow the Convert Text to Columns Wizard, choosing the following:
Original data type: Delimited
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.