Re: [GNC] Export values to Excel
Yes it's MTD. How can I add this report to my GC? I'd like to have a play around with it. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Export values to Excel
Use a recent build (3.7 should be fine), copy https://raw.githubusercontent.com/christopherlam/gnucash/maint-csv-export/gnucash/report/standard-reports/uk-vat-report.scm into the standard-reports folder. It should add the UK-VAT report. Please note the 4.x series should not need it; the Income-GST Report will incorporate the UK-VAT rules. On Mon, 4 Nov 2019 at 11:08, Bumbling Amateur via gnucash-user < gnucash-user@gnucash.org> wrote: > Yes it's MTD. > > How can I add this report to my GC? I'd like to have a play around with it. > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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] Export values to Excel
Thanks for the updates & advice, Chrisotpher. Look forward to v4 in due course. Maf. On Monday, 4 November 2019 11:49:21 GMT Christopher Lam wrote: > Use a recent build (3.7 should be fine), copy > https://raw.githubusercontent.com/christopherlam/gnucash/maint-csv-export/gn > ucash/report/standard-reports/uk-vat-report.scm into the standard-reports > folder. It should add the UK-VAT report. > > Please note the 4.x series should not need it; the Income-GST Report will > incorporate the UK-VAT rules. > > On Mon, 4 Nov 2019 at 11:08, Bumbling Amateur via gnucash-user < > > gnucash-user@gnucash.org> wrote: > > Yes it's MTD. > > > > How can I add this report to my GC? I'd like to have a play around with > > it. > > > > > > > > -- > > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > > ___ > > 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. -- Maf. King PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How should I enter values on a budget in gnucash ?
Michael, Of course, I understand your points. I was speaking specifically from the perspective of the budgeting module. Budgeting to put cash in savings, investment, or other asset, or peg it to equity doesn’t (with some minor exceptions) change what you have available to spend, it just changes its location/form. (which would be more in line with the term ’transfer’ as used in the summary section) Paying a liability *does* decrease your spendable cash. So from a budgeting perspective that isn’t really a ’transfer’ as it appears the summary line intends. Budgeting allots inflows. It isn’t about double-entry balancing. You don’t even need to allocate everything, or even determine from whence it came. The summary section could also read “Inflows, Outflows, Transfers, Total” and convey the same info. Chris, Maybe those would be better terms to avoid confusion that budgeting has to be double-entry? It would also more properly describe the budgeting process and its purpose, where the registers/ledger handle the double-entry of the actual activity. Regards, Adrien > On Oct 29, 2019 w44d302, at 12:44 PM, Michael or Penny Novack > wrote: > > On 10/29/2019 9:40 AM, Adrien Monteleone wrote: >> No objection here —I always thought it odd that Liabilities didn’t have its >> own total line, and thought ’Transfers’ should only include Assets & Equity. >> (you are transferring one asset to another, with no effect on net position, >> but paying a liability would change your net position) >> > Assets and Equity are NOT "both assets" << this is confusing a different > meaning of equity>> > > A transfer between "assets" and "liabilities"does NOT change net position > (ie: equity). A transfer from assets to liabilities that is "paying a > liability" is a debit to a liability (reducing it) and a credit to an asset > (reducing it) so no net change as the debit and credit will be equal. Taking > on more debt, a debit to an asset and a credit to a liability also does not > change net position (equity) > > What sort of transaction would be a transfer between an asset and equity? > Why do you think that this would not be a change to your net position? > > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Account for contracted grain sales?
I am just getting started with GnuCash (should have done so long ago...) and my main occupation these days is farming. I've been using a simple cash accounting system all of these years and I am able to configure my accounting in GnuCash to get an even more realistic view of my finances as time goes on. Thank you! In the future, i.e. next year, I will be taking on the role of treasurer for our church which is the principal reason I started with my personal finances so as to gain familiarity with GnuCash. One thing I have done for years is enter into a deferred payment contract with the cooperative that buys my grain. In general the grain is sold as of a given date with payment at some future specified date. In my case I generally defer payment until the beginning of the coming calendar year. What this represents, at least to me, is a transfer of the title of my asset (grain) to the cooperative immediately and then sometime in the future a payment from the cooperative for my asset. Other than my copies of the contract(s), I've not tracked this in any way, which I would now like to do. At first I thought of structuring this as an Account Receivable but skimming through that section of the manual, it doesn't look like quite the right fit. As I see it, I have a sort of promissory note that doesn't pay interest, if that makes any sense, that in early January will be paid by the cooperative. It is future income but I don't want it listed as such until next year. Of course, I could always let it ride until the funds are deposited in a couple of months. TIA - Nate -- "The optimist proclaims that we live in the best of all possible worlds. The pessimist fears this is true." Web: https://www.n0nb.us Projects: https://github.com/N0NB GPG fingerprint: 82D6 4F6B 0E67 CD41 F689 BBA6 FB2C 5130 D55A 8819 signature.asc Description: PGP signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] budget reports 'YTD' vs 'use accumulated amounts'
I am using gnuCash 2.6.15 for windows and rely on Phil's custom YTD report to compare income and expenses against my budget. I am considering upgrading to the current version which I understand has a similar report called 'use accumulated amounts'. I am wondering if anyone has used both and can let me know if 'use accumulated totals' works as well as YTD. ch I understand has a similar report called 'use accumulated amounts'. I am wondering if anyone has used both and can let me know if 'use accumulated totals' works as well as YTD. YTD gives me a report that includes: current month vs budget, year to date vs budget and current income and expenses vs annual budget. I don't want to lose that functionality if I upgrade. TIA, Larry ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] expense problem
I'm not an accountant. I use GNUCASH for personal finances. Many years and counting. I received a gift card for $200. I entered this in GNUCASH as income:gifts received:gift card. I used the $200 for groceries, McDonald's and a dental bill for $132. The gift card NOW shows a zero balance as it should. The Expenses:groceries recorded a debit as if I had used a credit card. No problem here. The dental account/journal, however, shows a negative balance of $132. How can the gift card record the expenditure without it recording properly as a credit in the dental account? I've tried GNUCASH 2.6.21 and 3.7, each with the same results. Richard ___ 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] expense problem
What was the opposite (debit) side of the transaction when you recorded the receipt of the gift card? That same account should have been the credit side of each expense transaction. (the debit side being the actual expense) If you are using the Basic view - either show the splits for this info on that transaction, or turn on Transaction Journal View or Auto-Split View from the View Menu. I usually record my gift cards as you did as gifts received, with the debit side of that to an Assets:Current-Assets:Pre-Paid Cards:xyz account, where ‘xyz’ is the store or type of card. This allows me to keep those cards organized and see at a glance what balance I have on each. When I spend using the card, that is where the funds come from. (the credit side of the expense transaction) Regards, Adrien > On Nov 4, 2019 w45d308, at 7:01 PM, RICHARD YENTZER > wrote: > > I'm not an accountant. I use GNUCASH for personal finances. Many years and > counting. > > I received a gift card for $200. I entered this in GNUCASH as income:gifts > received:gift card. > > I used the $200 for groceries, McDonald's and a dental bill for $132. > > The gift card NOW shows a zero balance as it should. The Expenses:groceries > recorded a debit as if I had used a credit card. No problem here. > > The dental account/journal, however, shows a negative balance of $132. > > How can the gift card record the expenditure without it recording properly > as a credit in the dental account? > > I've tried GNUCASH 2.6.21 and 3.7, each with the same results. > > Richard ___ 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] Account for contracted grain sales?
> On Nov 4, 2019, at 4:22 AM, Nate Bargmann wrote: > > I am just getting started with GnuCash (should have done so long ago...) > and my main occupation these days is farming. I've been using a simple > cash accounting system all of these years and I am able to configure my > accounting in GnuCash to get an even more realistic view of my finances > as time goes on. Thank you! In the future, i.e. next year, I will be > taking on the role of treasurer for our church which is the principal > reason I started with my personal finances so as to gain familiarity > with GnuCash. > > One thing I have done for years is enter into a deferred payment > contract with the cooperative that buys my grain. In general the grain > is sold as of a given date with payment at some future specified date. > In my case I generally defer payment until the beginning of the coming > calendar year. What this represents, at least to me, is a transfer of > the title of my asset (grain) to the cooperative immediately and then > sometime in the future a payment from the cooperative for my asset. > > Other than my copies of the contract(s), I've not tracked this in any > way, which I would now like to do. At first I thought of structuring > this as an Account Receivable but skimming through that section of the > manual, it doesn't look like quite the right fit. As I see it, I have a > sort of promissory note that doesn't pay interest, if that makes any > sense, that in early January will be paid by the cooperative. It is > future income but I don't want it listed as such until next year. > > Of course, I could always let it ride until the funds are deposited in a > couple of months. How you handle this depends on two things: The tax consequences and whether anyone else looks at your books. If you're not taxed on the sale of the grain until the following year and your books are likely to be audited or used in a friendly discussion with the tax man--a situation consistent with "cash accounting"--then you don't want to recognize the transfer until you actually get paid. In that case just credit income:sales and debit your bank account. If you owe the tax when the grain is transferred or you have other ways of presenting your records in a tax audit then you can just create two accounts: Assets:Sold Grain and Income:Grain Sales. When you deliver the grain to the coop you debit Assets:Sold Grain and credit Income:Grain Sales. When you get paid the following January you credit Assets:Sold Grain and debit your bank account. 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 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.
