Re: [GNC] Bulk moving transactions

2020-07-01 Thread Michael or Penny Novack
On 7/1/2020 6:30 PM, D. wrote: Of course, once you've edited every transaction to put it into a child account, you could have just changed them all to their proper account altogether, and eliminated the entire account delete set of steps... ??   I wasn't talking about editing ANY transacti

Re: [GNC] Cost Basis Report on Transaction

2020-07-03 Thread Michael or Penny Novack
On 7/2/2020 6:13 AM, gnuc...@runbox.com wrote: I'm evaluating gnuCash for tracking investments. For my taxes I need a report of all stock sales during the year, showing the cost basis. Perhaps even a report of the lots used in a sale. I cannot find any of these on Standard Reports. Am I mi

Re: [GNC] Help required

2020-07-06 Thread Michael or Penny Novack
On 7/6/2020 10:40 AM, David Carlson wrote: This thread was started by a newbie who is still learning how it works. That person doesn't need the extra burden of finding things changing, sometimes for the worse, while still learning. Well I spent my working days in a shop where the motto was "avoi

Re: [GNC] GnuCash list

2020-07-08 Thread Michael or Penny Novack
On 7/8/2020 8:02 AM, Bruce Irving via gnucash-user wrote: From: Robert Heller Most people in recent times are using a webmail client (eg GMail, Yahoo, AOL, Hotmail, etc.), so they are reading E-Mail in a webbrowser, just as they would be reading postings in an actual webforum.  The idea of an "

Re: [GNC] Command Line Report Options

2020-07-18 Thread Michael or Penny Novack
On 7/17/2020 10:50 PM, Robin Chattopadhyay wrote: In the release notes and the help page, the documentation lists 'export-type' as an option and the example cites html as an export type option. Are there any other supported options? I tried 'pdf' and 'PDF' and neither of those worked. You are co

Re: [GNC] Non-profit loan/grant tracking

2020-07-21 Thread Michael or Penny Novack
On 7/21/2020 9:18 AM, Joshua Ginsberg wrote: We have a single bank account. This year we received a cash loan and a grant. Both of them require us to track what expenses the funds specifically went to pay for. I'm unclear of how to best set this up in GnuCash. For grants that don't require tra

Re: [GNC] Accounting for Non-profits

2020-07-24 Thread Michael or Penny Novack
On 7/24/2020 6:05 AM, Fiona MacKinnon wrote: ... possible work around as I am otherwise familiar with the traditional method of bookkeeping used in GnuCash and it is ideal for my needs. Thanks Fiona If you are used to traditional bookkeeping there should be no problem. Simp

Re: [GNC] Accounting for Non-profits

2020-07-24 Thread Michael or Penny Novack
You can also start with a completely blank file (created by default) and then just add in your accounts manually. That seemed faster in my situation, instead of editing most of the supplied accounts. I have ALWAYS done it that way. The CoA of a non-profit organization bears little resemblance

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-25 Thread Michael or Penny Novack
I am going to jump in here because I strongly disagree with a lot of this. I have used gnucash quite successfully with non-profits. But they have different needs.  a) "Petty cash" is NOT "undeposited cash". And that's not what is usually meant by "undeposited cash. Thus NOT the little individual

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffic

2020-07-25 Thread Michael or Penny Novack
One of my nits to pick is the AR module:? if I create an invoice without posting it, I can't find it unless I look at each of my 100+ members.? I'll write an external program to prepare the invoices and keep them in a separate file.? Then I only need to enter it into GNC as they are paid.

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-26 Thread Michael or Penny Novack
On 7/26/2020 11:39 AM, John Ralls wrote: Did nobody read the footnote? The book was published in 1985, long before electronic payments became widely available. No doubt the 2020 edition would say something like "independently documented transfer" with a mention somewhere that that used to mea

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-26 Thread Michael or Penny Novack
Hmm.  Better migrate to a credit union then.  Mine will send checks to an address and they will even put the stamp on the envelope.  There is an option to send to a phone number or email address. Lovely. If you directed a check to my phone number it's inaccessible.  Do you KNOW that phone nu

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-27 Thread Michael or Penny Novack
On 7/27/2020 12:13 PM, Stephen M. Butler wrote: I am able to send along an account ID or Invoice ID and then there is the entire memo field on the check.  I also get an email from the CU (if I request) stating that it has been sent.  I can forward that to the recipient with additional notes. No

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-28 Thread Michael or Penny Novack
On 7/27/2020 4:50 PM, Dale Alspach wrote: I would not put much faith in requiring two signatures. It is unlikely that the bank is actually paying any attention to this requirement. I learned this from a former bank employee who was on the board of a nonprofit I work with. In other words it is an

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-07-29 Thread Michael or Penny Novack
On 7/28/2020 10:23 PM, Dale Alspach wrote: I am not confused. Here is a link to a CPA's site explaining the issue http://www.otcpas.com/advisor-blog/dual-signatures/#:~:text=By%20requiring%20two%20signatures%2C%20the,checks%20to%20a%20fictitious%20company. Dale That depends on the bank. What th

