If you have an Excel or CSV file with transactions from your bank (checking, savings or credit line) account or credit card statement and need to import into QuickBooks 2017, the best would be to convert to a QBO (Web Connect) file.
Use CSV2QBO as your one-stop solution for all your Excel, CSV or TXT files to convert to The QBO format ready to import into QuickBooks 2017.
QBO format provides advantages for a bookkeeper or an accountant in QuickBooks:
Imported QBO files are stored separately under Bank Feeds and QuickBooks provides an interface to review imported transactions, match to vendor records, assign Expense/Income accounts and add to the register.
Unwanted, duplicate or incorrectly converted transactions can be easily ignored under the Bank Feeds as well
When matched to a vendor record, QuickBooks remembers your choice for the next QBO import
CSV2QBO provides a feature to paste table data copied from Excel or other spreadsheet software directly into the application without need to to save the CSV/Excel file.
Related articles for: