Why do gross and net values differ in summarized reports?

Overview

Have you noticed that in summarized reports (daily, monthly, or annual), the gross and net values don't exactly match when you recalculate them using tax rates? This is not an error – it is a mathematical necessity due to rounding.

In this article, we explain in detail why these small discrepancies occur and why they are completely correct.

The Phenomenon: Small Differences in Large Sums

For example, if you have a monthly report showing:

• Gross total: €2,985.00

• Net total: €2,488.00

• VAT (20%): €497.00

...and you verify: €2,488.00 + €497.00 = €2,985.00 ✓

But if you calculate the VAT from the net amount: €2,488.00 × 1.20 = €2,985.60 ✗

Or calculate net from gross: €2,985.00 ÷ 1.20 = €2,487.50 ✗

Why is there a difference of 60 cents or 50 cents?

The Explanation: Rounding at Invoice Level

Why is rounding necessary?

Every individual invoice must display amounts that are readable for customers – meaning values with a maximum of 2 decimal places (cent precision).

Problem: Many net values mathematically require 3 or more decimal places to correctly calculate the tax and gross amount.

Example:

• An item costs €29.85 gross (incl. 20% VAT)

• Mathematically exact net: €24.875

• Mathematically exact tax: €4.975

Both values end in exactly 5 in the third decimal place and are therefore rounded up:

• Net rounded: €24.88 (rounded up from 24.875)

• Tax rounded: €4.98 (rounded up from 4.975)

Check: €24.88 + €4.98 = €29.86 – but the invoice amount is €29.85!

If we used the mathematically rounded values, the invoice would suddenly have a 1-cent discrepancy.

The Solution: Rounding Correction on the Invoice

Therefore, a rounding correction is applied on every single invoice to ensure that net + tax = gross matches 100%. In our example, the tax amount is corrected to €4.97:

• Net: €24.88

• Tax: €4.97 (corrected)

• Gross: €29.85 ✓

This is also legally required because:

• The rounded values are included in the cash register signature

• These values are reported through the fiscal data export

• Invoice amounts must be traceable for customers

Calculation Example: A Single Invoice

Let's take a specific invoice:

Verification:

• Net (€24.88) × 1.20 = €29.856 → rounded €29.86 (not €29.85!)

• Gross (€29.85) ÷ 1.20 = €24.875 → rounded €24.88 ✓ (happens to match here)

You can see: Even with a single invoice, rounding to 2 decimal places creates small differences of 1 cent.

The Effect: Summation Across Many Invoices

The Problem Multiplies

When you sum 100 such invoices, you also sum the small rounding differences:

Example Calculation with 100 Invoices

Summed values from invoices:

• Gross total: €2,985.00

• Net total: €2,488.00

• Tax total: €497.00

When you recalculate:

• €2,488.00 × 1.20 = €2,985.60 (difference: €0.60)

• €2,985.00 ÷ 1.20 = €2,487.50 (difference: €0.50)

These differences are mathematically correct and inevitably arise from rounding at the invoice level.

Why the System is Still Correct

1. Match with Individual Invoices

The summed report values correspond exactly to the sum of all individual invoices. If you were to manually add up all invoices, you would arrive at exactly the same values.

2. Match with Fiscal System

The reported tax values in the respective country-specific fiscal system are based on the rounded invoice values. The reports in the system match 100% with the values reported to the tax authority.

3. Legally Compliant Signature

The cash register signature is created using the rounded values. If the system calculated differently, the signatures would no longer be valid.

How You Can Verify the Accuracy Yourself

You can easily verify this in Excel:

Step 1: Enter a Single Invoice

Enter an example invoice:

• Gross: €29.85

• Tax: €4.97

• Net: €24.88

Step 2: Copy the Invoice

Copy this row 100 times (or use a formula with 100 rows).

Step 3: Sum Up

Calculate the total across all 100 invoices:

• Total Gross: €2,985.00

• Total Tax: €497.00

• Total Net: €2,488.00

Step 4: Recalculate

Now try to calculate the gross value from the net:

• €2,488.00 × 1.20 = €2,985.60 (not €2,985.00!)

This shows: The difference arises from rounding at the invoice level.

The Correct Approach for Reports

✓ How to calculate correctly:

Always use the tax values shown in the report!

If a report shows:

• Gross total: €2,985.00

• Tax total: €497.00

• Net total: €2,488.00

Then:

• Net + Tax = Gross → €2,488.00 + €497.00 = €2,985.00 ✓

✗ How NOT to calculate:

Do not try to recalculate tax or net amounts from gross or net using the tax rate:

• Net × 1.20 = Gross → leads to differences ✗

• Gross ÷ 1.20 = Net → leads to differences ✗

Frequently Asked Questions (FAQ)

Is this a bug in the POS system?

No. This is mathematically correct and legally required. Every POS system in Austria (and worldwide) works this way, as rounding at the invoice level is mandatory.

Why isn't rounding done only at the end of the day?

Because every individual invoice:

• Must be comprehensible for the customer (2 decimal places)

• Is signed and reported through the fiscal data export

• Must be a legally valid standalone document

How large can the differences become?

Typical deviations are:

• 1-2 cents per invoice

• With 100 invoices: 1-2 euros

• With 1,000 invoices: 10-20 euros

The deviation is proportionally very small (usually < 0.1%) and fiscally completely correct.

Can I avoid the differences?

No, because they arise from the legally required rounding at the invoice level. Every system that operates in compliance with fiscal regulations has these "differences" – they are a characteristic of correct bookkeeping.

Summary

Key points:

1. ✓ Each invoice is individually rounded (to 2 decimal places)

2. ✓ This rounding is legally required (fiscal data exports)

3. ✓ When summing up, the small rounding differences accumulate

4. ✓ The report values match exactly with the individual invoices

5. ✓ Always use the displayed tax values for verification

Never recalculate using tax rates – this inevitably leads to differences!

Further Information

For questions about the tax treatment or booking of these values, please contact your tax advisor.

For technical questions about the POS system, our Support team is happy to help.

Confluence Labels: rounding-difference, reports, gross-net, vat, tax, cash-register, fiscalization, accounting, faq, manager