Understanding Invoice Data from Jobber - Adhesion Connect Guide

Understanding Invoice Data

To help you understand the Invoice information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to best use the information in your integrations and automations.

Invoice

A request for payment which Service Providers send to their clients after the work is done.

Fields

amounts

Description: All amounts related to the Invoice.

  1. deposit

Field Type: decimal
Description: The deposit amount.

  1. discount

Field Type: decimal
Description: The discount amount.

  1. balance

Field Type: decimal
Description: The Invoice balance after all Payments.

  1. non_tax

Field Type: decimal
Description: The non-tax amount including line items which are exempted from the tax.

  1. payments

Field Type: decimal
Description: The total Payments paid on the Invoice.

  1. subtotal

Field Type: decimal
Description: The subtotal including line item costs but excluding tax amounts.

  1. tax

Field Type: decimal
Description: The tax amount.

  1. tips

Field Type: decimal
Description: The sum of all tips paid to an Invoice.

  1. total

Field Type: decimal
Description: The total cost of the Invoice, including line item costs and tax amounts.

billing_address

Description: The billing address associated with the Invoice.

  1. street

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The street address.

  1. street_1

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The first line of the street address.

  1. street_2

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The second line of the street address.

  1. city

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The city of the address.

  1. province_state

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The province/state of the address.

  1. postal_code

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The postal code of the address.

  1. country

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The country of the address.

billing_and_property_address_match

Field Type: boolean (true/false)
Description: If the Invoice has a billing address, identifies whether the billing address is the same as the property address.

client

Description: The Client associated with the Invoice.

  1. id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the Client.

  1. name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The name of the Client.

  1. first_name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The first name of the Client.

  1. last_name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The last name of the Client.

  1. email

Description: The email addresses of the Client.
  1. address
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The email address as stored.
  1. primary
Field Type: boolean (true/false)
Description: Identifies if this is the primary email address.

client_hub

Description: The client hub information related to this Invoice.
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The URL of the Invoice in the client hub.

  1. viewed_at

Field Type: date (date & time in ISO8601)
Description: The date the invoice was viewed in client hub.

created_at

Field Type: date (date & time in ISO8601)
Description: The date and time the Invoice was created.

custom_fields

Field Type: multiple
Description: Your custom fields represented as key:value pairs.
Example: 
{
"custom field label 1": "custom field value 1",
"custom field label 2": "custom field value 2"
}

due_date

Field Type: date (date & time in ISO8601)
Description: The date the Invoice is due on.

net_terms

Field Type: integer
Description: The number of days after the issue date that payment is due.

number

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The Invoice number.

status

Field Type: select (draft, awaiting payment, paid, past due, bad debt)
Description: The status of the Invoice.

issued_date

Field Type: date (date & time in ISO8601)
Description: The date the Invoice was issued on.

jobs

Description: The Jobs related to the Invoice.

  1. id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the Job.

  1. job_number

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The number of the Job.

line_items

Description: The line items on the Invoice.

  1. id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the line item.

  1. created_at

Field Type: date (date & time in ISO8601)
Description: The date and time the line item was created.

  1. category

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The category of the line item.

  1. date

Field Type: date (date & time in ISO8601)
Description: The date of service associated with the line item.

  1. description

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The description of the line item.

  1. name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The name of the line item.

  1. quantity

Field Type: decimal
Description: The quantity of the line item.

  1. taxable

Field Type: boolean (true/false)
Description: Identifies if the line item is taxable.

  1. unit_price

Field Type: decimal
Description: The unit price of the line item.

  1. total_price

Field Type: decimal
Description: The total price of the line item.

  1. updated_at

Field Type: date (date & time in ISO8601)
Description: The last date and time the line item was updated.

message

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The message on the Invoice.

payments

Description: The Payment records applied to the Invoice.

  1. id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the Payment.

  1. adjustment_type

Field Type: select (invoice, refund, correction, initial balance, failed ach payment, payment, deposit, bad debt)
Description: The type of Payment record.

  1. amount

Field Type: decimal
Description: The amount applied against the Invoice balance.

  1. date

Field Type: date (date & time in ISO8601)
Description: The date and time the Payment record was created.

  1. status

Field Type: select (in dispute, pending, refunded, failed, disputed, succeeded)
Description: The status of the Payment.

  1. tip_amount

Field Type: decimal
Description: The amount of the tip associated with the Payment.

properties

Description: The Properties related to the Invoice.

  1. id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the Property.

  1. property_address

Description: The address of the Property
  1. street
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The complete street component of this address.
  1. street_1
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The first line of this address.
  1. street_2
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The second line of this address.
  1. city
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The city for this address.
  1. province_state
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The province/state for this address.
  1. postal_code
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The zip or postal code for this address.
  1. country
Field Type: string (text, numbers, and/or special characters stored as text)
Description: The country for this address.

received_date

Field Type: date (date & time in ISO8601)
Description: The date and time the Invoice was received on.

subject

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The subject of the Invoice.

tax_calculation_method

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The tax calculation method on the Invoice.

tax_rate

Description: The tax rate information on the Invoice.

  1. id

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The unique identifier from Jobber for the tax rate.

  1. default

Field Type: boolean (true/false)
Description: Identifies if this tax rate is the default.

  1. description

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The internal description of the tax rate.

  1. label

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The names and rates of the component tax rates combined.

  1. name

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The name of the tax rate.

  1. quickbooks_tax_type

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The type of QuickBooks sync.

  1. tax

Field Type: decimal
Description: The tax percentage.

updated_at

Field Type: date (date & time in ISO8601)
Description: The last date and time the Invoice was updated.

event_type

Field Type: string (text, numbers, and/or special characters stored as text)
Description: The Jobber event that happened (Invoice Create/Invoice Update).


    • Related Articles

    • Understanding Payment Data

      To help you understand the Payment information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to best use the ...

    • Understanding Visit Data

      To help you understand the Timesheet information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to best use the ...

    • Understanding Product & Service Data

      To help you understand the Product and Service information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to ...

    • Airtable - Jobber Data Template

      How to Integrate Jobber Data with Airtable Using Adhesion Connect This article provides a step-by-step guide on integrating Jobber data with Airtable using the Adhesion Connect application. This integration enables real-time reporting and management ...

    • Understanding Property Data

      To help you understand the Product and Service information available through Adhesion Connect for Jobber we've put together the following outline. Each data component includes the field type and a description below it to help you understand how to ...