Re: [GNC] Clarification of Total (Period) column
Ok, after reading your message, I enabled the Present and Present (INR) columns and I see that they macth the Total (Period) column for me. For me, either Present or Total (Period) column gives me what I want, so if you are suggesting that the Total (Period) column should further restrict to a fiscal period, then that makes sense. If Present gives me what I want and Total (Period) gives you what you want, that would be desirable. Sorry about the digression... Cheers. Sent: Thursday, January 05, 2023 at 5:38 AM From: "Kalpesh Patel" To: dev...@asia.com Cc: gnucash-user@gnucash.org Subject: Re: Re: [GNC] Clarification of Total (Period) column Why do I get feeling that we may not be referencing the same column in the Account view. Please see attached picture of the column I am referring to. I have highlighted with a large red arrow that the question pertained to. The showing current balances as of date would be properly represented by the Present or Present(USD) column in Account view IMHO; not by Total(Period) column. -- Original Message -- Received: Wed, 04 Jan 2023 11:40:10 AM EST From: dev...@asia.com To: Kalpesh Patel Cc: gnucash-user@gnucash.org Subject: Re: Re: [GNC] Clarification of Total (Period) column > I’m not sure I understand. > > The period column isn’t tied to any fixed period. It is just showing current balances as of date. And if you have any future dated transactions in the same register, then the Total column shows the final future balance. > > My fiscal year runs Apr to Mar, so my future transactions will run till end of Mar. Each Apr, I update the register for all the future transactions. If your fiscal year ends in Dec, you can setup transactions until Dec, I suppose. > > There’s also one more distinction between the two. If you have securities in your books, the Period column shows the no. of shares, but the Total column gives you its current market value (assuming your price DB is up to date). > > Cheers. > > On 04/01/23 at 9:08 PM, Kalpesh Patel wrote: > > > You are absolutely correct on the distinction between Total and > > Total(Period) columns and their creative use. My question was a bit about > > whether Total (period) column supposed to take configurable period or is it > > fixed for current year. > > > > This stems from worry that if fiscal year that doesn't correspond to that > > "fixed" coded period, which is likely to be true for businesses, then how do > > you deal with that situation. > > > > My thinking is in line with Adrien as here which still would by default > > would permit to use it in the fashion you mentioned. > > > > > > -- > > > > Message: 1 > > Date: Wed, 4 Jan 2023 07:48:11 +0100 > > From: dev...@asia.com > > To: gnucash-user@gnucash.org > > Subject: Re: [GNC] Clarification of Total (Period) column > > Message-ID: > > > > > 01> > > > > Content-Type: text/plain; charset=UTF-8 > > > > I think one shows total as of today and the other shows total for today and > > beyond? > > > > This distinction helps me and I don?t think it?s a bug. For my use case, I > > setup any future known income or future tax payments till the end of my tax > > year., by entering all those future transactions at the beginning of the > > year itself. > > > > So if my current balance is 100, that?s shown in Total (Period) column. But > > in the register I have future dated entries for all the interest incomes due > > during the year as well as any taxes owed by year end. Let?s say the future > > income is 20 and future tax liability is 5, then my total column will show - > > > > 100+20~5 = 115. > > > > This distinction tells me how much I have at my disposal to spend till end > > of year. > > > > I think the budget report can be used to do something similar, but this is > > easy enough for me to track and understand. > > > > Cheers. > > > > -- > > > > > > Date: Tue, 3 Jan 2023 15:28:57 -0600 > > > From: Adrien Monteleone > > > To: gnucash-u...@lists.gnucash.org > > > Subject: Re: [GNC] Clarification of Total (Period) column > > > Message-ID: > > > Content-Type: text/plain; charset=UTF-8; format=flowed > > > > > > Hmmm... I'm seeing the same thing. > > > > > > It appears to default to 'this year' regardless of the setting. > > > > > > I'd call that a bug. > > > > > > Regards, > > > Adrien > > > > > > On 1/3/23 3:14 PM, Kalpesh Patel wrote: > > > > I have added a column called ?Total
[GNC] Variables in Scheduled transactions
On 2023-01-04 14:20, David H wrote: > Yes, forget the variables, I've never managed to get them to work > either by > duplicating and modifying an existing transaction or creating one from > scratch, so I found it wasn't worth persisting with at all !!! My mortgage payment (say 900.00) is the same each month, but of course every month interest (intamt) is a few cents less and principal (900-intamt) the same few cents more. My scheduled transaction is: Debit: Liabilities:Mortgage Principal 900-intamt Debit: Expenses:Mortgage Interest intamt Credit:Assets:Bank Account 900.00 I would like to be prompted for the interest due when the transaction fires, and then have GC compute the principal as 900.00 minus interest. But GC prompts me twice. Is there some way I've missed for how to use the same variable twice in a scheduled transaction but be prompted for it only once? (I also have a couple of dozen accruals at the end of every month, for instance a debit to Expenses:Fixed Auto Expense and _equal_ credit to Assets:Auto. I'd love th have GC prompt me for each amount so that I wouldn't have to fill them ion in duplicate. The answer to my mortgage question will show the answer to this no-formula question as well, I'm sure.) Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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
Thanks... this may be useful... I hadn't tried that approach. I don't usually have things go too far in advance, but I may try it. I needed this ability recently... I support a charity each year around 01 Jan... but they had a sponsor matching for 3 times the amount that ended 31 Dec, so I needed to enter it early. I didn't think about changing the "Notify" time, but I instead entered it manually, and then went to the Editor and told it to "Skip" the usual entry. When you tell it to "Create" the transaction, does it enter today's date or the date in the editor? If the latter, you'd have to adjust it manually, right? On Wed, Jan 4, 2023 at 3:06 PM Tommy Trussell wrote: > I enter scheduled transactions from the future all the time. For example, > when I receive a utility bill or a credit card that will draft my bank > account on the (future) draft date. > > The secret is to use the "Remind in advance" field in scheduled > transactions. For my bills, the statement might usually come on the 15th of > the month and draft on the 3rd day of the NEXT month. SO I have my reminder > ("remind in advance") come up about 15+3=19 days before the draft date. It > takes a few months to figure out about when the bills are usually "in hand" > (online or by mail) but I adjust them for the usual, and note the bill > dates in the name of the Scheduled Transaction. (For example: "Water > bill/15 due/3"). > > If an unusual situation (such as a February?) makes the bills available a > few days sooner than usual before the draft date, I can either wait until > the later date or temporarily increase the "remind in advance" field. > > Obviously if the amount doesn't change, such as a mortgage payment, you > could use the "Create in advance" field, even months in advance, maybe to > help you monitor cash flow. > > When the Since Last Run dialog comes up, HERE is where you have a "pop-up" > you were looking for. The status of each transaction will be listed along > with a little chevron to remind you the status can be changed. Change the > ones you want to enter now to "To Create." If somehow you've gotten ahead > of yourself (or behind the times), change the ones you're not ready from > "To Create" to "Reminder." > > I am tempted to add a tip about using variables, but I'll stop here. > > On Tue, Jan 3, 2023 at 12:52 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Is this just a one-off? I'd just enter the transaction. If it is > > complicated and you already have an instance in a register, duplicate it. > > > > If it hasn't ever occurred, and you don't want to manually enter it, > > edit to run today, click Actions > Since Last Run to fire it off, then > > edit to revert to your future date. > > > > But no, there is no way I can see to otherwise execute it. > > > > Regards, > > Adrien > > > > On 1/3/23 12:36 AM, Fred Tydeman wrote: > > > I looked in the Help: Tutorial and Concepts Guide in GC 4.13 for the > > term: > > > "scheduled transaction" and got no hits. > > > > > > My question is: Is it possible to select a scheduled transaction from > > the > > > future and have it be done now? I was hoping I could click on the > > calendar > > > entry and get a popup offering choices: Skip, Run now, Edit, ... > > > > ___ > > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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] Request for Automatic Reconciliation Function
On Wed, 4 Jan 2023 15:42:41 +0800 Bite Gao wrote: >GnuCash Developers and Maintainers: > Hello! While your software has done many tedious jobs previously >done by >accountants manually, it cannot automatically reconcile its > accounting data >to the bank statement in its digital form. In my opinion, the >automation of >reconciliation is not only efficient but also accurate since it > reduces human-caused errors. > I would appreciate you a lot if you could add an > auto-reconciliation function to your software. > Yours, > Bite Gao >Jan 4th, 2023 Bite, this is an interesting idea, but to me reconciliation requires human input. While I manually reconcile, I have to attend to pending transactions, for example a payment made on a card which never is taken from the bank account. At what time do I take that from the active list? Where will I put the the never finished transactions? A number which is different in my list to the banks? How will I check for the correct number? When do I contact the bank? They are human decisions, different in each jurisdiction. They are the reason I reconcile - not to have my numbers the same as the banks, but to see the discrepancies and decide on an action. Could you please describe more what you want from automated reconciliation? Your statement about "human-caused errors" implies that reconciliation introduces errors rather than highlights them. Liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Are accountants happy with CVS exports?
On Wed, 4 Jan 2023 at 22:29, R. Victor Klassen wrote: > I generally export a transaction report with all (relevant) accounts > selected. I generally do a select-all from the open report window and then > paste it into OpenOffice/LibreOffice Calc. > > That I can sort on any key I like - normally date within (sub)account, and > run subtotals and look for anomalies. > > If I find any I fix them and then re-export. > > There may well be a pass to and from .csv after it’s pasted into the > spreadsheet. > But after you fix the anomalies and reexport, do you pass the exported files to your accountant? I am quite tempted to give my accountant the files exported by GnuCash, but offer to put them in a different format if he wants. If nothing else it will make him aware of the program. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ 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] Clarification of Total (Period) column
Why do I get feeling that we may not be referencing the same column in the Account view. Please see attached picture of the column I am referring to. I have highlighted with a large red arrow that the question pertained to. The showing current balances as of date would be properly represented by the Present or Present(USD) column in Account view IMHO; not by Total(Period) column. -- Original Message -- Received: Wed, 04 Jan 2023 11:40:10 AM EST From: dev...@asia.com To: Kalpesh Patel Cc: gnucash-user@gnucash.org Subject: Re: Re: [GNC] Clarification of Total (Period) column > I’m not sure I understand. > > The period column isn’t tied to any fixed period. It is just showing current balances as of date. And if you have any future dated transactions in the same register, then the Total column shows the final future balance. > > My fiscal year runs Apr to Mar, so my future transactions will run till end of Mar. Each Apr, I update the register for all the future transactions. If your fiscal year ends in Dec, you can setup transactions until Dec, I suppose. > > There’s also one more distinction between the two. If you have securities in your books, the Period column shows the no. of shares, but the Total column gives you its current market value (assuming your price DB is up to date). > > Cheers. > > On 04/01/23 at 9:08 PM, Kalpesh Patel wrote: > > > You are absolutely correct on the distinction between Total and > > Total(Period) columns and their creative use. My question was a bit about > > whether Total (period) column supposed to take configurable period or is it > > fixed for current year. > > > > This stems from worry that if fiscal year that doesn't correspond to that > > "fixed" coded period, which is likely to be true for businesses, then how do > > you deal with that situation. > > > > My thinking is in line with Adrien as here which still would by default > > would permit to use it in the fashion you mentioned. > > > > > > -- > > > > Message: 1 > > Date: Wed, 4 Jan 2023 07:48:11 +0100 > > From: dev...@asia.com > > To: gnucash-user@gnucash.org > > Subject: Re: [GNC] Clarification of Total (Period) column > > Message-ID: > > > > > 01> > > > > Content-Type: text/plain; charset=UTF-8 > > > > I think one shows total as of today and the other shows total for today and > > beyond? > > > > This distinction helps me and I don?t think it?s a bug. For my use case, I > > setup any future known income or future tax payments till the end of my tax > > year., by entering all those future transactions at the beginning of the > > year itself. > > > > So if my current balance is 100, that?s shown in Total (Period) column. But > > in the register I have future dated entries for all the interest incomes due > > during the year as well as any taxes owed by year end. Let?s say the future > > income is 20 and future tax liability is 5, then my total column will show - > > > > 100+20~5 = 115. > > > > This distinction tells me how much I have at my disposal to spend till end > > of year. > > > > I think the budget report can be used to do something similar, but this is > > easy enough for me to track and understand. > > > > Cheers. > > > > -- > > > > > > Date: Tue, 3 Jan 2023 15:28:57 -0600 > > > From: Adrien Monteleone > > > To: gnucash-u...@lists.gnucash.org > > > Subject: Re: [GNC] Clarification of Total (Period) column > > > Message-ID: > > > Content-Type: text/plain; charset=UTF-8; format=flowed > > > > > > Hmmm... I'm seeing the same thing. > > > > > > It appears to default to 'this year' regardless of the setting. > > > > > > I'd call that a bug. > > > > > > Regards, > > > Adrien > > > > > > On 1/3/23 3:14 PM, Kalpesh Patel wrote: > > > > I have added a column called ?Total (Period)? in the accounts view > > > > page but I am not sure what that period is? I made changes to it in the > > ?Edit ? > > > > Preference ? Accounting Period? but didn?t change the value there so > > > > I don?t think the ?period? denoted is in anyway reflected from > > > > there. I am curious to know what that ?period? entails, if that is > > > > something changeable and if so where. > > > > > > > > > > > -- > > > > > ___ 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] import settings file
thanks for that ! I am able to move setting successfully Kevin On Wednesday, January 4, 2023 at 02:58:13 AM CST, flywire wrote: https://lists.gnucash.org/pipermail/gnucash-user/2022-October/103049.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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Are accountants happy with CVS exports?
I generally export a transaction report with all (relevant) accounts selected. I generally do a select-all from the open report window and then paste it into OpenOffice/LibreOffice Calc. That I can sort on any key I like - normally date within (sub)account, and run subtotals and look for anomalies. If I find any I fix them and then re-export. There may well be a pass to and from .csv after it’s pasted into the spreadsheet. > On Jan 2, 2023, at 4:30 PM, Dr. David Kirkby > wrote: > > It would be nice if one could export all the expenses without the dates > being in a random order. The only way I can find to get dates in a > chronological order is to export every single account separately, so there > are no sub accounts. I thought about trying to write some code that would > allow all the expenses to be exported in one file in chronological order. > That’s not an impossible task, but would take me quite a bit of coding. If > I did it, I would just create something that’s command line driven, using > as many as the unix tools as possible to cut down the work. It might be > possible to just make a fairly complex shell script. ___ 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
Tommy, My workflow is somewhat different but I find it gives me a good handle on upcoming transactions and account balances... I just set up all of my scheduled transactions to Create automatically and Notify me when created 60 days in advance. This gives me a pretty good idea of what's coming up even over the next couple of months even for bills such as utilities that haven't arrived yet. When Gnucash starts it displays a list of newly created scheduled transactions for me to check if I want to, most times I just give it a quick scan and close the tab. I also check the "Register >> Layout >> Future transactions after blank transaction" checkbox ON (I usually sort on date order) so that I get a blank transaction line between transactions up to today and the future transactions which makes the future ones stand out. When I get the actual utility bill, which can be up to 6 weeks before the due date in some cases, I update the due date and amount details and take it from there :-) Yes, forget the variables, I've never managed to get them to work either by duplicating and modifying an existing transaction or creating one from scratch, so I found it wasn't worth persisting with at all !!! Cheers David H. ps I skimmed over the adding error and didn't notice it until I saw your followup email :-) On Thu, 5 Jan 2023 at 07:06, Tommy Trussell wrote: > I enter scheduled transactions from the future all the time. For example, > when I receive a utility bill or a credit card that will draft my bank > account on the (future) draft date. > > The secret is to use the "Remind in advance" field in scheduled > transactions. For my bills, the statement might usually come on the 15th of > the month and draft on the 3rd day of the NEXT month. SO I have my reminder > ("remind in advance") come up about 15+3=19 days before the draft date. It > takes a few months to figure out about when the bills are usually "in hand" > (online or by mail) but I adjust them for the usual, and note the bill > dates in the name of the Scheduled Transaction. (For example: "Water > bill/15 due/3"). > > If an unusual situation (such as a February?) makes the bills available a > few days sooner than usual before the draft date, I can either wait until > the later date or temporarily increase the "remind in advance" field. > > Obviously if the amount doesn't change, such as a mortgage payment, you > could use the "Create in advance" field, even months in advance, maybe to > help you monitor cash flow. > > When the Since Last Run dialog comes up, HERE is where you have a "pop-up" > you were looking for. The status of each transaction will be listed along > with a little chevron to remind you the status can be changed. Change the > ones you want to enter now to "To Create." If somehow you've gotten ahead > of yourself (or behind the times), change the ones you're not ready from > "To Create" to "Reminder." > > I am tempted to add a tip about using variables, but I'll stop here. > > On Tue, Jan 3, 2023 at 12:52 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Is this just a one-off? I'd just enter the transaction. If it is > > complicated and you already have an instance in a register, duplicate it. > > > > If it hasn't ever occurred, and you don't want to manually enter it, > > edit to run today, click Actions > Since Last Run to fire it off, then > > edit to revert to your future date. > > > > But no, there is no way I can see to otherwise execute it. > > > > Regards, > > Adrien > > > > On 1/3/23 12:36 AM, Fred Tydeman wrote: > > > I looked in the Help: Tutorial and Concepts Guide in GC 4.13 for the > > term: > > > "scheduled transaction" and got no hits. > > > > > > My question is: Is it possible to select a scheduled transaction from > > the > > > future and have it be done now? I was hoping I could click on the > > calendar > > > entry and get a popup offering choices: Skip, Run now, Edit, ... > > > > ___ > > 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] Generic Import Matcher GUI
There was no problem with the department store file. The question is why it allowed double click on an "A" transaction to successfully open a window while this fails on the TIAA file. I wrote the details because it is unclear what exactly were the significant differences. Dale On Wed, Jan 4, 2023, 3:09 PM David Carlson wrote: > Dale, > Not sure what you perceive as a problem with that department store > import. It is perfectly normal to need to make some corrections in the > matching step of the import. That is why that step is there. Some files > will go more smoothly than others. Imports from one of my credit cards all > come in with every amount reversed, for example, and there is no way I > could get them to fix that. > > On Wed, Jan 4, 2023 at 10:26 AM Dale Alspach wrote: > >> Curiously today I imported a QFX file generated by a department store. >> Unlike the TIAA file which had every line marked "A", this one had a >> variety of states. I manually fixed the transfer account on a few. Then I >> noticed one marked "A" had the wrong transfer account. Double clicking >> worked this time and I was able to change the transfer account. >> It appears that there is something going on with the parsing of the files >> and Quicken format. >> >> I looked in syslog and there were issues with both imports that produced >> messages. For the department store file there were complaints >> about parsing some date strings. For TIAA there several lines similar to >> this >> Jan 4 09:53:01 azul org.mate.panel.applet.MintMenuAppletFactory[883515]: >> LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate >> POSOTHER >> (POSOTHER replaced by other names in other lines) >> Whether this is significant I do not know. >> >> I know very little about Quicken format and nothing about how gnucash >> handles the import. So what is happening is a total mystery to me. I have >> not filed a bug report. >> >> >> Dale >> >> On Sun, Jan 1, 2023 at 4:24 PM David Cousens >> wrote: >> >> > Dale, >> > >> > I am running V4.13 on Linux Mint 21.1(Vera) ( built from tarball on my >> > system and not Flatpak). >> > I have just downloaded an OFX file and imported it. Double clicking any >> > where in the currently selected transaction is bringing up the dialogue >> for >> > assigning the transfer account. >> > Similarly the right click brings up the dialogue to select the transfer >> > account for the current selection of transactions >> > . I still have the problem that only my right CTRL key can be used for >> > multiple selection ( that may possibly be a keyboard issue and not >> GnuCash) >> > but otherwise it all looks to be working normally. >> > >> > I have just run a keyboard tester and it appears my CTRL problem is the >> > keyboard, so GNuCash appears to be working fine on my system. >> > It is possibly a problem with access to your system resources from >> within >> > the flatpak environment. >> > >> > Regards >> > >> > David Cousens >> > >> > >> > On Sun, 2023-01-01 at 14:47 -0600, Dale Alspach wrote: >> > >> > Upgrading to 4.13 changed the behavior. With "A" selected: Double click >> > still does nothing. Right click raises a menu with first choice "Assign >> a >> > transfer account to the selection" but selecting that does nothing. The >> > second choice "Edit description, notes or memo" does open an edit >> window. >> > >> > Dale >> > >> > On Sun, Jan 1, 2023 at 1:54 PM David Cousens >> > wrote: >> > >> > Dale, >> > >> > You may have to double click in the transfer account field. Try right >> > clicking >> > on the transaction and see if that works. That should also bring up the >> > dialog >> > for selecting the transfer account I have noticed in a few recent >> versions >> > (4.10 -4.12) that there have been some problems with selecting multiple >> > transactions to assign a single account to using the control and shift >> keys >> > which went away after I upgraded to a more recent version(currently >> 4.13). >> > It >> > wasn't consistentand in one case depended on which CTRL key I used on >> my >> > keyboard. I suspected these were likely due to changes in the underlying >> > GTK >> > library rather than code changes in GnuCash itself.. I've got to bring >> my >> > accounts up to data in the next day or two so will be using the >> importer a >> > bit. >> > I'll report back if I have any problems. >> > >> > David Cousens >> > >> > >> > On Sun, 2023-01-01 at 11:27 -0600, Dale Alspach wrote: >> > > Flathub gnucash 4.11 on linux mint. QFX file (Quicken) import. File >> > > downloaded from TIAA. >> > > The help for the import matcher claims that by double clicking on a >> > > transaction that one should be able to check or change the transfer >> > > account. This fails for a transaction matched as new. Double clicking >> > does >> > > nothing. Changing the type to U+C or C allows double clicking to open >> a >> > > window but discards the transfer account information, shows one side >> of a >> > >
Re: [GNC] Scheduled transactions
I thought that you put that there to see if anyone was reading!! You outlined a very comprehensive procedure to effectively utilize the somewhat awkward UI of the Since Last Run Druid. On Wed, Jan 4, 2023 at 3:11 PM Tommy Trussell wrote: > > 15+3=19 days > oops > 18 days for those who can add. > > On Wed, Jan 4, 2023 at 3:05 PM Tommy Trussell > wrote: > > > I enter scheduled transactions from the future all the time. For example, > > when I receive a utility bill or a credit card that will draft my bank > > account on the (future) draft date. > > > > The secret is to use the "Remind in advance" field in scheduled > > transactions. For my bills, the statement might usually come on the 15th > of > > the month and draft on the 3rd day of the NEXT month. SO I have my > reminder > > ("remind in advance") come up about 15+3=19 days before the draft date. > It > > takes a few months to figure out about when the bills are usually "in > hand" > > (online or by mail) but I adjust them for the usual, and note the bill > > dates in the name of the Scheduled Transaction. (For example: "Water > > bill/15 due/3"). > > > > If an unusual situation (such as a February?) makes the bills available a > > few days sooner than usual before the draft date, I can either wait until > > the later date or temporarily increase the "remind in advance" field. > > > > Obviously if the amount doesn't change, such as a mortgage payment, you > > could use the "Create in advance" field, even months in advance, maybe to > > help you monitor cash flow. > > > > When the Since Last Run dialog comes up, HERE is where you have a > "pop-up" > > you were looking for. The status of each transaction will be listed along > > with a little chevron to remind you the status can be changed. Change the > > ones you want to enter now to "To Create." If somehow you've gotten ahead > > of yourself (or behind the times), change the ones you're not ready from > > "To Create" to "Reminder." > > > > I am tempted to add a tip about using variables, but I'll stop here. > > > > On Tue, Jan 3, 2023 at 12:52 AM Adrien Monteleone < > > adrien.montele...@lusfiber.net> wrote: > > > >> Is this just a one-off? I'd just enter the transaction. If it is > >> complicated and you already have an instance in a register, duplicate > it. > >> > >> If it hasn't ever occurred, and you don't want to manually enter it, > >> edit to run today, click Actions > Since Last Run to fire it off, then > >> edit to revert to your future date. > >> > >> But no, there is no way I can see to otherwise execute it. > >> > >> Regards, > >> Adrien > >> > >> On 1/3/23 12:36 AM, Fred Tydeman wrote: > >> > I looked in the Help: Tutorial and Concepts Guide in GC 4.13 for the > >> term: > >> > "scheduled transaction" and got no hits. > >> > > >> > My question is: Is it possible to select a scheduled transaction from > >> the > >> > future and have it be done now? I was hoping I could click on the > >> calendar > >> > entry and get a popup offering choices: Skip, Run now, Edit, ... > >> > >> ___ > >> 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. > -- David Carlson ___ 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
> 15+3=19 days oops 18 days for those who can add. On Wed, Jan 4, 2023 at 3:05 PM Tommy Trussell wrote: > I enter scheduled transactions from the future all the time. For example, > when I receive a utility bill or a credit card that will draft my bank > account on the (future) draft date. > > The secret is to use the "Remind in advance" field in scheduled > transactions. For my bills, the statement might usually come on the 15th of > the month and draft on the 3rd day of the NEXT month. SO I have my reminder > ("remind in advance") come up about 15+3=19 days before the draft date. It > takes a few months to figure out about when the bills are usually "in hand" > (online or by mail) but I adjust them for the usual, and note the bill > dates in the name of the Scheduled Transaction. (For example: "Water > bill/15 due/3"). > > If an unusual situation (such as a February?) makes the bills available a > few days sooner than usual before the draft date, I can either wait until > the later date or temporarily increase the "remind in advance" field. > > Obviously if the amount doesn't change, such as a mortgage payment, you > could use the "Create in advance" field, even months in advance, maybe to > help you monitor cash flow. > > When the Since Last Run dialog comes up, HERE is where you have a "pop-up" > you were looking for. The status of each transaction will be listed along > with a little chevron to remind you the status can be changed. Change the > ones you want to enter now to "To Create." If somehow you've gotten ahead > of yourself (or behind the times), change the ones you're not ready from > "To Create" to "Reminder." > > I am tempted to add a tip about using variables, but I'll stop here. > > On Tue, Jan 3, 2023 at 12:52 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> Is this just a one-off? I'd just enter the transaction. If it is >> complicated and you already have an instance in a register, duplicate it. >> >> If it hasn't ever occurred, and you don't want to manually enter it, >> edit to run today, click Actions > Since Last Run to fire it off, then >> edit to revert to your future date. >> >> But no, there is no way I can see to otherwise execute it. >> >> Regards, >> Adrien >> >> On 1/3/23 12:36 AM, Fred Tydeman wrote: >> > I looked in the Help: Tutorial and Concepts Guide in GC 4.13 for the >> term: >> > "scheduled transaction" and got no hits. >> > >> > My question is: Is it possible to select a scheduled transaction from >> the >> > future and have it be done now? I was hoping I could click on the >> calendar >> > entry and get a popup offering choices: Skip, Run now, Edit, ... >> >> ___ >> 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] Generic Import Matcher GUI
Dale, Not sure what you perceive as a problem with that department store import. It is perfectly normal to need to make some corrections in the matching step of the import. That is why that step is there. Some files will go more smoothly than others. Imports from one of my credit cards all come in with every amount reversed, for example, and there is no way I could get them to fix that. On Wed, Jan 4, 2023 at 10:26 AM Dale Alspach wrote: > Curiously today I imported a QFX file generated by a department store. > Unlike the TIAA file which had every line marked "A", this one had a > variety of states. I manually fixed the transfer account on a few. Then I > noticed one marked "A" had the wrong transfer account. Double clicking > worked this time and I was able to change the transfer account. > It appears that there is something going on with the parsing of the files > and Quicken format. > > I looked in syslog and there were issues with both imports that produced > messages. For the department store file there were complaints > about parsing some date strings. For TIAA there several lines similar to > this > Jan 4 09:53:01 azul org.mate.panel.applet.MintMenuAppletFactory[883515]: > LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate > POSOTHER > (POSOTHER replaced by other names in other lines) > Whether this is significant I do not know. > > I know very little about Quicken format and nothing about how gnucash > handles the import. So what is happening is a total mystery to me. I have > not filed a bug report. > > > Dale > > On Sun, Jan 1, 2023 at 4:24 PM David Cousens > wrote: > > > Dale, > > > > I am running V4.13 on Linux Mint 21.1(Vera) ( built from tarball on my > > system and not Flatpak). > > I have just downloaded an OFX file and imported it. Double clicking any > > where in the currently selected transaction is bringing up the dialogue > for > > assigning the transfer account. > > Similarly the right click brings up the dialogue to select the transfer > > account for the current selection of transactions > > . I still have the problem that only my right CTRL key can be used for > > multiple selection ( that may possibly be a keyboard issue and not > GnuCash) > > but otherwise it all looks to be working normally. > > > > I have just run a keyboard tester and it appears my CTRL problem is the > > keyboard, so GNuCash appears to be working fine on my system. > > It is possibly a problem with access to your system resources from > within > > the flatpak environment. > > > > Regards > > > > David Cousens > > > > > > On Sun, 2023-01-01 at 14:47 -0600, Dale Alspach wrote: > > > > Upgrading to 4.13 changed the behavior. With "A" selected: Double click > > still does nothing. Right click raises a menu with first choice "Assign a > > transfer account to the selection" but selecting that does nothing. The > > second choice "Edit description, notes or memo" does open an edit > window. > > > > Dale > > > > On Sun, Jan 1, 2023 at 1:54 PM David Cousens > > wrote: > > > > Dale, > > > > You may have to double click in the transfer account field. Try right > > clicking > > on the transaction and see if that works. That should also bring up the > > dialog > > for selecting the transfer account I have noticed in a few recent > versions > > (4.10 -4.12) that there have been some problems with selecting multiple > > transactions to assign a single account to using the control and shift > keys > > which went away after I upgraded to a more recent version(currently > 4.13). > > It > > wasn't consistentand in one case depended on which CTRL key I used on my > > keyboard. I suspected these were likely due to changes in the underlying > > GTK > > library rather than code changes in GnuCash itself.. I've got to bring my > > accounts up to data in the next day or two so will be using the importer > a > > bit. > > I'll report back if I have any problems. > > > > David Cousens > > > > > > On Sun, 2023-01-01 at 11:27 -0600, Dale Alspach wrote: > > > Flathub gnucash 4.11 on linux mint. QFX file (Quicken) import. File > > > downloaded from TIAA. > > > The help for the import matcher claims that by double clicking on a > > > transaction that one should be able to check or change the transfer > > > account. This fails for a transaction matched as new. Double clicking > > does > > > nothing. Changing the type to U+C or C allows double clicking to open a > > > window but discards the transfer account information, shows one side > of a > > > transaction, and does not show any means to add a transfer account. > > > > > > This seems to me to be a bug. Am I missing something? > > > > > > Dale > > > ___ > > > 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. >
Re: [GNC] Scheduled transactions
I enter scheduled transactions from the future all the time. For example, when I receive a utility bill or a credit card that will draft my bank account on the (future) draft date. The secret is to use the "Remind in advance" field in scheduled transactions. For my bills, the statement might usually come on the 15th of the month and draft on the 3rd day of the NEXT month. SO I have my reminder ("remind in advance") come up about 15+3=19 days before the draft date. It takes a few months to figure out about when the bills are usually "in hand" (online or by mail) but I adjust them for the usual, and note the bill dates in the name of the Scheduled Transaction. (For example: "Water bill/15 due/3"). If an unusual situation (such as a February?) makes the bills available a few days sooner than usual before the draft date, I can either wait until the later date or temporarily increase the "remind in advance" field. Obviously if the amount doesn't change, such as a mortgage payment, you could use the "Create in advance" field, even months in advance, maybe to help you monitor cash flow. When the Since Last Run dialog comes up, HERE is where you have a "pop-up" you were looking for. The status of each transaction will be listed along with a little chevron to remind you the status can be changed. Change the ones you want to enter now to "To Create." If somehow you've gotten ahead of yourself (or behind the times), change the ones you're not ready from "To Create" to "Reminder." I am tempted to add a tip about using variables, but I'll stop here. On Tue, Jan 3, 2023 at 12:52 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Is this just a one-off? I'd just enter the transaction. If it is > complicated and you already have an instance in a register, duplicate it. > > If it hasn't ever occurred, and you don't want to manually enter it, > edit to run today, click Actions > Since Last Run to fire it off, then > edit to revert to your future date. > > But no, there is no way I can see to otherwise execute it. > > Regards, > Adrien > > On 1/3/23 12:36 AM, Fred Tydeman wrote: > > I looked in the Help: Tutorial and Concepts Guide in GC 4.13 for the > term: > > "scheduled transaction" and got no hits. > > > > My question is: Is it possible to select a scheduled transaction from > the > > future and have it be done now? I was hoping I could click on the > calendar > > entry and get a popup offering choices: Skip, Run now, Edit, ... > > ___ > 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] Clarification of Total (Period) column
I’m not sure I understand. The period column isn’t tied to any fixed period. It is just showing current balances as of date. And if you have any future dated transactions in the same register, then the Total column shows the final future balance. My fiscal year runs Apr to Mar, so my future transactions will run till end of Mar. Each Apr, I update the register for all the future transactions. If your fiscal year ends in Dec, you can setup transactions until Dec, I suppose. There’s also one more distinction between the two. If you have securities in your books, the Period column shows the no. of shares, but the Total column gives you its current market value (assuming your price DB is up to date). Cheers. On 04/01/23 at 9:08 PM, Kalpesh Patel wrote: > You are absolutely correct on the distinction between Total and > Total(Period) columns and their creative use. My question was a bit about > whether Total (period) column supposed to take configurable period or is it > fixed for current year. > > This stems from worry that if fiscal year that doesn't correspond to that > "fixed" coded period, which is likely to be true for businesses, then how do > you deal with that situation. > > My thinking is in line with Adrien as here which still would by default > would permit to use it in the fashion you mentioned. > > > -- > > Message: 1 > Date: Wed, 4 Jan 2023 07:48:11 +0100 > From: dev...@asia.com > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Clarification of Total (Period) column > Message-ID: > > 01> > > Content-Type: text/plain; charset=UTF-8 > > I think one shows total as of today and the other shows total for today and > beyond? > > This distinction helps me and I don?t think it?s a bug. For my use case, I > setup any future known income or future tax payments till the end of my tax > year., by entering all those future transactions at the beginning of the > year itself. > > So if my current balance is 100, that?s shown in Total (Period) column. But > in the register I have future dated entries for all the interest incomes due > during the year as well as any taxes owed by year end. Let?s say the future > income is 20 and future tax liability is 5, then my total column will show - > > 100+20~5 = 115. > > This distinction tells me how much I have at my disposal to spend till end > of year. > > I think the budget report can be used to do something similar, but this is > easy enough for me to track and understand. > > Cheers. > > -- > > > > Date: Tue, 3 Jan 2023 15:28:57 -0600 > > From: Adrien Monteleone > > To: gnucash-u...@lists.gnucash.org > > Subject: Re: [GNC] Clarification of Total (Period) column > > Message-ID: > > Content-Type: text/plain; charset=UTF-8; format=flowed > > > > Hmmm... I'm seeing the same thing. > > > > It appears to default to 'this year' regardless of the setting. > > > > I'd call that a bug. > > > > Regards, > > Adrien > > > > On 1/3/23 3:14 PM, Kalpesh Patel wrote: > > > I have added a column called ?Total (Period)? in the accounts view > > > page but I am not sure what that period is? I made changes to it in the > ?Edit ? > > > Preference ? Accounting Period? but didn?t change the value there so > > > I don?t think the ?period? denoted is in anyway reflected from > > > there. I am curious to know what that ?period? entails, if that is > > > something changeable and if so where. > > > > > > -- > > ___ 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] Generic Import Matcher GUI
Curiously today I imported a QFX file generated by a department store. Unlike the TIAA file which had every line marked "A", this one had a variety of states. I manually fixed the transfer account on a few. Then I noticed one marked "A" had the wrong transfer account. Double clicking worked this time and I was able to change the transfer account. It appears that there is something going on with the parsing of the files and Quicken format. I looked in syslog and there were issues with both imports that produced messages. For the department store file there were complaints about parsing some date strings. For TIAA there several lines similar to this Jan 4 09:53:01 azul org.mate.panel.applet.MintMenuAppletFactory[883515]: LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate POSOTHER (POSOTHER replaced by other names in other lines) Whether this is significant I do not know. I know very little about Quicken format and nothing about how gnucash handles the import. So what is happening is a total mystery to me. I have not filed a bug report. Dale On Sun, Jan 1, 2023 at 4:24 PM David Cousens wrote: > Dale, > > I am running V4.13 on Linux Mint 21.1(Vera) ( built from tarball on my > system and not Flatpak). > I have just downloaded an OFX file and imported it. Double clicking any > where in the currently selected transaction is bringing up the dialogue for > assigning the transfer account. > Similarly the right click brings up the dialogue to select the transfer > account for the current selection of transactions > . I still have the problem that only my right CTRL key can be used for > multiple selection ( that may possibly be a keyboard issue and not GnuCash) > but otherwise it all looks to be working normally. > > I have just run a keyboard tester and it appears my CTRL problem is the > keyboard, so GNuCash appears to be working fine on my system. > It is possibly a problem with access to your system resources from within > the flatpak environment. > > Regards > > David Cousens > > > On Sun, 2023-01-01 at 14:47 -0600, Dale Alspach wrote: > > Upgrading to 4.13 changed the behavior. With "A" selected: Double click > still does nothing. Right click raises a menu with first choice "Assign a > transfer account to the selection" but selecting that does nothing. The > second choice "Edit description, notes or memo" does open an edit window. > > Dale > > On Sun, Jan 1, 2023 at 1:54 PM David Cousens > wrote: > > Dale, > > You may have to double click in the transfer account field. Try right > clicking > on the transaction and see if that works. That should also bring up the > dialog > for selecting the transfer account I have noticed in a few recent versions > (4.10 -4.12) that there have been some problems with selecting multiple > transactions to assign a single account to using the control and shift keys > which went away after I upgraded to a more recent version(currently 4.13). > It > wasn't consistentand in one case depended on which CTRL key I used on my > keyboard. I suspected these were likely due to changes in the underlying > GTK > library rather than code changes in GnuCash itself.. I've got to bring my > accounts up to data in the next day or two so will be using the importer a > bit. > I'll report back if I have any problems. > > David Cousens > > > On Sun, 2023-01-01 at 11:27 -0600, Dale Alspach wrote: > > Flathub gnucash 4.11 on linux mint. QFX file (Quicken) import. File > > downloaded from TIAA. > > The help for the import matcher claims that by double clicking on a > > transaction that one should be able to check or change the transfer > > account. This fails for a transaction matched as new. Double clicking > does > > nothing. Changing the type to U+C or C allows double clicking to open a > > window but discards the transfer account information, shows one side of a > > transaction, and does not show any means to add a transfer account. > > > > This seems to me to be a bug. Am I missing something? > > > > Dale > > ___ > > 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
Re: [GNC] Missing "Buy" action after import of QIF file
Thank you both. I’ll work on a report. > On Jan 4, 2023, at 07:00, Kalpesh Patel wrote: > > I stand corrected as well. The Action column is never updated with the action > denoted in the qif file. Nonetheless the right side buy and sell columns do > reflect correct transaction (which Derek confirmed by walking the code), > which is what I was looking at it before, albeit it is not easy on the eyes > to decipher what transaction is what. Since Action column never had any > information in it (since at least going back 3.4 version), I have gotten used > to looking at the right side columns. > > As a follow on, it does not populate for OFX imports either so might be > absent for all import methods. > > That should be a bug IMHO; not a RFE. > > > -Original Message- > From: Derek Atkins > Sent: Wednesday, January 04, 2023 7:32 AM > To: m...@tgr66.me > Cc: Kalpesh Patel ; gnucash-user@gnucash.org > Subject: Re: [GNC] Missing "Buy" action after import of QIF file > > Looking at the code, you are correct; the importer never calls > xaccSplitSetAction. > > It USES the action to figure out how to process the transaction, but it never > actually saves it. > > Feel free to file an RFE in Bugzilla. > > -derek > > On Tue, January 3, 2023 8:14 pm, m...@tgr66.me wrote: >> This is what I would expect to see. Note the “Buy” in the Action field. >> >> >> >> However, I had to add that as the QIF import process doesn’t appear to >> be doing it. >> >> >> >> Thank you. >> >>> On Jan 3, 2023, at 18:50, Derek Atkins wrote: >>> >>> Screen cap came through (at least to me) -- but you cut out too much >>> info so I can't tell what I'm supposed to be seeing or not. >>> >>> -derek >>> >>> On Tue, January 3, 2023 7:35 pm, m...@tgr66.me wrote: Yes. Trying again to paste a screen cap. I also tried on my Linux box and got the same result. No action showing. > On Jan 3, 2023, at 18:27, Derek Atkins wrote: > > Are you in double-line mode? If not, try turning that on.. > > -derek > > On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote: >> I only included the snippet relevant to the question; my real file >> has the header lines and carets. The back ticks were included >> because I’m used to using those to show a code block :-) They’re >> not in the real file. >> I’ll >> include the entire test file at the end of this message. >> >> So I just double checked, and the Buy action is not selected in >> either the `XYZ` account or in “Joint Brokerage” account. I don’t >> know where else I should be looking. >> >> I’m on Mac with GnuCash v4.13. >> >> I can also try on a Linux box. >> >> !Account >> NAssets:Investments:Brokerage Account:Joint Brokerage TInvst ^ >> !Type:Bank >> D01/11/2020 >> NPayment/Deposit >> PTrf My Bank >> CX >> T1,000.00 >> MDeposit >> LAssets:Current Assets:My Bank >> ^ >> !Type:Invst >> D12/2/2022 >> NBuy >> PXYZ, INC >> YXYZ >> I150 >> T450 >> Q3 >> CR >> M3 shares @ 150; Nothing to see here ^ !Type:Invst >> D1/1/2023 >> NDiv >> PXYZ, INC >> YXYZ >> T16.23 >> CR >> MInvestments:Dividend Income; Still nothing ^ >> >> >>> On Jan 3, 2023, at 16:09, Kalpesh Patel >>> wrote: >>> >>> Your QIF may not be complete. I believe it is not documented but >>> need first four lines and the last line as shown in the below >>> example; carets are important in qif format as well! This would >>> be the minimal example: >>> >>> !Account >>> NTest >>> TInvst >>> ^ >>> !Type:Invst >>> D12/2/2022 >>> NBuy >>> PXYZ, INC >>> YXYZ >>> I150 >>> T450 >>> Q3 >>> CR >>> M3 shares @ 150; Nothing to see here ^ >>> >>> >>> With that qif file contents, a top level 'Test' account created, >>> child >>> account called 'XYZ' created under 'Test' account, a buy entry for 3 >>> shares >>> created and a new security called XYZ under NONCURRENCY namespace >>> created. I >>> also think back ticks at beginning and end of the one you provided >>> in >>> the >>> message are extraneous when included. >>> >>> I am on Windows 11 running GNC v4.11. >>> >>> -- >>> >>> Message: 2 >>> Date: Tue, 3 Jan 2023 09:37:05 -0600 >>> From: m...@tgr66.me >>> To: gnucash-user@gnucash.org >>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file >>> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me> >>> Content-Type: text/plain; charset=utf-8 >>> >>> Oops, I guess the mailing list doesn?t show attached images. >>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote: In my import file:
Re: [GNC] Clarification of Total (Period) column
You are absolutely correct on the distinction between Total and Total(Period) columns and their creative use. My question was a bit about whether Total (period) column supposed to take configurable period or is it fixed for current year. This stems from worry that if fiscal year that doesn't correspond to that "fixed" coded period, which is likely to be true for businesses, then how do you deal with that situation. My thinking is in line with Adrien as here which still would by default would permit to use it in the fashion you mentioned. -- Message: 1 Date: Wed, 4 Jan 2023 07:48:11 +0100 From: dev...@asia.com To: gnucash-user@gnucash.org Subject: Re: [GNC] Clarification of Total (Period) column Message-ID: Content-Type: text/plain; charset=UTF-8 I think one shows total as of today and the other shows total for today and beyond? This distinction helps me and I don?t think it?s a bug. For my use case, I setup any future known income or future tax payments till the end of my tax year., by entering all those future transactions at the beginning of the year itself. So if my current balance is 100, that?s shown in Total (Period) column. But in the register I have future dated entries for all the interest incomes due during the year as well as any taxes owed by year end. Let?s say the future income is 20 and future tax liability is 5, then my total column will show - 100+20~5 = 115. This distinction tells me how much I have at my disposal to spend till end of year. I think the budget report can be used to do something similar, but this is easy enough for me to track and understand. Cheers. -- > > Date: Tue, 3 Jan 2023 15:28:57 -0600 > From: Adrien Monteleone > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Clarification of Total (Period) column > Message-ID: > Content-Type: text/plain; charset=UTF-8; format=flowed > > Hmmm... I'm seeing the same thing. > > It appears to default to 'this year' regardless of the setting. > > I'd call that a bug. > > Regards, > Adrien > > On 1/3/23 3:14 PM, Kalpesh Patel wrote: > > I have added a column called ?Total (Period)? in the accounts view > > page but I am not sure what that period is? I made changes to it in the ?Edit ? > > Preference ? Accounting Period? but didn?t change the value there so > > I don?t think the ?period? denoted is in anyway reflected from > > there. I am curious to know what that ?period? entails, if that is > > something changeable and if so where. > -- ___ 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 user, new file
In your example, you would not credit Equity ("my owner account") when you pay a bill. Crediting an equity account increases its balance, and you don't own anything more than you did before you paid the bill. Your equity in the business is the net of assets minus liabilities, but it's quite rare that you would make any transaction in an equity account directly. (The net of current-period income minus expenses is a special kind of equity, often called Retained Earnings.) No, you are misunderstanding what equity is in this case. He WOULD be increasing equity (of the business) by investing this additional amount (by personally paying a bill of the business) Imagine that this were in TWO steps. Suppose he FIRST put the amount into the bank account of the business (the bank account that doesn't exist yet). Do you see that THIS (imaginary) transaction would be a debit to bank account (asset) and a credit to "owner's equity". He has invested this additional amount. Now SECOND, from this non-existent bank account he pays the bill. That's a debit to the appropriate expense account and a credit to the bank account. The bank account doesn't exist yet but that's OK because we have a debit and a credit for the same amount (in this imaginary account) so those cancel out and it doesn't matter that no bank account (yet) We are left with a debit to the expense account and a credit to "owner's equity". Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 user, new file
On 1/3/2023 4:15 PM, Jamie Tolbert wrote: Starting a new business. For the next month or so, what few bills I have will be paid by me, until I get my business checking set up. Its been years since I studied double entry accounting, but I thought if I paid a bill for lets say 100.00, I would credit my owner account for 100.00 and debit whatever expense account it is. I cant find how to credit my owner account, or opening balance. You are perhaps confused by "opening balance". This is just a special equity account used by the wizard and only applies if you are creating your new set of books WITH opening balances. Instead of creating your new set of books with all accounts zero and then filling in the correct starting amounts (from your old balance sheet) with opening transactions. So just imagine that is what you were doing (even if you DID use the wizard. The point here is that the amount in "starting equity" really should have been in an account (under equity) with a name like "owner's equity", right? So create such an account and then you have an account to credit for these interim additional investments (you are investing more in your business by personally paying some business bills). NOW your only problem is this extraneous "starting equity" amount which you really should want in "owner's equity". Take a look at that account "starting equity". What is its parent account? (the top level account equity, right?) Will gnucash allow you to change that parent to make starting equity a child of owner's equity instead? Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Missing "Buy" action after import of QIF file
I stand corrected as well. The Action column is never updated with the action denoted in the qif file. Nonetheless the right side buy and sell columns do reflect correct transaction (which Derek confirmed by walking the code), which is what I was looking at it before, albeit it is not easy on the eyes to decipher what transaction is what. Since Action column never had any information in it (since at least going back 3.4 version), I have gotten used to looking at the right side columns. As a follow on, it does not populate for OFX imports either so might be absent for all import methods. That should be a bug IMHO; not a RFE. -Original Message- From: Derek Atkins Sent: Wednesday, January 04, 2023 7:32 AM To: m...@tgr66.me Cc: Kalpesh Patel ; gnucash-user@gnucash.org Subject: Re: [GNC] Missing "Buy" action after import of QIF file Looking at the code, you are correct; the importer never calls xaccSplitSetAction. It USES the action to figure out how to process the transaction, but it never actually saves it. Feel free to file an RFE in Bugzilla. -derek On Tue, January 3, 2023 8:14 pm, m...@tgr66.me wrote: > This is what I would expect to see. Note the “Buy” in the Action field. > > > > However, I had to add that as the QIF import process doesn’t appear to > be doing it. > > > > Thank you. > >> On Jan 3, 2023, at 18:50, Derek Atkins wrote: >> >> Screen cap came through (at least to me) -- but you cut out too much >> info so I can't tell what I'm supposed to be seeing or not. >> >> -derek >> >> On Tue, January 3, 2023 7:35 pm, m...@tgr66.me wrote: >>> Yes. Trying again to paste a screen cap. >>> >>> >>> >>> I also tried on my Linux box and got the same result. No action >>> showing. >>> >>> On Jan 3, 2023, at 18:27, Derek Atkins wrote: Are you in double-line mode? If not, try turning that on.. -derek On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote: > I only included the snippet relevant to the question; my real file > has the header lines and carets. The back ticks were included > because I’m used to using those to show a code block :-) They’re > not in the real file. > I’ll > include the entire test file at the end of this message. > > So I just double checked, and the Buy action is not selected in > either the `XYZ` account or in “Joint Brokerage” account. I don’t > know where else I should be looking. > > I’m on Mac with GnuCash v4.13. > > I can also try on a Linux box. > > !Account > NAssets:Investments:Brokerage Account:Joint Brokerage TInvst ^ > !Type:Bank > D01/11/2020 > NPayment/Deposit > PTrf My Bank > CX > T1,000.00 > MDeposit > LAssets:Current Assets:My Bank > ^ > !Type:Invst > D12/2/2022 > NBuy > PXYZ, INC > YXYZ > I150 > T450 > Q3 > CR > M3 shares @ 150; Nothing to see here ^ !Type:Invst > D1/1/2023 > NDiv > PXYZ, INC > YXYZ > T16.23 > CR > MInvestments:Dividend Income; Still nothing ^ > > >> On Jan 3, 2023, at 16:09, Kalpesh Patel >> wrote: >> >> Your QIF may not be complete. I believe it is not documented but >> need first four lines and the last line as shown in the below >> example; carets are important in qif format as well! This would >> be the minimal example: >> >> !Account >> NTest >> TInvst >> ^ >> !Type:Invst >> D12/2/2022 >> NBuy >> PXYZ, INC >> YXYZ >> I150 >> T450 >> Q3 >> CR >> M3 shares @ 150; Nothing to see here ^ >> >> >> With that qif file contents, a top level 'Test' account created, >> child >> account called 'XYZ' created under 'Test' account, a buy entry for 3 >> shares >> created and a new security called XYZ under NONCURRENCY namespace >> created. I >> also think back ticks at beginning and end of the one you provided >> in >> the >> message are extraneous when included. >> >> I am on Windows 11 running GNC v4.11. >> >> -- >> >> Message: 2 >> Date: Tue, 3 Jan 2023 09:37:05 -0600 >> From: m...@tgr66.me >> To: gnucash-user@gnucash.org >> Subject: Re: [GNC] Missing "Buy" action after import of QIF file >> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me> >> Content-Type: text/plain;charset=utf-8 >> >> Oops, I guess the mailing list doesn?t show attached images. >> >>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote: >>> >>> In my import file: >>> >>> ``` >>> !Type:Invst >>> D12/2/2022 >>> NBuy >>> PXYZ, INC >>> YXYZ >>> I150 >>> T450 >>> Q3 >>> CR >>> M3 shares @ 150; Nothing to see here >>> ``` >>> >>> Import and GnuCash creates the correct account, but notice the lack >>> of >>> a >> ?Buy?
Re: [GNC] Missing "Buy" action after import of QIF file
Looking at the code, you are correct; the importer never calls xaccSplitSetAction. It USES the action to figure out how to process the transaction, but it never actually saves it. Feel free to file an RFE in Bugzilla. -derek On Tue, January 3, 2023 8:14 pm, m...@tgr66.me wrote: > This is what I would expect to see. Note the “Buy” in the Action field. > > > > However, I had to add that as the QIF import process doesn’t appear to be > doing it. > > > > Thank you. > >> On Jan 3, 2023, at 18:50, Derek Atkins wrote: >> >> Screen cap came through (at least to me) -- but you cut out too much >> info >> so I can't tell what I'm supposed to be seeing or not. >> >> -derek >> >> On Tue, January 3, 2023 7:35 pm, m...@tgr66.me wrote: >>> Yes. Trying again to paste a screen cap. >>> >>> >>> >>> I also tried on my Linux box and got the same result. No action >>> showing. >>> >>> On Jan 3, 2023, at 18:27, Derek Atkins wrote: Are you in double-line mode? If not, try turning that on.. -derek On Tue, January 3, 2023 7:16 pm, m...@tgr66.me wrote: > I only included the snippet relevant to the question; my real file > has > the > header lines and carets. The back ticks were included because I’m > used > to > using those to show a code block :-) They’re not in the real file. > I’ll > include the entire test file at the end of this message. > > So I just double checked, and the Buy action is not selected in > either > the > `XYZ` account or in “Joint Brokerage” account. I don’t know where > else > I > should be looking. > > I’m on Mac with GnuCash v4.13. > > I can also try on a Linux box. > > !Account > NAssets:Investments:Brokerage Account:Joint Brokerage > TInvst > ^ > !Type:Bank > D01/11/2020 > NPayment/Deposit > PTrf My Bank > CX > T1,000.00 > MDeposit > LAssets:Current Assets:My Bank > ^ > !Type:Invst > D12/2/2022 > NBuy > PXYZ, INC > YXYZ > I150 > T450 > Q3 > CR > M3 shares @ 150; Nothing to see here > ^ > !Type:Invst > D1/1/2023 > NDiv > PXYZ, INC > YXYZ > T16.23 > CR > MInvestments:Dividend Income; Still nothing > ^ > > >> On Jan 3, 2023, at 16:09, Kalpesh Patel >> wrote: >> >> Your QIF may not be complete. I believe it is not documented but >> need >> first >> four lines and the last line as shown in the below example; carets >> are >> important in qif format as well! This would be the minimal example: >> >> !Account >> NTest >> TInvst >> ^ >> !Type:Invst >> D12/2/2022 >> NBuy >> PXYZ, INC >> YXYZ >> I150 >> T450 >> Q3 >> CR >> M3 shares @ 150; Nothing to see here >> ^ >> >> >> With that qif file contents, a top level 'Test' account created, >> child >> account called 'XYZ' created under 'Test' account, a buy entry for 3 >> shares >> created and a new security called XYZ under NONCURRENCY namespace >> created. I >> also think back ticks at beginning and end of the one you provided >> in >> the >> message are extraneous when included. >> >> I am on Windows 11 running GNC v4.11. >> >> -- >> >> Message: 2 >> Date: Tue, 3 Jan 2023 09:37:05 -0600 >> From: m...@tgr66.me >> To: gnucash-user@gnucash.org >> Subject: Re: [GNC] Missing "Buy" action after import of QIF file >> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@tgr66.me> >> Content-Type: text/plain;charset=utf-8 >> >> Oops, I guess the mailing list doesn?t show attached images. >> >>> On Jan 2, 2023, at 19:51, m...@tgr66.me wrote: >>> >>> In my import file: >>> >>> ``` >>> !Type:Invst >>> D12/2/2022 >>> NBuy >>> PXYZ, INC >>> YXYZ >>> I150 >>> T450 >>> Q3 >>> CR >>> M3 shares @ 150; Nothing to see here >>> ``` >>> >>> Import and GnuCash creates the correct account, but notice the lack >>> of >>> a >> ?Buy? action: >>> >>> >>> >>> Is this a known issue or am I misunderstanding the need for the >>> action >>> to >> be shown there? >>> ___ >>> 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. >> >> >> >> -- >> >> Message: 3 >> Date: Tue, 3 Jan 2023 10:46:56 -0500 >> From: "Derek Atkins" >> To: m...@tgr66.me >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC]
[GNC] import settings file
https://lists.gnucash.org/pipermail/gnucash-user/2022-October/103049.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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.