Re: [GNC] Can I get help with GnuCash here

[Geoff]

Hi Bob

First, a matter of email list etiquette.  Please always reply to the 
list email address (gnucash-user@gnucash.org) so that everyone can see 
your questions and answers.


Second, unfortunately I don't have any experience with either MAC or the 
GnuCash OFX/QFX importer, so I can't assist you with this particular 
problem apart from a couple of pointers:
* Has the bank that provides the 4th credit card recently changed their 
IT systems?
* Can you compare one of the failed OFX/QFX files to an earlier 
(successful) version, or to one from another bank?
* There have been some changes to the OFX/QFX routines in GnuCash 
version 5 (https://gnucash.org/news.phtml) - perhaps you could try 
upgrading to the latest version?  *Be sure to take a backup first*.


Hopefully someone else on this list can chime in with further suggestions.

Regards

Geoff
=


On 8/04/2024 3:10 pm, R7 wrote:

Geoff,
I am using Ver 4.9, Build ID 4.9+(2021-12-18) of GnuCash.
My computer is a MAC M1 with Sonoma 14.2.1.
Problem: I have 4 credit cards where I go into each in order to download 
the transactions. I use OFX/QFX for my downloads. Three of the four work 
perfectly however on the fourth transaction-download, all the 
transactions download perfectly. I then allocate each transaction to an 
expense or income account. When I finished and all the transactions are 
in the green I hit the submit button and all of the transactions 
disappear as they should. Then I look over to my register for that 
particular credit card and all those transactions that I just submitted 
disappear. I then Iook throughout all my register and cannot find those 
transactions...they just went poof. It is strange it happens on only one 
credit card account.
Please note, I have been using GnuCash for several years and have never 
had this problem up until now...it is most disturbing.

Can you help me?
Bob

On 4/7/24 8:19 PM, Geoff wrote:
Greetings Dr. Robert L. Kieffer, and welcome to the wonderful world of 
GnuCash!


Yes, you most certainly have come to the right place.  Just send 
through the following information:

* Your computer operating system type & version:
(Windows 10 / Linux Mint 21.3 / macOS Sonoma / ...)
* Your version of GnuCash
(Help -> About)
* Your question / problem

And, to paraphrase the former president you quoted, "Do you best, the 
Internet will do the rest."


Regards

Geoff
=

On 8/04/2024 10:56 am, R7 wrote:
>I need some help with GnuCash..is this the place to get it?
>
>*R7eagle*
>
>Dr. Robert L. Kieffer
>
>Waukegan, IL.
>
>*r...@r7eagle.com*
>
>224-800-1128
>
>**
>
>/There is nothing new in this world, only history we do not know!/





*R7eagle*

Dr. Robert L. Kieffer

Waukegan, IL.

*r...@r7eagle.com*

224-800-1128



**

/There is nothing new in this world, only history we do not know!/







___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can I get help with GnuCash here

[David H]

If it’s only happening with one register I’d be checking I don’t have any
filtering on for that particular register ?

Cheers David H.

On Mon, 8 Apr 2024 at 5:28 pm, Geoff  wrote:

> Hi Bob
>
> First, a matter of email list etiquette.  Please always reply to the
> list email address (gnucash-user@gnucash.org) so that everyone can see
> your questions and answers.
>
> Second, unfortunately I don't have any experience with either MAC or the
> GnuCash OFX/QFX importer, so I can't assist you with this particular
> problem apart from a couple of pointers:
> * Has the bank that provides the 4th credit card recently changed their
> IT systems?
> * Can you compare one of the failed OFX/QFX files to an earlier
> (successful) version, or to one from another bank?
> * There have been some changes to the OFX/QFX routines in GnuCash
> version 5 (https://gnucash.org/news.phtml) - perhaps you could try
> upgrading to the latest version?  *Be sure to take a backup first*.
>
> Hopefully someone else on this list can chime in with further suggestions.
>
> Regards
>
> Geoff
> =
>
>
> On 8/04/2024 3:10 pm, R7 wrote:
> > Geoff,
> > I am using Ver 4.9, Build ID 4.9+(2021-12-18) of GnuCash.
> > My computer is a MAC M1 with Sonoma 14.2.1.
> > Problem: I have 4 credit cards where I go into each in order to download
> > the transactions. I use OFX/QFX for my downloads. Three of the four work
> > perfectly however on the fourth transaction-download, all the
> > transactions download perfectly. I then allocate each transaction to an
> > expense or income account. When I finished and all the transactions are
> > in the green I hit the submit button and all of the transactions
> > disappear as they should. Then I look over to my register for that
> > particular credit card and all those transactions that I just submitted
> > disappear. I then Iook throughout all my register and cannot find those
> > transactions...they just went poof. It is strange it happens on only one
> > credit card account.
> > Please note, I have been using GnuCash for several years and have never
> > had this problem up until now...it is most disturbing.
> > Can you help me?
> > Bob
> >
> > On 4/7/24 8:19 PM, Geoff wrote:
> >> Greetings Dr. Robert L. Kieffer, and welcome to the wonderful world of
> >> GnuCash!
> >>
> >> Yes, you most certainly have come to the right place.  Just send
> >> through the following information:
> >> * Your computer operating system type & version:
> >> (Windows 10 / Linux Mint 21.3 / macOS Sonoma / ...)
> >> * Your version of GnuCash
> >> (Help -> About)
> >> * Your question / problem
> >>
> >> And, to paraphrase the former president you quoted, "Do you best, the
> >> Internet will do the rest."
> >>
> >> Regards
> >>
> >> Geoff
> >> =
> >>
> >> On 8/04/2024 10:56 am, R7 wrote:
> >> >I need some help with GnuCash..is this the place to get it?
> >> >
> >> >*R7eagle*
> >> >
> >> >Dr. Robert L. Kieffer
> >> >
> >> >Waukegan, IL.
> >> >
> >> >*r...@r7eagle.com*
> >> >
> >> >224-800-1128
> >> >
> >> >**
> >> >
> >> >/There is nothing new in this world, only history we do not know!/
> >
> >
> >
> >
> > *R7eagle*
> >
> > Dr. Robert L. Kieffer
> >
> > Waukegan, IL.
> >
> > *r...@r7eagle.com*
> >
> > 224-800-1128
> >
> >
> >
> > **
> >
> > /There is nothing new in this world, only history we do not know!/
> >
> >
> >
> >
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can't import .qif files from quicken since latest update

[Joseph Keithley]

Both version 5.6 and 5.6-1 reject my credit card qif import with the
following message:

"Missing QIF investment action for transaction dated 04/06/2024."

Reinstalled version 5.5 and imported the qif successfully.

On Sun, Apr 7, 2024 at 9:39 PM Geoff  wrote:

> Hi Christopher
>
> Thanks for resolving this so quickly.
>
> I have successfully imported both my Bank Statement and Credit Card QIF
> files on Windows 10 using this nightly build:
>
> gnucash-5.6-2024-04-06-git-5.6-9-gcab6173cd5+.setup.exe
>
> If anyone is interested, this is the layout of my QIF files.  Only the
> first two transactions are shown.  Ignore the equals signs (=).
>
> Bank Statement
> ==
> !Account
> NAssets:Bank Accounts:GNC Savings Bank
> TBank
> ^
> !Type:Bank
> D03/03/24
> T123.45
> N
> PBEING A PRESIDENT IS LIKE RIDING A TIGER
> L
> ^
> D03/03/24
> T-987.65
> N
> PA MAN HAS TO KEEP ON RIDING OR BE SWALLOWED
> LExpenses:Medical:Insurance
> ^
> ==
>
> Credit Card
> ===
> NLiabilities:Credit Cards:GNC Mastercard
> TBank
> ^
> !Type:Bank
> D02/03/24
> T-12.34
> PI NEVER SIT ON A FENCE.
> L
> ^
> D02/03/24
> T-135.79
> PI AM EITHER ON ONE SIDE OR ANOTHER.
> LExpenses:Medical:Surgery
> ^
> ===
>
>
> Regards
>
> Geoff
> =
>
>
> On 7/04/2024 7:25 pm, Christopher Lam wrote:
> > Correct Geoff, and the latest nightlies will have the correct fix.
> >
> >   https://code.gnucash.org/builds/win32/stable/
> >
> > On Sun, 7 Apr 2024, 12:10 pm Geoff,  wrote:
> >
> >> I suspect this bug fix in the 5.6 release notes is the cause:
> >>
> >> Bug 799225 - QIF Importer Crashes Silently after "Start Import" Button:
> >> Don't allow a QIF investment transaction without an action
> (buy/sell/etc)
> >>
> >> I *think* it was intended to block *investment* transactions but it
> >> appears to have blocked *banking* transactions too?
> >>
> >> Geoff
> >> =
> >>
> >> On 7/04/2024 11:44 am, Ian Cuthbertson wrote:
> >>> Bryan
> >>> This problem seems to be caused by the latest update (5.6) .I import
> >>> direct from a bank and got the same error message but when I used an
> >>> earlier version (5.4) transactions imported OK. Problem has been
> reported
> >>> in another thread.
> >>> Ian
> >>> ___
> >>> 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.
> ___
> 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.
>


-- 
iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can't import .qif files from quicken since latest update

[Joseph Keithley]

Just out of curiosity is the word "Discover" somehow a protected word,
function, directive or key word in the Gnucash code?  Everytime I import my
Discover Card qif it asks me for the date format.  No other qif import does.

On Mon, Apr 8, 2024 at 4:38 AM Joseph Keithley  wrote:

> Both version 5.6 and 5.6-1 reject my credit card qif import with the
> following message:
>
> "Missing QIF investment action for transaction dated 04/06/2024."
>
> Reinstalled version 5.5 and imported the qif successfully.
>
> On Sun, Apr 7, 2024 at 9:39 PM Geoff  wrote:
>
>> Hi Christopher
>>
>> Thanks for resolving this so quickly.
>>
>> I have successfully imported both my Bank Statement and Credit Card QIF
>> files on Windows 10 using this nightly build:
>>
>> gnucash-5.6-2024-04-06-git-5.6-9-gcab6173cd5+.setup.exe
>>
>> If anyone is interested, this is the layout of my QIF files.  Only the
>> first two transactions are shown.  Ignore the equals signs (=).
>>
>> Bank Statement
>> ==
>> !Account
>> NAssets:Bank Accounts:GNC Savings Bank
>> TBank
>> ^
>> !Type:Bank
>> D03/03/24
>> T123.45
>> N
>> PBEING A PRESIDENT IS LIKE RIDING A TIGER
>> L
>> ^
>> D03/03/24
>> T-987.65
>> N
>> PA MAN HAS TO KEEP ON RIDING OR BE SWALLOWED
>> LExpenses:Medical:Insurance
>> ^
>> ==
>>
>> Credit Card
>> ===
>> NLiabilities:Credit Cards:GNC Mastercard
>> TBank
>> ^
>> !Type:Bank
>> D02/03/24
>> T-12.34
>> PI NEVER SIT ON A FENCE.
>> L
>> ^
>> D02/03/24
>> T-135.79
>> PI AM EITHER ON ONE SIDE OR ANOTHER.
>> LExpenses:Medical:Surgery
>> ^
>> ===
>>
>>
>> Regards
>>
>> Geoff
>> =
>>
>>
>> On 7/04/2024 7:25 pm, Christopher Lam wrote:
>> > Correct Geoff, and the latest nightlies will have the correct fix.
>> >
>> >   https://code.gnucash.org/builds/win32/stable/
>> >
>> > On Sun, 7 Apr 2024, 12:10 pm Geoff,  wrote:
>> >
>> >> I suspect this bug fix in the 5.6 release notes is the cause:
>> >>
>> >> Bug 799225 - QIF Importer Crashes Silently after "Start Import" Button:
>> >> Don't allow a QIF investment transaction without an action
>> (buy/sell/etc)
>> >>
>> >> I *think* it was intended to block *investment* transactions but it
>> >> appears to have blocked *banking* transactions too?
>> >>
>> >> Geoff
>> >> =
>> >>
>> >> On 7/04/2024 11:44 am, Ian Cuthbertson wrote:
>> >>> Bryan
>> >>> This problem seems to be caused by the latest update (5.6) .I import
>> >>> direct from a bank and got the same error message but when I used an
>> >>> earlier version (5.4) transactions imported OK. Problem has been
>> reported
>> >>> in another thread.
>> >>> Ian
>> >>> ___
>> >>> 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.
>> ___
>> 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.
>>
>
>
> --
> iii
>


-- 
iii
___
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] Keep running into "Could not get lock file for postgres..."

[john]

It usually means that GnuCash is not quitting cleanly. Are there any errors in 
the tracefile? (https://wiki.gnucash.org/wiki/Tracefile).

 In the SQL backend it's actually a record in the gnclock table, so a simpler 
work-around would be to use the postgres CLI to remove that record.

Regards,
John Ralls

> On Apr 5, 2024, at 22:14, Bryan B.  wrote:
> 
> For some reason, GnuCash has started having some issue when I'm opening it
> where it will say "Could not obtain lock file for
> postgres://postgres@localhost/gnucash_personal"
> Then it gives a few options to use the file anyway, such as to use it in
> read-only mode, etc.
> 
> I found a temporary work around by opening it anyway, saving it to xml,
> dropping then recreating my postgresql database, and then reopening the xml
> file and resaving it to the postgresql database.
> 
> Any ideas on why this would be happening and how to resolve it?
> ___
> 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] CSS GTK Register padding/spacing

[J R via gnucash-user]

 Thanks Ken, I just tried yours, still the same. I also tried adding 
transparent borders & margins. As we get older we need a little flexibility. 
All the other css "tags' not a problem
Although I was using: "user".gnc-class-user-register-primary {  
background-color: #403f3f;  color: white;  padding-top: 11px;  padding-bottom: 
11px; }
I do more graphics work so accessibility in Win 11 would not helpJust the 
register lines a little too close
On Sunday, April 7, 2024 at 10:42:13 PM EDT, Ken Farley 
 wrote:  
 
 Don't know if you ever solved this, or if a solution is possible, but 
these are the lines from my GTK3 CSS file that deal with the register lines.

*.gnc-class-register-primary
{
   background-color: @hueRegLight ;
   color:    @hueTextNormal ;
}

*.gnc-class-register-secondary
{
   background-color: @hueRegDark ;
   color:    @hueTextNormal ;
}

I don't know if the padding values are available to change. You'd have 
to try it. First, make sure you are setting the register settings that 
are available by making the color something ridiculous like pink, to be 
sure your syntax is correct. You can always change it back to white or 
whatever you were using. I have variables set in my CSS file that I can 
reference in many setting statements, so if I want to change a setting 
for "normal text" everywhere, I only have to change it once, at the 
beginning of the file.
___
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] gnucash-devel list down?

