Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-09 Thread list+gnucash

Hello, David:

I have the same kind of transactions in my small business bookkeeping as 
you describe here. My responses are interleaved below.


On 2022-12-09 12:00, Dr. David Kirkby wrote:

I have the following accounts, and am buying something in GBP.

Assets -> Accounts  Receivable -> GBP
Assets -> Bank account
Assets -> PayPal -> GBP
Expenses -> Utilities -> Internet
Liabilities -> Accounts Payable -> GBP

I paid Google £15 for using some cloud storage (OneDrive) using PayPal. So
PayPal took the money from the bank account and paid Google.

*If I were NOT using PayPal, this is the process I would go through.*

*Under Business -> Vendor -> New Bill*
Create a bill and post that to these accounts
*Expense Account:* Expenses -> Utilities -> Internet
*Post to Account: * Liabilities -> Accounts Payable -> GBP

*Under Business -> Vendor -> Process Payment*
Process the payment
*, using these accounts*
*Post to*: Liabilities -> Accounts Payable -> GBP
*Transfer Account:* Assets ->  Bank account

Am I doing that all correctly done, if not using PayPal ?


I do not use the Business -> Vendor features to handle such 
transactions, even for business expenses. If the funds are leaving my 
possession as part of the payment, I do not see a reason to involve 
Accounts Payable. So I follow this process:


Create a simple transaction with these accounts
*Asset Account:* Assets ->  Bank account
*Other Account:* Expenses -> Utilities -> Internet


...how can I modify the process so the  account* Assets ->
PayPal -> GBP* account gets used?
If I am using Paypal, which keeps a zero balance, then as soon as I pay 
for something with Paypal, Paypal funds that amount by charging my bank 
account (or credit card, sometimes). I follow a process with two simple 
transactions:


*Asset Account:* Assets ->  Paypal account -> GBP
*Expense Account:* Expenses -> Utilities -> Internet

*Asset Account:* Assets ->  Paypal account -> GBP
*Other Account:* Assets ->  Bank account

This means that the expense is recorded in the Expense Account, the 
Paypal ledger has two matching transactions to reconcile against my 
Paypal statement, and the Bank account ledger has a single transaction 
to reconcile against the Bank statement.


Hope this helps!

      —Jim DeLaHunt


___
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] How to bulk import about 130 Securities entries?

2022-08-16 Thread list+gnucash

On 2022-08-16 19:54, john wrote:


OTOH I'm pretty sure that gnc_commodity is fully exposed to the Python bindings 
so you should
be able to write a python script using them to do the same thing without 
voiding your warranty
or needing to unzip the file or, for that matter, caring which backend is used.


Ah! Thank you for this nudge, John. I like using Python. Doing my import 
via Python would likely be very comfortable for me.


This question may end up leading me to learn not just how to automate my 
mac UI, but also how to use the Python bindings in GnuCash.


I have been using the macOS GnuCash app downloaded via GnuCash.org, 
which I understand does not include Python bindings. However, I use 
MacPorts all the time, and it looks like MacPorts will be happy to 
provide me GnuCash with the Python bindings enabled.


I appreciate the pointer. (Well, not pointer exactly, because it is 
Python after all, but… reference?)


 —Jim DeLaHunt

___
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] How to bulk import about 130 Securities entries?

2022-08-16 Thread list+gnucash

Chris:

On 2022-08-16 02:36, Chris Good wrote:
…There is code in the ofx import to handle creating securities which 
is done before an investment transaction if the security (commodity) 
does not exist and Preference, Import, "Automatically create new 
commodities" is ticked.
I have never used it but maybe some-one else can supply an example ofx 
file. 


Thank you for pointing out this preferences option, and this OFX import 
code.  I was not aware of either.


I just checked with a test book. With Preferences -- Import -- 
"Automatically create new commodities" checked, I performed an input of 
an Accounts CSV file which referred to a novel security. The CSV 
importer rejected it with an error message about the missing commodity.


