Eve Mattingley | 25 Jun 04:03 2016
Picon

Help with GNUcash on new Mac Mini

June 23, 2016

I have a new Mac Mini, running OS X 10.11.4.  I was previously
using a SnowLeopard Mac Mini (mid-2010), also OS X but of course
a slightly earlier OS X version. I have GNUcash v 2.4.13, which
ran fine on the earlier Mac, and I've been using it without incident
for several years.

In setting up the new system, we used Time Machine to bring in
all apps and data, which worked fine except that when I open GNUcash,
my general ledger simply does not exist.  All my account categories
are there, and several other customizations, but not the spent/
deposited money info itself.

In the course of trying to figure out what was wrong, I tried printing
several of my (custom) reports -- reports I print once a month for my
both my own business records and for my CPA.  I was able to more or less
duplicate reports I'd already printed (some report customization elements
were apparently lost or corrupted), but from what amounted to "invisible"
ledger information.  (Not sure that's clear.  One, I can see no ledger
ledger info at all -- zero balance, no entries.  Two, I already had
printed-out reports
for earlier months.  Three, I tried setting the date range for the month
of February 2016, then printed several reports, which matched what I had
on file.)

I simply do not understand why this is happening.  Honestly, I'm afraid to
touch anything for fear I'll make the situation worse.  I should probably
say that I am NOT especially computer-savvy.  I'm an experienced user, but
not any kind of programmer or someone who understands the deeper workings
(Continue reading)

JimR | 24 Jun 16:17 2016

How to refinance a mortgage

I had a 30 year fixed rate mortgage in GNUCash.  I have refinanced it to 
a 5/1 adjustable rate (same bank, if it matters).  The bank essentially 
closed out the old mortgage, and created a new one.

How should I close out the old mortgage, applying principal from the 
funds of the new mortgage?

Thanks,
JimR

_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
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.

Robert Heller | 23 Jun 16:20 2016
Gravatar

Separate windows, NOT TABS -- is it possible?

I recently upgraded to CentOS 6 and GnuCash 2.4.15 and it appears that gnucash
is now following Firefox down the alley of "There can be only one [window]"
and is now using tabs, *like it or not*. *I* don't like tabs! I want things
like invoices, etc. to open in *separate* windows as a default behaviour. Is
this possible? How?

Yes, I know I can open a new (blank) window and *then* find/create something,
but I really want to just find/create from whereever I happen to be and get a
fresh window, without having to go through the extra steps. The older versions
of GnuCash worked that way (as did the older versions of Firefox/Mozzilla).
This 'craze' of tabs everywhere (with the aversion of creating new windows) is
really anoying (to me). (And no, I almost *never* maximize my windows -- I am
an old-school UNIX user and never used mess-windows -- I really make full use
of my 'window manager', often having multiple windows up side-by-side and/or 
overlapping.) 

--

-- 
Robert Heller             -- 978-544-6933
Deepwoods Software        -- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
heller <at> deepsoft.com       -- Webhosting Services

_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
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.

(Continue reading)

DaveC49 | 23 Jun 05:56 2016
Gravatar

Re: I am soooo frustrated

What version of Gnucash are you using and on what Platform?
Works fine in GnuCash 2.6.12 running on Linux Mint Rosa.

Possibles 
Look at Edit->Report Options   
General tab

Make sure if it is notset  for the current accounting period that the Date
of report is correct and occurs after the date set for the adjusting/closing
which should be a date before the date of the report - the default should be
the current accounting period.

Accounts tab  Select All or Select the specific accounts you want in the
trial balance- should be all by default.

The current accounting period can be set in the Edit->Preferences dialog -
ensure the transactions you want are in the period set or the report dates
set above.

Then Reports->Income & Expense->Trial Balance  should produce the Trial
Balance Report.

Wouldn't charge the time to the client but maybe you can claim it under
professional development. 

Cheers,

DaveC49

--
(Continue reading)

ahmed | 22 Jun 12:52 2016
Picon

i have probleme with ofx format to conect to cpa bank in algeria

 the ofx protocol banking  to connect cpa bank in algeria so the transactions
is not done in the reality and i find no moneyin the bank

--
View this message in context: http://gnucash.1415818.n4.nabble.com/i-have-probleme-with-ofx-format-to-conect-to-cpa-bank-in-algeria-tp4685448.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
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.

John Ralls | 22 Jun 19:23 2016
Picon
Gravatar

Re: Issues with an Opening Balance in GnuCash


> On Jun 22, 2016, at 9:58 AM, <fonnique <at> forpostprod.com> <fonnique <at> forpostprod.com> wrote:
> 
> Good Day Alex,
>  
> I have an issue with the software not being able to change the opening balance in my balance sheet. Ever
since I uploaded my data into GnuCash from 2014 the system generated an opening balance of $
(1,552,869.32) that has not changed in value. Is there any way to allow the system to properly account for
this balance?
>  
> I look forward to your response.

The response is: Don't write directly to developers unless *expressly invited to*. We have a support
mailing list for this purpose. Your impertinence is made much more annoying by the fact that most of the
people in your address list haven't been involved in GnuCash for years.

I've copied the appropriate list for your convenience. You'll need to subscribe at
https://lists.gnucash.org/mailman/listinfo/gnucash-user in order to reply.

