Introduction

  • SCHEMAS

  • Invoices

    Journal Entries

    Profit and Loss Detail Report

    Projects

    Bills

    Vendors

    Customers

    Credit Notes

    Accounts

    Items

    Bank Accounts

Introduction

A single schema to push and pull Accounting data across connectors.


Supported Connectors

Live

Microsoft Dynamics Business Central

NetSuite

NetSuite (R)

QuickBooks

QuickBooks Desktop

QuickBooks Sandbox

Sage Intacct

Xero

Zoho Books

Beta

logo for FreshBooks

FreshBooks

logo for MYOB

MYOB

logo for Microsoft Dynamics 365 Finance

Microsoft Dynamics 365 Finance

Accounts

Accounts are what businesses use to track transactions.

Properties



id

string


name

string


type

string


active

boolean


category

string


currency

string


parentId

string


createdAt

string


tenant_id

string


updatedAt

string


hg_deleted

boolean


parentName

string


subsidiary

string


description

string


subsidiaryId

string


accountNumber

string


isBankAccount

boolean

Example

COPY TO CLIPBOARD
{
  "id": "bd9e85e0-0478-433d-ae9f-0b3c4f04bfe4",
  "name": "Revenue - Subscriptions",
  "type": "incomestatement",
  "active": true,
  "category": "Revenue - Subscriptions",
  "currency": "USD",
  "createdAt": "2019-08-24T14:15:22Z",
  "updatedAt": "2019-08-24T14:15:22Z",
  "description": "",
  "accountNumber": "41000"
}

Bank Accounts

Provides the relevant information for a bank account.

Properties



id

any


name

any


type

any


active

any


currency

any


createdAt

any


swiftCode

any


updatedAt

any


hg_deleted

any


holderName

any


description

any


accountNumber

any

Example

COPY TO CLIPBOARD
{
  "id": "3302926931",
  "name": "Silicon Valley Bank",
  "type": "checking",
  "active": true,
  "currency": "USD",
  "createdAt": "2019-08-24T14:15:22Z",
  "updatedAt": "2019-08-24T14:15:22Z",
  "description": "",
  "accountNumber": "10160"
}

Bills

Properties



id

string


notes

string


number

string


status

string


balance

number


dueDate

string


currency

string


expenses

object [ ]


accountId

string


accountNumber

string


amount

number


department

string


id

string


taxAmount

number


taxCode

string


location

string


paidDate

string


vendorId

string


createdAt

string


issueDate

string


lineItems

object [ ]


accountName

string


accountNumber

string


classId

string


className

string


customFields

object [ ]


name

string


value

string


description

string


discount

number


id

string


orderId

string


productId

string


productName

string


quantity

number


serviceDate

string


taxCode

string


totalPrice

number


unitPrice

number


tenant_id

string


updatedAt

string


externalId

object


name

any


value

any


hg_deleted

boolean


locationId

string


vendorName

string


accountCode

string


accountName

string


attachments

object [ ]


id

string


name

string


url

string


totalAmount

number


customFields

object [ ]


name

string


value

string


currencyBalance

number

Example

COPY TO CLIPBOARD
{
  "id": "string",
  "status": "string",
  "address": {
    "id": "string",
    "city": "string",
    "name": "string",
    "line1": "string",
    "line2": "string",
    "line3": "string",
    "state": "string",
    "country": "string",
    "postalCode": "string"
  },
  "dueDate": "2019-08-24T14:15:22Z",
  "currency": "string",
  "paidDate": "2019-08-24T14:15:22Z",
  "subTotal": 0,
  "amountDue": 0,
  "createdAt": "2019-08-24T14:15:22Z",
  "issueDate": "2019-08-24T14:15:22Z",
  "lineItems": [
    {
      "taxCode": "string",
      "quantity": 0,
      "productId": "string",
      "taxAmount": 0,
      "unitPrice": 0,
      "productSku": "string",
      "totalPrice": 0,
      "accountName": "string",
      "description": "string",
      "productName": "string",
      "discountAmount": 0
    }
  ],
  "updatedAt": "2019-08-24T14:15:22Z",
  "vendorNum": "string",
  "vendorName": "string",
  "totalAmount": 0,
  "invoiceNumber": "string",
  "totalDiscount": 0,
  "totalTaxAmount": 0
}

Credit Notes

