Skip to main content
GET
/
finops
/
v1
/
payables
Get payables
curl --request GET \
  --url https://api.sandbox.tesouro.com/finops/v1/payables \
  --header 'Authorization: Bearer <token>' \
  --header 'x-finops-version: <x-finops-version>' \
  --header 'x-organization-id: <x-organization-id>'
{
  "data": [
    {
      "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "created_at": "2023-11-07T05:31:56Z",
      "updated_at": "2023-11-07T05:31:56Z",
      "credit_notes": [
        {
          "id": "123e4567-e89b-12d3-a456-426614174000",
          "status": "submitted_for_approval",
          "document_id": "CN-123456",
          "issued_at": "2024-01-15",
          "total_amount": 1000
        }
      ],
      "entity_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "payable_origin": "upload",
      "source_of_payable_data": "ocr",
      "status": "draft",
      "amount_due": 1000,
      "amount_paid": 1000,
      "amount_to_pay": 1000,
      "approval_policy_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "counterpart": {
        "address": {
          "city": "New York",
          "country": "US",
          "line1": "456 Fifth Avenue",
          "line2": "<string>",
          "postal_code": "10001",
          "state": "<string>"
        },
        "bank_account": {
          "account_holder_name": "<string>",
          "account_number": "123456789012",
          "bic": "CHASUS33XXX",
          "iban": "<string>",
          "routing_number": "<string>",
          "sort_code": "<string>"
        },
        "email": "acme@example.com",
        "name": "Acme Inc.",
        "phone": "5551231234",
        "tax_id": "123456789",
        "vat_id": {
          "country": "AF",
          "type": "<string>",
          "value": "<string>"
        }
      },
      "counterpart_address_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "counterpart_bank_account_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "counterpart_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "counterpart_raw_data": {
        "address": {
          "city": "New York",
          "country": "US",
          "line1": "456 Fifth Avenue",
          "line2": "<string>",
          "postal_code": "10001",
          "state": "<string>"
        },
        "bank_account": {
          "account_holder_name": "<string>",
          "account_number": "123456789012",
          "bic": "CHASUS33XXX",
          "iban": "<string>",
          "routing_number": "<string>",
          "sort_code": "<string>"
        },
        "email": "acme@example.com",
        "name": "Acme Inc.",
        "phone": "5551231234",
        "tax_id": "123456789",
        "vat_id": {
          "country": "AF",
          "type": "<string>",
          "value": "<string>"
        }
      },
      "counterpart_vat_id_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "currency": "USD",
      "currency_exchange": {
        "default_currency_code": "<string>",
        "rate": 123,
        "total": 123
      },
      "description": "<string>",
      "discount": 500,
      "document_id": "INV-2287",
      "due_date": "2023-12-25",
      "einvoice_file_url": "https://bucketname.s3.amazonaws.com/12345/67890.xml",
      "enforce_approval_policy_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "file": {
        "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
        "created_at": "2023-11-07T05:31:56Z",
        "file_type": "payables",
        "md5": "31d1a2dd1ad3dfc39be849d70a68dac0",
        "mimetype": "application/pdf",
        "name": "invoice.pdf",
        "region": "eu-central-1",
        "size": 24381,
        "url": "https://bucketname.s3.amazonaws.com/12345/67890.pdf",
        "pages": [],
        "previews": []
      },
      "file_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "issued_at": "2023-12-25",
      "marked_as_paid_by_entity_user_id": "71e8875a-43b3-434f-b12a-54c84c176ef3",
      "marked_as_paid_with_comment": "Was paid partly in the end of the month.",
      "ocr_request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "ocr_status": "processing",
      "other_extracted_data": {
        "counterpart_account_id": "CHASUS33",
        "counterpart_account_number": "<string>",
        "counterpart_address": "<string>",
        "counterpart_address_object": {
          "city": "New York",
          "country": "US",
          "line1": "456 Fifth Avenue",
          "line2": "<string>",
          "original_country_name": "United States",
          "postal_code": "10001",
          "state": "<string>"
        },
        "counterpart_branch_number": "<string>",
        "counterpart_email": "<string>",
        "counterpart_name": "Clacksworth Keyboards",
        "counterpart_routing_number": "<string>",
        "counterpart_vat_id": "123456789",
        "currency": "USD",
        "discount_raw": 123,
        "document_due_date": "<string>",
        "document_id": "CST-13341",
        "document_issued_at_date": "<string>",
        "line_items_raw": [
          {
            "description": "Impact Players : How to Take the Lead , Play Bigger , and Multiply Your",
            "item_adjusted": false,
            "line_item_ocr_id": "<string>",
            "quantity": 1.2,
            "total_excl_vat": 120,
            "total_incl_vat": 135,
            "unit": "meters",
            "unit_price": 100,
            "vat_amount": 15,
            "vat_percentage": 12.5
          }
        ],
        "payment_terms_raw": [
          "<string>"
        ],
        "purchase_order_number": "1234",
        "tax_payer_id": "12345678901",
        "total_excl_vat_raw": 77,
        "total_paid_amount_raw": 50,
        "total_raw": 70,
        "total_vat_amount_raw": 7,
        "total_vat_rate_raw": 12.5,
        "type": "invoice"
      },
      "paid_at": "2023-11-07T05:31:56Z",
      "partner_metadata": {},
      "payment_terms": {
        "name": "<string>",
        "term_final": {
          "number_of_days": 123
        },
        "description": "<string>",
        "term_1": {
          "discount": 123,
          "number_of_days": 123
        },
        "term_2": {
          "discount": 123,
          "number_of_days": 123
        }
      },
      "project_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "purchase_order_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
      "sender": "hello@example.com",
      "subtotal": 1250,
      "suggested_payment_term": {
        "date": "2023-12-25",
        "discount": 5000
      },
      "tags": [
        {
          "id": "ea837e28-509b-4b6a-a600-d54b6aa0b1f5",
          "created_at": "2022-09-07T16:35:18.484507+00:00",
          "updated_at": "2022-09-07T16:35:18.484507+00:00",
          "name": "Marketing",
          "category": "department",
          "created_by_entity_user_id": "ea837e28-509b-4b6a-a600-d54b6aa0b1f5",
          "description": "Tag for the Marketing Department"
        }
      ],
      "tax": 2000,
      "tax_amount": 250,
      "total_amount": 1500,
      "total_amount_with_credit_notes": 123,
      "was_created_by_user_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
    }
  ],
  "next_pagination_token": "<string>",
  "prev_pagination_token": "<string>"
}

