sag982384

What I found till now:

• it seems that fully refunded orders are not substracted from the net sales
• partly refunded orders are counted as 2 orders. 1 for the initial order and 1 for the refunded part. The refunded part is incorporated in the sales, other then the fully refunded orders.
• I use a plugin for removing VAT for BE clients when they apply a valid VAT nr. So for those clients, their VAT is not included in the Tax Report. That makes sense.
• All the orders of 1 specific client are not included in sales. Still have to figure out why.

There are no other countries then BE & NL.
I will do some research now by comparing the lists of order by the two different reports.

• This reply was modified 10 months, 1 week ago by sag982384.

You want an example, but I think we first have to look at this problem: when I ask the reports of last week, the Revenue report states that there where 80 orders while the taxes report counts only 76 orders.

The next screenshot shows my analytics settings.

Here are the screenshots of my settings.

` WordPress Environment

WC Version: 8.5.1
REST API Version: ? 8.5.1
WC Blocks Version: ? 11.8.0-dev
Action Scheduler Version: ? 3.7.1
Log Directory Writable: ?
WP Version: 6.4.2
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: nl_NL
External object cache: – Server Environment

Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 100 MB
PHP Time Limit: 600
PHP Max Input Vars: 100000
cURL Version: 7.87.0
OpenSSL/1.1.1w

SUHOSIN Installed: –
MySQL Version: 8.0.36
Max Upload Size: 100 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 8.5.1
WC Database Prefix: wp_
Total Database Size: 947.12MB
Database Data Size: 710.84MB
Database Index Size: 236.28MB
wp_woocommerce_sessions: Data: 236.30MB + Index: 13.30MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 4.52MB + Index: 1.52MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 35.58MB + Index: 42.14MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_404_to_301: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
wp_actionscheduler_actions: Data: 39.58MB + Index: 31.16MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 20.55MB + Index: 19.06MB + Engine InnoDB
wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_automatewoo_abandoned_carts: Data: 0.34MB + Index: 0.08MB + Engine InnoDB
wp_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_automatewoo_customers: Data: 1.52MB + Index: 1.13MB + Engine InnoDB
wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_automatewoo_guests: Data: 0.36MB + Index: 0.64MB + Engine InnoDB
wp_automatewoo_log_meta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
wp_automatewoo_logs: Data: 0.28MB + Index: 0.41MB + Engine InnoDB
wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_aws_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aws_index: Data: 2.45MB + Index: 1.70MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 19.55MB + Index: 17.09MB + Engine InnoDB
wp_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_duplicator_pro_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gpf_feeds: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nextend2_smartslider3_sliders: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_nextend2_smartslider3_slides: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
wp_options: Data: 26.06MB + Index: 0.42MB + Engine InnoDB
wp_postmeta: Data: 91.64MB + Index: 79.27MB + Engine InnoDB
wp_posts: Data: 4.52MB + Index: 3.59MB + Engine InnoDB
wp_pys_stat_landing: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_pys_stat_order: Data: 0.45MB + Index: 0.00MB + Engine InnoDB
wp_pys_stat_product_order: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
wp_pys_stat_traffic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pys_stat_utm_campaing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pys_stat_utm_content: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pys_stat_utm_medium: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pys_stat_utm_source: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pys_stat_utm_term: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_analytics_inspections: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_redirection_404: Data: 0.31MB + Index: 0.11MB + Engine InnoDB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
wp_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.22MB + Index: 0.08MB + Engine InnoDB
wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 7.52MB + Index: 9.03MB + Engine InnoDB
wp_users: Data: 0.42MB + Index: 0.36MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 1.52MB + Index: 0.53MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 4.52MB + Index: 7.06MB + Engine InnoDB
wp_wc_order_stats: Data: 1.52MB + Index: 0.84MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 1.52MB + Index: 0.72MB + Engine InnoDB
wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.08MB + Index: 0.13MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wcpdf_credit_note_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.30MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_packing_slip_number: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_proforma_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdp_order_items: Data: 0.31MB + Index: 0.33MB + Engine InnoDB
wp_wdp_orders: Data: 0.28MB + Index: 0.17MB + Engine InnoDB
wp_wdp_persistent_rules_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdp_product_collections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdp_rules: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_webwinkelkeur_invite_error: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpml_mails: Data: 190.08MB + Index: 0.20MB + Engine InnoDB
wp_wpr_rocket_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_zettle_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_zettle_woocommerce_id_map: Data: 0.14MB + Index: 0.00MB + Engine InnoDB Post Type Counts

acf-field: 19
acf-field-group: 5
attachment: 1033
aw_workflow: 6
bricks_fonts: 2
bricks_template: 15
custom_css: 6
et_body_layout: 3
et_footer_layout: 1
et_header_layout: 1
et_pb_layout: 16
et_template: 8
et_theme_builder: 1
filter-field: 13
filter-set: 1
jetpack_migration: 2
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
nav_menu_item: 41
oembed_cache: 10
page: 36
phoe_badge: 1
post: 12
product: 290
product_variation: 4
revision: 25
saswp: 2
shop_coupon: 38
shop_order: 8766
shop_order_refund: 168
sp_wcslider: 2
wp_global_styles: 1
_pods_field: 12
_pods_group: 4
_pods_pod: 2 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (55)

Query Monitor: by John Blackbourn – 3.15.0
Advanced Custom Fields: by WP Engine – 6.2.5
Advanced Dynamic Pricing for WooCommerce (Pro): by AlgolPlus – 4.4.2
Advanced Woo Search PRO: by ILLID – 2.97
AutomateWoo: by WooCommerce – 6.0.13
BricksExtras: by BricksExtras – 1.4.0
BricksLabs Bricks Navigator: by Sridhar Katakam – 1.0.3
WP Sheet Editor - Users (Premium): by WP Sheet Editor – 1.5.30
Campaign Monitor for WooCommerce: by Campaign Monitor – 1.4.9
Code Snippets: by Code Snippets Pro – 3.6.2
Cost of Goods for WooCommerce: by WPFactory – 3.2.2
Disable Emojis (GDPR friendly): by Ryan Hellyer – 1.7.6
GTM4WP: by Thomas Geiger – 1.19.1
Easy Auto SKU Generator for WooCommerce: by Dan Zakirov – 1.1.9
EU VAT for WooCommerce Pro: by WPWhale – 2.4.2
Filter Everything PRO: by Andrii Stepasiuk – 1.7.15
Campaign Monitor for WordPress: by Campaign Monitor – 2.8.14
XML Sitemap Generator for Google: by Auctollo – 4.1.18
Jetpack: by Automattic – 13.0
Loco Translate: by Tim Whitlock – 2.6.6
Members: by MemberPress – 3.2.9
Mollie Payments for WooCommerce: by Mollie – 7.4.1
Payment Gateways by User Roles for WooCommerce: by Imaginate Solutions – 1.3.0
PixelYourSite PRO: by PixelYourSite – 9.11.1.2
Product GTIN (EAN, UPC, ISBN) for WooCommerce: by Emanuela Castorina – 1.1.1
Redirection: by John Godley – 5.4.1
Schema & Structured Data for WP & AMP: by Magazine3 – 1.26
Slim SEO: by eLightUp – 3.22.5
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.23.16

User Switching: by John Blackbourn & contributors – 1.7.2
WooCommerce Custom Order Status: by Ameer – 1.0.2
WooCommerce Tree Table Rate Shipping: by tablerateshipping.com – 1.31.4
WebwinkelKeur: by Albert Peschar – 3.32
WP Sheet Editor - WooCommerce Orders Pro: by WP Sheet Editor – 1.3.10
Product Feed PRO for WooCommerce: by AdTribes.io – 13.2.1
WP Sheet Editor - WooCommerce Products (Premium): by WP Sheet Editor – 1.8.8
Ultimate Order Combination: by Fahad Mahmood – 1.7.2
WooCommerce Email Test: by RaiserWeb – 1.2.2
MyParcel: by MyParcel – 4.22.1
PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.7.6
WooCommerce: by Automattic – 8.5.1
WordPress Importer: by wordpressdotorg – 0.8.2
WP Add Mime Types: by Kimiya Kitani – 3.1.1
WP Crontrol: by John Blackbourn & crontributors – 1.16.1
WP Mail Logging: by WP Mail Logging Team – 1.12.0
WP Mail SMTP: by WP Mail SMTP – 3.11.0
WP Rocket | Deactivate WooCommerce Refresh Cart Fragments Cache: by WP Rocket Support Team –
WP Rocket: by WP Media – 3.15.7
WP Sheet Editor - Redirection: by WP Sheet Editor – 1.0.1
WP Sync DB: by Sean Lang – 1.5
WP Test Email: by Boopathi Rajan – 1.1.6
WP Overnight Sidekick: by WP Overnight – 2.5.1
YITH WooCommerce Frequently Bought Together Premium: by YITH – 1.37.0
YITH WooCommerce Product Bundles Premium: by YITH – 2.3.0
PayPal Zettle POS: by PayPal – 1.5.7 Inactive Plugins (4)

Hotjar: by Hotjar – 1.0.16
PDF Invoices & Packing Slips for WooCommerce - Professional: by WP Overnight – 2.14.6
Perfmatters: by forgemedia – 2.1.4
Tawk.to Live Chat: by Tawkto – 0.8.2 Dropin Plugins (2)

advanced-cache.php: advanced-cache.php
maintenance.php: maintenance.php Settings

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
pw gift card (pw-gift-card)
simple (simple)
variable (variable)
woosb (woosb)
yith_bundle (yith_bundle)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to Woo.com: ?
Enforce Approved Product Download Directories: –
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: – WC Pages

Shop base: #4 - /winkel/
Cart: #14213 - /winkelwagen/
Checkout: #14212 - /afrekenen-2/
My account: #7 - /mijn-account/


Name: Bricks Child Theme
Version: 1.1
Author URL: https://bricksbuilder.io/
Child Theme: ?
Parent Theme Name: Bricks
Parent Theme Version: 1.9.5
Parent Theme Author URL: https://bricksbuilder.io/
WooCommerce Support: ? Templates

Overrides: bricks/archive-product.php
bricks/woocommerce/cart/cart-empty.php
bricks/woocommerce/cart/cart.php
bricks/woocommerce/cart/proceed-to-checkout-button.php
bricks/woocommerce/checkout/form-checkout.php
bricks/woocommerce/checkout/form-pay.php
bricks/woocommerce/checkout/order-receipt.php
bricks/woocommerce/checkout/thankyou.php
bricks/single-product.php Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: customize-store
minified-js
new-product-management-experience
product-linked
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-01-24 06:12:22 +01:00
Options: ?
Notes: 193
Onboarding: completed Action Scheduler

Canceled: 5
Oldest: 2024-01-22 09:01:46 +0100
Newest: 2024-01-22 09:01:46 +0100

Complete: 91,614
Oldest: 2023-12-23 10:36:06 +0100
Newest: 2024-01-23 10:33:24 +0100

Failed: 17
Oldest: 2023-10-20 23:47:10 +0200
Newest: 2024-01-22 16:13:58 +0100

Pending: 17
Oldest: 2024-01-23 10:35:24 +0100
Newest: 2024-01-24 00:06:25 +0100 PayPal Zettle POS

Onboarding state: onboarding-completed
Price sync: yes
Initial sync collision strategy: wipe
First import: 17:01 21/03/2022
Number of products syncing: 258
PayPal Zettle VAT: 9
PayPal Zettle currency: EUR
PayPal Zettle country: NL
PayPal Zettle language: nl
PayPal Zettle time zone: Europe/Amsterdam
PayPal Zettle taxation mode: INCLUSIVE
PayPal Zettle taxation type: VAT
PayPal Zettle customer mode: SelfEmployed Status report information

Generated at: 2024-01-23 10:33:34 +01:00
`

