• Tutorials
    • Forms, Navigation
    • Forms, Popup and Context Menus
    • Forms, Color of Fields
    • Forms, Changing the Font
    • Forms, Customizing
    • Forms, Printing Reports
    • Forms, Send Email
    • Forms, Help
    • Grids, Navigation
    • Grids, Scrollbars
    • Grids, Functions
    • Grids, Functions, Refresh
    • Grids, Functions, New Wizard
    • Grids, Incremental Search
    • Grids, Selecting Multiple Records
    • Grids, Find and Find Next
    • Grids, Filters
      • Filters, Creating a New
      • Filters, Getting Fancy
      • Filters, Saving and Reusing
      • Filters, Default Filters
    • Grids, Printing Reports
    • Grids, Customizing
    • Menus, Shortcut Keys
    • Forms, Form Letters
      • How to print a Form Letter, Richtext
      • How to print a Form Letter, PDF
      • How to create your own Form Letter
  • Webinars
  • Training
    • Windows XL Training
    • Mobile Delivery
  • What’s New
  • Follow us on Twitter

TeamDME! XL Help

  • System
    • Company
    • Postal Codes
    • Task
    • User Security
    • Dashboard
    • Report Designer
  • Inventory
    • Item
    • Item Category
    • Item Department
    • Item Manufacturer
    • Item Location
    • Tracked Item
    • Activity
      • Physical Count
      • Item Adjustment Edit
      • Service Transaction Edit
      • Item Transfer Edit
    • Reports
  • Orders
    • Diagnosis Code
    • HCPCS Procedure Code, Edit
    • HCPCS Procedure Modifier
    • HCPCS Coverage Criteria List
    • HCPCS Fee Schedule
    • Physician
    • Payor
    • Therapist
    • Facility
    • Quote
    • Medical Order
    • Point-of-Sale
    • Recurring
    • Claim Pending
    • Claim History
    • Reports
  • Receivable
    • Customer
    • Salesperson
    • Referral
    • Nonallowed Reason
    • Responsible Reason
    • Adjustment Reason
    • Payment Type
    • Payment
    • Reports
      • Aged Receivable Reports
      • Revenue Reports
      • Audit Reports
      • Finance Fee
      • Customer Statement
      • Collection Letter
  • Purchase Orders
    • Purchase Order
    • Purchase History
  • Payables
    • Vendor
    • Unposted Invoice
    • Unpaid Invoice
    • Reports
      • Aged Payable
      • Open Payable
      • Cash Requirements
      • IRS 1099 Forms
  • Ledger
    • Chart of Account
    • Journal Unposted
    • Journal History
    • Bank Register
    • Reports
      • Balance Sheet
      • Income Statement
      • Trial Balance
  • Windows
You are here: Home / Receivable / Reports / Revenue Reports / How to Fill out your State Sales Tax form using Revenue by Salestax report.
«« Revenue, by ReportsAudit Reports »»

How to Fill out your State Sales Tax form using Revenue by Salestax report.

How to Fill out your State Sales Tax form using Revenue by Salestax report.

Each State Sales Tax reporting form is unique for each of the 50 states and territories. But each asks for basically the same information.

First you have to understand what is happening when we submit a Sales Tax report to most tax authorities. We submit what our sales were for the period and from that net amount we are assessed a sales tax amount. Since most sales tax authorities expect us to pay the tax regardless of whether we have collected the sales tax, you will normally write a check to the state for this assessment.

In the DME industry, unlike any other industry, we have the contractual allowable amount to contend with. Which simply means that we submit a bill for $100 and we get an EOMB for $72 (80% of the allowable amount) $90. At that time we will “write off” $10, the difference between the $100 we submitted and the $90 that was allowed. Of course the allowable amount is assumed to include whatever sales tax is due, so some part of that non-allowed amount $10 is sales tax, so we need to recoup this money.

To report our net sales for a period, we need to do the following:

Step 1

Run a Revenue report by Sales Tax area. This will give you the gross submitted charges, non-allowed amounts, sales tax collected and adjustments for the month.

Step 2

The amount of net sales for the month will be the gross sales / (1+ sales tax percentage)

Step 3

The amount of “returned” product or bad debt will be the non-allowed amount plus adjustments times this same percentage. (NA + Adjustment) / (1 + sales tax percentage)

Example: Your state sales tax rate is 8.25%, submitted charges for the month is $75,000, your non-allowed amount charged off is $10,000 and your adjustments are $2,000.

Net sales: $69,284.06 or $75,000 / (1 + 0.0825)

Bad Debt: $11,085.45 or $12,000 / (1 + 0.0825)

This calculation simply removes the sales tax component from the gross sales (submitted charges) and returns/bad debt to allow you to report them correctly to your state. If you are reporting the submitted charges, then you are paying sales tax on the sales tax amount and that’s bad.

Note: If your Tax Authority allows you to pay sales tax based on the amount you collect, use the payments amount instead of the submitted and other amounts.

Page Tags: How, Report, Revenue, Salestax
«« Revenue, by ReportsAudit Reports »»

Tell us what you think. Cancel reply

You must be logged in to post a comment.

RETURN TO TOP

Copyright 2014-2026 · TeamDME!, Inc. · All Rights Reserved · Log in