QuickBooks Online Canada: exporting data for T2 and GIFI review
A practical, plain-English article about using QuickBooks Online reports while preparing Canadian corporate tax working papers.
This page is general information. It does not confirm service availability, pricing, or suitability at a specific address.
What this article is about
This article is a practical Canadian small-business note about getting useful tax-return numbers out of QuickBooks Online when preparing a corporation income tax return. It is written from an operator’s point of view, not as professional accounting advice.
For a T2 return, the Canada Revenue Agency’s GIFI categories are broad financial-statement categories. The practical job is to review the bookkeeping, export the trial balance or reports, and map accounts to the right GIFI areas.
Useful QuickBooks Online reports
Start with reports such as Profit and Loss, Balance Sheet, Trial Balance, General Ledger, and Account List. Use the corporation’s fiscal year, not the calendar year, unless they are the same.
Export reports to Excel or CSV when you need to clean up account names, group categories, check totals, or provide working papers to an accountant.
Common GIFI mapping ideas
| Bookkeeping area | Possible GIFI area to review |
|---|---|
| Bank balances | Cash and deposits |
| Accounts receivable | Trade receivables or other receivables |
| PayPal, Stripe, merchant clearing | Cash, deposits, receivables, or clearing accounts depending on how recorded |
| Sales revenue | Sales of goods and services or other revenue categories |
| Bank and merchant fees | Bank charges, merchant fees, or similar expense lines |
| Domain names, software, hosting, tools | Computer, internet, software, office, advertising, or other categories depending on use |
| GST/HST payable or receivable | Sales tax balances |
| Shareholder loan | Due to or from shareholder, depending on balance and accounting treatment |
Checks before filing
- Confirm the fiscal year dates.
- Reconcile bank, PayPal, Stripe, and other payment accounts.
- Look for negative asset or liability balances that may indicate posting problems.
- Review Uncategorized Income, Uncategorized Expense, Suspense, and Ask My Accountant accounts.
- Separate shareholder transactions from business revenue and expenses.
- Make sure GST/HST balances make sense against filings.
- Keep exported reports and notes with the tax working papers.
Important caution
This page is general educational information. GIFI mapping and T2 preparation can affect taxes, losses, shareholder balances, GST/HST, and corporate records. When in doubt, use qualified accounting or tax advice.