Re: [GNC] exporting from gnucash to Excel

[Paul W via gnucash-user]

 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

[Paul W via gnucash-user]

 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.

[GNC] exporting from gnucash to Excel

[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 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] UK Flat Rate VAT

[Paul W via gnucash-user]

There's a few posts about this subject but I can't find any that provide a 
solution. I'd like to know how to account for UK Flat Rate VAT.
EgInvoice: £1000+ VAT @ 20%: £200Invoice Total: £1200
Flat Rate VAT @ 16.5% of invoice total is paid to the government: £198The 
remainder is added to income: £2
Than you, Paul

___
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] withholding tax

[Paul W via gnucash-user]

 
Thanks Maf, that does seem to work. Shame there's not an automatic way to do 
this as WHT isn't a tax from Mars!



On Friday, 2 October 2020, 15:09:37 GMT+8, Maf. King wrote:


Hi Paul,

A possible way to deal with this is to process the full payment to your bank
account, then go an manually split the witholding portion out of the
transaction as it appears in the bank account.

so step 1. process payment for the full £100

step 2. Go to the bank account, edit the transaction. Reduce the split into
the bank account to £80 and allocate the £20 to the WHT account.

(step 3 - check your work to see if it all makes sense for tax-return time!)

regards,
Maf.



On Friday, 2 October 2020 05:18:43 BST Paul W via gnucash-user wrote:
> Stan,
>
> I see what you are saying. Practically I think I need to process the invoice
> payment twice, first part payment (80) to Accounts Receivable then another
> payment (20) to Assets: WHT. But I don't seem to have this ability in
> gnucash because when I process an invoice payment in the 'post to' box only
> has Assets: Accounts Receivable as an option in the pull down menu. Help!
>
> Paul
>
> On 2020-10-01 19:14, Paul W via gnucash-user wrote:
> > Foreign Government A keeps this money and My Government B will credit this
> > amount against my corporation tax liability.
> >
> > My invoice is for the full amount, £100.
> >
> > Usually (without WHT) when the invoice is paid the full amount is
> > sent to my Accounts Receivable. In this case I think the way to do it
> > is for gnucash to send £100 to Accounts Receivable then £80 will go
> > from here to my Asset: Bank Account and £20 to Asset: WHT. How do I
> > achieve this in gnucash?
>
> Just to be clear, the answer to any question like this is always, "Think
> of GnuCash as a pen-and-ink ledger. First determine what entries you
> need to make, to cover your own accounting and tax needs. Once you know
> that, you can make those entries in GnuCash."
>
> > Do you agree this is the way to do it?
>
> I don't think so. Since you will collect 80 pounds not 100, the amount
> in receivables should, I think, be 80 pounds not 100. The 20 pounds is
> an asset, but it is a prepaid tax expense and not a receivable.
>
> Debit: Assets: Receivable from {customer} 80
> Debit: Assets: Tax prepaid to {Foreign Government} 20
> Credit: Income: Sales 100
>
> Then at the end of the year you make an adjusting entry:
> Debit: Liabilities: Tax payable to {My Government) {total for the year}
> Credit: Assets: Tax prepaid to {Foreign Government} {same amount}
>
> That lets you track the amounts invoice by invoice or by annual totals.
> For strictly accounting purposes, that is what I would do. However, your
> country may mandate doing it in a particular way, so you may want to get
> local advice on that point. There's no need to bring GnuCash into that
> discussion; just ask how debits and credits should be recorded.



-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542





  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] withholding tax (Liz Dodd)

[Paul W via gnucash-user]

 Stan,

I see what you are saying. Practically I think I need to process the invoice 
payment twice, first part payment (80) to Accounts Receivable then another 
payment (20) to Assets: WHT. But I don't seem to have this ability in gnucash 
because when I process an invoice payment in the 'post to' box only has Assets: 
Accounts Receivable as an option in the pull down menu. Help!

Paul


On 2020-10-01 19:14, Paul W via gnucash-user wrote:
> Foreign Government A keeps this money and My Government B will credit this 
> amount against my corporation tax liability.
>
> My invoice is for the full amount, £100.
>
> Usually (without WHT) when the invoice is paid the full amount is
> sent to my Accounts Receivable. In this case I think the way to do it
> is for gnucash to send £100 to Accounts Receivable then £80 will go
> from here to my Asset: Bank Account and £20 to Asset: WHT. How do I
> achieve this in gnucash?

Just to be clear, the answer to any question like this is always, "Think
of GnuCash as a pen-and-ink ledger. First determine what entries you
need to make, to cover your own accounting and tax needs. Once you know
that, you can make those entries in GnuCash."


> Do you agree this is the way to do it?


I don't think so. Since you will collect 80 pounds not 100, the amount
in receivables should, I think, be 80 pounds not 100. The 20 pounds is
an asset, but it is a prepaid tax expense and not a receivable.

Debit: Assets: Receivable from {customer} 80
Debit: Assets: Tax prepaid to {Foreign Government} 20
Credit: Income: Sales 100

Then at the end of the year you make an adjusting entry:
Debit: Liabilities: Tax payable to {My Government) {total for the year}
Credit: Assets: Tax prepaid to {Foreign Government} {same amount}

That lets you track the amounts invoice by invoice or by annual totals.
For strictly accounting purposes, that is what I would do. However, your
country may mandate doing it in a particular way, so you may want to get
local advice on that point. There's no need to bring GnuCash into that
discussion; just ask how debits and credits should be recorded.

-- 
Regards,
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
https://OakRoadSystems.com

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] withholding tax (Liz Dodd)

[Paul W via gnucash-user]

 Foreign Government A keeps this money and My Government B will credit this 
amount against my corporation tax liability.