Re: [GNC] Can't find file

2020-07-30 Thread Michael or Penny Novack
On 7/29/2020 8:04 AM, Dan Bilich wrote: Been using Gnucash for years. Tried to open today and got the message that it couldn’t find the file and it opened to a new, blank slate. What do I do to recover? Do you know the name of your data file? If you don't know the name/path, do you at least

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

2020-08-01 Thread Michael or Penny Novack
On 7/31/2020 7:48 PM, doncram wrote: Michael Novack said:  "I did like you said, recounted in the presence of a witness or witnesses, and then and there wrote a personal check for that amount and pocketed the currency. In other words, I was able to REPLACE physical cash so now just checks" But i

Re: [GNC] non-currency liabilities

2020-08-02 Thread Michael or Penny Novack
On 8/2/2020 4:37 AM, David Carlson wrote: I believe there is no restriction to have a positive number of shares of a security. After all, it is common to sell stock short (Against the box) or not. We must not have many "bears" among our gnucash users. I imagine this is how you would have to de

Re: [GNC] non-currency liabilities

2020-08-02 Thread Michael or Penny Novack
On 8/2/2020 8:00 PM, doncram wrote: I am not an expert about how personal financial accounting should be done, where that is different from business accounting... If done that way in GnuCash, then increases (decreases) in value from stock market fluctuations would be

Re: [GNC] help to set up equity sub-accounts opening balances

2020-08-05 Thread Michael or Penny Novack
Here is a case where a little but of the history of double entry bookkeeping might help you. Originally (hundreds of years ago) there was just "assets", "liabilities", and "equity". The other side of the transaction for money coming in or going out was either "liabilities" or "equity". This ha

Re: [GNC] help to set up equity sub-accounts opening balances

2020-08-07 Thread Michael or Penny Novack
On 8/7/2020 9:14 AM, D. via gnucash-user wrote: Marilyn, Part of your problem, I think, is based on a misunderstanding of terminology. You keep referring to these virtual amounts as "Equity" when really they are *Assets*. In the gnucash world, these funds should be placed as Assets accounts. T

Re: [GNC] Crediting Invoice for Minor Underpayment

2020-08-07 Thread Michael or Penny Novack
On 8/4/2020 2:35 PM, Mark Seeba wrote: I think I figured out the correct approach: Create a new invoice for the credit amount and post it. Then hit Pay and select the credit amount and the amount left due. Does this make sense? Do you have an account for "bad debts and forgiven underpayments"?

Re: [GNC] help to set up equity sub-accounts opening balances

2020-08-09 Thread Michael or Penny Novack
On 8/8/2020 11:00 PM, Adrien Monteleone wrote: You don't *need* to close a month or year, though you certainly can if you want to. In the old days of pen and paper, 'closing' was the process of migrating balances from temporary accounts to Equity in preparation of reports. With computers, t

Re: [GNC] GnuCash and Swedish accounting legislation

