Your ledger does not need every transaction

At high volume, the accounting system slows down because it processes every transaction itself. Match the detail before the ERP, post what is explained, and the ledger stays lean.

Peter EngelFounder & CEO · 2 min read

The ERP is slow again. A report that should take a moment keeps loading, the reconciliation is stuck halfway, and someone in the team suggests more server capacity.

That suggestion is understandable. It is also the most expensive way out. The accounting system is not slow because it is too small. It is slow because it is asked to process every single transaction directly.

Three ways out that make it worse

At high volume, most teams try one of three things. Each one moves the burden instead of removing it.

  • More capacity. Bigger servers or a system upgrade keep things running for a while, and drive up the operating cost.
  • Spreadsheets next to the system. The data that does not fit in the ledger gets handled outside it, which brings manual work and errors.
  • Waiting until month end. Reconciliation is pushed to the close, so for most of the month nobody can see the open balances or what sits in the suspense accounts.

Keep the detail out of the ledger

The ledger is the place for entries you can sign off on. It is not the place to match payments, fees and settlements line by line. That work can happen before the ERP, in three steps.

  1. Transactions are processed outside the accounting system. Orders, payments and settlements from each provider are matched there, every day.
  2. The journal entries are made from that matched data. The ERP receives entries it can trace back to the transactions behind them, without carrying every transaction itself.
  3. Open balances stay visible. Finance can see what is still open on any day, instead of waiting for the month-end report.

The ledger stays lean, the systems do not need an upgrade, and the records are ready for the audit without manual work.

How HelloPrint did it

HelloPrint is a global online printing platform that handles millions of transactions. Its finance team ran into system slowdowns when reconciling across multiple providers. Matching financial data to accounting entries took a lot of manual work, and open balances were hard to track.

With Actuals, the Adyen settlement batches are processed daily. The team can see which orders have been invoiced, and whether those invoices are recorded in NetSuite. Discrepancies are found quickly, so revenue does not slip through the cracks. Reconciliation became significantly faster, which shortened the month-end close. And the reports now serve as external validation of revenue completeness during audits.

Before you buy more capacity

Ask what your ledger actually has to hold. If the answer is every transaction, the cost will keep growing with your volume. If the answer is matched, explained entries, the ledger no longer has to grow with every order.

The Actuals scan takes 15 minutes and shows where your transaction data first stops matching, before it reaches the ledger.

In practiceYour PSP payout never equals your revenue. Can you explain every cent?

Written by

Peter EngelFounder & CEO