Lodol Docs

Expensify

API actions for the Expensify integration.

Expensify

Automate expense reports and policy management in Expensify.


Create Expensify policy

Create a new Expensify workspace/policy.

Parameters

ParameterTypeRequiredDescription
policy_namestringYesName for the new workspace/policy.

Response

{
  "policyID": "NEW123POLICY"
}

Export expense reports

Export expense reports from Expensify with flexible filters. Each report includes its expenses, with amounts in dollars (not cents).

Parameters

ParameterTypeRequiredDescription
start_datestringNoStart date for the export range (YYYY-MM-DD). Required unless you provide a list of report IDs.
end_datestringNoEnd date for the export range (YYYY-MM-DD). Date range cannot exceed one year.
report_id_liststringNoReport IDs to export, separated by commas. Required unless you provide a start date. You can find report IDs in the results of an earlier 'Export expense reports' action.
report_statestringNoOptional. Only include reports with this status.
policy_idstringNoOnly include reports from this policy (workspace). You can get the ID from the 'List Expensify policies' or 'Create Expensify policy' actions.
limitnumberNoMaximum number of reports to export.

Response

[
  {
    "currency": "USD",
    "expenses": [
      {
        "amount": 350.0,
        "category": "Travel",
        "date": "2024-03-15",
        "merchant": "Delta Airlines",
        "transactionID": "T001"
      }
    ],
    "policyName": "Default Policy",
    "reportID": "R00abc123",
    "reportName": "March Travel",
    "status": "Approved",
    "submitter": "user@example.com",
    "total": 450.75
  }
]

List Expensify policies

List all policies (workspaces) your Expensify account has access to.

Parameters

ParameterTypeRequiredDescription
admin_onlybooleanNoSet to true to only include policies where you are an admin.

Response

[
  {
    "id": "ABC123DEF456",
    "name": "Engineering Team",
    "role": "admin",
    "type": "corporate"
  }
]

Mark reports as reimbursed

Mark reports as reimbursed. Only Approved reports will be updated; others are skipped. You can get report IDs from the 'Export expense reports' action.

Parameters

ParameterTypeRequiredDescription
report_id_liststringNoReport IDs to mark as reimbursed, separated by commas. Required unless you provide a start date. You can get report IDs from the 'Export expense reports' action.
start_datestringNoStart date filter (YYYY-MM-DD). Required unless you provide a list of report IDs.
end_datestringNoEnd date filter (YYYY-MM-DD).
payment_sourcestringNoOptional description of the payment source (1-100 characters).

Response

{
  "reportIDsUpdated": [
    "R00abc123",
    "R00def456"
  ]
}

On this page