Expensify Lite
Expensify is an expense management tool for personal and business use.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | EXPENSE and POLICY tables. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Expensify setup guide to connect Expensify with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the REPORT, REPORT_ACTION_LIST, REPORT_APPROVER, EXPENSE, and EXPENSE_ATTENDEE tables.
To capture updates and deletes, we re-import the EXPENSE and EXPENSE_ATTENDEE tables once a week.
We also re-import the POLICY table and its child tables during every sync to capture updates and deletes.
Schema information
This schema applies to all Expensify connectors.
Explore Expensify schema ERD