Hello @Coast2 , I am an accounting professional who is a Certified QBO ProAdvisor and is based in CA with clients in CA and other states. I came across your problem in the QBO community when I was searching to see if anyone else was having issues with the built-in sales tax system miscalculating the total tax for items for the 6% state rate for Florida where my client is located (similar to CA, Florida has county surtax rates that QBO also tracks and calculates which show as sub-lines on the Sales Tax Liability report proper filing of the return and payment on Florida's DOR website). Your issue came up because a commenter mentioned Florida.

What I am writing to you about has nothing to do with your missing column problem ... I happened to notice on your screenshot of your sales tax liability report you provided to the QBO employee, that it is a Cash Basis report. CDTFA regulation is that sales tax liability in CA is required to be remitted on a accrual basis, regardless if your business is cash-based for income tax purposes. (https://www.cdtfa.ca.gov/lawguides/vol2/suta/130-0005.html)

Based on direct experience with my clients in CA, I strongly recommend you start filing your tax returns using an accrual basis sales tax liability report from QBO, because CA routinely audits businesses who have Sales & Use Tax accounts, and the aftermath of an audit on your account is a time-sucking headache for the business owners (I have a CA client who made online purchases for her business but some retailers were not charging tax on the sales--CDTFA caught this and assessed a ridiculous amount owed with penalties and fees based a blind estimate of total purchases she made in a calendar year (multi years) - she had to produce all the receipts for her online purchases to prove she was charged sales taxes on most of her online purchases).

Hope this helps! Just wanted to offer some sage advice from one business own to another! Have a nice day!