[Adrien Monteleone]

An announcement posted on 4/2 came through for me.

And while you can get to it here:

https://lists.gnucash.org/mailman/listinfo/gnucash-devel

The archive link returns a Not Found.

Regards,
Adrien

On 4/7/24 8:50 PM, Michael or Penny Novack wrote:
I have received nothing from that list since 3/22   The on-line site for 
the mailman list is still up (but I never communicate with mailman that 
way)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Recording transactions (date)

[R Losey]

Since I first learned about recording transactions, I have always dated a
transaction on the date I wrote the check; similarly, when entering credit
card transactions, I use the date that I actually used the credit card.

Recently, however, I was having a discussion with a friend and he said that
he uses the bank or credit card date of entry for all of his transactions.

I thought this was strange - probably because it is different from the
method I've used all of my life. Perhaps I am the odd one... or perhaps
it's merely a matter of choice, so I thought I'd bring it up to this list
to see what people think about it.

>From (a very brief) research about this topic, perhaps this is the
difference between cash basis accounting and accrual accounting?


After thinking about it for a bit, one issue with using the date that the
transactions occur is the reports, especially if one has repeating
transactions.  For example, if the satellite service bill is paid each
month on the 28th, using my method, I record a transaction on the 28th. My
friend will see it on the 29th or 30th, but if the weekend or holiday hits
just right, it can be the 1st or 2nd before he sees it. In the long run
everything should be the same, but the monthly sub-totals can look odd.
Checks can be even worse... someone may hang onto one for weeks.

