Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Thanks for your response but I just tried from both locations and I still have the same issue. From: john Sent: Wednesday, January 12, 2022 5:25 AM To: xraive . Cc: Mark Sutton ; gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during

Re: [GNC] Does GNUCash have an install DVD for Macintosh?

These things pop up from time to time. Sometimes they want a lot more money. It's absolutely permitted under the GPL, but you should recognize that they're competing with a free download. Five bucks is pretty reasonable for the effort of burning a CD for you. If you do buy it you should make

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Are you using our AIO bundle downloaded from https://sourceforge.net/projects/gnucash or https://github.com/gnucash/GnuCash , perhaps after linking through https://www.gnucash.org? This

[GNC] Import Transaction Manager (version 3.8) customization

Greetings, I am using GnuCash 3.8 (I haven't updated to a later version because I'm running Ubuntu 20.04 and don't want to take the time to set up to compile the source, nor do I want to be bothered with having to set up and work around the limitations of the flatpack installs. Once 22.04

Re: [GNC] Does GNUCash have an install DVD for Macintosh?

Derek, I was wondering, because someone has a GnuCash DVD for sale on eBay for $5.80 plus shipping. It is supposed to have Windows and Mac. I was interested in it, but thought that it could be a fraud, or malicious software. I found it at:

Re: [GNC] No install is needed

Thank you Alton. I will do what you recommended. Neal Lewis On 1/11/22 7:34 PM, Alton Brantley wrote: 1. Download the Mac software from Gnucash.org You will get a DMG file which you then open 2. Create a directory named “gnucash” in your /Application folder 3. Drag the contents from the

Re: [GNC] Does GNUCash have an install DVD for Macintosh?

1. As Derek noted, you should download the .dmg file. 2. When it finishes downloading, double-click it to open it. 3. Then open a second Finder window and navigate to your Applications folder. 4. Drag the GnuCash icon from the GnuCash.dmg window to the Applications folder in the second

Re: [GNC] Does GNUCash have an install DVD for Macintosh?

HI, All we distribute for MAC is the DMG. Make sure you download it in "binary" form. If you have a poor internet connection, I am sure that someone could write it to a CD for you and ship it to you, but it is not a "service" that we generally provide. -derek On Tue, January 11, 2022 8:15 pm,

[GNC] Does GNUCash have an install DVD for Macintosh?

Does GnuCash have an install DVD for Macintosh? I am running Mojave and would like to try GNUCash on my computer. The download that I did, did not seem to install correctly. Thank you for your help. wnlewis ___ gnucash-user mailing list

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

I'm in the Eastern Standard Time - Time zone in (GMT-5). From: gnucash-user on behalf of Mark Sutton Sent: Tuesday, January 11, 2022 10:55 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) what time

Re: [GNC] Trying to get report with total when account has sub-accounts

Thank you! I will definitely look at budget reports and the P/Income statement as alternatives. And thanks for the other advice as well, though after having massaged my various accounts/categories over the last 28-ish years (I started with CA-Simply Money), I'm pretty happy with how I have that

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

The [-5:EST] is in fact the problem. I think GNC posts in UTC. They even change that when daylight saving time comes into effect. I either made the change in vi or wrong a sed script. I'll have a look at what I did. On Tue, Jan 11, 2022 at 12:06:04PM -0800, Jean Laroche wrote: > > I wonder

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

what time zone are you in? 2:00AM (whether GMT, or EST) is still yesterday if you are GMT-8 ? On January 11, 2022 2:33:08 PM PST, "xraive ." wrote: >Sorry for the late response. I tried removing [-5:EST] and the issue still >persists. All the dates are still reported as one day earlier. I

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

This is what I have in my file. 20220101161409[-5:EST] From: David Reiser Sent: Tuesday, January 11, 2022 11:36 PM To: xraive . Cc: David Carlson ; gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) What do

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

What do the tag contents say about timezone? I have some ofx files from TDBanknorth (as it was known in the US back in 2007) where the field said the server was keeping time in GMT. None of the transactions declared a timezone, but all of the transaction times were 17. There was

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Yes I live in the same time zone as the time zone in the file. From: David Carlson Sent: Tuesday, January 11, 2022 10:57 PM To: xraive . Cc: Jean Laroche ; gnucash-user@gnucash.org Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Re: [GNC] Trying to get report with total when account has sub-accounts

