Transaction Adjustments? WooCommerce Square Showing Different Information

[mmiller3601]

We are currently setting up a WooCommerce Store using 'WooCommerce Square' plugin. When an order is processed we noticed there are some discrepancies between WooCommerce order and the Square Transaction.

In the WooCommerce order the following information is shown:
Items Subtotal: $57.69
Coupon(s): - $6.15
Shipping: $0.00
Tax: $1.62
Order Total: $53.16
Paid: $53.16

But when you look at the Transaction in Square the following information is shown:

Adjustment: $0.18

Discount: -$6.15

Subtotal: $51.72

Tax: $1.45

TOTAL: $53.17


What is the "Adjustment" line? I can seem to find an explanation of this anywhere.
Why is the Tax being changed? We are using WooCommerce (Taxjar) to calculate the Tax from the site.
The customer was charged $53.17 even though the order total in WooCommerce was $53.16?
It also seems in the sales report that the shipping has been "sold" like a product? This would cause issues with sales reporting.

This would make the integration difficult to use as they are reflecting different information.

[Candlestore]

@mmiller3601 ,

In Woocommerce

: In the WooCommerce order the following information is shown:
Items Subtotal: $57.69                                        57.69
Coupon(s): - $6.15                                               - 6.15
Shipping: $0.00                                                   -0.00
Tax: $1.62                                                             +1.62     Tax rate 3.15%?

Order Total: $53.16                                             -------

Paid: $53.16                                                         53.16

In Square:

Adjustment: $0.18                                               51.72 + 6.15= 57.87 ?      $ 57.87 Squares sales price?- 57.69 Woo commerce Sales price = .18

Discount: -$6.15

Subtotal: $51.72

Tax: $1.45                                                            Tax rate 2.8%?

TOTAL: $53.17

What do you have the sales price of the item at....$57.87 or $57.69?

What is your tax rate?  3.15% or 2.8% 

This just odd and trying to help ... I did figure these numbers out but not sure where or why they are the way they are.

[mmiller3601]

Hi, Thanks for looking at this. Here is more information that may be helpful.
On WooCommerce the following information is shown:

Product	Price	Discount	Total	Tax
Mug	$26.96		$26.96	$1.62
Tee Shirt A	$12.79	$2.79	$10.24	$0
Tee Shirt B	$17.95	$3.60	$14.35	$0

Items Subtotal	$57.69
Coupon	-$6.15
Shipping (Store Pickup)	$0.00
Tax	$1.62
Order Total	$53.16
Paid	$53.16

In Square Transaction the following information is shown:

Mug	$26.95
Tee Shirt A	$12.79
Tee Shirt B	$17.95
Store Pickup	$0.00
Adjustment	$0.18
Discount	-$6.15
Subtotal	$51.72
Tax	$1.45
Total	$53.17

Is the adjustment a Square Charge then?
Why is the tax being changed?

[Candlestore]

@mmiller3601 

So far this morning I am looking at these new numbers you gave me fro Woo Commerce.

If you add up all 3 of your items you get $57.70

If you add up you 2 discounts you get $6.39

This gives you $51.31 for a total sales price before adding in taxes of $1.62

   Total sales after discount 51.31

+ Taxes                                     1.62

------------------------------------------

Total charge to customer    52.93

Woo Commerce

Seems messed up unless I am missing something else....

T-Shirt A $12.79 - $2.79 is $10 not $10.24 for a total

I copied your chart for Woocommerce and added the columns up..... but they do not match what is on their information

Product	Price	Discount	Price-Discount	Total	Tax
Mug	$26.96		$26.96	$26.96	$1.62
Tee Shirt A	$12.79	$2.79	$10.00	$10.24	$0
Tee Shirt B	$17.95	$3.60	$14.35	$14.35	$0
totals	$57.70	6.39	$51.31	$51.55	$1.62

Even Squares Discount does not match the 6.39 total discount both come to a discount of $6.15?

The .18 cent adjustment seems to be the difference in taxes with 1 cent for adjustment for rounding.

But why the difference in taxes?   What are your taxes for Woo Commerce and for Square?

[mmiller3601]

Right, Sorry, I keep messing the number up let me put them in correctly. Again Sorry, thank you for looking into this.

In WooCommerce the following information:

Item	Cost	Qty	Discount	Total	Tax
Mug	$26.95	1	$0.00	$26.95	$1.62
Tee Shirt A	$12.79	1	$2.55	$10.24	$0.00
Tee Shirt B	$17.95	1	$3.60	$14.35	$0.00

Items Subtotal	$57.69
Coupon	-$6.15
Shipping (Store Pickup)	$0.00
Tax	$1.62
Order Total	$53.16

In Square Transaction the following information:

Mug	$26.95
Tee Shirt A	$12.79
Tee Shirt B	$17.95
Shipping (Store Pickup)	$0.00
Adjustment	$0.18
Discount	-$6.15
Subtotal	$51.72
Tax	$1.45
Total	$53.17

I have double-checked these numbers with another person and they are now correct. Sorry for not providing them straight away.

[Candlestore]

@mmiller3601 ;

If you go to :

https://squareup.com/dashboard/sales/transactions 

Then press the button Export and choose from the drop down Items Detail CSV

and get a report on the transaction in question It should show the tax amounts for each item.

But What does Woo Commerce have for your Tax rate?

What do you have for Square for the Tax rate?

That seems to be the issue.  Woo Commerce is charging a higher tax rate than Square.

The difference alone in taxes is 17 cents... Square has a adjustment to Raise the tax by 18 cents.... this is to match what was accepted as payment.   The 1 cent difference between the 17 and 18 cents could be a rounding difference.

I think your big issue is the Tax rates in Woo Commerce and in Square not matching.  I do not use Woo Commerce to know how to update tax rates.   You may need to contact them to see what rate they are charging you.

[mmiller3601]

I did as you said and got the following data:

Item	Qty	Price Point Name	Modifiers Applied	Gross Sales	Discounts	Net Sales	Tax
Mug	1	White		$26.95	$-2.86	$24.09	$1.45
Tee Shirt A	1	Large		$12.79	$-1.36	$11.43	$0.00
Tee Shirt B	1	Oxford, Small		$17.95	$-1.91	$16.04	$0.00
Store Pickup	1			$0.00	$0.00	$0.00	$0.00
Adjustment	1			$0.18	$-0.02	$0.16	$0.00

This doesn't make sense at all, why has Square changed the data transmitted from WooCommerce?

The tax rate in WooCommerce is coming from Taxjar and is the correct rate of 6% (on items of tax) now I have noticed on our Mug product in Square we have No taxes setup which is incorrect but doesn't explain the Square transaction behaviour. I will correct this and do more tests and post results

[Candlestore]

@mmiller3601 ;

I just redid the math you gave me from Both Woo Commerce and Square

Woo Commerce is doing the tax on the Mug at $26.95 without the Discount.

26.95*.06 = 1.617..... rounded to 1.62

Where Square is using $24.09 after the Discount is applied.

24.09*.06 =  1.4454.... rounded to 1.45

So Woo Commerce is charging tax on the Gross Sale and then because of the difference in Tax calculation Square added the Adjustment to balance what Woo Commerce is reporting with the charge to equal what Square Calculates for the cost of the item.  

Seems like you need to find out why the tax is being charged on the Gross price and not the Net price after the discount form either TaxJar or Woo Commerce.