1.6a Importing Products and Services | Scribe

    1.6a Importing Products and Services

    • 16 steps
    information ordinal icon
    Start in the Sample company.
    1
    To complete this exercise, you must be in the Sample company. From your QBOA account, click on the Gear icon on the top right corner of the screen, then select Sample company.
    alert ordinal icon
    Note that you will be logged out of your current account. If you are sure, click "Continue" to confirm.
    information ordinal icon
    Now let's get started with the exercise.
    2
    Click the "Gear icon".
    3
    Click "Import data".
    4
    In the Select record type, click the "down arrow".
    5
    Click "Products and Services".
    6
    Click "Import".
    information ordinal icon
    For the purposes of this exercise, you will use the Sample File to replicate Craig's spreadsheet.
    7
    Click "Download a sample file".
    information ordinal icon
    Once the file has been downloaded, you will need to locate it on your computer.
    8
    Click "Browse" to locate the file on your computer and select it for uploading.
    information ordinal icon
    Once the file has been selected you can continue.
    9
    Click "Next".
    information ordinal icon
    The next step is to match the fields (column headings) in the spreadsheet to the fields in QuickBooks Online. If this were a real life scenario, you might have to make adjustments. For the purposes of this exercise, leave everything as is.
    10
    Click "Next".
    information ordinal icon
    Now that you have confirmed the fields that you are importing and matched them to QBO, the next step is to confirm the data in those fields. One of the records is for a Non-Inventory product. For some reason, the Sample File does not match the correct format for the Type. You can tell this because it is highlighted in red.
    11
    Use the dropdown to select "Non-inventory".
    12
    Click "Import".