Business Dashboard
YTD Revenue · 2026
$47,644
Jan – Mar · ▲ 63% vs 2025
Best Month Ever
$20,612
March 2026 · 123 orders
Full Year 2025
$92,695
Net revenue after discounts
Discount Rate · Trend
—
Calculating...
Operating Expenses · 2025
$29,362
Categorized months only
Avg Orders/Month · 2026
117
Jan–Apr 2026 · 466 total
Monthly Net Revenue
After discounts · Jan 2025 – Mar 2026 (QuickBooks)
Expense Breakdown
Jan 2025 – Feb 2026 (categorized)
Revenue vs. Operating Expenses
Monthly comparison · categorized expenses only
Order Volume by Month
Orders placed · Airtable · last 12 months
Monthly P&L Summary
Source: QuickBooks · Jan 2025 – Apr 2026
| Month | Gross Sales | Discounts | Net Revenue | COGS | Op. Expenses | Net Op. Income |
|---|---|---|---|---|---|---|
| Total |
Expense Detail
Operating Expenses by Category
Full period Jan 2025 – Feb 2026
Share of Total Expenses
By category
Mar 2026 CM
$16,867
123 orders · 110% (costs incomplete)
Feb 2026 CM
$7,443
74 orders · 74.9% CM ratio
Jan 2026 CM
$6,762
71 orders · 68.2% CM ratio
Apr 2026 (MTD)
$8,522
53 orders · 90.6% CM ratio
Monthly Contribution Margin $
Last 12 months · Airtable
CM% by Month
Contribution margin as % of order revenue
Monthly Contribution Margin Detail
Source: Airtable · Sync Orders
| Month | Orders | Order Revenue | Contribution Margin $ | CM % | Status |
|---|
Chequing Balance
—
Connect Plaid for live balance
RBC Visa *4129 YTD
$4,191
Jan 2026 · RBC Visa *4129
RBC Visa *4129 2025
$4,210
Full year · RBC Visa *4129
Last Transaction
Jan 14, 2026
Data current to this date
RBC Visa *4129 Monthly Spend
Charges only (excl. payments) · RBC Visa *4129
Plaid Connection Status
RBC Royal Bank · OAuth pending
RBC Royal Bank
Awaiting OAuth setup after deployment
Plaid Production
Account active · credentials in .env
Access Token
Not yet issued — complete OAuth flow
Next step: Deploy to Cloudflare Pages → set redirect URI → run Plaid Link flow → paste access token to .env
RBC Visa *4129 — Recent Transactions
Last 30 days · RBC Visa *4129
| Date | Description | Amount (CAD) |
|---|
Ask Me Anything
Ask questions about Tequila Swim's financial performance. Powered by Claude AI using your live QuickBooks and Airtable data.
Revenue trend 2026
Biggest expenses
March 2026
Discount rate concern?
Best CM months
Claude API Key:
Enter your Claude API key from console.anthropic.com to enable AI chat. Stored in memory only — never saved or shared.