Dashboard
A simple view of Factorial Coffee's books.
Local mode
Cash flow
Income vs. expenses by month
Expense mix
Where the money is going
Recent transactions
Latest activity
| Date | Description | Category | Type | Amount |
|---|
Roast profitability
Latest production lots
| Date | Description | Category | Source | Receipt | Amount |
|---|
| Lot | Origin / Coffee | Process | Purchased | Remaining | Landed $/lb | Value |
|---|
| Date | Roast / Coffee | Green | Roasted | Yield | Cost | Revenue | Profit |
|---|
Sales tax detail
Bookkeeping aid only; verify filings with your tax professional.
| Date | Description | Taxable sale | Tax collected |
|---|
| Date | Purpose | From | To | Miles |
|---|
Profit & Loss
Summary for selected date range
Total revenue$0.00
Cost of goods sold$0.00
Gross profit$0.00
Operating expenses$0.00
Net profit$0.00
Category summary
Expenses grouped for review
Monthly summary
Revenue, expenses, and profit
| Month | Revenue | Expenses | Profit |
|---|
Square
Import Square CSV exports now. Live API sync is server-ready but requires Square credentials and a secure backend.
Not connectedSquarespace
Import order CSVs and automatically classify product sales, shipping, tax, and fees where available.
Not connectedBank / Credit Card
Import statement CSVs. Debit/negative amounts become expenses; credits/positive amounts become income.
CSV readyCloud & Login
This build includes a Supabase-ready schema and configuration hook. Local mode remains the default until a project is configured.
Local modeImport activity
Recent imported batches and duplicate protection.
| Date | Source | File | Imported | Skipped |
|---|
Generic transaction CSV
Use your original Factorial format: date,type,description,category,amount plus optional source,taxable,tax,reference,notes.
Business settings
Used for estimates and reports.
Data tools
Back up or move bookkeeping data.
Cloud account
Encrypted-in-transit Supabase connection with database RLS and private receipt storage.
StatusLocal mode
Only the Supabase project URL and publishable/anon key belong in config.js. Never place service-role, Square, Squarespace, or bank secrets in browser code.