RC
Riverside Cafe LLC Bookkeeping
SA
Sign out
Bookkeeping / Reports

Reports

Riverside Cafe LLC · Jun 2026 – Jun 2026 · Accrual basis

Send to client
✦
Period summary · auto-generated

For Jun 2026, revenue was $126,000 against $100,000 in expenses, for a net profit of $26,000 (20.6% margin).

Revenue
$126,000
For the period
Total expenses
$100,000
Operating + COGS
Net profit
$26,000
20.6% margin
Net margin
20.6%
Net ÷ revenue
Reports
◔
Profit & Loss
Revenue, COGS, expenses and net income — with drill-down
Net $26,000 Jun 2026
→
▦
Balance Sheet
Assets, liabilities and equity — as of period end
View Jun 30, 2026
→
≋
Cash Flow Statement
Operating, investing and financing — indirect method
View Jun 2026
→
≣
Trial Balance
Unadjusted debit and credit balances across all accounts
View Jun 30, 2026
→
⇆
What Changed
All income & expense accounts × 12 months — missed, swings, one-offs
Trailing 12mo 12 mo
→
⊘
Duplicates & Reconciliation
Possible duplicate transactions and bank reconciliation mismatches
Needs action Review
→
◑
Charts & Ratios
Revenue trend, expense mix, margins and key ratios
Visual YTD
→
Compare
Riverside Cafe LLC
Profit & Loss
Jun 1, 2026 – Jun 30, 2026 · Accrual basis
CodeAccount This period Prior Δ %
Income
4010 Food Sales▸ $82,400 $78,900 +4.4%
4020 Beverage Sales▸ $31,600 $29,400 +7.5%
4030 Catering Income▸ $12,000 $9,500 +26.3%
Total Income $126,000
Cost of Goods Sold
5010 Food & Beverage COGS▸ $38,000 $36,100 +5.3%
Total Cost of Goods Sold $38,000
Operating Expenses
6010 Rent▸ $9,500 $9,500 —
6020 Payroll & Wages▸ $42,000 $40,100 +4.7%
6030 Utilities▸ $3,200 $2,950 +8.5%
6040 Insurance▸ $1,800 $1,800 —
6050 Marketing▸ $2,500 $1,600 +56.3%
6060 Supplies▸ $1,900 $2,050 −7.3%
6070 Depreciation▾ $1,100 $1,100 —
Contributing transactions
Jun 30 Monthly depreciation — kitchen equipment $1,100
View all transactions → $1,100 total
Total Operating Expenses $62,000
Net Income $26,000
Generated Jul 20, 2026 · Zie Pie Books Click any line to drill into transactions
Riverside Cafe LLC
Balance Sheet
Jun 1, 2026 – Jun 30, 2026 · Accrual basis
✓ In balance
CodeAccount This period Prior Δ %
Assets
1010 Chase Business Checking▸ $84,300 — —
1200 Accounts Receivable▸ $8,200 — —
1300 Inventory▸ $14,500 — —
1500 Equipment (net of depreciation)▸ $62,000 — —
Total Assets $169,000
Liabilities
2010 Accounts Payable▸ $11,300 — —
2100 Amex Credit Card▸ $4,700 — —
2500 Equipment Loan Payable▸ $38,000 — —
Total Liabilities $54,000
Equity
3010 Owner's Capital▸ $60,000 — —
3900 Retained Earnings▸ $29,000 — —
3910 Net Income (current period)▸ $26,000 — —
Total Equity $115,000
Total Liabilities & Equity $169,000
Generated Jul 20, 2026 · Zie Pie Books Assets $169,000 = Liabilities $54,000 + Equity $115,000
Riverside Cafe LLC
Cash Flow Statement
Jun 1, 2026 – Jun 30, 2026 · Accrual basis
CodeAccount This period Prior Δ %
Operating Activities
Net Income $26,000 — —
Add: Depreciation $1,100 — —
Increase in Accounts Receivable ($2,400) — —
Increase in Inventory ($1,800) — —
Increase in Accounts Payable $3,600 — —
Increase in Credit Card Payable $700 — —
Net Cash from Operating $27,200
Investing Activities
Purchase of kitchen equipment ($5,000) — —
Net Cash from Investing ($5,000)
Financing Activities
Equipment loan principal repayment ($2,000) — —
Net Cash from Financing ($2,000)
Net Change in Cash $20,200
Beginning cash $64,100 + $20,200 = Ending cash $84,300 (ties to Balance Sheet) Indirect method
Riverside Cafe LLC
Trial Balance
As of Jun 30, 2026 · Accrual basis
✓ Debits = Credits
CodeAccount DebitCredit
1010Chase Business Checking$84,300·
1200Accounts Receivable$8,200·
1300Inventory$14,500·
1500Equipment (net)$62,000·
2010Accounts Payable·$11,300
2100Amex Credit Card·$4,700
2500Equipment Loan Payable·$38,000
3010Owner's Capital·$60,000
3900Retained Earnings·$29,000
4010Food Sales·$82,400
4020Beverage Sales·$31,600
4030Catering Income·$12,000
5010Food & Beverage COGS$38,000·
6010Rent$9,500·
6020Payroll & Wages$42,000·
6030Utilities$3,200·
6040Insurance$1,800·
6050Marketing$2,500·
6060Supplies$1,900·
6070Depreciation$1,100·
Totals $269,000 $269,000
Jul 2025 – Jun 2026 · monthly net movement
⚠
Missed months 1
Marketing 6050
No spend recorded in Feb 2026 — every other month posted.
▲
Big changes 2
Catering Income 4030
Up 26% vs prior month — holiday party bookings.
Marketing 6050
Up 56% vs prior month — new summer campaign.
◆
One-offs 1
Equipment (net) 1500
$5,000 equipment purchase in Jun — no comparable in other months.
CodeAccount JulAugSepOctNovDecJanFebMarAprMayJun NotableSignal
Income
4010 Food Sales 74k 76k 75k 77k 80k 83k 72k 73k 78k 79k 79k 82k +4% MoM Stable
4030 Catering Income 8k 7k 9k 10k 11k 13k 8k 7k 9k 9k 9k 12k +26% MoM Big change
Operating Expenses
6050 Marketing 1.5k 1.4k 1.6k 1.5k 1.8k 2.0k 1.5k — 1.6k 1.5k 1.6k 2.5k Missed Feb Missed
Missing month Big change One-off Figures in $ thousands (k)
⊘
Possible duplicates
2 pairs open · $1,540 at risk
⇋
Reconciliation mismatches
1 accounts open · $120 variance
Possible duplicates — review and resolve before close
High confidence
Same amount, same vendor, 2 days apart — likely a re-entered bill.
5010 · Food & Beverage COGS
$1,240
duplicated
DateDescriptionReferenceAmount
Jun 12, 2026 Sysco Foods invoiceOriginal INV-88213 $1,240
Jun 14, 2026 Sysco Foods invoiceSuspected duplicate INV-88213 $1,240
Medium confidence
Similar amount and description within the same week.
6060 · Supplies
$300
duplicated
DateDescriptionReferenceAmount
Jun 5, 2026 Restaurant DepotOriginal CARD-4821 $300
Jun 8, 2026 Restaurant DepotSuspected duplicate CARD-4821 $300
Kept both entries
Reconciliation mismatches — book vs statement balance
MonthAccount BookStatementVariance
May 2026 Amex Credit Card 2100 Statement fee not yet booked $4,580 $4,700 −$120
Total unreconciled variance $120
Revenue vs Expenses
Last 12 months
Net profit trend
Month over month
Expense breakdown · Jun 2026
$100,000 total
Payroll · $42,000
COGS · $38,000
Rent · $9,500
Other · $10,500