Sales tax exception report

Go to the Sales Tax menu > View Prior Sales Tax Returns.

Whichever you select will pull up all reports relating to that sales tax filing.

Hi,

I filed 2017 GST return in January (my client was way behind when I took over his books).

QBO automatically post JE to GST Suspense (debit) -$11,400. 

In February we received an assessment that CRA did not allow his ITC and let him pay $4,800 plus penalties.

I recorded his payment under bill - CRA as payee and under account Non-Refundable taxes thereafter penalties. But the GST suspense of -$11,400 is still sitting in this account. I am going to do an adjustment JE of credit GST suspense and debit  Non Refundable taxes?

I just need confirmation if I'm doing this right.

Thanks,

Marg

That's not true, none of the transactions from the exception report show up on the detailed listing for the current period and in order to include the transactions from the exception report you need to make an adjustment.

Why doesn't the sales tax report work in the same manner as the desktop version, where if you've made an entry in a previous period after you've filed a GST return for that period it shows up as a carry forward balance on the detail report? The online version is very frustrating. I have so many unused ITCs because of the stupid "exception report."

Just had the MOST frustrating experience with QB ONline support.  The representatives have no clue how to guide one through making adjustments to the GST/HST Return in QBO.  The issue is that journal entries that were edited since the last return are being flagged as exceptions and adding to the HST collected, which is not accurate.  It was paid in the last filing!  QBO really needs to figure this one out!

Hi there. Your time is valuable and I want to make sure you get the support you need. It's important you reach out to our support so they can take a closer look at your account. That way you can share your account info in a private/secure environment. I encourage you to learn more about Exceptions by reviewing this helpful article: Sales tax exceptions.  In case you have further questions, don't hesitate to reach out to our support team using this link. 

I'm having this same issue with a client.  The client files their own HST in QBO, so I don't know how the HST on the exception report gets cleared.  Are you able to confirm if the HST on the exception reports automatically gets included in the next filing period?

Hi there. That's correct.

When preparing Sales Tax returns, you may see a column titled Exception Amount. The amounts in this column represent transactions you have previously filed for, but have since been changed, deleted or added. This is to ensure that no sales tax collected (or credits earned) is missed or duplicated.

If you delete and recreate a transaction for a previous period, then both changes will show as exceptions, but will net out to zero. This is also caused by editing and saving a transaction, even if the line item in question was not changed. This is perfectly normal and should not affect the balance of your filing.

For more information, check out this article: Sales tax exceptions. For further details, please reach out to our tech support team.

Cheers. 

I just undid an HST Filing - because I wanted to print it and didn't see a way to print after Filing.  It has totally wiped out the exceptions, so now when trying to file, it doesn't include them and shows me owing more than is applicable!

Even though it is an online program, we should still be able to print or PDF the actual filing in a manner that looks decent...not a screenshot.

Frustrated as usual when dealing with QBO.

Regarding message "Go to the Sales Tax menu > View Prior Sales Tax Returns.

Whichever you select will pull up all reports relating to that sales tax filing."

In all their wisdom, they must have deleted this from the options.  Now, there is no way to print the Summary report.

Hello Janetta,

Thanks for joining in on this thread and taking the time to share your thoughts. I'd like to take a moment to clarify the information in this thread and get you back on track with your sales tax filing in QuickBooks Online.

After you've filed sales tax in QuickBooks Online, you'll see the filing in the Filed section on the Sales Tax page. Each filing has the option to record a payment or refund or to view the summary for that filing. Each of these options is also available in the drop-down arrow. Clicking View summary will bring up the summary report with the Line description, related amounts, and balance. If this is what you were looking at, I see what you mean about there not being a clear way to export or print this page, but here's another way you can find it.

The summary generated through that option is quite simply the sales tax summary report you can find through the Reports tab. Simply scroll to the Sales Tax section of the Reports page and run the summary or detail report for the sales tax code or codes you'd like. You can use the date fields to filter for a filing period to narrow down the information you're seeing on the report. It's also possible to export or print the report as needed right from the same page. Look for the print and export icons on the report itself. Check out this article for step-by-step instructions: Run reports in QuickBooks Online

The option for View Prior Sales Tax Returns mentioned earlier in this thread relates to QuickBooks Desktop. This option generates the Tax Agency Detail report, which you can save to your computer. Using the Reports tab in QuickBooks Online and running the specific ones you need achieves the same thing.

As for sales tax exceptions, those are removed when you undo a sales tax filing. Before undoing a sales tax filing, it's always recommended to make note of these exceptions manually so you can make adjustments as necessary when refiling. Since you said you undid the sales tax filing, it sounds like you may be an accountant user as that user type has access to undo a filing. If you're not an accountant, however, I recommend touching base with one if you're unsure how to move forward. You can use the My Accountant tab in QuickBooks Online to invite an accountant you're already working with as a user to your account or use the Find a pro to help button there to find a QuickBooks-certified accountant near you.

I hope that helps clear this up. I'll be around if you have further questions. :)

Good afternoon,

Thanks for your detailed answer.  Another question - same area.  

Line 101 has a value under the exceptions column which increases the total Sales.  However, it is not appearing on the Sales Exception Report, nor the Sales Tax Summary Report. 

The ITC exceptions appear, but not the sales.  Since I deal with Sales that are HST applicable and exempt, I need to ensure it doesn't change the HST owing amount. 

Which report will provide what this number represents or where it comes from?  TIA

Hello again Janetta.

