Industries · Subscription, D2C & e-commerce

It’s renewal morning. The payout is 50 cents short.

Every “buy now” starts a chain: a payment, a fee, a delivery, sometimes a refund or a chargeback weeks later. In a subscription business that chain starts again every month, for every customer. Reconciliation has to follow every link of it.

Settlement · PSP A · order 12345€0.50 short
Expected from PSP A€77.80
Received at the bank€77.30
Difference−€0.50
  1. orderOrder 12345, paid by card€100.00
  2. paymentCaptured at PSP A€100.00
  3. feeProcessing fee, booked against the sale−€2.50
  4. refundPart of the order returned to the customer−€20.00
  5. feeFee returned by the processor on the refund+€0.30
  6. expectedSettlement due after the refund€77.80
  7. bankReceived at the bank€77.30
  8. flag€0.50 unexplained. Flagged against this transaction and this journal, with an owner.−€0.50

Press the button to see the same settlement one level deeper.

Illustrative example from the Actuals blog, not a customer case.

Refunds and chargebacks

Some money arrives months late. It still belongs to the month it came from.

“Chargebacks are tracked back to the originating transaction even when they arrive weeks or months later.” From the Actuals FAQ

JanuaryClosed

  • Renewal · sub-4471 · card€29.00
  • Renewal · sub-4472 · card€29.00
  • New plan · sub-5108€12.99

FebruaryClosed

  • Renewal · sub-4471 · card€29.00
  • Renewal · sub-6033 · PayPal€9.99
  • Renewal · sub-5108€12.99

MarchClosed

  • Renewal · sub-4471 · card€29.00
  • Webshop order 88120€58.00
  • Renewal · sub-6033 · PayPal€9.99

AprilOpen

0 of 3 traced

Click a late arrival in April to trace it back to the month it came from.

Illustrative months and amounts. “For prior-period refunds, adjustments are handled automatically without reopening closed books.” From the Actuals FAQ.

Three subscription businesses

Finance is not the only team that opens Actuals. Pick your team and see what it does.

Showing what Actuals does for Finance in each story. Pick another team to compare.

Tech rental subscriptions Grover

“If Actuals were to break down, we would need two to three additional full-time employees to handle reconciliation manually.”

Payments Associate Manager, Grover
Read the Grover story
Digital top-ups in around 160 markets Recharge.com

“Now that Actuals automates reconciliation, our team can focus on resolving issues instead of getting bogged down in the process itself.”

Freddy Dijkman, CFO, Recharge.com
Read the Recharge.com story
Digital learning subscriptions FutureWhiz

Users do not log in to Actuals every day, and the platform is still considered critical. The moderate login frequency reflects trust in the data. Without that trust, far more time would go to checking numbers around month end.

From the FutureWhiz case
Read the FutureWhiz story

Build it yourself?

The script works at 10,000 transactions. Then the edge cases arrive.

“A script that works at 10,000 transactions often fails at 100,000.” Each edge case below is a separate incident, found one at a time. From actuals.io.

  • Race conditions
  • Timezone drift
  • Partial settlements
  • Multi-currency rounding
  • Late chargebacks

“A refund processes before the original payment settles. Your matching logic flags it as an error. Happens to 0.1% of orders but it’s 1,000 orders a month.”

Illustrative example from the Actuals blog on build vs buy

One honest question

Is this data integration your core competitive advantage, or is it infrastructure for your core advantage?

Choose the answer that fits your company. The advice changes with it.

The question and both answers come from the Actuals blog. The subscription company is an anonymous client.

Your payment stack

Which payment providers do you run? Tick them and see where to start.

0 providers ticked

Tick the providers you use today.

Running subscriptions or a webshop at volume? The 15-minute Actuals scan shows where your numbers first stop matching.