I'd appreciate thoughts on the topic.
-- 
_
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.

[GNC] Import QIF files

[Beryl Lymer]

I have been importing QIF files into GNUcash successfully for several years. 
However, for recent files, I am getting an error of ‘MISSING QIF INVESTMENT 
ACTION FOR TRANSACTION DATED xx/xx/.  The erroneous transaction seems to be 
the last of those imported.  The import will not complete.  I have had to 
manually enter all the transactions.

I am downloading the files from Santander online banking.  Not sure if it is 
Santander or Gnucash that’s the issue.

Beryl
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] OFX duplicate transactions and missing ones.

[Jeffrey Black]

Right now I am limited to using my phone for e-mail so I cannot search for 
related mails or bug reports easily. I had multiple line surges that fried 3 
towers and my laptop computer.  Not to mention a cascade failure of all of my 
hard-drives and backup drives and printers.

Somewhere along the way, under Ubuntu, snaphub (I thought it was snapd) updated 
from 5.? To 5.6, to 5.6-1 so I do not remember which version I used. But, it 
created duplicate transactions of ofx imports which is a nightmare since I did 
the imports on a 30-day cycle. Now that I am attempting to reconcile the 
affected accounts, I discover that there are missing transactions as well.

Has anyone reported this?

Or should I just create a new imbalance‐USD to balance the books? I am talking 
about imports thar were a couple of months late.  Yes I know sloppy work on my 
part.



