I've inherited a company from an accountant that didn't teach the client how to post sales tax payments. Their sales tax is screwed up going back years. The current year sales tax liability is $3045 which was paid by creating a bill (not from the pay sales tax menu) and then writing the check so the sales tax payable hasn't been reduced by the payment.
Note, I can run correct reports if I run the sales tax liaiblity for 2019 but the sales tax payable column has a positve 27000+ figure and two different vendors with negative $21000 figures.. Very confusing for client and would like to clear this cumulative sales tax payable balance off the books. There are multiple journal entries that produced the negative balances going back years.