Re: [GNC] QIF imports fails in 5.6
Luckily, OXF & CSV still work. bit more stuffing around, but actually easier to view what is happening. You need to tell the import the account on CSV, but it seems easier to select the accounts that I am transferring to so I might continue using csv imports. regards, Doug (long, long time Australian user & a Thank you to the developers) On Sat, 27 Apr 2024 21:30:38 +1000 Geoff wrote: > Hello Nodje > > Please read this: > > https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111431.html > > Regards > > Geoff > = > > On 27/04/2024 3:21 pm, coolnodje wrote: > > Hi, > > > > QIF imports is failing in 5.6. > > I had to revert to 5.5 to be able to be able ro import as usual. > > > > The error message is "Missing QIF investment action for transaction > > dated 02.04.2024." > > > > Let me know how can I help, I'm unsure where to find more meaningful logs. > > > > /nodje > > > > ___ > > 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. > ___ > 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. ___ 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] find and replace
Just a quick idea: Perhaps you can do a sort on the known string of memo text. Next, as you edit & change categories, also edit the text (perhaps add a star or something in the middle) The search should drop that item then You can also look in the unassigned category. As you change fields from unassigned to another category, they will drop out of unassigned. regards, Doug (nb: I am no expert! but there is always a way) On Sat, 30 Jan 2021 11:13:33 -0800 gnu Gord wrote: > Is it possible to find a specific split transaction based on the memo field > and assign the account to transfer for that split item? > > Let me explain. I'm new to GnuCash and have just imported my Quicken data > QIF file but it appears that some transactions within splits have no > transfer account assigned. It appears that I did not have a category > assigned to them in Quicken. However, most seem to have the same memo text. > There are really too many to do manually so some sort of find/replace would > be helpful. If it's not possible within GnuCash, can the XML file be edited > directly? > ___ > 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. -- Doug ___ 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] What is the purpose of hidden accounts?
Hi, I can only mention my own use of hidden accts: I have used Gnucash since 2003 abt, & my old accts get moved to a holder place (in my case ´´ for reasons that might be obvious!) These accts still exist, but are hidden in reports. Good to keep them for historical accounting purposes. (such as in Australia, calculating Capital gains tax) regards, Doug On Sun, 22 Aug 2021 05:13:17 + Tim Hume via gnucash-user wrote: > Hi everyone, > > In GnuCash one can create a hidden account. What legitimate purposes are > there for hidden accounts? > > Regards, > > Tim. > > Sent with ProtonMail Secure Email. > ___ > 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. -- Doug ___ 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] Moving Sub-Accounts???
First, I am a user, not an X-pert! You can easily move accounts by editing them. (This lets you select where they go). You can set up a placeholder account first, so you can attach accounts under that placeholder. If you want to move all transactions from one account to another, set it up as a sub account first. Then delete the account & the transactions move to the account above. (I think this is undocumented, so use at your own risk!) this is good when you want to combine accounts. Sounds like you are a new user. Keep in mind that you can use maths to split deposits: this is useful where you split amounts into known amounts (eg 1/3rd) I find this useful where tax amounts are split into personal & tax claimable for instance. (btw, download the documentation package: there is a LOT of useful info there!) good luck! Doug (long time Gnucash user that fumbles along!) On Sat, 4 Sep 2021 14:57:42 -0400 "Nora" wrote: > Hello All > > Is it possible to move income sub accounts to other "place holder" income > accounts. > I want to change the hierarchy and regroup AFTER I've set it all up. > Thanks again! > Nora > Ps > I tried a transfer of 'income' monies to the "new income sub-account" but > it didn't let me. > THX. > Nora > > ___ > 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. -- Doug ___ 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] Default Accounting period permanent change (Ver 4.6 still..)
Hi, has anyone changed the default accounting period in the reports window? Currently they are set to 1 Jan to 31 Dec. Australian Tax year is 1 July to 30 June. I know I can set them report by report, but it would be nice to change the defaults. I am currently using ver 4,6 on Linux (PCLinuxOS, which I have been using for years & love!) regards, Doug (Long time Gnucash user & appreciator!) -- ___ 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 Accounting period permanent change (Ver 4.6 still..)
Thanks Alan. Yes, knew that. I am certainly no accountant, but manage to bumble along. I think it might be possible to set the defaults in the setup file, but honestly have not looked. What I would like is to be able to define the Financial Year start/Financial Year end in setup so it always defaults to the current financial year ()which in Australia´s case is 1 July to 30 June). I wonder how many other countries have non-Calendar year Financial years? I guess the UK might copy us seeing we seem to copy their laws in our early days. regards, Doug n Sat, 9 Oct 2021 13:32:07 +1100 Alan Hopkins wrote: > Hi Doug > > Nice to hear from another Aussie PCLOS & GNUCash user! > > I have the same version of GNC as you (as that's what is in the repo!) - I > haven't been using GNC for long but I set the accounting period in the > Preferences as Absolute to 1st July 20 to 30 Jun 21 (ie last fin year) and it > defaults the reports (Beginning & End of Accounting Period) to the correct > dates. I will need to change that for this fin. year (and those that follow) > as it is an absolute setting but I don't see that as problem. > > Another alternative would be to set the dates in the Report Options and then > save that report configuration so when you use it the report has the default > settings you want. > > But I guess you know all the above being a long-time GNC user! > > My thanks to the GNUCash gurus, facilitators & fixers - GNC is a terrific > resource!! > > Cheers > > Hop > > On 9/10/21 10:25, Doug wrote: > Hi, > > has anyone changed the default accounting period in the reports window? > > Currently they are set to 1 Jan to 31 Dec. Australian Tax year is 1 July > > to 30 June. > > > > I know I can set them report by report, but it would be nice to change the > > defaults. > > > > I am currently using ver 4,6 on Linux (PCLinuxOS, which I have been using > > for years & love!) > > > > regards, Doug (Long time Gnucash user & appreciator!) > > > > > -- ___ 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 Accounting period permanent change (Ver 4.6 still..)
Thanks, that is the type of setting I want, but the documentation says it all: to quote: I've been using this hack which changes the definition of current and previous year in reports to start 1 July. It will be overwritten each time a new version of GnuCash is installed and it's unlikely to work with the next major release. (end) I feel what is needed is for it to be a part of the configuration settings window. Until implemented. I will just set the dates for each report. I am certainly no programmer regards, Doug On Sun, 10 Oct 2021 11:15:51 +1100 flywire wrote: > Hack Financial / Fiscal Year in all Reports - > https://lists.gnucash.org/pipermail/gnucash-user/2021-October/097880.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] question from newbie
Similar comment, by a non-accountant. What I do with transactions that are planned is to enter them when I place the forward transaction with the bank, & set the date as when the account will be paid (or transferred). I can always see the current day balance by looking at the dividing line on the account at todays date. Recurring expenses such as loan payments, periodical payments etc are copied using the duplicated transaction, then edited if required. This is handy for transactions with multiple splits (such as your pay if employed), where the amounts might change, but the splits remain fairly consistent (albeit with changed amounts). eg in my case for deposited weekly pay (before I retired!) I had (to give an idea) Total pay> Income; Tax> Tax; Superannuation> Super; various benefits & payments such as Union fees> relevant accounts. By using a duplicated transaction, it is easier to remember exactly how the splits are distributed. Hope that helps Mr Newbie! regards, Doug On Sun, 7 Nov 2021 10:42:10 + Michael Hendry wrote: > On 6 Nov 2021, at 21:40, Shevach Pepper wrote: > > > > Hello there, > > 'I'm having trouble on how to record buying groceries on Jan. 1 with a > > head check for Feb. 1 > > What I understood from the manual that this is not an expense but a > > liablity but I don't understand if I should make two accounts one > > expense: grocery and one "liability: grocery" or some easier way to > > record this. > > Thank you very much for the help > > Shevach > > gif > > I’m assuming a “head check” is what we in the UK would call a post-dated > cheque - a cheque which can’t be cashed until a stated date; for what it’s > worth, I understand that banks in the UK will often make the payment if the > cheque is presented early. > > I would suggest recording the expense on the date of the purchase as a > transaction between your checking account and the grocery store. If you wish, > you could add a note to indicate that the check can’t be presented until 1st > Feb to avoid confusion when reconciling the bank account. > > It’s a similar situation to making a postal payment by check - you know that > the payee won’t receive it for several days and may not take it to the bank > for several days after that, but you’re recording your commitment to the > payee rather than the date on which the bank transfers the money to his > account. > > I am not an accountant, but there are those on the list who will no doubt > correct me if there are problems with the way I view this! > > 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. -- ___ 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: GnuCash 3.0 Released
Thanks for the hard work. I will report the upgrade to PCLinuxOS (my distro of choice for many years). regards, Doug (Australia) On Mon, 2 Apr 2018 15:49:10 -0500 C M Reinehr wrote: > John, > > Thanks for all your hard work. GnuCash is an invaluable piece of software. > > Cheers! > > CMR > > > On 04/02/2018 03:17 PM, John Ralls wrote: > > GnuCash 3.0 released > > > > The GnuCash development team proudly announces GnuCash 3.0, the first > > release in our new 3.x stable series. > > New Features for Users: > > > > The headline item for this release is that GnuCash now uses the > > Gtk+-3.0 Toolkit and the WebKit2Gtk API. This change was forced on us by > > some major Linux distributions dropping support for the WebKit1 API. > > Unfortunately the Webkit project doesn't support Microsoft Windows so that > > platform will continue to use the WebKit1 API, though with Gtk3. We've > > selected Gtk+-3.14.0 as the minimum version because it fully supports CSS > > theming. > > New editors to remove outdated or incorrect match data from the import > > maps, a new user interfacs for managing files associated with transactions, > > an improved facility for removing old prices from the price database, and a > > way to remove deleted files from the history list in the file menu. > > New Reports: A Reconciliation Report based on the Transaction Report,a > > Income GST Report, and a Cashflow Barchart report. > > A new CSV importer largely rewritten in C++, adding new features > > including the ability to re-import CSV files exported from GnuCash, along > > with a separate CSV price importer. > > A new preference panel for the Alphavantage API key so that > > Finance::Quote users need not edit /etc/gnucash/environment. We've removed > > all references to the various Yahoo! quote sources and made Alphavantage > > the default. > > Data file directories are now located appropriately to the operating > > system's conventions by default: > > Windows: CSIDL_APPDATA/Gnucash > > MacOS: $HOME/Application Support/Gnucash > > Linux: $XDG_CONFIG_HOME/gnucash (or the default > > $HOME/.config/gnucash) > > It's still possible to overried with the environment variable > > GNC_DOC_PATH, which replaces GNC_DOT_DIR in earlier versions of GnuCash. > > Accounts in the Bayes import map are now linked by GUID instead of > > names so that the matcher won't have to be retrained if you rename an > > account. The Bayesian import maps are also stored in a flatter structure to > > allow faster access, especially in SQL. These changes mean that if you have > > Bayesian mapping data, once converted your database will be loadable only > > by GnuCash 2.6.20 and later. > > MySQL and SQLite3 date storage has changed a bit. Once converted, > > MySQL and SQLite3 database will be loadable only by GnuCash 2.6.19 and > > later. > > Numerics are rewritten to allow for more significant digits. The old > > 6-digit-maximum fraction is now 9-digits, and prices may have up to 18 > > digit precision. > > Chart Reports appearance is improved, including more modern chart > > colours as suggested by http://clrs.cc/. > > Transaction Report improvements, including regular expression > > filtering and many more options and features including a "Subtotal Summary > > Grid" The subtotal summary-grid will tabulate subtotals - prime-sortkey > > vertically, sec-sortkey horizontally. For example, with prime-sortkey = > > accounts, sec-sortkey = date, sec-subtotal = monthly will produce a monthly > > time series table. > > The About dialog box layout is improved and now includes the detected > > Finance::Quote version. > > GnuCash will always build the locale-specific tax modules. This was > > optional when building with autotools and never enabled when building with > > cmake. Note that the only supported tax locales are en_US and de_DE. > > On Macs the Reconcile Window's menu moved to the menubar. > > GnuCash no longer supports Guile-1.8 and now does support Guile-2.2 > > > > New Features for Developers: > > > > Several parts of the engine and the SQL backend are rewritten in C++, > > an effort that will continue in the next development cycle. KVP is now > > private to libgncmod-engine and accessible outside via qof_instance_set and > > qof_instance_get. KVP and GUID are reimplemnted in C++ using boost::variant > > and boost::UUID r
Texhad an issue compiling for PCLinuxos....
Offline Tex Administrator Super Villain ** Posts: 18933 Space City, Tx View Profile Personal Message (Offline) Re: GnuCash « Reply #2 on: Today at 01:28:20 AM » Quote I've spent hours on this and this is what it gives me even though the library is installed in /usr/lib64/gnucash. I'm tired of it for now. [tex@localhost SPECS]$ gnucash gnucash: error while loading shared libraries: libgncmod-gnome-utils.so: cannot open shared object file: No such file or directory (end) Can anyone help me point Tex in the right direction please? (I will forward it to PCLibuxOS) regards, Doug (not a developer! merely an intermediary...) ___ 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.
Issue compiling: any assistance?
Tex, the Administrator of PCLinuxos struck a problem. Can you help please? (I am not a developer, but can pass any help on) regards, Doug Re: GnuCash « Reply #2 on: Yesterday at 01:28:20 AM » Quote I've spent hours on this and this is what it gives me even though the library is installed in /usr/lib64/gnucash. I'm tired of it for now. [tex@localhost SPECS]$ gnucash gnucash: error while loading shared libraries: libgncmod-gnome-utils.so: cannot open shared object file: No such file or directory -- Doug ___ 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 preferred OS - Windows or Linux
On Thu, 27 Jul 2023 03:14:07 -0500 my 2c worth: I have been running Gnucash on PCLinuxOS forever (or so it seems). They are usually up to date with releases. Currently Build ID: 5.3+(2023-06-26). Loaded weeks ago. Love both Gnucash, & PCLinuxOS: they both just work! Only thing I could have used was GST support(a VAT type tax used in Australia) when I was running a business, but now I am retired, who cares! (the go-go years, the slo-go years, then the no-go years! Currently towards end of go-go... Thanks to the Developers for the support over the years. regards, Doug Ben Kamen wrote: > On 7/26/23 7:55 AM, Mark at Lorimark wrote: > > I am a staunch Linux user, and came from the Quickbooks world as well. I am > > running a very small database, but have it in the sqlite, since that (for > > me) is very easy to work inside of if i need to poke around in the database > > (which I do). > > > Which version of Linux? And are you compiling or running flatpak or distro > supplied versions? > > > > > > I much prefer the 'double entry' approach to things rather than the bubble > > wrapped QB environment > > I always worry about missing something somewhere. > > > > > and yes QB is getting expensive! > > It's irritating as the pricing jump is so obviously designed to push users to > their web product and it's just gobsmacking that anyone at a financial > software company would think it's a good idea to put one's financial life > onto cloud services. (whether personal or company/business) > > And then there's Intuit. Go figure. > > Insane. > > > > I can't imagine any functional difference between any of the platforms as > > it pertains to GnuCash. > > Yea, I just have to keep plugging at it to figure out how to make everything > work for me. > > Thanks, > > -Ben > > ___ > 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. ___ 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] Is there an 'easy' way to have a transaction with 'sub-transactions' as it were?
Chris, I am no Gnucash or accounting x-pert, but how I perform a similar task is to just do a total import, to ´Unspecified´. Then I duplicate another transaction with similar splits, to the same date (so in you case, the previous weeks transaction). Then I manually do the split in that transaction, finishing with deleting the original import (which was only there as a ´memory prompt´ anyway). In my case, I use this for importing my wife´s salary, where the variations are usually relatively minor. Would love to know if someone does a similar task in a more efficient way. Keep safe! (from Covid) regards, Doug (Australia) On Tue, 8 Sep 2020 15:29:41 +0100 Chris Green wrote: > I'm feeling my way with these PCC accounts but I do feel as if GnuCash > will do quite well for me. > > Anyway, next silly question, two of our income streams are > 'Collections in services' and 'Offertory Box'. These are (currently) > recorded separately in the accounts but get paid into the bank > together. So, for example, I have for one Sunday in January a > collection of £48.00 and £10.50 in the offertory box which get paid > into the bank on a single paying in slip of £58.50. > > Is there a way of recording the amounts as two income entries but as > only one bank account credit? > > Obviously I could simply record two transactions with the same paying > in slip reference number, not that onerous, I was just hoping there > might be an easier/better way. > > In the long run it may well be that they're only recoroded separately > because "it was always done that way" but I don't want to rock the > boat too much! :-) > > -- > Chris Green > ___ > 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. -- Doug ___ 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] Ubuntu distribution version
Derek, I run PCLinuxOS, & it is Gnucash ver 4.1. I have been a happy PCLinuxOS user for about 15 years. I love PCL because it just works. Try it off a USB drive, or SD card. (I run Ubuntu on my Energy server, & must say I prefer PCL! Emoncms (that I use) is set up for Ubuntu, so too hard to change for me...) regards, Doug On Sat, 22 Aug 2020 15:20:49 -0400 Derek Zehr wrote: > Hello Fellow GnuCashers, > > I installed GnuCash from Ubuntu software (Ubuntu 18.04), and it is > version 2.6.19. But I see the latest release on gnucash.org is 4.1. Why > is mine so far behind, and when can I expect the upgrades to come > through Ubuntu's distribution? > > Thanks, > > Derek Zehr > > ___ > 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. -- Doug ___ 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 treat accommodation security deposit
Tony, I am no Accouintant, but the way I would attack it is to set up a cash account for the bond (security deposit), then split the payment into bond & rental (into another account, or as a Draw). When the bond is returned, that credits into the bond account, hopefully leaving it at zero balance. (hint: the account can then be hidden if you no longer need to see it) I also have old ´sleeper´ accounts: a hidden main account (bit obvious: a snooze!) then drop old unused accounts into that main account. Keep safe! regards, Doug (in sunny, relatively covid free Australia) On Sun, 22 Nov 2020 15:29:36 +0700 Tony Vanson wrote: > Hi all, > Using Windows 10 Home > GC 4.2 > > I anticipate renting a property for 1 month and will pay the rental up > front plus a security deposit amount which will be returned at the finish > of the rental period. I am totally in the dark how to approach this. > Do I need some kind of split? The rental expense is a straight forward > expense, but how do I input the security deposit - I tried it as an asset > but that didn't work and doesn't seem right. Various other things i tried > usually came up with an Imbalance entry. > I would really appreciate some guidance on this. > Cheers > > -- > *Tony Vanson* > > *The older I get,* > *the better I was* > ___ > 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. -- Doug ___ 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] Thank you
Lyndon, it has worked in Aus for many years! So long that I cannot remember the first version I used. (One of my old loans was dated 1995 to give an idea) I used to run a business & when GST was introduced, it was a bit of a pain, but not impossible. Now I have retired, I use it to manage my bank accts & a rental property. There are some things I would like to see, but they are not a deal breaker to me: -Management of GST for Australia (I think A similar system runs in NZ & other countries too). What this requires is putting the 10% GST in a management acct, then managing the remittance to the Tax Office. Also being able to manage changes/mistakes. -Yearly Tax Management, in Aust case, July 1 to Jun 30. (Prebuilt but editable filters that exported the data for Tax to a spreadsheet that I could give to my accountant would be great too.) Perhaps in future releases these could be covered: There are many countries using Value-added taxes, so a way of plugging in the rates (ie dividers), then how it is managed would mean it would have general use. The Yearly rollovers, & the tax management might also be covered with a rate table. I have had little success exporting successfully to a spreadsheet, but that is probably my lack of skills. One advantage of the full history of the accounts is when a property is sold: all the old figures are at your fingertips which is much easier than the other well known commercial products (which do not easily run on Linux anyway). I am a PCLinuxOS user, also for many years (Easy to use & recommended too). I also would like to thank the developers. I have seen the advancements over the years. The program is now far more polished than the early versions. I have had hiccups, but never lost any data in 25 years! regards, Doug (Nth Coast, NSW, Australia, near Byron Bay. Someone has to put up with this lifestyle: sunny one day & perfect the next!) On Mon, 2 Sep 2019 05:34:52 -0500 (CDT) Lyndon wrote: > I just want to say thank you to the wonderful people who have given of their > time so freely to produce this superb programme. > > It even works here in Australia! > > Lyndon > > > > -- > 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. -- Doug ___ 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] Thank you
Thanks Adrien. Every year I need to send my data to my accountant who does not (yet) use Gnucash. I did not have any success exporting to .qif files: not sure why. (Would not read into Quickbooks) I thought a spreadsheet might be better way to go. This is a new accountant because my last accountant retired (at 85! & still runs a farm: tough people these rural folk). Previously I supplied hard copy reports because they were old-school. The new accountant is quite happy for electronic version, but last year I had no success with her reading my files. Basically, I have always prepared a report on each account for the 12 months which detail my tax deductible transactions. I am no accountant, & even tho I have used Gnucash for years, I still have issues every tax year but usually bumble through. regards, Doug On Tue, 3 Sep 2019 13:14:05 -0500 Adrien Monteleone wrote: > Regarding the export, > > What is the purpose of the export and what data are you trying to get out? > (there might be a way to craft a report in GnuCash that shows the same info) > > What are the steps you are currently taking to do the export? > (copy/paste/save report results or export -> CSV) > > Finally, what spreadsheet app are you using to read the exported data? > (Libreoffice Calc, Gnumeric, something else?) > > Regards, > Adrien > > > On Sep 3, 2019 w36d246, at 7:26 AM, Doug wrote: > > ... > > > > I have had little success exporting successfully to a spreadsheet, but that > > is probably my lack of skills. One advantage of the full history of the > > accounts is when a property is sold: all the old figures are at your > > fingertips which is much easier than the other well known commercial > > products (which do not easily run on Linux anyway). I am a PCLinuxOS user, > > also for many years (Easy to use & recommended too). > > > > > > I also would like to thank the developers. I have seen the advancements > > over the years. The program is now far more polished than the early > > versions. I have had hiccups, but never lost any data in 25 years! > > > > regards, Doug (Nth Coast, NSW, Australia, near Byron Bay. Someone has to > > put up with this lifestyle: sunny one day & perfect the next!) > > > ___ > 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. -- Doug ___ 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] Thank you
Adrien, one thing that would help in Australia is in the setup to be able to set the year start as 1 July, & end as 30 June. Currently the only options are the beginning of the year, monthly, quarterly, or absolute. I usually use absolute, resetting each year. regards, Doug On Wed, 4 Sep 2019 23:09:55 +1000 Doug wrote: > Thanks Adrien. Every year I need to send my data to my accountant who does > not (yet) use Gnucash. I did not have any success exporting to .qif files: > not sure why. (Would not read into Quickbooks) > I thought a spreadsheet might be better way to go. > > This is a new accountant because my last accountant retired (at 85! & still > runs a farm: tough people these rural folk). Previously I supplied hard copy > reports because they were old-school. > The new accountant is quite happy for electronic version, but last year I had > no success with her reading my files. > Basically, I have always prepared a report on each account for the 12 months > which detail my tax deductible transactions. > I am no accountant, & even tho I have used Gnucash for years, I still have > issues every tax year but usually bumble through. > > regards, Doug > > > On Tue, 3 Sep 2019 13:14:05 -0500 > Adrien Monteleone wrote: > > > Regarding the export, > > > > What is the purpose of the export and what data are you trying to get out? > > (there might be a way to craft a report in GnuCash that shows the same info) > > > > What are the steps you are currently taking to do the export? > > (copy/paste/save report results or export -> CSV) > > > > Finally, what spreadsheet app are you using to read the exported data? > > (Libreoffice Calc, Gnumeric, something else?) > > > > Regards, > > Adrien > > > > > On Sep 3, 2019 w36d246, at 7:26 AM, Doug wrote: > > > ... > > > > > > I have had little success exporting successfully to a spreadsheet, but > > > that is probably my lack of skills. One advantage of the full history of > > > the accounts is when a property is sold: all the old figures are at your > > > fingertips which is much easier than the other well known commercial > > > products (which do not easily run on Linux anyway). I am a PCLinuxOS > > > user, also for many years (Easy to use & recommended too). > > > > > > > > > I also would like to thank the developers. I have seen the advancements > > > over the years. The program is now far more polished than the early > > > versions. I have had hiccups, but never lost any data in 25 years! > > > > > > regards, Doug (Nth Coast, NSW, Australia, near Byron Bay. Someone has to > > > put up with this lifestyle: sunny one day & perfect the next!) > > > > > > ___ > > 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. > > > -- > Doug > ___ > 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. -- Doug ___ 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 Initial Setup Q's
I have been a long-term non-professional Gnucash user in Australia. I guess, I am like you in that I felt the cost of the Quicken products was a bit excessive. I changed to Gnucash possibly 12 years ago. The only issue I would like to see is an ability to track Business GST, but this is no longer an issue for me because I have retired. My suggestion for tracking a 'Home inventory' would be either to set up an asset for each one, or if low value, congregate them in one asset class. You can put some information in the description so you can search for items. You could also export the account details to a Spreadsheet, & attach photos, etc there. I think you should find all the accounts should move over fairly easily from Quicken. If you need to aggregate accounts, the trick is to set up the main account, then shift the other accounts in as sub-accounts. Then each transaction can be moved fairly easily (At least that is the way I do it!) I run Gnucash under Linux: I love PCLinuxOS! which I have used for many years. regards, Doug On Sat, 24 Nov 2018 00:34:33 +1030 Xboxboy Mageia wrote: > Hi all: Great to see how active the mailing list is. > I'm in the process of getting all my finances into gnucash. > Up until know I've been using a spreadsheet to track all my shares/stocks, > fund and interest income. > I've read and continue to read the guide and principles, and I run my > business through MYOB, which is also a double entry system. > But, I still have plenty of questions as I get settled in. > The first is, I've got an old edition of Quicken Personal plus, which I've > read the manual, and a really handy feature I seen was what they call "home > inventory". This is used to keep track of items of value that aren't > traditional stocks/bonds etc. This is particularly useful for insurance > purposes, which I currently have a scrappy spreadsheet for also. Can anyone > advise how to set this up, or if I'm missing something, and this function > is already set to go? > Many thanks > ___ > 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. -- Doug ___ 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] "no linked account" during transaction import
Hello. Newbie here. I'm attempting to "Import Transactions from CSV" Transactions are formatted as, for example: Account Date DescriptionAmount Expenses:Auto:Gas 1/1/2019 Shell Service 70 Expenses:Clothes1/1/2019 Ann Taylor 50 Expenses:Internet 1/1/2019 Comcast50 Expenses:Dining 1/1/2019 McDonald's 4.50 At "Import Preview" I map the Transaction.CSV" column names to GnuCash field names directly (name = name) except "Amount" maps to "Withdrawal". At "Match Import and GnuCash accounts" I receive "No Linked Account" for all transactions. I would have thought(?) that the Transactions.CSV "Account" name corresponding exactly to the GnuCast account name would have auto-matched. Am I wrong about that? How do I avoid having to manually make a mapping for each and every transaction? Thanks! Doug Pearson ___ 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] Unable to get TIAA-CREF price quotes
Linux Mint v. 20. GNUCASH v. 4.2Finance::Quote v. 1.56 When I update the price Data Base it fails to retrieve TIAA-CREF quotes. The Security Editor is set up as follows: Running gnc-fq-dump gives the following result: doug@sager:~/src/gnucash-5.1$ gnc-fq-dump tiaacref QCBMPXFinance::Quote fields Gnucash uses: symbol: QCBMPX (deduced) <=== required date: ** missing ** <=== recommended currency: ** missing ** <=== required last: **missing** <=\ nav: **missing** <=== one of these price: **missing** <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! Any thoughts? ___ 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] Unable to get TIAA-CREF price quotes
Yes. That does work. Although it takes a very long time to get a response from Yahoo. Like three minutes. That may be a function of my slow internet connection. Thank you very much, Dale. Doug On Wednesday, July 5, 2023 at 07:20:02 PM GMT-7, Dale Alspach wrote: Have you tried using Yahoo as JSON to retrieve TIAA prices? This works for all of mine. I don't know about that particular one. Dale On Wed, Jul 5, 2023, 7:06 PM doug brown via gnucash-user wrote: Linux Mint v. 20. GNUCASH v. 4.2Finance::Quote v. 1.56 When I update the price Data Base it fails to retrieve TIAA-CREF quotes. The Security Editor is set up as follows: Running gnc-fq-dump gives the following result: doug@sager:~/src/gnucash-5.1$ gnc-fq-dump tiaacref QCBMPXFinance::Quote fields Gnucash uses: symbol: QCBMPX (deduced) <=== required date: ** missing ** <=== recommended currency: ** missing ** <=== required last: **missing** <=\ nav: **missing** <=== one of these price: **missing** <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! Any thoughts? ___ 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. ___ 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] Finance::Quote terminal commands not working with Flatpack v:5.3 install
I installed via flatpack Gnucash v. 5.3 on Linux Mint v. 20 OS and the terminal commands that I previously used to find sources for quotes on longer work. Here is the output: doug@sager:~$ gnucash-cli --quotes dump yahoo_json QCBMPXgnucash-cli: command not found doug@sager:~$ gnc-fq-dump -v yahoo_json QCBMPXCommand 'gnc-fq-dump' not found, but can be installed with:sudo apt install gnucash Any thoughts? ___ 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] Fw: Finance::Quote terminal commands not working with Flatpak v:5.3 install
Old dog learning new tricks comes hard: I forgot to cc the mailing list in my reply to the valuable information Geert shared so this is to rectify that omission. Also, it occurs to me that it would be very useful if somebody who knows how to edit the Gnucash Wiki could put a link in the Online Quotes page, Section 3 (https://wiki.gnucash.org/wiki/Online_Quotes#Command_line_interface) pointing to the Flatpak page on Using Command Line Tools (https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools) which documents the information that Geert supplied me. Cheers,doug - Reply - From: doug brown To: Geert Janssens Sent: Tuesday, July 11, 2023 at 02:45:37 PM GMT-7Subject: Re: Re: [GNC] Finance::Quote terminal commands not working with Flatpack v:5.3 install Thanks Geert- This works! The whole topic of flatpack is a complete mystery to me that I'm not sure I have the motivation to unravel. One small error in the code line you sent. The option keyword needs to be preceded with a double dash as follows: flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes dump and dump requires some arguements. Thanks again. Cheers,doug On Tuesday, July 11, 2023 at 08:30:29 AM GMT-7, Geert Janssens wrote: Hi Doug, For the flatpak edition of gnucash the command to fetch quotes is slightly more complex: flatpak run --command=gnucash-cli org.gnucash.GnuCash -quotes dump This boils down to the following components: - flatpak run org.gnucash.GnuCash => indicate you want to execute a command in the org.gnucash.GnuCash sandbox without any further options, this will run the default command in that sandbox, which is "gnucash" - --command=gnucash-cli => indicate you don't want to run the default command, but gnucash-cli instead - -quotes dump => the arguments to pass to the command to run Regards, Geert Op dinsdag 11 juli 2023 16:13:37 CEST schreef doug brown via gnucash-user: > I installed via flatpack Gnucash v. 5.3 on Linux Mint v. 20 OS and the > terminal commands that I previously used to find sources for quotes on > longer work. Here is the output: doug@sager:~$ gnucash-cli --quotes dump > yahoo_json QCBMPXgnucash-cli: command not found doug@sager:~$ gnc-fq-dump > -v yahoo_json QCBMPXCommand 'gnc-fq-dump' not found, but can be installed > with:sudo apt install gnucash Any thoughts? > > > > ___ > 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. ___ 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] YahooJSON hack for Linux Flatpak install
The hack proposed by Bruce Schuck in the thread "Yahoo Closed the Door on Finance API" also works for Flatpak install of Gnucash v. 5.3. This Flatpak install was the only Linux distribution of Gnucash v.5.3 I have been able to find. Unfortunately it it uses F::Q v. 1.56 and I have been unable to find any means of upgrading to F::Q v. 1.57. The good news is the hack also works on F::Q v.1.56. Bruce's hack is:>For those comfortable with locating and editing the YahooJSON.pm module>manually I have a quick fix. If you have F::Q v1.57 change the lines>defining $YIND_URL_HEAD and $YIND_URL_TAIL (lines 38 and 39) to: >my $YIND_URL_HEAD >=>'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=';>my >$YIND_URL_TAIL = '&modules=price,summaryDetail,defaultKeyStatistics'; The Flatpak YahooJSON.pm module is located at:var/lib/flatpak/app/org.gnucash.GnuCash/current/active/files/lib/perl5/site_perl/S.32.0/Finance/Quote Elevated privileges are required to modify this file. ___ 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.