gmane.comp.gnome.apps.gnucash.user

Change Name of File

Trevor Wheeler — 2012-05-26T06:52:34

Hi guys

 

I am using the Gnucash software for MiVAC's 2011-12 accounts.  The title of
the file (which I inherited) is the date on which the previous treasurer
sent the the file to me.

 

I would like to change the title to one which reflects the current financial
year and to remove any confusion with other files.  I can't find any
reference in the manual about this.  How do I do this?

 

Thank you

 

Trevor Wheeler

Treasurer

MiVAC Trust

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

Am I "Closing the Books" correctly?

Micah Carrick — 2012-05-26T00:05:07

Hey folks,

This is largely more of a general accounting concept, but, since I'm not an
accountant, maybe you guys can tell me if I have this right. I'm doing the
books for my small business (partnership LLC) with GnuCash and want to see
if my strategy for "closing the books" at the end of the accounting period
is sound.

Rather than using Equity:Opening Balances, I have setup "Capital" and
"Draws" equity accounts for each partner:

Equity
    Doe, John
        Capital
        Draws
    ...

The balance in the Assets:Checking account initially came from each
partner's equity capital account in the amount of their capital
contribution.

To close the books I zero out the balance of every Expense:* account and
every Income:* account by:

1. Creating transactions to move those expense and income balances to each
partner's equity capital account according to their share.
2. If any of that income is to be retained by the company I create another
transaction from their equity capital account back to the Assets:Checking
account.
3. If the partners are taking a draw then I create a transaction from the
equity capital account to the equity draws account.

Does that sound about right?

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

question on transaction download/import

Chuck Cox — 2012-05-23T21:18:03

Hi, new Gnucash user here in the process of converting over from
Quicken. I have successfully setup my accounts and imported about 12
years of old Quicken data via QIF files. Believe it or not, this all
went pretty smoothly. The few issues I ran into were caused by stupid
things that Quicken did...

I have also successfully configured Online Banking to fetch
transactions for my checking and savings accounts from my bank's OFX
server.  This is where my question comes in:

After the OFX file is downloaded from the bank's server, the list of
transactions comes up in the "Generic import transaction matcher". I
feel I understand pretty well what this window is showing me and have
figured out how to check what it has matched or to manually match
things if it has failed to find a match. No problems with adding new
transactions or just assigning an account to a transaction.

The problem is that I do not see a way to edit the "Description" of
each transaction in this window. The importing process seems to be
taking the <NAME> and <MEMO> fields from the OFX data, joining them
together, and then sticking them into the description field. After I
am done matching things up and click OK, all the transaction inserted
into the register show this big long string of stuff as the
description which does usually contain the payee in it somewhere, but
with a bunch of other junk I don't need there.

So is there a way to fix the Descriptions from within the matcher, or
do I simply have to go through them all in the register each time and
correct them? I have searched the mailing list archives and found
several past discussions about this sort of thing, but no solutions. I
did see several mentions that the Bayesian capability in the matcher
is supposed to learn and improve over time. Will this address the
issue? I have only downloaded transactions a couple of times so far,
so obviously it hasn't had much of a chance to learn anything yet. :-)


Thanks,
Chuck
_______________________________________________
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.

F::Q

Les — 2012-05-23T17:39:53

Is there a listing for precious metals (gold, silver) prices (per oz or..)?

Thanks,
Les
_______________________________________________
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.

account e transaction

auleia — 2012-05-23T16:56:24

I come here with this question. you can have a current account balance also
calculate the scheduled transactions on a certain date? Thank you.

--
View this message in context: http://gnucash.1415818.n4.nabble.com/account-e-transaction-tp4651828.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.

Enabling scheduled transaction crashes GnuCash

DavidS — 2012-05-22T07:39:13

I've been using GnuCash for a couple of years now.  For several months until
today I have been using Ubuntu 11.10 (Oneiric) with GnuCash 2.4.7.  Because
of the problem I have been getting I have now upgraded to 2.4.10, but it
hasn't helped.

I have a couple of dozen scheduled transactions which all work as they
should.  I have been trying to add another one, but every time I try to
enable it by setting the frequency and then click on OK, GnuCash crashes.

I've compared the options I've ticked and the layout of items on the three
tabs in the Scheduled Transaction Editor with other scheduled transactions
which work, and I can't see anything different, abnormal or inconsistent
about the new transaction.

I deleted another scheduled transaction in case there was a maximum number
allowed by GnuCash, but that didn't help either.

Has anyone else come across anything like this?  What could possibly be
causing the problem?

David



--
View this message in context: http://gnucash.1415818.n4.nabble.com/Enabling-scheduled-transaction-crashes-GnuCash-tp4649523.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.

Finance::Quote IndiaMutual - source changes

Divakar Ramachandran — 2012-05-20T19:14:06

There are two changes at the AMFI <javascript:parent.test_func(0)> India website <javascript:parent.test_func(1)> which makes IndiaMutual <javascript:parent.test_func(2)>.pm <javascript:parent.test_func(3)> non-functional.

1. URL <javascript:parent.test_func(4)> for quote source on AMFI <javascript:parent.test_func(5)> India has changed to: http://www.amfiindia.com/spages/NAV0.txt

Replace lines 22 - 24:

$AMFI <javascript:parent.test_func(6)>_MAIN_URL <javascript:parent.test_func(7)> = ("http://amfiindia.com/");
$AMFI <javascript:parent.test_func(8)>_URL <javascript:parent.test_func(9)> =("${AMFI <javascript:parent.test_func(10)>_MAIN_URL <javascript:parent.test_func(11)>}NavReport <javascript:parent.test_func(12)>.aspx <javascript:parent.test_func(13)>?type=0");
#$AMFI <javascript:parent.test_func(14)>_URL <javascript:parent.test_func(15)> =("${AMFI <javascript:parent.test_func(16)>_MAIN_URL <javascript:parent.test_func(17)>}spages <javascript:parent.test_func(18)>/NAV <javascript:parent.test_func(19)>0.txt <javascript:parent.test_func(20)>"); This page seems to do the job also. Keep for reference

with:

$AMFI <javascript:parent.test_func(21)>_MAIN_URL <javascript:parent.test_func(22)> = ("http://www.amfiindia.com/");
#$AMFI <javascript:parent.test_func(23)>_URL <javascript:parent.test_func(24)> = ("${AMFI <javascript:parent.test_func(25)>_MAIN_URL <javascript:parent.test_func(26)>}NavReport <javascript:parent.test_func(27)>.aspx <javascript:parent.test_func(28)>?type=0");
$AMFI <javascript:parent.test_func(29)>_URL <javascript:parent.test_func(30)> = ("${AMFI <javascript:parent.test_func(31)>_MAIN_URL <javascript:parent.test_func(32)>}spages <javascript:parent.test_func(33)>/NAV <javascript:parent.test_func(34)>0.txt <javascript:parent.test_func(35)>"); #This page seems to do the job also. Keep for reference


2. Within the file, for every fund, ISIN <javascript:parent.test_func(36)> codes appear for growth and reinvestment <javascript:parent.test_func(37)> versions of the funds just after the fund code, which is the first item on the line.

This requires lines 89 - 94:

    $fundquote <javascript:parent.test_func(38)>{$symbol, "name"} = $data->[0];
    $fundquote <javascript:parent.test_func(39)>{$symbol, "nav <javascript:parent.test_func(40)>"} = $data->[1];
    $fundquote <javascript:parent.test_func(41)>{$symbol, "rprice <javascript:parent.test_func(42)>"} = $data->[2];
    $fundquote <javascript:parent.test_func(43)>{$symbol, "sprice <javascript:parent.test_func(44)>"} = $data->[3];
    $quoter <javascript:parent.test_func(45)>->store_date(\%fundquote <javascript:parent.test_func(46)>, $symbol, {eurodate <javascript:parent.test_func(47)> => $data->[4]});
    $fundquote <javascript:parent.test_func(48)>{$symbol, "success"} = 1;

to be replaced with:

    $fundquote <javascript:parent.test_func(49)>{$symbol, "name"} = $data->[4];
    $fundquote <javascript:parent.test_func(50)>{$symbol, "nav <javascript:parent.test_func(51)>"} = $data->[5];
    $fundquote <javascript:parent.test_func(52)>{$symbol, "rprice <javascript:parent.test_func(53)>"} = $data->[6];
    $fundquote <javascript:parent.test_func(54)>{$symbol, "sprice <javascript:parent.test_func(55)>"} = $data->[7];
    $quoter <javascript:parent.test_func(56)>->store_date(\%fundquote <javascript:parent.test_func(57)>, $symbol, {eurodate <javascript:parent.test_func(58)> => $data->[8]});
    $fundquote <javascript:parent.test_func(59)>{$symbol, "success"} = 1;
 
This works for me on Ubuntu <javascript:parent.test_func(60)> 10.04 LTS <javascript:parent.test_func(61)> 64-bit with GnuCash <javascript:parent.test_func(62)> 2.2.9 and Perl <javascript:parent.test_func(63)> v5.10.1 built for x86_64-linux <javascript:parent.test_func(64)>-gnu-thread-multi.

Regards,
Divakar <javascript:parent.test_func(65)>

"No file" on starting Gnucash

miikro — 2012-05-20T13:32:28

Help! When I start up, instead of being offered a choice of my two data
files, I simply get "no file"
Have I lost all my data somehow?
This is very worrying and I would appreciate any help

--
View this message in context: http://gnucash.1415818.n4.nabble.com/No-file-on-starting-Gnucash-tp4646847.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.

GIFI Tax TXF Categories for Canada

bunk3m — 2012-05-18T21:34:15

Hi.

I'm in the process of finishing tax returns for my company.  This is the
first year of using Gnucash.

I would like to investigate how difficult it would be to add/create a
similar set of tax codes to the US ones provided.  In Canada that would
be the GIFI codes.

---Quote Oct 31---
The current implementation is US-specific.  Nobody has defined a tax
mapping for other locales.  Take a look in src/report/locale-specific/
and you'll see us/taxtxf.scm -- nobody has defined a taxtxf.scm for
other locales.

-derek
---end quote---

I've been looking for these scm forms within the Gnucash package without
any luck.  I'm probably completely confused and stupid when it comes to
what I should do, but I'm trying to figure it out.

Can someone tell me where the US codes are found on the Mac
implementation so I can find the files and look at them?  If they don't
look to complicated, I'll try to transfer the GIFI codes into a similar
format.

I'd appreciate some guidance on what to read to learn how to do this and
then I'll give it a whirl.

I'm on Digest-Mode so please CC me on any reply.

Thanks in advance.
B.
_______________________________________________
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.

QIF import creates duplicate account

Chris Bainbridge — 2012-05-16T18:52:31

Hello,

I try to use QIF import for credit card account data. It works for
most transactions, but has a problem when a transaction is matched to
one of my GnuCash accounts (my Assets:Current account). When I click
"Apply" on the QIF import, the importer creates a duplicate account,
identical to the original (Assets:Current account), even with exactly
the same name, but containing only the newly imported transactions.
This happens even if I "match" every QIF transaction with an existing
one -  so the QIF importer imports no transactions, making the newly
created duplicate account have no transactions.

I have read some previous emails to this list that said a duplicate
account is created if the currency or account type is different. In
this case, the duplicate account and original account both have type
"Bank", and same currency (GBP). The QIF import is done with currency
GBP, which is set from the locale.

I am not particularly bothered about this one transaction as it is
easy to work around, but this looks like a bug in the QIF importer? I
tried to reproduce the problem by creating a new set of accounts, and
then importing the QIF, but that worked ok.
_______________________________________________
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.

Average Value in Barchart Report

Anderson Aquino — 2012-05-16T16:34:39

I often use the expense barchart report for a specific account at a selected period of time.

Is there any way of tracing a dotted line of the average value in the graphic? Or show the average value any where on the screen(not necessary on the graphic)?
_______________________________________________
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.

Account alphabetization lost

Elaine Breuer — 2012-05-16T16:17:54

I began as treasurer of a charity in March of this year and started  
using GnuCash 2.4.10 on Windows 7 (I prefer linux or Mac but the  
charity director prefers Windows). When I generated a balance sheet  
for a particular date and profit/loss statement up to that date  
yesterday, I was able to do so with some fumbling, but somehow I lost  
the alphabetical listing of subaccounts (e.g., our list of donors  
under income now appears to be in the order in which I first added  
that donor rather than alphabetical as it was before, making it much  
harder to find the donor as new donations come in). Is there a way to  
have GnuCash alphabetize the subaccounts again? I tried bring up an  
earlier .gnucash file when I knew it showed them alphabetically, but  
it was not alphabetized so the problem seems to be something I changed  
in the program. I have looked through a few months of posts on the  
user mailing list, but didn't see anyone else having this problem.  
Thanks for any help.
_______________________________________________
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.

Owner drawings to equity

Supercoley — 2012-05-16T00:52:08

Hello.  I recently started a UK business (Sole Proprietor) and after dabbling
with a few different software packages have settled on Gnucash.  It seems
much more user friendly than others.

I have set up most of the accounts I need to but have a couple of little
questions.  Not urgent per se but some niggling doubts.

One that is easy to answer and maybe some could give me a preference here. 
All my transactions go through paypal.  Should I record the transactions in
full then have an expense account for Paypal fees or should I just deduct
the paypal fee from the amount I enter into Sales?

Next a little more technical - I was buying items for the business from my
personal bank account prior to setting the business up.  I assume I account
for these by way of the owner loaning money to the business.  Should I set
this up as a loan in liabilities?  This is not cash in the business, it has
already been spent and therefore would be an expense or Asset already (Some
was spent on equipment and some on bits and bobs)

Secondly and I have nearly a year to work this out :)  I have never had to
do any kind of book-keeping or accounts involving drawings before.  I am
struggling to grasp what happens at the end of year really.  I know al
profit becomes taxable at the end of the year which is fine.  So at year end
do I just calculate tax and put the relevant entries in tax and NI within
expenses?

Then all that is left becomes drawings.  This goes to Owner drawings I
assume?

If for example (theory to make it easy for me to understand) I made profit
of £30k, paid tax on that and final profit was £25k.  Then I withdrew the
whole £25k as drawings what entries would I make?  I am geting confused as I
assume this £25k must leave the business rather than be equity?  All
research I have made seems to suggest that it remains as Owner Capital and I
can see lots of people get confused by this part however I can't find any
clear answers in replies to the 'confused' Op in these sort of threads.

--
View this message in context: http://gnucash.1415818.n4.nabble.com/Owner-drawings-to-equity-tp4639050.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.

Accounts tab balance as currency value possible for Stock accounts?

prl — 2012-05-16T07:19:45

In our Accounts tab, all our stocks (Assets>Shares>..., Type=Stock) show 
up as a count of shares held and the exchange code in the Balance column 
(1234 XYZ, rather than $9876.54). Since our highest price stocks have a 
share value ~35 times our lowest price stocks, and the numbers of shares 
we hold changes infrequently, I'd much prefer a display of value in 
currency terms rather than a count of shares held.

I can't work out how this can be done (apart from opening each holding's 
account tab). Is it possible?


Peter

Mac

Dennis Powless — 2012-05-16T02:40:16

I'm a treasurer and my term for my organization is completed.  I am
using an older version of GC on linux and I want to pass off the file
to the next person.  He is using a MAC and I was wondering if the file
will be usable.  I have heard the file can be used on all platforms,
but I really concerned about the older version and what he will
download is the latest version.

I'll post what version I'm using when I can figure it out.


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

Top level account without any type (or file links)

Dr. Muhammad Masroor Ali — 2012-05-14T10:19:11

Dear All,
Looks like gnucash does not allow you to link between separate files. To
circumvent the problem, let us say that we want to create three separate
accounts (A, B and C) at the top level. Under each of A, B and C, we want to
create our usual accounts (Assets, Equity, Expenses, Income and
Liabilities). But when I try to do this, I can not create a top level one
without any type. You have to choose one (Liability, Income, Asset ...)
type. 

I need to do this since the three entities A, B and C have some kind of
dependency relationship among them which needs to be reflected. One solution
will be to have Income.A, Income.B and Income.C, Equity.A, Equity.B and
similar ones. But this is counterintuitive for the scenario.

Any suggestion will be appreciated.



--
View this message in context: http://gnucash.1415818.n4.nabble.com/Top-level-account-without-any-type-or-file-links-tp4631912.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.

ofx transaction description problem

William S Markley — 2012-05-14T03:39:50

I have been using gnucash and downloading transactions from my bank with 
OFX.  Recently, the descriptions have been mixed up.

For example, the description of a purchase at Stater Bros (grocery 
store)  is now imported as "2 PURCHASE #651913 PALM SPRINGS CA; 
STATERBROS126 05-11 CUSTOMER 927" instead of "STATERBROS126 05-11 
CUSTOMER 9272 PURCHASE #651913 PALM SPRINGS CA; " as it was previously.

This just started since I upgraded to gnucash version 2.4.10.

Any ideas?

Gnucash for a small partnership scenario

Dr. Muhammad Masroor Ali — 2012-05-13T14:10:59

Dear All,
I have been using gnucash for maintaining accounts related to a school
account for quite sometime. 

Now, I want to use it for a small partnership (large family) scenario where
the members put in their monetary contributions to a common account.
Expenses are paid out of a common account.

Incomes come in as crop sales, rents and similar items and transferred to
the common account.

With all my experiences, I am getting confused at some point. The part about
individual contributions, common expenses, income distribution to members
are the most difficult ones. I am often getting scenarios with reversed
signs (negative where it should be positive), and unbalanced funds.

Do you think you could point me to some kind of tutorial or a comprehensive
example to tackle the above mentioned scenario?

Thanks in advance.

--
View this message in context: http://gnucash.1415818.n4.nabble.com/Gnucash-for-a-small-partnership-scenario-tp4630505.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.

No Back End found

fredgmau — 2012-05-13T15:46:01

My HD failed, but I was able to save all my data files,

Now, on a new HD, I installed 2.4.10 with no issues.

 

I am trying to import or open my existing/older data files from previous
(within a year) version of Gnucash.

 

I get the error, "no suitable back end found" when I try to open.

Please help.

 

 

 

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

adjusting budget line items to free up funds

Mark Breeden — 2012-05-13T01:54:46

I want to play with line item amounts in my budget.  Based on adjustments
to line items, I want to see how much available funds I will have at the
end of the budget period.  Basically, I need to know how much money I can
free up by reducing budgeted amounts in different categories.  Is there a
quick/interactive way to do this?

Also, I want to know how to quickly show how much I have spent on dining
and gas in the last week, month, two months, or year.

Thanks for your input!
_______________________________________________
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.

insurance dividends

David Zelinsky — 2012-05-13T00:56:18

I'm having trouble figuring out where to record dividend checks from a
mutual insurance policy.  I'm hoping someone has a clever solution.

Here's the situation.  I currently have separate accounts for my
homeowners and car insurance: Expenses:House:Insurance and
Expenses:Car:Insurance.  I recently switched both policies to a mutual
insurance company, which gives me an annual rebate check ("dividend").
This is supposedly a return of some fraction of the premium, so I would
like to record it as a rebate in the two expense accounts.  However,
they don't break it down according to the two policies, so I'm not sure
where to put it.

I could divide up between the two accounts, according to the ratio of
the premiums.  But that seems awfully fussy, plus I don't know if the
divident rate is actually the same for both types of policy (in which
case, in principle my method could end up with one of them having a
rebate that's larger than the premium!)

Ideally I would like to have both accounts be under one master account
for insurance company, so the dividend could go into the parent
account.  But I still want them to be under Expenses:House and
Expenses:Car, so they would each need two parents!

At the moment I can't think of anything better to do than just put the
dividend into some Income account and leave it at that.

Any better suggestions?

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