How to import credit card transactions from Excel CSV file to QuickBooks Online (QBO)

QuickBooks Online allows users to import their credit card transactions via Excel CSV (comma-separated values) files. It will allow importing date, description and amount columns. For the amount, you can use 1-Column field or 2-Column fields. It is recommended to use Debit and Credit with two columns excel file format to import. QBO will not allow mapping additional columns, for example, billable to customer, class, and location.

QBO uses the same “Map CSV columns” fields format for importing both bank account as well as credit card account. It’s a bit confusing for importing credit card liability type account. It could be ended up importing the wrong way. For bank checking account import, you will need to use opposite fields selection of credit card import. Like for example, the expenses were imported as payments and vice versa. See below instructions on how to correct if that happens.

Here is recommended Excel CSV template format:
Debit = Expense
Credit = Payment

 

To import a CSV file (see below for screenshots):

    • From the left dashboard, select Banking.
    • Select File upload at the top right corner.
    • Click Browse and Select the “.CSV file” to upload from your computer.
    • Click Next.
    • From the QuickBooks Account drop-down, select the credit card account to which to import.
    • Click Next.
    • Map your fields according to your CSV file’s format.
    • Under Amount, Select 2 Column radio-button.
    • For Debit Column 3, Select Expense and for Credit Column 4, Select Payment.
    • Click Next.
    • Select the transactions to import.
    • Click Next.
    • You will receive a notification, stating the number of transactions that will be imported.
    • Click Yes.
    • When you get confirmation of the import, click Finish.

     

    You will now be directed to the Downloaded Transactions window under Banking, where the imported transactions will appear under the “For Review” tab. You will now need to review account category and appropriate payee and add the transaction to QuickBooks.

     


     

    How to delete the transaction imported from bank feed if they were imported wrong way?
    Like for example, the expenses were imported as payments.

    You will first need to exclude and then delete all the transactions.

    To exclude a transaction or multiple transactions:

    • Choose Banking on the left dashboard.
    • You’ll see the For Review tab, click the checkboxes to the left of the date for the transactions you want to exclude.
    • Once you’re done, click the Batch Actions drop-down arrow and select Exclude Selected.
    • The transactions move to the Excluded tab.

    To permanently delete unwanted downloaded banking transactions from “Excluded” section of the banking center

    • From the Excluded tab, go to “Batch actions” and choose to pull down arrow and select DELETE. That will permanently delete downloaded transactions.

    Screenshots of CSV file upload:



     


QuickBooks Desktop QBD trial to export or import into QuickBooks Online QBO – US UK CA

This QuickBooks article is helpful for:
1) If you have QuickBooks desktop QBD company file saved on computer hard drive or on external hard drive storage and you need to export that file to QuickBooks Online QBO. This means you have backup company file but no actual QuickBooks desktop program.
2) If you want to cancel QuickBooks Online QBO subscription, and need to export the company file to QuickBooks desktop QBD. This is a way to have a backup company file.

 


Our Quickbooks Data Conversion Services

We can also help export or import into QuickBooks Online QBO.
If you want to move to QuickBooks (QBO and QBD), but not sure how to move your data, please call our consulting service at 858-798-5058 or email us at info@vpcontroller.com .


 
IMPORTANT: These links are only trials, so please don’t try to register these products because it won’t validate and you’ll be locked out.

If you need a QuickBooks Desktop trial to export or import into QuickBooks Online, you can download it here.
If you try to restore a file with a different region’s QuickBooks, it will not work.
Please ensure you are on the latest release of any version downloaded to ensure a smooth migration.

Already a Desktop customer and need to troubleshoot an issue? http://support.quickbooks.intuit.com/Support/ProductUpdates.aspx

QuickBooks Pro/Premier 2017 – 30-day trial

You need these minimum requirements on your system to install this trial.
This installation requires a reboot, so be sure you can close other programs before proceeding.
http://dlm2.download.intuit.com/akdlm/SBD/QuickBooks/2017/US_R1/QuickBooksPremier2017.exe
License number: 5756-3895-5371-772
Product number: 760-899
Trial Validation Code: 653934

Note: If you haven’t installed this product version previously, you may not need the validation code.

QuickBooks Enterprise Solutions 17.0 – 30-day trial

Do not use this for converting your file to QuickBooks Online unless you only have an Enterprise Solutions file.
You need these minimum requirements on your system to install this trial.
This trial link doesn’t require license and product information, and will automatically install without it.
http://http-download.intuit.com/http.intuit/Downloads/2017/Latest/Setup_QuickBooksEnterprise17Trial.exe

QuickBooks for Mac – 30 Day Trial

The QuickBooks for Mac 2016 trial can be found here:
http://intuit.me/1LEuYn0

Canada QuickBooks Trials

