Exact Online
App · 22 actions
Work with your Exact Online administration: relations, contacts, items, sales invoices, G/L accounts, VAT codes and receivables.
Actions
| Action | What it does |
|---|---|
| Create contact | Add a contact person to a relation. |
| Create item | Add an item to sell or purchase. |
| Create relation | Add a relation: a customer, prospect or supplier. |
| Create sales invoice | Create an open sales invoice for a customer, with one or more item lines. |
| Delete contact | Delete a contact person. |
| Delete item | Delete an item. |
| Delete relation | Delete a relation. |
| Delete sales invoice | Delete a sales invoice that is still draft or open. |
| Get current user | Get the signed-in Exact Online user and the division they work in now. |
| Get relation | Get one relation with its address, type and contact details. |
| Get sales invoice | Get one sales invoice with its lines. |
| List contacts | List contact people, optionally for one relation or one email address. |
| List divisions | List the divisions (companies) the signed-in user can reach. |
| List G/L accounts | List general ledger accounts with their codes and types. |
| List items | List items, filtered by code, whether they are sold, or change date. |
| List journals | List the division's journals, such as the sales journals invoices are booked in. |
| List receivables | List what customers still owe, invoice by invoice, with due dates. |
| List relations | List relations (customers, suppliers, prospects), filtered by name, email, type or change date. |
| List sales invoices | List sales invoices, filtered by status, customer or invoice date. |
| List VAT codes | List the division's VAT codes and rates. |
| Process and send sales invoice | Make a sales invoice final, create its document and optionally email it to the customer. |
| Update relation | Change a relation. |
Create contact
Add a contact person to a relation.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Relation
account_idtextRequired - The relation the contact works for.
- First name
first_nametext - Their first name. Give a first or a last name.
- Last name
last_nametext - Their last name. Give a first or a last name.
- Email
emailtext - Their email address.
- Phone
phonetext - Their phone number.
- Mobile
mobiletext - Their mobile number.
- Job title
job_titletext - Their job title.
- Main contact
is_main_contacttrue/false - Turn on to make them the relation's main contact.
- Notes
notestext - Notes about the contact.
Outputs
contactobject- The contact person
Example output
{
"contact": {
"Account": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"AccountName": "Clearwater BV",
"Created": "2026-11-18T09:34:00Z",
"Email": "anna@clearwater.example",
"FirstName": "Anna",
"FullName": "Anna de Vries",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"IsMainContact": true,
"JobTitleDescription": "Buyer",
"LastName": "de Vries",
"Mobile": "+31 6 1234 5678",
"Modified": "2026-11-18T09:34:00Z",
"Phone": "+31 20 123 4567"
}
}Create item
Add an item to sell or purchase.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Item code
codetextRequired - Your unique code for the item.
- Description
descriptiontextRequired - The item's description.
- Can be sold
is_sales_itemtrue/false - Whether the item can be sold. Defaults to on.Default:
true. - Can be purchased
is_purchase_itemtrue/false - Whether the item can be purchased.
- Unit
unittext - The item's standard unit code, such as pc.
- Standard cost price
cost_pricenumber - The item's standard cost price.
- Revenue G/L account
revenue_gl_accounttext - The G/L account its revenue is booked on. Defaults to the item group's.
- Notes
notestext - Notes about the item.
Outputs
itemobject- The item
Example output
{
"item": {
"Code": "CONSULT-HR",
"CostPriceStandard": 45.0,
"Created": "2026-11-18T09:34:00Z",
"Description": "Consulting hour",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"IsPurchaseItem": false,
"IsSalesItem": true,
"IsStockItem": false,
"Modified": "2026-11-18T09:34:00Z",
"Notes": "Billed per started hour",
"Unit": "pc"
}
}Create relation
Add a relation: a customer, prospect or supplier.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Name
nametextRequired - The relation's name.
- Code
codetext - Your own numeric code for the relation. Exact Online gives the next one if empty.
- Relation type
statustext - Customer, prospect, suspect or none. Defaults to customer.One of:
C(Customer),P(Prospect),S(Suspect),A(None). - Supplier
is_suppliertrue/false - Turn on when it is also a supplier.
- Email
emailtext - Its email address.
- Phone
phonetext - Its phone number.
- Address
address_line1text - Visit address, first line.
- City
citytext - Visit address city.
- Postcode
postcodetext - Visit address postcode.
- Country
countrytext - Two-letter country code, such as NL.
- Website
websitetext - Its website.
- VAT number
vat_numbertext - Its VAT number.
- Chamber of commerce number
chamber_of_commercetext - Its chamber of commerce number.
- Remarks
remarkstext - Remarks about the relation.
Outputs
accountobject- The relation (customer, supplier or prospect)
Example output
{
"account": {
"AddressLine1": "Molengraaffsingel 33",
"Blocked": false,
"City": "Delft",
"Code": " 1001",
"Country": "NL",
"Created": "2026-11-18T09:34:00Z",
"Email": "info@clearwater.example",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"IsSales": true,
"IsSupplier": false,
"Modified": "2026-11-18T09:34:00Z",
"Name": "Clearwater BV",
"Phone": "+31 20 123 4567",
"Postcode": "2629 JD",
"Status": "C",
"VATNumber": "NL001234567B01",
"Website": "https://clearwater.example"
}
}Create sales invoice
Create an open sales invoice for a customer, with one or more item lines.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Customer
account_idtextRequired - The customer who ordered.
- Sales journal
journaltextRequired - The sales journal to book it in.
- Item
item_idtextRequired - The item on the first line.
- Quantity
quantitynumber - How many of the item. Defaults to 1.
- Unit price
unit_pricenumber - The price per unit. Defaults to the item's sales price.
- Line description
line_descriptiontext - The first line's text. Defaults to the item's description.
- VAT code
vat_codetext - The first line's VAT code. Defaults to the item's.
- More lines
more_lineslist - Further lines, each with an item (its ID) and optionally quantity, unit_price, description and vat_code.
- Invoice date
invoice_datedate - The invoice date. Defaults to today.
- Description
descriptiontext - The invoice's description.
- Customer reference
your_reftext - The customer's own reference, such as their PO number.
- Payment condition
payment_conditiontext - When payment is due. Defaults to the customer's.
- Remarks
remarkstext - Extra remarks.
Outputs
invoiceobject- The sales invoice with its lines
Example output
{
"invoice": {
"AmountDC": 121.0,
"AmountFC": 121.0,
"Created": "2026-11-18T09:34:00Z",
"Currency": "EUR",
"Description": "November consulting",
"DueDate": "2026-11-18T09:34:00Z",
"InvoiceDate": "2026-11-18T09:34:00Z",
"InvoiceID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"InvoiceNumber": 26700001,
"InvoiceTo": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"InvoiceToName": "Clearwater BV",
"Journal": "70",
"Modified": "2026-11-18T09:34:00Z",
"OrderedBy": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"OrderedByName": "Clearwater BV",
"PaymentCondition": "30",
"SalesInvoiceLines": [
{
"AmountFC": 100.0,
"Description": "Consulting, week 46",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"Item": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"ItemDescription": "Consulting hour",
"Quantity": 2.0,
"UnitPrice": 50.0,
"VATCode": "2"
}
],
"Status": 20,
"StatusDescription": "Open",
"VATAmountDC": 21.0,
"YourRef": "PO-4711"
}
}Delete contact
Delete a contact person.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Contact ID
contact_idtextRequired - The contact's ID, from 'List contacts' or an earlier step.
Outputs
deletedtrue/false- True once Exact Online has deleted it
idtext- The ID of what was deleted
Example output
{
"deleted": true,
"id": "dd0273aa-67bc-410b-9321-f27c40af22a9"
}Delete item
Delete an item. Exact Online refuses if it has been used.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Item
item_idtextRequired - The item. Pick one, or use an ID from an earlier step.
Outputs
deletedtrue/false- True once Exact Online has deleted it
idtext- The ID of what was deleted
Example output
{
"deleted": true,
"id": "dd0273aa-67bc-410b-9321-f27c40af22a9"
}Delete relation
Delete a relation. Exact Online refuses if it is used in transactions.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Relation
account_idtextRequired - The relation (customer, supplier or prospect). Pick one, or use an ID from an earlier step.
Outputs
deletedtrue/false- True once Exact Online has deleted it
idtext- The ID of what was deleted
Example output
{
"deleted": true,
"id": "dd0273aa-67bc-410b-9321-f27c40af22a9"
}Delete sales invoice
Delete a sales invoice that is still draft or open.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Invoice ID
invoice_idtextRequired - The sales invoice's ID (InvoiceID), from 'List sales invoices' or an earlier step.
Outputs
deletedtrue/false- True once Exact Online has deleted it
idtext- The ID of what was deleted
Example output
{
"deleted": true,
"id": "dd0273aa-67bc-410b-9321-f27c40af22a9"
}Get current user
Get the signed-in Exact Online user and the division they work in now.
Inputs
None.
Outputs
userobject- The signed-in user
Example output
{
"user": {
"CurrentDivision": 123456,
"Email": "anna@clearwater.example",
"FullName": "Anna de Vries",
"LanguageCode": "en-GB",
"UserID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"UserName": "anna@clearwater.example"
}
}Get relation
Get one relation with its address, type and contact details.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Relation
account_idtextRequired - The relation (customer, supplier or prospect). Pick one, or use an ID from an earlier step.
Outputs
accountobject- The relation (customer, supplier or prospect)
Example output
{
"account": {
"AddressLine1": "Molengraaffsingel 33",
"Blocked": false,
"City": "Delft",
"Code": " 1001",
"Country": "NL",
"Created": "2026-11-18T09:34:00Z",
"Email": "info@clearwater.example",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"IsSales": true,
"IsSupplier": false,
"Modified": "2026-11-18T09:34:00Z",
"Name": "Clearwater BV",
"Phone": "+31 20 123 4567",
"Postcode": "2629 JD",
"Status": "C",
"VATNumber": "NL001234567B01",
"Website": "https://clearwater.example"
}
}Get sales invoice
Get one sales invoice with its lines.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Invoice ID
invoice_idtextRequired - The sales invoice's ID (InvoiceID), from 'List sales invoices' or an earlier step.
Outputs
invoiceobject- The sales invoice with its lines
Example output
{
"invoice": {
"AmountDC": 121.0,
"AmountFC": 121.0,
"Created": "2026-11-18T09:34:00Z",
"Currency": "EUR",
"Description": "November consulting",
"DueDate": "2026-11-18T09:34:00Z",
"InvoiceDate": "2026-11-18T09:34:00Z",
"InvoiceID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"InvoiceNumber": 26700001,
"InvoiceTo": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"InvoiceToName": "Clearwater BV",
"Journal": "70",
"Modified": "2026-11-18T09:34:00Z",
"OrderedBy": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"OrderedByName": "Clearwater BV",
"PaymentCondition": "30",
"SalesInvoiceLines": [
{
"AmountFC": 100.0,
"Description": "Consulting, week 46",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"Item": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"ItemDescription": "Consulting hour",
"Quantity": 2.0,
"UnitPrice": 50.0,
"VATCode": "2"
}
],
"Status": 20,
"StatusDescription": "Open",
"VATAmountDC": 21.0,
"YourRef": "PO-4711"
}
}List contacts
List contact people, optionally for one relation or one email address.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Relation
account_idtext - Only this relation's contacts.
- Email
emailtext - Only contacts with exactly this email address.
- Maximum results
limitnumber - How many to return, 1 to 300. Defaults to 60.From 1 to 300.
Outputs
contactslist- The contacts
countnumber- How many were returned
Example output
{
"contacts": [
{
"Account": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"AccountName": "Clearwater BV",
"Created": "2026-11-18T09:34:00Z",
"Email": "anna@clearwater.example",
"FirstName": "Anna",
"FullName": "Anna de Vries",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"IsMainContact": true,
"JobTitleDescription": "Buyer",
"LastName": "de Vries",
"Mobile": "+31 6 1234 5678",
"Modified": "2026-11-18T09:34:00Z",
"Phone": "+31 20 123 4567"
}
],
"count": 1
}List divisions
List the divisions (companies) the signed-in user can reach.
Inputs
None.
Outputs
countnumber- How many were returned
divisionslist- The divisions
Example output
{
"count": 1,
"divisions": [
{
"Code": 123456,
"Country": "NL",
"Currency": "EUR",
"Current": true,
"Description": "Clearwater BV",
"Status": 1
}
]
}List G/L accounts
List general ledger accounts with their codes and types.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Balance type
balance_typetext - Only balance sheet or only profit and loss accounts.One of:
B(Balance sheet),W(Profit and loss). - Maximum results
limitnumber - How many to return, 1 to 300. Defaults to 60.From 1 to 300.
Outputs
countnumber- How many were returned
gl_accountslist- The G/L accounts
Example output
{
"count": 1,
"gl_accounts": [
{
"BalanceType": "W",
"Code": "8000",
"Description": "Revenue",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"Type": 110,
"TypeDescription": "Revenue",
"VATCode": "2"
}
]
}List items
List items, filtered by code, whether they are sold, or change date.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Item code
codetext - Only the item with exactly this code.
- Sales items only
sales_items_onlytrue/false - Only items that can be sold.
- Changed since
modified_sincedate - Only items changed on or after this day.
- Maximum results
limitnumber - How many to return, 1 to 300. Defaults to 60.From 1 to 300.
Outputs
countnumber- How many were returned
itemslist- The items
Example output
{
"count": 1,
"items": [
{
"Code": "CONSULT-HR",
"CostPriceStandard": 45.0,
"Created": "2026-11-18T09:34:00Z",
"Description": "Consulting hour",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"IsPurchaseItem": false,
"IsSalesItem": true,
"IsStockItem": false,
"Modified": "2026-11-18T09:34:00Z",
"Notes": "Billed per started hour",
"Unit": "pc"
}
]
}List journals
List the division's journals, such as the sales journals invoices are booked in.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Type
journal_typetext - Only journals of this type, such as sales journals for invoices.One of:
20(Sales),21(Return invoice),22(Purchase),23(Received return invoice),10(Cash),12(Bank),16(Payment service),90(General journal).
Outputs
countnumber- How many were returned
journalslist- The journals
Example output
{
"count": 1,
"journals": [
{
"Code": "70",
"Description": "Sales journal",
"Type": 20
}
]
}List receivables
List what customers still owe, invoice by invoice, with due dates.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Customer code
account_codetext - Only this customer's receivables, by their code.
- Maximum results
limitnumber - How many to return, 1 to 300. Defaults to 60.From 1 to 300.
Outputs
countnumber- How many were returned
receivableslist- The outstanding receivables
Example output
{
"count": 1,
"receivables": [
{
"AccountCode": " 1001",
"AccountName": "Clearwater BV",
"Amount": 121.0,
"CurrencyCode": "EUR",
"Description": "November consulting",
"DueDate": "2026-11-18T09:34:00Z",
"InvoiceDate": "2026-11-18T09:34:00Z",
"InvoiceNumber": 26700001
}
]
}List relations
List relations (customers, suppliers, prospects), filtered by name, email, type or change date.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Name
nametext - Only the relation with exactly this name.
- Email
emailtext - Only relations with exactly this email address.
- Relation type
statustext - Only customers, prospects, suspects or relations with none.One of:
C(Customer),P(Prospect),S(Suspect),A(None). - Suppliers only
suppliers_onlytrue/false - Only relations that are suppliers.
- Changed since
modified_sincedate - Only relations changed on or after this day.
- Maximum results
limitnumber - How many to return, 1 to 300. Defaults to 60.From 1 to 300.
Outputs
accountslist- The relations
countnumber- How many were returned
Example output
{
"accounts": [
{
"AddressLine1": "Molengraaffsingel 33",
"Blocked": false,
"City": "Delft",
"Code": " 1001",
"Country": "NL",
"Created": "2026-11-18T09:34:00Z",
"Email": "info@clearwater.example",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"IsSales": true,
"IsSupplier": false,
"Modified": "2026-11-18T09:34:00Z",
"Name": "Clearwater BV",
"Phone": "+31 20 123 4567",
"Postcode": "2629 JD",
"Status": "C",
"VATNumber": "NL001234567B01",
"Website": "https://clearwater.example"
}
],
"count": 1
}List sales invoices
List sales invoices, filtered by status, customer or invoice date.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Status
statustext - Only draft, open or processed invoices.One of:
10(Draft),20(Open),50(Processed). - Customer
account_idtext - Only invoices for this customer.
- From date
from_datedate - Only invoices dated on or after this day.
- To date
to_datedate - Only invoices dated on or before this day.
- Maximum results
limitnumber - How many to return, 1 to 300. Defaults to 60.From 1 to 300.
Outputs
countnumber- How many were returned
invoiceslist- The sales invoices
Example output
{
"count": 1,
"invoices": [
{
"AmountDC": 121.0,
"AmountFC": 121.0,
"Created": "2026-11-18T09:34:00Z",
"Currency": "EUR",
"Description": "November consulting",
"DueDate": "2026-11-18T09:34:00Z",
"InvoiceDate": "2026-11-18T09:34:00Z",
"InvoiceID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"InvoiceNumber": 26700001,
"InvoiceTo": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"InvoiceToName": "Clearwater BV",
"Journal": "70",
"Modified": "2026-11-18T09:34:00Z",
"OrderedBy": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"OrderedByName": "Clearwater BV",
"PaymentCondition": "30",
"Status": 20,
"StatusDescription": "Open",
"VATAmountDC": 21.0,
"YourRef": "PO-4711"
}
]
}List VAT codes
List the division's VAT codes and rates.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
Outputs
countnumber- How many were returned
vat_codeslist- The VAT codes
Example output
{
"count": 1,
"vat_codes": [
{
"Code": "2",
"Description": "VAT 21%",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"IsBlocked": false,
"Percentage": 0.21,
"Type": "E",
"VATTransactionType": "B"
}
]
}Process and send sales invoice
Make a sales invoice final, create its document and optionally email it to the customer. It can't be changed or deleted afterwards.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Invoice ID
invoice_idtextRequired - The sales invoice's ID (InvoiceID), from 'List sales invoices' or an earlier step.
- Email it to the customer
email_customertrue/false - Turn on to email the invoice to the customer; off only creates the document.
- Sender email
sender_emailtext - The address it is sent from. Defaults to the company's.
- Extra text
extra_texttext - Text added to the document and the email.
Outputs
resultobject- What Exact Online did
Example output
{
"result": {
"Document": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"DocumentCreationError": "",
"DocumentCreationSuccess": "Document created",
"EmailCreationError": "",
"EmailCreationSuccess": "Email sent",
"InvoiceID": "dd0273aa-67bc-410b-9321-f27c40af22a9"
}
}Update relation
Change a relation. Only the fields you fill in change.
Inputs
- Division
divisiontext - The company in Exact Online to work in. Leave empty for your current one.
- Relation
account_idtextRequired - The relation (customer, supplier or prospect). Pick one, or use an ID from an earlier step.
- Name
nametext - The relation's name. Leave empty to keep it.
- Code
codetext - Your own numeric code for the relation. Exact Online gives the next one if empty. Leave empty to keep it.
- Relation type
statustext - Customer, prospect, suspect or none. Leave empty to keep it.One of:
C(Customer),P(Prospect),S(Suspect),A(None). - Supplier
is_suppliertrue/false - Turn on when it is also a supplier. Leave empty to keep it.
- Email
emailtext - Its email address. Leave empty to keep it.
- Phone
phonetext - Its phone number. Leave empty to keep it.
- Address
address_line1text - Visit address, first line. Leave empty to keep it.
- City
citytext - Visit address city. Leave empty to keep it.
- Postcode
postcodetext - Visit address postcode. Leave empty to keep it.
- Country
countrytext - Two-letter country code, such as NL. Leave empty to keep it.
- Website
websitetext - Its website. Leave empty to keep it.
- VAT number
vat_numbertext - Its VAT number. Leave empty to keep it.
- Chamber of commerce number
chamber_of_commercetext - Its chamber of commerce number. Leave empty to keep it.
- Remarks
remarkstext - Remarks about the relation. Leave empty to keep it.
Outputs
accountobject- The relation (customer, supplier or prospect)
Example output
{
"account": {
"AddressLine1": "Molengraaffsingel 33",
"Blocked": false,
"City": "Delft",
"Code": " 1001",
"Country": "NL",
"Created": "2026-11-18T09:34:00Z",
"Email": "info@clearwater.example",
"ID": "dd0273aa-67bc-410b-9321-f27c40af22a9",
"IsSales": true,
"IsSupplier": false,
"Modified": "2026-11-18T09:34:00Z",
"Name": "Clearwater BV",
"Phone": "+31 20 123 4567",
"Postcode": "2629 JD",
"Status": "C",
"VATNumber": "NL001234567B01",
"Website": "https://clearwater.example"
}
}