PST Remittance BC Excel - Free Template

1. Open the Transactions sheet and enter each taxable sale on its own row. Keep the transaction date, invoice number, customer name, and province consistent so your totals stay clean.
2. Enter the taxable amount, PST rate, PST collected, and exempt amount for each line. For example, 10 sales of $250.00 at 7% PST produce $17.50 each, or $175.00 in total PST.
3. Use the remittance period column to group the rows for the filing period you are reporting. That makes it easier to total one month or one quarter without sorting through the whole year.
4. Check the PST Remittance Summary sheet after you finish your entries. Use it to confirm the total taxable sales, total PST collected, and exempt amounts before you file.
5. Review the Notes column for anything unusual, such as exempt services or a customer deduction that needs support. This is the place to flag items you may want to explain later.
6. Copy the sheet forward for the next filing period instead of starting from scratch. That keeps your column structure intact and cuts data-entry time.

You usually need this workbook when you are collecting PST on taxable sales in British Columbia and want a clear running total before the return goes in. A sole proprietor with 40 invoices a month can enter each sale as it happens, while a bookkeeper at a trades company can use it to prepare a month-end summary in under an hour.

Who uses it and when

An office manager at a plumbing shop might use it after each weekly invoice run, especially if the shop sells parts, fixtures, and labour on separate lines. A non-profit selling tickets or merchandise can use the same structure to separate taxable and exempt amounts before a season-end remittance check.

A practical example

If you bill 120 taxable invoices in a quarter at an average of $180.00, that is $21,600.00 of taxable sales. At 7% PST, the remittance total is $1,512.00, and a sheet like this gives you a row-by-row record to back that number up.

Why the sheet layout matters

The Transactions sheet in image 1 keeps the taxable amount, PST rate, and PST collected in separate columns, which is much easier to audit than burying everything in a memo. The summary in image 2 then gives you the filing total without forcing you to rebuild the math by hand.

In British Columbia, the PST rate is generally 7% on taxable goods and services, so you need to keep the tax shown separately instead of blending it into the sale price. If you sell $1,250.00 of taxable materials, the PST collected is $87.50, and that belongs in your remittance records as a distinct line.

Registration and filing basics

If your business is registered to collect PST, you need records that support each return period and the amounts reported. This workbook helps you separate taxable sales from exempt amounts, which matters when you file monthly or other required periods through your provincial account.

Record retention and traceability

The CRA’s six-year record-retention rule is the standard you should work around for business records, and a neat spreadsheet is easier to keep than loose paper slips. If you have 300 transactions in a quarter, a searchable sheet is the difference between finding one invoice in two minutes and spending half a day sorting folders.

Why the rate column matters

The PST rate column in image 1 is useful even when you mostly charge the same rate, because it shows what was actually applied on each transaction. If one exempt sale slips in, the separate exempt amount column prevents you from overstating tax collected by mistake.

The most expensive mistake is mixing taxable and exempt sales in one total and then remitting too much or too little tax. If you collect PST on $18,000.00 of sales but accidentally include another $4,000.00 of exempt revenue, your filing total is wrong before you even start the return.

Missing or inconsistent rates

Another problem is leaving the PST rate blank and trying to fix it from memory later. That works on 10 rows; it falls apart on 200 rows, especially when you have mixed transactions such as materials, shipping, and services on the same invoice.

Duplicate invoices and poor notes

Double-entered invoices can inflate your remittance total by hundreds of dollars. For example, duplicate a $950.00 invoice at 7% and you overstate PST by $66.50, then spend time untangling which sale was real.

The cost of sloppy filing support

If you cannot explain why a sale was exempt, the missing note becomes a problem at review time. A clean notes column and a separate exempt amount field are much easier to defend than a spreadsheet full of merged totals and blank cells.

Those same notes also line up with a business expense record when you need to separate mixed invoices into deductible costs and taxable amounts.

The easiest way to keep this workbook alive is to tie it to one fixed task, such as your month-end close or your remittance deadline. If you process sales every Friday, spend 10 minutes that afternoon updating the Transactions sheet instead of waiting until the end of the quarter.

Simple habits that stick

• Copy the prior period’s sheet and clear only the rows you no longer need.
• Enter invoices on the same day they are issued so the remittance period stays current.
• Review the summary sheet before you send money to the province.
• Use the notes column to flag exempt items, adjustments, and questions.

When a spreadsheet is no longer enough

If you are handling 500 or more taxable invoices a month, a spreadsheet starts to feel tight. At that point, accounting software with tax codes and locked audit trails is usually the better move, while the workbook still works well as a review tool.

That same workbook can still serve as a review tool, while the quick HST calculation sheet keeps the remittance figures easy to check.