2020-08-11 Thread Michael or Penny Novack
The fixed date locking should be stronger, ideally requiring a password. The previous year would be locked only when the Treasurer or other authorized person is really finally signing off on all reporting, after performing all necessary closing entries to recognize accruals (see my comment in

Re: [GNC] envelope method, equity sub-accounts, cash vs. hybrid vs. accrual accounting

2020-08-12 Thread Michael or Penny Novack
On 8/11/2020 8:32 PM, doncram wrote: The idea of "envelope method" then is to mirror the model of budgeting and control done by real life envelopes holding the cash allowed to be spent in each budget area. This is an inspiring model/image. The physical model is very visual, very clear... each e

Re: [GNC] envelope method, equity sub-accounts, cash vs. hybrid vs. accrual accounting

2020-08-14 Thread Michael or Penny Novack
It doesn't have to "break double entry", it doesn't require partitioning the actual asset account holding the funds. Those are only issues IF you want to have "envelope budgeting" without extra work when entering transactions. It might help if people wanting envelope budgeting look at our disc

Re: [GNC] Recording Tax Correctly

2020-08-16 Thread Michael or Penny Novack
On 8/16/2020 3:54 AM, Omer Hayat wrote: Hi. We have a 5% VAT charged on all bills and invoices. To the government, we pay the difference. I have setup an 'Input VAT(paid to Vendor)' and 'Output VAT(received from Customers)' accounts under Liabilities, and set them up. These are recording the V

Re: [GNC] Recording Tax Correctly

2020-08-16 Thread Michael or Penny Novack
PS: Yes, as Christopher notes, could place VAT paid as an asset (which it properly is). I was following the set up you were describing instead, placing VAT paid as a contra account. Also sensible, as under normal conditions, the parent VAT is going to have a net credit balance << your business

Re: [GNC] Monthly Payments on posted Liability?

2020-08-24 Thread Michael or Penny Novack
On 8/24/20 11:19 AM, Stan Brown wrote: On 2020-08-24 09:01, Fran_3 via gnucash-user wrote: For a posted liability of say $1,000with an agreement to pay in 10 monthly installments of $100 each.How do you enter those monthly payments and...1 - have the payment applied to the liability Also,

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-08-26 Thread Michael or Penny Novack
On 8/26/2020 7:16 AM, Michael Hendry wrote: I used to run my own small Ltd. company so basic accounting methods, VAT, etc. are not beyond me either. What I want is more on the 'how to run a small PCC accounts with GnuCash' sort of thing. There are some quirks to PCC accounts (I think!):-

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-08-29 Thread Michael or Penny Novack
Well, yes, but the existing paper system is hardly transparent! :-) I'm really only trying to work things out from what has to be on the annual return to the CofE. The restricted and unrestricted funds are at least basically separated by being in separate accounts. If the restricted funds are i

Re: [GNC] Further to restricted/unrestricted funds

2020-08-29 Thread Michael or Penny Novack
On 8/29/2020 6:40 AM, Chris Green wrote: I have been doing some reading around this restricted/unrestricted funds issue. I think in reality we have *no* restricted funds in our PCC. What I *thought* were restricted funds are actually 'designated' funds. I.e. we (the PCC) have made a collection

Re: [GNC] Asset accounts: cost, or value?

2020-09-02 Thread Michael or Penny Novack
On 9/2/2020 8:28 AM, Marcus Winston wrote: OK, Thanks. So the "balance" in the asset account would reflect the cost of the asset, not its value. That's fine, and is what I concluded also. Next question: When I sell the house, I'm adding the costs to sell the house (title insurance, reconveyan

Re: [GNC] Asset accounts: cost, or value?

2020-09-02 Thread Michael or Penny Novack
On 9/2/2020 11:08 AM, D. wrote: Michael, Could you go into more detail about how one would enter, e.g., title insurance in GnuCash so that it would apply to the cost basis of a property? TIA, David Take a simple example. You write a check to pay something that is properly part of the basis:

Re: [GNC] Asset accounts: cost, or value?

2020-09-04 Thread Michael or Penny Novack
On 9/3/2020 7:14 PM, David Cousens wrote: Marcus As a number have people have pointed out you may need to keep the cost basis of your house separate from any adjustments for the estimate of the current value you may apply to calculate your estimated current net worth. You can have your cake and

Re: [GNC] Help - entering opening balances

2020-09-08 Thread Michael or Penny Novack
On 9/8/2020 8:52 AM, Chris Green wrote: I am at the stage of lots of rude words at the moment! :-) I am just starting to try and set up GnuCash for the PCC accounts and I've fallen at the first hurdle. I can't work out how to enter opening balances for the two accounts we have - a current accou

Re: [GNC] Is there an 'easy' way to have a transaction with 'sub-transactions' as it were?

2020-09-09 Thread Michael or Penny Novack
On 9/8/2020 5:25 PM, Adrien Monteleone wrote: Yes, View > Transaction Journal Now all transactions in that register will always show all splits. It is not only helpful when learning GnuCash, but I use it exclusively because I don't want to have to click each transaction to see the splits. Les

Re: [GNC] Be careful with `petty cash'

2020-09-09 Thread Michael or Penny Novack
On 9/8/2020 11:32 PM, Adrien Monteleone wrote: I've seen suggestions in accounting texts (and use myself) an account called 'Undeposited Funds' as a Current Asset. Checks and currency destined to the bank (but not there yet) are recorded here when received. Regards, Adrien Yes, the term "pet

Re: [GNC] Be careful with `petty cash'

