cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Eve2019
Level 5

SALES TAX REPORT

Hi, which report can I run that will show me total payment made to Dept of tax Administration (cdtfa.ca.gov). I filed Sales and Use Tax on quarterly basis with montly payment. I have record the payment in quickbooks desktop but now I want to print a report that shows total amount I paid for all 4 quarters.  Also will this show up on my Balance sheet, if so where can I find it in my balance sheet report.

 

Thank you in advance. 

 

2 Comments 2
FishingForAnswers
Level 10

SALES TAX REPORT

@Eve2019  There are a few ones that will show payments made.

 

Probably the most all-encompassing option is under the Reports menu>Custom Reports submenu>Transaction detail. You can filter to any Vendor, Other Name, or whichever classification you assigned to the Dept. of Tax Administration when you set it up. It will provide a total of all debits and credits at the bottom of the report for the time period you selected, and can display pretty much any column you'd want to include, information wise.

 

It'll also show up within a Balance Sheet QuickReport. You can generate these by opening your Balance Sheet and double-clicking on the appropriate row total.

 

In your case, it should be something similar to Sales Tax Payable.

MirriamM
Moderator

SALES TAX REPORT

Hi there, Eve2019.

 

In QuickBooks Desktop (QBDT), there isn't a specific report that displays all the sales tax payments you've recorded. However, you can generate the Sales Tax Liability report and click on the amount under the Sales Tax Payable column. This action will open the Custom Transaction Detail report, allowing you to view the sales tax payments.

 

To open the report, here's how:

 

  1. Go to the Reports menu at the top.
  2. Choose Report Center.
  3. In the Standard tab, type in Sales Tax Liability on the search field.
  4. Click the Run button.
  5. Set the Date and Report Basis.
  6. Click on the amount under the Sales Tax Payable.

 

Please note that the Sales tax payable column includes the payments you’ve made, so it might not always match the total tax collected.

 

For the Balance Sheet report, you can navigate to the Sales Tax Payable account and click on the amount to expand the transactions.

 

If you come across issues while managing your sales tax, feel free to refer to these articles for guidance:

 

 

If you have any further questions or need assistance, please leave a comment below, Eve2019. I'm here to help.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us