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
Orders=Payments=Revenue
Your question to the teamWhat was revenue in October?
Platform back endAll orders placed in October?
StripePayments settled for October?
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
Reporting“Management sees numbers that come with a caveat nobody has written down.”The report reads from the same reconciled data as the ledger.
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.
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.
Matching“The rules live in lookups and in people’s heads.”The matching rules are written down and versioned, not carried in a file.
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.”
“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.”