A Credit Note is a financial transaction representing a refund or credit of payment or part of a payment for goods or services that have been sold.

Properties



id

string


note

string

Any additional information about the credit note.


status

string

Draft, Submitted, Paid, PartiallyPaid, Void, Unknown


currency

string

Currency of the credit note.


subTotal

number

Value of the credit note, including discounts and excluding tax.


issueDate

string

Date of the credit note as recorded in the accounting system.


lineItems

string


customerRef

any


totalAmount

number

Total amount of credit that has been applied to the customer's accounts receivable.


currencyRate

string


modifiedDate

string

Date the record was last changed in the accounting system.


totalDiscount

number

Any discounts applied to the credit note amount.


totalTaxAmount

number

Any tax applied to the credit note amount.


allocatedOnDate

string

Date on which the credit note was fully allocated.


remainingCredit

number

Unused balance of totalAmount originally raised.


creditNoteNumber

string

Friendly reference for the credit note.


discountPercentage

number


paymentAllocations

string

Example

COPY TO CLIPBOARD
{
  "id": "string",
  "note": "string",
  "status": "string",
  "currency": "string",
  "subTotal": 0,
  "issueDate": "2019-08-24T14:15:22Z",
  "lineItems": "string",
  "customerRef": {
    "id": "71",
    "active": true,
    "addresses": [
      {
        "id": "123",
        "city": "San Francisco",
        "line1": "Main street",
        "line2": "apt #",
        "line3": "Suite #",
        "state": "CA",
        "country": "US",
        "postalCode": "94104"
      }
    ],
    "createdAt": "2017-08-12T20:43:21.291Z",
    "updatedAt": "2017-08-12T20:43:21.291Z",
    "contactName": "Tony Stark",
    "customerName": "Stark Industries",
    "emailAddress": "tony@starkindustries.com",
    "phoneNumbers": [
      {
        "type": "mobile",
        "number": "111-111-1111"
      }
    ]
  },
  "totalAmount": 0,
  "currencyRate": "string",
  "modifiedDate": "2019-08-24T14:15:22Z",
  "totalDiscount": 0,
  "totalTaxAmount": 0,
  "allocatedOnDate": "2019-08-24T14:15:22Z",
  "remainingCredit": 0,
  "creditNoteNumber": "string",
  "discountPercentage": 0,
  "paymentAllocations": "string"
}

Customers

A customer is a consumer of the service or product that your business offers.

Properties



id

string


notes

string


title

string


active

boolean


suffix

string


balance

number


ownerId

string


taxCode

string


taxable

boolean


website

string


currency

string


lastName

string


addresses

object [ ]


city

string


country

string


id

string


line1

string


line2

string


line3

string


postalCode

string


state

string


checkName

string


createdAt

string


firstName

string


salesTerm

string


tenant_id

string


updatedAt

string


middleName

string


subsidiary

string


balanceDate

string


contactName

string


customFields

object [ ]


name

string


value

string


customerName

string


customerType

string


emailAddress

string


phoneNumbers

object [ ]


number

string


type

string


paymentMethod

string


parentReference

object


id

any


name

any

Example

COPY TO CLIPBOARD
{
  "id": "71",
  "active": true,
  "addresses": [
    {
      "id": "123",
      "city": "San Francisco",
      "line1": "Main street",
      "line2": "apt #",
      "line3": "Suite #",
      "state": "CA",
      "country": "US",
      "postalCode": "94104"
    }
  ],
  "createdAt": "2017-08-12T20:43:21.291Z",
  "updatedAt": "2017-08-12T20:43:21.291Z",
  "contactName": "Tony Stark",
  "customerName": "Stark Industries",
  "emailAddress": "tony@starkindustries.com",
  "phoneNumbers": [
    {
      "type": "mobile",
      "number": "111-111-1111"
    }
  ]
}

Invoices

An Invoice represents a sales form where the customer pays for a product or service later.

Properties



id

string


status

string


address

object [ ]


city

string


country

string


id

string


line1

string


line2

string


line3

string


postalCode

string


state

string


deposit

number


dueDate

string


taxCode

string


currency

string


paidDate

string


shipDate

string


subTotal

number


amountDue

number


billEmail

string


createdAt

string


issueDate

string


lineItems

object [ ]


accountName

string


accountNumber

string


classId

string