Get Outlook for Android
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash-devel list down?

[Liz]

On Sun, 7 Apr 2024 18:39:07 -0700
Bruce Schuck  wrote:

> Odd, after sending a message to the gnucash-devel list early this 
> morning, I received an email saying my message was in a queue because 
> I'm not subscribed. Odd, I've been subscribed for at least a handful
> of years.
> 
> I also notice that it does not show up in the list of lists at 
> https://lists.gnucash.org/mailman/listinfo. At least I *think* I 
> remember it would be listed.
> 
> Is the gnucash-devel list down? Or have I somehow become unsubscribed?
> 
> Thanks.
> 
> Bruce S

It appears to have had a upset at the server side.
I managed to get to the list of moderator requests and dump the spam
this morning, and your email did not appear in the list of messages
waiting.
Then I could not get any further with reaching any of the gnucash-devel
pages.
Derek runs the server, I'm sure he will look into the problem.

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] Recording transactions (date)

[Liz]

On Mon, 8 Apr 2024 17:11:37 -0500
R Losey  wrote:

> Since I first learned about recording transactions, I have always
> dated a transaction on the date I wrote the check; similarly, when
> entering credit card transactions, I use the date that I actually
> used the credit card.
> 
> Recently, however, I was having a discussion with a friend and he
> said that he uses the bank or credit card date of entry for all of
> his transactions.
> 
> I thought this was strange - probably because it is different from the
> method I've used all of my life. Perhaps I am the odd one... or
> perhaps it's merely a matter of choice, so I thought I'd bring it up
> to this list to see what people think about it.
> 
> From (a very brief) research about this topic, perhaps this is the
> difference between cash basis accounting and accrual accounting?
> 
> 
> After thinking about it for a bit, one issue with using the date that
> the transactions occur is the reports, especially if one has repeating
> transactions.  For example, if the satellite service bill is paid each
> month on the 28th, using my method, I record a transaction on the
> 28th. My friend will see it on the 29th or 30th, but if the weekend
> or holiday hits just right, it can be the 1st or 2nd before he sees
> it. In the long run everything should be the same, but the monthly
> sub-totals can look odd. Checks can be even worse... someone may hang
> onto one for weeks.
> 
> I'd appreciate thoughts on the topic.

