

If your financial institution does not support CSV files but offers Quicken, QuickBooks Online, or Microsoft Money, you can upload your data and then upload bank transactions over 90 days using Web Connect Huh. QuickBooks Online will automatically fill in the details if banking rules are properly established or it recognizes the details of your transaction as QuickBooks Online.ĬSV files are formatted differently by each bank and due to this, it may not be possible for all financial institutions to import a CSV file. Once you are done with importing, you will be able to make any additional details, such as transactions, on the Forward tab of the banking page. The 4-column template has a Date column, a Description column, and both a Credit and a Debit column. The 3-column template has columns for the Date, a Description of the transaction, and the amount of the transaction.

Here we are importing the bank transactions using the CSV files, so it is necessary to know the CSV template format. It is important to ready the CSV file, before importing bank transactions using Excel CSV files into QuickBooks Online. Import CSV file into QBO Make Your CSV File Ready
