TRANXACT.AI Help

Accounting · Travel & Expense

Expense Lines

A line that needed a receipt and has none is the commonest reason a claim is queried, so the board says so on the face of it.

Type REST6 operationsBase path /api/accounting/expense-linesPublished as /api/v1/expense-lines

Download specification (OpenAPI 3.1) Screen: Expense Lines

Overview

PackageAccounting
AuthenticationBearer token: a service account's token (POST /api/auth/service-token) or, for the published path, an API key
AuthorizationThe caller's roles must hold Accounting › Expense Lines on the Roles screen: display for GET, add for POST, change for PUT, delete for DELETE; an action needs the grant of the button that runs it on the screen.
Tablescm.expense_lines · kept per company (and organisational unit where it has one)
RecordCreated, changed and (where the screen allows) deleted; key id
RulesThe same as the screen: validation, numbering, approvals, posting, the company the caller belongs to, and the audit trail.

API reference

6 operations. Open one for its parameters, bodies, responses and a sample request.

GET/api/accounting/expense-linesList expense lines

Query parameters

NameDescriptionExample
limitRows per page (50 by default, at most 200)limit=100
offsetRows to skipoffset=200
qFree-text search over the search columnsq=acme
sortcolumn:asc or column:desc, several separated by commassort=created_at:desc
filterA JSON condition or group (see the filter language), URL-encoded; any field below can be filtered and sortedfilter={"col":"status","op":"eq","value":"open"}
<field>=<value>Shorthand for "field is value" 

Response 200

{
  "rows": [
    {
      "id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
      "report_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
      "line_no": 10,
      "expense_date": "2026-10-30",
      "expense_type": "text",
      "description": "text",
      "merchant": "text",
      "amount": "1250.00",
      "currency": "USD",
      "exchange_rate": "1250.00",
      "base_amount": "1250.00",
      "is_billable": true,
      "is_company_paid": true,
      "card_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73"
    }
  ],
  "count": 1
}

Sample request

curl "https://demo.tranxact.ai/api/accounting/expense-lines?limit=20" \
  -H "Authorization: Bearer $TOKEN"
GET/api/accounting/expense-lines/{id}Read one expense line

Path parameters

NameTypeDescription
idstring (uuid)The record's id, as a list returns it.

Response 200

{
  "id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
  "report_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
  "line_no": 10,
  "expense_date": "2026-10-30",
  "expense_type": "text",
  "description": "text",
  "merchant": "text",
  "amount": "1250.00",
  "currency": "USD",
  "exchange_rate": "1250.00",
  "base_amount": "1250.00",
  "is_billable": true,
  "is_company_paid": true,
  "card_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73"
}

404 when no record with that id is visible to the caller.

Sample request

curl "https://demo.tranxact.ai/api/accounting/expense-lines/3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73" \
  -H "Authorization: Bearer $TOKEN"
POST/api/accounting/expense-linesCreate a expense line

Request body

The record as JSON. Fields marked Yes are required.

FieldTypeRequiredDescription
report_iduuidYesClaim
line_nointegerYesLine
expense_datedateYesDate
expense_typetextYesCategory — The free-text category Supply Chain has always used. Pick the master below as well and the accounting and tax treatment follow from it.
descriptiontextNoDescription
merchanttextNoMerchant
amountnumericYesAmount
currencytextNoCurrency
exchange_ratenumericNoExchange rate
is_billablebooleanNoBillable
has_receiptbooleanNoReceipt attached
receipt_reftextNoReceipt reference
gl_account_iduuidNoAccount
cost_center_iduuidNoCost center
expense_type_iduuidNoExpense type
citytextNoCity
countrytextNoCountry
tax_amountnumericNoTax
tax_code_iduuidNoTax code
reclaimable_taxnumericNoRecoverable tax
quantitynumericNoQuantity
ratenumericNoRate
distancenumericNoDistance
distance_unittextNoDistance unit
Allowed: km mile
nightsintegerNoNights
attendeesintegerNoAttendees
attendee_namestextNoAttendee names — Entertainment without the attendees named is not deductible.
project_iduuidNoProject
wbs_element_iduuidNoWork breakdown element
account_iduuidNoCustomer
is_personalbooleanNoPersonal — not claimed
payment_methodtextNoPaid by — A corporate-card line reimburses nobody: the company has already paid it.
Allowed: personal corporate_card company_paid cash_advance central_billing
card_transaction_iduuidNoCard charge
booking_iduuidNoBooking
receipt_iduuidNoReceipt
justificationtextNoJustification

