About this template
Work type: Bookkeeping
Location: Canada
Client industry: Generic
Version: 1 (Latest)
This template includes
- 7 tasks
Before we generate that file, please let us know more about you.
Sorry, but you can only download 5 Excel files per day.
Please come back tomorrow to download 5 more.
Work type: Bookkeeping
Location: Canada
Client industry: Generic
Version: 1 (Latest)
This template includes
| Team Tasks | ||
|---|---|---|
| Pre-Filing Setup |
Bookkeeper
|
|
| Confirm GST filing period (annual) | ||
| Confirm GST account number + CRA access | ||
| Confirm filing deadline | ||
| Confirm payment deadline | ||
| Gather & Review Financial Data |
Bookkeeper
|
|
| Confirm bookkeeping is complete for full fiscal year | ||
| Review sales reports for GST-taxable vs zero-rated vs exempt sales | ||
| Review expense accounts for GST-eligible ITCs | ||
| Confirm GST rates applied correctly (5% / 0%) | ||
| Identify non-claimable GST (meals, personal portion, etc.) | ||
| GST Reconciliation |
Bookkeeper
|
|
| Reconcile GST collected vs sales reports | ||
| Reconcile GST ITCs vs expense detail | ||
| Reconcile GST payable/refundable account in QBO (or applicable software) | ||
| Investigate discrepancies or unusual variances | ||
| Review prior-year carryforwards or adjustments | ||
| Prepare GST Return |
Bookkeeper
|
|
| Calculate total GST collected | ||
| Calculate total ITCs | ||
| Determine net GST payable or refund | ||
| Review reasonableness vs prior year | ||
| Save detailed working papers to client folder | ||
| File GST Return |
Bookkeeper
|
|
| Notify client GST return is ready for submission - send working copy for reference | ||
| Log in to CRA My Business Account / Represent a Client | ||
| Enter GST return details | ||
| Review return before submission | ||
| Submit GST return | ||
| Save confirmation page | ||
| Payment or Refund Handling |
Bookkeeper
|
|
| Confirm payment method (client / bookkeeper / pre-authorized) | ||
| Schedule or submit GST payment (if payable) | ||
| Save proof of payment | ||
| Confirm refund tracking (if applicable) | ||
| Post-Filing Entries & Cleanup |
Bookkeeper
|
|
| Record GST payment/refund in QBO | ||
| Clear GST payable/refundable account | ||
| Upload filing confirmation + support documents | ||
| Update GST tracking log | ||
Copyright © 2017-2026 Financial Cents LLC