Tom Allred | 1 Sep 09:50 2015
Picon

Bank account balance incorrect after import from Quicken

Just installed the latest version of gnucash and imported everything from
quicken.  Have data back to 1995.  No errors during the import process but
my primary checking account balance is low by around $3,000.  I reconcile it
every month and just did the latest one a couple of days ago before the
export/import.  Need suggestions on where to even start looking given my
newness to the product, the amount of data, and lack of errors during
import.

If it matters I'm on Windows XP and moving to Win7.  Was looking to avoid
buying Quicken (I'm using the 2000 version) for Win7 so that's why I was
considering gnucash.  Thanks.
_______________________________________________
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.

Randy Orrison | 31 Aug 21:19 2015
Picon

Reconciliation error - need to mark two transactions as reconciled

Hi,

A couple months ago something went wrong with an account reconciliation.
Now, when I reconcile that account I have two transactions from 29 June
that are showing as not reconciled, but actually should be. They cleared
the bank on that day, and they did appear on the bank statement at the
time, so I don't know how I could have posted the reconciliation of that
statement without them having been marked as reconciled, but that must have
happened.  Now, I just need to mark them as reconciled without affecting
any starting or ending balances.

I suppose I could enter a bogus transaction to offset them, and reconcile a
fake statement, but I'd prefer to just fix them.  Is there a way to do it?

Thanks,

Randy
_______________________________________________
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.

Anton Kratz | 31 Aug 12:49 2015
Picon

two different account books open at the same time, is this possible?

I am using GnuCash 2.6.7 under Mac OS X 10.10.5. I have two different
*.gnucash-files, or books.

(One is the main file and the other is for expenses in a foreign country
and currency. This was the easiest way I could figure out how to avoid
dealing with this situation, otherwise I would need to duplicate accounts,
or deal with currency gains and losses which I don't want... anyway I know
have two account books).

I want to have both account books open at the same time. Either in the same
or in two different instances of GnuCash.

Is this possible?

I found threads about this topic from years ago (
http://lists.gnucash.org/pipermail/gnucash-user/2014-January/052176.html),
but they mention something about preferences files clashing, and I wonder
if this is still the case, and also my question is with respect to GnuCash
2.6.7 under Mac OS X 10.10.5.

Anton
_______________________________________________
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)

Maxim Cournoyer | 31 Aug 02:34 2015
Picon

Recording an income which includes shares

Hello,

I'd be interested in knowing how to record a pay which is partly composed
of a stock.

For example, let's say my pay stub says total income is: 1500, and 200$ of
this income is actually converted to stock 'ABC'.

I want to track the $ amount of my income (1500$), while recording the
amount of stock newly received (say 200$ is equal to 20 shares). How would
I balance such an income transaction?

Right now I have the following split defined in my income account, but I'm
not sure if that makes sense at all:

*Account                                Charge         Income*Cash
pay        Assets:Checking Account      1300
Shares pay     Assets:RSA                           20 ABC
                     Trading:CURRENCY:USD        200
                     Trading:Stock:ABC
20 ABC
                     Income:MyIncome
1500

Is this OK?

Another question I have: I'd like to schedule such a transaction every
other week, but the Scheduled Transaction Editor returns the following
warning: "Scheduled Transactions with variables cannot be automatically
created.". Is there a way to schedule such a transaction ? What variables
(Continue reading)

Daniel Kraft | 30 Aug 16:51 2015
Picon

Report for asset distribution among securities

Hi!

I'm using Gnucash for private accounting (surprise!) but also to keep
track of investments in various securities.  I think that it would be
great to create a report that displays my portfolio as distribution of
funds over these securities (could be as a piechart or table).

I. e., I would like to get something like this:

  25% EUR
  25% USD
  20% XAU
  20% Fund ABC
  10% Stock XYZ

The report "Asset Piechart" is already quite close to this -- but it
groups things together by the account structure and not by security.  Of
course, I could get the effect I want if I structure my accounts by
security.  That is, however, not what I want.  I may have multiple
EUR/USD accounts or hold the same other security in multiple broker
accounts, for instance.  In that case, I prefer to group the accounts by
bank/broker instead of by security.

Is there something I can do to get a report as I want it, grouped by
security that I missed?

Otherwise, since I know a bit of Scheme/Guile, I guess that I can write
my own script to create it.  In that case, do you think there could be
interest to publish it with Gnucash as a new report type?

(Continue reading)

Colin Law | 29 Aug 15:17 2015
Picon

Re: RESOLVED error after upgrading to ubuntu 15.04

On 29 August 2015 at 14:11, ssc1478 <ssc1478 <at> aim.com> wrote:
> Colin,
>
> I upgraded from ubuntu 14.10 (gnucash was installed) to 15.04 using
> do-release-upgrade command.
>
> That is how gnucash was installed.

Sorry, I did not make myself clear, I meant how was gnucash installed
in the first place (before the upgrade)?  Did you install it from the
Ubuntu Software Centre or a ppa or compiled it yourself or what? Also
you have not said what
apt-cache policy gnucash
and
which gnucash
show, when run in a terminal.

PS please remember to copy the list when replying (use Reply All or
Reply list or something similar in your email software) otherwise the
reply only goes to previous poster.

Colin
_______________________________________________
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)

