Australian BAS Report

I was thinking about trying to create a generic tax report for FA that would create an Australian BAS, as well as an NZ GST or UK VAT report, and have the options of creating a journal to balance off the GST/VAT accounts and create a payment to the tax office. Please have a look at kwikpay.co.nz/download/bas.docx and let me know what you think.

Thanks

@Elax
I've made changes to FA for my own use to handle zero rate GST for NZ/Aus.

/reporting/rep107.php, line 158:  if ($tax_item['amount'] == 0 && $tax_item['rate'] != 0)
/sales/includes/db/sales/sales_invoice_db.inc, line 144 : if ($taxitem['Net'] != 0 || ($taxitem['rate'] == 0 && $taxitem['Value'] != 0)) {

I hope it is of use to you.

I believe so, but you'd have to apply the same logic to the purchases as well. I don't use the purchases application so I had not looked at applying it there.  What I was trying to do was to make any sale linked to a zero tax rate to show in the tax reports so I could see the total of sales for which zero rate applied.

@Joe

I think so. Normally, everything Item related should work because you can create a 0% VAT type and assign it to an item.
This 0% VAT type will appears in the tax report with the correct net amount.
itronic patch should allow also to 'tweak' the tax amount calculated on invoice.
The problem only occurs for payment or deposit. In my version you can enter the net amount corresponding to a 0% VAT transaction, so everything should work fine. This net amount will then show up in the tax report on the corresponding tax type.

/Elax

I fiddled around with GnuCash for a couple of years but eventually found it too deficient (no inventory, no credit note, etc.) AND it somehow ate my database (I know, I know, I should have backed up). Looked at TurboCash (too buggy according to former Australian support consultant), SQL Ledger and LedgerSMB (too difficult technically to install and setup for this liddle black duck), and AdminSoft (probably okay but has a scary, amateurish GUI).

Finally, Nirvana! FrontAccounting is professional, has a great GUI, and is way overcapable for my tiny hobby retail and service business. Would really love the ability to select a zero percent GST category that appears on invoices, reports, etc., and from that a BAS report.

In GnuCash I had these Liability accounts:

• GST Receipts (from sales)

• GST Paid (from purchases)

• GST Adjustments

• GST Liability

GST Receipts was posted automatically from invoices, and GST Paid from bills received. GST Adjustments was a journal transaction. GST Liability was posted by clearing the first three, and then itself cleared when payment was made to the Australian Taxation Office.

In FrontAccounting I have to use some dummy accounts to allow 0% tax "rates" to be selected from GST Exempt, GST No Tax (not reported), and GST Input Taxed. The BAS form requires you to report both GST taxed and untaxed sales and purchases, so I hope someone can come up with a lovely one-click way of generating the required report. And not doubt that fundamental processing is similar for Australian, Canadian, and New Zealand GST sales tax; and UK and European VAT.

In Sandpit Co. I may even experiment with modifications of AlastairR's tweaks, but that won't cut it for purchases. So can some angel with skills and experience way beyond mine please, please, please develop a GST/BAS module!

Regards,
Hedley

P.S. Having worked at MYOB as in the final 6 years of my career as a technical writer of user documentation, I know enough of coding and bookkeeping in general to be a danger to humanity, but nought about SQL, MySQL, and PHP in particular.