[GNC] Warning account contains splits whose reconcile date is after statement date

2022-01-31 Thread Cricket Onebit
I get this warning each time I reconcile my credit card statement. It's happened for several months now. The balance is fine. There was a bit of confusion over similar lines, but the balances are now fine. (it was a really good series of $10.19 books.) The latest statement was Jan 10. The last tr

[GNC] Lock file problems -- won't open current file, claiming can't get lockfile

2021-02-04 Thread Cricket Onebit
Even if I save immediately before closing the program, it refuses to open the file. I'm making do with Open Anyways, then Save As and changing the file name, but I don't think that's a good plan for the long run. Any ideas? -- +++ Not as a ladder from earth to Heaven, not as a witness to any cr

Re: [GNC] Fix assets

2019-05-22 Thread Cricket Onebit
Is it really worth doing that in GNUCash? Every type of asset depreciates differently, and you have different types of depreciation (tax, resale, saving to replace). Also, the value of your building for insurance might be replacement cost, which is very different from what you could sell it for. O

Re: [GNC] De-Reconciliation Settings

2019-05-08 Thread Cricket Onebit
I vote strongly that reconciliation status should never change without a warning that's hard to ignore. That's safest for the users, especially those of us with fat fingers, and easier to program. Finding which transaction to re-reconcile can be difficult unless I catch it right away. The only clu

Re: [GNC] Changing account tree on large database

2019-05-07 Thread Cricket Onebit
.montele...@lusfiber.net> wrote: > > > > On Apr 26, 2019, at 9:49 PM, Cricket Onebit > wrote: > > > > On Fri, 26 Apr 2019 at 22:14, Tommy Trussell > > wrote: > > > >> > >> On Fri, Apr 26, 2019 at 8:49 PM Cricket Onebit <

Re: [GNC] Changing account tree on large database

