
Automated Reconciliation: Building a 3-Way Match Between Marketplace Orders, 3PL Shipments & Accounting
18 January 2026
When Customs Valuation Goes Wrong: Forensic Steps to Challenge a Reassessment and Save Duty
18 January 2026

OUR GOAL
To provide an A-to-Z e-commerce logistics solution that would complete Amazon fulfillment network in the European Union.
In the fast-paced world of cross-border e-commerce, the physical movement of goods is often the primary focus. You track the vessel, you monitor the warehouse arrival, and you celebrate when stock hits the digital shelves. However, behind every pallet that crosses a border lies a trail of data that is just as vital as the inventory itself. For many business owners, the realization that logistics and accounting are inextricably linked only hits during a VAT audit or year-end closing.
If your bookkeeping doesn't accurately reflect your customs entries, you aren't just looking at a messy spreadsheet; you are looking at potential financial penalties and missed tax reclaim opportunities. Accountants are notoriously precise, and when it comes to imports into the EU, they require specific data points to ensure your "books" match the reality of the Union Customs Code (UCC).
At FLEX. Fulfillment, we understand that a truly seamless supply chain doesn't stop at the warehouse doors—it extends into your back-office efficiency. To help you bridge the gap between your freight forwarder and your tax advisor, we have compiled the eight essential customs fields that your bookkeeping system must capture.
The Critical Intersection of Logistics and Ledger
Before diving into the specific fields, it is important to understand why this data matters. When goods enter the European Union, they undergo a "release for free circulation." This process generates a Customs Declaration (often a SAD - Single Administrative Document). This document is the legal birth certificate of your imported stock.
Accountants need this data to reconcile three things: the value of your inventory, the amount of duty paid (which is a cost of goods sold), and the Import VAT (which is often a reclaimable asset or a postponed liability). Without these eight fields, your financial statements are essentially guesswork.
1. The Movement Reference Number (MRN)
The MRN is the single most important identifier in the world of modern customs. It is a unique registration number assigned by the customs authority to every single import or export declaration. Think of it as the social security number for your shipment.
Why Accountants Ask For It: Your accountant needs the MRN to verify that the goods actually entered the country legally. In many EU jurisdictions, the MRN is the key required to download the official "VAT Certificate" (such as the C79 in the UK or the equivalent digital statement in Poland or Germany). Without a valid MRN linked to a transaction, you cannot legally reclaim Import VAT.
How to Record It: Every bookkeeping entry for an import purchase should have the MRN in the reference field. This creates a digital audit trail that allows an auditor to jump from your bank statement to your ledger, and finally to the customs portal, in seconds.
2. The Harmonized System (HS) Code
The HS Code (or Commodity Code) is a six-to-ten-digit number that classifies exactly what your product is. It determines the rate of duty you pay, whether you need specific licenses, and if there are anti-dumping measures in place.
Why Accountants Ask For It: Accountants use HS codes to validate the "Duty" expense on your Profit & Loss statement. If you are importing organic supplements at a 0% duty rate, but your HS code suggests you are importing processed chemicals at 6.5%, your tax liability will be incorrect. Furthermore, consistent HS coding is vital for inventory valuation.
The precision of your classification directly affects your bottom line. Misclassification can lead to retroactive duty bills that can wipe out a year’s worth of profit.

