Why the sales tax report excludes AR adjustments
The Sales Tax Report doesn’t include AR adjustments, so bad-debt write-offs don’t reduce the tax it shows. If your state gives a sales tax credit for uncollectible accounts, get the write-off amounts from the general ledger and subtract them yourself when you file.
Why this happens
Section titled “Why this happens”The Sales Tax Report is built from your invoiced sales. An AR adjustment, such as a write-off of an old, uncollectible balance, posts to the financial category tied to its adjustment reason. It doesn’t reverse the original sale, so it doesn’t appear on the Sales Tax Report.
Some states, such as Ohio, treat a bad-debt write-off as a reversal of the sale and let you take back the sales tax you already paid. Nexsyis doesn’t calculate that credit for you. You report it on your return.
Claim a credit for bad-debt write-offs
Section titled “Claim a credit for bad-debt write-offs”- Write off the balance with an AR adjustment, using the reason you use for bad debt. See Make an AR adjustment.
- When it’s time to file, run the Sales Tax Report as usual: close the GL period, finalize sales tax, then run the report. See Run the sales tax report.
- Open GL Detail Inquiry for the financial categories your write-off reasons post to, for the same period. See Look up GL detail.
- Total the write-offs that qualify for a credit under your state’s rules, and work out the sales tax portion.
- Enter the credit on your state sales tax return. Keep the GL detail as backup.
For example, a shop writes off several old folders as uncollectible in March. The March Sales Tax Report doesn’t show them. The bookkeeper runs GL Detail Inquiry for the bad-debt financial category for March, totals the qualifying write-offs, and claims the sales tax credit on the state return.
Track bad-debt write-offs in one account
Section titled “Track bad-debt write-offs in one account”If your write-offs are spread across several adjustment reasons and financial categories, Nexsyis can set up a new adjustment reason that posts to its own financial category, just for bad debt. You then check only one account in GL Detail Inquiry. It works the same way as your current write-off reasons.
To request it, contact Nexsyis Support at nexsupport@nexsyis.com with:
- the name of the new adjustment reason
- the financial category number and description you want it to post to
See also Set up adjustment reasons.
When to contact support
Section titled “When to contact support”Contact Nexsyis Support if:
- you’d like a dedicated bad-debt adjustment reason and financial category set up
- your Sales Tax Report doesn’t match your sales for reasons other than adjustments