Documentation Index

Fetch the complete documentation index at: https://docs.tesouro.com/llms.txt

Use this file to discover all available pages before exploring further.

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Headers

x-finops-version
string<date>
required
x-organization-id
string<uuid>
required

The ID of the entity that owns the requested resource.

Example:

"9d2b4c8f-2087-4738-ba91-7359683c49a4"

Query Parameters

order
enum<string>
default:asc

Sort order (ascending by default). Typically used together with the sort parameter.

Available options:
asc,
desc
limit
integer
default:100

The number of items (0 .. 100) to return in a single page of the response. The response may contain fewer items if it is the last or only page.

Required range: 1 <= x <= 100
pagination_token
string

A pagination token obtained from a previous call to this endpoint. Use it to get the next or previous page of results for your initial query. If pagination_token is specified, all other query parameters are ignored and inferred from the initial query.

If not specified, the first page of results will be returned.

sort
enum<string>

The field to sort the results by. Typically used together with the order parameter.

Available options:
id,
created_at,
issued_at,
due_date
created_at__gt
string<date-time>

Return only payables created in Monite after the specified date and time. The value must be in the ISO 8601 format YYYY-MM-DDThh:mm[:ss[.ffffff]][Z|±hh:mm].

created_at__lt
string<date-time>

Return only payables created in Monite before the specified date and time.

created_at__gte
string<date-time>