I think it is a philosophical difference.
There are legal ramifications, especially when you are spending money.
If you future date transactions you may spend money you don't actually
have. In my jurisdiction a business doing this is in big trouble, for
"trading while insolvent". 
It is not the difference between cash and accrual accounting, but is
part of the differences.

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] Import QIF files

[Jim Passmore]

Beryl,
I can't help on the specifics as I only occasionally do imports.  I will
give the request to supply your operating system and GnuCash version when
reporting a problem.

Also, and the main reason I replied, is to point out two emails in the same
day with that same error message while doing an import.  The other user was
using the recently released version 5.6.

-- 

*Jim Passmore*j...@passmore4.com




On Mon, Apr 8, 2024 at 6:38 PM Beryl Lymer  wrote:

> I have been importing QIF files into GNUcash successfully for several
> years. However, for recent files, I am getting an error of ‘MISSING QIF
> INVESTMENT ACTION FOR TRANSACTION DATED xx/xx/.  The erroneous
> transaction seems to be the last of those imported.  The import will not
> complete.  I have had to manually enter all the transactions.
>
> I am downloading the files from Santander online banking.  Not sure if it
> is Santander or Gnucash that’s the issue.
>
> Beryl
> ___
> 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] Import QIF files

[fromvendor]

Hi, I saw yesterday, I think, that there is an update to address this issue 
regarding regular QIF imports (vs investment ones).  That would require 
installing the latest fix update if I understood what I read.
-g

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of 
Jim Passmore
Sent: Monday, April 08, 2024 6:01 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Import QIF files