Sample body

{
  "report_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
  "line_no": 10,
  "expense_date": "2026-10-30",
  "expense_type": "text",
  "amount": "1250.00",
  "description": "text",
  "merchant": "text",
  "currency": "USD"
}

Response 201

{
  "id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
  "report_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
  "line_no": 10,
  "expense_date": "2026-10-30",
  "expense_type": "text",
  "description": "text",
  "merchant": "text",
  "amount": "1250.00",
  "currency": "USD",
  "exchange_rate": "1250.00",
  "base_amount": "1250.00",
  "is_billable": true,
  "is_company_paid": true,
  "card_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73"
}

Sample request

curl -X POST "https://demo.tranxact.ai/api/accounting/expense-lines" \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"report_id":"3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73","line_no":10,"expense_date":"2026-10-30","expense_type":"text","amount":"1250.00","description":"text","merchant":"text","currency":"USD"}'
PUT/api/accounting/expense-lines/{id}Change a expense line

Path parameters

NameTypeDescription
idstring (uuid)The record's id, as a list returns it.

Request body

Only the fields to change; fields left out keep their value.

FieldTypeRequiredDescription
report_iduuidYesClaim
line_nointegerYesLine
expense_datedateYesDate
expense_typetextYesCategory — The free-text category Supply Chain has always used. Pick the master below as well and the accounting and tax treatment follow from it.
descriptiontextNoDescription
merchanttextNoMerchant
amountnumericYesAmount
currencytextNoCurrency
exchange_ratenumericNoExchange rate
is_billablebooleanNoBillable
has_receiptbooleanNoReceipt attached
receipt_reftextNoReceipt reference
gl_account_iduuidNoAccount
cost_center_iduuidNoCost center
expense_type_iduuidNoExpense type
citytextNoCity
countrytextNoCountry
tax_amountnumericNoTax
tax_code_iduuidNoTax code
reclaimable_taxnumericNoRecoverable tax
quantitynumericNoQuantity
ratenumericNoRate
distancenumericNoDistance
distance_unittextNoDistance unit
Allowed: km mile
nightsintegerNoNights
attendeesintegerNoAttendees
attendee_namestextNoAttendee names — Entertainment without the attendees named is not deductible.
project_iduuidNoProject
wbs_element_iduuidNoWork breakdown element
account_iduuidNoCustomer
is_personalbooleanNoPersonal — not claimed
payment_methodtextNoPaid by — A corporate-card line reimburses nobody: the company has already paid it.
Allowed: personal corporate_card company_paid cash_advance central_billing
card_transaction_iduuidNoCard charge
booking_iduuidNoBooking
receipt_iduuidNoReceipt
justificationtextNoJustification

Sample body

{
  "report_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
  "line_no": 10
}

Response 200

{
  "id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
  "report_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73",
  "line_no": 10,
  "expense_date": "2026-10-30",
  "expense_type": "text",
  "description": "text",
  "merchant": "text",
  "amount": "1250.00",
  "currency": "USD",
  "exchange_rate": "1250.00",
  "base_amount": "1250.00",
  "is_billable": true,
  "is_company_paid": true,
  "card_id": "3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73"
}

Sample request

curl -X PUT "https://demo.tranxact.ai/api/accounting/expense-lines/3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73" \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"report_id":"3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73","line_no":10}'
DELETE/api/accounting/expense-lines/{id}Delete a expense line

Path parameters

NameTypeDescription
idstring (uuid)The record's id, as a list returns it.

Response 200

{ "deleted": true }

Many documents are cancelled or reversed instead; the API refuses a delete the screen would refuse.

Sample request

curl -X DELETE "https://demo.tranxact.ai/api/accounting/expense-lines/3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73" \
  -H "Authorization: Bearer $TOKEN"
POST/api/accounting/expense-lines/{id}/copyCopy

Path parameters

NameTypeDescription
idstring (uuid)The record's id, as a list returns it.

Request body

The keys this action reads (* = required; "one of" lists the only values):