My invoice is for the full amount, £100.

Usually (without WHT) when the invoice is paid the full amount is sent to my 
Accounts Receivable. In this case I think the way to do it is for gnucash to 
send £100 to Accounts Receivable then £80 will go from here to my Asset: Bank 
Account and £20 to Asset: WHT. How do I achieve this in gnucash?

Do you agree this is the way to do it?

On Thu, 1 Oct 2020 05:41:31 + (UTC)
Paul W via gnucash-user  wrote:

> I invoice my client ?100 for services provided. They process my
> invoice and pay me the balance of ?80 after deducting 20% (?20)
> withholding tax which they give to foreign government A. How do I
> account for this withholding tax in gnucash?
> ___

Just think about how you record this with pen and ink

But first, will you ever see the ?20 again?
Does Foreign Government A pay this back at some time?
Will you be credited this by your government instead?

According to the answer, that tells you how you might note this on
paper.

Until you have spoken to your accounting expert in your own country,
put this ?20 in an account of it's own, Asset:Withholding Tax:Country A

Later you move this to a preferred place in your account structure

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] withholding tax

[Paul W via gnucash-user]

I invoice my client £100 for services provided. They process my invoice and pay 
me the balance of £80 after deducting 20% (£20) withholding tax which they give 
to foreign government A.
How do I account for this withholding tax in gnucash?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Is there a GC function to separate a multi-split transaction into sepa rate, 2-split transactions?

[Paul W.]

I have multiple bank deposit items showing in a single, multi-split 
transaction.   
Is there a GC function to separate the multi-split transaction into separate, 
2-split transactions?
If not, I would appreciate guidance on how to manually separate the splits, 
other than re-entering each deposit item as a separate transaction.

GC novice, double-entry novice. 

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Methods to Track Gift Cards and Similar Items

[Paul W.]

Thanks to all for your guidance, "other hands" methods, and comments.  I see 
that I should use asset accounts as the primary type account to tract these 
stored-value items. I am a novice at double-entry accounting.  I have been 
using GnuCash for several months to track some of my personal financial 
transactions and  to keep a record of transactions imported from financial 
institutions.  I am also importing accounts with years of transactions from MS 
Money 3.0 (1994). I appreciate your guidance, I am certain I will need more. 
Paul

3 Common Foods Surgeons Are Now Calling "Death Foods"
Nucific
http://thirdpartyoffers.juno.com/TGL3141/598280933be3e936ccfst01vuc
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Methods to Track Gift Cards and Similar Items

[Paul W.]

I am seeking guidance on methods to track items such as gift cards, gift 
certificates, merchant cards,  bank reward cards, and store-credit cards for 
returned purchases.

On the one hand, these items are a form of income.  As such, I could track them 
as income.
On the other hand, I use these items  they way I use a credit card to make 
purchases.  As such, I could track them as a credit card.
Are there other hands with other methods?

I am looking for a simple, consistent method for all of these items so that I 
can easily track when I received the item and its initial value, and track the 
expenditures.  I want to keep all of these items in the same part of my account 
tree.   Rigorous, double-entry accounting is not essential.  Imbalance on one 
side of a transaction is OK.
  
What are the pros and cons of the various methods to track these items?


Actress Tells All: "I Felt Bloated, Tired...Now I Know Why"
ActivatedYou
http://thirdpartyoffers.juno.com/TGL3141/597f9255edc1c12556933st01vuc
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Preferred Date Format When Importing CSV Files

[Paul W.]

I set the date format to m-d-y in Edit>Preferences>Date/time
 
When I import CSV files, the date format on the Preview Settings page shows 
y-m-d.  I manually change the format to m-d-y.
What do I need to do to have GC automatically show the format I selected.



Affordable Wireless Plans
Set up is easy. Get online in minutes.
Starting at only $14.95 per month! 
www.netzero.net?refcd=nzmem0216
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Name Does Not Show in Posts

[Paul W.]

 Thanks to all for your comments.  My curiosity  is satisfied!


Affordable Wireless Plans
Set up is easy. Get online in minutes.
Starting at only $14.95 per month! 
www.netzero.net?refcd=nzmem0216
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Name Does Not Show in Posts

[Paul W.]

SOLVED
  
Thanks to all for you guidance and comments.
  
Now, a curiosity question.  What is the purpose of the optional name field in 
the Gnucash-user account?


Police Urge Americans to Carry This With Them at All Times
The Observer
http://thirdpartyoffers.juno.com/TGL3141/597a875f2485675f6b85st03vuc
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Name Does Not Show in Posts

[Paul W.]

I added my name to the "From" line of my outgoing email.
 
This is a test post to verify that my name shows in my posts to the mailing 
list.


-- Original Message --
From: Robert Heller 
To: "pfwoolver...@juno.com" 
Cc: gnucash-user@gnucash.org,Robert Heller 
Subject: Re: Name Does Not Show in Posts
Date: Wed, 26 Jul 2017 16:31:43 -0400 (EDT)

It is a setting in your E-Mail client (or Juno's webmail program).  You need 
to tell your client (or Juno's webmail program) to include your *name* as the 
E-Mail "comment", instead of your *email* address (which is what it is now).


At Wed, 26 Jul 2017 19:42:23 GMT "pfwoolver...@juno.com" 
 wrote:

> 
> 
> 
> My name does not show in my posts to the mailing list.  My email shows in the 
> name field.
> 
> I have my name in the optional name field in my Gnucash-user account.  What 
> do I need to do to get my name to show?
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
> 
> 

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services
   


1 Simple Trick Removes Eye Bags & Lip Lines in Seconds
Fit Mom Daily
http://thirdpartyoffers.juno.com/TGL3141/597a0daf44d34daf7d4ast03vuc
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.