As to your question, huh? An opening balance shouldn't ever change: It's the state of your asset and
liability accounts at the beginning of keeping your books in GnuCash. Why would you expect otherwise?

Remember, subscribe to the list and copy the list on all replies.

Regards,
John Ralls

_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
(Continue reading)

Wendell | 21 Jun 22:35 2016

Importing customers

Hello Lewis,
I am not understanding your directions on page 4 of your tutorial.
You give in step 2 contents of the shell script for Linux. Does this 
have to be entered in the terminal? Then below you give the sql script 
for Linux and windoze.

Please, when and where are these things entered? No matter what I do, 
nothing works. I need a little more clarity as I am not familiar with 
these things.

Thanks,
Wendell
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
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.

David T. via gnucash-user | 21 Jun 00:50 2016

Re: Help importing historical stock prices

Jim,

Thanks for explaining your case a little more clearly.

If I understand correctly, you have your periodic valuations already in a spreadsheet, yes? If so, then I
would go with that. 

As for excluding information, you have a few options. First, you could export the report results to a
spreadsheet and edit out the information you don’t want at that point. There are a number of list users
who would recommend that anyhow. Second, you could exclude investment accounts from the report by
clicking the Options button once you invoked the report, and click the Accounts tab, and select only the
accounts you want in the box there. (Note that the selector tool can be finicky, and if you want to select
specific accounts, you can do so by Ctrl- or Apple-Clicking the accounts you want).

Cheers,
David

> On Jun 20, 2016, at 1:34 PM, Jim Vincent <jimvincent2 <at> comcast.net> wrote:
> 
> David -
> Thanks for the prompt reply.
> I am trying to get accurate historical data for the last six years for some reports required by the courts in
relationship to a guardianship account. I had recorded data in Quicken - but I became dissatisfied with it
- so I a m trying GnuCash. I have imported the data from Quicken, and cleaned it up. But, as noted below,
unrealized gains and losses without corresponding stock market values aren't accurate.
> Maybe I can figure out a way to exclude unrealized gains and losses - and exclude the related invest
accounts (which I could then report on separately). I have market values in Quicken and in a spreadsheet.
> Any suggestions will be appreciated.
> Thanks again 
> Jim Vincent
(Continue reading)

John Ralls | 18 Jun 15:47 2016
Picon
Gravatar

Re: ANNOUNCE: Announcement: GnuCash 2.6.12 Release 2016-03-28


> On Jun 18, 2016, at 1:44 AM, Markus Gueniat <markus.gueniat <at> gmx.net> wrote:
> 
> good day john
> 
> can we have the latest stable version of "AqBanking / Version 5.6.10 2016/04/23" included in the next Gnu
Cash Release"2.6.13" planned on 2016-06-26?
> 
> i was asking the same before, but there was the answer that it has to wait for this release as the version was
populated after Gnu Cash release.
> 
> this will resolve some bugs with SWIFT-MT940 and Flicker-Code (HBCI).

Don't write directly to developers unless invited to: Use the mailing list.

Yes, AQBanking 5.6.10 will be in the bundles for the next release: I pushed those changes after you asked the
last time:
https://github.com/Gnucash/gnucash-on-osx/commit/f91342914a9b757a60e26edc9d5cf4b3e2061fb8
https://github.com/Gnucash/gnucash-on-windows/commit/4b892565dbb78a3532acc0513e2ee0e33f031ed0

That won't affect Linux distributions, of course, as the AQBanking version in those is up to the distro
package maintainers.

Regards,
John Ralls 
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
(Continue reading)

David Goodenough | 17 Jun 15:19 2016
Picon

Can I invent my own Slots?

Gnucash seems to store a variety of things in key-value pairs known as 
slots.  Can I invent my own slot keywords and therefore add my own 
data into the GnuCash datastore in a way that GnuCash will be able to
return to me later and will not cause problems to normal operations?

Presumeably I should try to make sure my keywords are going to be
unique to me and not likely to be used by GnuCash, say by starting them
with my application name.

David
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
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.

Derek Atkins | 17 Jun 13:49 2016
Picon

Re: importing QIF

Hi,

Please be sure to CC the gnucash-user list on all replies using your
mailer's reply-to-list or reply-all functionality.  Please do not reply
back just to me, because there are other people who can help and answer
questions (and lately I've been traveling a lot, which can result in a
week+ delay in a response).

Paul Kinzelman <paul <at> kinzelman.com> writes:

> Thanks for the reply! I'll give that a try. There are a few importing
> problems I found
> and so I put it on the back burner for awhile. I've got 20 years of
> financial data on
> my Quicken and I'd like to not be tied to it, but GnuCash still isn't
> up to the level of
> Quicken. I could probably use it, but I'd like to be able to cut loose
> from Quicken
> completely. The QIF import seems to not import everything, and the QIF
> format
> isn't well documented. I tried editing the QIF file, but that didn't
> seem to help.

Importing 20 years of history is a big job.  The importer isn't perfect;
different versions of quicken have slightly different quirks and
sometimes the importer hits an odd corner case.

It helps to start with a small section of import and make sure that it
comes in right before you import the whole thing.

(Continue reading)


Gmane