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 <m...@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.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.
