This article addresses how to conduct a manual import of transactions from a spreadsheet into your QuickBooks Online bank feeds center. This does NOT address how to import directly from a bank website.

Note: You must first prepare your spreadsheet for the importation of data into QuickBooks Online. Here are some simple tips on how to accomplish this:

  • QuickBooks Online only accepts three columns of bank data for manual import:
    • Date
    • Memo
    • Amount
  • Be sure all withdrawal type of transactions, including credit card charges, are negative amounts on your spreadsheet, while all deposit type of transactions are positive amounts.
    • Do not confuse this setup with QuickBooks Desktop which is different.
  • It helps to label each column on your spreadsheet with a column header for easy identification during the import wizard process within QuickBooks Online.
  • Once you have completed the process of preparing your spreadsheet, the final step in the spreadsheet preparation process is to convert it to a CSV type of file and re-label it to some sort of name which will be easy to find and discern during the import wizard process within QuickBooks Online.

Now, here are the steps to conduct a manual import from your spreadsheet CSV file into the QuickBooks Online bank feeds center:

  1. Click on the gear icon and then, underneath the Tools section, click on “Import Data”.
  2. Click on the Bank Data option.
  3. Now you are going to Select a file to upload and so click on “Browse” (on the right side section of the screen).
  4. Find and select your CSV file.
  5. Click on Next.
  6. Now you will choose which bank (or credit card) account in your QuickBooks Online company file these transactions will be for.
    1. Select the QuickBooks Account drop-down menu and choose your bank or credit card account.
  7. Click on Next.
  8. Now you are at the Map Columns section of the wizard:
    1. As advised above, be sure to checkmark “First row in file is a header row”.
    2. Match each of the three QuickBooks Online Fields with each of the three columns in your CSV file.
      1. Date = Your date column header
      2. Description = Your description column header
      3. Amount = Your amount column header
      4. The last thing to do in this section of the wizard is to choose (tell QuickBooks) if your spreadsheet has the one single column or two separate columns of positive and negative numbers (amounts). Typically, I always just use one column of numbers (amounts) data that will have both of the positive and negative amounts within one column.
  1. Click on Next.
  2. Now you are on the last screen of the spreadsheet import wizard. Here you will have one last chance to review your transactions to be imported before completing the importation process. Be sure to review your transactions here and ensure everything looks like it should.
  3. Once you are satisfied that all of your transactions are ready to be imported, then click on Next.
  4. Once the importation process is complete, go to your Bank Feeds section in QuickBooks Online and begin the process of posting to your chart of accounts.

 

Share This Post: