Difference between revisions of "Alternate Australian GST setup"

From GnuCash
Jump to: navigation, search
(Add more explicit account names)
(Document Income & GST Statement report - added)
Line 19: Line 19:
  
 
This is where all of the GST money you pay the government is recorded.  In the 3-account system this account is called '''Liabilities:GST:Payments'''.
 
This is where all of the GST money you pay the government is recorded.  In the 3-account system this account is called '''Liabilities:GST:Payments'''.
 
 
----
 
----
  
Another variation of the 3-account setup is to have the BAS payments (or refunds) as seperate sub-accounts, rather then entering the transactions directly in the Collected and Paid accounts.
+
Another variation of the 3-account setup is to have the BAS payments (or refunds) as separate sub-accounts, rather then entering the transactions directly in the Collected and Paid accounts.
  
 
*'''Liabilities'''
 
*'''Liabilities'''
Line 44: Line 43:
 
****'''BAS Refunds''' (net gst refunds from ATO)
 
****'''BAS Refunds''' (net gst refunds from ATO)
  
----
+
== Gnucash 2.7 or later ==
 +
 
 +
The following 3-account structure can be used, and will greatly ease the periodic reporting:
 +
 
 +
* '''GST''' (placeholder account) (type ASSET/LIABILITY)
 +
** '''GST:Collected''' (from Sales) (type LIABILITY)
 +
** '''GST:Paid''' (from Expenses) (type ASSET)
 +
** '''GST:BAS''' (from periodic BAS) (type ASSET/LIABILITY)
 +
 
 +
As above, GST collected on Sales and paid on Purchases will be recorded with a split to the above.
 +
 
 +
Periodically (usually quarterly) the ATO will require reporting of all GSTs collected and paid from business expenses. This can be obtained by running the report '''Income & GST Statement''', which is useful to add GSTs paid and collected, for ATO reporting. This report will obtain source transactions from your business expenses & sales, and will obtain GST splits from the Collected & Paid accounts selected in the Accounts tab.
 +
 
 +
The GST wholly received/paid to the government can be recorded into '''GST:BAS'''.
 +
 
 +
{| class="wikitable" style="text-align:center;"
 +
|+"Income & GST Statement" sample report
 +
! Date || Description || Total Sales || Net Sales || GST Sales || Total Purch || Net Purch || GST Purch
 +
|-
 +
| 03/08/17 || Agency || $4000 || $4000 || || $1760 || $1600 || $160
 +
|-
 +
| 03/09/17 || Agency || $5050 || $5000 || $50 || $2200 || $2000 || $200
 +
|-
 +
| 06/09/17 || Marketing || || || || $220 || $200 || $20
 +
|-
 +
| Totals || || $9050 || $9000 || $50 || $4180 || $3800 || $380
 +
|-
 +
|}
 +
 
 +
GST receivable for this period = $380 - $50 = $330 (to be claimed back from ATO)
 +
 
 +
Remittance into my bank = $9050 - $4180 = $4870 (what I initially receive into bank)
 +
 
 +
Income after expenses, relevant to annual income tax = $9000 - $3800 = $5200

Revision as of 09:36, 24 October 2017

The following GST scheme is used by MYOB BussinessBasics.

Since GST is money you owe the government (or visa versa) you create an account called:

  • Liabilities:GST

Then, to make your balance sheet more informative, you create two sub accounts:

  • Liabilities:GST:Collected
  • Liabilities:GST:Paid

Whenever you receive income you record the GST component in Liabilities:GST:Collected and whenever you make a purchase you record the GST component in Liabilities:GST:Paid.

At the end of each accounting period if you owe the government money then you record the amount you paid it in Liabilities:GST:Paid. Or if the government owes you money then the amount you receive should be recorded in Liabilities:GST:Collected.

This simple scheme can easily be modified to be the same as the 3-account system. In this scheme Liabilities:GST:Paid is exactly the same as in the 3-account system, but Liabilities:GST:Collected is given the rather confusing name of Liabilities:GST:Payable. To move to the 3-account system all you need to do is create a new account called:

  • Liabilities:GST:BAS

This is where all of the GST money you pay the government is recorded. In the 3-account system this account is called Liabilities:GST:Payments.


Another variation of the 3-account setup is to have the BAS payments (or refunds) as separate sub-accounts, rather then entering the transactions directly in the Collected and Paid accounts.

  • Liabilities
    • GST
      • Sales
        • Collected (gst received from sales)
        • BAS (net gst payments to ATO)
      • Purchases
        • Paid (gst paid on purchases)
        • BAS (net gst refunds from ATO)

You are free to change the names to be more explicit if it makes things easier for you :)

  • Liabilities
    • GST
      • Sales
        • GST Received (gst received from sales)
        • BAS Payments (net gst payments to ATO)
      • Purchases
        • GST Paid (gst paid on purchases)
        • BAS Refunds (net gst refunds from ATO)

Gnucash 2.7 or later

The following 3-account structure can be used, and will greatly ease the periodic reporting:

  • GST (placeholder account) (type ASSET/LIABILITY)
    • GST:Collected (from Sales) (type LIABILITY)
    • GST:Paid (from Expenses) (type ASSET)
    • GST:BAS (from periodic BAS) (type ASSET/LIABILITY)

As above, GST collected on Sales and paid on Purchases will be recorded with a split to the above.

Periodically (usually quarterly) the ATO will require reporting of all GSTs collected and paid from business expenses. This can be obtained by running the report Income & GST Statement, which is useful to add GSTs paid and collected, for ATO reporting. This report will obtain source transactions from your business expenses & sales, and will obtain GST splits from the Collected & Paid accounts selected in the Accounts tab.

The GST wholly received/paid to the government can be recorded into GST:BAS.

"Income & GST Statement" sample report
Date Description Total Sales Net Sales GST Sales Total Purch Net Purch GST Purch
03/08/17 Agency $4000 $4000 $1760 $1600 $160
03/09/17 Agency $5050 $5000 $50 $2200 $2000 $200
06/09/17 Marketing $220 $200 $20
Totals $9050 $9000 $50 $4180 $3800 $380

GST receivable for this period = $380 - $50 = $330 (to be claimed back from ATO)

Remittance into my bank = $9050 - $4180 = $4870 (what I initially receive into bank)

Income after expenses, relevant to annual income tax = $9000 - $3800 = $5200