I have been entering all my financial records into GNUCash, and now I need to find the most efficient way to extract all the needed figures for the BAS. The Income & GST Statement looks like the way to go however it appears only to calculate total sales and GST, and I am uncertain if it can be customised.
Currently, I have created tax tables for Export and GST-Free sales in addition to one for ordinary GST, although this might not be the correct approach. My thought was that I should be able to generate a report that breaks down sales by tax type, or at a pinch generate a report for each tax type, which would allow me to see each subtotal. Doing this has caused the report to calculate purchase tax of $0.00 on many of the sales, so clearly I am doing something wrong.
With respect to purchases, as I have both assets and expenses I would imagine that this needs to be calculated from Accounts Payable rather than individual expense and asset accounts, particularly as some of those are not purchases. At this stage, I have only non-capital purchases however for future purchases I would also like to somehow tag each purchase as capital or non-capital.
On the whole, GNUCash seems to be a very good system, so I am hoping enough people are using it to have solved this problem already. I don't want to learn Scheme or run an XSLT stylesheet over my database just to keep the ATO happy. :)