Billable Totals Don't Match: VAT Calculation Issues

If your billable totals don't match expected amounts, this guide explains VAT-inclusive vs exclusive pricing, why totals might be wrong, and how to verify calculations.

Problem Statement

The Issue

Your billable totals don't match what you expect. This could be:

• Subtotal doesn't match line items
• VAT amount seems incorrect
• Total is wrong
• Calculations don't add up
• Different totals in different views

Common Scenarios

Scenario 1: Subtotal Mismatch

• Subtotal doesn't equal sum of line items
• Some items missing from subtotal
• Subtotal is higher or lower than expected

Scenario 2: VAT Calculation Errors

• VAT amount is wrong
• VAT calculated on wrong base amount
• VAT rate seems incorrect

Scenario 3: Total Doesn't Match

• Final total doesn't equal subtotal + VAT
• Total is off by a small amount
• Total shows different values in different places

Scenario 4: Currency Conversion Issues

• Totals wrong when using different currencies
• Conversion rates seem incorrect
• Display currency shows wrong amounts

Understanding VAT-Inclusive vs Exclusive

VAT-Inclusive Pricing

VAT-Inclusive means the price already includes VAT:

• Price shown: 100.00 (includes VAT)
• VAT rate: 25%
• VAT amount: 20.00 (25% of 80.00)
• Price without VAT: 80.00

Example:

• You charge customer: 100.00
• This includes: 80.00 (product) + 20.00 (VAT)
• Customer pays: 100.00 total

VAT-Exclusive Pricing

VAT-Exclusive means VAT is added to the price:

• Price shown: 80.00 (before VAT)
• VAT rate: 25%
• VAT amount: 20.00 (25% of 80.00)
• Total with VAT: 100.00

Example:

• You charge customer: 80.00 + 20.00 VAT = 100.00
• Customer pays: 100.00 total

Why This Matters

If your business uses VAT-Inclusive:

• Prices already include VAT
• Don't add VAT again
• VAT is extracted from the price

If your business uses VAT-Exclusive:

• Prices are before VAT
• VAT is added to the price
• Total = Price + VAT

Common Mistake

Double VAT Calculation:

• If prices are VAT-inclusive, don't calculate VAT again
• This causes totals to be too high
• Check your business VAT settings

Why Totals Might Be Wrong

Common Causes

1. Double VAT Extraction

• VAT already included in prices
• System extracts VAT again
• Result: Totals are too low

2. Wrong VAT Rate

• Business VAT rate set incorrectly
• Different rate used than expected
• Regional VAT rates not configured

3. Currency Conversion Issues

• Exchange rates incorrect
• Conversion applied multiple times
• Display currency issues

4. Rounding Errors

• Multiple rounding operations
• Different rounding in different places
• Accumulated rounding differences

5. Missing Line Items

• Some items not included in total
• Filtered items excluded
• Draft items not counted

6. Incorrect Source Values

• Using wrong field for calculations
• Display values vs source values
• Currency conversion applied incorrectly

7. VAT Calculation Method Mismatch

• Business set to VAT-inclusive
• But items entered as VAT-exclusive
• Or vice versa

How to Identify the Issue

Check these in order:

1. Business VAT Settings

   • Go to Business Settings → VAT Settings
   • Check VAT calculation method (inclusive/exclusive)
   • Verify VAT rate is correct

2. Line Item Values

   • Check individual line items
   • Verify prices are correct
   • Check if VAT is included or not

3. Summary Calculation

   • Check how subtotal is calculated
   • Verify VAT amount calculation
   • Check total = subtotal + VAT

4. Currency Settings

   • Verify display currency
   • Check exchange rates
   • Ensure consistent currency usage

How to Verify Calculations

Step 1: Check Business VAT Settings

1. Go to Business Settings → VAT Settings
2. Check VAT Calculation Method:
   • Inclusive: Prices include VAT
   • Exclusive: VAT added to prices
3. Verify VAT Rate is correct (e.g., 25%, 20%, etc.)
4. Check Regional VAT Rate if applicable

Step 2: Verify Line Item Values

For each line item:

1. Check the Unit Price
2. Verify if price includes VAT or not
3. Check Quantity
4. Calculate: Unit Price × Quantity = Line Total
5. Verify Line Total matches

Step 3: Calculate Subtotal Manually

Add up all line items:

1. List all line items
2. Add their totals together
3. Compare to displayed Subtotal
4. If different, identify which items are wrong

Step 4: Verify VAT Calculation

If VAT-Inclusive:

1. Subtotal = Sum of all line items (VAT included)
2. VAT Amount = Subtotal - (Subtotal ÷ (1 + VAT Rate))
3. Example: 1000 - (1000 ÷ 1.25) = 1000 - 800 = 200

If VAT-Exclusive:

1. Subtotal = Sum of all line items (before VAT)
2. VAT Amount = Subtotal × VAT Rate
3. Example: 800 × 0.25 = 200

Step 5: Verify Final Total

Total should equal:

• VAT-Inclusive: Subtotal (VAT already included)
• VAT-Exclusive: Subtotal + VAT Amount

Check:

• Total = Subtotal + VAT (if exclusive)
• Or Total = Subtotal (if inclusive, VAT already in)

Step 6: Check Currency Conversion

