Can someone please help me with some reporting? Unlike the the GST Calculation Worksheet for BAS Report, the Tax Transactions report issues the transaction by issue date. Is it possible to create tax transactions report by payment date instead of by issue date. This is because the Tax is actually collected when the invoice is paid not when it is issued.
In fact the total sales (including any GST) on the BAS report show correctly whereas the total sales on the Transactions show all issued invoices within the specified period even if they still haven’t been paid.
Your help is very much appreciated.