Sales Tax Report Question

Sbhat

When we bill sales tax occasionally the customer will remit payment less the tax and then we need to credit that off. When we credit tax by itself, we put it to the correct G/L number, but it will not get picked up in the Sales Tax Collected report. (General Ledger>Reports>Tax Reporting). This report is used to determine taxable sales/tax that we need to remit to the state. The fact that it doesn't get picked up makes it difficult when we try to tie out to the ledger the tax posted to that account vs the detail from the report.

What I was wondering is if it were possible to write these amounts via a journal, where we might be able to indicate Taxable sales that would then get picked up in the report, but not hit the revenue account?

Example: I bill $110 ....$10 of which is tax.

Customer pays $100 - I need to write off the $10. Normally a credit memo would be issued against G/L 21605.

What I would like to be able to do via the journal: Enter the tax area code, the G/L account - the amount that needs to be credited (10.00) and indicate the taxable gross $100 as well as the invoice number it applies to. The taxable gross would not have a G/L posting as it shouldn't go against a g/l account.

This way when I run the Sales Tax Collected report - I will see this info as well.

Any help is highly appreciated.

Thank
S.