gnucash-user Digest, Vol 143, Issue 21

Sat Feb 14 02:50:17 EST 2015

re Topic 5   Cash flow from Reports giving zeroes

Hi David,
Thanks for the suggestion.
I have discovered that the files that were giving trouble had been saved in
external media during installation of Windows 7.
Newly created files are analysed correctly.  So I have started new files as
from Jan 1st and all is well.

As a result of your reply I have asked for Zimbabwean % to be removed.  It
is long dead and gone, and it was interfering with the results from
RECORDS>I have asked for

On Sun, Feb 8, 2015 at 7:00 PM, <gnucash-user-request at gnucash.org> wrote:

> Send gnucash-user mailing list submissions to
>         gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
>         gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
>         gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>    1. CRYPT-SSLeay not installing (Bryan Schreib)
>    2. Re: Commerzbank (Arian Sanusi)
>    3. Re: Lost data (Colin Law)
>    4. Re: OFX Viewer? (David Carlson)
>    5. Re: Fault in REPORTS (David Carlson)
>    6. Re: Lost data (David Carlson)
>    7. Transfers from outside accounts (EngineInstitute)
>    8. Re: Transfers from outside accounts (Tommy Trussell)
>    9. Re: Transfers from outside accounts (EngineInstitute)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 7 Feb 2015 23:15:24 +0000 (UTC)
> From: Bryan Schreib <schreib_bryan at yahoo.com>
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: CRYPT-SSLeay not installing
> Message-ID:
>         <30934154.822172.1423350924214.JavaMail.yahoo at mail.yahoo.com>
> Content-Type: text/plain; charset=UTF-8
>
> I have been trying to get the online price retrieval up and running.? This
> is the message I keep getting when I run the install file.
> Check Perl
> Check Perl version
> Determine which Perl flavour we have found
> ?- ActivePerlInstall DateManip
> Downloading ActiveState Package Repository dbimage...doneNo missing
> packages to install
> Install Crypt-SSLeay
> ppm install failed:? Can't find any package that provides Crypt-SSLeay
> An error occurred, see above.
> Press any key to continue .? .? .
>
> Is there a fix or workaround for this, my searches so far have turned up
> fruitless.?~Bryan
>
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 08 Feb 2015 12:50:19 +0100
> From: Arian Sanusi <arian at sanusi.de>
> To: gnucash-user at gnucash.org
> Subject: Re: Commerzbank
> Message-ID: <54D74D7B.3090606 at sanusi.de>
> Content-Type: text/plain; charset="utf-8"
>
> > The first issue with this is that the
> > import wizard does not support dates separated by anything else than
> > dashes (seriously?!?), while the Commerzbank formats dates with periods.
>
> Being based in Switzerland, I also have dot-separated dates in bank
> statements. I never noticed your problem in my csv-imports, but I guess
> this could be related to your locales. I guess gnucash tries to parse dates
> according to those. Maybe try:
>
> > LC_ALL=de_DE.UTF-8 gnucash
>
> if you have non-german locales.
>
> regards, Arian
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: signature.asc
> Type: application/pgp-signature
> Size: 473 bytes
> Desc: OpenPGP digital signature
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150208/efece9b3/attachment-0001.sig
> >
>
> ------------------------------
>
> Message: 3
> Date: Sun, 8 Feb 2015 13:35:15 +0000
> From: Colin Law <clanlaw at gmail.com>
> To: gillpyrah at gmail.com
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: Lost data
> Message-ID:
>         <CAL=0gLtPHVn=HkJm3=VxuFG_41n_raN-u-gzBbSvbhzv3B4t=
> A at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> On 14 October 2014 at 14:01,  <gillpyrah at gmail.com> wrote:
> >
> >
> >
> >
> > Trying to export data to accountants accidentally lost it all to ?bin?
> and though I can see every item as a few KB each, can?t copy or highlight
> all to retrieve. Somehow I?ve got two entries back but thousands are still
> in the bin. Please help! I have tried going to ?import? and got back to the
> bin, just can?t pick the info up.
>
> I, for one, have little idea what you mean.  Exactly what have you
> lost?  Do you mean you have lost your main accounts file?  What
> exactly do you see in the bin and which bin are you talking about?
>
> Also which operating system are you using (Win 7 or whatever) which
> version of gnucash?
>
> Colin
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sun, 08 Feb 2015 07:57:42 -0600
> From: David Carlson <david.carlson.417 at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: OFX Viewer?
> Message-ID: <54D76B56.3010102 at gmail.com>
> Content-Type: text/plain; charset=utf-8
>
> On 2/7/2015 8:16 PM, Greg Feneis wrote:
> > Hi folks,
> >
> > I'm using GnuCash 2.6.3 on a Win7 64.
> >
> > I've been importing transactions from my bank's downloaded OFX files one
> > month at a time.  After I import, I go through the records and assign the
> > right accounts, etc.  It's been going very well until I got to December
> > 2014.  The GnuCash import dialog showed 6 transactions to be imported,
> so I
> > clicked OK and now I can't find the transactions in GnuCash.  If I open
> the
> > OFX file again, the import dialog doesn't show any transactions because
> > they've all been imported.
> >
> > Does GnuCash have a way to let me view the content of an OFX file?  Or,
> > maybe someone can suggest an OFX viewer?  I figure if I can view the list
> > of transactions, I can get a better idea of where to find them in the
> > ledger.
> >
> > ?It doesn't seem like a good feature that GnuCash prevents the user from
> > seeing the content of a file if it's already been imported.  I mean, I
> get
> > it, but there must be a better way to handle
> already-imported-transactions
> > than to simply not show them, eh??
> >
> > Perhaps they could appear in the import dialog with all of the text
> > stippled out or some such.  I.e. We're here, but you can't do anything
> with
> > us because you've already imported us.
> >
> >
> >
> >
> > Kind regards,
> >
> > Greg
> > _______________________________________________
> > 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.
>
> Greg,
>
> If you have your bank statements handy then you can compare the register
> with the bank statements.  Since you only had 6 transactions in
> December, the balances should match frequently when there are no
> outstanding checks, for example.
>
> When you are importing the transactions are assigned a status 'C' so
> they will initially be in one of the columns on the reconcile page while
> reconciling.  If you have not reconciled that account yet the lists may
> be pretty long and you should try an early statement date first then
> work up to December.
>
> Sometimes the OFX importer will see transactions with similar amounts
> and mis-match them to incorrect existing transactions.  If that happens
> there is no easy fix.   You can manually enter the transaction that was
> not imported.  If you have become comfortable with reading and editing
> the OFX files, then you can change the unique transaction identification
> number <FITID> for the transactions that you want to re-import to
> different unique values that follow the pattern that the financial
> institution has been using but will not appear in the future.  Then
> import the edited file.
>
> It is critical to find and correct those mis-matches during the import
> to avoid this.  If I am not sure, I check the 'A' box for that
> transaction so I can check later to see if it really is a duplicate.  I
> frequently have ATM withdrawals for the same amount on different dates,
> so this happens to me too often.
>
> David C
>
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Sun, 08 Feb 2015 08:07:59 -0600
> From: David Carlson <david.carlson.417 at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: Fault in REPORTS
> Message-ID: <54D76DBF.4000403 at gmail.com>
> Content-Type: text/plain; charset=windows-1252
>
> On 2/8/2015 2:21 AM, John Moore wrote:
> > I have been using Gnucash for many years without any problems.
> >
> > Recently I updated to version 2.6.5 and ran into 2 problems connected
> with
> > 'REPORTS'.
> > The first one has been solved  (Gnucash crashed when RECORDS activated);
> > but now I find that if I use the proccedure  "Income & Expense\Cash
> flow" I
> > get just a series of zeros rather than the total expenditure/income for
> the
> > categories of transactions used over the period requested.
> > The only thing that is correct about it is that it lists only the
> > categories that had entries for that month/year.
> >
> > Thanks,    John Moore (Lusaka, Zambia)
> > _______________________________________________
> > 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.
> >
>
> There was a change in the way reports are handled in the background.
> One possibility might be that the report is no longer set to show the
> same currency that you normally use.
>
> David C
>
>
> ------------------------------
>
> Message: 6
> Date: Sun, 08 Feb 2015 08:24:02 -0600
> From: David Carlson <david.carlson.417 at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: Lost data
> Message-ID: <54D77182.6060203 at gmail.com>
> Content-Type: text/plain; charset=utf-8
>
> On 10/14/2014 8:01 AM, gillpyrah at gmail.com wrote:
> >
> >
> >
> > Trying to export data to accountants accidentally lost it all to ?bin?
> and though I can see every item as a few KB each, can?t copy or highlight
> all to retrieve. Somehow I?ve got two entries back but thousands are still
> in the bin. Please help! I have tried going to ?import? and got back to the
> bin, just can?t pick the info up. Thanks.
> >
> >
> > Gill Pyrah
> > 40 Warrington Crescent
> > London W9 1EL
> > 0207 286 9577 / 07946 352 671
> > _______________________________________________
> > 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.
>
> That message must have been sitting somewhere for a long time.  Are you
> still having that problem?  It looks like you may have saved the
> exported data file in the wrong folder.  I am not sure if that is what
> you mean by "bin".
>
> David C
>
>
> ------------------------------
>
> Message: 7
> Date: Sun, 8 Feb 2015 07:12:56 -0800 (PST)
> From: EngineInstitute <info at chinablueart.com>
> To: gnucash-user at gnucash.org
> Subject: Transfers from outside accounts
> Message-ID: <1423408376460-4675823.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> I have a partner who transfers funds from his personal savings account into
> the company checking account. What is the best way to manage these
> transfers?
> Thanks.
> China Blue
>
>
>
> --
> View this message in context:
> http://gnucash.1415818.n4.nabble.com/Transfers-from-outside-accounts-tp4675823.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
>
>
> ------------------------------
>
> Message: 8
> Date: Sun, 8 Feb 2015 09:37:53 -0600
> From: Tommy Trussell <tommy.trussell at gmail.com>
> To: EngineInstitute <info at chinablueart.com>
> Cc: GNU Cash User <gnucash-user at gnucash.org>
> Subject: Re: Transfers from outside accounts
> Message-ID:
>         <CABNyZMyawZQ28hcHc=
> vrd+PA8k6CUQ3amLbxWLtrxL+Aipe6HA at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> On Sun, Feb 8, 2015 at 9:12 AM, EngineInstitute <info at chinablueart.com>
> wrote:
>
> > I have a partner who transfers funds from his personal savings account
> into
> > the company checking account. What is the best way to manage these
> > transfers?
> > Thanks.
> > China Blue
> >
>
> It depends upon what the partner's intent is, AND what your attorney and/or
> accountant say about how it needs to be recorded and reported.
>
> For example, if the partner is shelling out the cash with an expectation
> that he will be repaid, then it's a loan, so it's a liability to the
> company.
>
> If the partner is putting in his money in exchange for a greater share of
> the company (more company stock), then you need to follow the rules
> prescribed by your corporate charter and the state and federal rules about
> how to account for the stockholder equity.
>
> I suppose the transfers might instead be a "gift," in which case they might
> be recorded as ordinary income to the corporation. But of course that
> income might be taxable.
>
> SO that goes back to needing to do whatever your accountant and/or
> corporate attorney say.
>
>
>
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> ------------------------------
>
> Message: 9
> Date: Sun, 8 Feb 2015 07:45:36 -0800 (PST)
> From: EngineInstitute <info at chinablueart.com>
> To: gnucash-user at gnucash.org
> Subject: Re: Transfers from outside accounts
> Message-ID: <1423410336565-4675825.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Tommy,
> The partner is making it a loan to the company.
> How do I post this?
> Thanks.
>
>
>
> -----
> China Blue
> --
> View this message in context:
> http://gnucash.1415818.n4.nabble.com/Transfers-from-outside-accounts-tp4675823p4675825.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 143, Issue 21
> *********************************************
>