CSV import is not the same as OFX import, of course. I don't have the 
information to quickly create an OFX test case.


And I have not tried CSV import of a transaction. It might be that 
transaction import has some code to create new commodities which account 
import is lacking.



___
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] Multiple currencies

2022-07-17 Thread list+gnucash

Servus Norbert, welcome to GnuCash:

On 2022-07-16 22:14, Norbert Klein wrote:

I am a new gnucash user, living in Cambodia (since 32 years).

I downloaded (in Windows 10), installed and tried to set up gnucash with
the US$ as the basic currency (which was already set-up as a default). I
have not yet set up the accounts.

Then I tried to find out how to make it possible to use, in addition,
also the Cambodian currency - the Riel - which is used here,
alternatively to the US$, every day. The Riel is available as one of the
currencies that can be used in gnucash.

I spent quite some time reading gnucash documents, but so far without
success. I would be most grateful if somebody could help me.


I have used GnuCash for many years with a book that included 
transactions in Canadian Dollars, US Dollars, Euros,  Japanese Yen, and 
more. It all works quite well. I can encourage you that what you seek is 
definitely possible.


My advice to you:

1. Do read the GnuCash concepts and tutorial guide, especially Chapter 
12 /Multiple Currencies/ 
<https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_currency.html>.


2. Do enable Trading Accounts, as described in 12. /Automatically 
Recording Currency Transactions using Trading Accounts/ 
<https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_trading_accts.html>. 
I have always used them. (In fact, I cannot tell you what happens if you 
do not use them, because I have not tried.


3. I second Paul Kroitor's excellent advice that you make a "test book" 
for practice and experiments. Accept a default chart of accounts. Make a 
few accounts in KHR currency. Enter a few test transactions. See how 
things work.  Then set up your real book.


4. I use the one currency structure for my asset accounts, and a 
different currency structure for my expense accounts. See if either of 
these makes sense for you.


a. Who / Currency / Category / Detail structure, which I use in my Asset 
accounts.


Level 1: Who, i.e. Personal assets vs My Business assets.
Level 2: Currency, e.g. CAD Personal assets vs USD Personal assets.
Level 3: Category, adopted from GnuCash suggested chart of accounts, 
i.e. Current Assets, Investments, Accounts Receivable
Level 4: Detail, adopted from specific bank accounts and investment 
accounts, e.g. Credit Union Chequing, Cash, Brokerage Account Cash Balance.


e.g. Assets:Personal Assets:CAD Personal Assets:Current Assets:Credit 
Union Chequing

Assets:Personal Assets:CAD Personal Assets:Current Assets:Cash CAD in pocket
Assets:Personal Assets:USD Personal Assets:Investments:Brokerage 
account:USD Cash Balance

Assets:Business Assets:USD Personal Assets:Current Assets:Paypal acct USD

b. Who / Detail / Currency structure, which I use in my Expense accounts.

Level 1: Who, i.e. Personal expenses vs My Business expenses.
Level 2: Detail, adopted from GnuCash suggested chart of accounts, 
modified by my own needs, i.e. Rent, Groceries, Dining

Level 3: Currency, e.g. CAD Groceries vs USD Groceries.

e.g. Expenses:Personal Expenses:Groceries:CAD Groceries
Expenses:Personal Expenses:Groceries:USD Groceries
Expenses:Personal Expenses:Groceries:CAD Rent
Expenses:Business Expenses:Computer Accessories:CAD Computer Accessories
Expenses:Business Expenses:Computer Accessories:USD Computer Accessories

I enter way more Expense account paths than Asset account paths. This 
currency-last structure makes it easier for GnuCash to complete each 
segment of the path when I type just the first few characters. If I type 
"Ex:P:Gro:C" then GnuCash expands those initial characters to 
"Expenses:Personal Expenses:Groceries:CAD Groceries".


5. Don't feel like you have to get the account tree right the first 
time. You can change the structure and the account names later, and the 
transactions will move with the changes.


Or more accurately: when you create an Account, GnuCash gives it a 
unique identifier behind the scenes. The transactions are linked to 
these unique identifiers, not to the Account's name or parent accounts. 
When you change the Account's name, or move it to a different parent 
Account, the identifier remains unchanged. Thus the transactions are 
still attached to the account, despite its new name and parent.


I hope this is helpful.  Have fun with the experiments!

Best regards,
 —Jim DeLaHunt, Vancouver, Canada


Norbert (Klein) - a German

_______
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.


_______
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscri

Re: [GNC] Multiple currencies in split tx

2022-06-30 Thread list+gnucash

Hello, HSC:

Welcome to GnuCash.

On 2022-06-30 13:30, HSC wrote:

...Is it possible to account in one GC split entry for a tx in which a payment 
processor simultaneously makes a payment to two different vendors in two 
different local currencies?...


In my experience, yes. I have made some transactions like this.


We see it on the statement as one payment in source currency and two in 
destination currencies, without any details regarding conversion rates.

Do we have to calculate all that manually, and enter in GC as two separate txs?


My suggestions:

1. Read the "Multiple Currencies" section of the GnuCash Tutorial and 
Concepts Guide 
<https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_currency.html>


2. Enable trading accounts (see 12.3 Automatically Recording Currency 
Transactions…). I have always used trading accounts in GnuCash, so I 
have no experience without trading accounts.


3. Know that each transaction has a default currency, but GnuCash does 
not easily show you which currency that is. GnuCash sets the default 
currency to be the currency of whichever account you were in when you 
created the transaction.  If you have three currencies, $AA, $BB, and 
$CC, and you want the transaction's default currency to be $CC, then go 
to an account register which has $CC as its currency, and create the 
transaction there.


4. You will have to establish an exchange rate between the currency of 
each split of the transaction, and the default currency of the 
transaction. For each split, if the account for that split uses the 
transaction's default currency, GnuCash will accept the amount you type 
in for that transaction. If the account for that split uses a different 
currency, then GnuCash will display a "Transfer Funds" dialogue (See 
12.3.2.2. Transfer of Funds to a Foreign Currency). You will have to 
determine an amount of the transaction's default currency which 
corresponds to the split amount, in the split account's currency.


4.example. Suppose you have a transaction where you pay $AA 4.00, and 
the payment processor pays out $BB 2.00 and $CC 1.00. Go to the source 
account, which uses $AA. Enter a split for that account with the amount 
4.00. Add a split with an account which receives the $BB 2.00. Enter the 
amount 2.00. A "Transfer Funds" dialogue appears. Enter the amount of 
$AA which corresponds to $BB 2.00. (You need to determine this yourself, 
if the payment processor does not document it for you.) Then add another 
split with an account which receives the $CC 1.00. Enter the amount 
1.00. In a similar way, fill out the Transfer Funds dialogue to set up 
an exchange rate between $AA and $CC.


5. GnuCash enforces a rule that, within every transaction, the sum of 
all splits using a currency sum to zero. This includes splits with 
trading accounts, which GnuCash creates based on what you entered in the 
"Transfer Funds" dialogue.


5.example. In the transaction with a source payment of $AA 4.00, there 
will be one split involving the source account, with a value of $AA 
4.00, and one or two splits involving the TRADING:$AA account, summing 
to -$4.00. The sum for all the splits in $AA is zero.


6. Note that you can use GnuCash as a calculator, by entering 
expressions in amount fields. See GnuCash Guide, 2.9.2.4. Using Entry 
Shortcuts. I use this for splitting the calculating a fraction of the 
total for individual splits.


This is complicated to describe in words. I recommend doing some trial 
and error to experiment, and learn it that way.  Save a copy of your 
Book file as another name. Open that copy, and make some test 
transactions. When you understand what you want to do, open your 
original Book file, and enter the transaction.


Does that help?

Best regards,
  —Jim DeLaHunt





_______
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.

_______
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] How to start fresh [was: Re: gnucash-user Digest, Vol 231, Issue 70]

