Re: Trading Accounts
And run “Actions -> Check & Repair -> Check & Repair All” to add the needed splits to existing transactions. Gruß, Christoph > Am 12.02.2018 um 01:27 schrieb David Carlson: > > I think that if you want to stop using trading account s it is difficult to > turn them off. > > I would set up a test file to try them on until you decide whether you like > them. > > David C > > On Feb 11, 2018 5:39 PM, "Adrien Monteleone" > wrote: > >> Yes, you can add trading accounts (or any other accounts) as needed to your >> current file. >> >> Regards, >> Adrien >> >> On Sun, Feb 11, 2018 at 4:18 PM, Les wrote: >> >>> I have been using GC for several years, and although I trade stocks, I >>> have never used the "Trading Accounts" option. Can I just start using >> it, >>> or would I need to start a new GC file? >>> >>> Thanks, >>> >>> Les >>> >>> ___ >>> 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. >> > ___ > 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: Trading Accounts
I think that if you want to stop using trading account s it is difficult to turn them off. I would set up a test file to try them on until you decide whether you like them. David C On Feb 11, 2018 5:39 PM, "Adrien Monteleone"wrote: > Yes, you can add trading accounts (or any other accounts) as needed to your > current file. > > Regards, > Adrien > > On Sun, Feb 11, 2018 at 4:18 PM, Les wrote: > > > I have been using GC for several years, and although I trade stocks, I > > have never used the "Trading Accounts" option. Can I just start using > it, > > or would I need to start a new GC file? > > > > Thanks, > > > > Les > > > > ___ > > 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. > ___ 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: A predictive bar graph needed
There is an expense and income graph that shows bars over months. You can also get a data table for each. Then, there is a future scheduled transaction report you can run. So set up your recurring income/expenses to see that data. There is currently no built-in way to get a bar chart with future scheduled transactions, and the app will not 'guess' for you based on past entries. You CAN export or copy and paste the Future Scheduled Transaction report to a spreadsheet and generate a graph there if you like. Regards, Adrien On Sun, Feb 11, 2018 at 5:12 PM, Cliff McDiarmidwrote: >Hi > >I've just moved over from Quicken. There was a rather neat feature in >it, whereby through a 12 month calender, one could input expenses and >income over the days of the months and see the predicted outcome in a >bar graph below. > >I need a similar thing in gnucash, but through the budget feature a >cannot get the outcome at the moment. I can only get a monthly view >which is not imformative enough. Any advice appreciated. > >thanks > >Cliff > ___ > 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.
A predictive bar graph needed
Hi I've just moved over from Quicken. There was a rather neat feature in it, whereby through a 12 month calender, one could input expenses and income over the days of the months and see the predicted outcome in a bar graph below. I need a similar thing in gnucash, but through the budget feature a cannot get the outcome at the moment. I can only get a monthly view which is not imformative enough. Any advice appreciated. thanks Cliff ___ 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.
Trading Accounts
I have been using GC for several years, and although I trade stocks, I have never used the "Trading Accounts" option. Can I just start using it, or would I need to start a new GC file? Thanks, Les ___ 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: Switching from Windows to Mint
As someone who has been using Linux as my principal operating system on home and business PCs since 2004, I can say with certainty that Linux helps those who help themselves. It'll be worth the effort, though. I don't use Mint, but the spousal unit does and on the rare occasions I've had to intervene with her machine one of the really nice things I've noticed about it is the Mint user community. There is competent help available if you really need it. Check out the user forum if you haven't already had the chance. Glad you got GnuCash going. RBM On 02/11/2018 12:44 PM, Robin Chattopadhyay wrote: Hello again! I appear to have solved my own issues. I had a number of dependencies missing in addition to what's listed in the wiki: * libdbd-sqlite3 * libofx-dev * libgoffice-0.8 * libgtk2.0-dev On Sun, Feb 11, 2018 at 12:05 PM, Robin Chattopadhyaywrote: Hi all- I've been using GnuCash for years on various versions of Windows, but I got a new computer and decided to make the leap to Linux. I'm using Mint 18.3 and I'm having trouble building from source. I've been following the steps in the wiki. (I tried the distribution, but it doesn't have the sqlite/libdbi options installed. And the version is 2.6.12) So, I've been trying to build my own with 2.6.19 and I'm running into a problem with cmake. It's complaining that I'm not passing a check for finding 'webkit-1.0>=1.2' Any pointers for a new *nix user on how to get past this? Thanks, Robin ___ 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: Reports crash Gnucash
FWIW, I had the same experience - i.e., the message "Gnucash has stopped working" after installing 2.6.18 on a 64 bit Windows 8.1 desktop and a 64 bit Windows 10 laptop (both HP machines). A slow response to a large report was not the problem. On each machine, I waited in vain for 10 to 15 minutes for a simple two page Balance Sheet report. My solution? Revert back to 2.6.16 which is where I'll stay for now. = On 2/10/2018 7:23 PM, gnucash-user-requ...@gnucash.org wrote: Date: Sat, 10 Feb 2018 19:14:16 -0600 From: David CarlsonTo: Ken Pyzik Cc: Stan Brown , Gnucash Users Subject: Re: Reports crash Gnucash Message-ID: Content-Type: text/plain; charset="UTF-8" Stan, I am sorry that your experience with GnuCash has not been favorable. I suspect that you may not have gotten the correct release of 2.6.19 for windows as I think there was a glitch early on that caused the crashing when opening reports that you mention. I believe the bug that you were trying to follow is very rare if it ever happens in Windows 10 or even Windows 7. It was more common in XP and Vista. You could try downloading a fresh copy of GnuCash and re-installing it again or use this link: https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.19/gnucash-2.6.19-setup.exe/download. Before you do that, tho, read the rest of this message... Some others have reported that reports are very slow to open in that release. I have not migrated to 2.6.19 myself, I am staying on release 2.6.18. It is also slow with very large files, but I do not have any issues with reports. Thus, I would suggest downloading and installing release 2.6.18. It is available here: https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.18/ As far as trying to find scheduled transactions in the ledger, they will not appear there until after they have been entered into the account registers by the Since Last Run assistant. The Future Scheduled Transactions Summary gives a clue that you have some coming up, but i personally do not like that report. I use the Scheduled Transaction Editor to see what is coming up soon. If you have other issues, please bring them up here, as there are several developers and users here that are willing to help new users when they hit speed bumps. David C On Sat, Feb 10, 2018 at 6:32 PM, Ken Pyzik wrote: Stan -- I am using 2.6.19 on 64-bit Windows 10. While the reporting module is indeed very slow (bug report already out there was this) and while it does say "Not Responding", eventually the report does come up (after about 60-90 seconds). I agree that it may be way too long -- but it does technically work. My belief is that it should work for you if given enough time. That all being said -- for almost of us -- this is still considered a bug -- but it does work -- eventually. -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org] On Behalf Of Stan Brown Sent: Saturday, February 10, 2018 7:38 AM To:gnucash-user@gnucash.org Subject: Reports crash Gnucash MODERATORS -- The entire list doesn't need to see this, but I'd appreciate if you'd pass this on to the developers. I wanted to like Gnucash, I really did, but it crashes e=whenever I try to generate any report from any Gnucash file. I installed Gnucash 2.6.19 (from link at Gnucash.org) on my 64-bit Windows 7 laptop and 64-bit Windows 8 laptop and started working my way through the tutorial. When I made a scheduled transaction and couldn't see it in the ledger, I attempted to display the report of scheduled transactions. Got only a blank window, and when I clicked Close the title bar showed "not responding". When I clicked the red x in the upper right corner to close the window, I got "Gnucash has stopped working". The same thing happened with every report I tried (maybe ten of them, min various categories), and whether I had reports opening in a separate window or not. This happens on both my laptops. I looked in the FAQ Wiki https://wiki.gnucash.org/wiki/FAQ#Q:_I_cannot_get_any_ report_to_display_not_ even_the_sample_reports._All_that_displays_is_an_empty_tab. and found a recommendation to change Internet options. That didn't help. I followed the link from the FAQ to the bug report https://bugzilla.gnome.org/show_bug.cgi?id=645273 which was entered SEVEN YEARS AGO. There were various suggestions related to Internet Explorer, which I tried, but as other folks found, those suggestions did not help. I then Googled the gnucash-user archive and found nothing new, just rehashes of the same problem. HTML files and trace files were generated in my temp folder, but there's no point in sending them since many others have done that already, yet
Re: One account for both Income and Expenses possible?
At Sun, 11 Feb 2018 15:51:30 +0100 Jeff Abrahamsonwrote: > > On 11/02/18 15:46, Robert Heller wrote: > > Here is a "practical" application: > > > > Lets say you buy a case of tomatoes for $10 -- this would be a transaction > > from your bank account (for the check you gave the vegetable wholeseller) of > > $10 to your Assets:vegetables account. (It is not actually an expense!). > > Then > > you sell that case of tomatoes for $12. This would be a split transaction: > > $10 > > from your Assets:vegetables account and $2 to an income account. The $12 > > would > > come from whatever account the $12 was paid into (eg "Cash" if it was a cash > > transaction). This brings the Assets:vegetables down to zero (you have no > > vegetables in stock right now). At the end of the year you generate a report > > showing the Assets:vegetables at the beginning of the year and and the end > > of > > the year. The difference is your "cost of goods sold" -- this is what goes > > on > > your tax form (actually, the form has your inventory at the beginning of the > > year, and your inventory at the end of the year, plus whatever you spent to > > acquire your inventory during the year, at least that is how the 1040C form > > works and I guess theo 1040F is similar). > > Our emails crossed. I see what you mean, but I don't think the tax > authorities would find that particularly legal here. It would also make > VAT computations impossible, I think, although we are exempt from VAT. If VAT is anything like Sales Tax, the sales transaction would include all of the pieces as parts of the "split". This is what I do: gross cash/payment in => 1) reduce inventory account by the cost of the goods 2) sales tax on the transaction to the sales tax account 3) whatever is left over to an income account (this will show up on your P report) Yes, the only real gotcha is that vegatables are not durable goods, so you have to account for spoilage somehow. It is possible to group things: Assets:Inventory:Vegetables Assets:Inventory:Fruits Assets:Inventory:Handicrafts Assets:Inventory:Meat etc. (And further subdivide -- Assets:Inventory:Vegetables:Tomatoes, Assets:Inventory:Vegetables:GreenBeans,etc. It would depend on the level of detailneeded and you can generate reports using the accounts at different levels, depending on what you need.) > > Thanks for explaining clearly! > -- Robert Heller -- 978-544-6933 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ 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: One account for both Income and Expenses possible?
On 2/11/2018 9:03 AM, Robert Heller wrote: At Sun, 11 Feb 2018 08:15:56 +0100 Jeff Abrahamsonwrote: ... transfer "money" from the vegetable account to a bank account (income when you sell vegetables) and when you transfer money from a bank account to the vegetable account (an expense when you buy vegetables). *I* do this which my inventory of thumb drives. GnuCash does not have "inventory" accounts or any way of dealing with inventory as such Inventory MANAGEMENT is something else (gnucash lacks this but that belongs in an inventory system*, not "general ledger". But you are saying that gnucash does not support inventory value and cost accounting and that is simply not so. Let's say incidental to its main activity an organization sells various things (tee shirts, coffee mugs, etc.) as a fund raiser. You create under Assets (after "current assets" and "fixed assets") a parent "Inventory of goods". Under that might be accounts (more likely also parents as batches of goods might have different basis) for "tee shirts", "coffee mugs", etc. When the organization buys a new batch of tee shirts that is a debit to "tee shirts" (or as I mentioned, perhaps "tee shirts batch 4" --- the account description can include what the unit price was for this batch) and a credit to checking << note: we get confused using the supposedly more user friendly terms worrying about what sort of "transfer" this is). Each sale of a tee shirt not only debits cash and credits "sale of tee shirts" for the sale price but also debits "cost of goods sold" and credits the inventory account "tee shirts batch N" for the unit cost of batch N << going to be a policy decision whether to simply use FIFO or to actually worry about from which batch that shirt came. Maybe BOTH come into play. To use your example, thumb drives, you might have 8 Gb drives (batches of those) and 16 Gb drives (batches of those) so you might want under "thumb drives" children "8 Gb drives" and "16 Gb drives" and under each of those "batch 1, batch2, etc. and use FIFO there >> Michael D Novack * The data kept here things like "number on hand", "physical location where shelved", "reorder point", etc. ___ 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: One account for both Income and Expenses possible?
On 11/02/18 15:46, Robert Heller wrote: > Here is a "practical" application: > > Lets say you buy a case of tomatoes for $10 -- this would be a transaction > from your bank account (for the check you gave the vegetable wholeseller) of > $10 to your Assets:vegetables account. (It is not actually an expense!). Then > you sell that case of tomatoes for $12. This would be a split transaction: $10 > from your Assets:vegetables account and $2 to an income account. The $12 would > come from whatever account the $12 was paid into (eg "Cash" if it was a cash > transaction). This brings the Assets:vegetables down to zero (you have no > vegetables in stock right now). At the end of the year you generate a report > showing the Assets:vegetables at the beginning of the year and and the end of > the year. The difference is your "cost of goods sold" -- this is what goes on > your tax form (actually, the form has your inventory at the beginning of the > year, and your inventory at the end of the year, plus whatever you spent to > acquire your inventory during the year, at least that is how the 1040C form > works and I guess theo 1040F is similar). Our emails crossed. I see what you mean, but I don't think the tax authorities would find that particularly legal here. It would also make VAT computations impossible, I think, although we are exempt from VAT. Thanks for explaining clearly! -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ ___ 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: One account for both Income and Expenses possible?
On 11/02/18 15:03, Robert Heller wrote: > > I expect that the OP wants to have an account that represents his stock of > vegetables (or whatever). He can actually do that. What you do is think of the > vegetables as a kind of currency or comodity or inventory, that is the > vegetables themselves are an asset (Assets:vegetables). Then when you sell > vegetables the vegetable account is redued and when you buy vegetables the > vegetable account is increased. This happens by transactions which transfer > "money" from the vegetable account to a bank account (income when you sell > vegetables) and when you transfer money from a bank account to the vegetable > account (an expense when you buy vegetables). *I* do this which my inventory > of thumb drives. GnuCash does not have "inventory" accounts or any way of > dealing with inventory as such -- the two "features GnuCash lacks are payroll > and inventory management features. Payroll processing is a huge process (not > trivial to implement) but inventory management can be "faked" by considering > inventory as if it were a currency of sorts, by just having an account with a > balance representing the value of the inventory, which then goes up or down as > inventory is bought or sold. Since he is a farm, I expect he is growing > vegetables, so things are slightly more tricky. Maybe it might be useful to > think of his farm like Bitcoin mining -- maybe someone with that sort of > experience can describe how to represent a Bitcoin currency and how to > represent the mining process -- one would do the same with growing vegetables > somehow. That is enticing, and I've contemplated doing the same. But, unlike a currency, which is a durable form of value that (except for currency traders) does not constitute P, the vegetables also should show up in income and expense accounts. I'd really love to have our inventory show up in our accounting system, but it's even more important to have our income and expenses show up, and it seems to be either/or. buy inventory bank [cx] -> expense [dx] (add value) sell inventory income [cx] -> bank [dx] or faking it with currencies buy inventory bank [cx] -> inventory [dx] (add value) sell inventory inventory [cx] -> bank [dx] Except in this second case, only my balance sheet changes, not my P Did I miss something? (This is moving away from OP, but a common theme here and one that I'd like to understand.) -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ ___ 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: One account for both Income and Expenses possible?
At Robert Hellerwrote: > > At Sun, 11 Feb 2018 08:15:56 +0100 Jeff Abrahamson wrote: > > > > > On 11/02/18 05:22, Norbert Klein wrote: > > > I am a complete newcomer to GNUcash, using version 2.6.19 on Windows 10. > > > > > > My name is Norbert, living in the countryside in Cambodia. > > > > > > This is my first posting. > > > > Welcome, Norbert. > > > > > > > I live on a farm =96 we produce, sell, and buy vegetables, fruits, and > > > handicrafts. > > > > > > [...] > > > When I now enter something like =93Selling vegetables=94 I can enter the > > > price under =93Charge/Income=94 into Income. - When I enter something like > > > =93Buying vegetables=94 I can enter the income under =93Expense/Rebate=94= > > into > > > Expenses (and as a double-entry to Cash, increasing or decreasing). > > > > > > [...] > > > > > > But could I instead set up an account =93Vegetables=94 where I can enter > > > both BOUGHT Vegetables and SOLD Vegetables? (same for fruits and > > > handicrafts) > > > > It depends what you want to do. > > > > When you sell vegetables, you are making a transfer from an income > > account to (probably) a cash or bank account. > > When you buy vegetables, you are making a transfer from a cash/bank > > account to an expense account. > > > > So that cash/bank account is a common account where you see both.=A0 If > > your goal is ease of entry, for example, that one account is the place > > to do it. > > > > Alternatively, you can construct reports where you see only vegetable > > income and expense transactions (if you have dedicated expense and > > income accounts for vegetables).=A0 I'm a bit new to gnucash, and I > > haven't fully explored the report functions.=A0 But an appropriately > > filtered income/expense report should be possible. > > > > But maybe that's not what mean.=A0 Maybe you can let us know what need you > > want to satisfy this way. > > I expect that the OP wants to have an account that represents his stock of > vegetables (or whatever). He can actually do that. What you do is think of the > vegetables as a kind of currency or comodity or inventory, that is the > vegetables themselves are an asset (Assets:vegetables). Then when you sell > vegetables the vegetable account is redued and when you buy vegetables the > vegetable account is increased. This happens by transactions which transfer > "money" from the vegetable account to a bank account (income when you sell > vegetables) and when you transfer money from a bank account to the vegetable > account (an expense when you buy vegetables). *I* do this which my inventory > of thumb drives. GnuCash does not have "inventory" accounts or any way of > dealing with inventory as such -- the two "features GnuCash lacks are payroll > and inventory management features. Payroll processing is a huge process (not > trivial to implement) but inventory management can be "faked" by considering > inventory as if it were a currency of sorts, by just having an account with a > balance representing the value of the inventory, which then goes up or down as > inventory is bought or sold. Since he is a farm, I expect he is growing > vegetables, so things are slightly more tricky. Maybe it might be useful to > think of his farm like Bitcoin mining -- maybe someone with that sort of > experience can describe how to represent a Bitcoin currency and how to > represent the mining process -- one would do the same with growing vegetables > somehow. Here is a "practical" application: Lets say you buy a case of tomatoes for $10 -- this would be a transaction from your bank account (for the check you gave the vegetable wholeseller) of $10 to your Assets:vegetables account. (It is not actually an expense!). Then you sell that case of tomatoes for $12. This would be a split transaction: $10 from your Assets:vegetables account and $2 to an income account. The $12 would come from whatever account the $12 was paid into (eg "Cash" if it was a cash transaction). This brings the Assets:vegetables down to zero (you have no vegetables in stock right now). At the end of the year you generate a report showing the Assets:vegetables at the beginning of the year and and the end of the year. The difference is your "cost of goods sold" -- this is what goes on your tax form (actually, the form has your inventory at the beginning of the year, and your inventory at the end of the year, plus whatever you spent to acquire your inventory during the year, at least that is how the 1040C form works and I guess theo 1040F is similar). > > > > > -- = > > > > > > Jeff Abrahamson > > +33 6 24 40 01 57 > > +44 7920 594 255 > > > > http://p27.eu/jeff/ > > > > > > ___ > > 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
Re: One account for both Income and Expenses possible?
At Sun, 11 Feb 2018 08:15:56 +0100 Jeff Abrahamsonwrote: > > On 11/02/18 05:22, Norbert Klein wrote: > > I am a complete newcomer to GNUcash, using version 2.6.19 on Windows 10. > > > > My name is Norbert, living in the countryside in Cambodia. > > > > This is my first posting. > > Welcome, Norbert. > > > > I live on a farm =96 we produce, sell, and buy vegetables, fruits, and > > handicrafts. > > > > [...] > > When I now enter something like =93Selling vegetables=94 I can enter the > > price under =93Charge/Income=94 into Income. - When I enter something like > > =93Buying vegetables=94 I can enter the income under =93Expense/Rebate=94= > into > > Expenses (and as a double-entry to Cash, increasing or decreasing). > > > > [...] > > > > But could I instead set up an account =93Vegetables=94 where I can enter > > both BOUGHT Vegetables and SOLD Vegetables? (same for fruits and > > handicrafts) > > It depends what you want to do. > > When you sell vegetables, you are making a transfer from an income > account to (probably) a cash or bank account. > When you buy vegetables, you are making a transfer from a cash/bank > account to an expense account. > > So that cash/bank account is a common account where you see both.=A0 If > your goal is ease of entry, for example, that one account is the place > to do it. > > Alternatively, you can construct reports where you see only vegetable > income and expense transactions (if you have dedicated expense and > income accounts for vegetables).=A0 I'm a bit new to gnucash, and I > haven't fully explored the report functions.=A0 But an appropriately > filtered income/expense report should be possible. > > But maybe that's not what mean.=A0 Maybe you can let us know what need you > want to satisfy this way. I expect that the OP wants to have an account that represents his stock of vegetables (or whatever). He can actually do that. What you do is think of the vegetables as a kind of currency or comodity or inventory, that is the vegetables themselves are an asset (Assets:vegetables). Then when you sell vegetables the vegetable account is redued and when you buy vegetables the vegetable account is increased. This happens by transactions which transfer "money" from the vegetable account to a bank account (income when you sell vegetables) and when you transfer money from a bank account to the vegetable account (an expense when you buy vegetables). *I* do this which my inventory of thumb drives. GnuCash does not have "inventory" accounts or any way of dealing with inventory as such -- the two "features GnuCash lacks are payroll and inventory management features. Payroll processing is a huge process (not trivial to implement) but inventory management can be "faked" by considering inventory as if it were a currency of sorts, by just having an account with a balance representing the value of the inventory, which then goes up or down as inventory is bought or sold. Since he is a farm, I expect he is growing vegetables, so things are slightly more tricky. Maybe it might be useful to think of his farm like Bitcoin mining -- maybe someone with that sort of experience can describe how to represent a Bitcoin currency and how to represent the mining process -- one would do the same with growing vegetables somehow. > > -- = > > > Jeff Abrahamson > +33 6 24 40 01 57 > +44 7920 594 255 > > http://p27.eu/jeff/ > > > ___ > 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. > > > -- Robert Heller -- 978-544-6933 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ 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: One account for both Income and Expenses possible?
On Sunday, 11 February 2018 04:22:43 GMT Norbert Klein wrote: > I am a complete newcomer to GNUcash, using version 2.6.19 on Windows 10. > > My name is Norbert, living in the countryside in Cambodia. > > This is my first posting. > > Apologies for my very simple question. I would appreciate to get help. > > I live on a farm – we produce, sell, and buy vegetables, fruits, and > handicrafts. > > When I set up a GNUcash system it created an Expense and an Income > section, and under them I created specific accounts and sub-accounts. > > When I now enter something like “Selling vegetables” I can enter the > price under “Charge/Income” into Income. - When I enter something like > “Buying vegetables” I can enter the income under “Expense/Rebate” into > Expenses (and as a double-entry to Cash, increasing or decreasing). > > The same for fruits, and for handicrafts. > > But could I instead set up an account “Vegetables” where I can enter > both BOUGHT Vegetables and SOLD Vegetables? (same for fruits and > handicrafts) > > When I tried to create such an account, I can select only ONE Account > Type: Expense or Income. > > Please kindly advise. > > > Norbert > Hi Norbert. Welcome to the list. Let me start by saying that you should have started a new thread for your question and not hijacked the existing thread, which is about something completely different. It would have made your question easier to find if anyone else ever has the same question in the future. You can do what you want, but I think it would be a bad idea. If you have an account Income:Vegetables, you can record expenses to that account, effectively it would be "negative income" though. The reason I think it would be a bad idea is that it would make it very hard to see how much you have spent (or earned) in total on vegetables, or to compare year to year totals etc. If this is a business that would need to fill in tax forms for the government, then what you suggest would certainly not be approved by the tax people, and might even be illegal depending on your local rules (you'd have to ask a local accountant about your local rules). HTH, Maf. -- 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: One account for both Income and Expenses possible?
On 11/02/18 05:22, Norbert Klein wrote: > I am a complete newcomer to GNUcash, using version 2.6.19 on Windows 10. > > My name is Norbert, living in the countryside in Cambodia. > > This is my first posting. Welcome, Norbert. > I live on a farm – we produce, sell, and buy vegetables, fruits, and > handicrafts. > > [...] > When I now enter something like “Selling vegetables” I can enter the > price under “Charge/Income” into Income. - When I enter something like > “Buying vegetables” I can enter the income under “Expense/Rebate” into > Expenses (and as a double-entry to Cash, increasing or decreasing). > > [...] > > But could I instead set up an account “Vegetables” where I can enter > both BOUGHT Vegetables and SOLD Vegetables? (same for fruits and > handicrafts) It depends what you want to do. When you sell vegetables, you are making a transfer from an income account to (probably) a cash or bank account. When you buy vegetables, you are making a transfer from a cash/bank account to an expense account. So that cash/bank account is a common account where you see both. If your goal is ease of entry, for example, that one account is the place to do it. Alternatively, you can construct reports where you see only vegetable income and expense transactions (if you have dedicated expense and income accounts for vegetables). I'm a bit new to gnucash, and I haven't fully explored the report functions. But an appropriately filtered income/expense report should be possible. But maybe that's not what mean. Maybe you can let us know what need you want to satisfy this way. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ ___ 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.