Re: [GNC] Order listing in account by "Transfer"? Select and modify multiple?
Sure, you can run a report and open registers from the hyperlinks, but that isn’t strictly necessary. You can just open the register directly. You may not even need to do so if you do a Find operation first. The results from the Find are given in a separate tab in the form of a register containing all of the found transactions. The basic field searches are pretty good, but you can also use regex for advanced pattern matching. When I’m moving transactions I use this method to get my target list for moving and then start plowing through. There are two options: 1. Move an entire account via deletion and re-assignment 2. Move one transaction at a time There is no way to move a subset of transactions in an account in bulk. Regards, Adrien > On Apr 30, 2020 w18d121, at 9:22 PM, flywire wrote: > > Adrein, thank you for those tips. > > I've simplified the example too much. There are multiple accounts, some > with more than a handful of transactions to be moved, but your workflow > seems to work using the transaction report to open up the account register. > I understand you're suggesting if the bulk of transactions need to be > reassigned the same way them reassign the others first then delete the > account to reassign the bulk. > > Am I right that I can view groups of transactions, eg an account, but only > actually select one at a time so they need to be moved one at a time (other > than the delete account tip above )? ___ 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] CVS Import of Security Transaction
Matthew The CSV importer is described reasonably fully in Ch6 of the help manual https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html. The mulitiline format used to export GnuCash data is described in the following section on exporting https://www.gnucash.org/docs/v3/C/gnucash-help/trans-export.html#trans-export-summary. Some fields in the export data can be left blank on import. Typically the TransactionID, Num, Notes, Void Reason, Action, Memo, Full Account Name, Reconcile, Reconcile Date and Account with Sym are fields not normally present in import data except in data which has been exported from GnuCash in the GnuCash Export Format. If the import data is multiline-multisplit as per the export data the account being imported is specified in the first line. Your example would be: Date Account Commodity/Currency Amount Num Price 01/01/2020,XYZ, XYZ, 5, 7.00 ,BANK, ,35.00, 1.00 The spaces are only there to align with the headers so it will look like: 01/01/2020,XYZ,XYZ,5,7.00 ,BANK,,35.00,1.00 in the actual file. You could specify the commodity/currency for the bank in the second line if you are using a foreign currency account for the transaction. Otherwise AFAIK it defaults to the currency of the parent of the stock account. When you do the import, the first step maps names in the account field onto accounts as setup in the in the CoA. If using the simple single line format you can either specify the account (Account header) and the transfer account (Full Category Path header) or leave the Account field out and specify it in the importer setup. Save your import settings with a name and you can just select them next time. Make sure the date format in the importer dialog matches the date format in your file. David Cousens David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Online banking breaks after upgrade to Fedora 32 - error on executing job. status: enqueued (1)
> On May 4, 2020, at 1:07 PM, Daffy Duck wrote: > > Hello, > > I'd been using online banking forever, but since upgrading to Fedora 32 > last week, I now get this error when I try to fetch transactions: > > error on executing job. status: enqueued (1) > > It shows in a popup. > > If I go into online banking setup and try to retrieve accounts, it just > crashes. > > gnucash-3.10-1.fc32.x86_64 > > aqbanking-6.0.1-2.fc32.x86_64 > > gwenhywfar-5.1.2-2.fc32.x86_64 > > Any ideas? Yes, AQBanking between 5.99.0 and 6.1.4 doesn't work with OFX DirectConnect. https://bugzilla.redhat.com/show_bug.cgi?id=1830609 Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Online banking breaks after upgrade to Fedora 32 - error on executing job. status: enqueued (1)
Hello, I'd been using online banking forever, but since upgrading to Fedora 32 last week, I now get this error when I try to fetch transactions: error on executing job. status: enqueued (1) It shows in a popup. If I go into online banking setup and try to retrieve accounts, it just crashes. gnucash-3.10-1.fc32.x86_64 aqbanking-6.0.1-2.fc32.x86_64 gwenhywfar-5.1.2-2.fc32.x86_64 Any ideas? ___ 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] Scheduled transactions
This might be the bug I reported (though now fixed, not sure of in which release) of being unable to edit SX with a split assigned to a now deleted account. It seems the editor is not seeing the account at all. (was it deleted?) Try re-assigning the offending split to a different account. (I also could not do this) Try tabbing through the split and deleting memo, account and amount/formula. Even if you need that split, see if you can remove it. Then edit the SX again if needed to add it back. Regards, Adrien > On May 4, 2020 w19d125, at 10:48 AM, augras wrote: > > Hi, > I can't delete or de-activate. > I get the message Couldn't parse sx-debit-formula for split "" and when > closed the message Unparsable formula in split, split with memo has an > unparseable debit formula > Philippe ___ 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] Record Loan Interest
Most loans (certainly mortgages) aren't allowed to grow like this, so the manual doesn't cover it. When your interest accrues, it will look like this: Credit cards, lines of credit, etc. do This is less a gnucash question than a fundamentals question, and once I show you what you might want in the CoA for this type of loan, how you enter transactions should become obvious. The point is that here you may want to track principle and interest separately. Thus : Line of Credit (under liabilities) Principle (child of Line of Credit) Interest (child of Line of Credit) You are confusing the difference between cash basis accounting and accrual basis accounting by thinking that physical cash has anything to do with it << you are thinking about "cash flow" >> Thus if you bought a car (asset) by borrowing the money, you debit car and credit loan NOW (even though no physical cash changed hands). In your case, you should debit "interest expense" and credit the loan when they charge you the interest. You had an expense that you paid for by assuming liability as of that date. I point this out because often "line of credits" come with what look like checks. You might acquire an asset or pay an expense with one of those instead of a check against bank account. You record a transaction like that when it happens, not at some time in the future when you might make a payment against that liability (THAT is a different sort of transaction, essentially a "transfer"). Accrual basis accounting is something quite different. I don't think you should worry about what it actually is at the moment. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scheduled transactions
Hi, I can't delete or de-activate. I get the message Couldn't parse sx-debit-formula for split "" and when closed the message Unparsable formula in split, split with memo has an unparseable debit formula Philippe -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Change account type by editing XML?
david whiting writes: > Assuming I have understood correctly, this still doesn't allow me to > change the account type. See attached screenshot of the Edit Account > dialogue after having moved an account to the top level. There might be a specific test for AR/AP, in case you have posted invoices -- ensure you have no transactions in there. > David >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] Record Loan Interest
On Mon, May 4, 2020 at 2:26 AM flywire wrote: > Sorry, another loan query. Going in circles and thoroughly confused by > https://www.gnucash.org/docs/v3/C/gnucash-guide/loans_mortgage1.html > which seems > to cut out before the interest is paid and flip to making a loan. > > I have a loan account (say $1000 Liabilities:Loan) and the interest is > calculated and added to the loan annually (say 30 June 19 $10 interest is > added to Liabilities:Loan). On 29 June I pay $9 from Assets:Saving and let > the rest increase the loan. Using cash accounting I need to track the $9 > Expenses:Interest-paid, and the current loan balance which is a combination > of principle and interest. > > Direction to the best place in the guide would be useful. > Most loans (certainly mortgages) aren't allowed to grow like this, so the manual doesn't cover it. When your interest accrues, it will look like this: Expenses:Interest $10 Liability:Interest $10 and since you don't pay off all the interest every month, your payment looks like this: Liability:interest $10 (this reduces the account to $0 interest) Assets:Checking $9 Liability:Note $1 Does that sound right? ___ 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] Payroll Report
On Sun, May 3, 2020 at 11:11 AM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 5/2/2020 11:40 PM, D. via gnucash-user wrote: > > Since each of the lines has its own account, that should be eminently > possible with a transaction report. I have something just like this to > track my personal wage situation--a W-2 in US tax parlance. It's just a > simple transaction report for the proper time period, using only the > accounts in question, showing totals only. > > > > I can forward a sample if you need more detail. > > > > David T. > > THAT is the key matter. Is the DATA for a report in the format shown > available from gnucash. > > It would be possible for us programmer types to create a report from > within gnucash to do this. But as I have pointed out many times, when I > began with gnucash was advised "don't bother". Just export the DATA out > of gnucash and use a favorite full power editor to create the pretty > printed finished report as requested. > > The reason is that there will always be another special report wanted*. > No end to the possibilities, which is why I was advised not to bother > trying. > > Michael D Novack > > * Mind, in my working days, creating special reports wanted by a client > was one of my specialties. This is not quite the same situation. There > it was saving client time doing REPEATED work for the SAME report wanted > over and over. The problem here is that would NOT be the same finished > report. You have shown us how YOUR accountant wants it formatted (the > final pretty printed report) . That won't be the same format somebody > else's accountant wants it. > Thank you, Michael, Chris, and David. These are all helpful thoughts. I'll kick these around a bit and see what comes. ___ 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] CVS Import of Security Transaction
Dear Geert, Thank you very much for your quick reply. I can manipulate the data I have (e.g., via python) to get it into a csv format that works. Do you know what the lines of a csv file would look like for the following multi-split transaction? Account 1. Date "01/01/2020", stock account "XYZ", shares purchased "5", share price "7.00" Account 2. Date "01/01/2020", bank account "BANK", dollars withdrawn 35.00 Sorry I do not know something so basic, but I haven't seen these types of files/formats before. When I go to import such a CSV file, would I import it for the stock account, or maybe it doesn't matter? Thank you very much for your time and help. Sincerely, Matthew On Mon, May 4, 2020 at 7:09 AM Geert Janssens wrote: > > Op maandag 4 mei 2020 02:36:58 CEST schreef Matthew Clay: > > > Dear Gnucash Community, > > > > > > Sorry if I missed this in the documentation, but is it possible to use > > > the CSV importer for security (stock) transactions? When I attempt to > > > import a CSV file into a security account, in the drop-down menu to > > > indicate what the columns in the CSV file are used for, I do not see > > > "Share" or "Price" as options. I'd like to set the "Share" and "Price" > > > columns, and then have Gnucash calculate the "Buy"/"Sell" price and > > > the "Balance" of shares after the transaction. > > > > > > Sincerely, > > > Matthew > > > > The csv importer is fairly limited when importing share/price data or > multicurrency data. It depends a bit on the format of your import data. > > > > If the import data is multi-split (that is it contains the debit and credit > side of a single transaction in separate lines) and it contains a transaction > currency, the importer knows how to handle it. > > > > Single line import can have issues like these bugs: > > https://bugs.gnucash.org/show_bug.cgi?id=796955 > > https://bugs.gnucash.org/show_bug.cgi?id=797450 > > > > So your mileage may vary. > > > > Regards, > > > > Geert ___ 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] CVS Import of Security Transaction
Op maandag 4 mei 2020 02:36:58 CEST schreef Matthew Clay: > Dear Gnucash Community, > > Sorry if I missed this in the documentation, but is it possible to use > the CSV importer for security (stock) transactions? When I attempt to > import a CSV file into a security account, in the drop-down menu to > indicate what the columns in the CSV file are used for, I do not see > "Share" or "Price" as options. I'd like to set the "Share" and "Price" > columns, and then have Gnucash calculate the "Buy"/"Sell" price and > the "Balance" of shares after the transaction. > > Sincerely, > Matthew The csv importer is fairly limited when importing share/price data or multicurrency data. It depends a bit on the format of your import data. If the import data is multi-split (that is it contains the debit and credit side of a single transaction in separate lines) and it contains a transaction currency, the importer knows how to handle it. Single line import can have issues like these bugs: https://bugs.gnucash.org/show_bug.cgi?id=796955 https://bugs.gnucash.org/show_bug.cgi?id=797450 So your mileage may vary. Regards, Geert ___ 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] Build ID: 3.3+ (2018-09-29) can't unvoid transactions
On 4 May 2020, at 06:17, Gene Selkov wrote: > > Hello, > > After a botched csv import, I have a bunch of empty transactions that are > marked read-only. I can't delete them; the explanation is that they have > been voided. I tried the Unvoid Transaction menu on one of them, with > no success. It did nothing. > > I guess I could export the database as sqlite, track down and delete those > transactions, then re-import the remainder, but that appears to be a > tedious job, given the way splits are laid out in the db. Is there an > easier way to do that? > > Thank you, > > —Gene Revert to the most recent backup before the csv import went wrong? Michael ___ 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] Record Loan Interest
Sorry, another loan query. Going in circles and thoroughly confused by https://www.gnucash.org/docs/v3/C/gnucash-guide/loans_mortgage1.html which seems to cut out before the interest is paid and flip to making a loan. I have a loan account (say $1000 Liabilities:Loan) and the interest is calculated and added to the loan annually (say 30 June 19 $10 interest is added to Liabilities:Loan). On 29 June I pay $9 from Assets:Saving and let the rest increase the loan. Using cash accounting I need to track the $9 Expenses:Interest-paid, and the current loan balance which is a combination of principle and interest. Direction to the best place in the guide would be useful. ___ 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.