thread Re: Why is there a discrepancy between total daily sales and tax sales report? in Orders, Menu Items, Catalog & Fulfilment

Why is there a discrepancy between total daily sales and tax sales report?

FayR — Sat, 20 Sep 2025 09:42:18 GMT

For example my total cash sales for the business day is $2300.50, however when I add my taxable sales and my nontaxables sales pluse sales tax collected is less than my daily total sales of $2300.50. Most days it's the same then there are days when the amounts are off.

Re: Why is there a discrepancy between total daily sales and tax sales report?

MayaP — Mon, 31 Mar 2025 21:47:04 GMT

Hey @FayR – Thanks for reaching out! We're glad to have you in our Community! 😊

Can you share more insight into why you're comparing your Sales Summary report to the Tax Sales report? You can learn more about our reporting here.

Any insight you can provide this seller? @Candlestore @TheRealChipA

Re: Why is there a discrepancy between total daily sales and tax sales report?

Candlestore — Tue, 01 Apr 2025 00:02:09 GMT

@FayR and @MayaP ;

I looked at this and would need an image to see which report your looking at so I can check My numbers on the same screen and figure them out. I am not sure which Report and I am wondering if this could be Net sales which would be less because Squares fee could be taken out or if the numbers you looked at before did have Cash and Credit card sales. There should be no fees out of Cash sales though so right now I am only guessing at Ideas without seeing the report and what the report has for titles of the data being reported.

Re: Why is there a discrepancy between total daily sales and tax sales report?

FayR — Tue, 01 Apr 2025 00:59:48 GMT

The reports that I am comparing is the "Payment report (cash only) daily total versus the "Sales Tax" report (cash only) daily totals. Some days the Sales Tax total report (taxable sales + non-taxable sales + tax collected) does not add up to the Payment method report for the same day of sales. I did speak with a Square support representative and he stated their was a bug on some days with the calculation of non-taxable sales daily but would average out in the monthly report, of which I have yet to verify.

Re: Why is there a discrepancy between total daily sales and tax sales report?

Candlestore — Tue, 01 Apr 2025 01:20:10 GMT

@FayR ;

Is the the report your looking at? This one is on the dashboard under reports > Payment methods

The 3 areas circled on mine are all the same amounts.

And these amounts for this day equal the amount in my Sales Summary of Total Sales, before Square deducts their fees, which should be $0.00 for cash sales.

Now I am just trying to see which report your reffering to to check my numbers and see if they are off and correct themselves by the end of the month.

Re: Why is there a discrepancy between total daily sales and tax sales report?

MayaP — Mon, 21 Apr 2025 20:08:30 GMT

Thank you @Candlestore for jumping in to help!

Let us know if you still need help @FayR?