Hi, that’s correct; the values doesn’t match. The strange thing is that the Taxes almost match, but when I calculate the sales, it’s a big difference. But lets take this step by step. Here are the values of tax by both reports:
Tax report: € 51.358
Revenue report: € 51.357,73
Total orders are different in each report:
Tax report: 3886 orders
Revenue report: 3928 orders

My taxes look like this:
6% BE: 373,94
21% BE: 8.359,22
9% NL: 3.182,17
21% NL: 39.442,67

If you calculate the sales from these tax figures, it looks like this (using the method I mentioned earlier):
6% BE: 6.232,33
21% BE: 39.805,81
9% NL: 35.357,44
21% NL: 187.822,24
Total sales ex vat: € 269.217,83

This is realy close to the gross sales of the Revenue report (270.994,65), but then the returns and the coupons are subtracted. We end up with 268.106,65.
Then there is this ‘Shipping’ of 10.393,64. It looks like these costs are not includes in the tax figures. This might be an important clue. It doesn’t say if this figure is in or ex vat.

Any idea when this update will be there?

That’s a lot of work for just a drop down menu… I’ll ask PiotNet if they have a solution for this. Thanks.

After some testing it worked. For the people who wants to know:
1. Woocommerce trigger Guest purchases [name product] 1 times(s)
2. Action will be run on New user
a. username: [username] | This has to be an existing user, always the same one
b. e-mail: {3:woocommerce_order_billing_email}
c. leave all the other fields untouched
d. What to do if the user already exists: Select existing user
e. Field to search the user: Username
3. WordPress action: Send an email to {3:woocommerce_order_billing_email}

Thank you. For step 3: how do I get his e-mail address? It looks like I have to fill it in manualy. I would like the address filled in automaticly.

OK, but what do I fill in at “username” and “email”? It has to be the e-mail of the anonymous client offcource. If I fill in a random username, then all the anonymous users will get the same random name wright?

superr!