Skip to main content

Run Tax Activity Reports (Canada)

Run the Tax Activity report in Blackpurl to see GST/PST collected on sales and tax paid on purchases for any date range.

Applies To: Canadian Dealerships

When tax filing deadlines approach, you need a clear breakdown of GST, PST, or HST collected on sales and paid on purchases. The Tax Activity Report pulls this data from your Blackpurl transactions for any date range, so you can verify amounts with your GL and submit accurate filings to CRA and provincial authorities.

Run the Tax Activity Report

  1. Go to Other Tools > Tax Activity & Settings

  2. Stay on the Activity tab

  3. Enter your From and To dates

  4. Click Search

Pro Tip: The report excludes internal invoices by default. Uncheck Exclude Internal Invoices and re-run if you need to include them.


What the Report Shows

Tax Collected on Sales

Column

What It Shows

Tax Name

Individual sales taxes (GST, PST, HST) and the combined total

Transaction Count

Number of transactions for each tax type

Taxable Amount

Total amount subject to this tax

Tax Amount

Actual tax calculated

Non-Taxable Amount

Amounts exempt from this tax

Tax Paid on Purchases

Column

What It Shows

Tax Name

Individual purchase taxes and the combined total

Transaction Count

Number of transactions for each tax type

Taxable Amount

Total amount subject to this tax

Tax Amount

Actual tax calculated

Non-Taxable Amount

Amounts exempt from this tax


View Transaction Details

Click any Tax Name row to see the individual transactions that make up that total.

From the detail view:

  • Review transactions on screen

  • Click Print/Export to generate a detailed report

  • Click Back to return to the summary


Export the Report

Click Print/Export from either the summary or detail view. The export includes:

  • Summary totals by tax type

  • Individual transaction details (when exported from detail view)


What Happens Next

Use this report to:

  • Prepare GST/HST filings to CRA

  • Prepare provincial sales tax filings

  • Reconcile with your BP Tax Collected and BP Tax Paid GL accounts

  • Identify discrepancies before filing deadlines

When filing with the government authority, allocate payment to the BP Tax Collected/Tax Paid GLs in your accounting package.

Did this answer your question?