className

string


customFields

object [ ]


name

string


value

string


description

string


discount

number


id

string


productId

string


productName

string


quantity

number


serviceDate

string


taxCode

string


totalPrice

number


unitPrice

number


salesTerm

string


tenant_id

string


updatedAt

string


customerId

string


shipMethod

string


subsidiary

string


invoiceMemo

string


totalAmount

number


customFields

object [ ]


name

string


value

string


customerMemo

string


customerName

string


invoiceNumber

string


paymentMethod

string


totalDiscount

number


trackingNumber

string

Example

COPY TO CLIPBOARD
{
  "id": "6f3c9546-1ca9-11ed-861d-0242ac120002",
  "status": "Draft",
  "address": {
    "id": "78391098-1ca9-11ed-861d-0242ac120002",
    "city": "Redmond",
    "line1": "One Microsoft Way",
    "line2": "",
    "line3": "",
    "state": "WA",
    "country": "USA",
    "postalCode": "98052"
  },
  "dueDate": "2022-08-08T22:40:50Z",
  "currency": "USD",
  "paidDate": null,
  "subTotal": 21.8,
  "amountDue": 21.8,
  "createdAt": "2022-08-01T22:40:50Z",
  "issueDate": "2022-08-01T22:40:50Z",
  "lineItems": [
    {
      "id": "69fff8fc-1ca9-11ed-861d-0242ac120002",
      "quantity": 5,
      "productId": "72f94e9a-1ca9-11ed-861d-0242ac120002",
      "taxAmount": 1.8,
      "unitPrice": 6,
      "totalPrice": 30,
      "accountName": "Produce",
      "description": "Organic Bananas",
      "productName": "Banana",
      "discountAmount": 10
    }
  ],
  "updatedAt": "2022-08-01T22:40:50Z",
  "customerId": "64c63216-1ca9-11ed-861d-0242ac120002",
  "totalAmount": 30,
  "customerName": "Gates Foundation",
  "invoiceNumber": "001",
  "totalDiscount": 10,
  "totalTaxAmount": 1.8
}

Items

An item is a thing that your company buys, sells, or re-sells, such as products and services. An item is shown as a line on an invoice or other sales form.

Properties



id

string


sku

string


code

string


name

string


type

string


active

boolean


taxCode

string


taxable

boolean


billItem

object


accountId

any


description

any


unitPrice

any


category

string


createdAt

string


tenant_id

string


updatedAt

string


isBillItem

boolean


invoiceItem

object


accountId

any


description

any


unitPrice

any


invStartDate

string


reorderPoint

string


isInvoiceItem

boolean


quantityOnHand

number

Example

COPY TO CLIPBOARD
{
  "id": "1",
  "code": "CCD",
  "name": "Concrete",
  "type": "Inventory",
  "active": true,
  "billItem": {
    "accountId": "123",
    "unitPrice": 10,
    "description": "Concrete for fountain installation"
  },
  "category": "Landscaping",
  "createdAt": "2019-08-24T14:15:22Z",
  "updatedAt": "2019-08-24T14:15:22Z",
  "isBillItem": true,
  "invoiceItem": {
    "accountId": "321",
    "unitPrice": 15,
    "description": "Concrete for fountain installation"
  },
  "isInvoiceItem": true
}

Journal Entries

A Journal Entry is a transaction in which there are at least one pair of lines, a debit and a credit, called distribution lines.

Properties



id

string


number

string


classId

string


currency

string


className

string


tenant_id

string


description

string


customFields

object [ ]


name

string


value

string


departmentId

string


journalLines

object [ ]


accountId

string


accountName

string


accountNumber

string


amount

number


classId

string


className

string


costCenter

string


costUnit

string


customFields

object [ ]


name

string


value

string


customerName

string


departmentId

string


departmentName

string


description

string


locationId

string


locationName

string


postingType

string


projectId

string


projectName

string


taxCode

string


supplierName

string


departmentName

string


transactionDate

string


paymentReference

string

Example