3. Transaction Value and Currency
While it seems obvious to record what you paid your supplier, customs bookkeeping requires a bit more nuance. You must capture the "Customs Value," which might differ from the "Invoice Value."
Why Accountants Ask For It: The customs value is the basis upon which duty and VAT are calculated. It usually includes the cost of the goods plus shipping and insurance to the EU border (CIF - Cost, Insurance, and Freight). Your accountant needs to see the breakdown of the net price in the original currency and the exchange rate used by customs at the time of entry.
The Complexity of Exchange Rates: Customs authorities use their own monthly "Customs Exchange Rates," which often differ from the daily market rate or your bank's rate. Your bookkeeping must capture the rate used on the customs declaration to ensure the VAT recorded matches the VAT actually paid at the border.
4. Incoterms (International Commercial Terms)
Incoterms like EXW, FOB, or DDP define who is responsible for costs and at what point the risk transfers from the seller to the buyer.
Why Accountants Ask For It: This field tells the accountant how to treat the shipping costs. If you buy on DDP (Delivered Duty Paid) terms, the supplier is supposed to handle the tax. If you buy on FOB (Free On Board), you are responsible for the import costs from the port of origin.
If your bookkeeping doesn't specify the Incoterm, your accountant won't know if a freight invoice from a carrier is a legitimate business expense or something that should have been covered by your supplier. It is the "who pays what" roadmap for your ledger.
5. Country of Origin (COO)
The Country of Origin is not necessarily where the goods were shipped from, but where they were manufactured or underwent "substantial transformation."
Why Accountants Ask For It: The COO is the trigger for "Preferential Duty Rates." For example, if you are an EU business importing from the UK or a country with a Free Trade Agreement (FTA), you might pay 0% duty—but only if you have a valid Proof of Origin.
Accountants need to store this data to justify why no duty was paid. During a tax audit, if you claimed 0% duty but cannot provide the Country of Origin data in your bookkeeping records, the authorities can demand the full duty amount plus interest.
6. Import Duty Amount
Import Duty is a "sunk cost." Unlike VAT, you generally cannot get this money back from the government. It is a tax on the consumption of foreign goods.
Why Accountants Ask For It: Duty must be capitalized into the cost of your inventory. If you buy a widget for €10 and pay €1 in duty, your "Landed Cost" is €11. If your bookkeeping simply throws duty into a general "Tax" category, your gross margin calculations will be wrong.
Accurate bookkeeping distinguishes between recoverable VAT and non-recoverable Duty. This distinction is what separates a profitable e-commerce brand from one that is bleeding cash through invisible costs. Using a structured fulfillment partner ensures that these costs are clearly delineated in your shipping documentation.
7. Import VAT (Paid vs. Postponed)
VAT is usually the largest cash outflow during an import. In many EU countries, you can now use Postponed VAT Accounting (PVA), which allows you to account for the VAT on your return rather than paying it upfront at the border.
Why Accountants Ask For It: This is the field that causes the most friction. If you paid the VAT upfront, the accountant needs the receipt to claim it back. If you used postponed accounting, they need the "Postponed VAT Statement" to perform a "reverse charge" entry in your books.
The Risk of Double Counting: Without clear fields in your bookkeeping to mark VAT as "Paid" or "Postponed," it is incredibly easy to accidentally pay the tax twice or—worse—fail to report it, leading to heavy fines. Consistency here is the hallmark of a professional e-commerce operation.
8. The EORI Number of the Importer
The Economic Operators Registration and Identification (EORI) number is your business's ID for all customs procedures in the EU.
Why Accountants Ask For It: Every customs entry must be linked to your EORI. Sometimes, freight forwarders mistakenly use their own EORI or an old number, which means the VAT is not legally yours to reclaim. Your accountant will check that the EORI on the customs entry matches the EORI on your VAT registration.
Think of the EORI as the anchor. If the anchor is missing or wrong, the entire customs declaration is useless for your bookkeeping.
The Role of Technology in Modern Compliance
The days of manually typing these eight fields into a ledger are fading. For a growing e-commerce brand, the volume of shipments makes manual entry a recipe for disaster. This is where the synergy between your fulfillment provider and your accounting software becomes a competitive advantage.
When you work with FLEX. Fulfillment, we prioritize the integrity of your documentation. By ensuring that every shipment is accompanied by the correct commercial invoices and packing lists, we help facilitate a smoother declaration process. While we handle the physical "heavy lifting" of your products in the EU, our organized approach to logistics data makes it significantly easier for your accountants to extract the "digital heavy lifting" required for compliance.
Common Pitfalls: What Happens When Data is Missing?

If your bookkeeping ignores these eight fields, you are essentially flying blind. We have seen businesses face several avoidable issues:
VAT Reclaim Rejections: The tax office denies a €20,000 VAT reclaim because the MRN couldn't be produced.
Inaccurate Pricing: A brand thinks they have a 30% margin, but because they didn't factor in the HS Code-based duty, their actual margin is only 22%.
Audit Anxiety: A standard customs audit becomes a three-month nightmare because the EORI and Country of Origin data weren't archived properly.
Logistics is more than just moving boxes from point A to point B. It is the movement of value. And where value moves, the taxman follows. By capturing these eight fields, you aren't just pleasing your accountant; you are building a resilient, scalable business.
How to Streamline Your Customs Bookkeeping
To make this process "audit-proof," consider the following steps:
Standardize Your Folder Structure: Every shipment should have its own folder containing the Invoice, Packing List, and the final Customs Declaration (SAD).
Use Digital Tools: Use OCR (Optical Character Recognition) software that can "read" customs documents and push the MRN and Duty amounts directly into your accounting software.
Audit Your Freight Forwarder: Once a month, ask your forwarder for a "Statement of Entries" to ensure you haven't missed any shipments in your bookkeeping.
Communicate with your Fulfillment Partner: Ensure your fulfillment center, like FLEX. Fulfillment, has the correct HS codes in their system. This ensures that any outgoing or incoming international movements are handled with the same level of data integrity.

In the modern EU marketplace, compliance is not a hurdle; it is a foundation. The "8 fields" represent the minimum viable data set required to keep your business safe, transparent, and profitable. By treating your customs entries with the same respect as your sales figures, you ensure that your growth is built on solid ground.
As you look to expand your reach across European borders, remember that the quality of your logistics partner is often reflected in the quality of your data.
At FLEX. Fulfillment, we don’t just store and ship your products; we support the ecosystem that allows your business to thrive—from the warehouse floor to the accountant’s desk.








