Oh dear, it turns out we don't get VAT back...

edpsystems systems at englishdentalpractice.com
Wed Jun 15 12:07:52 EDT 2011


Firstly, my sincere thanks to all of you for taking the time to reply. Colin,
you were quite correct, I want to shift the VAT out of the Expenses:VAT
account and spread it back through the corresponding expense accounts.
Keith, I set VAT up as an Expense account when I started using GnuCash (with
the intention of moving it to Liabilities once I understood better) so the
global figures are accurate, but the individual expense accounts are
misleading.

Secondly, I went through the tax tables, changed each of the Tax Table
entries for the 4, 8 and 18% Tables to zero (I'm in Spain btw). Then opened
a bill, unposted it, said OK to resetting the Tax Tables, and once I'd
reposted the bill the corresponding amount for that transaction in its
expense account now appears as a gross figure, rather than net. 

So Maf, your first guess may have been the right one! Let me just try a few
more...

...and it works as long as the gross amount was entered on the bill and the
Tax Included? column was checked in order to calculate the net figures.
Unfortunately, most of the amounts entered were net, and the Tax Tables
calculated the gross amount. 

So onto point 2, I didn't think deleting Bills was possible/advisable. If I
were to do that I think a running jump might be calling me..! Point 3? I
could try living with it, but most of our paper bills show the net amounts
with the 4, 8 or 18% tax getting added on as a lump after the subtotal
(which is why I entered them all as net + VAT). 

#4 raises a point I was wondering about a while back: The expense account
only shows the Supplier name, not a breakdown of each item on the bills. Say
I buy a tonne of biscuits and a tonne of bleach from Barry's Biscuit and
Bleach Emporium, and I want to split the bill between Expenses:Groceries and
Expenses:Cleaning Materials, post the bill etc, and look in each Expense
account, I'm shown total spent at Barry's, but nothing more specific.
Anyway, that's not the issue.

and #5, I guess we could register for VAT. I'll pop that one in the
suggestion box...

So I'm left wondering if there's a way of entering net costs into the bills,
and GnuCash calculating the gross totals without sending anything off to a
VAT account. Hmmm...

Best regards,
Stu



--
View this message in context: http://gnucash.1415818.n4.nabble.com/Oh-dear-it-turns-out-we-don-t-get-VAT-back-tp3596513p3599814.html
Sent from the GnuCash - User mailing list archive at Nabble.com.


More information about the gnucash-user mailing list