Beryl,
I can't help on the specifics as I only occasionally do imports.  I will
give the request to supply your operating system and GnuCash version when
reporting a problem.

Also, and the main reason I replied, is to point out two emails in the same
day with that same error message while doing an import.  The other user was
using the recently released version 5.6.

-- 

*Jim Passmore*j...@passmore4.com




On Mon, Apr 8, 2024 at 6:38 PM Beryl Lymer  wrote:

> I have been importing QIF files into GNUcash successfully for several
> years. However, for recent files, I am getting an error of ‘MISSING QIF
> INVESTMENT ACTION FOR TRANSACTION DATED xx/xx/.  The erroneous
> transaction seems to be the last of those imported.  The import will not
> complete.  I have had to manually enter all the transactions.
>
> I am downloading the files from Santander online banking.  Not sure if it
> is Santander or Gnucash that’s the issue.
>
> Beryl
> ___
> 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] Can't import .qif files from quicken since latest update

[Geoff]

I doubt it - I am often prompted for the data format when doing QIF imports.

Geoff
=

On 8/04/2024 6:41 pm, Joseph Keithley wrote:
Just out of curiosity is the word "Discover" somehow a protected word, 
function, directive or key word in the Gnucash code?  Everytime I import 
my Discover Card qif it asks me for the date format.  No other qif 
import does.


On Mon, Apr 8, 2024 at 4:38 AM Joseph Keithley > wrote:


