Re: [GNC] Clarification of Total (Period) column

2023-01-04 Thread Parthasarathy Devarajan
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

[GNC] Variables in Scheduled transactions

2023-01-04 Thread Stan Brown
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

Re: [GNC] Scheduled transactions

2023-01-04 Thread R Losey
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

Re: [GNC] Request for Automatic Reconciliation Function

2023-01-04 Thread Liz Dodd
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

Re: [GNC] Are accountants happy with CVS exports?

2023-01-04 Thread Dr. David Kirkby
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

Re: [GNC] Clarification of Total (Period) column

2023-01-04 Thread Kalpesh Patel
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

Re: [GNC] import settings file

2023-01-04 Thread Kevin T via gnucash-user
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

Re: [GNC] Are accountants happy with CVS exports?

2023-01-04 Thread R. Victor Klassen
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

Re: [GNC] Scheduled transactions

2023-01-04 Thread David H
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

Re: [GNC] Generic Import Matcher GUI

2023-01-04 Thread Dale Alspach
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,

Re: [GNC] Scheduled transactions

2023-01-04 Thread David Carlson
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

Re: [GNC] Scheduled transactions

2023-01-04 Thread Tommy Trussell
> 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. > >

Re: [GNC] Generic Import Matcher GUI

2023-01-04 Thread David Carlson
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

Re: [GNC] Scheduled transactions

2023-01-04 Thread Tommy Trussell
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

Re: [GNC] Clarification of Total (Period) column

2023-01-04 Thread devaps
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

Re: [GNC] Generic Import Matcher GUI

2023-01-04 Thread Dale Alspach
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

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-04 Thread ml
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

Re: [GNC] Clarification of Total (Period) column

2023-01-04 Thread Kalpesh Patel
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

Re: [GNC] new user, new file

2023-01-04 Thread Michael or Penny Novack
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

Re: [GNC] new user, new file

2023-01-04 Thread Michael or Penny Novack
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

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-04 Thread Kalpesh Patel
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

Re: [GNC] Missing "Buy" action after import of QIF file

2023-01-04 Thread Derek Atkins
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

[GNC] import settings file

2023-01-04 Thread flywire
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 -