Already a Desktop customer and need to troubleshoot an issue? http://support.intuit.ca/quickbooks/en-ca/iq/Update-QuickBooks/Update-QuickBooks-Desktop/HOW15427.html
QuickBooks Pro/Premier 2016 – 30-day trial
These are trial versions and will not validate if you try to register them.

Pro Trial
Premier Trial
Premier Accountant Trial
For trial links for other years, go to http://support.intuit.ca/quickbooks/en-ca/iq/Install–Update-and-Convert/Install-QuickBooks-from-a-download/HOW15493.html

United Kingdom QuickBooks Trials

Already a Desktop customer and need to troubleshoot an issue? https://community.intuit.com/questions/1339022-manually-updating-quickbooks-uk
QuickBooks Pro/Premier 2015 – 30-day trial
These are trial versions and will not validate if you try to register them.

Pro Trial Version
Premier Trial Version

source link






How to limit the number of years of information when converting from QuickBooks Desktop to Online version

You can use the Condense Data Utility in QuickBooks Desktop (In the menu bar, click File, then Utilities and then Condense Data) to condense company file data.

To do this task:

  1. In the menu bar, select File and then Utilities and then Condense Data.
  2. In the first window of the wizard, select Transactions before a specific date and enter the appropriate date.
  3. Put a checkmark in the checkbox labeled: Optional: Create a report showing which transactions cannot be removed.
  4. Click Next and select the radio button Create one summary journal entry (recommended).
  5. Click Next and select the radio button Summarize inventory transactions (recommended).
  6. Click Next and select the transaction groups you wish to be removed.
  7. Click Next and select the unused list entries you wish to be removed.
  8. Click Next and click the Begin Condense button. BIG NOTE This does not start the Condense: it starts the report.
condensed data1
condensed data1
condensed data2
condensed data2

Few other helpful tips before handling this task and also before converting to QBO:

  • Complete backup of your QuickBooks company file
  • Update QuickBooks (Help menu > Update QuickBooks)
  • Verify and Rebuild Data (File menu > Utilities > Verify and Rebuild Data)
    (do it a couple of times if it’s huge or old file)

How to import credit card transactions from Excel CSV (.csv) file into QuickBooks Online?

The short video (below) will show you step-by-step instructions on how to import credit card transactions from Excel CSV file into QBO so that you will not import transactions the wrong way.

Confusion has to do with bank account field and Quickbooks field screen. It is the same field name for bank download as well credit card download. Users are importing a CSV file from credit card company and every transaction ended up being the opposite of what it should be…. expenses listed as credits (spent), credits listed as expenses (received).

Once you have downloaded transactions, there is no way to UNDO or delete downloaded transactions. You will have to move to “EXCLUDED” column and it will stay there forever which is not good.

So, I highly encourage you to watch the entire video. You do not want to miss a step.

import cc csv 1

import cc csv 2

import cc csv 3JPG

import cc csv 4

import cc csv 5

import cc csv 6

import cc csv 7

import cc csv 8.1

import cc csv 8.2

import cc csv 9

QuickBooks Online: How to import bank transactions from Excel .csv file into QuickBooks Online?

Now, you can import bank transactions if your bank provides .csv (comma-separated values) file type. This is new improvement they have just made.

You will take the following steps to import bank CSV file:

From the home page screen > go to blue navigation bar on the left > select Transactions > select Banking under Transactions > click Update > select File upload

 

You can also import bank transactions directly from excel .csv file type into QuickBooks Online. Take these steps.

From the home page screen > go to blue navigation bar on the left > select Transactions > select Banking under Transactions > click Update > select File upload

This could be a huge time-saving task especially when bank do not provide a way to download old bank transactions but available in other formats. If you have bank statements in PDF format, you may be able to just copy and paste to Excel. You can also edit description data and make necessary changes in Excel spreadsheet. Once it done, save file type as Text CSV (*.csv). It takes the following columns to import from Excel:

Column 1 = date

Column 2 = description

Column 3 = spent as negative amount and received as positive amount

OR

Column 1 = date

Column 2 = description

Column 3 = spent as debit

Column 4 = received as credit

If the bank statement provides deposits and withdrawals in two columns, use four column format spreadsheet.

Once the bank file is uploaded into “New Transactions” section of bank feed, you can also add manage rules before transferring transactions to “In QuickBooks” section of bank feed.
 
You can watch this QuickBooks Online Tutorial Video for step-by-step training instructions.

 

1 bank1 csv
 

2 Save as Text  CSV type 

3 file upload 

4 select the file to upload 

5 select bank account

6 bank account quickbooks field 

We had our file imported into QB Online and now notice that nothing shows reconciled. The check mark is missing from all the transactions . How is this fixed?

It is part of the QBDT to QBO import limitations process, they forgot to mention it.

Here is my take on how to solve it in QBO?

If you still have access to QuickBooks desktop file, print bank reconciliations report (preferably for the last three months for record).

