Browse
 
Tools
Rss Categories

Import Invoices from a CSV File

Overview

This tutorial will show you the steps to import orders or invoices from a CSV file. If an invoice is being imported that has a client attached to it that already exists in StudioCloud then StudioCloud will automatically attach the invoice to that client.

How to Import Invoices into StudioCloud

Make sure that the CSV file you are importing has column headers matching the headers in the section "What are the column headers required for the csv file" below.  StudioCloud will match up the data in the CSV file using those column headers.

  1. Click on the Point of Sale component
  2. Click on the Invoices tab
  3. Click the Invoices/Estimates/Quotes button
  4. Click the Import menu button and select the Import Invoices Directly to Cloud option to open the Import Invoice window
  5. In the Import Invoice window click the Import Options menu button and select Import Invoices from CSV Files
  6. Find the file on your computer 
  7. Click the Open button
  8. Once you see the invoice window make any necessary changes
  9. Click the Save button

Limitations

  • The sales tax is a percentage and not the actual value.of the sales tax

What are the column headers required for the csv file

Note: Column headers are required for each column or the data will not be imported correctly.

The columns listed below are all optional, with the exception of Invoice Number and Invoice Date, and the columns can be in any order. However, they must be worded exactly as listed below. Please note that the column headers are case-sensitive.

  1. Invoice #
    1. This is the number associated with the invoice. This column is required.
    2. Note: If the invoice number already exists for another invoice in StudioCloud the invoice will not be imported.
    3. The header "Invoice Number" is also supported
  2. Order Date
    1. This invoice date is in the format of (MM/DD/YY or MM/DD/YYYY) This column is required
    2. The header "Invoice Date" is also supported
  3. Public Notes
    1. These are notes that would appear on the printed invoice for the customer to see.
    2. The header "Notes" can also be used
  4. Internal Notes
    1. These are notes that would not appear on the printed invoice.
    2. The header "Private Notes" is also supported
  5. Search Type
    1. This is the criteria whereby StudioCloud will match clients that already exist in StudioCloud with the invoice. This column is just a number 1 through 4 and nothing more. Below is a breakdown of what each number means
    2. 1 = Search by Client Number.
    3. 2 = Search by Client First and Last Name
    4. 3 = Search by Client Email
    5. 4 = Do not search. Just create a brand new client with the client number, client first name, client last name, and client email address if they exist. 
  6. Client Number
    1. This is the client number
  7. Customer Name
    1. This is the last name of the client followed by the first name with a comma separating them. For example, "Doe, John"
  8. Client First Name
    1. This is the first name of the client. The column "Customer Name" would not be used if this column is used.
  9. Client Last Name
    1. This is the first name of the client. The column "Customer Name" would not be used if this column is used.
    2. If this field is blank then the last name of "Unknown" will automatically be added to the client
  10. Client Email
    1. This is the email address for the client
  11. Invoice Taxable Amount
    1. This is the amount in the invoice that will be taxed
    2. The header "Taxable Amount" is also supported
  12. Invoice Non-Taxable Amount
    1. This is the amount in the invoice that will not be taxed
    2. The header "Non-Taxable Amount" is also supported
  13. Discount Type
    1. $ or %. This column will have either a $ character which means it is the dollar amount of the discount or a % character which means it is a percentage discount
  14. Discount
    1. This either the dollar amount or the percentage. For example, if discount type is $ then the discount amount would be something like 5 which means 5 dollars. If it is a % then the discount amount would be 5 which means 5%.
  15. Shipping
    1. This is the dollar value for the shipping cost. For example, if 5 was entered then the shipping would be $5.
  16. Tax
    1. This is the percentage value of the tax. For example, if 5 was entered then the tax would be 5%. The default is 0.
    2. The header "Tax Rate" is also supported
  17. Tax 2
    1. This is the secondary tax if applicable and it is a percentage.  For example, if 5 was entered then the tax would be 5%. The default is 0.
  18. Payment Amount
    1. This is the dollar amount that has been paid on the invoice. Only one payment is supported for this import process
  19. Payment Date
    1. This payment date is in the format of (MM/DD/YY or MM/DD/YYYY)
  20. Payment Note
    1. This is a note attached to the payment
  21. Payment Method
    1. This is the method regarding how the payment was made. For example, Cash, Credit Card, Check, etc. 
  22. Check Number
    1. This is the number of the check if the Payment Method of Check as entered above