2022-06-29 Thread list+gnucash
was not
updated for 4.11 $HOME/.var/app/org.gnucash.GnuCash/



On Mon, Jun 27, 2022, at 3:34 PM, David H wrote:

The wiki is your friend -https://wiki.gnucash.org/wiki/Flatpak

Cheers David H.


On Tue, 28 Jun 2022 at 04:05, Stephen C. Camidge  wrote:

When using gnucash 4.10 installed from Linux Manjaro repository, my saved 
reports are stored here:
  /home/steve/.local/share/gnucash/

I installed gnucash 4.11 from flathub and saved a newly created report.  I 
cannot find where the report is stored on my hard drive. My plan was to move my 
old settings over to the flatbed version so I could properly test the latest 
version.

How do I find where 4.11 is storing the preferences?
___
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 
seehttps://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.


--

Message: 2
Date: Tue, 28 Jun 2022 06:48:50 -0500
From: David Carlson
To: "Stephen C. Camidge"
Cc: David H, Gnucash Users

Subject: Re: [GNC] Saved Reports
Message-ID:

Content-Type: text/plain; charset="UTF-8"

For certain cases the migration to 4.11 has " lost " some information, this is 
a known issue .  Check other messages for more information.

On Mon, Jun 27, 2022, 7:55 PM Stephen C. Camidge
wrote:


Interesting. That location did work.

Further, some data went to
/home/steve/.var/app/org.gnucash.GnuCash/data/< 
http://org.gnucash.gnucash/data/>

But /home/steve/.var/app/org.gnucash.GnuCash/data/gnucash/< 
http://org.gnucash.gnucash/data/gnucash/>  is more complete.

Thank you very much for your help.
Steve




On Mon, Jun 27, 2022, at 8:43 PM, David H wrote:

Just rebooted into Mint Linux and mine are in

$HOME/.var/app/org.gnucash.GnuCash/data/gnucash - did you drill down
far enough ?  I seem to recall I would have manually copied my
saved-reports-2.8 file into that directory as Flatpak obviously
doesn't know about them initially...

Cheers David H.

On Tue, 28 Jun 2022 at 10:34, Stephen C. Camidge


wrote:

__
Thank you, but I do not have any entries here:
$HOME/.local/share/flatpak/app/org.gnucash.GnuCash/

and the other is where I was looking, but the saved reports was not

updated for 4.11

$HOME/.var/app/org.gnucash.GnuCash/



On Mon, Jun 27, 2022, at 3:34 PM, David H wrote:

The wiki is your friend -https://wiki.gnucash.org/wiki/Flatpak

Cheers David H.


On Tue, 28 Jun 2022 at 04:05, Stephen C. Camidge


wrote:

When using gnucash 4.10 installed from Linux Manjaro repository,
my

saved reports are stored here:

  /home/steve/.local/share/gnucash/

I installed gnucash 4.11 from flathub and saved a newly created

report.  I cannot find where the report is stored on my hard drive. My
plan was to move my old settings over to the flatbed version so I
could properly test the latest version.

How do I find where 4.11 is storing the preferences?
___
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.

___
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.



--

Message: 3
Date: Tue, 28 Jun 2022 07:12:41 -0700
From: Fred Tydeman
To: Gnucash Users
Subject: Re: [GNC] Split ownership
Message-ID:

Content-Type: text/plain; charset="UTF-8"

I see I was not clear in my description of the transactions.

I wrote a check for the full price of a golf cart to a dealer.
The next day, a friend gave me their half of the cost.
Some years later, I sold the golf cart and I got the full selling price from 
the buyer.
A few days later, I gave half of the selling price to my friend.