Both version 5.6 and 5.6-1 reject my credit card qif import with the
following message:

"Missing QIF investment action for transaction dated 04/06/2024."

Reinstalled version 5.5 and imported the qif successfully.

On Sun, Apr 7, 2024 at 9:39 PM Geoff mailto:cleanoutmys...@gmail.com>> wrote:

Hi Christopher

Thanks for resolving this so quickly.

I have successfully imported both my Bank Statement and Credit
Card QIF
files on Windows 10 using this nightly build:

gnucash-5.6-2024-04-06-git-5.6-9-gcab6173cd5+.setup.exe

If anyone is interested, this is the layout of my QIF files. 
Only the

first two transactions are shown.  Ignore the equals signs (=).

Bank Statement
==
!Account
NAssets:Bank Accounts:GNC Savings Bank
TBank
^
!Type:Bank
D03/03/24
T123.45
N
PBEING A PRESIDENT IS LIKE RIDING A TIGER
L
^
D03/03/24
T-987.65
N
PA MAN HAS TO KEEP ON RIDING OR BE SWALLOWED
LExpenses:Medical:Insurance
^
==

Credit Card
===
NLiabilities:Credit Cards:GNC Mastercard
TBank
^
!Type:Bank
D02/03/24
T-12.34
PI NEVER SIT ON A FENCE.
L
^
D02/03/24
T-135.79
PI AM EITHER ON ONE SIDE OR ANOTHER.
LExpenses:Medical:Surgery
^
===


Regards

Geoff
=


On 7/04/2024 7:25 pm, Christopher Lam wrote:
 > Correct Geoff, and the latest nightlies will have the correct
fix.
 >
 > https://code.gnucash.org/builds/win32/stable/

 >
 > On Sun, 7 Apr 2024, 12:10 pm Geoff, mailto:cleanoutmys...@gmail.com>> wrote:
 >
 >> I suspect this bug fix in the 5.6 release notes is the cause:
 >>
 >> Bug 799225 - QIF Importer Crashes Silently after "Start
Import" Button:
 >> Don't allow a QIF investment transaction without an action
(buy/sell/etc)
 >>
 >> I *think* it was intended to block *investment* transactions
but it
 >> appears to have blocked *banking* transactions too?
 >>
 >> Geoff
 >> =
 >>
 >> On 7/04/2024 11:44 am, Ian Cuthbertson wrote:
 >>> Bryan
 >>> This problem seems to be caused by the latest update (5.6)
.I import
 >>> direct from a bank and got the same error message but when
I used an
 >>> earlier version (5.4) transactions imported OK. Problem has
been reported
 >>> in another thread.
 >>> Ian
 >>> ___
 >>> 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.
___
gnucash-user mailing list
gnucash

Re: [GNC] Import QIF files

[Geoff]

Hi Beryl

This particular error is a problem with GnuCash version 5.6, and was 
resolved by one of the developers on Sunday:


https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111404.html

You have three choices:
(1) Downgrade to GnuCash version 5.5
https://gnucash.org/download.phtml

(2) Upgrade to the latest nightly build that contains the fix
https://code.gnucash.org/builds/

(3) Wait until GnuCash 5.7 is released.

Regards

Geoff
=

On 8/04/2024 6:41 am, Beryl Lymer wrote:

I have been importing QIF files into GNUcash successfully for several years. 
However, for recent files, I am getting an error of ‘MISSING QIF INVESTMENT 
ACTION FOR TRANSACTION DATED xx/xx/.  The erroneous transaction seems to be 
the last of those imported.  The import will not complete.  I have had to 
manually enter all the transactions.

I am downloading the files from Santander online banking.  Not sure if it is 
Santander or Gnucash that’s the issue.

Beryl
___
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] Recording transactions (date)

[Christopher Lam]

