Sales Tax setup

[JohnS]

Emre,

In Australia we have a Sales Tax (GST) of 10% on all packaged/processed products (basically 10% on everything).

We need to show the GST on receipts, and report on it. All of our prices are including GST. Receipts print OK

Scenario 1.
Create a GST Tax Template, set as Sale Transaction @ 10.00 and map to all transactions.
Tick Tax Included on Ticket Type.

Sell a $1.00 item - POS shows correct Tax, etc

Accounts on the other hand shows
Sales (0.09) - wrong
Receivables (0.91) - correct
Cash 1.00 - correct

Scenario 2.
Create GST Account Type
Create GST Account and set to GST Account Type
Create GST Transaction, from Receivable Account to GST Account and Receivables to GST
Create a GST Tax Template, set as GST Transaction @ 10.00 and map to all transactions.
Tick Tax Included on Ticket Type.

Accounts now reports
Sales (0.91) - correct but Ex Tax
Receivables (0.18) - wrong
Cash 1.00 - correct
GST 0.09 - correct

Now my understanding, and maybe at 2am I'm not thinking straight but, Accounts should show
Sales (1.00) - Because prices include tax
Receivables (0.91) - This is what we get, Sales less GST or Ex Tax price
Cash 1.00 - Money we received
GST 0.09 - What we owe the Tax Office

FYI - In each scenario the WPR shows sales as Ex Tax
Sales 0.91
Tax 0.09
Total 1.00


Am I even close to getting this right ??
Oh, and when you change the Tax Templates, you need to restart SambaPOS to take affect.

[emre]

Your configuration for Scenario 2 is correct but GST transaction should work from tax account to receivables. In the other words it should decrease tax (we owe) and increase receivables (we should receive) accounts.

In this case:

1. Sales account displays sales excluding tax.
2. Tax account displays tax we owe to TO.
3. Receivables account displays total amount we'll receive from tables and it includes tax.
4. Cash account displays amount we've received from tables including tax.

In your case Tax account type can be "Sales Accounts" and you can create additional "Account Screens" that displays sum of "Sales Accounts" by removing "Display Details" setting for listed account types. We may also improve that screen by adding displaying accounts and totals as a tree feature.

[JohnS]

That fixed it. Must have been the lack of sleep kicking in