Daily Takings
You can access this section from the left menu Accounting >> Daily takings.
In this section, daily sales are recorded month by month, grouped by tax jurisdiction and VAT rate.
The daily total shows the gross revenue net of customer refunds. Refunds are deducted on the date the refund is issued to the customer.
Takings are recorded on the basis of the date the actual movement of money takes place and not on the order date. ZonWizard calculates takings based on the Amazon VAT transactions report. Daily takings are calculated on the transaction completion date.
Download takings
By accessing the section Accounting >> Daily takings in the top right corner in the download button, you can download the following takings reports:
PDF Report: daily takings register for the selected month in PDF format
XLS Report: daily takings register for the selected month in Excel format
XML Report: this report generates daily takings in XML electronic format. A ZIP file containing one XML file for each day of the month will be downloaded
XLS Transactions: detailed report of all transactions making up the daily takings register for the selected month
The XML takings report can be used to upload takings into your accounting management system.
External sales management
If you sell on platforms not supported by ZonWizard, you can manually add sales from these marketplaces to include them in the tax reports generated by the software.
In this section, you can perform the following operations:
Upload external sales
You can upload external sales from the section Accounting >> Daily takings >> + >> Upload external sales
First, download the template by clicking on the download icon.
Then, you'll need to fill out the template with the following information for each sale:
Payment date: in Excel date format
Order ID: order identification code
Product ID: unique product code
Quantity: number of items sold
Product price: total price of products including VAT
Shipping price: shipping price including VAT
Currency: ISO currency code (e.g., EUR, GBP, USD).
Shipping country code: ISO code of the departure country of shipment (e.g., DE, FR, ES)
Arrival country code: ISO code of the destination country of the shipment (e.g., DE, FR, ES)
Marketplace: name of the marketplace, only one of the following supported values can be entered:
Shopify
ManoMano
Etsy
WooCommerce
Zalando
Leroymerlin
Decathlon
Prestashop
Other
If there's an invoice associated with the sale, also fill in the following optional fields:
Invoice number: invoice identification number
B2C or B2B: 0 for private customers or 1 for business customers
VIES invalid or valid: 0 for customers with VAT numbers not registered with VIES or 1 for VAT-registered customers
The following table provides an example of compilation
Payment date | Order ID | Product ID | Quantity | Product price (incl. VAT) | Shipping price (incl. VAT) | Currency | Shipping country code | Arrival country code | Marketplace | Invoice number | B2C or B2B (0 or 1) | VIES invalid or valid (0 or 1) |
2023-12-01 | 123.456.789 | SKU1 | 1 | 20.30 | 4.55 | EUR | IT | DE | Shopify | INV-2023-011 | 1 | 1 |
2023-12-02 | 123.456.790 | SKU2 | 1 | -35.30 | 0.00 | EUR | IT | FR | Shopify | CN-2023-002 | 1 | 1 |
2023-12-03 | 123.456.791 | SKU3 | 1 | 22.55 | 7.40 | EUR | IT | FR | Shopify | |||
2023-12-04 | 123.456.792 | SKU4 | 1 | 11.23 | 4.55 | EUR | IT | ES | Shopify | INV-2023-012 | 1 | 1 |
2023-12-05 | 123.456.793 | SKU1 | 1 | 56.30 | 5.30 | EUR | IT | DE | WooCommerce | |||
2023-12-06 | 123.456.794 | SKU2 | 2 | -34.20 | 7.40 | EUR | IT | FR | WooCommerce | |||
2023-12-07 | 123.456.795 | SKU3 | 1 | 12.50 | 4.55 | EUR | IT | FR | WooCommerce | INV-2023-013 | 1 | 0 |
2023-12-05 | 123.456.793 | SKU4 | 1 | 120.00 | 5.30 | EUR | IT | ES | WooCommerce |
Once you've filled out the file, save it and upload it in the "Choose File" field.
Check the import result in the notification center.
If the external sales you inserted have a reduced rate (e.g., for food or pharmaceutical products), you can set the product rate in the Reduced Rates section.
View external sales
You can access this section from the left menu Accounting >> Daily takings >> + >> External Sales
In this screen, you can view a table with the external sales you've added in ZonWizard.
The list shown is for the period selected from the drop-down menu "period".
The period can be monthly or quarterly.
Using the search bar in the top toolbar, you can search for sales by order number.
The table provides the following information for each sale:
Date: of payment
Order No.: order identification code
Product: unique product code
Type:
sale
return
Marketplace: name of the marketplace
Gross amount: amount of the transaction including VAT
Rate: VAT rate
Jurisdiction: VAT jurisdiction of the sale
Invoice No.: invoice number, if present
Delete external sales
By clicking on the trash can, you can delete one sale at a time, or you can select more than one using the checkboxes on the left and delete them in bulk using the larger trash can button at the top right.
Last updated
