Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher
On Wed, 4 May 2022 03:25:25 + Peter Wu wrote: > 1. Beside the mailing-list. Does anyone know a forum where we can > ask and discuss issues? I feel it maybe easier to > search/discuss/answer questions than a mailing list. This mailing list leads to the expertise, or the brains trust of Gnucash. You can also use IRC if you prefer. Liz ___ 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] default local currency
On Tue, 10 May 2022 12:17:22 +0800 "David Long" wrote: > Hi, > > > > Actually, I tried a re-install, thinking I had missed a trick in the > installation process, but exactly the same. > > > > Regards > > > > David David, could you advise your OS, because this may offer a different way of altering your locale settings. Liz ___ 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] Language settings
On Mon, 13 Jun 2022 17:36:07 -0500 wrote: > How do I get my GnuCash back to Spanish? Version 4.6 installed Spanish > automatically but it recently switched to English. > > > > Third time to ask for help with this question. > > > > Thanks, > > Roger Gnucash runs according to your system settings. So if you set your computer to a language, that is what you should see. This wiki page gives some information on how to change for Windows users https://wiki.gnucash.org/wiki/Locale_Settings#Changing_the_Language_on_Windows Liz ___ 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] rookie question Imbalance-USD
On Sun, 19 Jun 2022 10:57:19 -0400 "David T. via gnucash-user" wrote: > I made my comment from that perspective; your snarky comment just > underscores for me the kind of person YOU are. Go stuff yourself. > > David T. David, As the moderator, I don't want to see such words in the archives. You put in lots of good information, please refrain from those sorts of comments. Liz ___ 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] Copy/Paste Transaction Issue
On Fri, 19 Aug 2022 06:06:18 + Gyle McCollam wrote: > Liz, > Just wanted to mention that if you post to cash ledger and meant to > post to a card, instead of cutting and pasting, in the cash ledger, > you could click on the transaction and then the split icon. Then > click on the line for the cash ledger. You will then have the down > arrow for the account selection. You can then select the appropriate > card account and it will move the transaction and your debits and > credits will be correct. This may sound more involved, but it is a > lot easier than it sounds and you don't have to move between accounts > when cutting and pasting. I am doing that. But I wanted to say that the copy/paste transaction item is problematic. ___ 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] Fixing incorrect Vendor for invoices
On Sat, 27 Aug 2022 18:13:29 + Eric Hammond wrote: > Hi Derek, > > So this is a "hidden" feature! > On the unposted invoice, Billing Information panel, the Customer > field has an "Edit..." button, which to me means I can select the > customer. Instead, it only allows altering the Customer information. > > Currently the proper way is to go to the top GnuCash ribbon and > select "Edit Invoice" which then allows the proper "Customer ... > Select" option. > > This is very non-intuitive: I can't think of any reason I would want > to edit the basic Customer information from an invoice. Possibly a > fix for a later release? > > Thanks for your help, > Eric > I had tried to alter an invoice to a different customer and found myself with a similar problem. Now I have all of that data under one customer and a customer entry now called "Reuse me" for next time I have a new customer. I see Derek said its by design, but it caught me too. I was not aware that the menu entry "Edit Invoice" had different powers to choosing "View/Edit Invoice" from a search panel. Liz ___ 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] Paying invoices from the edit invoice screen
Background Debian 11 Gnucash 4.11 Workflow I use the business features to note income which is invoiced through another program. I copy invoice numbers and amounts into a Gnucash invoice so I keep track of my income through Gnucash. This money comes frequently (which is a ‘good thing’) and sometimes I get behind in my invoicing. Then I can be doing the invoice when I already have the money in the bank account, and can choose to “pay invoice” from the dropdown menu for post or unpost the invoice. Problem I had noticed money not arriving in Gnucash’ data for the bank account when I pay the invoice from that dropdown menu. The customer report showed the money had been paid, but the bank account didn’t show the deposit. Friday night I spent some time posting, unposting, paying and unpaying the same invoices until I opened the relevant split in ‘Accounts Receivable’ and found that the money had gone to the Liabilities top level account. This account has no entries but I have not marked ‘placeholder’. Question Why is the money in Liabilities? The ‘Process Payments’ child window is defaulting to ‘Liabilities’ when I have never used this. It used to default to ‘Assets > Bank Account’, where the money has been deposited. How can I stop this occurring? Liz ___ 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] Can I export a list of vendors and customers?
On Fri, 18 Nov 2022 14:58:56 -0800 Cam Ellison wrote: > On 2022-11-18 13:55, Adrien Monteleone wrote: > > Unfortunately no. > > > > Regards, > > Adrien > > > > On 11/18/22 12:11 PM, Dr. David Kirkby wrote: > >> Is it possible to export the customers as a .csv file in a > >> database, and also I'd like to export the vendors. There are no > >> transactions with these > >> yet. > > > > > If you store your transactions in a database instead of the standard > flat file, it's actually quite straightforward, especially with a > web-based database manager. Trying to work from the command line may > be a little more complicated. > > Cheers > > Cam > You could save once only in a suitable database format to get the data, then immediately save in compressed xml again if you don't want to use the database again. Liz ___ 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] How can I enter all fixed assets?
On Wed, 30 Nov 2022 01:18:00 + "Dr. David Kirkby" wrote: > It would be a bit tedious to create accounts for every item > individually > > Assets -> Test equipment -> VNA > Assets -> Test equipment -> Signal generator > Assets -> Test equipment -> Frequency counter > > and set each to have an appropriate opening balance. > That's what I do, then check the depreciation tables and then enter a part year, and then annual depreciation entries until the value is zero, many years ahead, and I don't look at that again. Reporting can then pull the end of financial year value for the appropriate year. Liz ___ 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] Net Worth Barchart
Gnucash Version: 4.12 Build ID: 4.12+(2022-09-24) Here is a screenshot of my Net Worth Barchart. I have checked that Assets are type "Assets" and Liabilities are type "Liabilities" Can someone explain to me why or how my Net Worth is greater than my Assets despite the existence of Liabilities? I have removed the actual values, they do not materially affect the question. Liz ___ 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] Net Worth Barchart
On Tue, 6 Dec 2022 15:40:06 +1100 Chris Grinton wrote: > The charts suggest that you have *negative* liabilities. That is, > while the underlying accounts may have a type of "Liability", the net > balance of these accounts is negative, so are effectively an asset. > > For "normal" positive liabilities, the red bars in the chart would be > above the $0 line as per the attached screenshot. > > Chris I accept that there is likely a logical fault in my account setup. I'm not sure how or where, certainly when I pay my tax out of the bank account my liability for paying tax goes down. So at the end of the month I enter a transaction by scheduled transaction to list my wages, tax and super payments. That transaction results in an increase in my Tax liability account, which when I pay up a few weeks later, the liability decreases. But what I have done, which I'm sure is my problem, is I haven't got the tax payments going to the correct logical place but recursively I have hurriedly filed them under tax liabilities. So my liabilities in my books are increasing regularly instead of being zeroed. This payment is the amount which the tax people tell me I'm going to pay to account for my company tax. They ask for 4 payments each year, and then the accountant sorts out annually what else I have to pay. So I think it comes to What are appropriate splits for the prepayment of my company tax? One side is tax liabilities, and the other I can't work out. No use Michael telling me that I need to decide what I would do on paper, I'm lost. Liz ___ 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] Net Worth Barchart
On Tue, 6 Dec 2022 17:30:35 +1100 Geoff wrote: > Hi Liz > > I think the other side of that liability entry should be something > like "Expenses:Company Tax". > > Regards > > Geoff > = > Thanks for that. A bit of rearranging and now the Net Worth barchart looks a bit more logical. Liz ___ 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] Net Worth Barchart
On Tue, 6 Dec 2022 00:57:44 -0600 Adrien Monteleone wrote: > Liz, > > I just ran the chart for myself and indeed, it appears your > Liabilities are backwards. That is, if you owe money, they should > have a Credit balance, but yours show as Debit balance. (The *normal* > balance of a Liability account is Credit, not Debit) > > What is your preference setting for Accounts > Reversed Balanced > Accounts? > > If it is "none" or "Income & Expense" then your Liability accounts > will show as negative amounts in the Accounts tab if they are a > Credit balance. > > If it is "Credit accounts" then they will show as positive on the CoA. > > If your balances are opposite of that, then your balances are > reversed. (they are 'contra balances' from what is normally expected) > > - > > As to your specific situational question: > > I'm not real clear on your SX template. Can you provide it for > clarification? (no need for amounts, It's just to clear up which > splits you have as Debits & Credits) > > From what I gather, this is a transaction to record money you pay as > wages (to yourself or others), the liability for taxes on those > wages, and super (??) payments. (not sure what that last part is) > > I'm not quite understanding why that is all in one transaction. But > I'll take a guess, maybe my below examples will be roughly correct... > > > > 1. Payments of wages by a company to employees would simplistically > be something like: > > Dr. Expenses:Labor >Cr. Cash > > > > 2. A (likely) separate transaction would record payroll tax liability > such as: > > Dr. Expenses:Payroll Taxes >Cr. Liabilities:Payroll Taxes Due > > (arguably, you can put this all in one transaction) > > > > 3. Then when you make the actual payment: > > Dr. Liabilities:Payroll Taxes Due >Cr. Cash > > Which reduces the previous liability incurred and recorded, by the > amount of your payment. > > You'd repeat that second transaction for any adjustments you are > advised to make as you note, and then zero it out with another > payment. (or otherwise your 4th Quarter payment is simply larger) > > - > > If the situation is concerning something like a 'self-employed' > status and you're making quarterly estimated income tax payments, the > treatment would generally be similar, just different terminology > and/or account names. > > - > > Now, in the case (which it appears you are dealing with) that you are > paying that tax liability at the same time as wages are disbursed, > the treatment is similar save that you can record the payment all at > once and *maybe* skip the intermediary step of 'Taxes Due' splits: > > Dr. Expenses:Labor > Dr. Expenses:Payroll Taxes >Cr. Cash > > You would still record the Liability of Taxes Due when you are > provided the adjustment you need to make, and then zero it out with > the final payment. > > However, I'd bet good practice would be to record those Liability > splits regardless, just to show a trail that they were incurred, and > then covered, thus: > > Dr. Expenses:Labor100 > Dr. Liabilities:Payroll Taxes Due 10 > Dr. Expenses:Payroll Taxes 10 >Cr. Liabilities:Payroll Taxes Due 10 >Cr. Cash 110 > > (the Credit to Cash being equal to the first two Debits and splits 3 > & 4 must be also equal to each other) > > *Hopefully* the three middle splits are all equal, but if the > Liability as estimated is not fully paid for, or overpaid, the Debit > to the 'Due' account (split #2) would be less or more accordingly. > > > Regards, > Adrien > > p.s.—that's how it would look on paper! > Thanks Adrien No I didn't have any reversed balance accounts set and it wasn't the Payroll tax, that was OK. 'Super' is the standard way of pronouncing 'Superannuation' here, and that is retirement savings in plain English. The image is the three monthly accounting for GST and company tax prepayment (PAYG) and the monthly payroll tax payment. Liabilities: Tax Liabilities is the same value as Expenses: Salaries : tax payments Expenses:Company Tax is after Geoff put me straight Part of my problem was calling everything "Tax" instead of being more specific. Now if I rename the Expenses:Salaries:Tax payments to Ex:S:Payroll Tax that could help the next lot of confusion. For those who wonder why I have so many blanks in a scheduled transaction, every three months I do some computation to fill in the blanks. A prepared template means I don't miss any and claim everything they owe me. Liz ___ 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 Import troubles
On Wed, 14 Dec 2022 22:26:40 + (UTC) Steve Silva via gnucash-user wrote: > Hi All, > Thanks a lot for your input. Based on your observations, I really > don't think I am going to make gnucash work for me, I have nearly 30 > years worth of QIF data files and it seems like this odd double entry > method is something I can't control, nor can I go back through 30 > years of data and try to correct it. Trying to get away from quicken > sure is a chore and I am not going to pay for their program every > year. I appreciated your time. Steve You are welcome. If you feel you want a program closer to Quicken, indeed look for one. We don't want to force you in any way. Liz ___ 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] Reconciling PayPal
On Thu, 15 Dec 2022 09:45:15 +0300 "David T. via gnucash-user" wrote: > At paypal.com, click the Activity tab, then click the download icon > at the top right. This takes you to a hidden area that includes a tab > for Taxes and Statements. At least, that's what I see on my machine. > > David T. I followed those instructions. To see the balance you can only have csv export. https://imgur.com/jPP5Fol.png is the screenshot with the sellers names redacted Liz ___ 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] Reconciling PayPal
On Thu, 15 Dec 2022 09:42:13 + "Dr. David Kirkby" wrote: > It’s annoying that the sellers names are not shown, as here in the UK > it’s a legal requirement to have that information if one is running a > limited liability company. Also the buyers name, unless one is > running a retail store. The sellers' names came from Paypal. I redacted them. ___ 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] Bank account reconciled, will this change screw things up?
On Fri, 30 Dec 2022 23:54:05 + "Dr. David Kirkby" wrote: > I think that I am in a minority here using them. They seem to make > things more complicated. I just hope that the benefits outweigh the > complications. > > Dave. I use them to create invoices and check that I have been paid but not to pay money out. Just going back to the data entry error, you typed 'P' and got 'payroll'. You can make sure that all your accounts have fairly unique first two letter combinations, so 'Pa' would be Payroll and 'Po' Postage. Then typing 2 letters should get the correct account, or you may decide to type three letters as a habit. Liz ___ 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] Entry of unknown transaction
On Mon, 6 Feb 2023 00:16:01 -0600 Jeff wrote: > Easiest example that I can remember off the top of my head is, my > wife recently wrote a check from her business account (her weeks > wages) and deposited it directly into our personal account. The OFX > import, and statement, from our bank show it but there is no matching > transaction in the business account. Our statement has an image of > the check plain as day but there is no match, period, in her business > account statement(s). And what really has me bumfuzzled is both sets > of books are reconciled per their respective statements. And it's > not just one transaction involved, there are multiples. That check > did not bounce, it just seemingly like magic appeared in our account > out of thin air. Magic money. > > > For now I have the check recorded as a deposit to our account and > withdrawal from Imbalance-USD. Just wanted to get your input on if > that is the best way to handle transactions like that. Thanks for that, now I have understood. You are depending on the bank's version of your account(s) to maintain your view of your accounts. Your view is of course far more up to date, because you know that the money was transferred from X to Y. These are personal choices on how you maintain your accounts, nothing is right nor wrong. I had initially thought that you had made an entry in Gnucash and that entry had lost one side of the transaction. Cheques (checks to you) have multiple delays in processing and data entry in any bank's procedures. Personally my wages go by direct transfer from business to personal, on a regular schedule booked online with my bank. Liz ___ 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] Blank entry in my check register -- can't be removed
On Mon, 3 May 2021 18:29:09 -0500 (CDT) randix wrote: > ignore my question, the moment I pressed the button to post my > question yesterday afternoon (Sunday), i found the problem (me). Too > bad it took a day (late on Monday) for my message to appear on this > site, otherwise i would have immediately replied to it for it to be > ignored or deleted. > > > > -- > Sent from: > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ Firstly When something happens that finally is found to be user error, we still need to share, because it helps the next person who has the same problem. Secondly Your messages do not routinely appear on the /Mailing List/ after you post, because you are not subscribed to the mailing list. They wait for the moderator, which is me. You choose to view the Nabble version of the mailing list, where it is presented like a forum. Lastly Posts cannot be deleted. Email once sent, is there and somewhere for ever. A note to say that you had quickly found the problem is fine. Liz ___ 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] Cut/paste between databases
On Wed, 5 May 2021 13:40:13 -0600 Paul Kinzelman wrote: > I'm running gnucash 4.5 > > I've got two gnucash databases (personal and business) and I > accidentally entered a charge into one instead of the other. So I > tried cut from one and paste into the other and it didn't work. > > When I pasted, I got only the Description got pasted, and I filled in > the rest > of the transaction manually, but I couldn't get it to enter. The > 'Enter' key did nothing and the transaction still stayed open. > > I had to cancel the transaction and enter the whole thing by hand and > it worked. > > It'd not a big deal to get it fixed, or maybe copy/paste isn't > supposed to work between > databases? > I agree, it doesn't work, and I haven't tried to do it for a long time. Liz ___ 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] Combine user accounts
On Thu, 29 Jul 2021 11:04:18 -0400 nonno wrote: > I initially setup Gnucash, about a year ago, with my wife having a > set of accounts and my having a set of accounts. For example, when I > go into Gnucash I open the file "personal.me.gnucash". When my wife > goes into Gnucash she opens the file "personal.wife.gnucash". I did > not realize at the time that we have some accounts that we need to > share. For example, we would like to have doctor expenses as an > account where we can both add items. Actually, it would have been > better if we could open the same file and have all of our accounts > shared. Is there any way that I can combine the files > "personal.me.gnucash" and "personal.wife.gnucash" into one file > perhaps called "personal.us.gnucash" so that we can share all of our > accounts? I wondered whether you should combine your accounts. Perhaps you need a third set of joint accounts. There are philosophical reasons to keep separate accounts. Liz ___ 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] Problems setting up first OFX transaction download
On Wed, 29 Sep 2021 14:25:54 -0600 "David Ellis" wrote: > get anywhere with her either. I kept getting the error that there > were no new transactions to download since the last one, which was 3 > weeks and 29 transactions ago. Am I going to just have to download > CSV monthly and import to gnu or can I actually get OFX to work? > Thanks, David I had a similar problem as my bank did not follow the OFX standard and reused the same numbers for the transactions. Hand editing the OFX file was successful, changing the numbers to previously unused ones. Have a look at the two files and see if that helps. Liz ___ 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] Updating from v 2.6.16.
On Thu, 04 Nov 2021 20:58:09 + "Mike Stillingfleet" wrote: > My question is can I install all 3 versions at the same time so that > I can migrate and check the integrity before moving forward whilst > ensuring that I still have a viable system in 2.6.16. > > If so how would I do the install. I use Windows 10. Can Mike do this with flatpak versions? Liz ___ 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] An automated depreciation calculator would be really helpful.
On Thu, 9 Dec 2021 00:34:04 + "Dr. David Kirkby" wrote: > So each time an asset is purchased, one needs to start depreciating > it from then. It's not true to say this is just done once per year. My scheme is to do all the calculations shortly after purchase, until I get to zero. I'm not sure whether this is the same as my accountant's calculations. So I enter all the transactions, each for a different year and I never have to look up again whether it was a 5% or a 30% or a 100% depreciation schedule. I can see an advantage to a calculation scheme in software to do it for me. Liz ___ 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] Dependency on AqBanking data (gnucash files referencing NUM in .aqbanking/settings6/accounts/$NUM)
On Tue, 21 Dec 2021 17:13:58 - "Fred Bone" wrote: > On 21 December 2021 at 10:48, Justin said: > > > I hadn't received "[GNC]" stamped copy. I just checked my > > subscription options, and I am supposed to be receiving a copy of > > mail sent to the list. Odd. I turned on ack emails for next time. > > > > Why odd? You're using Gmail. This is expected behaviour. > > Fred's correct, the point at which you lose the mail is Gmail. If you check in your "Allmail" you could find them there. Liz ___ 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] GnuCash Dark Theme Needed
On Tue, 21 Dec 2021 21:04:44 + S S wrote: > I apologize if my formatting is not appropriate to the list as I > can't find anything about how to format posts to the list. My problem > right now is that I downloaded GnuCash 4.9 and I can't read anything > in the software as it is not honoring/inheriting/adopting Windows 10 > High Contrast Dark theme settings properly. Even if I try to invert > the colors manually, it is not displaying correctly and the text is > upscaling so poorly it is illegible. For instance, in HomeBank, > there's an Edit > Preferences option with subset "Interface" that has > the options to "override" GTK font to increase the text size and > there is a clear option for "Dark theme." These two options make that > software accessible to me. Is there anything like this in GnuCash? > Are there any other legally blind or low vision users of GnuCash who > might be able to help with how they achieved readable text to use the > software? > > Thanks Very Much, > Arc Arc, your email suggests to me that you have impaired vision. If you (or someone else) makes a suitable css file for Gnucash for people with impaired vision, it would be good to share on the wiki. Liz ___ 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 can I fudge a quotation in GnuCash and convert it to invoice if accepted?
On Wed, 29 Dec 2021 13:00:30 + "Dr. David Kirkby" wrote: > If the invoice can not be deleted before posting, that would probably > mean it is unsuitable for use in the UK, as I believe invoice numbers > have to be created sequentially. One should *not* have invoice > numbers of 1, 2, 4, 7 etc. Some Eastern European jurisdictions have some rules on this too, and I think they have been discussed many years back. Perhaps Slovenia was one such place. I was of course wondering if the sequence 1, 2, 3, 5, 8, 13 etc would be acceptable? Invoice numbers in Gnucash are sequential in a legalistic way, it is simply incremented. Not every number results in an invoice to be paid, but that is (to me) analogous to cancelling a cheque, you had that one, but never spent it so its number doesn't appear in a statement. I make invoices for items which are being invoiced through a subsidiary program, where my Gnucash invoices represent a total for a time period, because it makes accounting for the income easier. Only myself and my accountant will ever see the evidence of those invoices. Each uses a number in my sequence, and if the ATO comes calling, I can demonstrate that I haven't hidden my income, which is of course all they are worried about. Liz ___ 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] A repository for user-contributed files
On Tue, 4 Jan 2022 09:48:52 + "Dr. David Kirkby" wrote: > I think there’s a good argument for either > a) Stopping the digest mode OR > b) Insisting that if people want to reply to something that they see > in the digest, they reply to the archive - assuming that maintains > the thread. > > In this day and age, people the bandwidth used by emails is a small > fraction of the overall bandwidth people have. People can set up > filters so that GnuCash emails go there. Then they scan the titles > and see if things interest them. Of the 2186 email accounts subscribed to Gnucash-user, 198 use the digest mode. It will continue to be available Liz, with moderator hat. ___ 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] gnucash-user Digest, Vol 226, Issue 48
On Tue, 18 Jan 2022 14:17:10 -0800 Heide Wang wrote: > after I recorded the split transaction, the furniture account shows > 250.00 but did not show it is for a chair. Did I do something wrong? > why on the split transaction it shows a chair but not on the > furniture account ledge? I think you have put the "chair" on the notes for the payment to the credit card company, rather than on the note in the split for the furniture. The long answer is to make the credit card account another account in Gnucash and enter the two transactions separately into the credit card account, then pay the credit card from the cheque account. Liz ___ 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] Split transaction
On Fri, 21 Jan 2022 21:16:35 -0800 "Stephen M. Butler" wrote: > Heidi, > > Also, this sounds like a credit card being used for several purchases > throughout the month. In which case it is better to record the > individual purchases as they occur. Or, download the individual > lines to import. > > In that case, you will have a Liability:Credit Card:nameofcc account > against which all the transactions will post with the other side of > the post (the other split) being the relevant expense account. > > When you pay the credit card off, you record the payment against the > checking account on the one side and the Liability account on the > other. > > Otherwise, if you have a lot of purchases throughout the month there > would be one humongous transaction with gobs of splits and you would > lose the date for each purchase. This is the best way to proceed, once you have followed David Cousen's suggestion and read the tutorial and concepts guide. Liz ___ 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 to properly import a csv with the correct settings.
On Thu, 27 Jan 2022 22:41:41 -0500 Glenn Fowler wrote: > It is. > > FYI the list archives are here: > https://lists.gnucash.org/pipermail/gnucash-user/ > > You'll see this thread in January 2022. Anything on the list gets > sent to everyone subscribed to it. > > > On Thu, Jan 27, 2022 at 10:30 PM W Velishek > wrote: > > > Can anyone tell me if my post to this mailing list is showing up? > The disconnect here is seen by all users of gmail. Gmail decides, on your behalf, that you don't need to see your posts to a mailing list. Gmail just puts them in "Allmail". You can either check the Allmail directory, or the Gnucash archives to find your post. Liz ___ 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] credit card minimum payment due
On Fri, 28 Jan 2022 14:23:41 -0600 Adrien Monteleone wrote: > While formulas and variables are possible with Scheduled > Transactions, unfortunately, they can't grab the current account > balance. (and there are no 'if:then' logic functions possible anyway, > just straight math) > > But you can choose to schedule the payment regardless of the balance, > but set it as a reminder rather than auto-create. You can then > preview and approve the transaction to be created if it is needed. > > Regards, > Adrien I just put in an amount in the scheduled transaction, then set it be checked before posting, and then update the amount to the actual charge nvolved. In my case it is a purchase on Friday night - sometimes the purchase is not made, so I delete the transaction, and other times I edit it to reflect the actual purchase. Liz ___ 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] Canadian Mortgage
On Sun, 30 Jan 2022 21:40:37 -0500 Al Maloney wrote: > Thanks. > What you say about formulae and bank practice makes sense to me. > Your advice says to me: "Don't sweat the small stuff". Some years ago, in Australia a number of people took to the courts to get the banks to recalculate their mortgages according to the contracts. I can't find an online reference in a 2 minute search, but before the days of a powerful home computer the calculations were beyond most people. Of course, you only need to take a couple of cents extra each month to make a worthwhile profit, and that is hard to find. While I agree, don't sweat the small stuff, there are those who are hoping you won't notice a little bit often. Liz ___ 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] Possible to display two account registers on screen?
On Thu, 3 Feb 2022 17:02:22 -0500 Art Chimes wrote: > I'm trying to clean up some issues with an import-gone-bad which left > me with two accounts for the same mutual fund. There are, I think, > some duplicate transactions and others that appear in only one of the > two accounts, and I want to consolidate this. It will simplify matters > and speed up the process if I can see both accounts side by side. I > know I can print up a transaction report, and use that as a reference, > but is it possible to display the two accounts — GnuFund GNUFX and > GnuFund GNUCX — on screen? > > If not, is it a feature GnuCash should have or is it just me? > > Thank you You can open multiple copies of a file. You will get a warning dialogue. At that point, choose "read only" for the second one. Then you are reasonably safe, read from one, edit the other. Liz ___ 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] Changing where my data is held
On Sat, 12 Feb 2022 14:23:01 + David Long wrote: > Hi, sounds ridiculous but cannot find how to change where my data is > held. Normally would expect to see that under preferences, but do not > see it there. Any advice? I want to put on a shared drive on > Dropbox, so another person can use. Thanks David It's really very simple. Just change where you save under "save-as" and your file will now be in that place. That hasn't removed the old copies, so you either would manually move it (easy) or edit the list of last opened files (harder). When you first opened "save-as" you were shown the current file location. You chose this when you installed Gnucash first up, and didn't need to remember. Liz ___ 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] Changing where my data is held
On Sun, 13 Feb 2022 16:17:32 +1000 David H wrote: > Some advice? I ALWAYS update my gnucash data file locally and then > copy it up to a shared drive, NAS/Cloud/Whatever using FreeFileSync ( > https://freefilesync.org/) - versions for Windows, Linux and Mac OS. > Just means depending on what pc I'm on I have to be a bit pedantic to > make sure I sync up the latest updated one and sync it down on the > other pc if I'm not on my usual machine. Once you have set it up > it's pretty easy to click on "Compare" to see if any changes have > been made and then click on "SYNC" to download the changed version. > Bonus with this is if you stuff some updates up you can just re-sync > the old file back down and over-write the botched file :-) > > Cheers David H. I use software which automatically syncs, and in that case you need to exclude LCK and log and dated-gnucash files from sync. Liz ___ 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] Automatic sales tax
On Mon, 21 Feb 2022 18:54:21 -0600 Adrien Monteleone wrote: > Keith, > > I’m not a mod. > > The instructions for unsubscribing are at the bottom of each e-mail. > You have to do it yourself. > > You can turn on Digest Mode if you prefer in your preferences. > > Please don’t e-mail list members personally unless requested to do > so, especially without copying the list. > > Regards, > Adrien And as the person with the password to subscribe and unsubscribe people, I am not going to do such a thing on that sort of request. My mail client will happily substitute different email addresses so I am well aware that something which says its from a person's email may well not be. Requests can be genuine or not. To unsubscribe yourself you need your password, and can have one sent to you to accomplish the task. Liz ___ 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] Directly posting payments
On Tue, 22 Feb 2022 11:29:53 +1000 David H wrote: > Jim, > > If you're only using your Windows 7 pc for your previous software > have you tried installing/running it on Windows 10 in "compatibility > mode"? Some older software will run ok on Windows 10 using this > feature. > > Cheers David H. Perhaps even a virtual machine, just for that software (extreme, but another solution) Liz ___ 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] Automatic sales tax
On Mon, 28 Feb 2022 06:58:08 -0800 Stan Brown wrote: > On 2022-02-28 06:34, Michael or Penny Novack wrote: > > But if not a remote sale, if person living in state A buys > > something at a seller in state B (and state B has sales tax) > > collected based on that. Now the buyer might still owe sales tax to > > state A when bringing the whatever home. > > The tax the buyer pays to their home state after "importing" goods for > personal use is called use tax in every state I've lived in. > > You didn't mention the case where buyer and seller are in different > taxing jurisdictions within the same state. I don't know how other > states do it, but when you live in county C in California, go to a > dealer in county D in California, and buy a car, the dealer is > required to charge sales tax at county C's rate, not county D's. > Probably the same is true for boats. For smaller items, you pay at > the rate of the seller's county, and there's no credit if you take > the goods back to your home in a lower-tax county. > > > When they pay that on their state return, they can claim > > credit for the sales tax (if any) already paid for that thing to > > state B. > > Maybe. Some states don't allow it, or allow it only up to the home > state's tax rate. It's incredibly complex. And Australians have all been led to believe that we have the most complex tax system on the planet. Liz ___ 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] Automatic sales tax
On Mon, 28 Feb 2022 18:58:20 -0500 Michael or Penny Novack wrote: > > It's incredibly complex. And Australians have all been led to > > believe that we have the most complex tax system on the planet. > > > > Liz > > > The reason is that here in the US sales tax is not national. The US > is a federation of states and commonwealths. You would not be > surprised if 50 countries had highly different rules about sales tax, > whether or not had one, what rates and what applied to and we were > discussing transactions crossing country boundaries. So why does it > seem surprising with our states. > > We haven't even begun to discuss another level of complexity for the > proposed software to deal with. It would also have to be able to be > turned off for each state by date range! That's because it is not at > all unusual for the governor of a state that has sales tax to declare > a "tax holiday" << to boost business >> > > Michael D Novack > Last century, when it was easier to reach political consensus, state sales taxes were all abolished. Now the States argue over the carve up of the pie. But there are plenty of other taxes to make life exceptionally complex here, do not worry, the accountants and tax people have plenty to keep them busy. Liz ___ 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] Keeping tenant accounts on Gnucash - periodic 'rent owing' ?
On Fri, 4 Mar 2022 19:26:04 -0500 Glenn Fowler wrote: > Hi, > > I use GnuCash for rental properties as well. Setup your accounts under > expenses for repairs, insurance, utilities, etc. In my case, I setup a > recurring transaction for rental income. Then, you only need to make > changes as needed instead of doing it manually every month. You need to have some idea on the tax implications of your expenses. In AU, this is where we start to rival North American sales tax ;) So some expenses are recurring - like rates and insurance and are tax deductible Some expenses are general maintenance - the bills from the plumber and electrician for callouts and are tax deductible Some expenses are capital - when you decide to replace the kitchen because it is wear and tear and scruffy, but not if it is seriously damaged by floods (topical here), that would be maintenance or on the insurance. Some expenses can be sent back to the tenant to pay (here we charge water usage to the tenant, but not if you didn't fix the leaky taps or cistern) Whether interest charges on the mortgage you have over the property are expenses which are tax deductible or capital expenses depends on the flavour of government - it seems to oscillate slowly here. If you are not sure about the expenses, make lots of expense subaccounts to keep them in general categories, and rationalise them when you have had a chat with your accountant. In GnuCash its easy to join subaccounts and tedious to split them. Liz ___ 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] Gnucash 3.8 Questions
On Mon, 7 Mar 2022 15:56:47 +0800 Lokesh Yagnik wrote: > Questions > - Can this version (or any version) of Gnucash allow remote access? Or > (from what I think is the case) will just have to allow him to remote > log in to my computer and then look at Gnucash > > - Since I was learning, I have resisted the temptation to update to a > newer version of Gnucash. To upgrade, my understanding is that I need > to upgrade each version to the most uptodate stable version. > As for backing up the current stuff, I will need to back up the > various XYXYXY.gnucash files or does the entire string - > Folder1/folder2/folder3/XYXYXY.gnucash has to be replicated? > > thanks in advance > > LY Remote access can be achieved, but it involves technological knowhow to do it safely and securely. You could decide to email the file each reporting period, and have the accountant make any notes and email it back. I make the reports that my accountant needs and provide those. Keeping up to date with Gnucash is a *good idea*. Catching up when your version is a long way behind is difficult. I am not usually on the *latest* but one or two releases behind. What to back up is covered in the FAQ https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups which I see now leads to longer articles in the wiki Liz ___ 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] Question about Assemblies
On Thu, 17 Mar 2022 01:59:28 + Frederick wrote: > Hi there, i am a interested in abandoning my Accounting software and > looking to see if Gnucash will work for my one person business. > > The main issue is that i manufacture items to sell and need software > that can account for assemblies. This can go by the name of > manufacture/build or assembly. Sage 50 calls this Assembly. > > If someone can let me know if builds are easily possible with gnucash > and direct me to literature on this matter, it would be greatly > appreciated. > > take care, fred > I'm assuming here that you mean "manufacture a widget" for assembly and build. There are other meanings of build that software developers use. When I make an invoice I can invoice different items. I can invoice Time, different types of Service, and different Goods. We don't know how you account for manufacturing costs when you invoice, nor how you spread this income in your accounts. If you give some more details, someone who is already doing similar with Gnucash can advise. Liz ___ 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] Report - Income Statement - Layout problem
On Sat, 26 Mar 2022 23:58:16 +0100 Carl-Kensaku HERBORT wrote: > But I will test it with my current one as soon as the 4.10 version > comes to Ubuntu (or if it takes too long, I will download it > manually) and let you know if it works on my end. Ubuntu seems to be very slow getting updated Gnucash versions, building it yourself would be worthwhile and should be much less than 3 months. Liz ___ 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] Reconciliation discrepancies
On Mon, 11 Apr 2022 14:36:41 -0700 (PDT) Rich Shepard wrote: > Every now and then one of my bank accounts doesn't reconcile because > what the bank shows differs from what GnuCash shows. The amounts are > significant. What puzzles me is that the previous month's balances > (bank and GC) match and so do all the transactions. But, the end of > month balances don't match. Rich when I get into a mess, I do very small increments on the reconcile. For example, just choosing a date about 10 transactions down, or one week, and then I will go through very slowly, doing small chunks. Assume this is one month, and I am doing weekly... I find the bank's ending balance for 7th of month, put 7th of correct month and the balance from the bank statement into the reconcile dialogue, and check off that week's items from the bank statement. When the residual is zero, I mark finished, and move forward to the 14th. (Procedure loops) By looking at such a small number of transactions it is possible to find whatever the errors are. I too have been on Gnucash for a couple of decades, but still found 4 errors in one file this March, payments not entered as received, and digit transposition. I hope you find what is happening and let us know. liz ___ 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] File browser file type filter and bookmarks
On Wed, 20 Apr 2022 09:06:53 +0200 James Thorpe wrote: > I have two questions regarding usage of the file browser dialog to > open a gnucash accounts file. > > > > many thanks > James, one way of dealing with this is to make changes to your user menu on Linux. Not that I remember how to do it, because it has been working for many years on my desktop, survives upgrades and so on. My menu, under "Office" has Gnucash Gnucash Business Gnucash Home Gnucash Super Gnucash Trust You didn't say which desktop environment you are using, so more specific advice would need that data. Liz ___ 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] New to GnuCash SQLite on Windows: I have questions
On Wed, 20 Apr 2022 09:02:16 +0100 Chris Green wrote: > On Tue, Apr 19, 2022 at 09:20:56PM -0400, Derek Atkins wrote: > > > > > > 1. Is there any way to get GnuCash to save its file, by default, > > > with an appropriate suffix other than "gnucash?" > > > > Sure, tell it to do that. It only adds ".gnucash" by default, but > > it won't override what you tell it. > > > Where do you tell it that? > "Save As" in the menu should do it. Liz ___ 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] Australian System
On Thu, 02 Jul 2020 15:38:38 +0930 Mike Alsop wrote: > You have probably been asked a thousand times, but as we entered a new > financial year yesterday, I seriously need to look at doing my own > books. Bookkeeping fees are now over the moon!! > > So, does this system comply with the Aussie GST and BAS reporting > system for the Australian Taxation Office?? > > Many thanks in advance for any info. > > Mike Mike thanks for the question Many of us are doing our business accounting in AU with Gnucash. There isn't a way to automatically populate anything on the ATO website. I am doing my IAS and BAS on paper ever since the ATO broke the system for renewing certificates and I couldn't use the electronic system on Linux. That would be about 13 years of quiet protest ;) Liz ___ 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] Gnucash-User
On Sat, 4 Jul 2020 07:54:56 -0700 John Ralls wrote: > > On Jul 3, 2020, at 11:03 PM, Adrian Holbrook > > wrote: > > > > I have been trying to post on the forum but for some reason am no > > longer allowed to post. I have sent a number of messages trying to > > get permission but with no response from the moderator. Sorry Adrian, but I am not stopping you from posting. I don't know where you have been sending messages requesting permission, but they haven't reached me as moderator. Were you sending from Nabble beforehand? We don't control what happens with Nabble. Posts made through Nabble come straight through if the writer is registered with the Gnucash mailing list involved, otherwise they sit in the queue for me to check. At the bottom of every email from the Gnucash server is the instructions on how to join. https://lists.gnucash.org/mailman/listinfo/gnucash-user Liz with Moderator hat in place. ___ 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] Gnucash user Nabble
On Sun, 5 Jul 2020 07:20:17 -0700 John Ralls wrote: > I'm not the list moderator nor do I have shell access to the mail > server, so I can't help you. Your best recourse is to get on IRC > (https://wiki.gnucash.org/wiki/IRC) and ping warlord. > > Regards, > John Ralls > > > On Jul 5, 2020, at 4:24 AM, J R wrote: > > > > I too sorry for contacting you, I also cannot create a new topic or > > reply also 1. I am logged in > > 2. I am subscribed > > 3. I don't know what Liz and I have in common for this problem, > > maybe a yahoo email? 4. Was working a couple of months ago > > > > Thank You > > Jimmy R > > mikromal...@yahoo.com > > I am the moderator. I have checked the subscription of the above address, and it is subscribed. It is set to receive all mail. You should get two copies of this mail. No one logs in to the Gnucash system other than Derek as maintainer and me as moderator. That's why Derek asks "where are you logged in?" I think that you could be logged in at Nabble, Nabble is not Gnucash. Liz ___ 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] Best match probability calc is too pessimistic
On Sun, 5 Jul 2020 14:49:40 -0400 David Reiser via gnucash-user wrote: > From my perspective, transactions posting within 3 days of the > transaction date should still get a match score of 6. One day after > transaction ought to be 8. One of the grocery stores I go to > frequently has never posted the charge to the credit card company the > next day. Sometimes there’s only a 2-day gap, but it is frequently 3 > days. I suspect the difference between 2 and 3 days is related to how > late in the evening I go shopping. If I "tap and go" with my debit card the money is on a 72 hour hold (Australia) before being paid by the bank to the place which is waiting for the money. So a person using this system in Australia would not get offered a match in the matching system, as the minimum time between the transaction and bank posting is 3 days. Liz ___ 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] Gnucash-User
On Sun, 5 Jul 2020 21:24:25 -0700 Stan Brown wrote: > > I guess all that would recommend abandoning nabble altogether, and > > drinking the gnucash Kool ade directly from lists.gnucash.org... > > just saying.?. > > I don't know how we could, because no-one knows who actually signed Gnucash lists up to Nabble in the first place. Liz ___ 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] Gnucash - user
On Tue, 7 Jul 2020 07:46:23 +0100 Adrian Holbrook wrote: > Liz, I tried to respond to a posting by David Cousens [via GnuCash] > and it was rejected by Nabble. Could you pass on the following - > > I have also tried to contact Hugo a number of times. In frustration I > have used a different email address and name and registered again > following the instructions on the gnucashe wiki. I have the same > problem. I do not unders tand the difference between posting > on the Gnucash list vs posting by Nabble - certainly following the > wiki in structions forces you to use Nabble. as soon as you register > you are sent an email to click on and it takes you to the Nabble > subscribe form. I am very confused and would love a simple > process that worked like a normal forum without having to go through > hoops If you get that impression we need to do some wiki editing. I just went to this page https://wiki.gnucash.org/wiki/Mailing_Lists >From https://wiki.gnucash.org/wiki/GnuCash and then to https://wiki.gnucash.org/wiki/GnuCash#Mailing_Lists and to https://wiki.gnucash.org/wiki/Mailing_Lists and the instructions show how to sign up directly to the mailing list. Could you advise which page advised you to go to Nabble, and if possible the route you took to get to that page. Then we can look at the links as well as the pages Liz ___ 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] Gnucash - user
On Tue, 7 Jul 2020 15:03:20 +0100 david whiting wrote: > If you do a google search for "gnucash forum" the top two hits are > results from nabble. If you click on either one of these you'll see > the login/register link top left that sign you up to nabble. > > Perhaps this is how some people think that this is the correct way to > sign up. They are doing something that is normal these days, a google > search for what they want to find (gnucash forum) and aren't aware of > the subtle difference between using nabble and signing up to the > mailing list. There's a very good chance they won't get close to the > wiki so perhaps it will make no difference how clearly it is > described in the wiki. > > See attached. > > David I use DDG, and just checked, Gnucash.org is the first entry returned. I s'pose Google would like us to buy ads to get to the top of their search?? Liz ___ 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] Reconcile also opens Interest Payment box?
On Sun, 12 Jul 2020 09:38:32 -0700 John Ralls wrote: > But that's a UI change and UI changes tend to generate heated > disagreement. I want to get that out of the way up front: Who here > objects to removing the interest and payment transfer automatic > popups and the interest payment button on the reconcile info dialog, > and what compelling reason do you have for objecting? No objection, I don't use them as it interferes with my workflow. Liz ___ 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] simple search
On Sat, 18 Jul 2020 22:31:51 -0400 (EDT) "Max Hyre" wrote: > > I wish to do a search in one account for all > > the listings of $31.99 > > > o Select the menu Edit > Find, which brings up a search dialogue. > o Click the radio button `New Search' > o Pull down the menu below `Add' and select `Account', then select > the account you want ( or in your example) o Click `Add' to > get an additional search line o Select `Value' on the new line, then > enter 31.99 o Click the `Find' button and you'll get a new tab with > the desired entries > > >HTH, > > Max Hyre I know it worksmy accountant asked about something, quoted correct amount, wrong date, wrong description, and with the search facility I was able to find the transaction, and then the supporting data :) Liz ___ 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] Still no access to Gnucash Nabble
On Fri, 24 Jul 2020 11:01:44 + (UTC) J R via gnucash-user wrote: > Thanks Dave, I seen your post the last time before, was just > wondering if there was an update on the problem.Hope there is a plan > B if the whole Nabble goes down Jimmy Well, our Plan A is your Plan B We will still be here, the Gnucash mailing lists will still exist, and we will still be able to communicate. You may be used to Nabble, but its particular formula led many users to try to post in the development list instead of this one. Liz ___ 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] Can't find file
On Fri, 31 Jul 2020 17:09:54 -0700 Chris Graves wrote: > For those that like launching from the gui, one can create a simple > shell script and automator script, then in the finder, right click > the .gnucash file->services->”name of automator script” to cause a > new instance of GC to open the selected file. > > Shell script, named for example - gnucash which in this example > resides in your $HOME directory: #!/bin/zsh > /Applications/Gnucash.app/Contents/MacOS/gnucash $1 > > Then in automator: > Select New-> Quick Action > In the dialog, select Utilities->Run Shell script > In Workflow receive current, select files or folder in Finder.app > In the Run Shell Script dialog, select /bin/zsh > For Pass input: select as arguments > In the dialog box beneath the above, enter > $HOME/gnucash “$@“ > > Select save and name the file —let’s call it gnucash. > > Then to make use of the above: > In finder, right click on the .gnucash file of > choice->services->gnucash > > This will open a new instance of gnucash with the selected file. > Could one of our Wiki editors add this to the Wiki? This would help many Mac users. Liz ___ 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 do I add notes to my columns
On Sun, 30 Aug 2020 16:56:57 + Tom Hatzigeorgiou wrote: > Can we put this on a vote? > I would say YES bring on. I need to see my notes on the same line as > the transaction. If there are people that do not like this option > maybe azalea4va could provide an option that the notes can be placed > on a new line, same line or hidden all together. based on his screen > shots, maybe azalea4va coded for that option already. If that's the > case, I see no reason why his request cannot be accommodated. Make it > my request too. Any other takers. Thank you. > Certainly We have a space set up complete with voting here Set up another item to vote on, announce it here on this list, hopefully the other language lists will also pick it up. https://gnucash.uservoice.com/forums/101223-feature-request Liz ___ 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] Negative attitudes [was: Re: Negative numbers]
On Sat, 12 Sep 2020 22:37:02 -0700 ToddAndMargo via gnucash-user wrote: > Folks do not understand that Open Source is not free. We have a way of describing this to deal with the various meanings of "free" in English. You are describing "free as in beer". Others are describing some of the further meanings of "free" that FSF refers to Freedom to use for any purpose; freedom to examine the code; freedom to share; freedom to improve (and share those improvements). You can read more about the matters here https://www.gnu.org/philosophy/free-sw.en.html Liz ___ 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] clip board paste across catagories
On Sun, 27 Sep 2020 00:23:50 -0700 ToddAndMargo via gnucash-user wrote: > On 2020-09-27 00:02, David Carlson wrote: > > AFAIK ctrl-v has always pasted entire contents of the clipboard > > only into the currently selected field. > > > > Any special character I can throw at it to get it to paste across > fields? I can insert anything I want into the string > Up in the menu icons you will find an option to cut a transaction, then an option to paste the transaction into another account. It doesn't always work smoothly for me If you are copying from a spreadsheet you may need to use the csv importer to make it work. I am ignorant about its workings. Liz ___ 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] Invoice Payment
On Mon, 5 Oct 2020 09:12:07 +0200 Oliver Arnold wrote: > I have a customer with two different business entities. Every month, > I write an invoice to each entity. Unfortunately, I receive ONE > payment for both invoices on my bank account. My question is: How to > I process this invoice payments? Since I use an online account to > sync my bank, I have the issue, that I can not really split the > booking. > > Thanks for ideas This is the same problem as one where of a charge of 100, 80 was paid to the vendor, and 20 went to a tax withholding account. Have a look at the varied answers to the problem. https://lists.gnucash.org/pipermail/gnucash-user/2020-October/093407.html https://lists.gnucash.org/pipermail/gnucash-user/2020-October/093418.html Liz ___ 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] Button1 & Button2
On Fri, 23 Oct 2020 12:29:11 -0600 Bert Riding wrote: > Start up xev in a terminal and you will find that what I said is the > actual way X works. It's configurable in /etc/X11/xorg.conf I certainly recall when the new middle button came up as button 3. Liz ___ 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] Customising "Action" in Register
This is not the Action menu, this is the "Action" seen in the column with the number, when Double Line view is selected. In a bank account, there is a drop down list which goes from "ATM Deposit" to "Withdraw". I can override and put in Australianised categories, but how can I influence the drop down list? Liz ___ 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] [GNC-dev] Gnucash server going offline shortly..
On Sat, 31 Oct 2020 10:49:49 -0700 Matthew McGillis wrote: > My rant, not related to gnucash at all, but utility companies and > smart devices. > > Just me venting some long frustration along these lines. > > We put in the effort to add UPS and in my case a stand by generator > that runs off natural gas. This combination has never failed to keep > my systems powered even for long outages (worst case was 5 days). But > guess what... most telcos (comcast, centurylink, cell phone towers …) > don’t have the same ability. So if the power outage also includes > that local distribution point generally you have about 6-12 hours > before those distribution points go dark. So although I keep running > perfectly locally it is no good for internet access. Agreed. Here during last summer's major bushfires many problems were found with communications infrastructure, with inadequate planning for power loss or fire hazard control on the hilltops. Liz ___ 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] Cannot Obtain Lock error?
On Sun, 8 Nov 2020 13:57:29 +1000 David H wrote: > Perhaps another thing to consider is are you using any sort of syncing > software that could possibly be copying this LCK back from a backup > location after Gnucash has deleted it ? > > Cheers David H. If so, set the software not to copy the *.LCK and the *.LNK as well as the *.log files. I use a complex system of syncing to allow me to use the laptop for Gnucash when away from home and have all the data automatically updated to the primary copy on the laptop. Liz ___ 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] Wrong starting balance
On Sat, 21 Nov 2020 11:32:39 +1100 Liz wrote: > I was trying to reconcile an account for the first time since I > created it. > > The reconcile dialogue says it has a starting balance of $6,300. > I have no idea from where this starting balance has come. The first > entry is $1.87. > > I can't find any entry in any account for $6,300 > > Has anyone any ideas on how to handle this? > > Liz > sorry, I forgot Version: 4.2 Build ID: 4.2+(2020-09-26) Finance::Quote: 1.47 On Debian ___ 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] Wrong starting balance
On Fri, 20 Nov 2020 16:41:22 -0800 Jim DeLaHunt wrote: > Hello, Liz: > > Are any of the transactions in that account reconciled? Do you have a > "starting balance" transaction in that account, perhaps created when > you created the account? > > The reconciliation model for GnuCash assumes that you start by > reconciling the earliest transactions, and move forward sequentially > in time, reconciling bit by bit. When you start a reconciliation, > GnuCash adds up all the reconciled transactions for that account, > regardless of date, and that becomes your starting balance. > > Does this help? > > Best regards, > —Jim DeLaHunt No Jim I know perfectly well how reconcile works. I have not reconciled this account ever. NO transactions are reconciled The starting balance is $1.87 I am mystified about $6,300, so I did a find for that value on the entire account tree and found nothing of that value. Liz ___ 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] Wrong starting balance
On Fri, 20 Nov 2020 18:50:06 -0600 (CST) David Cousens wrote: > Liz, > > That would seem to imply that some transactions have been marked as > reconciled somewhere in the account history, not necessarily a single > transaction for $6300. One possible suggestion, have you cleared all > filters that might restrict the date range displayed for the account? > There may be some hidden transactions that aren't appearing. > > David Cousens > > No filters in place, it starts from the date I started the account with the $1.87 balance I have created this and NEVER reconciled It's certainly a little odd. Liz ___ 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] Wrong starting balance
On Fri, 20 Nov 2020 18:50:06 -0600 (CST) David Cousens wrote: > Liz, > > That would seem to imply that some transactions have been marked as > reconciled somewhere in the account history, not necessarily a single > transaction for $6300. One possible suggestion, have you cleared all > filters that might restrict the date range displayed for the account? > There may be some hidden transactions that aren't appearing. > > David Cousens > > > > I moved some transactions from another account, and they copied the reconcile flag over. Phew! ___ 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] Wrong starting balance
On Fri, 20 Nov 2020 17:58:38 -0800 "Stephen M. Butler" wrote: > Try to reconcile another account that has never been reconciled. If > that comes up with a non-zero number then create a new account and > attempt to reconcile with no entries. If that comes up with a > non-zero amount then you have found a bug. > > What I'm wondering is if there are no entries to add up the module > might not be handling the results correctly. I tested that possibility, and it was negative. Fortunately I found where the problem was, and it is related to the user. I did not expect when I moved transactions from the bank account to a holding account that the reconcile flag for the bank account would remain. It may be a bug. Liz ___ 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] Wrong starting balance
On Sat, 21 Nov 2020 17:30:08 -0600 David Carlson wrote: > Liz: > > If I understand correctly, at some point intentionally or > unintentionally you were able to move a previously reconciled > transaction from one account to a different account without changing > the reconciliation status. I just tried that in release 3.8 and I > received a warning that the reconciliation will be cancelled. > > Do you remember which release of GnuCash you were using at that time? > I cannot test release 4.2 so I cannot check whether a new bug report > needs to be filed. > > I believe that user action is equivalent to my previous description of > changing the account GUID of a given split line which has a > reconciliation status of 'Y'. If not, someone please enlighten me. Version: 4.2 Build ID: 4.2+(2020-09-26) Finance::Quote: 1.47 On Debian I was dealing with an intermediate account I made to help me follow a credit I have with the tax people. So I was moving payments made to the tax authority into an intermediate account, type Liability. They were moved from an Asset account, type Bank. They had been reconciled. So Tax has to be paid, counted in account X The liability to pay the tax is counted in account Y The payments are still made to the tax people from account Z Previously the system counted the tax in X and paid it from Y so instead of X <> Z the books now go X <> Y and Y <> Z To get the accounting correct I have had to move reconciled transactions from Z to Y (they were scheduled transactions). The change was made from X, a non-reconciled account I said "Do not tell me again this session that I am changing a reconciled transaction" When the transactions were reviewed in Y they remained reconciled, and the amounts were reconciled in Y, which was inappropriate. How much of this needs to go in the bug report? Liz ___ 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] Help on daily cash income and bank statements
On Sat, 21 Nov 2020 19:07:14 + (UTC) alison Stoner via gnucash-user wrote: > Hi there > I started using gnucash. Now accountant would also like bank > statement typed in. I have only been typing in all my invoices.Where > do I type the monthly statements in/to?Also where do I type in daily > cash intake. Like I said I am only doing all my expensesLook forward > to your reply RegardsAlison Welcome Alison Yes, if you can do this extra data entry you will help your accountant and hopefully have to pay less to them! There is LOTS to learn, so we recommend making a practice set of accounts to learn on, and reading the user guide. The main user guide is https://code.gnucash.org/docs/C/gnucash-guide.pdf and the quick version is here https://wiki.gnucash.org/wiki/GnuCash_Quick_Start_Guide_For_Business_Users Play around and come back here with your questions. "gnucash-user@gnucash.org" If you subscribe to the list you won't have to wait for the Moderator to let your emails through. Liz ___ 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] Wrong starting balance
On Sat, 21 Nov 2020 23:51:01 -0600 David Carlson wrote: > Liz > > I would suggest copying that entire message into a bug report. > Especially be sure to include that you had said "Do not tell me again > this session that I am changing a > reconciled transaction" as that may be the key to the puzzle. The > developers can figure out which details don't matter and which are > important. If they cannot reproduce the issue they will ask for more > information, so it speeds things up to be very detailed the first > time. Also include that the transactions were spawned from scheduled > transactions, in case that makes a difference, even though they were > not reconciled until some time later. If you remember which account > register you were working in (X, Y, Z, Tax or perhaps General > Journal) when you made the changes, that may also help. > > After You have filed the bug report, if you think others may wish to > follow the progress, you can report the bug number in this list. I > suspect that you already know the drill! > https://bugs.gnucash.org/show_bug.cgi?id=798017 so long since I reported a bug I had to reregister ;) Liz ___ 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] GNU Cash on a Central Computer
On Sat, 5 Dec 2020 12:16:13 -0600 (CST) randix wrote: > When I save my GnuCash it does not > write the same file name each time, eg > > 2020-12-Dec.gnucash.20201205100356.gnucash > 2020-12-Dec.gnucash.20201205073851.gnucash > etc. You have a problem. You are working on backups. https://wiki.gnucash.org/wiki/FAQ#Q:_Why_is_my_file_name_getting_longer_and_longer.3F > 7. So are you saying when you use dropbox in conjunction with > GnuCash, the user has to go to the dropbox directory, and manually > load the last saved file after looking at the saved dates, to make > sure it's not loading an older saved file? > > Hope that's clear. Thanks. As I say, just curious. When you can work out why you are using backup files, this problem will "go away". Liz ___ 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] Rounding & formulas
On Tue, 22 Dec 2020 10:22:44 -0500 Michael or Penny Novack wrote: > > 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 between different legal jurisdictions. > > > > It is impossible for GnuCash to know apriori how a particular > > amount will be rounded and appear in external statements (hopefully > > someone is not skimming off the fractions of cents from the > > rounding) against which the GnuCash records will ultimately be > > reconciled, so no matter what rounding procedure was used by > > GnuCash in any internal calculations, it can end up being wrong > > because the bank chooses to or is required to round in a different > > manner. > > > > David Cousens > > It can be MUCH worse than that, because the consequences of > legislated rounding (in filling out filings) may be complicated. Thus > for US non-profits, if they have to file a 990/990EZ this much not > only be "whole dollar" but must match the previous year's filing. But > rounded (A+B) does not necessarily equal rounded A + rounded B. In > other words, there is no way to do this by "formula" as will require > human decision as to what "fudging" will result in minimal distortion > << for example, if use truncate instead of rounding for THIS amount > and round up on THAT one all will work out >> > > So some years don't have to fudge any amounts, other years just one > or two, still other years nasty and have to do many. > > Same with banks. Some may use one method of rounding, others another. > And sorry, but although many currencies integral to a specific > decimal point they may sometimes use more << like the "mil" seen in > tax rates. water rates, etc. >> > > Michael D Novack > I'm just rephrasing this... If Gnucash (or any accounting program) rounds values you have to know exactly how this has been done, and you have to know your jurisdiction's rules, so you can see if they match. If they don't match, then you would have undo the accounting program's rounding and then apply the correct one for your jurisdiction. I think that we have taken a peek down a rabbit hole and found enormous complexity past the entrance. Liz ___ 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] Set up
On Thu, 14 Jan 2021 15:31:20 -0500 David Ridell via gnucash-user wrote: > Am I doing something wrong? No, but you can do it better. See David's suggestions. Liz ___ 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] UK specific: MTD - Making Tax Digital
On Sun, 17 Jan 2021 02:52:19 -0600 (CST) "chr...@floatdene.com" wrote: > As there are only about 6 users interested, it is > definitely not worth the effort! While you have only counted 6 who have put up their hand so far, I think that there would be far more interested in a usable system. It doesn't include me, I live elsewhere. Liz ___ 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] Changing multiple transactions
On Sun, 31 Jan 2021 16:17:59 -0800 Jeff Rizzo wrote: > though I'm currently puzzling a > little about how to with an OFX source instead of CSV - it did ask me > the real account name, but apparently only for one side of each > transaction? I'll dig. You set the account name for the account for which you are doing the direct download eg "Bank Account, savings, Joe and Mary" the other parts of the transactions you provide the account name for further along the import system. You do a small fraction at a time. You train the import system with -nothing- going to Imbalance Then you put in the next fraction, and it has learnt from the first import that "Grocery Store" goes to Expenses:Groceries and slowly you get through the import process and did I remember to say SAVE and BACKUP ?? Liz ___ 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] Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile
On Mon, 08 Feb 2021 22:32:17 -0500 "D. via gnucash-user" wrote: > But David, how would this setting affect some credit card accounts, > but not others? I'm sure its an individual account setting. However, if one made an error and made a credit card a regular Liability, it wouldn't be set at all (See Adrien's post) Liz ___ 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] Credit Card payment pop-up doesn't appear on *some* credit card accounts after reconcile
On Tue, 9 Feb 2021 07:22:44 -0500 Robert Stocker wrote: > And for the record (thanks for asking), I did submit this question > before, but all I got back was an email saying it would wait in the > queue until approved because I wasn't a member of the mailing list. > After a week or so, I figured I should join the mailing list if I > wanted to get through to it, so I did. I never knew it actually went > through. I let it through. But it is much better to join the list. There are two versions of this query on the mailing list 30th Jan with no replies 9th Feb with replies Liz ___ 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] Importing Accounts with non-English Characters
On Tue, 16 Mar 2021 03:31:34 -0500 (CDT) viking wrote: > Quite an old bug from 2017. Is there a workaround to be able to import > accounts with non-English characters? > > I am also not able to /manually/ create a new account including > non-English characters. For example, the letter "å" can be typed here > by pressing "Alt-0229". However, it doesn't work when trying to type > this letter in the Account name for a New Account. > Is this another bug? Can you copy and paste the correct characters into place? Liz ___ 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] One bit of spam
Sorry Gals and Guys I've let through one bit of spam. It has got caught in my spam filtering here, so you may or may not see it. I do apologise. Liz ___ 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] Need help
On Fri, 16 Apr 2021 12:54:33 +0200 "Glen Bailie" wrote: > Dear Sirs, > > I am trying to set up a set of books, but have come across some > problems for which I need help. > > !) How do I get into Accounts, > > 2) How do I do transactions from a bank cheque account, such as > receipts and payments that are not from customers or vendors. For > example bank charges, and subscriptions. > > 3) When I enter a new Vendor, I get the message " no valid vendor can > be found" What is wrong here? > > > > Would you please give me detailed instructions about solving the above > problems. > > Regards, > > Glen Bailie > Glen Welcome here I think that you would do well to read the concepts guide and tutorial, which does have detailed explanations, and then start a set of books simply to experiment with and practise in. https://code.gnucash.org/docs/C/gnucash-guide.pdf Warning, because it is detailed, it's 311 pages long. Then come back with your questions. Liz ___ 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] read-only file
On Sat, 17 Apr 2021 09:27:30 -0700 Robin Lake wrote: > Greetings -- > > I have recently installed gnuCash and built a file (book) at the time > of installation. When I opened the file, it was read-only. Over the > couple days I've been trying to solve my dilemma, I have developed > two (to me) large questions. > > 1) Can I take the file out of read-only status? If so, how? > > 2) Can I simply delete the file, from within gnuCash, and start over? > If so, how? > > Since there is not yet any data deleting would not be a problem. > > I have searched both the guide and help .pdf's, and queried the > internet at large, and have not found an answer to either question. > > Any help would be greatly appreciated. > > Robin > > > Robin, thanks for bringing us this question. I'm sure this has been asked multiple times in the past. The answers are OS dependent. From your mail headers, I think you are using Windows 10. To take the read only marker from the file would be done from an administrator login. You cannot delete the file from within GnuCash. You could delete it with administrator privileges. You can start again. That is no problem. Take great care where you store your file, it should be in your home directory / folder. We recommend making a special directory for your GnuCash files and keeping them off your desktop. Plan your backup strategy for this directory as well. If David Carlson is correct, and this has started with you getting a warning that the file is already open, then follow his instructions. Next time be sure you close GnuCash before you close the computer! Liz ___ 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] Lost Transactions - HELP
On Sat, 22 Apr 2023 14:57:57 -0400 "Jonathan A. Cohen" wrote: > I acted too quickly. For whatever reason, the last save was not > complete. The file size was only 600k instead of 4.7M. After a > search, I restored from the last automatic backup. All good now. Pleased to hear it is all OK. My first thought was "disc space?" Liz ___ 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] Reorganize Trading accounts
On Sun, 23 Apr 2023 12:49:29 -0400 King Mak wrote: > Hi, > > I have just acquired a new computer. I moved all my gnucash files to > the new computer by copy-paste. But when I open my accounting files > in the new computer, I notice that some of the transactions are > missing . What do I do? start a new thread here after doing your basic checks on file sizes etc. Liz ___ 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] GNUcash 5 - Trial Balance
On Thu, 27 Apr 2023 16:44:17 +0100 Chris Bastock via gnucash-user wrote: > I also not that on the TB there is no way to filter for accounts with > a zero balance. This means manually removing them. Is this really desirable? If I was your auditor, I would want to see accounts with a zero balance. They may have had a balance in a previous period. Liz ___ 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] Should GNUCash allow a split to reference the same account twice
On Thu, 20 Jul 2023 18:46:08 +0100 Henry Law wrote: > Earlier today my wife was running GNUCash to update "her" bit of the > accounts and got into a serious tangle because she (inadvertently) > changed a newly-imported transaction so that its two splits -- which > should have been our current account and her credit card account -- > both referred to the credit card account. She then reconciled one > half and not the other, which caused a cascade of issues which took me > several hours and a manual edit to the GNUCash file to fix. > > Should GNUCash refuse to allow a transaction to have two splits into > the same account? My knowledge of accounting is scant, but with it I > can't see why one would ever legitimately do that. With the benefit of hindsight, would going back to a previous save have been a better thing from a time perspective? Liz ___ 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] How to record payments for several items paid with a single transaction?
On Sat, 22 Jul 2023 17:56:09 +0100 Chris Green wrote: > But what if one has cash from two collections to go to the same > account. I.e. a collection on 22nd July and a collection on 29th > July both paid in at the same time? One way of doing this is with an intermediate account. You take the cash from 22nd July and put it in the intermediate account, which could be called "undeposited funds" or "cash on hand". You do the same with the cash from 29th July. On banking day you put the cash from the cash tin in the bank, and move it in your books from the intermediate account to the bank account. Summary Physical movement of funds collection > count done > cash tin 2nd collection > count done > cash tin > count done again cash tin > bank (and another count) Recorded movement of funds collection > cash on hand 2nd collection > cash on hand cash on hand > bank I'm sure you will sort this out shortly. Liz ___ 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] Trouble building 5.3
On Sat, 22 Jul 2023 14:25:38 -0700 Steve Butler wrote: > First I would upgrade those 191 packages. > > sudo apt update > sudo apt upgrade > > Make sure everything upgradable was upgraded. > > Check that you have build-essentials. May I suggest checking what would happen if you did upgrade first? sudo apt update sudo apt -s upgrade Liz ___ 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] Trouble building 5.3
On Sat, 22 Jul 2023 18:27:52 -0700 John Ralls wrote: > > On Jul 22, 2023, at 5:15 PM, Liz wrote: > > > > On Sat, 22 Jul 2023 14:25:38 -0700 > > Steve Butler wrote: > > > >> First I would upgrade those 191 packages. > >> > >> sudo apt update > >> sudo apt upgrade > >> > >> Make sure everything upgradable was upgraded. > >> > >> Check that you have build-essentials. > > > > May I suggest checking what would happen if you did upgrade first? > > sudo apt update > > sudo apt -s upgrade > > > It won't help. Ubuntu doesn't update Gwenhywfar and AQBanking > post-release, and they're not in focal-backports. Gwen 5.6.0 and > AQBanking 6.2.10 are in Debian's buster-backports > (https://backports.debian.org/Instructions/) so you could see if you > can install them from there. > > If that fails they're both pretty easy to build from source. Download > from https://www.aquamaniac.com. > > Regards, > John Ralls > I was thinking that the user would check the output, and see if gwenhywfar or aqbanking were in the list to be upgraded before upgrading any packages. As you note, they wouldn't be, and then the next option is to build the required packages as well as Gnucash. Liz ___ 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] How to transfer all my accounts etc. to new computer. Linux version
On Fri, 11 Aug 2023 17:00:35 +0300 Shevach Pepper wrote: >I’m sure this is really simple but I’m not successful. > >I installed gnucash on new computer but I can’t find an option to >import all my old accounts from old computer. I’m sure this has > been asked before, but I can’t find any instructions on how to do it. > > I've just had to do this because I dropped my laptop. I've gone from 4.14 to 5.1 in the same move. I've transferred my ~/ (home directory) from one computer to the new one. Gnucash opens, but a lot of my preferences are gone, and even which is my next invoice number. I open Gnucash > Help > About, and attach the screenshot. This tells me where to look for my preferences, data etc. GNC_USERDATA_DIR is /home/liz/.local/share/gnucash Nope, my data files are in subdirectories of /home/liz/Nextcloud/gnucash/ My *.gcm files are under books in ~/.local/share/gnucash/ $ ls /home/liz/.local/share/gnucash accelerator-map deviceidhashsaltsqif-accounts-map storage booksexpressions-2.0 saved-reports-2.8 stylesheets-2.0 checks hsts-storage.sqlite saved-reports-2.8-backup translog GNC_USERCONFIG_DIR is /home/liz/.config/gnucash Nope, this directory is empty (and I checked two other computers that have shared this data and all are empty directories here) What does the FAQ say? https://wiki.gnucash.org/wiki/FAQ#Q:_I_moved.2Frenamed_my_data_file_and_my_reports_disappeared._How_do_I_get_them_back.3F "Reports are stored in a separate file in the ~/.gnucash/books directory." Nope, no such directory $ ls ~/.gnucash/books ls: cannot access '/home/liz/.gnucash/books': No such file or directory OK, I am supposed to know what I am doing, and I can't this time, having advanced from 4.14 to 5.1, find where to put my preferences file(s). There is a serious disconnect between the documentation and the new version here. I can understand that a person less familiar with Gnucash could have a lot of difficulty moving to a new computer. And by the way, where does the new version expect to find my *.gcm files?? Liz ___ 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] How to transfer all my accounts etc. to new computer. Linux version
On Sun, 13 Aug 2023 11:15:52 +1000 David Cousens wrote: > The saved reports are in > /home/liz/.local/share/gnucash/saved_reports2.8. GNC_USERDATA_DIR is > the location for the user preferences data all very well, but that file ~/.local/share/gnucash/books/*.gcm contains the data for the registry displays but where is the date format, the last invoice number, accounting period and so on? Liz ___ 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] How to transfer all my accounts etc. to new computer. Linux version
On Sun, 13 Aug 2023 14:08:49 +1000 David Cousens wrote: > I have to confess I don't know where that info is hiding. I tried > changing the format from the default locale for the date but couldn't > see anything changing in the .gcm file. Same for invoice number. > John may be able to tell us where the various bits of info go. I used > "find - mmin -120" to try and locate any files which had changed in > the last 120 min with no luck. if we can get the info then I can try > updating the wiki and work longer term perhaps on getting that info > into the documentation. > > David I just don't know, and having used rsync -av to move everything, I am not sure what has been missed. If the data has moved in the upgrade I can understand that my method may have not been a sure method of data transfer when changing computers. Certainly once we have the data we can update the documentation. Liz ___ 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] How to transfer all my accounts etc. to new computer. Linux version
On Sun, 13 Aug 2023 09:46:14 +0200 Geert Janssens wrote: > That data is managed via GSettings, which on Linux uses dconf as > back-end. I have no idea how dconf manages its internal database > unfortunately. It's tied into dbus but that's a black box for me. > > You can dump the the contents via dconf or GSettings tools and then > import this on the new machine. As I'm not near a computer right now, > I can't offer much more than a pointer in the right direction. > Someone on reddit has supplied some answers here https://www.reddit.com/r/linuxquestions/comments/oqbyqr/how_to_copy_dconf_settings_from_dead_machine/ and I'll report on success or failure, as I can ssh into the old machine. Liz ___ 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] How to transfer all my accounts etc. to new computer. Linux version
On Sun, 13 Aug 2023 09:46:14 +0200 Geert Janssens wrote: > That data is managed via GSettings, which on Linux uses dconf as > back-end. I have no idea how dconf manages its internal database > unfortunately. It's tied into dbus but that's a black box for me. > > You can dump the the contents via dconf or GSettings tools and then > import this on the new machine. As I'm not near a computer right now, > I can't offer much more than a pointer in the right direction. > Old machine $ dconf dump /org/gnucash/ > /home/liz/gnucash-dconf $ scp /home/liz/gnucash-dconf l...@192.168.xxx.xxx:/home/liz/gnucash-dconf New machine $ dconf load /org/gnucash/ < gnucash-dconf The last matter of the date settings was that when the locale was set in Debian the default went to "none" instead of en_AU. Running "dpkg-reconfigure locales", not adding any and setting the default locale was necessary to fix that. Liz ___ 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] How to transfer all my accounts etc. to new computer. Linux version
On Sun, 13 Aug 2023 16:50:26 +0200 "Frank H. Ellenberger" wrote: > Updated. BTW the FAQ is a terrible place because it is hard to > maintain. In most cases wiki's search offers more recent topics. I deliberately chose the FAQ because it was recommended to the Windows user changing computers. It's far too long and contains a lot of information. I can understand that it is hard to maintain. Liz ___ 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] Consolidation of family member accounts
On Sun, 13 Aug 2023 17:04:26 + Paras Desai wrote: > 4. Neither is a good practice, as at family level, it will > erroneously show duplicate expenses (mine as gift to wife and, wife's > actual expenses with gifted fund) consider another reason it is not good practice 5. At some time I anticipate your son will leave home and set up an independent household. Having to disentangle accounts at that time would be very difficult. Liz ___ 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] GNU Cash for Android
On Wed, 16 Aug 2023 18:01:15 + Paras Desai wrote: > I looked for Android fork for GC and was presented with two apps > 1. GNU Cash > 2. GNU cash mobile. > > I think they are independent and not connected with GC ORG. > > However, I just wish to understand if I use any of the two android > app just for basic day to expense posting, sync with say.. gdrive. > And on desktop, if I access the file from gdrive folder (synced), > then my account stays in sync. Is this possible with kind of GNU cash > file structure.? > > Thanks > > Paras > > I did once use gnucash for android. I could export a file and import that into my desktop. It wasn't worth the trouble, as others have mentioned, making a note on your phone is just as easy to handle. I now have a policy of asking for a paper receipt or an emailed receipt. Liz ___ 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.
