Re: [GNC] questions from a new user
Michael, I took Neil's comment to mean that he didn't want to connect to his bank account online. Neil, I'd like to point out that, despite the scope of your endeavor, you're in business, which will entail a certain amount of record keeping. Gnucash is directly designed for this sort of business, and will allow you to manage those finances in the ways you've described, but it *does* have a stiff learning curve, and you do have to learn a bit about accounting to use it. That being said, many non-accountants (myself among them) have been able to use GnuCash successfully to meet their needs. David T. On Jan 9, 2023, 4:42 AM, at 4:42 AM, Michael or Penny Novack wrote: >On 1/8/2023 7:14 PM, Neil Morrish wrote: >> Hi >> I am not sure if gnucash is right for me, as it seems quite hard to >get >> started. Can you advise me what steps to learn about for my simple >> requirement please? >> I want to keep a record of business transactions so I can send >invoices and >> make an annual report for my tax calculation. >> I do work for 4 or 5 customers and like to give an invoice that shows >the >> things I've done , the cost of the work, and the expenses I incur. >> I dont want to link this to my bank account. >> When it is set up, is it easy to input the entries quickly? > >By "I don't want to "link" to my bank account do you perhaps mean that >you are NOT wanting this to be a full personal set of books? You want >this JUST for your small number of customers business. > >Yes, you CAN use gnucash for this purpose. In effect, you are setting >up >a subset of what would be full books. It WOULD have a "bank account" >for >when the invoices you sent customers are paid. But this "bank account" >would be a (virtual) subset of your actual bank account. So don;t >(later) ask us how you can use gnucash's reconciliation << will be >manual for you >> > >So you would set up using the business features option and just the >income and expense accounts associated with your business plus that >asset account "bank". You will be able to run a report for the year >showing profit (or loss) for tax purposes. The only complication I can >see is if you file your taxes "cash basis" because using the business >features requires accrual basis, but it IS possible to adjust for that >at year end << for tax filing, subtract what's still in "receivables" >form income and what's still in "payables" from expenses >> > >BUT -- if new to double entry bookkeeping do carefully read the >tutorial >and if that's not enough to give you understanding, some standard >"Bookkeeping 101" text or on-line. Software like gnucash is partially >automating the process of keeping double entry books but you still have > >to understand what you are doing. > >Michael D Novack > > >___ >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. ___ 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] questions from a new user
On 1/8/2023 7:14 PM, Neil Morrish wrote: Hi I am not sure if gnucash is right for me, as it seems quite hard to get started. Can you advise me what steps to learn about for my simple requirement please? I want to keep a record of business transactions so I can send invoices and make an annual report for my tax calculation. I do work for 4 or 5 customers and like to give an invoice that shows the things I've done , the cost of the work, and the expenses I incur. I dont want to link this to my bank account. When it is set up, is it easy to input the entries quickly? By "I don't want to "link" to my bank account do you perhaps mean that you are NOT wanting this to be a full personal set of books? You want this JUST for your small number of customers business. Yes, you CAN use gnucash for this purpose. In effect, you are setting up a subset of what would be full books. It WOULD have a "bank account" for when the invoices you sent customers are paid. But this "bank account" would be a (virtual) subset of your actual bank account. So don;t (later) ask us how you can use gnucash's reconciliation << will be manual for you >> So you would set up using the business features option and just the income and expense accounts associated with your business plus that asset account "bank". You will be able to run a report for the year showing profit (or loss) for tax purposes. The only complication I can see is if you file your taxes "cash basis" because using the business features requires accrual basis, but it IS possible to adjust for that at year end << for tax filing, subtract what's still in "receivables" form income and what's still in "payables" from expenses >> BUT -- if new to double entry bookkeeping do carefully read the tutorial and if that's not enough to give you understanding, some standard "Bookkeeping 101" text or on-line. Software like gnucash is partially automating the process of keeping double entry books but you still have to understand what you are doing. Michael D Novack ___ 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] One payment covering multiple invoices
David, On Sun, January 8, 2023 6:35 pm, Dr. David Kirkby wrote: > On Sun, 8 Jan 2023 at 23:16, Derek Atkins wrote: > >> Just apply the 300£ payment split between the two invoices. In the >> process payment, just select both. >> -derek >> > > I am using my phone now, not near the computer, so this is from memory. > > On the business features there is a way to list who needs paying. Two were > listed as needing paying, but it was not obvious how to select both. I > will > havé to look again tomorrow. As I said, you need to do it from the Process Payment window. You don't do it from a "search". > > Dave -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] questions from a new user
Hi I am not sure if gnucash is right for me, as it seems quite hard to get started. Can you advise me what steps to learn about for my simple requirement please? I want to keep a record of business transactions so I can send invoices and make an annual report for my tax calculation. I do work for 4 or 5 customers and like to give an invoice that shows the things I've done , the cost of the work, and the expenses I incur. I dont want to link this to my bank account. When it is set up, is it easy to input the entries quickly? ___ 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] One payment covering multiple invoices
On Sun, 8 Jan 2023 at 23:16, Derek Atkins wrote: > Just apply the 300£ payment split between the two invoices. In the > process payment, just select both. > -derek > I am using my phone now, not near the computer, so this is from memory. On the business features there is a way to list who needs paying. Two were listed as needing paying, but it was not obvious how to select both. I will havé to look again tomorrow. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] One payment covering multiple invoices
Just apply the 300£ payment split between the two invoices. In the process payment, just select both. -derek Sent using my mobile device. Please excuse any typos. On January 8, 2023 18:04:28 "Dr. David Kirkby" wrote: I have an account with an electronics company RS. I get invoiced on the 20th of each month. Anything brought up to the 20th then needs to be paid by the 20th of next month. So depending on when I place the order, I can get from roughly 30 to 60 days credit. So I buy something for £100 one day, and another day I buy something for £200. So I created two bills. But when I pay, I just pay a single invoice of £300. How should this be handled in GnuCash? Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. ___ 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. ___ 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] One payment covering multiple invoices
I have an account with an electronics company RS. I get invoiced on the 20th of each month. Anything brought up to the 20th then needs to be paid by the 20th of next month. So depending on when I place the order, I can get from roughly 30 to 60 days credit. So I buy something for £100 one day, and another day I buy something for £200. So I created two bills. But when I pay, I just pay a single invoice of £300. How should this be handled in GnuCash? Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. ___ 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] Trial balance
John, Thanks for the information. I had no idea that the date range had a purpose on the TB. David T. On Jan 8, 2023, 8:34 PM, at 8:34 PM, john wrote: > > >> On Jan 8, 2023, at 2:47 AM, David T. via gnucash-user > wrote: >> >> As I understand it, the Trial Balance report is As Of A Date, and >therefore cumulative to that date. Not sure why the report includes >start and end dates in that circumstance, except to follow settings >provided by other reports. > >The start date is used to set a date range with end date for filtering >out book-closing and adjusting splits according to patterns set on the >Entries page of report options. The default values are descriptions >"Closing Entries" and "Adjusting Entries" respectively. For all other >purposes only the end date matters. > >Regards, >John Ralls ___ 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] QIF format for StkSplit
Tim, Since I still have a working copy of Quicken 2017, I started a new file and then did a single stock split and this is what it looks like when exported from Quicken in QIF format: !Type:Invst D8/24'22 NBuy YTesla Inc I891.29 Q1 U891.29 T891.29 ^ D8/25'22 NStkSplit YTesla Inc I302.36 Q30 ^ This transaction is for Tesla's 3:1 stock split that happened on Aug 25th. Essentially I bought a single stock of Tesla on Aug 24th at the closing price of $891.29. Then stock split 3:1 on Aug 25th with optional opening price of $302.36. Note that Quantity is listed as thirty - 10x value - on the split date! For kick-&-giggles I set the split to 1000:1 (this split size is limited by Quicken) and this is what it looks like: !Type:Invst D8/24'22 NBuy YTesla Inc I891.29 Q1 U891.29 T891.29 ^ D8/25'22 NStkSplit YTesla Inc I302.36 Q10,000 ^ So from the looks of it, the stock split needs an extra zero on the quantity of after the split quantity. And for split of 1000:3 as follows: !Type:Invst D8/24'22 NBuy YTesla Inc I891.29 Q1 U891.29 T891.29 ^ D8/25'22 NStkSplit YTesla Inc I302.36 Q3,333.33 ^ So Quicken 2017 on Windows is consistent that the final quantity it stores is 10X of what should be the normal stock split ratio that would be arrived at using strait math. When I imported the first and the last stock split QIF configuration above, GNC v4.11 on Windows imported the QIF (IMHO) as intended. -- Message: 2 Date: Thu, 5 Jan 2023 13:51:28 -0600 From: m...@tgr66.me To: gnucash-user@gnucash.org Subject: [GNC] QIF format for StkSplit Message-ID: <7a1892d0-5538-4140-8fd7-e18904494...@tgr66.me> Content-Type: text/plain; charset=utf-8 I?ve searched considerably, but if I missed it, I apologize. Docs for QIF say the Q field should contain the split ratio. I?ve tried various options, but I?m not getting the expected results after import. !Type:Invst D8/31/2020 NStkSplit PAPPLE INC YAAPL CR M4 for 1 split; Q36 // Have also tried 4:1, 4/1 and simply 48 ^ GnuCash 4.13 on macOS. I?ve not tried yet on my Linux box. Thanks. -- Message: 3 Date: Thu, 5 Jan 2023 15:02:24 -0500 From: David Reiser To: m...@tgr66.me Cc: gnucash-user@gnucash.org Subject: Re: [GNC] QIF format for StkSplit Message-ID: Content-Type: text/plain; charset=utf-8 I?ve never used QIF for stock splits, but the obvious question is ?Have you tried Q4?? After all, 4/1 is numerically equal to 4 (a ratio reduced to a single number). -- Dave Reiser dbrei...@icloud.com > On Jan 5, 2023, at 2:51 PM, m...@tgr66.me wrote: > > I?ve searched considerably, but if I missed it, I apologize. > > Docs for QIF say the Q field should contain the split ratio. I?ve tried various options, but I?m not getting the expected results after import. > > !Type:Invst > D8/31/2020 > NStkSplit > PAPPLE INC > YAAPL > CR > M4 for 1 split; > Q36 // Have also tried 4:1, 4/1 and simply 48 > ^ > > GnuCash 4.13 on macOS. I?ve not tried yet on my Linux box. > > Thanks. > ___ > 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. -- ___ 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] Trial balance
> On Jan 8, 2023, at 2:47 AM, David T. via gnucash-user > wrote: > > As I understand it, the Trial Balance report is As Of A Date, and therefore > cumulative to that date. Not sure why the report includes start and end dates > in that circumstance, except to follow settings provided by other reports. The start date is used to set a date range with end date for filtering out book-closing and adjusting splits according to patterns set on the Entries page of report options. The default values are descriptions "Closing Entries" and "Adjusting Entries" respectively. For all other purposes only the end date matters. Regards, John Ralls ___ 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] ASSETS
On 1/8/2023 8:35 AM, davidbrown.r...@photos.bozeat.biz wrote: 08 Jan 23 Dear all, I have a couple of additional assets to be included in EoY reports in a few months, that have cost nothing, but a value needs to be shown as assets have increased. How do I include those at their value? My current status for that account is ASSETS > Current Assets > Equipment although there is another account showing Equity > Equipment Assets Thank you ... David This is an accounting question, not a gnucash question. You need to refer to the rules of your jurisdiction/ By the account named (Equipment Assets) I assume that these are probably "fixed assets" that are depreciated annually. You say 'cost nothing" so I assume that means literally (cost nothing to acquire) or already fully depreciated. In MY jurisdiction these would come onto the (new) books at zero value. Yes, they might have residual real value in the sense that they could be sold for something. But if and when that happens, the "profit" (sale price - basic cost + depreciation since acquisition) would be a capital gain. You would not "mark to market" << in your main/legal books >> as this gain is still imaginary/conditional/hasn't happened yet an maybe never will. HOWEVER -- there is a special case situation where your "legal" economic state (according to your jurisdiction) is very different from your actual economic state because some assets have greatly more value than the jurisdiction recognizes. In that case, perhaps a second set of virtual books that have no legal standing. This does not require total duplication of effort as this second set of books need only have a few accounts and these adjusted only annually, etc. It's not JUST assets the jurisdiction doesn't recognize but possibly also expenses paid on your behalf that the jurisdiction doesn't consider income. The purpose of accounting is financial INFORMATION including the ability to compare "what ifs" and without being able to take into account things like this you couldn't, for example, compare two job alternatives, one with and one without a large amount of such "percs" Michael D Novack. ___ 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] ASSETS
08 Jan 23 Dear all, I have a couple of additional assets to be included in EoY reports in a few months, that have cost nothing, but a value needs to be shown as assets have increased. How do I include those at their value? My current status for that account is ASSETS > Current Assets > Equipment although there is another account showing Equity > Equipment Assets Thank you ... David -- This email has been checked for viruses by AVG antivirus software. www.avg.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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trial balance
As I understand it, the Trial Balance report is As Of A Date, and therefore cumulative to that date. Not sure why the report includes start and end dates in that circumstance, except to follow settings provided by other reports. As for multi currency trial balances, there have been many discussions about the effect of exchange rates on the report, but the trading accounts are supposed to address that. I've never had a trial balance report balance (in 15 years of GnuCash use), but then I've also never turned trading accounts on (because I'm afraid of what it might change in those data). An opening balance entry is not required; every account begins at some point in time at zero. I'm sure others can provide additional insights (and correct my inevitable inaccuracies). David T. On Jan 8, 2023, 10:14 AM, at 10:14 AM, Fred Tydeman wrote: >I have run a Transaction report (for all accounts) for just one day in >the >past (to find all the transactions on that one day). It found just one >transaction where I bought 600 yuan for 99.07 USD (at an ATM in china). >The grand totals in the report are 0 USD and 0 yuan. > >That one transaction has four splits: >Receive column: > Assets:...:$china 600 > Trading:cash US:ftexx 99.07 Fid. TE MM >Spend column: > Assets:..:Fid. TE MM 99.07 Fed. TE MM > Trading:CURRENCY:CNY 600 > >That transaction is the first one in $china. There is no Equity >Opening >Balance (which would be zero) for $china. > >I then ran a Trial Balance report; again for just that one day and all >accounts. The two totals at the bottom of the report do not match >(differ >by 5.46). If I change the date to 6 days earlier (again for just one >day), >the two totals match. > >By one day, I mean both Start date and Date of report are the same. > >OS: Fedora Linux 37 >GnuCash: 4.13 >Trading accounts are on. > >Is Trial Balance supposed to work when there is a mixture of >currencies? >Is Trial Balance supposed to work for just one day in the past? >Do all accounts need an Equity Opening Balance? >___ >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. ___ 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] Budget report fails in multiple currencies
Yes, it's cumulative, which is a problem I think. Let: 0 indicate the opening of the book 1 indicate the start of the budget period in question 2 indicate the end of that period S_i indicates the sum of transactions since 0 at marker i, in the currency of the sub-account P_i indicates the sum of transactions since 0 at marker i, in the currency of the parent account ES_ij indicates the sum of transactions during a period bounded by i and j, in sub-account currency X_i gives the exchange rate between sub-account and parent-account The trouble is that the report prints out: P_2 - P_1 = S_2*X_2 - S_1*X_1 = (S_1+ES_12) * X_2 - S_1 * X_1 = ES_12 * X_2 + S_1( X_2 - X_1) My problem is that I only really care about the first term, that contains ES_12. But as the years go by, S_1 >> ES_12, so the second term increasingly dominates. This becomes particularly visible when X_2-X_1 is significant, which has certainly been the case looking at GBP and EUR in recent years ;) By the way, I agree that "ES_12*X_2" is a bit trivial, and it would be nice to account for the variation of exchange rates during the year, but that's a second-order effect compared to this bug. To show this in the code: The "Actual" column in the budget report is populated by "gnc:get-account-periodlist-actual-value" https://github.com/Gnucash/gnucash/blob/master/gnucash/report/reports/standard/budget.scm#L404 which just calls "gnc-budget-get-account-period-actual-value budget acct period" https://github.com/Gnucash/gnucash/blob/master/gnucash/report/reports/standard/budget.scm#L313 which calls "gnc_budget_get_account_period_actual_value" https://github.com/Gnucash/gnucash/blob/master/libgnucash/engine/gnc-budget.cpp#L671gnc_budget_get_account_period_actual_value which calls "recurrenceGetAccountPeriodValue" https://github.com/Gnucash/gnucash/blob/master/libgnucash/engine/Recurrence.c#L421 where the documentation says "@return the amount that an Account's value changed between the beginning and end of the nth instance of the Recurrence." The problem is that this does: https://github.com/Gnucash/gnucash/blob/master/libgnucash/engine/Account.cpp#L3992 gnc_numeric b1, b2; b1 = xaccAccountGetNoclosingBalanceAsOfDateInCurrency(acc, t1, NULL, recurse); b2 = xaccAccountGetNoclosingBalanceAsOfDateInCurrency(acc, t2, NULL, recurse); return gnc_numeric_sub(b2, b1, GNC_DENOM_AUTO, GNC_HOW_DENOM_FIXED); ___ 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.