Re: [GNC] How to keep responding on mailing list?
On Sunday, September 15th, 2024 at 14:58, Geoff Jankowski via gnucash-user wrote: > > G’day all. > > I think the point of Heidi’s question is ´how do I see the mailing list?’ > > The answer is that you do not. It sits on a server in the web where it is > managed on our behalf by a few dedicated individuals. > > If you are subscribed you will see all questions raised to the mailing list > address. If you write to it, everyone will see your message. Not strictly true. Everyone can "see the mailing list(s)" via the Archives. From the web page detailing the variouas maling lists associated with the GnuCash project https://lists.gnucash.org/mailman/listinfo/ the specific page for the "GnuCash User" list, https://lists.gnucash.org/mailman/listinfo/gnucash-user has a link to the Archives for that specific list To see the collection of prior postings to the list, visit the [gnucash-user Archives.] where the "gnucash-user Archives" are at https://lists.gnucash.org/pipermail/gnucash-user/ ___ 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] New Australian user questions
On Sunday, September 8th, 2024 at 11:40, Megan Tilley wrote: > > > This email failed anti-phishing checks when it was received by SimpleLogin, > be careful with its content. > More info on https://simplelogin.io/docs/getting-started/anti-phishing/ > > -- > Hi everyone! > > You all appear to have a good handle on GnuCash, but I am a brand newbie!!! > > My environment is: > Local Currency: Australian Dollar (AUD) > Exchange Rates required for: > == USD > == GBP (UK) > == EUR > == SEK (Sweden) > - and are usually purchases that I pass through Paypal (no balance in > Paypal, at all) => buy with AUD and currency conversion made by Paypal into > seller's currency > All my investments are AUD Hi Megan, the following comes from my tracking of a "multi-currency" card in GnuCash, though I can't speak to the "windows" side of your environment. One way to handle this sort of thing, or at least one thing to try out to see if it works for you, would be to create a "top level" Asset account called Paypal Then create sub-accounts below that called AUD Balance GBP Balance EUR Balance SEK Balance each with the Security/Currency set to to be the "foreign" Currency. Beneath the top-level Expenses account, similarly create accounts such as Forex Purchases EUR Forex Purchases GBP Forex Purchases SEK again with the relevant Security/Currency. Now, when you make. say, a "Forex Purchases SEK" purchase, you could withdraw the money from the Assets::Paypal::SEK Balance which would be a Transaction (TXN) soley enacted in SEK. but which would leave you needing to "move" some AUD into the SEK Balance, so as to leave that as 0.00) at which point you would be able to record the AUD-SEK exchange rate. You might not even need the Assets::Paypal::AUD Balance account, depending on where you withdraw the AUD monies that go via Paypal, but, having that account as a "staging" account might help you keep track. As I say, set up a test Gnucash file an play around Depending on which currency Paypal deduct their fees in, you might also want/need to create Expense accounts for, say Forex Fees AUD Forex Fees EUR Forex Fees GBP Forex Fees SEK and play around with a few TXNs to see if you think that lets you keep a better record of where your money went. HTH ___ 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] [Possible phishing attempt] Re: Check & Repair
On Monday, July 22nd, 2024 at 10:56, Art Chimes wrote: > > I don't know whether the observed behavior (no feedback to user) is a bug > or that the Check and Repair function is supposed to operate silently. I am > hoping someone can clarify that. If I'm supposed to be getting some kind of > report but I didn't get feedback, then it would seem to be a bug that I > could report. In my opinion — and I am not a coder or designer of user > experience — if the interface leaves the user scratching their head, it > could be improved. But I understand if that is not a high-priority item on > what I'm sure is a very long to-do list. Thank you. Can't you compare the old and new files to see if anything was changed by the Check and Repair? If they are the same: it didn't do anything. ___ 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] [Possible phishing attempt] Re: [devel question] instanceCount in schedxaction
On Saturday, July 20th, 2024 at 10:13, Adrien Monteleone wrote: > > Strange, while it is certainly on the archive, I don't see it either. > (using Gmane via Thunderbird) > > I did see the thread about Apple Silicon though. > > I wonder if there was some sort of propagation hiccup. > > Regards, > Adrien That "Apple Silicon" thread was sent to all three announce devel user of the gnucash lists, Adrien. ___ 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] [devel question] instanceCount in schedxaction
On Thursday, July 18th, 2024 at 14:58, Liz wrote: > > > On Wed, 17 Jul 2024 17:38:13 -0700 > John Ralls jra...@ceridwen.us wrote: > > > Your email to gnucash-devel went through, > > https://lists.gnucash.org/pipermail/gnucash-devel/2024-July/046944.html > > > > Regards, > > John Ralls > > > I let it through from the moderation queue. > > Liz In which case that's even wierder, as I haven't seen anything, so John's explanatory reply, which I can see in the archives, nor anything else from the devel list, arrive in my mailbox here. Would that imply that I am still not "subscribed" to the devel list? ___ 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] [devel question] instanceCount in schedxaction
I've tried posting the following to the -devel list, to which I thought I was subscribed, but even after trying to subscribe, I haven't seen anything back, nor has the post passed moderation there. As it's possible that some non-devel folk might have some insight here, and so as to alert any devel folk on here to the question, I thought I'd try posting it here. Here's hoping, Kevin First up: need to point out that I'm running a modified 2.6.21a, but few gnucash-devs would recognise the source tree its built from as being such, as it's been rolled forwards a few versions past the directory layout changes! Secondly, the potential inconsistency I'm seeing doesn't affect the functionality of the application. Had been thinking about taking the XML stanzas for the schedxaction entries in my dot-xac GnuCash files and mangling them into generic calendar (VCal) entries that I could then use external to GnuCash. For the schedxaction I have first looked at, I have noted (some info replaced/truncated) e468... SX Name y n n 0 0 24 2023-08-30 2024-07-03 548e... 2 week 2023-08-30 By my reckoning, the dates for that schedxaction (Every 2nd Week on a Weds since StartDate, with no End, Date nor Number) are 1 2023-08-30start 2 2023-09-13 ... 22 2024-06-19 23 2024-07-03last But 23 not 24 as in the instanceCount above ? 24 2024-07-17 ... so I was wondering why the "instanceCount" was stored as 24 and not 23 ? If it's correct, then I'm thinking it'd just be some logic within the code that would be what requires it to be stored as a "nextInstance", but I just thought to ask about it, in case something I'd been doing had caused that potential inconsistency? I could see that a schedxaction without an end could be computed from the last date, plus the recurrence data, so wouldn't need to "know" the count, anyway, in which case you'ld only be storing an instanceCount so as to aid modifying the schedxaction via the dialog: so perhaps that's it? I'm sure someone will know ? ___ 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] Default Transaction Date and Duplicate
On Monday, June 10th, 2024 at 00:30, Fred Bone wrote: > > On 08 June 2024 at 15:03, Dale Alspach said: > > > If I directly enter a transaction in a register, the default date for that > > register gets reset to the date of the newly entered transaction. If I use > > "duplicate" to create a new transaction, the default date is not reset. > > Why? > > > What do you mean by "default"? > > I wouldn't expect the blank txn to change just because I duplicate > something else. And when I modify the blank txn and commit it, I expect > the new blank txn to inherit whatever date I'd committed with. > > FWIW, I'm on 2.6.21. I'm still on a 2.6.21a, plus a swateh of patches I've applied over time to try and get it using a later webkitgtk so that it compliles natively against newer OS distro versions, and I do see the behaviour that Dale describes. Always assumed that, because the duplication process offers one the chance to set the new TXN's date in its own dialog, it doesn't interact with the register's "current date", which is the last date entered manually, or "today", if you haven't yet entered anything? I actually like the fact that the last date one entered, manually, "percolates" down into the next empty TXN, as it helps with entering multiple TXNs from the past. And, of course, it's easy enough - type "t" in the date column to get (t)oday's date - to get back to "today", if that's the date on which you want to make your next entry. Just my thr'pen'th. Kevin ___ 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] The equivalent for Quicken Tag
On Monday, April 29th, 2024 at 10:48, hh8...@gmail.com wrote: > > It’s more challenge to solve the general problem. For example, there > are multiple sub-account under main Account “Travel”. > The Tag is used to select the travel destination. > This creates a 2-D setup where you can track different > expense types for each destination. Slightly different thinking required for GnuCash In general, let's say you have Expenses Travel Accom Excursions Flights Insurance but to break things down by destination, move to using Expenses Travel Dest1 Accom Excursions Flights Insurance Dest2 Accom Excursions Flights Insurance Then again, unless your trips to more than one spatial destination overlap in time, and you often find yourself in two places at once, maybe limit your reporting by the start and end date of each trip? Another way to do "tagging", although you might actually lose some visibility, depending on how good your report writing is, would be to create a "placeholder" Equity account for each Destination, as the "tag", so Equity Dest1 Dest2 and make each Expense be a Split containing the actual Tcategrory amount, say to Accom, plus a Zero amount TXN to, say, Equity:Dest1 That way, when you look at the TXNs in the Equity:Dest1 account register, you would at least have all Dest1 TXNs grouped together, although they'd all show as "Split", in the register, unless you turned on View->Transaction Journal and even then you would still only be viewing the categories, not really collating across them. As I say though, I'm even less sure whar any of the standard reports, made against that account structure, would produce. Finally, although it's been ages since I did anything with the Business parts of Gnucash, maybe there's a way, using its Customer and Invoice functionality, to overlay a form of "tagging/compartmentalisation" on top of transactions. ___ 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] Use same transfer column info for identical description
On Tuesday, April 16th, 2024 at 04:13, Adrien Laveau wrote: > > Hello, > Thank you both for your time answering my question. > > At the moment my data being in GNC or not is not a big deal. > I have the CSV/XLS fiel extracts (sadly my banks do not connect with GNC > online systems). > It is of the following form : > Description Amount Date > DescA xx 2024/03/12 > DescB yy ... > DescC zz > DescB ii > DescB aa > DescC rr > ... > > And I want DescA to go in one transfer, DescB to go in another one and C in > another one. > I have understood your method and remember it, but for the moment I cannot > use it as the > "initial répartition" is not done. Thanks for clarifying that. It would then appear that "fixing up" the data, prior to importing. is the way to go, as that will be easier than doing so once you have imported your data into GnuCash. > And also it does not seem to solve the problem of future transaction witj the > same description. > Indeed I plan to regularly get the CSV from sll my accountd and import them > in GNC and I would > have expected those new transaction to take the correct transfer action. Righto, so it's "future imports" from similar data that you are hoping to have automaically "corrected" and not future entries added via the register. Again, I feel that "adjustting" th edata so that the Import does what you want, is going to be the easiest way forwards. ___ 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] Use same transfer column info for identical description
On Monday, April 15th, 2024 at 04:40, Jim DeLaHunt
wrote:
>
> Hello, Adrien, and welcome to MusicBrainz!
Surely: "... welcome to GnuCash!" ?
>
> On 2024-04-14 13:03, Adrien Laveau wrote:
>
> > Hello community,
> >
> > I uploaded 5 years worth of bank account transaction to gnu-cash.
> >
> > I would like the apply the same transfer information to all the
> > transactions having the same description and keep applying it
> > automatically to all future transaction.
>
>
> It sounds like you want to do two different things:
>
> 1. Change the details ("transfer column info") which you have already
> imported into your book file to match your desired contents.
> 2. Ensure that GnuCash uses your desired contents for future
> transactions which you enter into GnuCash using the "same description".
>
> I don't have easy suggestions for #1, except to go through transactions
> one by one and correct them. It may be tedious, but you only have to do
> it once. (I have a difficult suggestion: to edit the GnuCash XML book
> file. This is dangerous but sometimes effective. It requires skills in
> working with XML and file formats.)
>
As someone who's not completely unfamiliar with editing GnuCash's
XML, I would like to say that doing what you are suggesting you
want to do here, by editing the XML, is going to be a large task,
because you would have to identify the various GUIDs (32 character
strings of text that give you no clue as to what each one is) that,
in the XML file, take the place of what you see, as the transfer
account, in the Register.
As Jim implies, it could be done, but I'm not sure you would want
to.
There may, depending on how cleanly your old data was imported,
be a bit of a "saving grace", as to what you are trying to do,
via an approach that doesn't mean you need to go through ALL
your TXNs one by one. You might still need to address a small
number of outliers.
It does, however, mean "Deleting" some things, but don't stop
reading yet, as it's not as bad as it sounds.
As I understand things, you have ended up with a lot of TXNs that
look like, where Desc1 is the same string every time
Description: Desc1, Transfer account: XFR1
Description: Desc1, Transfer account: XFR2
Description: Desc1, Transfer account: XFR1
Description: Desc1, Transfer account: XFR3
Description: Desc1, Transfer account: XFR3
Description: Desc1, Transfer account: XFR2
Description: Desc1, Transfer account: XFR1
scattered across any number of accounts, whereas you want all
those TXNs to be going into a single Transfer account: let's
say, XFR1.
So, I need to assume that, after you imported them, you have a
chart of accounts (and let's assume the transfer accounts are
all Expenses, so as to have a top-level account to work with)
something akin to the following, where all of your imported
TXNs are in one of three NEW transfer accounts, so
Expenses
+- XFR1
+- XFR2
+- XFR3
and that there's nothing but your imported TXNs that have those
new transfer accounts associated with them.
If you ended up importing your old data so that your old TXNs
ended up associated with existing transfer accounts, then stop
reading, as you are going to have to do them, one-by-one.
Still with me?
OK, if you go to Delete account XFR2, you will be asked if you
want to delete all of its TXNs, OR have them "Moved to" another
account, which, for your needs, would be "Expenses:XFR1".
Similary, when you come to delete XFR3, all its TXNs could
placed into XFR1 as well.
I hope that makes sense, and that your data allows you to try
that approach.
This should go without saying, but, please make a back-up before
you start attempting to edit your data in these "slightly less
than typical" ways.
___
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 suggestions
On Wednesday, March 20th, 2024 at 04:08, J. A. Harris wrote: > > Looking at the replies with a long view, to me they are supporting the > idea of extending gnucash so it supports creating new currencies. Yes, > one can use existing currencies or create new > FUNDs/NYSEs/NEWNAMESPACEs. But it appeared there was a consensus that > those workarounds were a less than ideal kludgy solution. (I have been > repurposing currencies and do not know how many times I have had to stop > and figure out what "XTS", "XXX" or "AMD" actually represented. > Certainly any report I generate will be confusing to anyone who will not > know how I am using those currencies.) Wanted to add something to the last part of that "discussion", as I hadn't been aware that one could do this, and doing it does appear to somewhat negate the claim of confusion. Fred Bone has pointed that you do have the ability to edit the "Display Symbol" of any of the pre-supplied ISO 4217 Currencies, so I thought I'd add in an example of what happens when you do. I did this for the obvious choice for a re-adjustment, the "Angola Kwanza Reajustado" changing its "Display Symbol" from AOR to "Air Miles" An as aside, for folk who like to see what's going on under the hood, if you have your Gnucash data stored in uncompressed XML, you get an extra stanza, as follows, added to the Gnucash file: 51a52,61 > AOR > > > user_symbol > Air Miles > > > > > ISO4217 which suggests, if you are comfortable editing Gnucash files, you can probably add "Display Symbol" overrides for more than one Currency, without even firing up GnuCash - nice to know! But. I digress, so, back to the example. I then created two accounts Assets:Future Assets:Air Miles Income:Air Miles both denominated in "AOR" (FWIW, the one time I had to choose my adjusted ISO 4217 Currency by its original name/symbol), and then created two sub-accounts of the latter, so Income:Air Miles:Scheme Income:Air Miles:Petrol Partner however, both accounts, by virtue of being created as sub-accounts, automatically get a default of denomination of "AOR", so you no longer have to remember which ISO 4217 Currency you have overriden for use with the accounts. I then created a couple of TXNs, putting Income into the Asset, and then generated a report (the rendering here is best viewed in a monospaced font) Transaction Report >From 01/01/2024 To 31/12/2024 DateDescription Transfer from/toAmount Air Miles March 2024 01/03/2024 Opening Offer Income:Air Miles:Scheme Air Miles500.00 25/03/2024 Some Fuel CoIncome:Air Miles:Petrol Partner Air Miles26.00 Total For March 2024 Air Miles526.00 Total For Air Miles Air Miles526.00 Grand Total Air Miles526.00 As you can see, ALL mention of the "Angola Kwanza Reajustado", or rather, its ISO 4217 symbol "AOR", has gone and the report appears to be solely denominated in "Air Miles". A very simplistic example, I'll grant you but, still - a lot less confusing that a report denominated in "AOR", which could well be interpreted as Album-oriented rock pressings in certain contexts. Hoping that helps you get closer to where you wanted to be. ___ 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 suggestions
On Wednesday, March 20th, 2024 at 04:08, J. A. Harris wrote: > > Looking at the replies with a long view, to me they are supporting the > idea of extending gnucash so it supports creating new currencies. Yes, > one can use existing currencies or create new > FUNDs/NYSEs/NEWNAMESPACEs. But it appeared there was a consensus that > those workarounds were a less than ideal kludgy solution. (I have been > repurposing currencies and do not know how many times I have had to stop > and figure out what "XTS", "XXX" or "AMD" actually represented. According to the ISO standard defining alpha codes and numeric codes for the representation for currencies, ISO 4217, at least as documented at this Wikipedia page (can never recall which ISO standards you have to pay to get from the ISO, hence falling back to Wikipedia) https://en.wikipedia.org/wiki/ISO_4217 "The code XTS is reserved for use in testing." "The code XXX is used to denote a "transaction" involving no currency." so those two actually have a defined meaning? > Certainly any report I generate will be confusing to anyone who will not > know how I am using those currencies.) Presumably, people wouldn't be expecting to see you reporting on AMD 051 2 Armenian dram if you weren't known to be conducting tranasactions in that currency, and so readers would rightly expect to see some additional definition on the report? Of course, if you really want to consistently use AMD for something other than the Armenian dram, then you could download the source; edit this file ./libgnucash/engine/iso-4217-currencies.xml so as to have this stanza contain the info you want, and compile your own Gnucash, complete with whatever "currencies" you want to be in it. FWIW, the notes in that file do mention that it "... is not currently used at runtime. It's used to generate the contents of iso-4217-currencies.c." so perhaps at some point in the future, there will be a way to load "currencies" from an XML file at runtime. As to whether you could add your own stanzas to that file and have a custom Gnucash compile against it, you'ld need to check to see if the internal arrays are pre-sized, or generated by the number of stanzas seen in the XML file when it's processed. Either way, it sounds do-able. HTH ___ 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't open old GnuCash file
On Friday, February 16th, 2024 at 09:00, MegaBrutal wrote: > > Hello, > > I've been using GnuCash between 2015 to 2017 to help to straighten out > my personal finances. ... > > Now I got a situation that I'm looking for certain transactions from > around that time and I remembered that I should check my old GnuCash > file, untouched since 2017-09-21. To my shock, the modern GnuCash > version that comes with my distro (Ubuntu 23.10) crashes when I try to > open my old file. ... If I am reading the Git logs correctly, then Release 2.6.18 came out one day after you last saved your file, and there were three more 2.6 releases to come after that. It will definitely be worth your while to try opening the file with a version 3, saving that if you can open it, and opening the new file with a v4, then saving that and opening that one with a v5. There will have been some changes to the underlying file format, since the 2.6 series, but as to whether such changes are the exact cause of what you are seeing, you going to have to try out older versions to narrow things down. Of course, if you only want to look at certain transactions from before Sep 2017, then opening your file with a 2.6 series Gnucash would be the way to go. If you find that you can't even open your file with a v2, then a possibly corrupted file may be the root cause of what's happening. ___ 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] End of year
On Wednesday, January 31st, 2024 at 01:12, Adrien Monteleone wrote: > > On 1/29/24 8:04 AM, Mahon Finbar via gnucash-user wrote: > > > OK, I want to do it properly, but I had an email crash and . > > > > So, can someone point me or send me the 'how to' for doing an end of > > year process, where I can 'inherit' the names from the autocomplete > > from the previous years? > > You can't. I thought we described that already. Not strictly true. > If you start a new file/account each year, you will lose all > auto-complete from the previous year's entries. > > The auto-complete list is generated on the fly from the other > transactions in the register you have open at that time. If that > register doesn't contain previous transactions because you started > a new year, then you don't get auto-complete suggestions. As Adrien points out, in order to have auto-complete, you need to have some "previous" transactions to auto-complete against However, if you have created a new, empty tree of accounts, and you have also exported a CSV of transactions, then you should be able to import those old transactions, so as to give you something to auto- complete against. Clearly though, you don't need multiple tranaactions that have the same name (Description field) because you only need one to be able to autocomplete against it. So the "trick" would be editing the CSV file so that you only have one transaction per auto-complete target that gets imported, and then deleting "old" entries, once you have your first autocompleted one for the new period, from within GnuCash itself. The amount of work required depends on how many "proto-transactions" you want to be able to autocomplete from, but it should be possible, however, it's not for everyone, and if you don't feel comfortable editing either CSV files, or the GnuCash files, when saved as XML, then make lots of backups as you work out what works best for you. Note that this approach is akin to copying your old GnuCash file to a new one and then deleting all the old tranactions, one at a time, from with the GUI front-end. I could even suggest that, once you have an exported CSV file of transactions, you might be able, simply by changing the dates in it, to re-use the same "common transactions" file every time you start a new GnuCash file. Alternatively, you might even maintain a second Gnucash file, which just has one transaction per auto-complete target, to which you add new ones as you encounter them in your ongoing accounts, and export your proto-transactions to CSV from that. So, make some backups; make one more set of backups, and then start experimenting. The bottom line is, whilst it is true that the vast majority of GnuCash users will only ever see, and operate on, their charts of accounts and transactions through the GUI front-end, underneath it all, it is just editable plain text, and you can use that to your advantage. HTH ___ 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] Starting a new year
On Wednesday, January 10th, 2024 at 03:14, Grace wrote: > > Hello, > > I am just wondering how folks are dealing with starting a new year? > > Finishing 2023 I think is easy. You just stop using it. > > However, how do I start 2024 with the finishing balances of 2023? Do I > have set up a brand new set of accounts, or is there a way of doing this > that I have not found? > > Grace If you are 1) Saving your GnuCash files as uncompressed XML 2) Happy editing files in a TXT editor, then the following may be of some use then it's not too hard to start over and, as long as you keep a copy of the "previous year" then you can't lose anything when trying it out. Create a new tree of accounts fron (let's say ongoing.gnucash) File->Export-Export Accounts (save as account_tree.gnucash) Copy account_tree.gnucash to new_yeargnucash Copy ongoing.gnucash to old_year.gnucash The next bits are probably best viewed in a monospcaed font as I have tried to line up the actions in each of the files: old_year.gnucash new_year.gnucash Grab from to last Add to end of file Grab the 5 count data line for the schedexaction Add after the lines Grab the two lines 1 Add before the lines so as to balance the closing gnc:book Need to disable the SchedTXNs in the old file, which you can do, one-at-a-time, from within GnuCash of by editing the XML and Replace every y with n Open up ongoing.gnucash in GnuCash Create a report from the "Account Summary" template that will give you all of the Opening blanaces you need to populate the new file. In the report creation dialog, I set the following: Tab:General Change the date to the last date of the previous period Tab:Accounts Make the level of subaccounts "All" Only need Assets & Liabilities and Children Tab:Display Uncheck Include accounts with zero balances Tab:Commodities Report's Currency: GBP (Just make sure it's the files default currency) Price Source: Most Recent Export as old_year-report-acc_sum.html Open up new_year.gnucash in GnuCash Enter the various Opening Balances with reference to your HTML report file. Save new_year.gnucash That's it. GnuCash on opening your new file, will do a very good job of adding in any "missing" bits, when it comes to save the new file for the first time. Aside: if you keep making copies of the new_year.gnucash before you operate on it, you will be able to see what Gnucash is doing to it. GnuCash is an incredible program in that respect: the authors deserve a lot of credit for their work. FWIW, people who want to try and get a better understanding of the format of a Gnucash XML file could do a lot worse than to create a brand new file, with a set of minimal accounts, enter one tranaction, and maybe one commodity and commodity price, and squirrel that file away for future reference. I hope that helps and/or gives you something upon which to create your own approach, although, as many folk on here will tell you, you may not need to have seperate files for seperate years, but if you want to, then you can do. ___ 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] Help
On Tuesday, January 9th, 2024 at 04:03, Max Crystal wrote: > > Every time I open and close the register it creates a notepad log entry on > my hard drive. Can I disable this so I will not have multiple entries every > day. > > Max Can't tell if you are using GnuCash on a UNIX-like platform. but, if you arem then I have a couple of Makefile targets, one that lists all of my "old files" and one that removes them all Note also that I have files named personal-??.xac where the ?? is a two letter country code - your filenames may differ, (indeed, I think the dot-xac is showing my age a little?) but adapting the commands to match your filenames shouldn't be too hard. list-old-personal: find .-name personal-??.xac.`date +%Y%m`\* \ -a \! -name personal-??.xac.`date +%Y%m%d`\* -print list-old-personal-and-rm: find .-name personal-??.xac.`date +%Y%m`\* \ -a \! -name personal-??.xac.`date +%Y%m%d`\* -print | xargs rm -f FWIW, you can use the power of 'expr' to clear out last month's list-last-month-personal: l=`date +%Y%m` ; \ find .-name personal-??.xac.`expr $$l - 1`\* -print ; list-last-month-personal-and-rm: l=`date +%Y%m` ; \ find .-name personal-??.xac.`expr $$l - 1`\* -print | xargs rm -f ; and even the previous year's list-last-year-personal: l=`date +%Y` ; \ find .-name personal-??.xac.`expr $$l - 1`\* -print list-last-year-personal-and-rm: l=`date +%Y` ; \ find .-name personal-??.xac.`expr $$l - 1`\* -print | xargs rm although note that if you run these commands from the command line, drop the $$l for $l, as the doubling is a Makefile escape. HTH, although apologies for the noise if you are not on a UNIX-like platform. ___ 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] Scheduled Transactions: Monday before the 4th Wednesday
On Wednesday, November 1st, 2023 at 03:32, Stan Brown wrote: > > Every month, I get a direct deposit two days before the fourth Wednesday > of the month. That's not the same as the third Monday. For example, this > month the fourth Wednesday was 25 October, so the deposit came on > 23 October, which is the fourth Monday. Next month, the fourth Wednesday > will be 22 November, so the deposit will come on 20 November, which is > the third Monday. > > I have scheduled my transaction for the 4th Wednesday of each month, but > to be created two days early. Then when the transaction fires, I > manually change the date the Wednesday. > > That's an inconvenience, albeit a minor one. Just in case I've missed > something, is there any way to have the transaction appear on the right > day (two days before the fourth Wednesday) and with that Monday date, > not the Wednesday date? This will look a lot better if read in monospaced text: some of us think that all email would! Best I could come up with is to suggest that you define a set of Scheduled Transactions (SchedXn) that all start on a known Monday before the 4th Wednesday, and repeat every 28 days, but start a new SchedXn once you hit a Monday before the 3rd Weds. FWIW, some UNIX shell commands (apologies to all of the non-UNIX Shell users out there!) to generate a year's worth of 28-day apart dates, are s=0 for n in 028 56 \ 84 112 140 \ 168 196 \ 224 252 280 \ 308 336 \ 364 ; do \ s=`expr $s + 1` ; echo -n $s " " ; date +'%Y%m%d' --date="Mon Oct 23 2023 + $n day" ; done (and, before anyone asks, it's merely a cut-down version of something that generates a yearly set of fornightly dates, given a starting date, but with the starting date changed) Here's what that produced, starting with your Mon Oct 23 example: 20231023 20231120 20231218 before 3rd Weds, start from next Monday 20231225 20240122 20240219 before 3rd Weds, start from next Monday 20240226 20240325 20240422 20240520 20240617 before 3rd Weds, start from next Monday 20240624 20240722 20240819 before 3rd Weds, start from next Monday 20240826 20240923 20241021 20241118 before 3rd Weds, start from next Monday I'd suppose that once you have passed the end of each SchedXn, you just change the start date to the correct date for the year after and see where you get to. Cave: leap years may well stuff things up, but you should get the jist, of how to think about it, and to take account of the extra day, I'm sure. FWIW, each of the five SchedXn-s above would be defined as: Start Date: 20231023, Freq: Daily, Every: 28 days, Occurences: For 2 Start Date: 20231225, Freq: Daily, Every: 28 days, Occurences: For 2 Start Date: 20240226, Freq: Daily, Every: 28 days, Occurences: For 4 Start Date: 20240624, Freq: Daily, Every: 28 days, Occurences: For 2 Start Date: 20240826, Freq: Daily, Every: 28 days, Occurences: For 2 HTH ___ 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 run Year End Procedures for the Tax Year (UK end 5 April 2023), and start new Data set for the New Tax Year starting 6 April 2023
On Sat, 8 Apr 2023 at 07:09, Stan Brown wrote: > > > On 2023-04-07 14:09, Michael or Penny Novack wrote: > > > > The point is, if you ever want to look at the books in their state prior > > to the 2023 close you don't undo anything. Instead you retrieve the > > back-up and open a copy of that. > > That's certainly possible, and I agree it's much better than undoing > things. But there's a very large caveat: > > When you open GnuCash, it opens the file you were working on most > recently. So you need to be very sure that you have opened the file you > intended to, after you have finished whatever you wanted to do with the > pre-closing file. > > ... > > P.S. There's a workaround for this in Windows, and I believe in Linux as > well. So, let's assume that you are running GnuCash on GNU/Linux. Chances are that there'is a menu entry, or an icon on a toolbar somehere, that you click on to invoke GnuCash. You should be able to edit the menu entry,'s or the icon's "command" string so that what you actually invoke is /path/to/gnucash --nofile That will invoke GnuCash without any Book/Ledger open, but you will have the four most recentl entries in GnuCash's File menu, so you can choose to open whichever one of the four you want to, rather than having to hard-code any particular file at every startup time, or, as Stan mentions, get the last one you worked on by default. There's probably something similar in windows-land. HTH Kevin PS I have spared you the "you can always edit/play with/ the XML in the GnuCash file, in order to start a new tax year in the same filename" approach, but I've added it into a few threads over the years so, if you feel like making a backup and having a go, you should be able to find all you need in the archives. ___ 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] XML or database?
On Mon, 31 Oct 2022 at 21:32, Derek Atkins wrote: > > On Mon, October 31, 2022 9:14 am, R Losey wrote: > > > > > > Long ago in my Quicken days, I would generally keep about 3 years of data > > and then "archive" transactions older than that... I don't know if GnuCash > > has (or needs) any similar feature. > > For what it's worth, I have data going back to like 2007 in my file. > GnuCash does not really have an "archive" function (although there have > been 3rd party tools that do that. Whilst there's no explict archive functionality, if you are using XML files, there's nothing to stop you copying your current file, and then opening up the copy and removing all transactions before a certain date. Time consuming, yes: but easily do-able. Similarly, the ability to export an empty file with the same set of accounts as your current file, create a report of current balances and enter those as the "Opening Balances" into you new file, affords a simple way to effectively archive old transactions into a separate file. Indeed, if you are prepared to cut and paste XML, it's fairly easy to copy over the "Scheduled Transction" stanza from the old file to the new one, and so avoid having to re-enter all of your scheduled transactions all over again. Just remember to disable the scheduled transactions in the "archived" file, or else, the next time you open it up ... Obviously, the process only applies to the simpler sets of accounts one might use GnuCash for (I have not tried this for a file that has any "Business" functionality within it), but here's some "pseudo code" as your starter for ten: File->Export-Export Accounts using Filename accounts_new Creates accounts_new.gnucash Open up old file Grab from to lthe last Add to end of accounts_new.gnucash Grab the 15 count data for the schedexaction Add after the sections in accounts_new.gnucash Grab the two lines 1 Add after the XML namespace block in accounts_new.gnucash so as to balance the closing gnc:book Then just create the "closing balances" report from the old file and enter as the new Opening Balances, having opened up accounts_new.gnucash HTH, Kevin ___ 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 & Macros
On Wed, 26 May 2021 at 23:11, Jack Frillman via gnucash-user wrote: > > I have repetitive task I do every day and I would like to reduce the > number of steps to do that task. > > More specifically I import stock/mutual fund and precious metal prices > from a CSV file. Currently I go through the multi-step process the GUI > walks you through. This is easy enough but I can be ultra lazy at times > and would like to execute that import process using a macro if possible. > Whilst I can't suggest a "macro" within Gnucash, I can suggest another way to achieve the same thing, assumimg you are happy doing a bit of shell scripting, plain text editing, and store your GnuCash files in uncompressed XML format. Cave! Make a backup: indeed, make lots of backups. I don't have a stock price stanza to hand at time of writing, but to flesh out the approach, here is a Currency Price stanza that tells you the EUR/AUD conversion rate on a given date, as recorded within GnuCash, where the Euro is the "commodity". 158b0e4b8ded0dfc150c6ac15a27bcc8 ISO4217 EUR ISO4217 AUD 2021-07-01 18:59:00 +0800 user:price transaction 15837/1 If you look at the actual data within the entry there, you might start to think that, were you to create another stanza, and alter the values in just the fields, and add that in between the then, the next time you opened up your GnuCash file, GnuCash might be clever enough to do the right thing and present you with the new data. The good news is: GnuCash is more than clever enough. It's a similar exercise for Stock commodiy price data, with, if I recall correctly, (been a while since I last did it) a couple of extra attributes that are the "links" to the stock definition, but, once you have identifed a Stock commodiy price data stanza, in your current XML file, for the Stock you are interested in, it will be obvious which values you need to maintain for the new price data entry to be associated with the correct Stock/Commidity, and which you need to alter. Alternatively, should you have any doubts about the above concept: Take a copy of a current GnuCash file Open the file up and import one new Stock/Commodity price. Save the new file Take a copy of the new file Compare the differences What you need then, is a template for a entry stanza into which you substitute placeholders, for the date and the price, with the date and price, data extracted from your CSV file. The hardest bit is likely to be generating the GUID for each entry. I have used that approach both for adding Stock/Commidity prices, and Invoices, in the past. I could even go so far as to suggest that you could have a template for generating some SQL "INSERT" commands that you squirt into the backend GnuCash Datsbase via a monitor, but I can't claim to have ever done that, being nore than happy with the XML format. Hoping that gives you enough to build on (as opposed to giving you enough rope to hang yoursefl with?) not least as few people on here are ever going to suggest editing the XML file as a solution, but you should know that you can, if you are careful, Kevin PS Did I mention you should make lots of backups? ___ 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 Confusion Again
On Sun, 10 Oct 2021 at 10:14, Jack Frillman via gnucash-user wrote: > > I just bought the stock and I got a dividend and I don't know how often > I will get them. So setting up a scheduled transaction for it is not > practical. You might like to think of scheduled transaction LIz describes merely as a template. You don't have to a scheduled transactions enabled, so it could just sit there, as a template and/or with a far future next date, until you needed it. Of course, the TXN completion feature allows for a duplication of a previous entry when entering the next, however, if you are in the habit of creating new XML files, then copying the scheduled transaction block into a new file gives you access to your "templates" from the off. ___ 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] Transcation Search & Replace
On Fri, 3 Jul 2020 at 04:00, listsub3 wrote: > > Typically bulk search replace changes would be for things like > transaction category/account, changes in names in description/notes. etc. > > My GC data folder is currently 46mb (I have quite a lot of histrorical > stuff). > > Seems like quite a functional omission in GC to me - it must be quite a > common user task - I don't have an old Quicken on this machine but I > know it used to be a breeze with that. > > Searching this list I found an an old response to the same question > which indicated that this functionality would only be considered once GC > had moved to a databese strcuture? Not clear that one needs a database to do much of what you've listed above, although an SQL syntax might offer extra capability, as regards say, more easily narrowing the change down to a specific set of transactions. If you have the XML file, then altering a common description string across multiple transactions in the file, is a simple text-editing, find-and-replace operation. These two pseudy-coded examples are equivalent (Note: not the actual Table names nor XML schema tags) UPDATE TXN t SET t.description = 'corrected string' WHERE t.description = 'erronenous string' ; sed -ie 's/txn:description>erronenous stringcorrected stringhttps://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] Porting the Tutorial & Concepts Guide to ReadTheDocs.org
On Wed, 6 May 2020 at 15:20, Adrien Monteleone wrote: > > Thanks for the bug reference. Certainly, I agree change won’t happen soon, or > easily, nor do I think it should. > > The point of my post was to encourage the OP not to lose hope or give up. > > Regards, > Adrien As someone else who's not often posting, but has been of late, what I'd also say to the OP is: if you now have a process that can take the existing doc sources and render them for display at "Read The Docs" then that's all you need. Just keep on doing it against the existing sources as they get updated. No harm in having multiple renderings, nor multiple tool chains to render the existing sources for as many other renderings as.possible. ___ 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] Fwd: Fastest ways to enter my transactions into GnuCash ?
Oops: forgot to copy to the list. -- Forwarded message - From: Kevin Buckley Date: Sat, 29 Feb 2020 at 19:23 Subject: Re: [GNC] Fastest ways to enter my transactions into GnuCash ? To: Long On Fri, 28 Feb 2020 at 18:22, Long wrote: > > ... But > sometimes, i need to enter large amount of transactions into GnuCash. So i > really want to hear some idea from who have experienced with this problem. As other people have stated it very much depends om the format that the transaction you wish to enter are in, as well as the nature of the transactions once you put them into GnuCash. Transactions with a lot of splits are going to be hard to automate. If though, your large amount of transactions are all doing a single amount from the same credit account to teh same debit account, you may be able to get some joy by playing with the XML that GnuCash stores its data in. This is DANGEROUS and you SHOULD backup your GnuCash XML file BEFORE starting to edit it. Here is the XML for such a simple transaction from a GnuCash 2.6.1 file d81e27dc72c046f6b6fea3bbcb134593 ISO4217 AUD 2020-02-26 00:00:00 +0800 2020-02-29 14:35:45 +0800 Stephanie's date-posted 2020-02-26 notes 2c98f40a1b12123cf1f899a4cc256765 n 900/100 900/100 239cccee94937c10e2aeeab5c665cebc 56eb9eaabb9de85dc371a5a438a17ca7 c -900/100 -900/100 d45c15b5c7634235e47c2cd5ca668094 It looks intimidating doesn't it, however, there are only THREE GUIDs that you need to regenerate in that block so as to be able to be able to add it to your GnuCash file, and have it seen as a NEW transcation when you reopen the file, vis d81e27dc72c046f6b6fea3bbcb134593 2c98f40a1b12123cf1f899a4cc256765 56eb9eaabb9de85dc371a5a438a17ca7 Of course, you may want to change the time, amount and description as well. If you have, and know how to use, somethng akin to uuidgen, then you may be able to evisage a simple program that takes arguments such has "2020-02-29 14:35:45" "9.00" "Stephanie's" and then writes out a block of transaction XM than you can add into your XML file. . As I say, editing the XML fille is not somthing to do unless you know what you are doing but it can be useful for some simple things. Another approach to entering a lof of transactions that are very similar would be to create a Scheduled Tranastion that you set to start at some point in the past and have them run daily. When you next to a "Since last run" you'll get as many nes trasnactions as there are days between your start date and today. This may not sound all that useful but it will mean that most of the info will now be inside your GnuCash, which may be a better place to start from that only having data in some non-GnuCash format outsidde it. You still have to edit amounts and totehr deatils but that may ease the load. It really does depend on the nature of your trasnactions though. ___ 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.