Let’s say you have done reconciliation through July 31, 2014 in desktop. Reconciliation report should show outstanding checks (under Checks and Payments) as well as deposits in transit (under Deposits and Other Credits).

In QBO for one-time only, do the bank reconciliation through July 31, 2014 again for the same period.

Enter ending balance as of July 31, 2014. Opening balance probably will not make sense, leave it as it is for now. Focus on ending balance.

Select checkbox > Hide transactions after the statement’s end date (upper corner)

Select “ALL” checkbox under Checks and Payments heading or next to Date column

Select “ALL” checkbox under Deposits and Other Credits or next to Date column

Uncheck Outstanding Checks (one by one) based on printed Bank Reconciliation report generated from desktop

Uncheck Deposits in Transit (one by one) based on printed Bank Reconciliation report generated from desktop

Difference should 0 (zero) now.

Select blue “Finish Now” button

Next reconciliation should be part of QBO process now.

Survival Guide: Import and Export Limitations of QuickBooks Online QBO

It is highly recommended reading these articles (and more help) if you are converting from or to QBO. Note: This is not a seamless process. Expect too many hurdles to overcome!

Import limitations from QuickBooks desktop (QBDT) version to QuickBooks Online (QBO).

What doesn’t come over during an import from QuickBooks Desktop – Import Limitations (US only). Click here.

Export limitations from QuickBooks Online (QBO) to QuickBooks desktop version (QBDT).

Export limitations for QuickBooks Online to QuickBooks Desktop. Click here to see this article.

Export limitations… more





See also.

For Export from QBDT to QBO:
Import into QuickBooks Online from QuickBooks Desktop for Windows (US only). Click here to see this article.

The Accountant’s Guide to Moving Clients QuickBooks Online (QBO). HERE.

For Export from QBO to QBDT:

Visual Guide to Export..here

Exporting from QBO to QuickBooks desktop editions.. here

Convert QuickBooks Online company file to QuickBooks desktop.. here

How long does it take to show up after I have imported my company file from QuickBooks desktop (QBDT) into new Quickbooks Online (QBO)?

There are two ways to import QuickBooks company file from desktop to QuickBooks Online.

Of course, if your company file is very large, it will take longer than a very small company file, so keep that in mind.

If you chose the option in your QuickBooks desktop under the Company menu for Export Company File to QuickBooks Online, great! This is the fastest way to bring your data in to QuickBooks Online. This process generally takes about an hour, though it could be more for larger companies. They will email you once the import is done, but you can start trying to log in after about an hour or so. If they’re not ready, they won’t let you in!

If you downloaded your file to your hard drive and manually imported it to QuickBooks Online, that’s a great solution to bring in your data too. This is a longer process, and can take up to 24 hours. Again, they should email you once the import has been completed, but if it’s been more than 24 hours, try signing in again. They should have the information all ready for you!




Sage One Online Accounting Free Trial Sign Up Program


Hotel_BestRate_300x250

How to import Chart of Accounts in new QuickBooks Online?

Here are the steps needed to import the Chart of Accounts:

  1. From the gear icon go to Import Data and choose Chart of Accounts.
  2. Read the checklist before importing and make sure your file fits the requirements for import (must be a .csv or Excel file format and must have Account Type and Name fields). I recommend downloading this sample Excel spreadsheet and use it as a format:  https://www.quickbase.com/up/bfwy8i23w/g/re7/eg/va/QuickBooks_Online_COA_Sample_File1.xls
  3. Click Choose File to find your file.
  4. Click Open.
  5. Click Continue.
  6. Click the drop-down menus next to the field descriptions to choose which field to import. If you don’t use a field, choose I don’t have this.
  7. When you’re ready, click Continue.
  8. If you’re missing critical fields, we’ll tell you by showing you an icon with an exclamation point and an instruction (such as Choose typeChoose detail type, or both).
  9. When you’re done, click Import [number] Records.

Important information to note:

  • The Type and Detail Type should match the types in QBO.  If not, you’ll get an error message in red and will need to change each line item manually.
  • Right now you can’t add new types or detail types; these are hard-coded into the system.  Please select the best fit for each account.  Here’s a link to a spreadsheet that has all the detail types listed: Detail Types:  https://www.quickbase.com/up/bfwy8i23w/g/rhw/eg/va/CoA%20Types%20%20Detail%20Types.xlsx
  • The import limit is 2 MB or 1000 rows.
  • The colon character isn’t allowed, so parent:sub-account relationships will have to imported as parents first, then adjusted to become subs on the chart of accounts after the import is completed.
  • See the Learn more link inside QuickBooks Online for exact limits on name lengths and other restrictions.
  • The import is ADDITIVE. That means that it will add accounts to the already-existing Chart of Accounts but won’t subtract the standard ones that came with QuickBooks Online.

IMPORTANT NOTE: You can’t undo this import.

This slideshow requires JavaScript.