Independent Ecommerce Settlement Verification · UK & US
For accounting firms: the clearing account that will not close, despite everything the integration says. · For forensic and insolvency practitioners: an independent reconstruction of the settlement chain across every revenue channel, ready for the working papers.
The settlement chain between an ecommerce platform and the bank account is undocumented in most professional engagements. Integrations confirm the sync. Platforms confirm the payout. Neither confirms what the bank actually received across every channel, nor why any difference exists.
LFG reconstructs that chain from raw source exports and the bank statement, independent of the accounting ledger and integration layer. Shopify, PayPal, Etsy and Amazon are reconciled simultaneously, and the result is a structured evidence bundle that a reviewing professional can open, interrogate, and file.
Currently accepting engagements from qualifying firms in the UK and US.
Bank statement composition
Also classified
Shopify match status (360 payouts)
Shopify batches gross sales, deducts fees, nets refunds and deposits a single consolidated figure into the bank days later. PayPal, Etsy and Amazon each settle on their own schedules with their own fee structures and timing. The amount that arrives in the bank almost never matches any figure in the platform's reporting.
Standard integrations push data into the ledger but cannot verify whether the net deposit ties back to the underlying transactions. The accounting software says one thing, the integration layer says another, and each platform's own reporting says something different again. Clearing accounts accumulate unexplained differences across every revenue channel simultaneously.
The problem is not that money is missing. The problem is that certainty is missing.
Until it is reconstructed independently from the source data, it cannot be established at all.
We reconstruct the settlement chain from raw source exports for every platform the merchant uses: Shopify, PayPal, Etsy, Amazon, against the bank statement. We do not connect to any platform, to the bank, or to the accounting software. The result is not influenced by existing ledger errors, broken integrations, or misconfigured sync tools.
Each engagement produces a structured evidence bundle containing:
Whether the result confirms the settlement chain is sound or isolates specific exceptions, you receive documented certainty rather than spreadsheet guesswork.
Approximately $6.5 trillion flows through ecommerce platforms annually. Shopify, PayPal, Etsy, Amazon: each platform records gross sales, deducts fees, processes refunds and batches the net result into payouts that land in the merchant's bank days later, on different schedules, in different amounts, with different reporting formats.
No tool on the market independently verifies whether those payouts reconcile to cash received across the complete revenue stack. Integration tools post data into the ledger. When the ledger drifts from cash reality, the accountant is left reconciling three conflicting sources manually: the platform, the integration layer and the bank.
Ledger Forensics Group was built to close that gap. We take the raw platform exports and the bank statement, reconstruct the settlement chain for every channel provided, and return a structured evidence pack that documents what matched, categorises what did not, and leaves nothing unresolved.
We work as a specialist subcontractor, instructed by accounting firms, forensic practitioners, insolvency practitioners, and due diligence teams. We do not access the accounting software. We do not provide audit opinions or legal conclusions. We provide the settlement evidence so the instructing professional can act with certainty.
Understanding the Service
Shopify, PayPal, Etsy and Amazon are fully supported with dedicated reconciliation modules. Additional platform modules are in the development pipeline and will be coming online soon. If you have a specific requirement please advise and we will do everything we can to accommodate you.
Our bank statement composition analysis also identifies additional platforms in the bank data, even where no source export has been provided for those platforms.
Before we reconcile platform data, we classify every transaction in the bank statement by source. Every credit and every debit is categorised across 19 deterministic classification categories covering Shopify, PayPal, Etsy, Amazon, Stripe and other platforms. The classification covers not just revenue deposits but also platform-related costs: loan repayments, subscription fees, marketplace fee collections, lending repayments and outbound payments. Everything that does not match a known platform pattern is classified as non-platform activity.
This means the instructing firm sees a complete picture of all platform-related activity flowing through the account — both revenue in and costs out — before any reconciliation begins.
Platforms for which no source exports have been provided are still identified and quantified in the bank data: deposit counts, totals and the classification basis are all documented. This shows the instructing firm exactly what remains unreconciled and whether additional source exports should be obtained.
The classification categories are maintained and updated as new platform patterns are identified. If the bank statement contains transactions from a platform not yet in the classification library, these are flagged for review as part of the engagement.
Every matched payout is assigned a match status based on the strength of the match. In every case, the amount is an exact match. The system does not estimate, round, or force partial matches.
CLEARED: Exact amount matched, expected settlement window, unique one-to-one match, payout status confirmed. No further review ordinarily required for the limited purpose of confirming the payout-to-deposit linkage.
REVIEW: Exact amount matched, but either the timing fell outside the expected window or multiple candidates existed and the match was resolved by date proximity. Professional review recommended.
INVESTIGATE: Exact amount matched, but with significant date distance or a non-standard payout status. Investigation required.
Items that do not match at any level are not forced. They are removed from the matching pool entirely and isolated in the exception register with a categorised reason and a recommended action.
In validated cases, between 93% and 95% of payouts resolve at RECONCILED. The system is designed to never produce a false positive at RECONCILED. When in doubt, the item is downgraded or isolated, never promoted.
Match status labels are jurisdiction-aware. UK deliverables use RECONCILED in place of CLEARED. All other labels are the same across jurisdictions. The naming conventions are tailored to established professional terminology in each jurisdiction.
No. We do not connect to any third-party platforms, to the bank, or to the accounting software. We work from the raw source files independently. The result cannot be influenced or contaminated by existing ledger errors or integration misconfigurations.
These tools automate the posting of platform transactions into your accounting software. They solve the daily sync problem. We solve a different problem: when the sync has produced data in the ledger but the clearing account still will not tie to the bank, when historical books need reconstruction from scratch, or when the case requires independent evidence from raw source data that no integration has touched.
Many of the firms that instruct us use A2X or similar tools for their daily workflow. They instruct us for the cases those tools cannot resolve.
The system supports 30 currencies: GBP, USD, EUR, CAD, AUD, NZD, JPY, CNY, HKD, SGD, CHF, SEK, NOK, DKK, PLN, CZK, ZAR, BRL, MXN, INR, KRW, THB, MYR, IDR, PHP, TWD, AED, SAR, ILS and TRY.
The evidence pack and working paper schedules render in the currency of the engagement. We work with settled amounts in the payout currency as reported by the platform and the bank. Multi-currency settlement analysis — where a merchant receives payouts in more than one currency — is available on request.
How It Works
No. The settlement review works from raw platform exports and the bank statement only. No accounting software access is requested or required.
We need the source export from every platform you want reconciled. The bank statement and at least one platform export are the minimum requirements. For a multi-channel merchant, the more platform exports you provide, the more complete the picture.
Our bank statement composition analysis classifies every transaction by source regardless of which exports are provided, so even before reconciliation begins, you can see exactly which platforms are active in the account and how much is flowing through each one. Platforms where no source export is provided are documented with deposit counts and totals, but remain unreconciled until the relevant export is obtained.
If exports are not available at the point of instruction, they can be added in a follow-up engagement.
We support major UK and US bank exports in CSV and XLSX formats. If we have not processed a specific bank format before, we build support as part of the engagement.
Turnaround depends on case complexity and file quality. Most eligible cases are delivered within 48 hours of receiving complete, validated source files. We confirm expected timing at the point of engagement.
Quality and Accuracy
A standard engagement applies over 70 discrete validation checks, classification rules and reconciliation tests across the full pipeline from input integrity through platform classification, settlement reconstruction, deterministic matching and exception categorisation before a single result is published.
Every match is tested against multiple parameters before a status is assigned: exact amount to the penny (cent), date proximity against defined settlement window thresholds, one-to-one uniqueness and payout status confirmation. No rounding, no estimation, no partial matches.
The bank classification includes a safety net that flags suspect patterns and large unclassified credits for manual review before delivery. Items that do not match any known platform pattern are classified as non-platform activity and documented in the bank statement composition.
The full methodology is disclosed as part of the evidence pack: procedures performed, matching rules applied, exception categories and their definitions, coverage qualification logic and all limitations. Every input file is registered with a cryptographic hash (SHA256) at intake. Every run produces a versioned manifest recording engine version, source file references, hashes, validation outcomes and output artifacts. The same source files processed through the same engine version will always produce the same result.
In validated cases, between 93% and 95% of payouts resolve at RECONCILED. The system is designed to never produce a false positive at RECONCILED. In the unlikely event that a parameter is uncertain, the item is downgraded or isolated and clearly specified in the evidence bundle and reports.
Note: The methodology described here and disclosed in the deliverables represents the evidentiary output layer. The underlying verification architecture is a proprietary codebase developed and wholly owned by Ledger Forensics Group. It is not licensed, not open-source, and not dependent on any third-party reconciliation platform.
It is categorised by reason: timing gap, amount not found in bank data, failed payout, negative net period, or incomplete status. Each unmatched item is assigned a recommended action. The exception register documents every unmatched item so the instructing firm knows exactly what requires attention and why.
No. This is a specialist settlement review, not an audit, attestation, or expert report. We do not provide an audit opinion or any form of assurance.
We operate as a specialist subcontractor, instructed by the firm, not by the merchant. We do not access, rely upon, or post entries to the client's accounting system. The review is performed entirely from raw source exports and the bank statement, structurally independent of the ledger and integration layer. This separation means the output cannot be influenced by existing accounting errors, broken integrations, or the practices of the parties involved.
The evidence pack is designed against AICPA SSFS No. 1 forensic services expectations and UK CPR Part 35 expert reporting conventions, structured so that a practitioner with no prior connection to the engagement can review and file the work without rewriting it. The instructing professional retains full responsibility for all conclusions, materiality judgements, accounting treatment and downstream use.
The evidence pack is not prepared as expert evidence under CPR Part 35 (UK) or as expert testimony (US). However, the methodology is deterministic, the inputs are cryptographically hashed and the output is reproducible. If the engagement purpose changes to dispute or investigation support, the scope can be re-papered to reflect applicable evidential requirements. The instructing professional should obtain advice on disclosure and privilege before distributing the deliverables in the context of proceedings.
Working With Us
Reviews are typically instructed by accounting firms, forensic accountants, insolvency practitioners, due diligence specialists, M&A brokers and quality of earnings providers. We do not engage directly with the merchant unless instructed to do so by the firm.
For accounting firms managing portfolios of ecommerce clients, the engagement is typically instructed on a per-client basis. Firms with recurring needs can establish a standing instruction arrangement after the first engagement is complete, reducing the scoping overhead for subsequent cases.
For forensic and insolvency practitioners, the engagement is typically case-specific and may be scoped to a particular analysis period or set of platforms relevant to the matter. The evidence pack is structured for inclusion in working paper files and can accompany the practitioner's own report to courts, creditors, or other stakeholders.
For due diligence and quality of earnings teams, the engagement is typically instructed as part of a transaction support workstream. The evidence pack verifies the settlement chain across all revenue channels independently of the target's own records, providing the acquirer's advisers with a source-led view of what actually settled.
We provide the verified settlement data that your firm needs to do its work with certainty. For accounting firms, that means a clean reconciliation across every platform channel so the month-end close is based on documented evidence rather than spreadsheet estimates. For forensic and insolvency practitioners, it means an independent reconstruction of the company's revenue position across all channels that can go straight into your working papers. For due diligence and QoE teams, it means verified settlement data across the merchant's full revenue stack that supports your financial analysis.
Your firm instructs us, provides the source files and receives the evidence bundle. We supply disambiguated data for your firm to apply professional judgement, set the materiality thresholds and decide what the findings mean for your client. The evidence pack is structured so the reviewing professional can open it cold and understand the work without a walkthrough.
Yes. Each client engagement is separately scoped and delivered. Firms with recurring settlement review needs across their client portfolio can establish a standing instruction arrangement after the first engagement.
A report confirming the settlement chain is sound is worth the same as one that identifies exceptions. The fee is for documented certainty, not for the nature of the findings. A clean result means you can file the evidence and close the matter with confidence.
We treat every engagement as if it will be reviewed by your firm's compliance team. Source files are transmitted via TLS encryption and received through a controlled intake path. All processing takes place in a controlled, encrypted local environment: no cloud databases, no shared hosting, no third-party processing platforms, no offshore teams, no subcontracting of data handling. Access to source files is restricted to the processing operator only.
Every input file is cryptographically hashed (SHA-256) at registration, so the integrity of the source data can be independently verified at any point. Each processing run produces a formal manifest recording engine version, source file references, validation outcomes and a complete output artifact register.
Raw source exports are purged within 48 hours of evidence pack delivery by default. Retention can be extended by explicit written instruction from the instructing firm, for example where a rerun with extended bank coverage is anticipated. Purge completion is recorded against the case reference. Deliverables are retained separately as engagement outputs and are not subject to the 48-hour purge.
If your firm requires a data handling summary for vendor onboarding, a client authorisation template for your engagement files, or a data processing confirmation for compliance review, these are available on request.
Yes. We can provide a demonstration evidence pack showing the full structure: multi-platform reconciliation, bank statement composition, exception register and working paper schedules. Submit the eligibility form and note that you would like to review a sample, or reply to any communication from us.
Getting Started
We review your enquiry and confirm eligibility within 2 business days. If the case fits our current review scope, we will contact you with next steps including file requirements and scheduling.
We are accepting a limited number of settlement review engagements from qualifying firms. Complete the form below and we will confirm eligibility and next steps within two business days.