Bailey's Market
Operations & Reporting System
Select your role to continue
Bailey's Market Operations
🔓 Sign out
Pull from Clover
💰
All POS Sales
$0.00
Net Sales $0.00
🍳
Kitchen POS Sales
$0.00
Sales from Kitchen register only — auto-filled when you Pull from Clover
Kitchen Net Sales $0.00
📤
Payouts & Cash Out
$0.00
Cash Payout
Total Payouts $0.00
💸
Money Transfer Services
$0.00
Ria Money Transfer
Total Cash Deposit $0.00
Cash field amount goes to bank deposit
🏦
Cash Collected / Bank Deposit
$0.00
Total Bank Deposit Today $0.00
📝
Notes
All fields are optional — save what you have ✓ Saved successfully
Today's Summary
Total Take Out
$0.00
Cash to collect today
Combined Net
$0.00
All machines cumulative
Vendor Pay (40%)
$0.00
Of total take out
Our Income (60%)
$0.00
Of total take out
Take Out Per Machine
✓ Saved
⚖️
Payout Reconciliation
Unpaid Invoices
0
📄
No unpaid invoices
📋
All Invoices
📋
No invoices yet
Daily Snapshot
Net Sales
$0.00
Total Purchases
$0.00
Top 5 Categories
Loading...
Monthly Summary
Total Net Sales
$0
0 days recorded
Total Purchases
$0
From invoices
Profit Margin
(Sales - Purchases) / Sales
Machine Income
$0
60% of net take out
Avg Daily Sale
$0
Net Sales / Days recorded
Avg Daily Purchase
$0
Purchases / Days recorded
Est. Month Sales
$0
Avg sale × days in month
Est. Month Purchases
$0
Avg purchase × days in month
Unpaid Invoices
0 invoices
$0
Total Repair Cost
$0
This month
Office Supplies
$0
This month
Top 5 Categories This Month
📊
No category data for this month
📈
Category Tracker
Pick up to 3 categories to track monthly net sales.
Daily Sales
to
No data yet
Total $0.00
💬
Ask anything about your business
Bailey's Market AI Advisor

Ask me anything about your business. I have your real sales data and can help you make decisions to grow the store.
🧠
Key Insights & Recommendations
📊
Loading insights...
Search for an item above to view and update its price in Clover
📊
Last 6 Biweekly Payrolls
📊
Loading...
💼
Salary Payments
$0.00
💼
No salary payments yet
Add Vendor
📋
All Vendors
🏪
No vendors yet
✏️
Invoice Changes
📅
Daily Report History
📱
Loading devices...
📥
Download CSV Templates

Download a template, fill in your data in Excel or Google Sheets, then upload below. Do not change column headers.

Daily Reports columns: date, cash_sales, credit_card, debit_card, ebt, tax, kitchen_cash, kitchen_credit, kitchen_debit, kitchen_ebt, kitchen_tax, lottery_payout, missing_extra, game_machine_winner, lottery_refund, atm_add, cash_payout, ria_cash, ria_debit, pos_cash, lottery_kiosk, toy_machine, coin_game, other_cash, notes
Invoices columns: date, vendor, amount, invoice_num, status, pay_type, check_number, paid_date, notes
💼
Upload Salary Payments

Upload a CSV with columns: date, staff_name, amount, check_number, notes
Staff name must match an existing vendor of type Salary. Date format: YYYY-MM-DD.

📊
Upload Clover Category Sales

Upload a Clover category export CSV. The date is read from row 2, and categories are read from the rows below the Category Name / Net Sales headers. Only category_sales is updated — all other report data is untouched.

You can upload multiple files at once — one per day or a batch. Each file must be a separate day's Clover export.
📤
Upload Daily Reports

Upload a CSV file with daily report data. Existing reports for the same date will be overwritten.

No file selected
📊
Pull Category Sales from Clover

Pulls only category sales data from Clover for each date — does not overwrite your imported totals (cash, payouts, deposits, etc.).

📅
Pull Historical Sales from Clover

Pulls All POS Sales (cash/credit/debit/EBT/tax) and Kitchen sales from Clover for each day in the selected range. Creates or updates daily report entries. Does not overwrite existing entries unless you check the box below.

Available months from Clover API: Oct 2024 · Nov 2024 · Dec 2024 · Jan 2025 · Feb 2025
Data beyond this range is not available via the Clover API.
👤
Backfill Customer Count from Clover

Fills customer_count on existing daily reports that don't have one — uses Clover to look up the customer count per day. Skips days that already have a count. Use this when you've uploaded daily sales totals via template (no customer_count) and want to fill that gap.

Tip: Centro 2026 (Jan 1 – May 8) was uploaded via daily template and is missing customer_count. Pick that range and click Backfill. Updates the Avg Ticket tile on the Dashboard once complete.
📂
Upload Clover Category CSV

Upload Clover "Revenue Item Sales" CSV exports. Only updates category sales — does not overwrite your other daily report data.

How to export from Clover:
Dashboard → Reports → Revenue Item Sales → Select date → Export CSV
You can upload multiple files at once (one per day)
No files selected
📄
Upload Historical Sales (Excel Template)

Upload the Clover or Old POS Excel templates with daily sales + monthly category totals. One file per month.

File type: Clover Template or Old POS Template (both formats auto-detected)
One file = one month. Upload multiple files at once for multiple months.
Categories: Monthly totals in the last column are imported automatically.
No files selected
📤
Upload Invoices

Upload a CSV file with invoice data. Duplicates (same vendor + date + amount) will be skipped.

No file selected
History
Loading…