You can use the Trial Balance OR Transaction and Payment Reconciliation report to identify tax liabilities.

 

 

A swift and exact report is available for the Tax Liabilities, and that is the Trial Balance report.  You will see when you are in that report that you will have a 'slicer' which allows you to filter by province.

After selecting the Ontario Risk province (as an example) in the Trial Balance report, it would match the same amount shown in the below report (Transaction and Payment report). 

 

 

 

As you can see, you can isolate your account balances by province.

 

 

 

To see the real tax liability in the Transaction and Payment report, you need to use the Transaction Type slicer to unselect any payment adjustments/payment changes:

 

 

Once you do that, the amounts match QBO (Quickbooks online), if applicable to you, and will provide the correct amount. 

 

 

You should just use the Trial Balance report or rely on what is in QBO (if you have integration). 

With this detail provided from the Trial Balance report, you could then do a quick reclass entry in QBO to divide up the revenue by province each month.