This is the formal terminology that the accountancy expert bodies deem
"revenue recognition". Numerous formal (see IFRS and GAAP) publications
exist, with a much better supporting evidence than our informal discussions
here.

On Tue, 9 Apr 2024, 6:12 am R Losey,  wrote:

> Since I first learned about recording transactions, I have always dated a
> transaction on the date I wrote the check; similarly, when entering credit
> card transactions, I use the date that I actually used the credit card.
>
> Recently, however, I was having a discussion with a friend and he said that
> he uses the bank or credit card date of entry for all of his transactions.
>
> I thought this was strange - probably because it is different from the
> method I've used all of my life. Perhaps I am the odd one... or perhaps
> it's merely a matter of choice, so I thought I'd bring it up to this list
> to see what people think about it.
>
> From (a very brief) research about this topic, perhaps this is the
> difference between cash basis accounting and accrual accounting?
>
>
> After thinking about it for a bit, one issue with using the date that the
> transactions occur is the reports, especially if one has repeating
> transactions.  For example, if the satellite service bill is paid each
> month on the 28th, using my method, I record a transaction on the 28th. My
> friend will see it on the 29th or 30th, but if the weekend or holiday hits
> just right, it can be the 1st or 2nd before he sees it. In the long run
> everything should be the same, but the monthly sub-totals can look odd.
> Checks can be even worse... someone may hang onto one for weeks.
>
> I'd appreciate thoughts on the topic.
> --
> _
> 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.
>
___
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] Recording transactions (date)

[Adrien Monteleone]

While there are other considerations, such as cash versus accrual and 
following the Recognition Principle, I see this as more of a general 
case of Your Books vs. the Bank's Books.


You keep Your Books.

The Bank keeps theirs.

You then reconcile the two. (which does *not* involve changing dates)

Simply copying what the bank has misses the opportunity to catch someone 
else's errors. (they *do* happen)


This is a similar question of entering your own transactions as they 
occur, or just downloading from the bank and importing.


It is a personal choice, but can have other implications as noted.

Regards,
Adrien

On 4/8/24 5:11 PM, R Losey wrote:

Since I first learned about recording transactions, I have always dated a
transaction on the date I wrote the check; similarly, when entering credit
card transactions, I use the date that I actually used the credit card.

Recently, however, I was having a discussion with a friend and he said that
he uses the bank or credit card date of entry for all of his transactions.

I thought this was strange - probably because it is different from the
method I've used all of my life. Perhaps I am the odd one... or perhaps
it's merely a matter of choice, so I thought I'd bring it up to this list
to see what people think about it.

 From (a very brief) research about this topic, perhaps this is the
difference between cash basis accounting and accrual accounting?


After thinking about it for a bit, one issue with using the date that the
transactions occur is the reports, especially if one has repeating
transactions.  For example, if the satellite service bill is paid each
month on the 28th, using my method, I record a transaction on the 28th. My
friend will see it on the 29th or 30th, but if the weekend or holiday hits
just right, it can be the 1st or 2nd before he sees it. In the long run
everything should be the same, but the monthly sub-totals can look odd.
Checks can be even worse... someone may hang onto one for weeks.


___
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] I'm looking at installing GnuCash but has a couple of questions first

[Liz]

On Tue, 09 Apr 2024 17:03:53 +1200
"Robert Dew"  wrote:

> I have a a number of small, separate, but interconnected companies
> that I'd like to have separate accounting systems for.
> 
> Does GnuCash allow for multiple businesses,
Yes
> or would I need to
> install a separate version for each business
No
> 
> It's a little unclear if GnuCash operates, or can be made to operate,
> via a remote web browser.
No
> I see references to using X-windows which
> would be an acceptable option, web/browser based would be my
> preference.
You can use a VNC system if you wish.
You can host your datafiles at home and then use the Gnucash program
from a roaming computer to use that datafile and save back to your
storage.
> 
> Is there any restrictions on the self hosted version. 
No


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.