Help

Export your administration for your accountant

From Reports, generate a full administration file as Excel or CSV for any period you choose: one row per watch with purchase, sale, VAT, margin, and profit, in the language and currency you pick.

Got a question about this guide? Use Open to continue it in Claude or ChatGPT.

Your accountant usually wants a clean ledger, not screenshots of a dashboard. Reports can produce one. The accountant export builds a full administration file, as Excel or CSV, covering the period you choose, with one row per watch and every figure your bookkeeper needs: purchase details, sale details, VAT, margin, and profit.

Create the export

Open Reports

Click Reports in the top navigation.

Set the period

Use the period picker to choose the range the file should cover (see choose the period below).

Open the export dialog

Click Export in the top-right actions. The Export for accountant dialog opens.

Choose what to include

Pick the dataset: All items, Sold items, or Purchased items. You can select more than one, and at least one must be on. Sold items are filtered by sale date, purchased items by purchase date.

Pick format, language, and currency

Choose the format, Excel (XLSX) or CSV. Set the language for the file's column headers and labels, and the currency all amounts are shown in. These are independent of the language you use the app in, so you can hand your accountant a file in their language and currency.

Download

Click download. The file is named like worldwatch-administration-de-DE-EUR-2026-07-09.xlsx, so the language, currency, and date are clear at a glance.

Choose the period

The export covers the same period selected on the Reports page. The picker offers rolling ranges, Last 30 days, Last 90 days, and Last 12 months, plus calendar periods grouped by year: a Full year for each year and its quarters (Q1 to Q4), newest first. Only quarters that have already started appear, so you never pick an empty future quarter.

What is in the file

Each watch that falls in the period is one row. The columns read left to right as a ledger:

  • The watch: SKU, status, brand, model, reference, condition, and description.
  • The purchase: purchase date, supplier and their VAT number, purchase invoice number and date, net, VAT and gross amounts, the input VAT regime, and any landed costs.
  • The sale: sale date, disposal type, buyer with their VAT number and country, sales invoice number and date, tax scheme, and net, VAT rate, VAT, and gross amounts.
  • Margin and profit: the margin, its VAT breakdown for margin-scheme sales, the net margin, and the profit with its percentage.
  • Currency and free-text notes close each row.

Margin-scheme sales are broken out. When a sale runs under the margin scheme, the file separates the margin, the VAT due on that margin, and the net margin, so your accountant sees the VAT owed on the margin rather than on the full sale price. The margin VAT rate is taken from the buyer's country. See the margin scheme.

Language and currency

You pick both in the dialog, and neither has to match the language you browse in. Column headers and the labels inside cells (statuses, tax schemes, supplier and buyer roles) are translated into the language you choose. Every amount is converted to the currency you choose using current exchange rates and rounded to two decimals, so the whole file is in one currency.

If nothing exports

If the file would be empty, the dialog tells you that no items match the selected filters. Widen the period, or turn on another dataset (for example add Purchased items), and try again.

On this page