[GNC] Not-for-profit report configurations sought
Hi folks, I seek standard not-for-profit report configurations, for quarterly use internal-to-organization. Links/leads appreciated, Brian- ___ 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] Tracking designated balances in the total checking account balance?
I have this same question - How to keep distinct funds within a checking account balance. Or is there a better-accounting way to do this? Brian- On Thursday, January 9, 2020, 8:05:10 AM EST, Nate Bargmann wrote: The issue I am wrestling with is how to deal with what I will call designated funds that our organization tracks internally but are just part of the one checking account. To explain further. Say there is a total checking balance of $1000.00. Then say there are two standing funds one with $200.00 and the other with $400.00. Conceptually I have: Fund A $200.00 Fund B $400.00 Undesignated $400.00 Total (as the bank statement shows) $1000.00 As deposits and withdrawals are made, in order to keep sync with the bank statement I should just work with the running account total at all times. Initially, I thought I should create and transfer funds to additional Assets accounts, but this doesn't work, as I see it, especially for reconciliations as the checking balance gets reduced accordingly. If I don't track the bank account closely, I'll go insane! I guess the standing funds will need to be tracked outside of GNU Cash, perhaps in a spreadsheet. Their balances will change throughout the year but not so often as to make this method unmanageable. The outgoing Treasurer used Quicken/Quick Books (whichever, I don't know) and he gave me several .qdf-backup files which are naturally not usable by GNU Cash. I'm not sure if he understood my request for an export to .qif. I'm loathe to buy a Windows 10 computer just for this so I'm starting from scratch to get going as quickly as possible and then may try to help him generate a .qif file sometime down the road. I'm not sure how he tracked the standing/designated balances. - 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 ___ 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] Nesting too deep for budget?
Is this caused by the 26 sub-accounts being marked as 'placeholder' accounts during creation? Not sure, I'm also a newbie, Brian- On Thursday, January 9, 2020, 2:11:50 AM EST, Nate Bargmann wrote: I am setting up a budget for this year in my new role as treasurer for our church. Ours is simply a spending budget and since we're partners with another parish there are actually two budgets, but that isn't my problem at the moment. Under Expenses I have created the placeholder account Home and under Home I have created 26 accounts. All accounts show in the Budget window but only Home has a cell where I can enter a budget amount. None of the 26 accounts have a cell for a budget amount. I had started the budget before creating the 26 accounts and thinking that was the issue created a new budget but it shows the same. I am presently running 3.7 on Debian Testing (3.8 should get here soon as the 3.8 doc package came in a couple of days ago). I can provide a screenshot if that helps Puzzled... - 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 ___ 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.
[GNC] Budget Flow Report - no column titles, & nothing in the help file
I've worked on a one-year budget in GNUCash 2.6.19, and now have made a budget flow report with two columns, but it has no column titles, nor is there explanation of the columns in the help files - There is only the words 'Budget Flow', under standard reports overview, beneath 'Budget Reports'. Brian- ___ 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] To: fellow Santander clients
How many other Santander bank users want .ofx (or .qfx) format reports and statements?With either I and you could reconcile checks more easily. I'm just told I can't get them on my existing accounts there at Santander Business. I hope to coalesce an advocacy group. Brian ___ 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] Local one-on-one tutorial help with Gnucash?
I also need help near Boston with basic GNUCash issues. Libby, if you find someone, or are willing to help me yourself as I attempt to correct transactions from and to wrong accounts and on wrong dates, I hope you'll contact me. I'm really new to double entry accrual basis bookkeeping. Brian - On Wednesday, June 12, 2019, 1:22:47 AM UTC, Libby Shaw wrote: Thanks, John! Might follow up on your suggestion, if no responses in the general neighborhood of Watertown. Hoping to sit down with someone one-on-one. Best regards, Libby Begin forwarded message: From: "johndse...@yahoo.com" Subject: Re: [GNC] Local one-on-one tutorial help with Gnucash? Date: June 11, 2019 at 8:13:33 PM EDT To: Libby Shaw , "gnucash-user@gnucash.org" Hi Libby, I'm nowhere close to you, but if you can consider a conference type call then you could get more offers, including myself. Cheers, John Sent from my Huawei phone Original Message Subject: [GNC] Local one-on-one tutorial help with Gnucash? From: Libby Shaw To: gnucash-user@gnucash.org CC: Looking for an experienced Gnucash user in or near Watertown, Massachusetts who could provide a few hours of tutorial help with Gnucash. I started using Gnucash as an accounting neophyte 3 years ago when I took over the treasurer role in a small all-volunteer nonprofit in Watertown. The previous user had been using a Windows-based accounting program, and I have a Mac. The accounting for this nonprofit is pretty simple. Until recently, activity has been minimal: annual dues, an occasional expense. Consequently I was able to set up an accounting system in Gnucash with very little resorting to online instructions. Recently, I finally got round to doing some reading in the Gnucash tutorial manual. It looks to me as though in setting up the accounts I made some architectural errors, which I’d like to correct now before I pass this role on to another accounting neophyte. If you’re experienced with Gnucash and are somewhere in the neighborhood of Watertown, and could sit down with me to advise and counsel for a couple hours, I am willing to pay a reasonable hourly fee for this education. Thank you, Libby Shaw ___ 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.
[GNC] To: GnuCash Documentation Team Re: Accounting Explanation Concept for GnuCash help file?
Hi folks, In puzzling over Debits increasing some accounts, while Credits increase others, I stumbled over an explanation that I hope will help me and others trying to learn accounting better than by remembering DEADCLIC or DEALS/ GIRLS, etc.- If one sets A = L & E equal to zero by subtracting A from both sides( 0 = -A + L + E ) Then the debit account has negative signs in front of them, and is the one debits increase.- We can adapt this to the expanded equation (A = L + E + Revenues - Expenses - Draws), re-phrasing as:0 = - Assets - Expenses - Draws on equity + Liabilities + Equity + Revenues, On the left, Debit side are the debit accounts, increased by debiting, while on the right, Credit side are the credit accounts, increased by crediting!- (Note: BeanCounter Dave Marshall's equation 'Property = Property rights' summation of 'Assets = Liabilities + Equities' really opened doors for me - thanks to him; I use it here.)- We can rewrite Marshall's simplified equation, then under it, the expanded equation, like this: 0 = - Property + Property Rights|___ - Draws + Principal/Equity/Ownership | Owner's Line0 = - Assets + Liabilities | Business Line - Expenses + Revenues/Income | Changes Line |_0 = - Debits + Credits-|- _So the debit accounts all are types of property, while the credit accounts are all types of property rights,and the debit accounts, on the left, are increased by debits, (Draws, Assets and Expenses) while the credit accounts, on the right, are increased by crediting. (Principal, Liabilities, Income)- Do you think that helps? Brian ___ 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.