Back to Systems Portfolio
MVP liveOperationsPrivate system

Community Ledger

Replaces the spreadsheets, email threads, and paper forms that organizers use to manage vendors, documents, invoices, and payments.

Primary outcome

Gives organizers one place to see who applied, who paid, who is missing paperwork, and what needs attention — without digging through spreadsheets.

What the operator can do

Open the vendor list and immediately see who is paid, who has missing documents, and who needs a follow-up — then act from that same screen without switching to email or a spreadsheet.

Product evidence

What the system looks like

Real screenshots are used for public systems. Private systems use clear system posters until approved screenshots are available.

System poster
System poster

Community Ledger

Vendor billing desk

Adminmvp-live
VendorsInvoicesDocumentsChecks
ActionUpload LinksStripe BaseCheck Tracking
ApplyReviewInvoiceClear
Upload LinksStripe BaseCheck TrackingRenewalsLocal MVP with seeded demo data
Mobile

Vendor billing desk

  1. 1Upload Links
  2. 2Stripe Base
  3. 3Check Tracking
  4. 4Renewals

Local MVP with seeded demo data

Problem

Community organizers often manage vendor applications, paperwork, payment status, checks, and event notes across spreadsheets, email, and memory.

Solution

A focused vendor billing desk with application intake, vendor profiles, invoice creation, manual check tracking, document review, upload links, and Stripe webhook support.

Impact

Gives organizers a calmer way to know who applied, who owes money, who is missing paperwork, and what needs attention next.

Before this existed

What this system replaced

What it replaced

  • Spreadsheets for tracking vendor payment status and who still owes money
  • Email threads for collecting, following up on, and reviewing required documents
  • Manual records for logging checks received, deposited, and reconciled
  • Paper application forms and informal notes about vendor renewals

What it actually is

A closer look at the system

Community Ledger is a vendor billing desk for organizers — markets, churches, vendor fairs, community programs. It replaces the usual mix of spreadsheets, paper forms, and ad-hoc email threads with one admin surface where the organizer can see who applied, who paid, who owes money, what paperwork is missing, and what needs attention this week. The MVP includes vendor application intake, vendor profiles, invoices, manual check tracking, document review, secure upload links, and a Stripe webhook foundation for organizers that want to take card payments.

Operator view

What it feels like to use

An organizer opens the Ledger admin and immediately sees a vendor list with payment status, document status, and any flags. They can open a vendor to see invoices, payments, uploads, and notes; create a new invoice; mark a manual check received; send a secure upload link; or generate a renewal. They do not have to dig through a spreadsheet to know who is missing what.

Inside the admin

What the operator side of this system can actually do

Private demo available

Vendor list with payment status, document status, and quick filters.

Vendor profile that combines invoices, payments, documents, and notes in one place.

Manual check tracking for organizers who get paid by mail.

Secure upload links for documents like insurance, permits, and agreements.

Recurring fee schedules for repeat market days or program seasons.

Stripe webhook foundation so card payments can post automatically when enabled.

Document checklist review so paperwork gaps are visible without hunting through email.

MVP uses seeded demo vendor data. Public-safe screenshots will be added when an organizer pilot approves them for display.

How it works

The workflow from end to end

Workflow steps

  1. 01Vendor applies through the public application intake.
  2. 02Organizer reviews the application and approves or requests more info.
  3. 03Vendor profile is created with their required document checklist.
  4. 04Organizer issues an invoice or fee schedule; payment status is tracked.
  5. 05Vendor uploads required documents through a secure link.
  6. 06Organizer marks documents reviewed and the vendor as ready for the event.
  7. 07Recurring fees auto-roll for the next event window if configured.

Under the hood

System modules and current build status

System modules

Labels show what is actually built today versus in progress or planned.

  • Vendor application intakeBuilt

    Public form that captures the data needed to create a vendor profile and required document list.

  • Vendor profile workspaceBuilt

    Combined view of invoices, payments, documents, notes, and history.

  • Manual check trackingBuilt

    Workflow for marking checks received, deposited, and reconciled without forcing online payment.

  • Document review workflowBuilt

    Checklist of required documents per vendor, with review and expiration tracking.

  • Stripe webhook foundationBuilt

    Webhook handler ready to post Stripe payment events against the right vendor invoice.

  • Real organizer pilotIn progress

    Validate the workflow end-to-end with a real organizer before expanding features.

Where it fits

Business use cases this pattern fits

Use cases

  • Weekly farmers market with a rotating vendor roster.
  • Church or community vendor fair with one-time fees and document requirements.
  • Seasonal program (camps, classes, art series) with recurring vendor or instructor billing.
  • Community organizer who has outgrown a spreadsheet but does not need full accounting software.

Capabilities

  • vendor application intake
  • invoice and check payment tracking
  • document checklist review
  • secure upload links
  • recurring fee schedules
  • Stripe webhook foundation

Proof points

  • local MVP app
  • seeded demo vendor data
  • admin billing desk routes
  • document review workflow

What it proves

  • A small custom system can remove a lot of administrative drag for community operators.
  • Billing and paperwork tools do not need to become a full accounting platform to be useful.

Next milestones

  • approve public-safe demo screenshots
  • validate with a real organizer workflow
  • document reminder and email copy boundaries
Next.jsTypeScriptPrismaPostgreSQLStripeZod

Could this work for you?

How this pattern applies to other businesses

Any organizer running a weekly market, vendor fair, seasonal program, or community event with recurring vendors and document requirements.

Build an operations desk

Want a system shaped around your workflow?

If your team is juggling spreadsheets, forms, follow-up, content, billing, or customer context across too many places, Flowdrive can help turn it into a practical tool.

Build an operations desk
Custom dashboardAI workflowAutomation map