[Programs](<https://www.thekeating.co/programs/>) / [Finance & business intelligence](<https://www.thekeating.co/programs/commercial-reporting/#main>)

[The shift](<https://www.thekeating.co/programs/commercial-reporting/#shift>) [Look inside](<https://www.thekeating.co/programs/commercial-reporting/#look-inside>) [The story](<https://www.thekeating.co/programs/commercial-reporting/#first-month>) [Use cases](<https://www.thekeating.co/programs/commercial-reporting/#use-cases>) [Yours to keep](<https://www.thekeating.co/programs/commercial-reporting/#keep>) [The review](<https://www.thekeating.co/programs/commercial-reporting/#review>) [Start a review](<https://www.thekeating.co/contact/?source=discovery&landing_path=%2Fprograms%2Fcommercial-reporting%2F&intent=discovery&cta_page=%2Fprograms%2Fcommercial-reporting%2F&cta_placement=navigation&program=commercial-reporting>)

# Numbers you can trust. Decisions someone owns.

Every payout in the right month, margin with every cost in it, cash seen weeks ahead, and a Monday brief that ends in decisions. Built on the accounting and BI tools you have, then run with you or handed over.

[Start with a finance review](<https://www.thekeating.co/contact/?source=discovery&landing_path=%2Fprograms%2Fcommercial-reporting%2F&intent=discovery&cta_page=%2Fprograms%2Fcommercial-reporting%2F&cta_placement=hero&program=commercial-reporting>) [Look inside](<https://www.thekeating.co/programs/commercial-reporting/#look-inside>)

In prior roles, our operators led the commerce and back-office systems behind $2B+ in annual revenue.

## Every sale becomes a number. Not every number is true.

Orders, payouts, supplier bills and ad spend each report in their own way. Finance and business intelligence turns them into one set of numbers you can trust, and into decisions someone owns.

Six sources, from store payouts to supplier bills, flow into one set of numbers. From there they lead to a decision, and come back around at the next close.Store payoutsTikTok ShopWholesaleAd platforms3PL invoicesSupplier billsOne set of numbersDecisionNext close

Buying and stocking

Supply chain & fulfillment

Knowing what it earned

Finance & business intelligence · this page

Pricing and promotions

Merchandising & commercial planning

## How ecommerce finance work changed

### Every number had its own spreadsheet. Each one true until someone checked.

Orders in one export, payouts in another, supplier bills in a third. A person stitched them together after month-end, and the result was only as good as their week.

### Then every tool learned to report. And each reports a different number.

Accounting, payables and BI tools now read invoices, code transactions, match settlements and draft reports on their own. Each one is right about its own slice, and the slices rarely agree.

### So the edge moved to numbers you can act on. Accepted, explained and owned.

What’s left is the definitions, the seams between adequate systems, and an owner for every exception. We build that, so each number is accepted, explained and tied to a decision someone owns.

1.  [Then](<https://www.thekeating.co/programs/commercial-reporting/#shift>)
2.  [Now](<https://www.thekeating.co/programs/commercial-reporting/#shift>)
3.  [Next](<https://www.thekeating.co/programs/commercial-reporting/#shift>)

[Skip the walkthrough](<https://www.thekeating.co/programs/commercial-reporting/#first-month>)

## Look inside. Five parts, built around your business.

1.  ### Your business. One October, one set of numbers.
    
    Orders, payouts, costs, stock and cash, read from the systems you already run. Every figure carries its source, its as-of date and whether it’s closed.
    
    Fernway Outfitters · October
    
    Measure
    
    October
    
    Status
    
    Net sales
    
    $2.33M
    
    Closed
    
    Canvas jacket contribution
    
    30% · 12%
    
    Shopify · TikTok
    
    Cash in the bank
    
    $500,000
    
    October 31
    
    The close
    
    Five days
    
    Closed
    
2.  ### Records. Every payout, in the right month.
    
    Payouts, refunds, fees and tax tie back to orders and the bank. Period rules your accountant approves decide the month, and nothing unexplained goes into a plug account.
    
    -   [Payout reconciliation](<https://www.thekeating.co/use-cases/revenue-reconciliation/>)
    -   [Month-end close](<https://www.thekeating.co/use-cases/month-end-close/>)
    
    Payout · TikTok Shop Batch of Oct 6
    
    Line
    
    Amount
    
    Net sales
    
    $820
    
    Sales tax held
    
    $64
    
    Platform and payment fees
    
    −$30
    
    Payout to the bank
    
    $854
    
3.  ### Margin. Every cost, by product and channel.
    
    Fulfillment, fees, returns, ads and commission land on each product and channel. A column says which costs are in, so an estimate never passes as an actual.
    
    -   [Contribution diagnosis](<https://www.thekeating.co/use-cases/contribution-diagnosis/>)
    -   [Landed cost](<https://www.thekeating.co/use-cases/landed-cost/>)
    
    Contribution · October
    
    Product · channel
    
    Margin
    
    Costs in
    
    Canvas jacket · Shopify
    
    30%
    
    All in
    
    Canvas jacket · TikTok
    
    12%
    
    All in
    
    Trail pant · TikTok
    
    Estimate
    
    Freight missing
    
    Merino crew · Wholesale
    
    Estimate
    
    Deduction open
    
4.  ### Cash. The low point, before it arrives.
    
    Dated receipts, payments and purchase orders run forward thirteen weeks. You see the low point and the buffer while a purchase order can still change.
    
    -   [Cash scenarios](<https://www.thekeating.co/use-cases/cash-scenarios/>)
    -   [PO cash check](<https://www.thekeating.co/use-cases/po-cash-check/>)
    
    Weekly low point Buffer $250,000
    
    -   Week 6 **$325,000**Above
    -   Week 7 **$290,000**Above
    -   Week 8 **$262,000**Close
    -   Week 9 **$205,000**$45,000 under
    
5.  ### Payables. Matched to what arrived.
    
    Supplier invoices are checked against the order and the receiving record. Short deliveries, duplicates and retailer deductions go to the person who can settle them.
    
    -   [Invoice matching](<https://www.thekeating.co/use-cases/invoice-matching/>)
    -   [Retailer deductions](<https://www.thekeating.co/use-cases/retailer-deductions/>)
    
    Invoices against receipts
    
    Invoice
    
    Billed
    
    Received
    
    Status
    
    4471 · Wax bars
    
    40
    
    30
    
    10 short
    
    4476 · Canvas wash
    
    24
    
    24
    
    Matched
    
    4480 · Hang tags
    
    5
    
    5
    
    Matched
    
    4471 · copy
    
    40
    
    —
    
    Held
    
6.  ### Monday. What changed, and who’s on it.
    
    A weekly brief from agreed definitions: what changed, how far to trust each figure, and an owner and a date for every decision.
    
    -   [Trading brief](<https://www.thekeating.co/use-cases/executive-trading-brief/>)
    -   [Management pack](<https://www.thekeating.co/use-cases/management-pack/>)
    -   [Governed answers](<https://www.thekeating.co/use-cases/governed-answers/>)
    
    Trading brief Monday
    
    TikTok Shop keeps 12%, not 31%.
    
    Changed
    
    Commission and returns, not ads
    
    Owner
    
    Head of growth · finance lead
    
    Revisit
    
    December 7
    
    Unavailable
    
    Returns by creator
    

### Built in your accounts. Yours to keep, whoever runs it.

Your data, definitions and playbooks live in accounts you control, on the tools you already pay for. If we ever part ways, the engine stays.

1.  [Your business](<https://www.thekeating.co/programs/commercial-reporting/#look-inside>)
2.  [Records](<https://www.thekeating.co/programs/commercial-reporting/#look-inside>)
3.  [Margin](<https://www.thekeating.co/programs/commercial-reporting/#look-inside>)
4.  [Cash](<https://www.thekeating.co/programs/commercial-reporting/#look-inside>)
5.  [Payables](<https://www.thekeating.co/programs/commercial-reporting/#look-inside>)
6.  [Monday](<https://www.thekeating.co/programs/commercial-reporting/#look-inside>)

## A new channel opens. Fernway’s first month on TikTok Shop.

Fernway sells direct and to about 60 outdoor retailers, which is about 8% of revenue. With the fall launch it opens TikTok Shop, paying creators 15% affiliate commission. Here is the finance engine at work, from the first payout to Monday’s brief.

2.  Week 1
    
    ### The first payouts didn’t equal sales.
    
    TikTok Shop paid $854 on a batch that sold $1,000 of product. The bridge explains every dollar: the discount, the refund, the tax and the fees.
    
    AI
    
    Explains each fee and refund line
    
    Rules
    
    Sums, tax and periods are calculated in code
    
    Your team
    
    Your accountant approves the mappings
    
    [Use case Reconcile every payout to the books, in the right month](<https://www.thekeating.co/use-cases/revenue-reconciliation/>)
    
    Payout bridge · TikTok Shop Batch of October 6
    
    Line
    
    Detail
    
    Amount
    
    Collected
    
    Sales less discount, plus shipping and tax
    
    $992
    
    Refund
    
    $100 of product, $8 of tax
    
    −$108
    
    Fees
    
    Platform and payment
    
    −$30
    
    Payout
    
    Matches the bank
    
    $854
    
    Net sales $820 + tax $64 − fees $30 = $854
    
3.  Week 2
    
    ### The dashboard said 31%. It was an estimate.
    
    Commission, fees and returns hadn’t landed, so the daily number ran on standard costs. It was labeled as an estimate, with the missing costs listed beside it.
    
    AI
    
    Drafts why the margin could move
    
    Rules
    
    Costs come from approved versions
    
    Your team
    
    Finance owns the definition
    
    [Use case Explain contribution margin by product and channel](<https://www.thekeating.co/use-cases/contribution-diagnosis/>)
    
    Contribution · Canvas field jacket Daily dashboard, week 2
    
    Channel
    
    Contribution
    
    Basis
    
    Shopify store
    
    31%
    
    Standard costs
    
    TikTok Shop
    
    31%
    
    Standard costs
    
    Affiliate commission
    
    Not in yet
    
    Lands at close
    
    Fees and returns
    
    Standard rate
    
    Trued up at close
    
    Labeled an estimate, with the missing costs listed
    

## Same sales. Different business.

One jacket, two channels, one October. The daily dashboard scores them the same. Switch views to see the closed books.

Whose viewWhat the daily dashboard showsWhat the closed books show

### Shopify store

Own store, paid ads

Net sales, October **$41,000**Unchanged

Sales this month Where each $41,000 went

-   Product **Not shared $17,000**
-   Fulfillment **Not shared $4,500**
-   Payment and platform fees **Not shared $1,200**
-   Returns **Not shared $2,000**
-   Ads **Not shared $4,000**
-   Affiliate commission **Not shared —**
-   Left over **Not shared $12,300**

Contribution Contribution

31% estimated 30%

Orders Left over

262 $12,300

Scale both Keep scaling

### TikTok Shop

Creators on 15% commission

Net sales, October **$41,000**Unchanged

Sales this month Where each $41,000 went

-   Product **Not shared $17,000**
-   Fulfillment **Not shared $5,200**
-   Payment and platform fees **Not shared $3,300**
-   Returns **Not shared $4,400**
-   Ads **Not shared —**
-   Affiliate commission **Not shared $6,150**
-   Left over **Not shared $4,950**

Contribution Contribution

31% estimated 12%

Orders Left over

262 $4,950

Scale both Fix commissions first

Which of your channels only looks profitable until the books close?

A finance review finds out on your own numbers, in two to four weeks.

[Start with a finance review](<https://www.thekeating.co/contact/?source=discovery&landing_path=%2Fprograms%2Fcommercial-reporting%2F&intent=discovery&cta_page=%2Fprograms%2Fcommercial-reporting%2F&cta_placement=content&program=commercial-reporting>) [Explain contribution margin by product and channel](<https://www.thekeating.co/use-cases/contribution-diagnosis/>)

2.  Day 31
    
    ### One settlement belonged to two months.
    
    It matched the bank to the penny. Revenue followed the order date, so $488 went into October and $748 into November, with no plug account.
    
    AI
    
    Flags the settlement that spans the month end
    
    Rules
    
    Splits it by the period rule
    
    Your team
    
    Your accountant owns the rule
    
    [Use case Reconcile every payout to the books, in the right month](<https://www.thekeating.co/use-cases/revenue-reconciliation/>)
    
    Settlement spanning October 31 Bank match to the penny
    
    Line
    
    Detail
    
    Amount
    
    Bank deposit
    
    Matches the settlement
    
    $1,236.00
    
    October
    
    Orders placed Oct 28 to 31
    
    $488.00
    
    November
    
    Orders placed Nov 1 to 3
    
    $748.00
    
    Plug account
    
    Nothing forced
    
    $0.00
    
    Period rule set by your accountant
    
3.  Week 5
    
    ### The books closed. TikTok Shop is 12%, not 31%.
    
    Commission, platform fees and returns landed. Every clearing balance was reconciled or given an owner, and the books closed in five days.
    
    AI
    
    Drafts the support for each balance
    
    Rules
    
    Tracks every balance to its evidence
    
    Your team
    
    The controller signs off the close
    
    [Use case Close the month with every balance supported](<https://www.thekeating.co/use-cases/month-end-close/>)
    
    October close
    
    **10 of 12**clearing balances reconciled, and two owned
    
    -   Shopify and TikTok Shop payouts
    -   Commission, platform fees and returns Trued up to actuals
    -   Clearing accounts No plug account
    -   Trail pant freight bill Owner: supply lead
    -   Merino crew deduction Owner: AR lead
    
    Closed in five days
    
4.  Week 6
    
    ### The winter order would have taken cash under the buffer.
    
    With a slower month and higher freight, the low point fell $45,000 under the $250,000 buffer in week 9 of the forecast. The Waxed field jacket order could still change, so Fernway split the deposit.
    
    AI
    
    Drafts the options and what each needs from the supplier
    
    Rules
    
    Recalculates the 13 weeks for each option
    
    Your team
    
    The finance lead decides, and supply confirms
    
    [Use case Forecast cash across inventory and growth plans](<https://www.thekeating.co/use-cases/cash-scenarios/>)
    
    Winter Waxed field jacket order Cash in week 9, by option
    
    -   Pay the deposit as agreed **$205,000**$45,000 under
    -   Collect $50,000 sooner **$255,000**$5,000 over
    -   Split the deposit in two **$305,000**$55,000 over
    
    Buffer $250,000 · the order can change for 10 more days
    
5.  Week 8
    
    ### Monday’s brief ended in owned decisions.
    
    It showed what changed and who owns each action. Commission on low-margin products drops to 10%, with a date to revisit it. One question came back “unavailable”, not zero.
    
    AI
    
    Drafts the story from the evidence
    
    Rules
    
    Figures come from agreed definitions, with an as-of date
    
    Your team
    
    Leaders decide, and every action gets an owner
    
    [Use case Run a weekly trading brief that ends in decisions](<https://www.thekeating.co/use-cases/executive-trading-brief/>)
    
    Trading brief Monday, November 23
    
    Commission on low-margin products drops to 10%.
    
    Changed
    
    TikTok Shop is 12% after the close, not 31%
    
    Decision · head of growth
    
    Commission to 10% · revisit Dec 7
    
    Last week · finance lead
    
    Order deposit split · low point $305,000
    
    Unavailable
    
    Returns by creator: not recorded yet, so not zero
    

## Every part, job by job. Start with one, or build the whole finance engine.

[All 11 use cases](<https://www.thekeating.co/programs/commercial-reporting/use-cases/>)

1.  ### Trusted records
    
    Every payout reconciled, in the right month.
    
    -   [Reconcile every payout to the books, in the right month](<https://www.thekeating.co/use-cases/revenue-reconciliation/>)
    -   [Close the month with every balance supported](<https://www.thekeating.co/use-cases/month-end-close/>)
2.  ### Margin
    
    Every cost in every margin, by product and channel.
    
    -   [Explain contribution margin by product and channel](<https://www.thekeating.co/use-cases/contribution-diagnosis/>)
    -   [Put true landed cost into every margin number](<https://www.thekeating.co/use-cases/landed-cost/>)
3.  ### Cash & commitments
    
    The low point seen weeks ahead, while it can still change.
    
    -   [Forecast cash across inventory and growth plans](<https://www.thekeating.co/use-cases/cash-scenarios/>)
    -   [Test a purchase order against your cash buffer](<https://www.thekeating.co/use-cases/po-cash-check/>)
4.  ### Payables & receivables
    
    Bills matched to what arrived, and deductions recovered.
    
    -   [Match supplier invoices to what actually arrived](<https://www.thekeating.co/use-cases/invoice-matching/>)
    -   [Recover retailer deductions that shouldn’t have been taken](<https://www.thekeating.co/use-cases/retailer-deductions/>)
5.  ### Reporting & decisions
    
    What changed, what to trust, and who’s on it.
    
    -   [Run a weekly trading brief that ends in decisions](<https://www.thekeating.co/use-cases/executive-trading-brief/>)
    -   [Produce the monthly management pack from verified figures](<https://www.thekeating.co/use-cases/management-pack/>)
    -   [Answer finance questions on agreed definitions](<https://www.thekeating.co/use-cases/governed-answers/>)

## Built around your team. Whoever closes the books today.

Your setupFounder-ledA lean finance teamAccountant-ledA finance and data team

### You’re the finance system, between everything else.

What we usually find

-   QuickBooks
-   An outsourced bookkeeper
-   Your cash spreadsheet

Where it falls back on people

Cash planning waits for a free evening, and nobody can say which channel makes money.

What we’d do

We set up the records and the margin view, run the Monday brief for you, and hand it over when you hire.

1.  Design
2.  Build
3.  Run

### A controller, and too many exports.

What we usually find

-   A controller
-   A2X
-   Triple Whale
-   Shopify and TikTok exports

Where it falls back on people

Each tool reports its own margin, and the reconciling happens in spreadsheets, by one person.

What we’d do

We agree one set of definitions, fix the seams between the tools, and build the exception queue around your controller.

1.  Design
2.  Build
3.  Equip

### A good accounting firm that closes the books.

What we usually find

-   An accounting firm
-   QuickBooks or Xero
-   A2X

Where it falls back on people

The books close on time, and the margin and the decisions still belong to nobody.

What we’d do

We work alongside your accountant. They keep the policy and the close, and we add cost-complete margin, cash and the Monday brief.

1.  Design
2.  Build
3.  Run

### A queue of questions, and models that wait.

What we usually find

-   NetSuite
-   Power BI
-   A planning tool

Where it falls back on people

Definitions drift between models, and answers wait behind the next model change.

What we’d do

We check what your BI and planning tools already do, add the missing definitions and tests, and build with your team so they own the models.

1.  Design
2.  Build
3.  Equip

## Yours to keep. Whoever runs it.

If your finance partner disappeared tomorrow, would the books still close and Monday’s brief still go out?

When the engagement ends, withA fractional CFOA reporting platformYour own engine

What leaves

The models in their head, and the commentary that explains them.

What stays

Last month’s deck.

What leaves

The definitions configured in their tool, and the setup that ran on them.

What stays

A CSV export.

What leaves

Nothing.

What stays

All of it: ledger, definitions, models and playbooks, in your accounts, with your team trained to run them.

1.  Design
    
    The finance engine, mapped to your channels, ledger and team.
    
2.  Build
    
    In your accounts, connected to your accounting and BI tools, documented.
    
3.  Run it, or hand it over
    
    We run it with you, or train your team and step back.
    

Fixed fees to design and build. Monthly to run, with part of the fee tied to agreed targets where the numbers support it.

## We’ve built the systems the numbers come from.

In prior roles, our operators built and ran the commerce, merchandising, supply-chain and back-office systems behind $2B+ in annual revenue. We know where a payout, a freight bill and a stock count each go wrong, and who has to sign off the fix.

-   **15+ years** building commerce products, teams and systems
-   **$2B+** in annual revenue supported by platforms led in prior roles
-   **Seven figures to acquisition** on technology built from scratch

[About the team](<https://www.thekeating.co/about/>)

## Start with a finance review. See which numbers hold up.

Fernway’s finance team hours last month, sorted by the work they went to

176 h

Analysis and decisions

30 h

Hours that changed what the business did

-   Margin analysis **18 h**
-   Cash planning **12 h**

Checking and fixing

40 h

Hours spent making numbers right

-   Payout exceptions **26 h**
-   Cost true-ups **14 h**

Assembling and rekeying

106 h

Hours spent moving numbers around

-   Export and reconcile **44 h**
-   Invoice entry **38 h**
-   The Monday deck **24 h**

**106 h a month,** 60% of the finance team’s month, spent assembling numbers instead of using them.

### Two to four weeks. A plan that’s yours.

We trace the payouts, costs and commitments for one channel, check what your accounting and BI tools already do, and map the engine you need. Every opportunity is sized and given a verdict: do first, validate, defer or leave alone.

-   Two to four weeks
-   Fixed fee, quoted after a short call, credited in full if we build it
-   The plan is yours, whoever builds it
-   The findings are yours whether or not we build

[Start with a finance review](<https://www.thekeating.co/contact/?source=discovery&landing_path=%2Fprograms%2Fcommercial-reporting%2F&intent=discovery&cta_page=%2Fprograms%2Fcommercial-reporting%2F&cta_placement=content&program=commercial-reporting>) [See a sample review](<https://audit.thekeating.co/demo/>)

## Know what you earned, and act on it. Start with a finance review.

[Start with a finance review](<https://www.thekeating.co/contact/?source=discovery&landing_path=%2Fprograms%2Fcommercial-reporting%2F&intent=discovery&cta_page=%2Fprograms%2Fcommercial-reporting%2F&cta_placement=closing&program=commercial-reporting>) [**Talk through your numbers**15 minutes](<https://cal.com/nkeating/15min>)

We reply within one business day.

---

Source: [https://www.thekeating.co/programs/commercial-reporting/](<https://www.thekeating.co/programs/commercial-reporting/>)

[Contact Keating & Co](mailto:nelson@thekeating.co) · [Agent guidance](https://www.thekeating.co/llms.txt)
