How to Integrate Replit with Expensify

1import os
2import json
3import requests
4from urllib.parse import urlencode
5
6USER_ID = os.environ["EXPENSIFY_USER_ID"]
7USER_SECRET = os.environ["EXPENSIFY_USER_SECRET"]
8
9API_URL = "https://integrations.expensify.com/Integration-Server/ExpensifyIntegrations"
10
11
12def expensify_request(job_description: dict) -> dict:
13    """Make a request to the Expensify Integration Server."""
14    job_description["credentials"] = {
15        "partnerUserID": USER_ID,
16        "partnerUserSecret": USER_SECRET
17    }
18    payload = urlencode({"requestJobDescription": json.dumps(job_description)})
19    resp = requests.post(
20        API_URL,
21        data=payload,
22        headers={"Content-Type": "application/x-www-form-urlencoded"}
23    )
24    resp.raise_for_status()
25    return resp.json()
26
27
28def create_expense(employee_email: str, merchant: str, amount_cents: int,
29                   currency: str, date: str, category: str = "") -> dict:
30    """Create a single expense for an employee. Amount is in cents (e.g. 2500 = $25.00)."""
31    job = {
32        "type": "create",
33        "dry-run": False,
34        "employeeEmail": employee_email,
35        "transactionList": [
36            {
37                "created": date,  # YYYY-MM-DD
38                "currency": currency,
39                "merchant": merchant,
40                "amount": amount_cents,
41                "category": category,
42                "comment": f"Created via Replit API integration"
43            }
44        ]
45    }
46    return expensify_request(job)
47
48
49def get_report_list(employee_email: str, status_filter: str = "OPEN") -> dict:
50    """Get expense reports for an employee. status_filter: OPEN, SUBMITTED, APPROVED, REIMBURSED."""
51    job = {
52        "type": "get",
53        "employeeEmail": employee_email,
54        "reportState": status_filter,
55        "limit": "20"
56    }
57    return expensify_request(job)
58
59
60def export_report_csv(report_id_list: list) -> str:
61    """Export specific reports to CSV. Returns CSV string."""
62    job = {
63        "type": "download",
64        "onReceive": {"immediateResponse": ["returnRandomFileName"]},
65        "inputSettings": {
66            "type": "combinedReportData",
67            "filters": {
68                "reportIDList": ",".join(report_id_list)
69            }
70        },
71        "outputSettings": {"fileExtension": "csv"}
72    }
73    result = expensify_request(job)
74    # If async, result contains a jobID — poll for completion
75    if "jobID" in result:
76        print(f"Export queued with jobID: {result['jobID']}")
77        print("Poll for results: add jobID to a subsequent get request")
78    return result
79
80
81if __name__ == "__main__":
82    # Create a test expense
83    result = create_expense(
84        employee_email="employee@yourcompany.com",
85        merchant="Office Depot",
86        amount_cents=4599,  # $45.99
87        currency="USD",
88        date="2026-03-15",
89        category="Office Supplies"
90    )
91    print("Create expense result:", result)
92
93    # Get open reports for the employee
94    reports = get_report_list("employee@yourcompany.com", status_filter="OPEN")
95    print("Open reports:", reports)

1const express = require('express');
2const axios = require('axios');
3const qs = require('qs');
4
5const app = express();
6app.use(express.json());
7
8const USER_ID = process.env.EXPENSIFY_USER_ID;
9const USER_SECRET = process.env.EXPENSIFY_USER_SECRET;
10const API_URL = 'https://integrations.expensify.com/Integration-Server/ExpensifyIntegrations';
11
12async function expensifyRequest(jobDescription) {
13  jobDescription.credentials = {
14    partnerUserID: USER_ID,
15    partnerUserSecret: USER_SECRET
16  };
17  const payload = qs.stringify({
18    requestJobDescription: JSON.stringify(jobDescription)
19  });
20  const { data } = await axios.post(API_URL, payload, {
21    headers: { 'Content-Type': 'application/x-www-form-urlencoded' }
22  });
23  return data;
24}
25
26// Create an expense
27app.post('/expense', async (req, res) => {
28  const { employee_email, merchant, amount_cents, currency, date, category } = req.body;
29  if (!employee_email || !merchant || !amount_cents) {
30    return res.status(400).json({ error: 'employee_email, merchant, and amount_cents are required' });
31  }
32  try {
33    const result = await expensifyRequest({
34      type: 'create',
35      'dry-run': false,
36      employeeEmail: employee_email,
37      transactionList: [{
38        created: date || new Date().toISOString().split('T')[0],
39        currency: currency || 'USD',
40        merchant,
41        amount: amount_cents,
42        category: category || '',
43        comment: 'Created via Replit API integration'
44      }]
45    });
46    res.json(result);
47  } catch (err) {
48    console.error('Create expense error:', err.message);
49    res.status(500).json({ error: err.message });
50  }
51});
52
53// Get reports for an employee
54app.get('/reports', async (req, res) => {
55  const { email, status = 'OPEN' } = req.query;
56  if (!email) return res.status(400).json({ error: 'email query param required' });
57  try {
58    const result = await expensifyRequest({
59      type: 'get',
60      employeeEmail: email,
61      reportState: status,
62      limit: '20'
63    });
64    res.json(result);
65  } catch (err) {
66    console.error('Get reports error:', err.message);
67    res.status(500).json({ error: err.message });
68  }
69});
70
71app.listen(3000, '0.0.0.0', () => {
72  console.log('Expensify integration server running on port 3000');
73});