Re: [GNC] Buying with PayPal - how do I split the transaction?
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?
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?
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
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
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]
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?]
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
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
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?
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.