Rebuilding Cross-Border Management Accounts Across Amazon, VAT, and Export Tax Rebates
This cross-border e-commerce company operates through a Hong Kong entity. Its main markets are Europe and North America, and it sells through Amazon US, Amazon's European marketplaces, and its own DTC site. Annual sales are about RMB 150 million. Because the business spans several countries and regions, its problems are far more complex than domestic e-commerce. Sales data lives in Amazon Seller Central. Collections arrive through Payoneer, WorldFirst, and Hong Kong bank accounts. VAT in Europe is filed by different tax agents in each country. Export tax rebates depend on customs declarations and VAT fapiao (China's official tax invoice) from domestic suppliers. Logistics runs on a mix of FBA and third-party overseas warehouses. The client first hired a bookkeeping firm whose main practice was domestic trade. The firm did not understand cross-border e-commerce. It simply booked the bank statements and invoices the client provided and filed the taxes. The books could show how much money came in that month, how much was invoiced, and how much tax was paid. But the links between sales, collections, VAT, rebates, and inventory stayed a permanent muddle. Whenever the owner asked how much the US marketplace earned that month, how much VAT had actually been paid in Europe, or how much of the export tax rebate was still outstanding, finance had no answer.
Before Caigeek stepped in, the client's core problems sat at five levels. First, sales and collections never matched for long. Amazon holds back reserves and deducts refunds, FBA fees, and advertising charges before paying out, so the actual transfer differs widely from the sales shown in the dashboard. The client had no consistent way to explain the relationship between dashboard sales, money received, and recognizable revenue. Second, VAT filings were disconnected from the finance records. VAT in each European country was filed by a different agent, usually based on the platform's VAT transaction reports. Those reports use different currencies and cut-off conventions from the finance ledger. The client could not tell how much tax each country really owed, how much had already been paid, or whether it had overpaid or underpaid. Third, export tax rebate documents were hard to match. A rebate claim needs three matching documents: the customs declaration, the VAT fapiao for the purchase, and the applicable foreign-currency receipt documentation. The client's goods ship through FBA, and the quantities and amounts on the customs declarations often did not match the sales detail in Amazon's dashboard. Part of the rebate documentation could not be used, and eligible rebate amounts remained outstanding. Fourth, inventory and cost accounting were chaotic. There was no unified ledger for FBA stock, in-transit stock, overseas warehouse stock, and domestic reserve stock. There was also no settled rule on whether product cost should be tracked by batch or by weighted average. Gross margin on the financial statements swung up and down and did not reflect how the business was actually doing. Fifth, multi-currency, multi-entity cash flows were complex. Hong Kong dollars, US dollars, euros, and renminbi moved between accounts, and exchange-rate swings, conversion gains and losses, and inter-entity balances were nowhere clearly recorded. To the owner, the financial statements might as well have been written in code.
Caigeek rebuilt the client's finance system around three principles: start from the business, hold the compliance line, and serve decisions. Step one: fix the reporting currency and the entity structure. Together with the client we confirmed renminbi as the bookkeeping currency and the Hong Kong company as the reporting entity, with a related domestic export company handling procurement and export tax rebates. All foreign-currency transactions are converted at the rate on the transaction date, and foreign-exchange gains and losses are calculated at period end. Step two: a four-line matching model linking platform sales, collections, VAT, and rebates. Starting from Amazon's transaction reports and DTC site orders, we matched every sales order with its Payoneer or WorldFirst collection, FBA fees, advertising charges, and refunds. European sales were split by country and checked against each country's VAT filing. FBA shipment records were matched with customs declarations, purchase fapiao, and collection records, building a complete documentation chain for export tax rebates. Step three: proper inventory and cost accounting. Caigeek helped the client build continuously updated ledgers for FBA stock, in-transit stock, overseas warehouse stock, and domestic stock. Product cost is calculated on a weighted-average basis. FBA storage fees, long-term storage fees, and return-handling fees are accrued monthly. Inventory data is checked against Amazon's inventory reports every week, and differences are adjusted promptly. Step four: a rebuilt monthly reporting pack. We designed a report set specific to cross-border business: a P&L by marketplace, a VAT detail table, an export tax rebate progress table, an inventory turnover report, a cash-position table, and an exchange gain-and-loss statement. The reports show results and flag anomalies and risks, such as a country where the VAT filing diverges sharply from platform sales, or a shipment whose rebate has been pending for too long. Step five: tax compliance review and risk alerts. Every month, Caigeek's tax team reviews the completeness and accuracy of VAT filings and rebate documentation, warns early about possible late fees or penalties, and helps the client work with tax agents and customs to resolve issues.
After six months of steady work, the client's finance management moved from passive coping to active control. First, historical differences were largely explained. We reconciled two years of platform sales, collections, VAT, and rebate data and identified the main sources of the gap between sales and payouts: reserves, refunds, FBA fees, and advertising deductions. For the first time, the client knew where every sum of money had gone. Second, long-stranded rebate money came back. By completing the links between customs declarations and Amazon shipment records, we helped the client recover over RMB 1.2 million in export tax rebates that had been stuck because the paperwork was incomplete. Cash flow improved noticeably. Third, VAT filing discrepancies dropped to zero. With a country-by-country, month-by-month check of sales against VAT filings, the client went several consecutive filing periods without a single amount difference, and the tax agents' work became much more efficient. In addition, the marketplace-level P&L showed the true profitability of each market. We found that the US marketplace had the largest sales but also high advertising and FBA costs, so its net margin was actually lower than some smaller European marketplaces. The DTC site had expensive traffic, but stronger order values and repeat purchase rates. The client adjusted its market investment accordingly. Finally, the monthly close shrank from about 25 days to 12. Management now sees the full prior-month picture by the middle of each month, and decisions move much faster.
Results are based on client-provided and reconciled operating data for the stated engagement period. Individual outcomes vary by business model, data quality, implementation scope, and management actions.
“Cross-border books are genuinely complicated. Several finance hires and bookkeeping firms before them never managed to connect sales, collections, VAT, and rebates. Caigeek not only untangled our historical accounts but also built a management reporting system we can keep using. I read the monthly reports with confidence now.”
Client comment translated and lightly edited for clarity; company name withheld for confidentiality.
Facing similar problems in your business?
A Caigeek consultant can review your reporting needs and recommend a practical starting point.