How To Import Bank Transactions Using Excel CSV Files In QuickBooks_
                     How To Import Bank 
Transactions Using Excel 
CSV Files In QuickBooks?
www.accountwizy.co
m
Import Bank Transactions Using Excel 
CSV Files In QuickBooks?
QuickBooks allows the users 
to import bank transactions in QuickBooks Online, and 
users are able to manually import bank transactions in 
QuickBooks Online. There any other way to import 
transaction in QuickBooks?’. Well, the answer is ‘Yes’. 
Importing of bank transactions into QuickBooks Online 
by using excel CSV files is a time-saving and effective 
of data to import into Intuit QuickBooks.
How To Formate CSV Files for 
Import?
Formatted your CSV file then you can 
successfully import your bank transactions and 
upload a file that is not properly formatted, you 
will receive an error to be sure. Here are some 
formatting restrictions for CSV files.
Follow The Steps:
1. Characters such as #,%, 
2. Using parentheses () for negative signs.
3. Currency symbol: $ 234.
4. Thousands (2, 111 must be 2111) to separate the commas.
5. Remove all the zeros (0) from the file. 
6. And you can make changes in any of the incorrect transactions that show a 
number in the Description column.
7. Remove all the word amount. It shows up in the name of the Credit or Debit.
8. Using MAC Operating System, you must not save the file as a Windows CSV 
file.
9. Changes and standardize the Date format to a single format.
10.The banks offer the day of the week and include it in the Date section.
11.Select the column and the date is mentioned.
12.After, navigate to the Data and click on the select of Text to columns.
13.You need to follow the Convert Text to Columns Wizard.
The last, you can choose the following options:
➔ Delimited Original data type.
➔ Delimiters: Space.
➔ Column data format: General.
➔ Select Finish all processes.
Thank You!