Use case · New in the CFO seat

New in the CFO seat, and the backend doesn’t match the books?

Your first weeks are for learning the business. Then you ask a simple question about last month, and every system gives you its own answer.

“When I joined, the accuracy of the data simply wasn’t there. Actuals fixed that. Now the data is accurate and that changes everything.”

VP Finance, Catawiki
A small figure at the entrance of a maze, with one green path through it

Week two

One question about last month. Three systems, three answers.

“In theory, keeping control over revenue is simple: customer orders = received payments = revenue in the books. But for companies with large (online) transaction volumes, the reality is more complex.”

Nart Wielaard, Accountant.nl, on the Actuals blog

Your question to the teamWhat was revenue in October?
  1. Platform back endAll orders placed in October?
  2. StripePayments settled for October?
  3. General ledgerRevenue booked for October?

    Ask the question and see what each system answers.

    Illustrative month.

    A test for your first month

    Pick one balance. Trace it back without asking anyone.

    “Pick one month-end balance and trace it back to source without asking anyone. Note the point where the trail stops. That point is your architecture’s real limit, and it is usually upstream of the ERP, not inside it.” From the Actuals blog

    Press Trace one step back until the trail stops.

    The balanceRevenue, October · €4,190,0050 of 5 links traced
    1. Reporting“Management sees numbers that come with a caveat nobody has written down.”The report reads from the same reconciled data as the ledger.
    2. Close“Buffer days are added, because the work cannot be finished in the time the process was designed for.”The close reads from the foundation, so the calendar shrinks.
    3. Posting“The ledger often receives summaries. [...] The link between the two is a reference someone typed by hand.”Each entry can be traced back to the transactions behind it.
    4. Matching“The rules live in lookups and in people’s heads.”The matching rules are written down and versioned, not carried in a file.
    5. Capture“A payment, an order and a refund can describe the same sale in three different ways, and nothing in the source system ties them together.”Every transaction carries a source reference that survives each hand-off.
    At each link, ask three questions

    Where was this record created? Which system holds its status today? Who decides how it is posted?

    The links and the quotes come from Peter Engel’s article “Excel is not your tool. It is your confession” on the Actuals blog.

    How it got this way

    Nobody decided to run the books in Excel. It happened in small steps.

    “Most finance teams never decide to run their books in Excel. It happens in small steps.”

    Peter Engel, Founder & CEO, Actuals

    Read “Excel is not your tool. It is your confession”
    finance-close-master.xlsx1 owner
    Revenue

    Add the workarounds one by one and watch the workbook grow.

    Illustrative workbook. The steps are quoted from the article.

    From the customer files

    They walked into it too. Here is what they found first.

    Catawiki · online marketplace
    The numbers didn’t line up.

    “Stripe data and the internal platform told different stories. Finance was closing the books with doubt instead of certainty.”

    • Transactions matched line by line, by hand
    • Reconciliation between order data, payment data and the data warehouse had become fragile
    A proof of concept within two days.

    Actuals connected Stripe and the internal platform to the data warehouse, automated journal entries and made mismatches visible on a daily basis.

    • Mismatches and bugs identified early
    • Month-end moves faster

    Switch between when the VP Finance joined and today.

    Read the Catawiki story
    Uwe van Rensburg
    Goboony · camper rental marketplaceCFO in August 2023, straight into a merger.

    Uwe van Rensburg walked into a cross-border merger with Yescapa. Ten countries, 347,000+ traveller bookings a year and €118M platform volume, across a patchwork of PSPs, currencies and VAT regimes.

    Watch the episode
    MultiTankCard · fuel, EV charging and transitWhen ‘close enough’ is no longer good enough.

    “A major concern was the uncertainty surrounding transaction reconciliation throughout the entire process. With millions of transactions happening each month, keeping everything in line was a daunting challenge.”

    Read the story

    Where to start

    Start with the matching. Then keep going.

    “We don’t settle for estimates; we match all orders, in any order database or transaction platform, with all possible payment, settlement and accounting data.”

    From actuals.io

    Real Financial ControlSix factors decide whether your numbers hold. Find your weakest link in six questions.
    1. 1
      Give every transaction a source reference

      One that survives each hand-off, from capture to report.

    2. 2
      Bring matching into the system

      So that the rules are written down and versioned rather than carried in a file.

    3. 3
      Post what can be traced

      The ledger receives entries that can be traced back to their detail.

    4. 4
      Let the close read from that foundation

      The calendar shrinks because the work is already done.

    5. ✓
      None of them requires replacing the ERP.

      “Most of them require agreeing, for the first time, which system owns which record.”

    6. The four steps follow the order of work in “Excel is not your tool. It is your confession”, Peter Engel on the Actuals blog.

    New in the seat? The 15-minute Actuals scan shows where your back end and your books first stop matching.