[GNC] exporting from gnucash to Excel

[Paul W]

 Thanks Maf. That seems like a neat solution. I'm almost there.
Because I'm on the Flat Rate Scheme my Box 6 figure needs to be the total of sales including VAT but apart from my Accounts Receivable which goes to zero once the invoice is paid I don't see how to get that figure from anywhere. I mean my Income:Sales figure does not include the tax - that goes separately to my ouput VAT liability account (which I use to populate Box1). 

By the way I'm using 100pc VAT Free Bridge to read a spreadsheet and send the figures to HMRC.It is free and has worked well.

    On Friday, 13 January 2023 at 23:36:21 GMT+3, Maf. King <maf at chilwell.net> wrote:  
 
 On Thursday, 12 January 2023 14:05:04 GMT Paul W via gnucash-user wrote:
> To submit VAT data to HMRC here in the UK I am obliged to use a method which
> is automatic. So I need to find a way to trasnfer the balances from a
> couple of accounts to an Excel spreadsheet automatically ie not by copying
> and pasting. I need to press a button and it is done without the
> opportunity for errors to be introduced to the figures.Then I use some
> pre-approved software which reads the spreadsheet and uploads the data to
> HMRC. Is there some way to transfer a balance from an account to an Excel
> spreadsheet? _______________________________________________

Hi Paul.

Yes. quite easy.

You need the report called Income and GST statement, which I find under the 
Reports -> Income & Expenses menu.

Then options -> Format -> UK VAT return
(and any other tweaking you need)

Export -> as CSV

boom, open the CSV in your spreadsheet...

(I use one from CHM software in LibreOffice Calc to file the return, I've 
persuaded it to open the exported CSV and self-populate.  Not an endorsment, 
no connection etc, but I find it does the job.)

good luck.
Maf.