Are you sure you are marking that the sales tax is included in the $20 price? That should cause GC to split it out when posting to the liability (for sales tax) and income accounts.
The tax has zero to do with net income. It should not impact it in any way. It should never post to income and therefore no need to subtract from it. It should post to a liability account and you discharge that liability with an asset. Income and Expense accounts (and therefore Net Income) don’t enter the picture as far as the $1.31 is concerned. That amount with regards to that invoice transaction should not appear as a debit or credit to any income or expense account, only to liability and asset accounts. Regards, Adrien > On May 21, 2017, at 7:11 PM, P M <filif...@hotmail.com> wrote: > > Thank you. I think I am doing what you have done. My problem is > understanding why the 1.31 adds to Net Income instead of takes away from it > when you create an income statement. It seems like sales tax would take away > from net income, no? Is that what yours does? > > > ________________________________ > From: doncram <donc...@gmail.com> > Sent: Sunday, May 21, 2017 4:07 PM > To: Maf. King > Cc: gnucash-user@gnucash.org; P M > Subject: Re: Understanding taxes and the income statement > > Got the tax table to work. Per > https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ar-setup1.html, the > way to set up a tax table is under Business select Sales Tax Table, select > New. Call this Consulting Sales Tax, set the default type as "Percent", set > the percentage to 7. Then go back and edit the invoice to show 20.00 for > Consulting revenue with Taxable set and with Tax included set to NO, and set > Tax table = Consulting Sales Tax. Then see "Print invoice" to see the > invoice looks good, which it does. > 7.1. Initial Setup - > GnuCash<https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ar-setup1.html> > www.gnucash.org > There are many different ways to set up a business account hierarchy. You can > start with the Business Accounts setup which is available from the New > Account ... > > > I still had to find the invoice and "Post" it. Then I had to find "Process > Payment" for the customer, and select the posted invoice, and enter $20.00 > being paid, then enter that. This did properly record $18.69 of Consulting > revenue, which I can see in Reports / Income & expense. And in balance sheet > I confirm it records $20 cash and also records $1.31 of Sales Tax on > Consulting revenues. > > So what Pete wants can be done. Hopefully this helps. :) > > On Sun, May 21, 2017 at 3:26 PM, doncram > <donc...@gmail.com<mailto:donc...@gmail.com>> wrote: > I try to do what Pete needs, but get stuck where I need to create a Tax table. > > In my test company, I created an Income account for Consulting revenues and a > Liability account for Sales Tax Payable. If I received the $20 in cash I > would want to enter a transaction that would implement the following journal > entry > > Cash $20 > Consulting revenues 18.69 > Sales tax payable 1.31 > > When I create a new invoice for a customer that i created, at first I didn't > see how to make any split transaction or otherwise include the sales tax. > However, I find that a kludgy way that works to add a line for 18.69 amount > for Consulting revenues, i.e. 1 unit at cost/unit of $18.69, and add another > line for a unit of Sales Tax Payable at 1.31. Printing an invoice, I see > that looks unprofessional, as the invoice form allows for taxes to be > included on a separate line below all components of work that the client is > being billed for, but it does present a bill for $20 in total. > > It seems like what is needed is to have just one line in the invoice, with > 18.69 amount and "Tax included" set to NO, or with 20.00 and with "Tax > included" set to YES. Then a linked "Tax table", where 7% rate is set > somehow, is supposed to do its magic. However I don't see how to create a > Tax table; it does not seem to be included in "Help". > > So can anyone advise more specifically how to set up the invoice that Pete > needs? > > Don > > On Sun, May 21, 2017 at 5:17 AM, Maf. King > <m...@chilwell.net<mailto:m...@chilwell.net>> wrote: > On Sunday, 21 May 2017 00:33:49 BST P M wrote: >> Very basic problem here. I made an invoice for a service that I did. I >> received $20. Where I live I have to charge 7% tax. So the revenue is >> actually $18.69 and the tax is 1.31. My invoice has a subtotal of $18.69 >> and a tax of 1.31. I post it and get it paid and for some reason my tax >> expense is a -1.31. In other words my net income is boosted by $1.31 as >> opposed to decreased to $1.31. Why is this? Is this because I haven't >> actually paid the sales tax yet and I close it out later? >> > > Hi, > > If your sales tax works anything like VAT does here in the UK, the tax you've > collected isn't an expense to you... you should record the tax portion as a > liability - it isn't your money, it belongs to the government, you are just > "looking after it" for them. > > HTH, > Maf. > > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
