Skip to main content
September 12, 2024
Question

SALES TAX REPORT

  • September 12, 2024
  • 2 replies
  • 0 views

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 replies

FishingForAnswers
September 12, 2024

@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.

September 12, 2024

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.