Good morning, Trevor

Here's your business at a glance

Last sync: --
$

Financials

Connected

$29K
Cash Position
A

Amazon

Setup Required

--
Revenue
W

Walmart

Setup Required

--
Revenue
G

Grocery/Retail

Setup Required

--
Revenue
Cash Position Low
$29,000
-74% from prior year
Line of Credit High
$675,000
+88% from prior year
Inventory Growing
$827,000
+15% from prior year
Accounts Receivable Watch
$566,000
+62% from prior year
Net Income (YTD) Loss
-$266,000
-36% from prior year
Total Assets Growing
$3.3M
+14% from prior year

Cash vs Debt Trend

Revenue by Channel

AI Insights

Powered by Claude

Cash Position Critical: Cash declined 74% YoY to $29K while line of credit grew 88% to $675K. Immediate attention needed on cash flow management.

AR Collection Lag: Accounts receivable grew 62% ($217K increase) suggesting collection delays. Review payment terms with major accounts.

Inventory Investment: Inventory grew 15% to $827K. Ensure turns are keeping pace with the increased investment.

Financial Analysis

Source: Google Sheets - Final Reports 12.31.2025

Cash Critical
$29,000
Was $112K in Dec 2024
Line of Credit High
$675,000
Was $360K in Dec 2024
Inventory Growing
$827,000
Was $718K in Dec 2024
Accounts Receivable Watch
$566,000
Was $349K in Dec 2024
Net Income Loss
-$266,000
Was -$195K in Dec 2024
Total Assets Growing
$3.3M
Was $2.9M in Dec 2024
Current Ratio 1.51
Debt-to-Equity 0.52
Working Capital $583K

Assets

ItemDec 2025Dec 2024Change
Cash$29,000$112,000-74%
Accounts Receivable$566,000$349,000+62%
Inventory$827,000$718,000+15%
Fixed Assets$1,540,000$1,420,000+8%
Total Assets$3,300,000$2,900,000+14%

Liabilities & Equity

ItemDec 2025Dec 2024Change
Line of Credit$675,000$360,000+88%
Accounts Payable$285,000$220,000+30%
Long-term Debt$180,000$195,000-8%
Total Liabilities$1,140,000$775,000+47%
Total Equity$2,160,000$2,125,000+2%

Cash vs Line of Credit (Monthly)

Accounts Receivable Trend

Inventory Level

Net Income (Monthly)

Amazon

Seller Central performance data

A

Connect Amazon Seller Central

Link your Amazon SP-API to see sales, inventory, advertising metrics, and FBA fees.

1 Go to Seller Central → Apps & Services → Develop Apps
2 Register as a developer (choose "Private" application)
3 Create an app and copy Client ID, Client Secret, and Refresh Token
4 Enter credentials in Settings tab below

Walmart

Retail Link performance data

W

Walmart Data Integration

Upload Retail Link exports or connect the Walmart API for automated data sync.

1 Log into Retail Link and export your sales/inventory reports
2 Click "Upload CSV" above to import the data
3 Or: Apply for Walmart Marketplace API at developer.walmart.com

Ask AI

Chat with your business data

AI

Hello Trevor! I'm your AI business assistant. Ask me anything about your financials, Amazon sales, Walmart performance, or inventory levels.

Try: "How is our cash flow trending?" or "Compare Amazon vs Walmart revenue"

Settings

Manage connections and preferences

Data Connections

QuickBooks Online Financial data (P&L, Balance Sheet, Cash Flow)
Active
Google Sheets Balance sheet - Final Reports 12.31.2025
Active
Amazon SP-API Sales, inventory, advertising
Not Connected
Walmart Retail Link POS data, inventory at retail
Not Connected

Report Schedule

Automated reports are sent every Monday at 7:00 AM

Reports include: Financial summary, channel performance, AI insights, and recommended actions.

Account