I guess I could record the purchase as 1/2 to golf cart asset and 1/2 to short 
term loan to friend.  And that loan is paid back the next day.

And the same idea would be used for the sale.

On Mon, Jun 27, 2022 at 4:01 PM Fred Tydeman  wrote:


A friend and I bought a golf cart, each paying 1/2 of the price.
Some years later, we sold that golf car

Re: [GNC] a place to ask personal finance questions [was: Re: Am I in business?]

2022-05-14 Thread list+gnucash

On 2022-05-13 7:31 p.m., arthur brogard via gnucash-user wrote:


…This is the only forum I know of where I can ask such questions.  If it's 
misuse of this forum and anyone knows a more fitting place please let me know.…


Another forum that might be a good place to ask such questions is the 
Personal Finance and Money Stack Exchange 
<https://money.stackexchange.com/>. They even have a tag for "[gnucash]" 
questions.



___
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] Adding new income category or new expenses category

2021-07-15 Thread list+gnucash


On 2021-07-15 13:07, Stephen M. Butler wrote:

On 7/15/21 12:27 PM, Jim DeLaHunt wrote:

Hello, Barry:

Welcome to GnuCash and welcome to the gnucash-user list. The word 
"Bellingham" in your signature caught my eye. Bellingham, WA is near 
where I live. It is known as the "the city of subdued excitement". :-)


Is this a West Coast thread?   Battle Ground, WA (Near that other 
Vancouver).


Yes. This is the thread where we plan a new region-specific edition, 
"GnuCashcadia". :-)


    — Jim ">121.5°W" DeLaHunt
_______
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] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-14 Thread list+gnucash

On 2021-06-12 23:49, Jim DeLaHunt wrote:

…I submit that installing packages with MacPorts or Homebrew has 
aspects of installing application software, as well as aspects of 
altering the OS. Installing application software is a reasonable thing 
for people to do with their personal computers. I don't think its 
reasonable to say that GnuCash should ignore the existence of MacPorts 
and Homebrew.


It would help for the gnucash-cli documentation to mention that 
GnuCash lets the environment pick which perl instance to run.


It would help for the Finance::Quote troubleshooting documentation to 
mention this problem, and the solution.


It would help for the GnuCash error message to also say, "Use `perl -e 
'print join("\n", @INC), "\n";'` to see where perl is looking.".



I improved the documentation a bit in 
https://wiki.gnucash.org/wiki/Online_Quotes to add the clarification 
which I was lacking in this situation. I also copy-edited and refactored 
the existing content a bit. The changes are in the sections: 
Warnings/Multiple Perl installations on macOS,  Troubleshooting, and 
Technical Details.


Thanks especially to John Ralls for providing the technical information 
which helped me understand the situation well enough that I could 
explain it.


Best regards,
    —Jim DeLaHunt


_______
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] How do I get the 3D Interface look - Take 2?

2021-03-15 Thread list+gnucash


On 2021-03-15 17:22, viking wrote:

…The interface changed now, but it doesn't give me the nice "3D" interface
seen in the manuals (from v2.x which used GTK2).
What was the reason for going to GTK3, and loosing the much nicer looking
(IMHO) "3D" interface?


One of the developers will probably be able to point to the specific 
reasons and the specific announcements by the GnuCash project. But as an 
onlooker I can tell you that the people behind GTK2 moved on to GTK3, 
and now GTK4. Their recommendation to everyone was to use the overlap 
time of GTK2 and GTK3 simultaneous support to move apps from GTK2 to 
GTK3. Then, with the release of GTK4, they stopped supporting GTK2. If 
GnuCash were not to move forward along with the GTK project, they would 
have no way to get bug fixes and improvements from the GTK project. 
There is a lot more to GTK than just the 2D vs 3D look. IMHO it is a 
wise decision for GnuCash to move forward as recommended by their tool 
providers.


Best regards,
    —Jim DeLaHunt, Vancouver, Canada


___
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.