Our Sales tax detail report does not recognize past payments but the balance sheet shows all correctly. How do you get the detailed sales tax report to reconcile?

Good day, @greenplants. 

I'm here to share info about the possible reasons why the Sales Tax Detail report doesn't recognize past payments in QuickBooks. 

There's a limitation once you migrate from QuickBooks Desktop to Online. Sales tax payments made in QuickBooks Desktop don't apply to the correct filings in QuickBooks Online. This is the reason why your past payments aren't showing on the Sales Tax Detail report.

As a workaround, you can delete the migrated sales tax payments and then recreate them in the sales tax center in QuickBooks Online.

Here's how to delete a sales tax payment

1. Go to the Taxes menu and select Sales tax.
2. From the Recent Sales Tax Payments list, select the payment you want to delete, then click Delete Payment.
3. Select Yes to confirm.

Once done, follow these steps to record the sales tax payment.

1. Go back to the Taxes menu, then Sales tax.
2. From the Sales Tax Owed list, choose the tax agency you're recording the payment for and click Record Tax Payment.
3. From the Bank Account drop-down list, select the account you're making the payment from.
4. Enter the Payment Date and the tax payment amount in the Tax Payment field.
5. Click Record Tax Payment. 

For additional reference, please check this article: How to record, adjust, and delete sales tax payments in the tax center.

Moreover, you can review this resource to learn how features and data move from QuickBooks Desktop to QuickBooks Online: What does and doesn’t move to QuickBooks Online?

If you have additional questions about reviewing your past payments in the Sales tax detail report, simply post them to the thread. We'll be here to help. Have a nice day!