Return only payables created in Monite on or after the specified date and time.

created_at__lte
string<date-time>

Return only payables created in Monite before or on the specified date and time.

status
enum<string>

Return only payables that have the specified status.

To query multiple statuses at once, use the status__in parameter instead.

Available options:
draft,
new,
approve_in_progress,
waiting_to_be_paid,
partially_paid,
paid,
canceled,
rejected
status__in
enum<string>[]

Return only payables that have the specified statuses.

To specify multiple statuses, repeat this parameter for each value: status__in=draft&status__in=new

Available options:
draft,
new,
approve_in_progress,
waiting_to_be_paid,
partially_paid,
paid,
canceled,
rejected
id__in
string<uuid>[]

Return only payables with specified IDs. Valid but nonexistent IDs do not raise errors but produce no results.

To specify multiple IDs, repeat this parameter for each value: id__in=<id1>&id__in=<id2>

total_amount
integer

Return only payables with the exact specified total amount. The amount must be specified in the minor units of currency. For example, $12.5 is represented as 1250.

total_amount__gt
integer

Return only payables whose total amount (in minor units) exceeds the specified value.

total_amount__lt
integer

Return only payables whose total amount (in minor units) is less than the specified value.

total_amount__gte
integer

Return only payables whose total amount (in minor units) is greater than or equal to the specified value.

total_amount__lte
integer

Return only payables whose total amount (in minor units) is less than or equal to the specified value.

amount
integer

Return only payables with the specified amount.

amount__gt
integer

Return only payables whose amount (in minor units) exceeds the specified value.

amount__lt
integer

Return only payables whose amount (in minor units) is less than the specified value.

amount__gte
integer

Return only payables whose amount (in minor units) is greater than or equal to the specified value.

amount__lte
integer

Return only payables whose amount (in minor units) is less than or equal to the specified value.

currency
enum<string>

Return only payables that use the specified currency.

Available options:
AED,
AFN,
ALL,
AMD,
ANG,
AOA,
ARS,
AUD,
AWG,
AZN,
BAM,
BBD,
BDT,
BGN,
BHD,
BIF,
BMD,
BND,
BOB,
BRL,
BSD,
BTN,
BWP,
BYN,
BZD,
CAD,
CDF,
CHF,
CLP,
CNY,
COP,
CRC,
CVE,
CZK,
DJF,
DKK,
DOP,
DZD,
EGP,
ETB,
EUR,
FJD,
FKP,
GBP,
GEL,
GHS,
GIP,
GMD,
GNF,
GTQ,
GYD,
HKD,
HNL,
HTG,
HUF,
IDR,
ILS,
INR,
IQD,
ISK,
JMD,
JOD,
JPY,
KES,
KGS,
KHR,
KMF,
KRW,
KWD,
KYD,
KZT,
LAK,
LBP,
LKR,
LRD,
LSL,
LYD,
MAD,
MDL,
MGA,
MKD,
MMK,
MNT,
MOP,
MUR,
MVR,
MWK,
MXN,
MYR,
MZN,
NAD,
NGN,
NIO,
NOK,
NPR,
NZD,
OMR,
PAB,
PEN,
PGK,
PHP,
PKR,
PLN,
PYG,
QAR,
RON,
RSD,
RUB,
RWF,
SAR,
SBD,
SCR,
SEK,
SGD,
SHP,
SLE,
SOS,
SRD,
SSP,
SVC,
SZL,
THB,
TJS,
TMT,
TND,
TOP,
TRY,
TTD,
TWD,
TZS,
UAH,
UGX,
USD,
UYU,
UZS,
VND,
VUV,
WST,
XAF,
XCD,
XOF,
XPF,
YER,
ZAR,
ZMW
counterpart_name
string

Return only payables received from counterparts with the specified name (exact match, case-sensitive).

For counterparts of type = individual, the full name is formatted as first_name last_name.

counterpart_name__contains
string

Return only payables received from counterparts whose name contains the specified string (case-sensitive).

counterpart_name__icontains
string