2019-05-07 Thread Cricket Onebit
ney grab looks bad.) On Sat, 27 Apr 2019 at 12:21, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > > On Apr 26, 2019, at 8:49 PM, Cricket Onebit > wrote: > > > > > > > > (Aside: https://wiki.gnucash.org/wiki/FAQ#SQL_Database recom

Re: [GNC] Quicken import and duplicate records

2019-05-07 Thread Cricket Onebit
Can someone edit that page in the wiki? It would help new users a lot. On Mon, 29 Apr 2019 at 17:00, David Carlson wrote: > The wiki that David Cousins pointed you to does not mention the fact that > GnuCash can only find duplicates to transactions that already exist in the > data. Thus to avoi

Re: [GNC] Changing account tree on large database

2019-05-07 Thread Cricket Onebit
< adrien.montele...@lusfiber.net> wrote: > > > > On Apr 26, 2019, at 4:28 PM, Cricket Onebit > wrote: > > > > > > > > Also, for this particular example, I’d opt for tags for each kid instead > of accounts, see below about Cars. > > > > I didn

Re: [GNC] Changing account tree on large database

2019-05-07 Thread Cricket Onebit
d that exporting the same data as CSV > and opening in Excel gave me good hints about what I was looking at in the > OFX or QIF > > > > > Kind regards, > > Greg Feneis > > > > > On Fri, Apr 26, 2019 at 8:06 PM Cricket Onebit > > wrote: > > &g

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
> > You WILL almost certainly see some strangeness in the imported data > because Quicken doesn't strictly enforce balanced transactions as GnuCash > does. When you're just dealing with a few years, you may find it easy to go > back and fix the odd strange transactions in Quicken, and start the imp

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
On Fri, 26 Apr 2019 at 22:14, Tommy Trussell wrote: > > On Fri, Apr 26, 2019 at 8:49 PM Cricket Onebit > wrote: > >> The speed thing is disappointing. I thought 3.5 fixed that, but maybe not >> enough. I planned to save as XML to get going, since the docs say it&#x

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
Somewhere I saw that most people find QIF works better, and that QIF is similar to CSV. If my version of Quicken won't export to QIF, I'll try CSV. There are too many variations of CSV for me to trust it entirely. I might make one huge QIF, import it and save as GC, then make another QIF just of r

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
The speed thing is disappointing. I thought 3.5 fixed that, but maybe not enough. I planned to save as XML to get going, since the docs say it's more stable, then try SQLite. (Aside: https://wiki.gnucash.org/wiki/FAQ#SQL_Database recommends not using the SQL just yet. Several posts on this list sa

Re: [GNC] Need help reconciling

2019-04-26 Thread Cricket Onebit
Sounds like me at the grocery store. Just tell me what aisle, even better something big beside it, and like magic it appears, even though I'd already checked that area thoroughly. On Fri, 26 Apr 2019 at 20:35, David Cousens wrote: > Todd, > > >Why I could not find it on my own, I can only specul

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
On Thu, 25 Apr 2019 at 17:29, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > I'm preparing to convert 14,000 transactions from Quicken. It's a bit > > overwhelming, and I've put it off for years. > > Sounds like a daunting task. I don’t do such imports, but reading the > various th

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
That page gave me nightmares when I first read it two years ago. I ran a few tests, then procrastinated. Nothing's difficult, but there's a lot to do. It looks like I should anticipate problems with the matcher for transfers between accounts, and for split transactions. I'll make before/after repo

[GNC] Changing account tree on large database

2019-04-25 Thread Cricket Onebit
Hello, I'm preparing to convert 14,000 transactions from Quicken. It's a bit overwhelming, and I've put it off for years. 1. Can I move child accounts to other parents, and promote / demote them? I want to make some major changes, mostly Clothes-kid1 to kid1-clothes. It's one more excuse for dela

Re: [GNC] Convert from Quicken by date rather than account -- recommended?

2019-04-18 Thread Cricket Onebit
ansfers will > appear twice. > > David Carlson > > On Mon, Apr 15, 2019, 2:02 PM Cricket Onebit > wrote: > >> Would it work to go by date, one file per year or even quarter or month, >> instead instead of by account? >> >> Pros: >> - Transactions wit

Re: [GNC] Unable to import QIF or QFX.

2019-04-15 Thread Cricket Onebit
Watch the order of Q and X, and O vs Q. Lots of similar file names. On Sat, 13 Apr 2019 at 21:42, Evan Platt wrote: > Wow I feel like an idiot. Attention to detail LOL. Quicken is > exporting a QXF file. Gnucash is importing QFX. So my guess is to > export from quicken to Gnucash I have to do ac

[GNC] Convert from Quicken by date rather than account -- recommended?

2019-04-15 Thread Cricket Onebit
Would it work to go by date, one file per year or even quarter or month, instead instead of by account? Pros: - Transactions with multiple accounts (eg transfers or "gift card + cash") get done in the same session. - Less confusion as to what's been done over multiple sessions. Thanks, Cricket /

Re: [GNC] two lines for every entry

2019-04-12 Thread Cricket Onebit
One additional point: When the bank or credit card company gives you money and issues a Debit Memo, they name from their perspective, giving instructions to their clerks. They say they are debiting you. You, however, are on the other side of the transaction. In your books, you credit them -- even

Re: [GNC] Mac OS Mojave

2019-04-06 Thread Cricket Onebit
Reply All rather than Reply. Some email defaults to Reply, which only goes to the original poster, no the entire list. Very annoying for all involved, but changing the settings only seems to work for a short while.

[GNC] Convert from Quicken by date rather than account

2019-04-06 Thread Cricket Onebit
Would it work to go by date, one file per year or even quarter or month, instead instead of by account? Pros: - Transactions with multiple accounts (eg transfers or "gift card + cash") get done in the same session. - Less confusion as to what's been done over multiple sessions. Thanks, Cricket /

Re: [GNC] QIF Import Fails

2019-04-06 Thread Cricket Onebit
Is it using Retained Earnings for uncategorized transactions? Quicken used to have a report for uncategorized transactions. Years ago when I tried to convert (then life got busy), uncategorized transactions caused many problems.

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-06 Thread Cricket Onebit
ent=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Tue, 2 Apr 2019 at 15:23, no_more_quicken wrote: > Cricket Onebit wrote > > Can you explain more about not being able to undo things with the SQL > > backend vs XML (or point to more details)? I'm undecided about w

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread Cricket Onebit
Thanks for this. I have a similar project in the near future, and was wondering the best order for some things. It looks like the major re-categorization should be done before leaving Quicken. Good to know there's a workaround for the HiDPI bug. Is there a bug report / feature request for bulk a

Re: [GNC] Gnucash leadership team

2019-02-01 Thread Cricket Onebit
First, I'm sorry about including the entire digest. It was careless and rude of me, since I've been around long enough to know better. I now get individual emails, not digests, and not compose on the small screen that makes it harder to check things. Also, apologies to Michael Stagle for Replying r

[GNC] Gnucash leadership team

2019-01-31 Thread Cricket Onebit
Hello, Before I commit to a very large conversion from Quicken, I want to know that GnuCash will continue to be around and maintained. Is the core leadership team large enough that a single life event (eg new job, new baby, sabbatical, too many changes needed because of an OS upgrade) will stop m