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
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
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
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
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
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
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
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
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
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
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
12 matches
Mail list logo