Reconciling Sales Tax in Walla: What to Expect and Why | Walla Support Center

Reconciling Sales Tax in Walla: What to Expect and Why

Walla calculates sales tax per transaction, not on total sales. If your figures don't match a flat-rate calculation, that's expected. This article explains why and walks you through how to reconcile correctly.

Overview

If you're trying to reconcile your sales tax figures and the numbers aren't adding up, you're not alone and you're probably not doing anything wrong. There are a few specific reasons Walla's reported tax totals won't match a simple percentage applied to gross sales, and this article walks you through exactly why and how to get to the right number.

Why the Numbers Don't Match

Walla calculates sales tax at the individual transaction level, not against your total gross sales. This is important to understand because applying a flat tax rate to your gross sales figure will almost never match what Walla reports, and that's by design.

Here's why. Not everything you sell is taxable. Before tax is ever calculated, you need to isolate your taxable sales only, subtract any discounts applied to those items, and then apply your tax rate to that adjusted figure. Any remaining difference after that is rounding, which we'll cover next.

Skipping any of these steps is typically where the disconnect happens.

Rounding

Rounding is unavoidable in transaction-level tax calculation and accounts for the majority of minor variances you'll see between Walla's reported totals and a manual calculation.

Here's a simple example at 7.5%:

Tables can't be imported directly. Please insert an image of your table which can be found here.

Item Price

$5.00

Exact Tax

$0.375

Rounded Tax Charged

$0.38

That $0.005 difference is negligible on a single transaction. Across hundreds of transactions in a month it adds up, but remains a small and expected variance, not an error.

A common question is how many transactions it takes before rounding becomes noticeable. In short, there's no single answer, but here's how it works: when the tax on a transaction lands on exactly half a cent ($0.005), it rounds up to the nearest hundredth. Anything below that rounds down to the nearest hundredth. Since this can go either direction depending on the transaction amount, the differences tend to cancel each other out over time rather than stack up in one direction.

So the better question isn't "how much rounding adds up" so much as "what else is contributing to the difference." That's what the next section covers.

Factors That Affect Reconciliation

Non-Taxable Items: This is the most common and impactful reason your numbers won't match a flat-rate calculation. If any of your products are designated as non-taxable in Walla, they are intentionally excluded from tax calculation. Applying your tax rate to gross sales without accounting for these items first will always produce an inflated result.

Before running any manual calculation, identify your non-taxable items and remove them from your gross sales total. What remains is your taxable sales base, and that is the only figure your tax rate should ever be applied to.

Discounts and Refunds: Tax in Walla is calculated on the discounted price, not the original price. This means if a $20.00 item is sold at a $5.00 discount, tax is applied to $15.00. When reconciling manually, make sure discounts are subtracted from your taxable sales total before applying your tax rate.

Refunds work similarly. When a transaction is refunded, the associated tax collected is also reversed. This reduces your total tax collected for the period and needs to be accounted for when reconciling against your reported figures.

Payment Methods - Gift Cards and Account Balance: Transactions paid via gift card or account balance are still taxable at the point of sale, but they will not appear in the Sales Report when run on a Cash Basis.

Important: To capture these transactions, you must additionally export the Sales Report as Accrual Basis only. The Cash Basis export is not used for gift card and account balance transactions.

Bigger picture: these are two separate exports that need to be reviewed together to get a complete picture of your taxable sales and tax collected for any given period. Relying on the Cash Basis report alone will result in an incomplete total. This is one of the more common and least obvious reasons a reconciliation comes up short.

Reporting View Differences: Each report in Walla is built for a specific purpose, and understanding what each one includes is important before drawing conclusions from the numbers.

For tax reconciliation specifically, the Sales Report is your most comprehensive starting point, but only when exported correctly and reviewed across both Cash and Accrual Basis. Each export serves a different function and together they provide the most complete picture of your taxable sales and tax collected for any given period.

When in doubt, export both and compare. If the numbers don't align, the difference is usually traceable to one of the factors covered in this article.

What Should Be Used for Tax Filing

Use the actual tax collected as shown in your Walla reports. This is the figure that reflects what was charged at the point of sale, collected from your customers, and should be remitted to the appropriate tax authority.

Walla's tax calculation happens automatically at the transaction level with multiple layers of system checks in place. While no system is entirely immune to edge cases, the tax figures recorded in your reports represent the most accurate and defensible numbers available for filing purposes.

Do not recalculate tax from gross sales and use that figure instead. As this article outlines, that approach will almost never produce a matching result and is not how tax authorities expect figures to be reported.

How to Reconcile Correctly

Follow these steps in order. Skipping or rearranging them is the most common reason a manual reconciliation doesn't land on the right number.

Step 1: Export Both Cash and Accrual Sales Reports

These are two separate exports from the Sales Report. Do not rely on the generated report view alone. The data you need for accurate reconciliation requires both exports. Cash Basis captures standard transactions while Accrual Basis captures gift card and account balance transactions that would otherwise be missing from your totals.

Step 2: Identify and Remove Non-Taxable Items

Review your product catalog and identify anything designated as non-taxable in Walla. Remove those sales from your gross total. What remains is your taxable sales base and the only figure that should move forward in this process.

Step 3: Subtract Discounts

Remove any discounts applied to taxable transactions from your taxable sales base. Tax in Walla is calculated on the discounted price, so your manual calculation needs to reflect that.

Step 4: Apply Your Tax Rate

Apply your configured tax rate to the adjusted taxable sales figure from Step 3. This is your expected tax total.

Step 5: Account for Refunds

Subtract any refunded tax amounts from your expected total. Refunds reverse the associated tax collected and need to be reflected here.

Step 6: Compare Against Walla's Reported Tax Total

Compare your result against the tax total shown in your Walla exports. At this point the figures should be very close.

Step 7: Any Remaining Variance Is Rounding

A small remaining difference is expected and is the result of transaction-level rounding as covered earlier in this article. This is not an error.

Key Takeaway

If your sales tax figures don't match a flat-rate calculation, that's not a red flag. It's the nature of how transaction-level tax calculation works. The factors covered in this article, including non-taxable items, discounts, refunds, payment method reporting gaps, and rounding, each play a role. Understanding how they interact is the difference between a frustrating reconciliation and a clean one.

When in doubt, follow the steps outlined above and trust the figures in your Walla reports. They represent what was actually charged, collected, and owed, and that's exactly what you need for accurate filing.

If something still doesn't add up after working through this, reach out to our support team with those details. We're happy to take a look.