Why not use the Budget Report? It rolls up sub accounts, and shows a variance if you like. I'm pretty certain you can restrict the accounts reported on as well to reduce clutter. Another option is to use the P/Income Statement, select just the expense accounts you want. There is an option

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

And do you live in the Eastern Standard Time zone? On Tue, Jan 11, 2022, 4:49 PM xraive . wrote: > If I haven't mentioned it, I'm running GNUCASH Version: 4.9 Build ID: > 4.9+(2021-12-18) on a Windows 10 PC. The time settings on this PC are > correct as far as I can tell. > > Thanks in

Re: [GNC] reports: filter by number

Do the bill#'s show up in the NUM field (or elsewhere) in your expense account registers? If so, my first suggestion would be to do a Find (from the CoA tab) filtering for the string you want. Then run an Account Report (or File > Export > Active Tab to CSV) on the Find results tab. Let

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

If I haven't mentioned it, I'm running GNUCASH Version: 4.9 Build ID: 4.9+(2021-12-18) on a Windows 10 PC. The time settings on this PC are correct as far as I can tell. Thanks in advance. From: xraive . Sent: Tuesday, January 11, 2022 10:33 PM To: David

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Sorry for the late response. I tried removing [-5:EST] and the issue still persists. All the dates are still reported as one day earlier. I imported the same file in MSMoney and the dates matched the banks if that helps. Thanks for your assistance so far. From: gnucash-user on behalf of

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

That -5 EST relates local time to universal time and may come into play if the local computer clock is not set to the local time zone. Usually it clarifies the source time reference of the data. On Tue, Jan 11, 2022, 2:07 PM Jean Laroche wrote: > > I wonder what happens if the "[-5:EST]" gets

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

I wonder what happens if the "[-5:EST]" gets removed. The dates seem to have 0200 as their time; subtracting 5 hours from that would return -3 o'clock (and presumably shift the date back one). You could do a test where you modify your OFX file to remove [-5:EST] from all transactions (you

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

But EFT transactions (which are the bulk of my txns these days) shouldn't get shifted around much at all. I'd be miffed if every EFT entry were a day off. Original Message From: Gyle McCollam Sent: Tue Jan 11 13:33:51 EST 2022 To: "D." Cc: "gnucash-user@gnucash.org"

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

I find my dates usualy do not agree with the bank dates. I record credit card bills when I pay them (electronically) and they are recorded by the payee on the same date. However, they usually hit my bank the next banking day. This isn't and shouldn't be a problem or concern. Actual physical

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

I'd be annoyed at the shift. I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to have 0200 as their time; subtracting 5 hours from that would return -3 o'clock (and presumably shift the date back one). Original Message From: David Carlson Sent: Tue Jan

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Your bank creates the Ofx file. Gnucash just accepts what they give you. Sometimes it may appear to be incorrect when it is a misunderstanding about whether transactions are posted on the same day they occur. Does it really make a difference? On Tue, Jan 11, 2022, 10:12 AM xraive . wrote:

[GNC] Transaction Date issues during import OFX file (TD Bank)

I downloaded transactions from my bank (TD) in Canada and when I tried importing the file into GNUCASH all the dates were set to one day earlier then the actual transactions. I'm including sample transactions below. OFX file imported to GNUCASH DEBIT 2021072202[-5:EST] -14.64

[GNC] Trying to get report with total when account has sub-accounts

To update my budget projections, monthly I run a transaction report to show what I've spent on 2 expense accounts over the past 12 months. One of the expense accounts has a sub-account. Let's call them Groceries and Dining Out, where Dining Out has sub-account Delivery Charges. I cannot figure

[GNC] reports: filter by number

Hi all! I live in Belgium and am using GnuCash and its business features for my (small) company accounting. I'm running GnuCash 4.4 on Ubuntu Mate 20.04 LTS. I've composed a custom CoA in compliance to local accounting laws. My accountant told me to register all transactions through one of 4

Re: [GNC] Gnucash import QIF issue

Thanks for your advice I did manage to import a partial QIF file of my records. And so have now had a look at Gnucash. At the moment I don’t think it is worth me moving from my Quicken XG2004 as Gnucash is not quite as good yet (can’t see how to import share prices and overall not as easy