If using different currencies:

1. Verify exchange rates
2. Check conversion is applied once
3. Ensure display currency is correct
4. Compare source currency vs display currency

Step-by-Step Solutions

Solution 1: Fix Business VAT Settings

If VAT rate is incorrect:

1. Go to Modules → Finance → Click the settings (cog) icon
2. Or navigate to Business → VAT Settings
3. Check current VAT rate
4. VAT is always enabled and included in all pricing calculations
5. Update the VAT rate if needed
6. Recalculate existing billables if needed

Solution 2: Correct VAT Rate

If VAT rate is incorrect:

1. Go to Modules → Finance → Click the settings (cog) icon
2. Or navigate to Business → VAT Settings
3. Check current VAT rate
4. Verify correct rate for your region:
   • Norway: 25% (standard), 15% (food), 10% (transport)
   • Sweden: 25% (standard), 12% (food), 6% (books)
   • EU: Varies by country (typically 19-27%)
5. Update VAT rate
6. Consult with accountant if unsure

Solution 3: Fix Line Item Prices

If line item prices are wrong:

1. Go to the billable
2. Edit each line item
3. Verify unit price is correct
4. Check if price includes VAT or not
5. Ensure quantity is correct
6. Save changes
7. Recalculate totals

Solution 4: Recalculate Totals

If calculations seem off:

1. Go to the billable
2. Check if there's a "Recalculate" button
3. Click it to recalculate all totals
4. Verify totals are now correct
5. If not, check individual line items

Solution 5: Check Currency Conversion

If currency conversion is wrong:

1. Verify exchange rates are current
2. Check if conversion is applied correctly
3. Ensure display currency matches business currency
4. Contact support if exchange rates seem wrong

Solution 6: Verify Source Values

If using wrong values in calculations:

1. Check which fields are used for calculations
2. Verify source values (not display values)
3. Ensure currency conversion is applied once
4. Check for double conversion

Solution 7: Contact Support

If calculations still don't match:

1. Gather information:
   • Billable ID
   • Expected totals
   • Actual totals
   • VAT settings
   • Line item details
2. Contact support with this information
3. They can investigate the calculation logic

Common Calculation Errors

Error 1: Double VAT Extraction

Problem:

• Prices are VAT-inclusive
• System extracts VAT from prices
• Then adds VAT again
• Result: Totals too high

Solution:

• Set business to VAT-inclusive
• Don't add VAT to already-inclusive prices
• Use source_subtotal directly

Error 2: Wrong Base for VAT Calculation

Problem:

• Calculating VAT on wrong amount
• Using total instead of subtotal
• Including VAT in VAT calculation

Solution:

• Calculate VAT on subtotal only
• Don't include existing VAT
• Use correct base amount

Error 3: Currency Conversion Applied Multiple Times

Problem:

• Converting currency multiple times
• Each conversion adds error
• Totals become increasingly wrong

Solution:

• Convert once at source
• Use converted values consistently
• Don't convert already-converted values

Error 4: Rounding Accumulation

Problem:

• Rounding at each step
• Errors accumulate
• Final total is off

Solution:

• Round only at final step
• Use precise calculations throughout
• Round final total only

Error 5: Using Display Values Instead of Source

Problem:

• Using display values for calculations
• Display values may be rounded
• Source values are more accurate

Solution:

• Use source values for calculations
• Only use display values for display
• Calculate from source, display formatted

Prevention Tips

How to Avoid Calculation Issues

1. Configure VAT Settings Correctly

• Set VAT calculation method correctly from start
• Verify VAT rate is accurate
• Consult with accountant if unsure
• Document your VAT configuration

2. Use Consistent Pricing

• Decide if prices include VAT or not
• Use same method for all items
• Document pricing policy
• Train team on pricing method

3. Verify Settings Before Creating Billables

• Check VAT settings before creating billables
• Verify currency settings
• Test with sample billable first
• Review calculations before finalizing

4. Regular Reviews

• Periodically review billable totals
• Check for calculation errors
• Verify VAT calculations
• Compare to expected amounts

5. Document Your Process

• Document VAT calculation method
• Keep notes on special cases
• Document currency conversion process
• Maintain calculation examples

6. Test Calculations

• Create test billables
• Verify calculations manually
• Compare to expected results
• Fix issues before production use

7. Consult with Accountant

• Get accountant approval on VAT setup
• Verify VAT rates are correct
• Confirm calculation method
• Review calculation examples

When to Contact Support

When to Contact Support

If you've verified all settings and calculations still don't match:

1. Gather Information Before contacting support:

• Billable ID or reference
• Expected subtotal, VAT, and total
• Actual subtotal, VAT, and total
• Business VAT settings (method and rate)
• Line item details
• Currency information
• Screenshots of the billable

2. Contact Support

• Email: support@piraja.io
• In-App: Use the help icon (?) in the interface
• Knowledge Base: Search for related articles

3. What Support Will Need

• Your account email
• Business name
• Billable details
• VAT configuration
• Calculation examples
• Screenshots

Related Articles

• Understanding the Module System
• Setting Up Your Account

Additional Resources

• Finance Module Guide: Complete guide to finance (billables)
• VAT Configuration: How to configure VAT settings
• Financial Help: General financial troubleshooting