Portfolio Overview
P&L snapshot · year to date through May 2026 · all reporting entities
MAY 2026 · BLENDED
Titan Intelligence · Priority Read
Loading…
Revenue · YTD (P&L)
$23.40M
17.2% net sales YoY
Net Income · YTD
$1.43M
37% vs $2.27M budget
Net Margin · YTD
6.1%
vs 9.7% budget margin
Net Income vs Budget
−$0.83M
10 reporting entities
Priority Alerts
View all 11 →Barn & Lodge Rotunda — −$192K Loss · Labor 50%
A −$191.5K loss YTD with labor at 50.2% and prime cost 74.9% at the new unit — ~2× the group norm and roughly $570K/yr of opportunity.
Farmhouse Tuscan — Operating at a Loss (−$78K)
−$78K net income YTD on a −5.4% margin, against a +$30K budget. Labor 32.5%; growing fast (+10.8%) but not yet profitable.
Period Close — Wilmington & Rotunda Blocked
Both new units are blocked at bank reconciliation with no account ever reconciled — the critical path to a clean close.
Location Performance
Ask Titan Books
Plain-English answers from Titan's live Restaurant365 data — no report-building required
AI · LIVE QUERY
Connected to R365 · live
What do you want to know?
Ask about cash, costs, reconciliations, payroll, journal entries — anything in the books across all ten entities.
Performance Analytics
Historical trends, comparative analysis, and operating insights
YTD · NET SALES +17.2% YoY
Top Performer
—
—
Lowest Margin
—
—
Fastest Growing
—
—
Group Labor %
—
—
Company Net Sales Trend
Monthly · Jan – May 2026 · R365 daily feed
Net Margin by Entity
P&L YTD · vs 4.8% group average
Entity Comparison · YTD through May 2026
Key Insights
Top line is growing
—
Profit is under plan
—
Rotunda is the outlier
—
Alert Management
10 active alerts across all entities — surfaced from the live R365 cleanup diagnostics
18 Bank Accounts Have Never Been Reconciled
18 of 50 cash accounts have no completed reconciliation in R365 — concentrated at Barn & Lodge Rotunda, Wilmington, and Lodge Pasadena. Core of the catch-up engagement.
32 Unapproved Journal Entries · $1.97M
70-day backlog of unapproved JEs totaling $1.97M. Largest at Titan Hospitality Group ($884K), Lodge Pasadena ($191K), and Alexandria ($155K). Block a trustworthy close.
Barn & Lodge Rotunda — −$192K Loss · Labor 50%
A −$191.5K loss YTD with labor at 50.2% and prime cost 74.9% at the new unit — roughly 2× the group norm and ~$570K/yr of opportunity. The single biggest margin lever in the group.
Farmhouse Tuscan — Operating at a Loss (−$78K)
−$78K net income YTD on a −5.4% margin, against a +$30K budget. Labor 32.5%; growing fast (+10.8%) but not yet profitable.
Barn & Lodge Wilmington — Negative Book Cash ($358,603)
Book cash is negative across Wilmington's accounts and none have been reconciled — likely unrecorded deposits / transfers. Needs full catch-up.
Widespread Negative Book Cash · −$1.86M
7 of 11 entities show negative cash on the books (Annapolis −$846K, Lodge Annapolis −$795K, Tuscan −$769K, Pasadena −$587K…) — a sign of unrecorded deposits/transfers. None is bank-verified until reconciled.
Undeposited Funds · $2.01M Uncleared
$2,012,590 sits in Undeposited Funds (GL 12000) — deposits recorded on the books but not yet matched/cleared to the bank. Clearing these is part of the cash clean-up.
Smashing Grapes Columbia — Stale Outstanding Check (84d)
Check #11110 ($1,274) has been outstanding 84 days; #11133 at 61 days. Confirm or void & reissue before they block the rec.
Smashing Grapes — Margin Near Zero (0.2%)
Barely break-even — +$3.4K net income YTD (0.2% margin) vs a +$62K budget. Discounts at 4.1% are the highest in the group.
Month-End Close — 2 Locations Pending GL Reconciliation
Blackwall Barn & Lodge and The Farmhouse awaiting final GL sign-off.
Monthly Close Workflow
Period close · 10 reporting entities · catch-up in progress
CLEANUP CLOSE · IN PROGRESS
Close Status · Titan Intelligence
2 of 10 entities are locked (Barn & Lodge Gambrills, Lodge Annapolis). The critical path runs through Wilmington and Rotunda — both blocked at bank reconciliation with no account ever reconciled — plus the 15 unapproved standard JEs at the management company. Bank Sync and JE approval are the two levers that unblock the rest.
Close Progress
57%
57 of 100 tasks complete
Entities Locked
2 / 10
B&L Gambrills · Lodge Annapolis
Blocked Tasks
5
Bank recs & payroll JE
Open Items
43
Across 8 entities
Entity Close Status
Close Checklist Matrix
● Done ● Active ● Pending ● BlockedBank Sync
Direct bank feeds into R365 — every account across all 11 entities, no manual statement uploads
50 ACCOUNTS · 11 ENTITIES
Accounts on Feed
50 / 50
All connected via BAI feed
Reconciled This Period
32 / 50
18 never reconciled — cleanup
Outstanding Items
$157.8K
23 uncleared transactions
Last Sync
2m ago
Auto-pulls nightly 12:01 AM
Direct Bank Connection
Truist · Fulton · Linkbank — read-only BAI feedSync all bank feeds now
Pulls every connected account across all 11 entities directly from the bank into R365 — transactions auto-match against the GL. No statement files, no bank passwords shared.
18 accounts have never been reconciled
The feeds are live and pulling, but 18 of 50 cash accounts — concentrated at Barn & Lodge Rotunda, Wilmington, and Lodge Pasadena — have no completed reconciliation in R365. These are the core of the cleanup engagement; each gets caught up to a $0 difference and signed off.
Accounts by Entity
| Entity | Cash Accounts | On Feed | Cash per Books (5/31) | Last Reconciled | Status |
|---|
Outstanding Checks & Uncleared Items
Issued but not yet cleared the bank — pulled live from the R365 bank feed across all entities
AS OF JUN 22, 2026
Total Outstanding
$157.8K
23 uncleared items
Outstanding Checks
$57.8K
20 checks / ACH
Deposits in Transit
$100.0K
3 deposits · Farmhouse Middletown
Oldest Open Item
84d
Smashing Grapes · #11110
Stale items void the bank rec
Checks outstanding past ~60 days should be confirmed or voided and reissued — they're the most common reason a reconciliation won't tie. Items below are sorted by age; the three Farmhouse Middletown deposits-in-transit are a pre-opening funding pattern, not a clearing problem.
Uncleared Register
Export →Trial Balance Sync
Read-only trial balance from R365 OData — scanned for unusual activity before the monthly review
ODATA · READ-ONLY
Titan Intelligence · Anomaly Scan
Every entity's TB ties (debits = credits, $0.00), but the scan flagged 8 items worth a look — led by widespread negative book cash (net −$1.86M across 7 entities; Annapolis −$846K is the largest), $2.01M in Undeposited Funds, and a $884K backlog of unposted JEs. Suspense itself is clean (~$1K). These are the things that wouldn't show up if you only checked that the books balance.
Entities Synced
11 / 11
Via OData · read-only
In Balance
$0.00
Debits = credits, all entities
Unusual Activity
8
4 high · 4 to review
Negative Book Cash
7 / 11
Net −$1.86M · unrecorded deposits
What "Uncategorized $" means
It's a "to-sort" pile — money that hit the books before anyone said which account it belongs in (an unidentified deposit, a payment with no invoice, a transfer that didn't match). Accountants call it a suspense or "Ask-My-Accountant" account. The books still balance, but those dollars need to be sorted into the right account before the close is trustworthy. Right now this is basically clean — only about $1K group-wide. The real cleanup here is the negative book cash and the $2.01M of Undeposited Funds above.
Re-sync & re-scan now
Re-pulls each entity's TB from the R365 OData endpoint, re-checks debits = credits, and re-runs the anomaly scan. Read-only — nothing is written back to R365.
Unusual Activity Flagged
Things "in balance" still hidesTrial Balance by Entity · YTD net activity
Journal Entries
Unapproved JE backlog by entity, plus the recurring entry library
Unapproved JEs
32
Across 12 entities
Unapproved Value
$1.97M
Blocks a trustworthy close
Largest Backlog
Titan Hospitality
15 entries · $884K
Recurring Templates
9
Auto-generate each period
Approvals live here — nothing posts without sign-off
These are real unapproved entries pulled from R365. Each must be reviewed and approved (or sent back) before the period can lock. Mostly payroll JEs at the operating entities plus a 15-entry standard-JE backlog at the management company.
Unapproved JEs by Entity
Export →Recurring JE Library
Budget vs Actual & P&L
Consolidated P&L · year to date through May 2026 · from the R365 P&L scorecard
YTD · P&L BASIS
Flux commentary
—
Consolidated P&L · YTD through May 2026
Net Income vs Budget by Entity
Export →Accounts Payable & EDI
Vendor invoices flowing into R365 by EDI — captured, 3-way matched, coded, and routed for approval
MAY 2026 · ALL ENTITIES
Titan Intelligence · AP Automation
EDI carries the cleanest invoice load. 6 vendors (led by PFG) send invoices straight into R365 by native EDI — ~435 of Titan's 1,933 monthly invoices, ~94% auto-coded with no keying. The other ~1,500 flow through mapping & capture. The exceptions queue below is where a human is actually needed: 11 price/quantity mismatches and 4 invoices over the $5K approval threshold.
EDI Invoices · Month
~435
6 native-EDI vendors
Auto-Coded
94%
Order guide · no keying
Exceptions Queue
15
11 mismatch · 4 over threshold
AP Open · Due 14d
$486.3K
Across all entities
EDI Vendor Connections
Exceptions — Need Review
Auto-matched invoices post without youDaily Sales
Net sales by unit — week-to-date, period-to-date and prior-year, straight from the R365 sales feed
Live · Restaurant365
The same daily sales report the CEO gets each morning, rendered natively in the Hub — plus the Monthly Scorecard and Rankings views. Net sales pull from R365, prior-year is loaded for all of 2026.
Audit Trail
Every change — who, when, and why — with supporting workpapers. Nothing overwritten.
IMMUTABLE LOG
Logged Actions · 30d
312
Across all 11 entities
Workpapers on File
132
Linked to entries & recs
Last Export
Today
Full who/when/why log
Retention
7 yrs
Immutable · audit-ready
Every action is attributed and permanent
Each entry is timestamped, tied to a person, and never overwritten or deleted — the who/when/why record an auditor, lender, or incoming CFO asks for. Corrections post as new reviewable entries, never silent edits.
Recent Activity
Export log →| Timestamp | Entity | Action | By | Detail |
|---|---|---|---|---|
| 2026-06-23 16:42 | B&L Gambrills | Period locked | JT | Close signed off & frozen — all tasks complete |
| 2026-06-23 15:10 | Lodge Annapolis | Period locked | JT | Close signed off & frozen |
| 2026-06-23 11:05 | B&L Wilmington | Anomaly flagged | System | Negative book cash (−$358,603) — 5 accounts never reconciled |
| 2026-06-23 03:04 | Portfolio | TB scan | System | Trial balances synced via OData — 8 unusual items flagged |
| 2026-06-22 14:18 | Hitch Alexandria | Bank synced | ML | Operating account reconciled to statement — $0 difference |
| 2026-06-22 10:30 | B&L Rotunda | JE held | SD | Payroll JE ($88,554) pending — labor at 48% under review |
| 2026-06-22 06:15 | Mgmt Co. | Approval queued | System | 15 standard JEs ($884K) routed to controller for sign-off |
| 2026-06-21 13:40 | Smashing Grapes | Stale item | System | Check #11110 ($1,274) outstanding 84 days — flagged to void/reissue |
Owner's Brief
Year to date through May 2026 · the whole group, in plain English
AUTO-GENERATED FROM R365
Titan Intelligence · YTD Brief
—
Watch — losing money / off the rails
—
Healthy and growing
—
Needs you
Decide on Rotunda labor
48% labor / 76% prime cost on a new unit — needs a staffing plan or it keeps bleeding
Clear the cleanup backlog
32 unapproved JEs ($1.97M) and 18 never-reconciled bank accounts block a trustworthy close
Cross-Entity Benchmarking
Every entity against the group average — pick any metric
YTD · ALL METRICS
Titan Intelligence · Opportunity
—
Benchmark by Metric
Best to worst · vs group averageThe play
—
YoY Net Sales Growth · all 11 entities
Live from R365 · YTD through 6/22/2026 vs prior yearGroup up +17.2% YoY
Company net sales of $23.25M YTD vs $19.85M prior year. Three new/ramping units (Wilmington, Rotunda) have no prior-year base; among comparable units The Farmhouse Tuscan (+10.8%) and The Lodge Annapolis (+5.9%) lead, while Lodge Pasadena (−34%) and Barn & Lodge Columbia (−7.5%) lag.
Report Generation
Create, schedule, and export audit-ready reports
Pre-Built Reports · One-Click
Settings & Integrations
Manage R365 connections and system preferences