2020-09-10 Thread Michael or Penny Novack
I think the best approach is either:- 1 - Record the amounts in their different categories as required, e.g. 'collection' or 'offertory box' and simply record the same paying-in slip number against both transactions. 2 - Have, as you suggest, an intermediate "Undeposited Fund

Re: [GNC] Be careful with `petty cash'

2020-09-10 Thread Michael or Penny Novack
On 9/10/2020 5:29 PM, Adrien Monteleone wrote: I'm not sure what you are referencing by 'paying-in slip'. POSSIBLY something else. For example, there is an annual event at which a "teacup auction" takes place. There is both cash and checks placed in the can when people buy tickets, sometimes

Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Michael or Penny Novack
On 9/11/2020 12:45 PM, Fran_3 via gnucash-user wrote: I'm looking for an easy way list all paid expenses for a defined period. I poked around under Reports and maybe I missed it. How can I do this? Thanks for any help. If you want a report that shows, for a defined time period, the transactions

Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Michael or Penny Novack
On 9/11/2020 5:16 PM, Fran_3 via gnucash-user wrote: How can I limit the report to "Paid Expenses" during the period? Thanks WHAT do you mean? The books are not a "budget". They are a record of transactions that have actually taken place. If you did not pay some expense there should not be

Re: [GNC] Negative attitudes [was: Re: Negative numbers]

2020-09-12 Thread Michael or Penny Novack
ToddAndMargo, I don't know what to conclude from what you are saying. One sentence seems to show you understand that GnuCash only reaches you by lots of people doing lots of things. The next sentence seems to show you having a tremendous sense of entitlement to getting something for nothing,

Re: [GNC] Negative attitudes [was: Re: Negative numbers]

2020-09-13 Thread Michael or Penny Novack
On 9/13/2020 1:37 AM, ToddAndMargo via gnucash-user wrote: Great exposition! I use Fedora in my business.  It is a wonderful example of "Kaisen", meaning constant improvement.  I am totally spoiled by their responsiveness to users, including me.  I presume "someone" is paying them, but I do no

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-09-19 Thread Michael or Penny Novack
The "restricted account" you are referring to is probably a "fund". Monies collected for a specific purpose and meant to be used for that specific purpose only. These are accounts that need to be kept in the Equity section. Actually, there are SEVERAL ways restricted funds may be accounted

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-09-20 Thread Michael or Penny Novack
If one has a lot of separate restricted and/or designated funds it must be very difficult to keep track of them all. And don't forget GRANTS. Those are very much like restricted funds if the money is received ahead of use AND are almost, if not quite as much work, even when in the form of re

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-09-21 Thread Michael or Penny Novack
On 9/20/2020 10:47 PM, doncram wrote: Just to say GnuCash could serve churches and other nonprofits much better if Job Costing were supported.  And relatedly, more churches and other nonprofits could use GnuCash if Job Costing were supported.  Thank you Jacob Oomen for sharing the links to your

Re: [GNC] How to balance correctly a particular transaction which involves debt?

2020-09-21 Thread Michael or Penny Novack
On 9/21/2020 9:37 AM, Daniel Fishman wrote: Hello, Suppose that you go with your friend to a shop, and then a friend remembers that he forgotten his credit card and asks you to pay for his merchandise. He intends to return the money later. You pay in the shop (for example, buy a book) using your

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-09-23 Thread Michael or Penny Novack
On 9/22/2020 11:20 PM, doncram wrote: About invoicing making GnuCash show assets (accounts receivable) when the dues are billed (or pledges receivable), I don't see why that would be much of a problem.  Couldn't that be addressed by your entering a journal entry to zero out the asset balance an

Re: [GNC] Report headings, can one separate the company name from the report name?

2020-10-01 Thread Michael or Penny Novack
Two things: First, you may be not have considered all of the report options. I haven't looked at all gnucsh reports, but the ones that I have allow you to control the "title" of the report. This might be more obvious to folks like me doing books for non-profits << by custom the report titled

Re: [GNC] withholding tax (Liz Dodd)

2020-10-02 Thread Michael or Penny Novack
On 10/2/2020 12:18 AM, Paul W via gnucash-user wrote: Stan, I see what you are saying. Practically I think I need to process the invoice payment twice, first part payment (80) to Accounts Receivable then another payment (20) to Assets: WHT. But I don't seem to have this ability in gnucash b

Re: [GNC] withholding tax

2020-10-02 Thread Michael or Penny Novack
On 10/2/2020 4:17 AM, Paul W via gnucash-user wrote: Thanks Maf, that does seem to work. Shame there's not an automatic way to do this as WHT isn't a tax from Mars! Doing in two transactions simply avoids the complexity of entering a split from the "wrong" account. It's just a little more w

Re: [GNC] 8.1.1. Find Transaction

2020-10-03 Thread Michael or Penny Novack
On 10/2/2020 10:49 PM, David Carlson wrote: ... including (especially, with examples) exactly what regex means to those of us that went to school before that term existed,. ROFLOL in which case you are older than I am and I'm in my mid 70's It's not exactly a new term, dates t

Re: [GNC] 8.1.1. Find Transaction

2020-10-03 Thread Michael or Penny Novack
On 10/3/2020 11:19 AM, David Carlson wrote: We are't dead yet, and a couple of our approximate peers are actively seeking terms in the white house.  One of them having tested positive for Covid, hoping he will recover. I am going to add something. Matching strings using "regular expressions"

Re: [GNC] Standard chart of accounts?

2020-10-04 Thread Michael or Penny Novack
On 10/3/2020 1:09 PM, doncram wrote: Hi Ken Brown, I think that you need what you asked for, a good Chart of Accounts example, which you will implement into a new GnuCash entity. How about the following Chart of Accounts, designed by me just now for a single person in the United States with some

Re: [GNC] Split Transactions

2020-10-04 Thread Michael or Penny Novack
On 10/3/2020 7:01 PM, Norman Jessup wrote: Thanks David, I tried aggregating the two amounts on the asset side and, as you suggest, it resulted in a single entry in the asset register. However, the duplicate entries in the Income register remain. As this is an artefact (bug?) of GnuCash

Re: [GNC] Fwd: Changing report title of the General,Journal; was: Solving printer issues

2020-10-06 Thread Michael or Penny Novack
Might have gotten to actually look at the problem if had been described clearer. Brilliant!  Thanks to all of you for this guidance. I never realized before that ‘export’ will produce an html version. However — I have not yet been able to change the title of the General Journal, not in the Gnu

Re: [GNC] Fwd: Changing report title of the General,Journal; was: Solving printer issues

2020-10-07 Thread Michael or Penny Novack
On 10/7/2020 8:50 AM, Christopher Lam wrote: Usually https://bugs.gnucash.org/ would be the preferred reporting mechanism, but this one will be fixed for 4.3 onwards. I was not (re)reporting a bug clearly already reported. I was apologizing for not earlier confirming what a user reported and

Re: [GNC] Issues with Balance Sheet report in 4.2

2020-10-11 Thread Michael or Penny Novack
First question (before we look deeper) To what level of nesting have you set for this report? We want to make sure you have set that high enough so that the levels of nesting you expect would be shown. I believe the default nesting level is three. So ... confirm for us that you have used Edit

Re: [GNC] Issues with Balance Sheet report in 4.2

2020-10-11 Thread Michael or Penny Novack
On 10/11/2020 11:14 AM, mike823 wrote: I also looked into the "Balance Sheet (eguile)" report as well and while this one does indenting properly and shows all subaccount levels, it does not allow account selection. I think you misunderstood me. a) Start the Balance Sheet report (select it) b)

Re: [GNC] Issues with Balance Sheet report in 4.2

2020-10-11 Thread Michael or Penny Novack
On 10/11/2020 7:13 PM, mike823 wrote: I definitely do not understand what you are trying to say. - Are talking about "Balance Sheet (eguile)" report or "Balance Sheet"? - You are using "nesting" term in context of report options but there is no such option. - "CoA" is an acronim for what ? Th

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Michael or Penny Novack
On 10/15/2020 5:37 AM, Gal Bar Mashiah wrote: I have expense accounts in several currencies, for example: Expenses:Food:USD Expenses:Food:ILS I run the income statement report for 2013 for example, select only Expenses:Food account (and its sub accounts) and select ILS as the currency report. Th

Re: [GNC] Exchange rate of income statement report

2020-10-15 Thread Michael or Penny Novack
On 10/15/2020 7:23 AM, Gal wrote: Michael or Penny Novack wrote Meanwhile, Gal,  please explain something to me. If you wanted dollar amounts converted to shekels as of the date of the initial transaction (frozen as of that date) why entered in dollars rather than shekels? Actually, I'm i

Re: [GNC] Exchange rate of income statement report

2020-10-16 Thread Michael or Penny Novack
On 10/16/2020 7:49 AM, Gal wrote: Assume a user doesn't file any tax report, and is only interested in accurate expense and income reports for personal tracking. Moreover, accurate, means that when a transaction is translated to a different currency, it is always done so at the exchange rate of t

Re: [GNC] Make PDF from reports

2020-10-20 Thread Michael or Penny Novack
On 10/20/2020 12:02 PM, Adrien Monteleone wrote: If I recall correctly, there is are PDF issues on Windows and Mac. You should be able to Export the report as HTML, open with a modern browser and print to paper or PDF from there. You'll need a PDF virtual printer however. Win10 includes one bui

Re: [GNC] Make PDF from reports

2020-10-20 Thread Michael or Penny Novack
For still using Windows 7. Can't you still get LibreOffice for 7?  I'm pretty sure if you have a document open under "Writer" you can export as PDF. The point is, I used to be under Win 7 and used the LibreOffice Suite (instead of MS Office) Michael __

Re: [GNC] Managing UK Gift-Aid

2020-10-29 Thread Michael or Penny Novack
On 10/29/2020 5:18 AM, Chris Green wrote: I am treasurer for a small PCC in the UK. I know there are other similar charity treasurer's hereabouts. How do you handle Gift-Aid in your accounts, or do you not bother at all and simply record the datail of Gift-Aid donations separately for making th

Re: [GNC] Managing UK Gift-Aid

2020-10-31 Thread Michael or Penny Novack
On 10/29/2020 8:36 AM, Michael Hendry wrote: When I took over as Treasurer I inherited a set of spreadsheets for the accounts from my predecessor, including a separate one for Gift Aid. I’m not keen on spreadsheets for bookkeeping, and set up a parallel set of books in GnuCash. At first I th

Re: [GNC] Managing UK Gift-Aid

2020-10-31 Thread Michael or Penny Novack
What you can claim Your GASDS claim cannot be more than 10 times your Gift Aid claim. For example, you can claim on £1,000 worth of donations through GASDS if you’ve received £100 of Gift Aid donations in the same tax year. You can claim on donations that are eligible for Gift Aid, but not me

Re: [GNC] Managing UK Gift-Aid

2020-10-31 Thread Michael or Penny Novack
I'm not aware of any church that has a membership fee, and I'd be amazed to learn of one. In the case of tithing (which is expected in only a very small minority of churches) I imagine it would be cast as a donation, and not as membership. Our common law holds a membership fee to be contract

Re: [GNC] Cannot Obtain Lock error?

2020-11-07 Thread Michael or Penny Novack
No to mention that there are very often (nearly always?) at least three 'latest versions' for Open Source software:- The latest stable, general release, version The latest beta version, for 'ordinary users' to test, or even use if it works well for them The latest 'cutting

Re: [GNC] Cannot Obtain Lock error?

2020-11-07 Thread Michael or Penny Novack
On 11/7/2020 9:32 AM, Chris Green wrote: Yes, I know (and mainly agree with) all that, I am a fully fledged (well, ancient) chartered software engineer with lots of letters both before and after my name if necessary. I was just trying to aim my comment at non-computer people and, anyway, it is

Re: [GNC] Split Transactions

2020-11-15 Thread Michael or Penny Novack
On 11/14/2020 8:37 PM, David Carlson wrote: Nathan, The first time it can be a little tricky. First select one of the transaction view options that will show the splits, then practice using the tab key to move the curser from box to box. For practice you can enter garbage text because it is ea

Re: [GNC] How to treat accommodation security deposit

2020-11-22 Thread Michael or Penny Novack
On 11/22/2020 3:29 AM, Tony Vanson wrote: I anticipate renting a property for 1 month and will pay the rental up front plus a security deposit amount which will be returned at the finish of the rental period. I am totally in the dark how to approach this. Do I need some kind of split? The renta

Re: [GNC] entry point error after recent automatic windows 10 update

2020-11-26 Thread Michael or Penny Novack
On 11/25/2020 9:25 PM, laurel hargis wrote: Perhaps the Windows 10 update didn’t cause the problem. Maybe coincidence. but still don’t know how to find my files or work on them. That’s why I’m concerned about losing 10 months of work although I’m told the files are in there somewhere.

Re: [GNC] Help

2020-12-21 Thread Michael or Penny Novack
On 12/21/2020 11:43 AM, Brian Gardner wrote: I have just had the system installed for me and I have managed to get all the accounts that I have used in my financial statements into the file. Unfortunately I read about the installing of opening balances after I had done everything thinking that

Re: [GNC] Rounding & formulas

2020-12-22 Thread Michael or Penny Novack
Thomas Another perspective on this is that in practice what rounding procedure a bank or other external body may apply may depend on any legislative requirements (usually by taxation bodies) and their internal accounting policies and these are not under GnuCash's control and may also vary betw

Re: [GNC] Rounding & formulas

2020-12-22 Thread Michael or Penny Novack
On 12/22/2020 5:17 PM, Liz wrote: I think that we have taken a peek down a rabbit hole and found enormous complexity past the entrance. Liz For us pros it gets far worse than that. In my working days often had to compute the "fuzz" value to use in comparisons because of "rounding errors" wh

Re: [GNC] {GNC} How secure is Gnu-Cash? Good enough for a credit union?

2020-12-28 Thread Michael or Penny Novack
On 12/28/2020 7:01 PM, Edward Bainton wrote: Can anyone give a view on whether Gnucash is suitable for a very small credit union? How would easily can fraud be detected? If not easily, could it be paired with, say, some kind of blockchain backup system so as to make fraud detectable? Thanks,

Re: [GNC] New user account setup question

2020-12-29 Thread Michael or Penny Novack
On 12/29/2020 2:17 PM, Charles Hudson wrote: First post: Greetings to all and thanks for your help. Because I have never used GNUCASH before, am unfamiliar with its reporting capabilities and am only conversant with basic accounting principles, I have a couple of questions about how to set up th

Re: [GNC] Set up

2021-01-15 Thread Michael or Penny Novack
Most people might prefer to put files they create in a "documents" directory. /In other words, you might under documents create a folder with a name like gnucash-data and use THAT as a place to store your gnucash data./ / / /If all the files you create are somewhere in the documents folder, t

Re: [GNC] Changing end date on a saved report config option

2021-01-15 Thread Michael or Penny Novack
No way for us to know what you are doing wrong, but it SHOULD work. You run the report << wrong end date shows up >>  You then use Edit +> Report Options and then the "general" tab. You should see there a way to specify start and end dates. If you were doing it this way, remember you have to

Re: [GNC] UK specific: MTD - Making Tax Digital

2021-01-18 Thread Michael or Penny Novack
Good points. I have bridge software already working and approved by HMRC for use. My initial thought was to have a report in GnuCash that generated the VAT report for a period. There would then be a menu option to submit VAT. This menu option would generate a csv file containing the VAT values

Re: [GNC] Requesting a trial balance as of a specified date

2021-01-23 Thread Michael or Penny Novack
Oddly, when I just ask for the trial balance (from Reports), I get the trial balance as of 12/31/1969. I'd have thought the default would be the date of the last transaction. Not specific to gnucash. Whenever you see an unexpected date of 12/31/1969 be aware that the most likely reason is "n

Re: [GNC] The man who saw everything twice....

2021-01-24 Thread Michael or Penny Novack
On 1/24/2021 12:26 AM, Peter S. Shenkin wrote: Gnucash 4.3 on a mac. Why do Gnucash balance sheets print account and subaccount totals twice: once at the beginning of each such account and again at the end? It adds a large number of extra lines and no new information, and balance-sheet examples

Re: [GNC] The man who saw everything twice....

2021-01-24 Thread Michael or Penny Novack
That's the right place. Make the selection that you want. For example, if like me you want the total afterwards, you want (for "Parent account balances" to be "do not show" and for "parent account subtotal" you want "show subtotals". Michael * Parent account balances o Subtotal (I

Re: [GNC] multiple attachments

2021-01-25 Thread Michael or Penny Novack
On 1/25/2021 3:39 PM, gnu Gord wrote: Most of the files I would want to attach will be pdf files so I could, theoretically, use pdftk to combine them into one file but that's not really the way I'd prefer. I'm able to attach one file but not a second or third file, ETC. What are you trying to

Re: [GNC] Changing multiple transactions

2021-02-01 Thread Michael or Penny Novack
On 1/31/2021 5:30 PM, Stephen M. Butler wrote: To err is human.  It requires a computer to really foul things up -- especially if you ask the DBA (me in a former life) to fix a few million transactions with "this script"). As somebody who did this sort of thing in my working days, I will se

Re: [GNC] Scheduled Transaction Mystery?

2021-02-05 Thread Michael or Penny Novack
On 2/5/2021 4:54 PM, Jack Slater wrote: Interesting. Sure seems like a bug to me. But that's why good to post HERE (in the users' help list). The FIRST step is to confirm that there are other users who have scheduled transactions and whether they have seen this behavior. If not, if schedule

Re: [GNC] Frustration

2021-02-09 Thread Michael or Penny Novack
On 2/8/2021 5:37 PM, David Cousens wrote: If you do need to create a new file for some reason, use the File->Export->Export Account Tree to CSV to export your account structure, the Fuile->NewFile to open a new file.In the setup wizard you cannot proceed if you Clear All but if you select the S

Re: [GNC] Asset vs Equity accounts?

2021-02-15 Thread Michael or Penny Novack
On 2/15/2021 5:17 PM, Adrien Monteleone wrote: (technically, Income & Expenses are 'temporary' Equity accounts, but GnuCash gives them their own 'top-level' with Assets, Equity & Liabilities. In the pen&paper days, you closed these out at the end of the year to Retained Earnings, also an Equ

Re: [GNC] Asset vs Equity accounts?

2021-02-16 Thread Michael or Penny Novack
That's how I learned it at Ernst & Ernst when I worked there. (I attended the firm's basic accounting course for non-accountants.) I believe our textbook called the special account Income Summary rather than Profit and loss, but that's a minor detail. A very minor detail, especially because what

Re: [GNC] Expense Over Time report

2021-02-20 Thread Michael or Penny Novack
That was an excellent answer, and explains clearly a big reason why users should strive to limit their transactions to leaf nodes in the account hierarchy. (My own books include numerous violations of this premise, BTW) Gnucash has always allowed users to put transactions in intermediate leve

Re: [GNC] Moving log location

2021-02-28 Thread Michael or Penny Novack
You have been given a solution. Create a folder, aka directory, where you would ordinarily put data and move your gnucash file there. Gnucash will create those log files in the same directory that the data file is in. But that you have this problem indicates an underlying issue understanding w

Re: [GNC] Capital Gains

2021-03-03 Thread Michael or Penny Novack
On 3/3/2021 3:21 PM, gnu Gord wrote:nclude BTW, hello from Canada, I'm just across that little bit of water from you on the west coast of Canada, I'll wave my hand out the window... I'm sure you'll see it!! 😉😀 Well actually, in a couple of places, there is a bit of the US on the Canadian side

Re: [GNC] Tracking the same asset or asset type held at multiple brokerages

2021-03-11 Thread Michael or Penny Novack
So, I guess I have two questions: (1) Is there a way to generate balance sheets that show totals per brokerage as well as totals per asset type, given the same account structure? (2) If the above is not possible, which account structure have you found to be most natural / useful in your experi

Re: [GNC] Reports using accounts

2021-03-12 Thread Michael or Penny Novack
On 3/12/2021 3:27 PM, Chuck wrote: I Want a report showing only selected accounts, Seems like Transaction Report would work but can't find how to access specific accounts. I seem to be missing something somewhere. Maybe I am just looking in the wrong place or the wrong report type?. HELP,

Re: [GNC] Error on report over time

2021-03-15 Thread Michael or Penny Novack
On 3/15/2021 11:48 AM, Christopher Lam wrote: This is a strange report indeed. May I suggest a bug report at Bugzilla. On Mon, 15 Mar 2021, 3:00 am , wrote: Hello, My "Expenses over time" report and also the "Income over time" report from last year (2020) is showing November 2019 instead of

Re: [GNC] Billable Expenses carried over into the new year

2021-03-17 Thread Michael or Penny Novack
On 3/17/2021 1:04 PM, Andrew via gnucash-user wrote: Small business owner who is definitely not a trained accountant here, so please bear with me if none of this makes sense. Our business regularly incurs travel expenses while performing work for clients, which we invoice to the client with no

Re: [GNC] How to code merchant refunds

2021-03-24 Thread Michael or Penny Novack
On 3/24/2021 9:47 AM, Mike via gnucash-user wrote: How should merchant refunds be coded? Are they income? Mike White ___ I would think better to consider a reduction of the expense. If you treated as income, equivalent to an overstatement of both

<    1   2   3   4   5   6   7   8   9   10   >