Business Command Center v2 in Excel: A Complete Tour
Introduction
Running a small business means keeping orders, stock, prices and money connected. Business Command Center v2 in Excel brings those jobs into one workbook with a shared navigation bar and dedicated work areas. This tour follows all 12 screenshots in order, from initial setup to the balance sheet, so you can see where to enter information, what each page tells you and which action to take next.
Why this matters
An order tells you what a customer bought. An invoice tells them what to pay. Stock records tell you what you can supply, while cash planning asks when money will actually be available. Keeping those questions together makes the handoffs easier to follow. The sample candle business also shows how product sales and workshop bookings can sit alongside purchasing, production and financial review.
Before you start
Have your business details, opening account balances, products, material costs, recurring bills and budget ready. Use a working copy and read the supplied guide. The Start screen says macros support buttons, the calendar and automatic IDs. Use Excel desktop for those VBA features; Excel for the web can retain a macro workbook but cannot run its VBA. Enable content only for a file you trust and within your organization's policy.
These are user-supplied screenshots with demo data for Juniper & Wick Candle Co., mostly dated 29 October 2026. Amounts below use English number formatting; the images use mixed locale formatting. This is a walkthrough of the shown interface, not an execution test of the workbook or a verified list of changes from v1. Exact Excel-version and Mac compatibility aren't established by the screenshots.
Step-by-step: tour the workbook from 01 to 12
01 · Start: set up your business before entering transactions
The Start page gives you a seven-step checklist: business details, currency and tax; accounts and opening balances; income and expense categories; products, materials and recipes; recurring bills and income; monthly goals and budget; and your first orders, bookings and ledger entries.
Work through that sequence before replacing the demo data. Opening balances establish your starting point, categories determine how transactions appear in reports, and recipes describe which materials go into each finished product.
The screenshot shows all seven steps complete and DEMO DATA LOADED. Explore this copy first, read the guide, and keep a backup before using Clear all data. White cells are inputs; grey calculated columns should be left intact.
02 · Home: decide what needs attention today
Home brings cash, monthly revenue, fiscal-year profit, receivables and upcoming bills into one overview. The demo shows $8,872 cash, $7,332 revenue this month and $23,316 net profit for FY2026 to date.
Start with Needs attention. It identifies two overdue bills, three overdue invoices, materials to reorder, products to make, shipments, bookings, tasks and accounts awaiting reconciliation. These prompts give you a practical review order.
The 13-week cash outlook adds context; the lower panels show revenue versus expenses, leading products and upcoming events. Use Refresh after changes and Backup before major edits. The Report pack (PDF) button provides a route to sharing the report views.
03 · Calendar: put obligations and operations on the same timeline
The Calendar combines bills, income, bookings, shipments and tasks. Use the Yes/No filters to reduce clutter, move between months, or select a day to inspect its details below the grid.
Colors distinguish event types, while the weekly summary shows money in, money out, net movement and the cash figure for that week. The example includes rent, subscriptions, workshops, shipments and restocking tasks.
Read the selected-day detail separately from the highlighted current date: this screenshot highlights 29 October while the detail panel displays 28 October. The layout shown starts on Sunday; don't assume it follows your regional week-start setting.
04 · Sales: understand orders, channels and unpaid balances
The Sales & Customers page lets you choose a period, custom dates, a channel and a comparison. The demo shows $43,201 net sales from 358 orders, an average order value of $120.67 and $3,534 receivables.
Use the monthly chart to inspect the sales pattern, then compare channel sales, top products and top customers. Wholesale contributes $22,959 in the displayed period, making its payment timing worth reviewing alongside sales volume.
Receivables aging groups unpaid invoices by lateness: $1,782 is not yet due and $1,752 is 1–30 days overdue. The sales margin here is labeled after materials, labor and channel fees. It has a different scope from the P&L gross margin, so compare definitions before comparing percentages.
05 · New Order: capture the transaction once
Enter the customer, order date, channel, ship-by date and status, then add products and quantities. Optional price overrides, line discounts, order discounts, shipping and tax let you describe the actual sale.
The Summary separates subtotal, discount, net sales, sales tax, shipping and total. If money arrives immediately, fill Payment received now with the amount, account and method. Without a payment, the form states that the order will appear as Unpaid.
Use Save order or Save & open invoice. The on-screen instructions describe creating the order, lines, customer and any payment together. Check the resulting records during your first test, and avoid entering that same receipt again manually in the ledger.
06 · Invoice: give the customer a clear payment record
The invoice presents the business and customer details, invoice number, issue and due dates, status, line items, payment instructions and balance due.
In the demo, INV-1821 contains a $24 candle and a $12 tin. The $36 subtotal plus $2.88 sales tax and $5.95 shipping produces a $44.83 total. A matching payment leaves $0.00 due, and the document is marked PAID.
Check your own contact details, payment instructions and required invoice fields before using this layout with customers. This screenshot demonstrates the presentation; it doesn't establish compliance with every country's invoicing requirements.
07 · Inventory: turn low-stock signals into purchasing and production
Inventory & Production separates materials to reorder from finished products to make. The top cards summarize stock value at cost, reorder needs, production needs, out-of-stock items and open purchase orders.
The demo shows about $3,005 in inventory, two materials to reorder now, one product to make now and seven open purchase orders. The lists add quantities on hand, thresholds, suggested quantities, estimated costs and suppliers.
Review incoming purchases before creating more orders. Use the actions for purchase orders, production, stock counts and posting purchases as appropriate. Material-value and product-stock charts help you see where stock is concentrated; inventory value at cost isn't expected selling revenue.
08 · Pricing: build a price from costs and test alternatives
Pricing Studio brings together recipe materials, optional extras, labor, equipment and other costs. Select a product, pricing method, method value, discount, channel and tax assumptions.
For Lavender Fields Candle 8oz, the displayed unit cost is $6.43. A 65% target margin gives a suggested net price of $18.37 before channel fees reduce the displayed real margin to 60.2%. Customer pays includes the sample sales tax.
The What if section explores another selling price, monthly profit goal, lower costs, a target real margin and fixed-cost break-even. Compare scenarios before using Save to Price Book or Apply price to product. Margin and markup use different denominators; the two percentages aren't interchangeable.
09 · Cash Flow: look ahead to payment timing
The Cash Flow Forecast combines scheduled bills and income, open receivables and a run-rate estimate for other activity. Controls let you change sales and spending assumptions, include receivables or pending entries, use last year's pattern and provide opening cash.
The 13-week chart shows weekly inflows and outflows, projected closing cash and a dashed buffer. Under the displayed assumptions, the lowest weekly closing balance is $10,317 against a $3,000 buffer; no forecast week falls below it.
Use the week-by-week table to investigate a dip, then review the 12-month outlook. Cash-positive describes this scenario, not a guarantee. Revisit assumptions when collections, purchasing or seasonal demand change, and check that receivables aren't counted twice in your inputs.
10 · Profit & Loss: compare performance with the prior period and budget
The P&L view uses paid entries on a cash basis in the screenshot. Choose the period, comparison and pending-entry setting before interpreting the cards or income statement.
The demo displays $58,624 revenue, $42,527 gross profit, $18,873 operating expenses and $23,316 net profit. Net profit is $12,576 above the displayed $10,740 budget.
The detailed statement separates revenue, cost of goods sold, operating expenses, other income and other expenses. Monthly profit and the expense-mix chart show patterns behind the totals. Order-based sales and paid-entry revenue measure different things; investigate their basis instead of forcing them to match.
11 · Tax: organize collected tax and a planning reserve
The Tax page shows collected sales tax, tax on purchases, remittances, the running balance and an income-tax reserve planner. Its note says purchase tax is included in costs rather than reclaimed in this example.
The monthly table and collected-versus-remitted chart help trace timing. Don't subtract only this year's headline totals to infer the balance: opening amounts and the periods covered by payments can matter.
The income-tax planner applies the configured 25% reserve rate to demo profit, showing $5,829 suggested reserve, $2,400 already paid and $3,429 still to set aside. These are workbook planning assumptions. The US-style sales-tax example doesn't establish German VAT treatment, deductibility or your actual tax liability.
12 · Balance Sheet: review resources, obligations and equity
The Balance Sheet compares assets, liabilities and owner's equity at the selected date with the displayed fiscal-year starting point. Cash, receivables and other operational figures sit alongside manual items such as fixed assets and long-term liabilities.
The demo shows $18,567 total assets, $4,633 liabilities and $13,934 owner's equity. The financial-health panel adds current and quick ratios, debt measures, working capital and inventory share, with each calculation described below its value.
Notice the explicit limitation: inventory is today's value at cost, including in the comparison display. It isn't a reconstructed historical valuation. Keep manual items current and use the Healthy labels as prompts for review; their thresholds don't provide a universal assessment of every business.
Practical example: follow one order through the workbook
Start in New Order with the two products shown on INV-1821: one Lavender Fields Candle 8oz at $24 and one Vanilla Bean Tin 4oz at $12.
Apply the sample 8% tax and $5.95 shipping. Check that the total is $44.83 before saving.
If the full amount has arrived, enter $44.83 once with the correct account and payment method. Open the invoice and confirm the payment and $0.00 balance due.
Inspect the order, payment and ledger records, then refresh Home and review the relevant cash, P&L and tax views. Reconcile their different definitions rather than expecting every headline to increase by the gross invoice total.
Expected result: a traceable order and payment, a consistent invoice balance and report figures you can explain. The invoice shown is the reference example; these steps are a recommended acceptance check in your own copy, not a claim that an additional transaction was run here.
Bonus tips and common mistakes
If buttons don't respond, check that you're in Excel desktop and that trusted-file macros are permitted. If reports look inconsistent, inspect dates, payment status, pending-entry settings and the distinction between order records and paid ledger entries. If stock looks wrong, investigate purchases, production and adjustments before overwriting calculated cells.
Treat forecast assumptions, manual balance-sheet entries and tax settings as maintained inputs. The 8% sales tax and 25% reserve rate are demonstration choices. Configure the workbook for your circumstances before relying on it; this article doesn't determine statutory accounting or tax treatment.
Final thoughts
Start with the setup checklist, capture one complete order and payment, and trace it through the relevant views. Once that works, build a routine around Home, Calendar, stock review and cash planning. The value of a command center comes from keeping its underlying records consistent.
Explore the Excelized template collection for available downloads, or discuss a tailored reporting workflow through our services page.
Get Business Command Center v2 in Excel
Ready to use the workbook? Open the product page to view the current price and purchase the downloadable template.
Sources and further reading
Product walkthrough: the 12 screenshots supplied with this article. Interface descriptions and sample values come from those images.
Want help tailoring your Excel reporting workflow? Explore Excelized services.
Comments