QuickBooks Online accounting software automates invoicing, billing, and reporting. Easily manage bookkeeping and accounting online.

quickbooksonline.intuit.com
accounting tier-1
Try Cloudpipes FREE for 14 days

Unlimited access to all features, so you can start automating your workflow.

Get started

Intuit Partner Platform Logo

Customers

  • Created At
    Updated At
    Sync Token
    ID
    Title
    Title of the person. For example Mr, Ms, Mrs, Dr.
    Given Name
    Middle Name
    Family Name
    Suffix
    Suffix of the name. For example, Jr.
    Fully Qualified Name
    Company Name
    Display Name
    Assigned by default, but needs to be unique within your company.
    Print on Check Name
    Name of the person or organization as printed on a check. If not provided, this is populated from Display Name.
    Active
    If true, this entity is currently enabled for use by QuickBooks.
    Primary Phone
    Alternate Phone
    Mobile
    Fax
    Primary Email Address
    Web Address
    Bill Address
    Ship Address
    Default Tax Code
  • Customer Created

    Triggers when a new Customer is created in the selected account.

  • Customer Updated

    Triggers when a Customer is updated in the selected account.

  • Create a Customer

    Creates a new Customer.

  • Update a Customer

    Updates the selected Customer.

  • Look Up a Customer

  • Search Customers

    Deletes the selected Customer.

Items

  • Created At
    Updated At
    Sync Token
    ID
    Name
    Sku
    The stock keeping unit (SKU) for this Item. This is a company-defined identifier for an item or product used in tracking inventory.
    Description
    Active
    Sub Item
    If true, this is a sub item. If false or null, this is a top-level item.
    Parent
    Parent product (category) ID. Needs to be specified if sub_item is True.
    Level
    Specifies the level of the hierarchy in which the entity is located. Zero specifies the top level of the hierarchy; Anything above will be the next level with respect to the parent. Limited to 5 levels.
    Fully Qualified Name
    Fully qualified name of the entity. The fully qualified name prepends the topmost parent, followed by each sub element separated by colons. Takes the form of Item:SubItem. Returned from an existing object and not input on a new object.Limited to 5 levels.
    Taxable
    Sales Tax Inclusive
    True if the sales tax is included in the item amount, and therefore is not calculated for the transaction.
    Unit Price
    Corresponds to the Price/Rate column on the QuickBooks Online UI to specify either unit price, a discount, or a tax rate for item.; If; used for unit price, the monetary value of the service or product, as expressed in the home currency.; If used for a discount or tax rate, express the percentage as a fraction.For example, specify 0.4 for 40 % tax.
    Type
    Income Account
    Reference to the posting account, that is, the account that records the proceeds from the sale of this item.
    Expense Account
    Reference to the expense account used to pay the vendor for this item.
    Purchase Description
    Purchase Tax Inclusive
    True if the purchase tax is included in the item amount, and therefore is not calculated for the transaction.
    Purchase Cost
    Amount paid when buying or ordering the item, as expressed in the home currency.
    Track Qty on Hand
    True if there is quantity on hand to be tracked. Once this value is true, it cannot be updated to false. Applicable for items of type Inventory. Not applicable for Service or NonInventory item types.
    Inventory Start Date
    Date of opening balance for the inventory transaction. (required for Inventory)
    Qty on Hand
    Current quantity of the Inventory items available for sale. Not used for Service or NonInventory type items..
  • Item Created

    Triggers when a new Item or Category is created in the selected account.

  • Item Updated

    Triggers when a Item or Category is updated in the selected account.

  • Create an Item

    Creates a new Item or Category.

  • Update an Item

    Updates the selected Item.

  • Look Up an Item

  • Search Items

    Deletes the selected Item.

Time Activities

  • Created At
    Updated At
    Sync Token
    ID
    Transaction Date
    The date entered by the user when this transaction occurred.
    Name Of
    What type of time is being tracked, vendor or employee time?
    Employee
    Specifies the employee whose time is being recorded. Required if Name Of is set to Employee. You can also give a primary email address or a display name in this field.
    Vendor
    Specifies the vendor whose time is being recorded. Required if Name Of is set to Vendor. You can also give a display name in this field.
    Item
    Customer
    You can give either an ID, email, or DisplayName in this field.
    Department
    Billable Status
    Taxable
    Start Time
    Time that work started. Provide either start and end time, or hourly rate and duration (hours and/or minutes)
    End Time
    Time that work ended. Provide either start and end time, or hourly rate and duration (hours and/or minutes)
    Hourly Rate
    Hourly bill rate of the employee or vendor for this time activity. Provide either start and end time, or hourly rate and duration (hours and/or minutes)
    Hours
    Hours worked. Provide either start and end time, or hourly rate and duration (hours and/or minutes)
    Minutes
    Minutes worked. Provide either start and end time, or hourly rate and duration (hours and/or minutes)
    Description
    Description of work completed during time activity.
  • Time Activity Created

    Triggers when a new Time Activity is created in the selected account.

  • Time Activity Updated

    Triggers when a Time Activity is updated in the selected account.

  • Create a Time Activity

    Creates a new Time Activity.

  • Update a Time Activity

    Updates the selected Time Activity.

  • Delete a Time Activity

    Deletes the selected Time Activity.

  • Search Time Activities

    Searches for Time Activities in the selected account and returns a list.

Invoices

  • Created At
    Updated At
    Sync Token
    ID
    Customer
    You can give either an ID, email, or DisplayName in this field.
    Doc Number
    Reference number for the transaction.
    Transaction Date
    The date entered by the user when this transaction occurred.
    Department
    Currency
    Code of the currency in which all amounts on the associated transaction are expressed. If not returned, currency for the transaction is the home currency of the company.
    Exchange Rate
    The number of home currency units it takes to equal one unit of currency.
    Private Note
    User entered, organization-private note about the transaction. This note does not appear on the invoice to the customer. This field maps to the Statement Memo field on the Invoice form in the QuickBooks Online UI.
    Lines
    Customer Memo
    Bill Address
    Ship Address
    Class
    Sales Term
    Ship Method (Ship Via)
    Ship Date
    Tracking Number
    Total Amount
    Indicates the total amount of the transaction. This includes the total of all the charges, allowances, and taxes.
    Home Total Amount
    Total amount of the transaction in the home currency. Includes the total of all the charges, allowances and taxes.
    Apply Tax After Discount
    Print Status
    Email Status
    Bill Email
    The e-mail address where the invoice is sent.
    Balance
    The balance reflecting any payments made against the transaction. Initially set to the value of Total Amount. A Balance of 0 indicates the invoice is fully paid.
    Home Balance
    Balance expressed in home currency.
    Txn Source
    Transaction Source.
    Deposit
    The deposit made towards this invoice.
    Custom Field 1
    Custom Field 2
    Custom Field 3
  • Invoice Created

    Triggers when a new Invoice is created in the selected account.

  • Invoice Updated

    Triggers when a Invoice is updated in the selected account.

  • Create an Invoice

    Creates a new Invoice.

  • Update an Invoice

    Updates the selected Invoice.

  • Delete an Invoice

    Deletes the selected Invoice.

  • Add a Line Item

    Adds a line item to an existing invoice.

  • Look Up Invoice

  • Search Invoices

    Searches for Invoices in the selected account and returns a list.

Try Cloudpipes FREE for 14 days

Unlimited access to all features, so you can start automating your workflow.