Understanding the 'transfer' list of options...

[Maf. King]

On Tue 28 August 12 14:13:55 Expert_wannabe wrote:
> Thank you Colin & Liz for your replies.
> 
> Time was pressing on and so I've just spent the last 10 - 12 hours
> transferring all my into to good ol' Excel.
> The problem was that I needed to get this info to the HMRC and it didn't
> look like I could get what I needed from GnuCash.
> Basically, I needed this info......

Hi,

GC can give you this info, if you take some time to get the account structure 
and saved report options set up.  Unfortunately, when the HMRC deadlines are 
close, I understand that there isn't that time to be spent.  Need answers and 
need them now!

<SNIP>


> It took me less than one day to start from scratch with Excel to get the
> results I needed, whereas, I tried for days and days (very long days - 14
> hour days) with GnuCash and I was just getting nowhere fast. I'm surprised
> I'm not bald yet!
> 
> I won't totally give up on it yet, but I don't have much faith in it.

Take some time to go through the wikia tutorial link I sent yesterday.  it 
should help you get the appropriate account structure in place (before your 
next VAT return is due (in late November?)). Run GC in parallel with the 
spreadsheet and see how you go.

> 
> Liz:
>       I see what you are saying with (value/5*4) etc, but I don't believe I
> should have to do that for every entry.
> I certainly don't have to do that in my spreadsheet. It works it all out for
> me. The only problem with my spreadsheet is that although it 'works' it
> doesn't look pretty

Glad that you have a working solution - pretty is optional, accurate is not!  
Does your spreadsheet handle different VAT rates?  will it help when it comes 
to corporation tax return, or will you be tweaking and jiggling some more? 
(Just some things to think of, not intended as criticism.)

Maf.