Re: [GNC] How to specify the date format in a QIF file
HI, The importer will take a look at all the date strings in the full qif file and attempt to figure out what format it is. For example, if you have 01-31-18 then you know that this is either m-d-y. It cannot be anything else. However, if you have, e.g. 01-01-01, there is no way to tell. If you're creating the QIF, then the best thing to do is ensure you use 4-digit years. If you have 01/01/2001, this is less ambiguous (it could be d-m-y or m-d-y). So long as you have at least ONE date with a day > 12, and use 4-digit years, then you'll be completely unambigious. There is no way to specify the format in the QIF indirectly. So if ALL your dates are from days <= 12 then the importer will always ask you to choose. There is no way around that. Hope this helps! -derek On Thu, May 30, 2019 12:19 pm, Bram Mertens wrote: > Hi, > > I'm looking into converting the CSV format my bank uses to QIF. > While importing my current test file I get an additional dialog: "set > date format for this QIF file". > > It says that the current QIF file does not specify which order the > day, month and year components of a date are printed. > Since I am generating these QIF files I can add whatever info needed > to avoid this. > > But I can't find any documentation on how to specify this. It's not on > the wikipedia page that is linked from the wiki and not in the > official specification of the QIF format linked from that page. > > What do I need to add to the file to allow gnucash to recognize the date > format? > > Thanks in advance > > Bram > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to specify the date format in a QIF file
Hi, I'm looking into converting the CSV format my bank uses to QIF. While importing my current test file I get an additional dialog: "set date format for this QIF file". It says that the current QIF file does not specify which order the day, month and year components of a date are printed. Since I am generating these QIF files I can add whatever info needed to avoid this. But I can't find any documentation on how to specify this. It's not on the wikipedia page that is linked from the wiki and not in the official specification of the QIF format linked from that page. What do I need to add to the file to allow gnucash to recognize the date format? Thanks in advance Bram ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GNUCASH Android
Some more feedback for Mr. Jon,when i try to open a file saved with gnucash desktop v.3.5 (windows) the error reports, "unable to parse transaction time 2019-04-30 20:00:00" However, same file could be opened when exported as "Export Accounts" in xml format. i.e file without any transactions. nor - nor -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Misc Newbie Questions
Adrien
Climbing learning curves is about the only thing I have energy for these
days. Thanks for pointing out these hills (mountains?). Some time
(hopefully soon) I'll start my exploration, in the meantime I'll be
using Bert Riding's suggestion - at least that slope is fairly shallow.
Take care
Eric
===
On 29/05/2019 22:33, Adrien Monteleone wrote:
Thanks Eric for the clarification,
I found that I got a better handle on the reports after I just played around
with them for a bit. Some options are laid out or described in a way that while
technically accurate, can be obtuse if not confusing.
To see what each option does, I just started fiddling and clicking the
???Apply??? button to learn what their effect was. Sometimes reading Help
manuals actually helps, but in this case, I learned more by doing.
To your specific purpose, you might want to take a look at the following:
Balance Forecast
Average Balance
Cash Flow Bar Chart
Income & Expense Line Chart
Each of these (as most reports) can be set for just a single account, so you
can see what is happening to it alone if desired.
Also, the Multi-column report would allow you to have 2 or more (and other)
reports all on one tab, which you could always keep open as a sort of
???dashboard??? if you will. One of these might be a Balance Forecast chart
just for the Checking Account. Note, that chart offers you the option of a
???reserve amount??? and a ???target amount??? as lines you can display to see
if you are projected to cross a danger zone.
Regards,
Adrien
On May 29, 2019, at 4:05 PM, Eric Coates wrote:
Adrien (and any others sufficiently interested)
I'm assuming the question was meant for me (or is that just ego?):
It's a personal requirement in two senses (1) I make no use of the business features of
GnuCash and (2) it's because of that "fear of going into the red".
The first needs no comment.
The second, although now of less concern was, at one time, significant. To
simplify the real situation (almost to the point of triviality) we [see below]
have a current account (aka checking account) and a deposit account with
different banks. Transfers from the current account to the deposit account is
almost instantaneous, transfers in the opposite direction can take up to seven
days. Having all the upcoming payments from the current account already entered
allows for two situations:
(1) If there will be insufficient funds in the current account at some point it will
"flash red" and I will have time to arrange a covering transfer from deposit to
current.
(2) When our salaries/pensions are deposited (in the current account) I will be
able to see the expected month end balance and so, possibly, be able to
transfer cash to the deposit account (for its higher interest rate)
At the moment, in this low interest environment, the benefit of transferring to
the deposit account is, to a first and probably third approximation,
negligible. But I'm a man of habit!
I suppose what I'm doing is a form of budgeting.
I've never got into the reporting possibilities of GnuCash. To be frank - and
with no implied criticism - I have difficulty with interpreting the ones I've
glanced at. That may be because I use one set of books to keep track of my, my
wife's and our joint accounts so the shear number of sub-accounts can be a
little overpowering.
As an aside: I totally agree with your statement "the journey is part of the learning fun, even, or
especially if you take detours" - although I might be tempted to put the word "fun" in quotes,
"satisfaction" wouldn't need quotes.
Take care
Eric
==
On 29/05/2019 20:58, Adrien Monteleone wrote:
Out of curiosity, is this a personal requirement?
What is the end purpose?
If it is just to ???see??? what might transpire, the Future Scheduled
Transactions Summary report might be helpful. (as might the Budget module)
The reason I pose the above questions is I often find that the original
question of ???How do I do ???xyz??? isn???t the actual desired answer
because the questioner is already in a rabbit hole.
The real question is, removing all intermediate steps, what is the desired end
result? What are you trying to accomplish? What is the end goal?
Usually, going back to that fundamental question will yield a clearer answer
and result in a more efficient process or workflow to accomplish the task. (of
course, the journey is part of the learning fun, even, or especially if you
take detours)
Regards,
Adrien
On May 29, 2019, at 2:40 PM, Eric Coates wrote:
Hi
My requirement is that on the first of the month all transactions due before the last day of the month are
entered. My method does that but the one proposed by Bert Riding seems to be better. ("Seems" only
because I'll need to check it against my "boring scheme of work" at month end. Luckily we have one
of them coming up.) I knew of the "enter N d
Re: [GNC] Payment month after reconcile
At least ’today’ is better than ‘last month on some date’ as the OP noted. However, on that note, I wonder, is there an issue as to when certain features grab ‘current’ date? If someone never closes GC (or rarely does so) can this influence what is the ‘current date’ for some features? If so, perhaps that part of the code should be revisited. Just a thought... Regards, Adrien > On May 30, 2019, at 2:44 AM, Colin Law wrote: > > It would be nice to be able to specify a default value for the credit > card payment date after a reconcile, something like nnth of next month > for example. I can't find anything in the preferences that seems to > relate to this issue. At the moment for me it defaults to 'today' I > think. > > Colin ___ 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] Payment month after reconcile
It would be nice to be able to specify a default value for the credit card payment date after a reconcile, something like nnth of next month for example. I can't find anything in the preferences that seems to relate to this issue. At the moment for me it defaults to 'today' I think. Colin On Thu, 30 May 2019 at 07:56, Adrien Monteleone wrote: > > Thanks for that info Michael, > > Certainly, closing dates are guessed and probably attempt something like the > end of the previous month if close enough to the start of the next one, mid > month otherwise. (might be the case for the OP’s notice of the 16th being > chosen) > > As for default suggested payment dates, I guess that’s still an unknown, > though ‘current’ date as you mention (and as happens with the business > features) would seem a sane default choice the user could always override. > > Any insight you can offer on your next reconciliation would be helpful in > either pinning this down as a bug/enhancement opportunity or a case for > updating the documentation. > > Regards, > Adrien > > > On May 30, 2019, at 1:45 AM, Michael Hendry > > wrote: > > > >> On 30 May 2019, at 05:05, Adrien Monteleone > >> wrote: > >> > >> Thanks David, > >> > >> Now that you mention it, I vaguely seem to recall this from reading the > >> documentation. (I might retain a bit of info I don’t need from time to > >> time) > >> > >> Is there anyone who uses this feature (or that programmed it?) who can > >> shed light on the date defaults? > >> > >> Regards, > >> Adrien > > > > > > Morning, Adrien. > > > > I use the reconciliation feature both for bank and for credit card accounts. > > > > The system “guesses” the statement date, and usually gets it right. > > Occasionally it’s a day out, I don’t recall an instance of more than that > > but couldn’t swear to it. > > > > The default date offered for credit card payments following reconciliation > > seems never to be correct. As I know I always have to change it, I haven’t > > paid much attention to the date offered, but I think it’s “today’s date” - > > I couldn’t swear that a date before today’s doesn’t occur (as in the OP’s > > case), but I don’t believe I’ve seen that. > > > > I’m using 3.5 on Mac OS X High Sierra, and will pay more attention with the > > next batch of reconciliations. > > > > Michael > > > > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
