How do I reconcile the Sales Tax Payable account on a cash basis?
I have an older version of QuickBooks that *does* allow me to reconcile the Sales Tax Payable account (so please don’t ask why I want to do this). It is neat, but the one issue that I have with it is that it lists items on an accrual basis rather on a cash basis. I pay sales tax on a cash basis. So, if I open a liability report for Sales Tax Payable and compare that to what displays as unreconciled in the reconciliation window for the Sales Tax Payable account, the listings are off as the report lists the only the invoices that have been paid, by the date that they were paid, whereas the reconciliation window lists the invoices, regardless of whether or not they have been paid, by the date assigned to them when created. This is not too much of an issue, but it would be nice if it I could get the reconciliation window to work on a cash basis. Is there any way to correct this? Perhaps I should just forget that the reconciliation option for the Sales Tax Payable account exists.