overrides, preview, withLines

Response

200 or 201 with the record or result as JSON; a refusal is 409 or 422 with a sentence saying why.

Sample request

curl -X POST "https://demo.tranxact.ai/api/accounting/expense-lines/3f1c2a9e-5b7d-4c1e-9a2f-0d4b8e6c1a73/copy" \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"overrides":"value","preview":"value","withLines":"value"}'

Data model

Every field of a expense line, as the API returns it. Field names are the JSON keys; any of them can be filtered and sorted on a list.

FieldTypeAccessDescription
iduuidread onlyId
report_iduuidread, writeClaim
line_nointegerread, writeLine
expense_datedateread, writeDate
expense_typetextread, writeCategory — The free-text category Supply Chain has always used. Pick the master below as well and the accounting and tax treatment follow from it.
descriptiontextread, writeDescription
merchanttextread, writeMerchant
amountnumericread, writeAmount
currencytextread, writeCurrency
exchange_ratenumericread, writeExchange rate
base_amountnumericread onlyBase amount
is_billablebooleanread, writeBillable
is_company_paidbooleanread onlyIs company paid
card_iduuidread onlyCard id
has_receiptbooleanread, writeReceipt attached
receipt_reftextread, writeReceipt reference
gl_account_iduuidread, writeAccount
cost_center_iduuidread, writeCost center
policy_iduuidread onlyPolicy id
violationtextread onlyViolation
violation_severitytextread onlyViolation severity
org_iduuidread onlyOrg id
org_unit_iduuidread onlyOrg unit id
expense_type_iduuidread, writeExpense type
citytextread, writeCity
countrytextread, writeCountry
tax_amountnumericread, writeTax
tax_code_iduuidread, writeTax code
reclaimable_taxnumericread, writeRecoverable tax
quantitynumericread, writeQuantity
ratenumericread, writeRate
distancenumericread, writeDistance
distance_unittextread, writeDistance unit
Allowed: km mile
nightsintegerread, writeNights
attendeesintegerread, writeAttendees
attendee_namestextread, writeAttendee names — Entertainment without the attendees named is not deductible.
project_iduuidread, writeProject
wbs_element_iduuidread, writeWork breakdown element
account_iduuidread, writeCustomer
is_billedbooleanread onlyIs billed
is_personalbooleanread, writePersonal — not claimed
is_taxable_benefitbooleanread onlyIs taxable benefit
payment_methodtextread, writePaid by — A corporate-card line reimburses nobody: the company has already paid it.
Allowed: personal corporate_card company_paid cash_advance central_billing
card_transaction_iduuidread, writeCard charge
booking_iduuidread, writeBooking
receipt_iduuidread, writeReceipt
approved_amountnumericread onlyApproved amount
adjustment_reasontextread onlyAdjustment reason
statustextread onlyStatus
policy_violationsjsonbread onlyPolicy violations
justificationtextread, writeJustification
xf_text_1textread onlyXf text 1
xf_text_2textread onlyXf text 2
xf_text_3textread onlyXf text 3
xf_text_4textread onlyXf text 4
xf_text_5textread onlyXf text 5
xf_num_1numericread onlyXf num 1
xf_num_2numericread onlyXf num 2
xf_num_3numericread onlyXf num 3
xf_date_1dateread onlyXf date 1
xf_date_2dateread onlyXf date 2
created_attimestamp with time zoneread onlyCreated at
created_byuuidread onlyCreated by
updated_attimestamp with time zoneread onlyUpdated at
updated_byuuidread onlyUpdated by
fund_iduuidread onlyFund id
grant_iduuidread onlyGrant id
program_iduuidread onlyProgram id
function_iduuidread onlyFunction id
derivation_tracejsonbread onlyDerivation trace

Errors

StatusMeaning
400The request could not be read: a filter that is not JSON, a bad parameter
401No credential, or it is wrong, revoked or expired
403The caller's roles do not hold Accounting › Expense Lines for this verb, or the address or origin is not allowed
404No record with that id is visible to the caller
409A conflict: a duplicate number, a document in a state that does not allow it, or a record changed or locked by someone else
422Refused by the same validation as the screen; the error names the field and why

Every error is JSON: {"error": "a sentence saying what was wrong"}, with field where it applies.