Skip to content
SchemeLedger

VAT Margin Scheme workflow for Shopify

VAT Margin Scheme records, built around your Shopify orders.

Turn confirmed acquisition costs and Shopify order data into a structured VAT Margin Scheme ledger — with clear review states, preserved calculation records and reporting-ready exports.

Built for Shopify merchants who use the VAT Margin Scheme.

Ledger

  • Omega SeamasterREADY
  • Rolex DatejustREVIEW REQUIRED
  • Cartier TankREADY
  • Replacement strapEXCLUDED

Acquisition

Acquisition price
€900.00
Source
Manual entry
Status
Confirmed

Calculation

Selling consideration
€1,000.00
Acquisition price
€900.00
Margin
€100.00
VAT on margin
€20.00

A workflow problem, not a formula problem

VAT margin records need more than a sales total.

Calculating VAT on a margin can be straightforward. Keeping the underlying product classification, acquisition price, Shopify order financials and historical calculation record aligned is where the operational work begins.

When those inputs live across Shopify, spreadsheets and manual records, it becomes harder to see which transactions are complete, which need review and what was actually used in a historical calculation.

Product classificationConfirmed acquisition priceShopify order dataSchemeLedgerStructured ledger

One structured workflow

From confirmed inputs to a preserved ledger record.

SchemeLedger brings the key steps of an item-level VAT Margin Scheme workflow together around your Shopify orders.

  1. 01Classify

    Confirm the product treatment

    You decide which products are managed under your Margin Scheme workflow and which are excluded.

  2. 02Record

    Confirm the acquisition price

    Add or import the purchase price, record its source and explicitly confirm it before it is used.

  3. 03Connect

    Use the Shopify order

    SchemeLedger reads the relevant order financials and reconstructs the selling consideration used by the workflow.

  4. 04Check

    Determine readiness

    Required inputs and transaction conditions are checked before a completed ledger entry can be created.

  5. 05Preserve

    Create the ledger snapshot

    READY transactions preserve the relevant inputs and calculation results as historical records.

  6. 06Report

    Review and export

    Use the stored ledger entries for reporting and CSV export.

Explore the full workflow →

Built to surface uncertainty

Know what's ready. Review what isn't.

SchemeLedger separates transactions with the required confirmed information from those that need attention before they become completed ledger records.

Instead of silently filling gaps or guessing through ambiguous transactions, unresolved cases remain visible for review.

  • READY

    Ready for the ledger

    The required confirmed inputs are in place and the transaction can be preserved as a ledger snapshot.

  • REVIEW REQUIRED

    Needs attention

    A required input or transaction condition needs to be reviewed before the record can be completed.

  • EXCLUDED

    Outside the workflow

    The product or transaction is not being processed under the configured Margin Scheme workflow.

Rolex Datejust 1601REVIEW REQUIRED
Acquisition price
€2,750.00
Confirmation
Missing
Resolve →

Connect both sides of the transaction

Connect what you paid with what you sold.

SchemeLedger combines a confirmed acquisition price with the relevant financial data from the Shopify sale to create the calculation inputs for the ledger.

Confirmed acquisition price

Use a supported source such as Shopify unit cost, manual entry or CSV import, and explicitly confirm the price before it is used by the workflow.

Acquisition price
€900.00
Source
Manual entry
Status
Confirmed

Order financials

Relevant Shopify order data is used to derive the selling consideration required for the transaction.

Order
#1048
Selling consideration
€1,000.00

Example

For a zero or negative margin, VAT on the margin is zero.

See the calculation workflow →
Selling consideration
€1,000.00
Acquisition price
€900.00
Margin
€100.00
VAT rate
25%
VAT on margin
€20.00
Taxable margin
€80.00

Historical records

A ledger that preserves what was calculated.

When a transaction becomes READY, SchemeLedger preserves the relevant calculation inputs and results as a historical ledger snapshot.

Reporting is based on those stored records rather than silently rebuilding historical results from later product settings.

Order #1048READY
Selling consideration
€1,000.00
Acquisition price
€900.00
Margin
€100.00
VAT rate
25%
VAT on margin
€20.00
Taxable margin
€80.00
Acquisition source
Manual
Calculation version
v1

Reporting and export

From individual records to usable reports.

Review READY ledger entries across the relevant period, summarize the stored figures and export the underlying records to CSV.

Reporting period01 Aug 2026 — 31 Aug 2026
READY records
84
Selling consideration
€76,840.00
Acquisition prices
€61,320.00
Positive margin
€15,520.00
VAT on margin
€3,104.00

More than a calculation in a spreadsheet.

A spreadsheet can calculate a margin. SchemeLedger is designed around the workflow that surrounds it: merchant-confirmed inputs, Shopify order data, review states, preserved ledger records and repeatable exports.

ConfirmConnectReviewPreserveReport

Clear responsibility

You make the tax decision. SchemeLedger structures the workflow.

SchemeLedger does not determine whether a product or transaction legally qualifies for the VAT Margin Scheme.

You remain responsible for confirming the applicable treatment, acquisition price, VAT rate and the evidence supporting those inputs.

SchemeLedger helps organize the resulting Shopify-based calculation, review and ledger workflow.

You confirm

  • Margin Scheme treatment
  • Acquisition price
  • VAT rate
  • Supporting evidence

SchemeLedger structures

  • Shopify order financials
  • Readiness states
  • VAT margin calculation
  • Ledger snapshots
  • Reports and CSV

Built around Shopify

A Margin Scheme workflow that starts with the store you already run.

SchemeLedger is an embedded Shopify app designed to work with your product configuration and Shopify order financials rather than requiring a separate sales workflow.

Bring structure to your VAT Margin Scheme workflow.

SchemeLedger is being prepared for launch on Shopify.