All projects
ENVOYS / Business operations

Field Expense Reconciliation Desk

Recon Desk is where ENVOYS field staff and HQ reconcile what they spend on school trips in 32 countries. Built on Softr and Airtable with Vibe Coding, it splits card charges, program cash and personal funds across programs and accounting categories, in local currency and with receipts. The team edits its own options, categories and screens.

SoftrAirtableVibe Coding
Field Expense Reconciliation Desk project overview

The challenge

ENVOYS runs school trips in 32 countries, and its field staff pay for hotels, buses, meals and activities with company cards, program cash and sometimes their own money, in whatever currency the destination uses. Finance needs every one of those charges tied to a program and an accounting category, with a receipt, before a program can close. The process lived in a legacy custom-coded tool, and even adding an option to a dropdown meant calling a developer.

What we built

A reconciliation desk for field staff, HQ and administrators: card charges, program cash and personal funds split across programs and accounting categories in local currency, with receipts, batch reconciliation and transfers, on tables and screens the ENVOYS team changes on its own.

About the project

ENVOYS is an educational travel company and Public Benefit Corporation that has run programs for more than 12,000 students across 32 countries. On every program, field staff pay for hotels, buses, meals and activities with company cards, program cash and sometimes their own money, in the local currency. Finance needs each of those charges tied to a program and an accounting category, with a receipt, before the program can close. That process lived in a legacy custom-coded tool, where even adding an option to a dropdown meant calling a developer. Base Flows rebuilt it as Recon Desk, on Softr and ENVOYS's own Airtable base. Each staff member signs in to the card charges imported from their statements, plus any transferred to them, with a running count of what is still pending. Every expense can be split into as many allocations as it needs, each with a program, an accounting category and a receipt, or a clear flag when there is no receipt, and its status moves from pending to partial to completed on its own. Money in the field does not only move through cards. Staff register the Field Cash they received for a program in USD and in local currency, and the exchange rate is calculated from the cash they actually got, not a market rate. Personal funds are registered the same way. Both then go through the same reconciliation as card charges, so they match the bank statements later without being counted twice. The interface is built with Vibe Coding and adapts to each role. Field staff can reconcile a group of small expenses in one step or transfer a charge to the person it belongs to. HQ classifies each card expense as an HQ Office or a Program Related expense and gets the categories that fit, and administrators see every expense across the team in one list. The team owns it. People, programs, currencies and the chart of accounts, including which categories each type of expense can use, are tables ENVOYS edits directly, and the screens change the same way. Adding an option no longer means a developer ticket, and expenses that finance has already reviewed drop out of the queue on their own.

What changed

  • 0 Developer tickets to add an option, a category or a currency
    People, programs, currencies and the chart of accounts are tables the team edits
  • 3 Funding sources reconciled in one place
    Company cards, program cash and personal funds
  • 3 Roles with their own view
    Field Staff, HQ and Administrators

More work in motion.

All projects
01 / NonprofitClient portal
Multilingual Creative Submissions Portal built by Base Flows

Instituto Fe y Vida

Multilingual Creative Submissions Portal

Nuestras Raíces is Instituto Fe y Vida's platform for young Latino Catholics to share writing, visual art and music. Built on Softr in 10 weeks, it pairs a public site in four languages with a guided submission flow, e-signed releases, an admin review workspace and a gated, weighted judging process.

01 / Sports & EntertainmentClient portal
Player Family Services Portal built by Base Flows

NBA franchise

Player Family Services Portal

A family services portal for an NBA franchise. Player and staff families request arena credentials, parking, hotels, flights and car service in one guided flow and follow each request in its own thread. Family services runs approvals and the season from a command centre, and a tablet desk checks families in on game night.

Your move

Goodbye,
busywork.

Your next chapter starts with a better way to work.

Book a
discovery call