Which Tax Rates are applicable for a given Canada province?

[Maciej Król]

Hello,

We are looking for a solution to retrieve tax rates in Business Cloud Accounting for Canada region. We are struggling to spot connections between tax rates, tax types and tax profiles to establish which taxes are available for each Province properly. We were already trying to match Tax Rates based on Tax Types, but we cannot reliably match all available taxes shown in the UI dropdowns, for example, during Sales Invoice creation. 

Therefore I want to ask, Is there any easy solution that we could use to find which tax rates are available for a given province? If not, could you give us a hint on which algorithm we should follow to perform this properly on our side?

Thanks,
Maciej

[Steel, Mark]

Hi Maciej, thank you for your question.

Two of the query params supported by the tax_rates endpoint are usage and address_region_id. usage accepts the values of sales and purchase and address_region_id accepts the province the tax_rates are required for.

An example could be that you need the sales tax_rates for a sales invoice going to a customer in BC. We could use tax_rates?usage=sales&address_region_id=CA-BC and the response would contain the applicable tax_rates.

{
    "$total": 16,
    "$page": 1,
    "$next": null,
    "$back": null,
    "$itemsPerPage": 20,
    "$items": [
        {
            "id": "CA_GST_PST_BC",
            "displayed_as": "GST & PST 12.00%",
            "$path": "/tax_rates/CA_GST_PST_BC"
        },
        {
            "id": "CA_GST",
            "displayed_as": "GST 5.00%",
            "$path": "/tax_rates/CA_GST"
        },
        {
            "id": "CA_PST_BC",
            "displayed_as": "PST 7.00%",
            "$path": "/tax_rates/CA_PST_BC"
        },
        {
            "id": "CA_GST_PST_BC_1",
            "displayed_as": "GST & PST 13.00%",
            "$path": "/tax_rates/CA_GST_PST_BC_1"
        },
        {
            "id": "CA_GST_PST_BC_2",
            "displayed_as": "GST & PST 14.00%",
            "$path": "/tax_rates/CA_GST_PST_BC_2"
        },
        {
            "id": "CA_GST_PST_BC_3",
            "displayed_as": "GST & PST 15.00%",
            "$path": "/tax_rates/CA_GST_PST_BC_3"
        },
        {
            "id": "CA_GST_PST_BC_4",
            "displayed_as": "GST & PST 17.00%",
            "$path": "/tax_rates/CA_GST_PST_BC_4"
        },
        {
            "id": "CA_GST_PST_BC_5",
            "displayed_as": "GST & PST 25.00%",
            "$path": "/tax_rates/CA_GST_PST_BC_5"
        },
        {
            "id": "CA_PST_BC_1",
            "displayed_as": "PST 8.00%",
            "$path": "/tax_rates/CA_PST_BC_1"
        },
        {
            "id": "CA_PST_BC_2",
            "displayed_as": "PST 9.00%",
            "$path": "/tax_rates/CA_PST_BC_2"
        },
        {
            "id": "CA_PST_BC_3",
            "displayed_as": "PST 10.00%",
            "$path": "/tax_rates/CA_PST_BC_3"
        },
        {
            "id": "CA_PST_BC_4",
            "displayed_as": "PST 12.00%",
            "$path": "/tax_rates/CA_PST_BC_4"
        },
        {
            "id": "CA_PST_BC_5",
            "displayed_as": "PST 20.00%",
            "$path": "/tax_rates/CA_PST_BC_5"
        },
        {
            "id": "CA_EXEMPT",
            "displayed_as": "Exempt 0.00%",
            "$path": "/tax_rates/CA_EXEMPT"
        },
        {
            "id": "CA_ZERO",
            "displayed_as": "Zero Rated 0.00%",
            "$path": "/tax_rates/CA_ZERO"
        },
        {
            "id": "CA_NO_TAX",
            "displayed_as": "No Tax",
            "$path": "/tax_rates/CA_NO_TAX"
        }
    ]
}

Supporting Docs:
https://developer.sage.com/accounting/reference/taxes/#operation/getTaxRates

https://developer.sage.com/accounting/guides/concepts/address_region_validation/

Thanks

Mark