Hello there, @JKCEnt.

Let me provide additional information about your cash sales liability report.

You'll have to create a Bad Debt (Service item) to reduce the unpaid portion of the sales.

Here's how:

1. Go to the Lists menu and select Item List
2. Select the Item button and click New.
3. Choose Service Type.
4. In the Item Name/Number enter Bad Debt.
5. Put the Expense account then click OK.

Once done, we can create a Credit Memo to put the unpaid portion to the Expense account to record a negative sales tax.

To create a credit memo, here's how:

1. Click Customers menu, then select Create Credit Memos/Refunds.
2. From the Customer: Job drop-down, select your customer.
3. Enter the items you're giving credit for.
4. Hit Save and Close.

For more details, click this article: Give your customer a credit or refund in QuickBooks Desktop for Window.

Also, I'd suggest contacting a tax expert to ensure the compliance of the sales tax records.

You can visit our website, it provides articles on how to manage your account in QuickBooks.

Please stay in touch if you have any other sales tax concerns, I'll be right here to help you. Take care.