Re: [GNC] exporting from gnucash to Excel
Just a thought - can you mangle the VAT spreadsheet to sum the CSV exported box 1 and box 6 (nett) figures to give you a grossed-up number? Maf. On Thursday, 19 January 2023 17:20:31 GMT you wrote: > How could I organise my accounts such that I can pull my total sales > including VAT into the Box 6 total in the Income and GST Statement? At > present my sales go to one account and the VAT charged goes to another. But > VAT is paid from this latter account to HMRC so the balance of the account > in a quarter does not equal the total VAT received / charged. > > On Sunday, 15 January 2023 at 19:39:36 GMT+3, Maf. King > wrote: > On Sunday, 15 January 2023 16:30:38 GMT Paul W wrote: > > 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. > > I've heard of but never looked at the flat rate scheme, so I can't really > offer any words on it. > > but if you invoice for £100 + VAT, are you saying that Box1= 20 and box 6 = > 120? > > thanks for the tip on the VAT Bridge Free will investigate it before I > do my return later in the month! > > regards, > 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.
Re: [GNC] exporting from gnucash to Excel
How could I organise my accounts such that I can pull my total sales including VAT into the Box 6 total in the Income and GST Statement? At present my sales go to one account and the VAT charged goes to another. But VAT is paid from this latter account to HMRC so the balance of the account in a quarter does not equal the total VAT received / charged. On Sunday, 15 January 2023 at 19:39:36 GMT+3, Maf. King wrote: On Sunday, 15 January 2023 16:30:38 GMT Paul W wrote: > 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. > I've heard of but never looked at the flat rate scheme, so I can't really offer any words on it. but if you invoice for £100 + VAT, are you saying that Box1= 20 and box 6 = 120? thanks for the tip on the VAT Bridge Free will investigate it before I do my return later in the month! regards, 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.
Re: [GNC] exporting from gnucash to Excel
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 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.
Re: [GNC] exporting from gnucash to Excel
On Sunday, 15 January 2023 16:30:38 GMT Paul W wrote: > 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. > I've heard of but never looked at the flat rate scheme, so I can't really offer any words on it. but if you invoice for £100 + VAT, are you saying that Box1= 20 and box 6 = 120? thanks for the tip on the VAT Bridge Free will investigate it before I do my return later in the month! regards, 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.
Re: [GNC] exporting from gnucash to Excel
How can this be enforced except by obliging you to use only software they (inland revenue?) endorse? — Peter West p...@pbw.id.au “Which is easier, to say to the paralytic, ‘Your sins are forgiven,’ or to say, ‘Rise, take up your bed and walk’?” > On 14 Jan 2023, at 6:40 am, Maf. King wrote: > > On Friday, 13 January 2023 04:45:20 GMT David T. via gnucash-user wrote: >> Indeed. >> >> I don't have to comply with this either, but it seems to me that "pressing a >> button" to export to Excel provides exactly the same automated reliability >> as CTRL-C/CTRL-V (two buttons, if you will) into Excel. The data in both >> cases will have the same reliability. >> > > You know that, I know that. The gubberment want "more automation" than > that. > > Because all the VAT fraud in the world happens when you make an honest error > copying 3 numbers between programs, not systematically at the point of data > entry... > > It's digital, and only directly linked. must be foolproof, so say the powers > that be > > Hmmm. >:-) > 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. ___ 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.
Re: [GNC] exporting from gnucash to Excel
On Friday, 13 January 2023 04:45:20 GMT David T. via gnucash-user wrote: > Indeed. > > I don't have to comply with this either, but it seems to me that "pressing a > button" to export to Excel provides exactly the same automated reliability > as CTRL-C/CTRL-V (two buttons, if you will) into Excel. The data in both > cases will have the same reliability. > You know that, I know that. The gubberment want "more automation" than that. Because all the VAT fraud in the world happens when you make an honest error copying 3 numbers between programs, not systematically at the point of data entry... It's digital, and only directly linked. must be foolproof, so say the powers that be Hmmm. >:-) 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.
Re: [GNC] exporting from gnucash to Excel
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.
Re: [GNC] exporting from gnucash to Excel
Scripts can also make redundant tasks less of a burden through hands-off automation. That's what scripts do well, too. I'm seeing a few posts in this topic verging on berating the OP for wanting to do something and asking if there's a way. Maybe you stop second-guessing the OP's needs and motives. If you have no real idea how to do something, or have nothing constructive to add, maybe just remain silent. On Fri, Jan 13, 2023 at 4:37 AM Liz Dodd wrote: > On Fri, 13 Jan 2023 07:45:20 +0300 > "David T. via gnucash-user" wrote: > > > Indeed. > > > > I don't have to comply with this either, but it seems to me that > > "pressing a button" to export to Excel provides exactly the same > > automated reliability as CTRL-C/CTRL-V (two buttons, if you will) > > into Excel. The data in both cases will have the same reliability. > > > > David T. > > It's come from the same purveyors as many other things which sound good > but don't work in the real world. > Data can get changed at any point, and it doesn't have to be as obvious > as a lightning bolt hitting your house. Automating the proceedings > doesn't guarantee accuracy, it hides the potentials for error. > > When you write your script to do this little task, there are > opportunities to add to or subtract from the data. That's what scripts > do well ;) > > Liz > ___ > 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. > ___ 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.
Re: [GNC] exporting from gnucash to Excel
On Fri, 13 Jan 2023 07:45:20 +0300 "David T. via gnucash-user" wrote: > Indeed. > > I don't have to comply with this either, but it seems to me that > "pressing a button" to export to Excel provides exactly the same > automated reliability as CTRL-C/CTRL-V (two buttons, if you will) > into Excel. The data in both cases will have the same reliability. > > David T. It's come from the same purveyors as many other things which sound good but don't work in the real world. Data can get changed at any point, and it doesn't have to be as obvious as a lightning bolt hitting your house. Automating the proceedings doesn't guarantee accuracy, it hides the potentials for error. When you write your script to do this little task, there are opportunities to add to or subtract from the data. That's what scripts do well ;) Liz ___ 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.
Re: [GNC] exporting from gnucash to Excel
Indeed. I don't have to comply with this either, but it seems to me that "pressing a button" to export to Excel provides exactly the same automated reliability as CTRL-C/CTRL-V (two buttons, if you will) into Excel. The data in both cases will have the same reliability. David T. On Jan 13, 2023, 5:11 AM, at 5:11 AM, Adrien Monteleone wrote: >Do a list search on this topic. I'm pretty certain someone has a >solution already worked out. I recall several threads over the last 2 >years or so about this. > >Apologies, but I don't use this myself, so I can't comment further. > >Regards, >Adrien > >On 1/12/23 8:05 AM, 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? > >___ >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. ___ 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.
Re: [GNC] exporting from gnucash to Excel
Do a list search on this topic. I'm pretty certain someone has a solution already worked out. I recall several threads over the last 2 years or so about this. Apologies, but I don't use this myself, so I can't comment further. Regards, Adrien On 1/12/23 8:05 AM, 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? ___ 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.
[GNC] exporting from gnucash to Excel
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? ___ 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.