Review GST/HST Overview and Detail
Review recorded GST/HST collected and eligible tax amounts for a selected period.
Availability
GST/HST report navigation appears when tracking is enabled or when the Workspace has posted GST/HST history, including posted zero-rated transactions. A period without activity can show an empty report.
GST/HST Overview
- Open Reports > GST/HST Overview.
- Open Prepare Return, or use GST/HST Summary, and choose a Report Period. From and To remain editable. Changing
either date selects Custom Range; select Apply to load the new dates.
- Review the CRA-aligned working lines. Line 101 reports sales and other
revenue before GST/HST and provincial sales tax, including completed zero-rated or exempt income. Income/Other Income Journal Entry activity is included only when it carries an Exempt, Zero-rated, GST, or HST sales classification. A blank Sales Tax selection and Out of Scope are excluded. Lines 103 and 106 are calculated from completed bookkeeping records; the report also shows their calculated totals through Lines 105, 108, 109, 113A, and 113C. The Transactions value counts each source transaction once, including a split transaction that contributes more than one detail line.
- Lines 103, 104, 106 and 107 include explicit adjustments. Net Tax is
(103 + 104) minus (106 + 107). Lines 110 and 111 include explicitly recorded instalments and rebates. Balance subtracts those credits from Net Tax. Lines 205 and 405 remain unsupported and show a dash.
- Select Line 101 to review its supporting income, Line 103 or 105 to review
collected-tax details, or Line 106 or 108 to review ITC details. Net and balance lines open the complete GST/HST detail for the same period. Use Back to GST/HST Overview in the detail report card to return without losing the selected period.
- Use Download (Excel, PDF or CSV) or Print when required. The output follows the selected period.
Purchase refunds and credits reduce the related Line 106 input tax credit when they are posted to an eligible Expense or asset account. They are not treated as sales merely because money was received. The saved recoverable percentage also applies to eligible asset purchases. Likewise, reductions posted to an Income account reduce Line 103. Completed income marked Out of Scope is excluded from Line 101; exempt and zero-rated income remains included.
Record a filing or settlement
Use Prepare Return to review the calculation. After filing externally, use Mark as Filed with the filed date; the filing confirmation number is optional and is not the tax amount. The filing and its snapshot are saved together. See the preparation workflow below. If you record a payment or refund settlement, enter its actual date and reference. Recording a settlement does not move funds.
Before saving, xBoox recalculates the exact selected period. If Line 101 revenue, tax totals, or currency changed after the report loaded, refresh the report and review the current figures before saving. If another user changed the filing record, or a bookkeeping change occurred while saving, xBoox rejects the stale save and asks you to refresh. The filing record and its audit entry are saved together. Saving also preserves a snapshot of Line 101 revenue, calculated collected tax, ITCs, net tax, total other credits, and currency shown for that period. If historical bookkeeping is changed later, use the snapshot to identify that the current calculation differs from the amount previously reviewed or filed.
xBoox saves this as a Workspace audit record. It does not file with the CRA, create a payment or refund, link a bank transaction, clear account 2500 GST/HST Payable, or move an instalment from account 1300 automatically. Record the actual bank transaction using the appropriate reviewed Category and retain CRA evidence with your records. Ask an Accountant when a filing-period difference needs an accounting adjustment.
GST/HST Detail
- Open Reports > GST/HST Detail.
- Use the same period controls.
- Review transaction-level tax records and saved tax snapshots.
- Use Export CSV or Print for supporting review.
Detail groups records under Line 103 and Line 106. Line 110 and Line 111 groups appear when the selected period contains recorded instalments or rebates. Select a group to expand or collapse it. Opening Detail from a Summary line opens that group for the same period; Line 101 has its own revenue drilldown.
Each expanded group starts with 50 records per page. Groups with 50 or fewer records hide the pagination bar; their total row remains visible. Groups with more than 50 records retain the controls even when a larger page size fits all records. Use Rows per Page to choose 50, 100, 200, 300 or 500 records, and Previous / Next to move through that group's records. Changing the page size resets all groups to their first page. Its total includes every record in the selected period. CSV and Print include every matching record, regardless of collapsed groups or pagination. Select a transaction or Journal Entry row to open its source details.
Data rules
- Reports use tax amounts stored on completed transactions.
- An explicitly adjusted GST or HST component uses its confirmed saved amount;
the report does not recalculate that component from the current tax rate. A Split contributes its saved line components using each line's money direction. PST and QST remain separate provincial amounts.
- Dashboard uses the same collected-tax and recoverable-ITC calculation for
the selected date range, including the saved recoverable percentage and signed refund adjustments. Its GST/HST Owing card displays zero when the period has a net credit; open the report to review that credit.
- GST/HST return direction follows the posting account's accounting
classification and Money Direction. A money-in refund posted to an Expense or eligible asset account reduces ITCs instead of increasing tax collected. Split asset purchases and refunds follow the same rule as non-split activity.
- Imported explicit tax may retain an override flag and source values.
- Historical transactions retain saved tax-code labels and rate snapshots when available.
- PST may be stored for audit and expense treatment but is not the same as a GST/HST input tax credit.
Important boundaries
These reports do not:
- file GST/HST;
- compare xBoox automatically with a filed return or CRA balance;
- create a remittance, refund, or automatic account-clearing entry;
- guarantee tax eligibility or treatment.
Use the reports for review and Accountant handoff.
Related articles
Note and memo length
Note, memo, description, and review-reason inputs use a single line. Use the left and right arrow keys to move through longer text without expanding the form. New or edited text is limited to 500 characters; typing stops at the limit, and pasted text is silently shortened. No character counter or extra dialog appears. Existing longer notes are preserved when you save other changes without changing that text. Imported working Bank Memo fields are limited to 500 characters; the original import source is retained separately.
Saved changes and report updates
A successful bookkeeping change reloads the currently open report. Other reports update when opened. Applied periods and filters remain selected; detail sorting and page size remain selected, with the page adjusted if fewer pages remain. If the report cannot reload after a successful save, refresh it without entering the transaction again. See Choose the right xBoox report for Category changes and split-transaction membership.
Purchase credits
A purchase refund against an Expense Category reduces the corresponding purchase tax/ITC amounts according to the saved tax snapshot. Its Deposit or Credit Card Credit document name does not turn it into sales tax collected on revenue. Review the vendor's credit document when choosing tax components; a classification-only update does not recalculate historical tax amounts.
Report Period offers month, year (and eligible fiscal-year) presets and Custom Range. This Quarter and Last Quarter are not preset choices; use Custom Range for those dates.
Customize detail columns
In the transaction detail report, Customize appears before Refresh, Download and Print. Its first section is Columns. Choose columns, then Apply. Transaction Number and Name, where available, start hidden. Reset restores default choices in the draft; Cancel, Close, Escape or clicking outside discards the draft. Choices are remembered in this browser separately for each detail report. Detail downloads and printing respect the corresponding column choices without changing the report amounts or record scope.
GST/HST Detail keeps each return-line group’s expand/collapse control. It has no Expand All or Collapse All buttons.
Use Back to GST/HST Overview at the top-left of the detail report card to return to Overview with the current period. This uses the same arrow-and-text navigation as other report details.
Download formats
GST/HST Overview offers Excel, PDF and CSV. GST/HST Detail offers Excel and CSV, respecting the selected line, applied period and chosen columns and including all matching rows rather than only the visible page. Money, tax rates and transaction counts use their corresponding formats. Print remains available. Export formats do not alter GST/HST calculations or filing status.
Excel data row height
Page-level Excel downloads use fixed-height data rows with automatic text wrapping off. Long Memo, Note, Description and account text remains fully stored in the cell. Widen the column or select the cell and use the formula bar to read it; fonts are not shrunk to fit. Column headings may wrap separately. This presentation rule does not alter amounts, records, CSV or PDF output. Settings Data Export is outside this update.
Detail Excel downloads size columns by purpose: compact dates, identifiers and types, wider account/category names and Memo/Description fields, with suitable monetary widths. Customize column choices retain the matching width when columns move or disappear. Summary statements retain their account-first layout.
Excel titles, Workspace/period labels, scope notes and column headings are separate from fixed-height data rows: they wrap and receive additional row height as needed. Scope notes span the table width. Summary exports freeze the rows above the data without freezing the first column; detail exports also freeze the first identification column. The freeze line is an Excel viewing aid, not a printed border. Account columns remain text columns. Settings Data Export remains outside this update.
Excel expandable groups
Excel downloads preserve all matching rows. Only General Ledger and GST/HST Detail use native row outlines, initially collapsed to summary/total rows. Use Excel plus/minus controls to expand them. All other Excel reports show their rows without collapse controls. This does not change amounts, row completeness, or the app’s expand/collapse controls. Detail rows retain fixed height without automatic wrapping.
Flat reports, including GST/HST Overview, Account Summary, Trial Balance, transaction drilldowns, Journal Entries and Transfers, keep their existing layout. CSV and PDF/Print output are unchanged. Settings Data Export remains outside this update.
Report date controls
Corporations with valid fiscal settings default to This Fiscal Year to Date; other workspaces default to This Year to Date. Full-year choices remain available. Preset From and To dates are editable. Editing either date selects Custom Range, and Apply loads the complete range. Drilldown retains the selected dates and corresponding period label. Comparison drilldown uses the clicked column and Back restores the comparison settings.
Simple Tracking menu and export scope
Simple Tracking provides Profit & Loss and Profit & Loss Comparison, plus GST/HST Overview and Detail when tax tracking is enabled or posted GST/HST history exists. Rental Property Summary is unavailable: use the rental income and expense Categories in Profit & Loss. Accountant Export opens the Accountant Package option in Data Export & Download. Its guide describes Income, Expenses and Categories; retained historical records can still be included. Return adjustments retain Evidence Reference and Save Adjustment; Journal Entry references identify existing accounting evidence when applicable.
Journal Entries now use Edit and Delete, without an automatic reversal action. Deleting an eligible entry removes its amounts from reports for its original date; audit evidence is retained. A later-period adjustment must be entered as a separate manual entry. Generated entries remain controlled by their source workflow. See the Journal Entries help article for deletion restrictions.
Adjustments and Filed-period corrections
In Overview, open the target period’s Prepare Return or View Summary. Use Adjust beside Lines 103, 104, 106, 107, 110 or 111. Enter a signed tax amount, date and optional Memo. Review the line and balance preview.
Choose Update Return Only — No Ledger Posting when the accounting is already correct. Choose Update Books and Return when a balanced accounting entry is also needed, and select an eligible adjustment account. Avoid recording the same accounting correction twice. The current creation drawer does not link an existing Journal Entry or request a separate Evidence Reference. GST Installment can be used as an adjustment account. No historical conversion occurs.
Delete removes the adjustment’s return contribution and its own posting, retaining deletion evidence and audit history. A legacy adjustment’s independently linked Journal Entry is retained. Reconciliation and other business links can still prevent deletion. Generated entries must be changed through their source.
Confirm changes involving a Filed period
Ordinary income, expense, manual Journal Entry, bank posting, split, matching, Undo and adjustment operations involving a Filed GST/HST period require an explicit acknowledgement. Editing checks the original and revised dates; creation and deletion check the affected dates. Adjustment periods are also checked. The checkbox starts unchecked. Cancel retains the form. Permissions, reconciliation, matching and source-record protections still apply.
The confirmation does not calculate whether your particular change alters tax. You must assess its filing impact. The original filing snapshot and Filed status are preserved. xBoox does not amend a CRA return or automatically carry a difference to another return.
View a Filed return and exceptions
In the Filed list, View Summary opens the saved GST/HST Summary. Its dropdown provides View GST/HST Detail for the original source snapshot and View Exception Details for the GST/HST Exception Report. Standard reports outside this saved filing view continue to show current bookkeeping data.
The exception report compares filed and current amounts, showing additions, modifications and records removed from the period. Removal can mean deletion, a date change or loss of report eligibility. Expand Before / After for the saved source information, tax code, tax rate and net/tax amounts. Summary rows keep revenue, tax and credit amounts separate. A source can change while its tax difference remains zero. Historical returns without detailed snapshots explicitly show that comparison is unavailable; this is not a zero-difference result.
Link a manual correction
Review each difference and determine whether an adjustment is needed. Create a manual adjustment in the appropriate target period, then select it under Manual Adjustment Links in the exception report and explain its purpose. Partial corrections and multiple links are allowed. Existing links remain visible so you can avoid duplicate adjustments. The selector lists the latest 200 adjustments.
A link documents your action; it does not change report amounts, eliminate the historical difference, confirm a CRA amendment, or automatically resolve it. If the source changes again or the adjustment is deleted, the link requires review. Unlink removes the active association and preserves its audit history. Only Workspace Owners and members with transaction-edit access may change links.
Prepare an externally filed return
Review the figures, then record the external filed date with Mark as Filed. This does not submit to CRA or create a bank payment. Once Filed, the saved filing itself cannot be overwritten. Correct the underlying books with acknowledgement and review exceptions instead.
All Dates
All Dates appears immediately above Custom Range in Report Period. It fills From and To with the earliest and latest financial dates in the current Workspace, including Posted transactions, posted/reversed journal entries, and saved non-zero opening balances. Pending, Waiting Match, Ignored and deleted transactions do not extend this range. Other report filters still apply. An empty Workspace uses today's date for both fields and displays an empty report. Select Refresh to include newly available dates. Editing either date switches to Custom Range; apply the edited range normally. Default periods are unchanged. Balance Sheet remains an as-of-To snapshot; comparison reports retain their selected comparison mode.
Choose how an adjustment affects your books
Select Adjust beside the required return line. The line is fixed by that entry point. Enter the adjustment amount, not the final total: positive adds to the line and negative subtracts. Select an Adjustment Effect; neither option is selected by default. Each selection, including selecting the same option again, opens an explanation. Close it with Got it; it does not save. Update Books and Return creates a balanced Journal Entry and requires an Adjustment Account. Update Return Only changes the current return summary without changing account balances; use it only when the books are already correct. The left-aligned preview shows the line, Net Tax and Balance before and after. Select Save Adjustment to save. The adjustment list keeps the effective date separate from creation details. Deleted adjustments remain in history and do not contribute to current totals. No adjustment submits to CRA or replaces the original Filed snapshot.
2026-11-10 — Adjustment record presentation
Adjustment records use Date, Line, Treatment, Amount, Reason and Reference, Action. Select a row (or press Enter/Space) to open its details. Delete is a separate action. New Books and Return entries carry a system-generated note, period and return line, preserving the user memo. Their Journal Entry source displays GST/HST Adjustment. Existing notes are not backfilled.
2026-11-10 — Filing groups and date ranges
To File and Filed each have a disclosure arrow. Each group starts expanded with ten or fewer records and collapsed with more than ten. Select the heading to toggle. Date ranges use To between ISO dates. An empty filing confirmation number does not leave a separator after Filed Date.
2026-11-10 — Filed detail and exception report navigation
Filed → View GST/HST Detail opens the shared detail report with Filed Snapshot (Not Current Books) and a fixed filing period. Ordinary GST/HST Detail keeps its existing title and controls. View Exception Details opens a separate GST/HST Exception Report with Filed, Current, Difference and the comparison time. Refresh recomputes the comparison. Select a difference row for the Filed / Current source drawer; its reference opens the current original record. Print and export use the displayed comparison. Returning to Overview restores the group state and position for this navigation. Missing detailed snapshots are identified and never replaced with current books. Linked manual adjustments do not erase differences, carry them forward automatically or submit a CRA amendment.
2026-11-10 — GST review corrections
Filed Summary exports use the saved snapshot. Older returns without a saved summary identify it as unavailable; current books never replace historical figures. Current adjustment records are labelled separately. Filed periods cannot overlap. Filing dates must be real calendar dates. Line 101 revenue changes are included in Exception sources; their amounts are revenue amounts. Overview shows Other Credits separately. Only Owners can change GST reporting settings; an existing filing fixes the next start to the following day. Saved settings refresh Overview. In Manual Adjustment Links, filter loaded adjustments and select Load more adjustments to reach older records.
2026-11-10 — Historical source coverage
Filed menus use View GST/HST Detail (Filed Snapshot) and View Exception Detail. Line 101 compares revenue amounts while source details retain original tax amounts. If historical revenue details were not saved, Line 101 source comparison is unavailable; saved summary amounts are still compared. A return with only saved summary fields displays a Limited Historical Summary: missing amounts say Not saved, and historical detail is unavailable. No current amounts replace missing history.