I'm glad to hear that my previous response helped you with your sales tax in QuickBooks Online. It's good to see you've still been working with the program since your initial question a few months ago, and I'm happy to continue working with you on this.

When you have exceptions showing as you're moving forward with filing sales tax, the Exception report through the Reports tab should show you the information you're looking for. Since you're not seeing it, it could simply be that your date range isn't encompassing the exception amount. Use the date fields at the top of the report to adjust for the reporting period you're filing for and then click Run report to bring up the information.

Another good way to make sure you have exactly the report you need is by following these steps in the Taxes tab.

1. Click the down arrow beside Prepare return.
2. Select View exception details.

This will populate a report that breaks down the transactions falling under the exception amounts in your filing, grouped by what line they appear under. You may not see line 101 specifically, but with using the details from the other lines highlighted on the report, you should be able to work out what's factoring into line 101, which is the total amount of revenue. This article from the CRA website gives a helpful line-by-line breakdown: Instructions for completing a GST/HST Return

Give that a shot and let me know if you still have questions about where the amount is coming from and what the sales tax filing is calculating. A screenshot may be helpful so I can see exactly what you're seeing.

Another way to work with an agent to have them see what you're seeing is to get in touch via one of the following methods.

Schedule a Callback or Chat: click (?)Help in the upper right > type and enter "Contact support" into the QB Assistant > click Contact Us > explain your situation > click Let's Talk > choose Get a callback or Start a Chat. Support is available from Monday to Friday between 9 a.m. and 8 p.m. ET.

Social Media: Facebook, Twitter, and Instagram.

Feel free to choose whichever you prefer. Whether you work with us here or via one of the other methods, our goal is to get you back to business as quickly as possible.

I figured out the issue.  Intuit in their infinite wisdom decided that Sales (Line 101) is not important; therefore, it is not included in the detail report or the exception report, nor can it be drilled down to see the details.  This means that if a company has Exempt Sales (like my client does) and an invoice is changed or added to the prior period it will not appear anywhere.  The bookkeeper is supposed to manually sort through everything to figure out which one(s) were changed.  Not sure why they decided to do this, given that QBD shows all this information and it is obviously important; but there you have it.  Am I sounding bitter, yes, sorry I am. Just lost over 2 hours on the phone with Intuit today over things that should not have been issues.  

Hi Janetta Howson,

Being able to see all the information you need in your reports to help save time is something we focus on. I'd be happy to help with this.

QuickBooks Online makes finding sales tax info in your reports easy to help you save time. In the GST/HST Detail Report you will see only lines 103 and 106 as this report shows you the total transactions for all sales and purchases you have made. If you wish to see line 101 I suggest using the GST/HST Summary Report as this report will show you each line total and give you the option to zoom in to see what is included for that line. 

If you wish to have the ability to see or customize to include line 101 or other lines in the GST/HST Detail Report, you can send feedback to our technicians by following this steps.

1. Select the Gear icon at the top, then Feedback.
2. Enter your comments or product suggestions then select Next.
3. You'll be provided a list of suggested Help articles related to your comment. You can read through them or select Skip and send message.
4. From the drop-down, choose the appropriate category, then select Send message.

Have a great one!

QBO is very frustrating.  I am switching to desktop this week.

Hi there LKSC,

Working with the best program for your business plays a big role in accurately and easily keeping track of your books. If QuickBooks Desktop is the better fit for you, I encourage you to take that step toward getting set up. I want to make sure you have the information for going through that process, so I'll leave you that in my response here.

There are a few ways to get QuickBooks Desktop: a subscription through Intuit, an outright purchase through Intuit, or an outright purchase through a third-party retailer. Feel free to choose whichever of those options you feel fits your needs best. For monthly subscriptions from Intuit, you can check out the links below.

• QuickBooks Desktop Pro and Premier
• QuickBooks Desktop Enterprise

For annual subscription options or a one-time purchase from Intuit of Pro or Premier, please feel free to touch base with our sales team. The number and hours for that team are available in the Pro and Premier link above. Enterprise works on a subscription basis only, and you can connect with the Enterprise sales team using the number on that link to learn more about the subscription options.

When it comes to moving any data you have in QuickBooks Online to QuickBooks Desktop, I encourage you to take a look at this link: Move lists and balances from QuickBooks Online to QuickBooks Desktop. There isn't currently a built-in way to transfer the data, but this article can help you get started.

The other option is to explore third party services that can move the data for you. I don't have any I'd recommend, but you may get some suggestions from other users in the QuickBooks Community. If not, with a bit of research, you may find something.

If there's anything I can do to help you with your QuickBooks Online, let me know in a reply. I'd like to do what I can to sort out any issues you're having.

Take care.

This answers nothing:

I NEED to know (for QBO) if the transactions on the GST Exception report have already been included in the totals on the GST Return automatically by the QB program (lines 103 and 106) or whether I need to adjust those lines manually to account for the transactions on the Exception Report. Please, someone at Quickbooks?? And do keep pasting the link to the useless Sales Tax Exception report help - it did NOT answer my question.

Ha, ha, ha - and yet here I am in 2022 still having the same issues as everyone above, so clearly the 'Feedback' forms are not read or are read, but completely disregarded.

I have just had this same issue! Were you able to fix it? I trust the cumulative values shown in the trial balance, but not the HST summary, because it is now missing the exceptions and would result in me overpaying.

I need to adjust the filing report without actually posting a journal entry.