ssc1478 | 29 Aug 05:24 2015

Re: RESOLVED error after upgrading to ubuntu 15.04

On Fri, Aug 28, 2015 at 11:02 PM, ssc1478 <ssc1478 <at> aim.com> wrote:

> no code for module (www main)

I was able to find the solution on google, which was to delete this
directory and try again:

~/.cache/guile/ccache/

And it worked.

Phil
_______________________________________________
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.

ssc1478 | 29 Aug 05:02 2015

error after upgrading to ubuntu 15.04

Hello,

I just upgraded my ubuntu laptop to 15.04 and get the following error
(pasted below) when launching gnucash.  Can you please tell me what I need
to do to correct this?   Thank you very much!!

Phil

phil <at> remus:~$ gnucash
Backtrace:
In ice-9/boot-9.scm:
 157: 16 [catch #t #<catch-closure a18d680> ...]
In unknown file:
   ?: 15 [apply-smob/1 #<catch-closure a18d680>]
In ice-9/boot-9.scm:
3597: 14 [process-use-modules (((gnucash price-quotes)))]
 702: 13 [map #<procedure a09c980 at ice-9/boot-9.scm:3597:25 (mif-args)>
((#))]
3598: 12 [#<procedure a09c980 at ice-9/boot-9.scm:3597:25 (mif-args)> (#)]
2864: 11 [resolve-interface (gnucash price-quotes) #:select ...]
2789: 10 [#<procedure a1401f0 at ice-9/boot-9.scm:2777:4 (name #:optional
autoload version #:key ensure)> # ...]
3065: 9 [try-module-autoload (gnucash price-quotes) #f]
2401: 8 [save-module-excursion #<procedure b11c8e8 at
ice-9/boot-9.scm:3066:17 ()>]
3085: 7 [#<procedure b11c8e8 at ice-9/boot-9.scm:3066:17 ()>]
In unknown file:
   ?: 6 [primitive-load-path "gnucash/price-quotes" ...]
In gnucash/price-quotes.scm:
  41: 5 [#<procedure b12e720 ()>]
(Continue reading)

Chris Good | 29 Aug 04:32 2015
Picon
Picon

discount for early invoice payment

Hi,

I'm updating GnuCash Guide for billing terms & sales tax tables, and I
thought I'd update the section on account setup to include a tax account and
discount account.

Anyone know where Geert's document on how to fix up payment problems is?

How do we cater for a customer invoice early payment discount?

I see that Billing Terms does calculate invoice due date but calculation of
early payment discount is not yet implemented.

I thought it could possibly be done by doing a credit note and selecting the
transfer account as Expenses:Discount but it is not possible to select an
Expense account.

GnuCash 2.6.7 Windows 7

Regards,

Chris Good

Attachment (smime.p7s): application/pkcs7-signature, 6513 bytes
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
(Continue reading)

Gilberto Reis Filho | 28 Aug 20:42 2015
Picon

Extract a table with expense accounts balances

I am using the Expense Barchart report to get a monthly balance of my
expense accounts from 01/01/2007 until 31/12/2014.

This works but is a pain because it can only handle 24 accounts at a time.

Is there any way I can extract expense accounts balances in monthly
steps for a period of time (let´s say 5 years) to a table? I intend to
work with this info in excel. I do not need the graph, just the table.

Thanks and regards.
Gilberto.

_______________________________________________
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. | 28 Aug 18:49 2015
Picon

Budget Reporting Issues

Hi,

In the course of trying to address shortfalls in documentation around reports, I began poking around in the
various Budget reports and features, and I wanted some explanation on a number of points. Bear with me if I
ask questions that are meaningless; I do not use the Budget features much, and probably don’t
understand the original intent of the various reports. Add in the fact that I Am Not An Accountant, and you
will further understand my questions.

By all means, if you know better what a report is meant to do, and can clue me in, it will help me write up
accurate descriptions of the reports.

Generally, what is each report meant to do? The grouping includes:

Budget Balance Sheet
Budget Barchart
Budget Flow
Budget Income Statement
Budget Profit & Loss
Budget Report

I understand (somewhat) what these reports mean in a common sense, but what exactly are they meant to do in
the context of a Budget? For example, a Balance Sheet provides a summary of all your accounts as of a certain
date. But what does a Budget Balance Sheet report? The numbers I get match neither the budget numbers *nor*
the actual numbers. 

More generally, I believe that the data presented in the reports is derived from the budget, with the
exception of of the Budget Report, which includes both Budget and Actual amounts. Is this right?

I have similar questions regarding the other reports in this grouping.

(Continue reading)


Gmane