Article ID: 9083

Cannot Reconcile the GST/HST Journal to the GST/HST Payable (2400) Account

Problem Description:

The General Reconciliation Balance on the GST/HST Journal displays the G/L GST/HST Payable (2400) balance. The report shows the General Reconciliation Balance as of the end date of the report period. This balance does not match the Payment Enclosed (115) or the Refund Claimed (114) rows on the GST/HST Journal when you run the report for a specific period. The difference occurs because the remittance posts to the GST/HST Payable (2400) as of the check (cheque) date, but the remittance posts to the GST/HST Journal as of the remittance period end date.

Suggested Actions:

Use the following guidelines to determine when the GST/HST Journal includes or excludes the remittance amount:

  • Only the Running Balance from rows 110 through 115 and the General Reconciliation Balance include the remittance amount when the check date is before the report End Date and the remittance period ends before the report Start Date.
  • The Period Totals and Running Balance from rows 110 through 115 and the General Reconciliation Balance include the remittance amount when the check date and remittance period ends between the report Start and End Date.
  • Only the Running Balance from rows 110 through 115 include the remittance amount when the check date is after the report End Date and the remittance period ends before the report Start Date.
  • Only the Period Totals and Running Balance from rows 110 through 115 include the remittance amount when the check date is after the report End Date and the remittance period ends between the report Start and End Date.
  • The report excludes the remittance amount when the check date and the remittance period end date is after the report End Date.