COPY TO CLIPBOARD
{
  "id": "053122 Rev_Rec USD 1",
  "lines": [
    {
      "amount": 31240.5896,
      "className": "",
      "accountName": "Deferred Revenue",
      "description": "202205 Revenue Recognition - Accenture",
      "postingType": "Debit",
      "customerName": "Accenture",
      "accountNumber": "2400"
    },
    {
      "amount": 1001.2453,
      "className": "",
      "accountName": "Recurring",
      "description": "202205 Revenue Recognition - Accenture",
      "postingType": "Credit",
      "customerName": "Accenture",
      "accountNumber": "4100"
    },
    {
      "amount": 30239.3443,
      "className": "",
      "accountName": "Non-Recurring",
      "description": "202205 Revenue Recognition - Accenture",
      "postingType": "Credit",
      "customerName": "Accenture",
      "accountNumber": "4200"
    }
  ],
  "currency": "USD",
  "transactionDate": "5/31/2022"
}

Profit and Loss Detail Report

Profit and loss (P&L) statement is a financial statement that summarizes the revenues, costs, and expenses incurred during a specified period.

Properties



id

string

Unique id of the transaction


Num

string

Account Number


Date

string

Date of transaction


Memo

string

Description of the transaction


Name

string

Name of the associated entity on this transaction. Usually a customer or a vendor


Class

string

Class name on this transaction


Split

string

Account for this transaction


Amount

number

Transaction Amount


Categories

string [ ]

Fully qualified account name / hierarchy of this transaction


Department

string

Typically a division of a subsidiary


CompanyName

string

Name of the company this transaction is for (usually only relevant in multi-company ERPs)


entity_name

string

Name of the entity associated with this transaction


entity_type

string

Type of entity associated with this transaction. Usually "Customer" or "Vendor"


TransactionType

string

Type of transaction: Journal Entry, Invoice, Credit Memo, etc.

Example

COPY TO CLIPBOARD
{
  "id": "2608_1",
  "Num": "62100",
  "Date": "2019-08-24",
  "Memo": "JE per Annie from EY 2020 Audit",
  "Name": "",
  "Class": "",
  "Split": "JE per Annie from EY 2020 Audit",
  "Amount": 7867.1,
  "Categories": [
    "Expense",
    "62044 Allocated Overhead : Rent Payments",
    "62044 Rent Payments"
  ],
  "Department": "People",
  "CompanyName": "ACME, Corp",
  "entity_name": "",
  "entity_type": "",
  "TransactionType": "Journal Entry"
}

Projects

Properties



id

string


name

string


type

string


active

boolean


classId

string


endDate

string


category

string


currency

string


location

string


className

string


createdAt

string


startDate

string


updatedAt

string


customerId

string


hg_deleted

boolean


locationId

string


description

string


customFields

object [ ]


name

string


value

string


customerName

string


departmentId

string


locationName

string


projectNumber

string


departmentName

string

Example

COPY TO CLIPBOARD
{
  "id": "string",
  "name": "string",
  "type": "string",
  "active": true,
  "endDate": "2019-08-24T14:15:22Z",
  "category": "string",
  "currency": "string",
  "className": "string",
  "createdAt": "2019-08-24T14:15:22Z",
  "startDate": "2019-08-24T14:15:22Z",
  "updatedAt": "2019-08-24T14:15:22Z",
  "customerId": "string",
  "locationId": "string",
  "description": "string",
  "customerName": "string",
  "departmentId": "string",
  "locationName": "string",
  "departmentName": "string"
}

Vendors

Properties



id

string


active

boolean


currency

string


addresses

object [ ]


city

string


country

string


id

string


line1

string


line2

string


line3

string


postalCode

string


state

string


createdAt

string


tenant_id

string


updatedAt

string


hg_deleted

boolean


vendorCode

string


vendorName

string


contactName

string


paymentTerm

string


bankAccounts

object [ ]


accountNumber

string


active

boolean


createdAt

string


currency

string


description

string


hg_deleted

boolean


holderName

string


id

string


name

string


swiftCode

string


type

string


updatedAt

string


emailAddress

string


phoneNumbers

object [ ]


number

string


type

string


vendorNumber

string


taxPayerNumber

string


vendorGroupCode

string

Example

COPY TO CLIPBOARD
{
  "id": "string",
  "active": true,
  "currency": "string",
  "addresses": [
    {}
  ],
  "createdAt": "2019-08-24T14:15:22Z",
  "updatedAt": "2019-08-24T14:15:22Z",
  "vendorName": "string",
  "contactName": "string",
  "emailAddress": "string",
  "phoneNumbers": [
    {}
  ]
}