How Do You Create a Cash Basis Sales Tax Payables List?
1. Change the List View to be “Sales Tax Payable– Grouped by Code”
2. On the left, set “As of” custom date based on your criteria. Click the Calendar icon to input End Date. Click Search.
To show only invoices that were paid, create a filter on “Customer Paid” column to be equal to “Full” and Apply Filter.
3. To show only invoices that were paid, create a filter on "Customer Paid" column to be equal to "Full" and Apply Filter.
4. Set another filter on the Balance column to “is NOT equal to 0.00” and Apply Filter
The report that is created should be printed and saved in a binder for Sales Tax audit purposes.