I have switched from SAGE 50 to Quickbooks Online. SAGE has different accounts for the GST/HST.
My issue is: Background - My husband bought a new vehicle that is strictly a work vehicle. Instead of receiving the GST/HST paid on it as a refund he opted to use this against the quarterly GST/HST filings until it has been used up. As of Jan 1 2025 GST/HST Charged on Sales was $1670.57 and GST/HST Paid on Purchases was $6280.86 for the period Oct - Dec 2024. The filing on Line 103 for Oct - Dec 2024 was $1671.27 (collected in the reporting period) and on Line 106 was filed as $1671.27 (ITCs collected for the reporting period) resulting in a zero balance - no refund and no payment. This was Netfiled on Jan 30 2024 by our previous accountants.
I made a journal entry for Jan 30 2025 showing this amount for Lines 103 and 106 resulting in the reduction from GST/HST collected and GST/HST paid for Jan - Mar 2025 to keep everything balanced in the Quickbooks account GST/HST Payable.
My issue is: I want to keep reducing the refund owing using the quarterly filings. How do I do this in Quickbooks? The GST/HST collected/charged on sales is $703.79 and shows on line 103. However, line 106 shows $5274.31 which is the opening balance of $6280.86 minus the $1671.27 plus and GST/HST Paid on purchases for the period of Jan - Mar 2025 of $664.72 resulting in a refund of $4570.52. My husband wants to use this refund against future quarterly filings.
I only want to show the $703.79 on line 106 resulting in no refund or payment due.
Is this possible if I want to use the Sales Tax module in Quickbooks?
Elizabeth 7