Return only payables received from counterparts whose name contains the specified string (case-insensitive).

search_text
string

Apply the icontains condition to search for the specified text in the document_id and counterpart_name fields in the payables.

due_date
string<date>

Return payables that are due on the specified date (YYYY-MM-DD)

due_date__gt
string<date>

Return payables that are due after the specified date (exclusive, YYYY-MM-DD).

due_date__lt
string<date>

Return payables that are due before the specified date (exclusive, YYYY-MM-DD).

due_date__gte
string<date>

Return payables that are due on or after the specified date (YYYY-MM-DD).

due_date__lte
string<date>

Return payables that are due before or on the specified date (YYYY-MM-DD).

issued_at
string<date>

Return payables that are issued at the specified date (YYYY-MM-DD)

issued_at__gt
string<date>

Return payables that are issued after the specified date (exclusive, YYYY-MM-DD).

issued_at__lt
string<date>

Return payables that are issued before the specified date (exclusive, YYYY-MM-DD).

issued_at__gte
string<date>

Return payables that are issued on or after the specified date (YYYY-MM-DD).

issued_at__lte
string<date>

Return payables that are issued before or on the specified date (YYYY-MM-DD).

document_id
string

Return a payable with the exact specified document number (case-sensitive).

The document_id is the user-facing document number such as INV-00042, not to be confused with Monite resource IDs (id).

document_id__contains
string

Return only payables whose document number (document_id) contains the specified string (case-sensitive).

document_id__icontains
string

Return only payables whose document number (document_id) contains the specified string (case-insensitive).

was_created_by_user_id
string<uuid>

Return only payables created in Monite by the entity user with the specified ID.

counterpart_id
string<uuid>

Return only payables received from the counterpart with the specified ID.

Counterparts that have been deleted but have associated payables will still return results here because the payables contain a frozen copy of the counterpart data.

If the specified counterpart ID does not exist and never existed, no results are returned.

counterpart_id__in
string<uuid>[]

Return only payables received from the counterparts with the specified IDs. Valid but nonexistent IDs do not raise errors but produce no results.

To specify multiple IDs, repeat this parameter for each value: counterpart_id__in=<id1>&counterpart_id__in=<id2>

source_of_payable_data
enum<string>

Return only payables coming from the specified source.

Available options:
ocr,
user_specified,
einvoicing
ocr_status
enum<string>

Return only payables with specific OCR statuses.

Available options:
processing,
error,
success,
canceled
line_item_id
string<uuid>

Search for a payable by the identifier of the line item associated with it.

purchase_order_id
string<uuid>

Search for a payable by the identifier of the purchase order associated with it.

project_id
string<uuid>

Return only payables assigned to the project with the specified ID.

Valid but nonexistent project IDs do not raise errors but return no results.

project_id__in
string<uuid>[]

Return only payables whose project_id include at least one of the project_id with the specified IDs. Valid but nonexistent project IDs do not raise errors but produce no results.

tag_ids
string<uuid>[]

Return only payables whose tags include at least one of the tags with the specified IDs. Valid but nonexistent tag IDs do not raise errors but produce no results.

tag_ids__not_in
string<uuid>[]

Return only payables whose tags do not include any of the tags with the specified IDs. Valid but nonexistent tag IDs do not raise errors but produce the results.

has_tags
boolean

Filter objects based on whether they have tags. If true, only objects with tags are returned. If false, only objects without tags are returned.

origin
enum<string>

Return only payables from a given origin ['einvoice', 'upload', 'email']

Available options:
upload,
email,
einvoicing
has_file
boolean

Return only payables with or without attachments (files)

Response

Successful Response

A paginated list of payables.

data
object[]
required
next_pagination_token
string

A token that can be sent in the pagination_token query parameter to get the next page of results, or null if there is no next page (i.e. you've reached the last page).

prev_pagination_token
string

A token that can be sent in the pagination_token query parameter to get the previous page of results, or null if there is no previous page (i.e. you've reached the first page).