Gross Sales Tax issue

Questions
1

Hi, in our order object we’ve two different types of taxes object

  1. “taxes”: {
    “catalog_version”: 1626124235541,
    “uid”: “1f870e91-81e9-452f-b234-93972647554f”,
    “catalog_object_id”: “DQIMRPMR7JVVAKZZXFVOXOOK”,
    “applied_money”: {
    “amount”: 79,
    “currency”: “USD”
    },
    “percentage”: “7.0”,
    “scope”: “LINE_ITEM”,
    “name”: “Oconnee stores”,
    “type”: “INCLUSIVE”
    }
    2.“taxes”: {
    “catalog_version”: 1613741630577,
    “uid”: “1334B4A9-3914-4944-8B55-3AD0E6DE7A10”,
    “catalog_object_id”: “DQIMRPMR7JVVAKZZXFVOXOOK”,
    “applied_money”: {
    “amount”: 0,
    “currency”: “USD”
    },
    “percentage”: “7”,
    “scope”: “LINE_ITEM”,
    “name”: “Oconnee stores”,
    “type”: “INCLUSIVE”
    }
    Please observe that uid in the 1st case contains numeric and small letters while in the 2nd case it’s numeric and upper case. Also, percentage is decimal in 1st case, integer in 2nd case while both being 7. The issue we’re facing is, in our order object that having the 1st type of tax gross_sales includes this tax but in the second case, it is not(Checked with the square UI and on our platform). So my questions are,
    Q. Is it normal for taxes to be of both forms?
    Q. While gross_sales is pretty much straight forward why in the 1st case tax is added there?

Thanks in advance.

2

:wave: Do you have the order_id that you are seeing two different tax objects in?

3

Hi @Bryan-Square, here are the two of the order ids
“Ud6lrCdJcVmNB51pkyIrX2JgKpKZY” - in this case, we need to subtract total_tax_money.amount from gross_sales.amount for line_items to match the gross sales in square UI.
“SGMOUYqCvN7vvGVxSZWmXO3eV” - in this case, gross_sales are matching.

4

Hi @Bryan-Square any update?

6

Hi, There is something I found digging more. Sharing here if it helps:
Our tax was inclusive, some of the gross sales had tax cooked in. In those case variation_total_price = gross_sales + modifier_total
Checked for this and subtracted the tax from gross_sales there. For example, we had latte to have tax included(in the image) but for one of the variations, tax was added in gross sales for other variations it wasn’t.

image
image1920×961 111 KB

There may be something with the catalog API where we can find the reason. But I couldn’t. Maybe @Bryan-Square can help.

7

:wave: The two orders that you provided were created by two different services within Square.One was created with the API and the other was created with the Square app. This is the reason for the different appearance of the taxes in the order. :slightly_smiling_face: