Eric Moon | 5 Mar 19:25 2015
Picon

Question on Split Transaction stock/fund purchases

(version 2.6.5 on Win7)

I'm trying to enter a stock purchase (well, mutual fund, but same
thing) with a brokerage fee using the exact steps outlined in the
documentation - section 8.5.2 : buy of shares, brokerage fee, and
deduction from cash account to fund it all.

My problem is that when I enter all of the data, the balance ends up
blank - it doesn't add the new shares purchased to the running total,
it just makes the balance column empty.

This carries forward to the account list - blank as well for that
stock, and in all reports.

Any ideas on what's going on?  I have some screenshots, but am unsure
of attachment etiquette on this list.
_______________________________________________
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.

Buddha Buck | 5 Mar 14:20 2015
Picon

Re: Working with membership accounts

List etiquette is to use "reply-all" so responses go back to the list for
everyone's benefit. I am including the list in my reply for that reason.

On Thu, Mar 5, 2015 at 1:39 AM Raymond Laverty <raymond.laverty <at> lylt.net>
wrote:

> Hi Buddha Buck,
>
> thanks for the prompt response. We only send invoices once a year (annual
> membership), but as you said, I’d nearly prefer to keep the
> members/invoices out of the system if it’s too much hassle, unless you know
> an easy way to import csv file with all the data in there already.
>

GnuCash does have a facility for importing both customers and invoices in a
CSV file. Basically, the customer CSV file has one row per customer, and
the invoice CSV file has one row per invoice line (so a single invoice may
be multiple rows, all with the same invoice number). For membership
invoices, you'd really only need one line per invoice, one invoice per
member per year.

As it happens, because of this situation, I have been writing a Ruby On
Rails membership management application which will generate importable CSV
GnuCash invoices. It's set up for monthly membership dues, but I'm sure
that if you, or someone you know, is comfortable with the phrase "forking a
Rails project on GitHub and customizing it" you might find it helpful. If
you (or anyone else on the list) is interested, let me know.

> Basically, all I really need at this stage is way of showing that X amount
> of membership fees are still outstanding, and of course this number should
(Continue reading)

John Mason | 4 Mar 21:29 2015
Picon

Script for basic CSV to QIF conversion

Simple Bash script to convert from CSV to QIF. I use it, figured someone 
else might want to try it to see if it helps them with transaction imports.

Filename: mkqif.sh
Type: Ascii text (BASH Script)
Original Author: John A. Mason
Purpose: Simply create a CSV file (comma separated text) any way you 
wish. Then make it match the template formula (you can get a copy of the 
template to see some examples and instructions by using the -x 
command-line parameter). Then run mkqif on that csv file to create a QIF 
file for importing into gnucash. (My version is 1.2.6.1-2)

Features:
     fault-tolerant about values in fields
     Multiple options depending on how your bank provides CSV or just 
copy/paste to CSV
     Supports auto-account classifications (can assign transactions 
to/from particular accounts from csv)
     Supports split transactions from CSV (see template.csv for 
details.... -x CLI parameter)
     Built-in Help option (mkqif -h will show basic help, mkqif -x will 
show detailed help within the template.csv)

License: Don't care, just leave my original author line alone and do 
what you will with the rest.

Hope this helps someone.
--

-- 
John A. Mason
	
(Continue reading)

Raymond Laverty | 4 Mar 16:52 2015
Picon

Working with membership accounts

Dear all,

I’m new to Gnucash and would therefore appreciate any tips you may regarding the following:

I work for a small organisation that has about 100 members from around the globe. Since we are planning to
increase our membership dramatically over the next few years, I decided it might be good to start using an
accounting software. Our budget is small, we have only one bank account and a paypal account, and our
income is from membership fees and project funding.

My question is therefore, what is the best/easiest way in Gnucash to keep track of my members’ payments?
Should I enter each one as a customer, and enter an invoice for each, or should I just create an account for
each member or …??

Thanks for your assistance,

Ray

"All truth passes through three stages. First, it is ridiculed. Second, it is violently opposed. Third, it
is accepted as being self-evident. <http://www.brainyquote.com/quotes/quotes/a/arthurscho103608.html>"
(Arthur Schopenhauer <http://www.brainyquote.com/quotes/quotes/a/arthurscho103608.html>)

www.disclosureproject.org 

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

John Haiducek | 2 Mar 01:28 2015
Picon

How are the budget totals calculated

When I go to edit the budget, there are a row of totals for "Income," 
"Expenses," "Transfers," and "Total" at the bottom of the screen. Can 
someone explain how they are calculated? The behavior seems erratic.

Specifically, "Income" and "Transfers" get populated, but only after 
putting seemingly magic combinations of values in just the right 
sub-accounts under "Income." Similarly, "Expenses" never shows anything 
but zeros for my main gnucash file, but with some finagling I managed to 
get something to show up under "Expenses" after starting a new gnucash 
XML file for testing purposes. Shouldn't these fields just show the 
totals of their respective categories? Is this a bug or am I completely 
misunderstanding what the fields are for?

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

geo909 | 2 Mar 00:54 2015
Picon

How to account for rent cheque?

Dear all,

First off, I do realize that this is more of an accounting question, but I
took the liberty to post here. I'm very new to gnucash, accounting and
double entry bookkeeping and I find myself lost very often; I would really
appreciate any help.

The manual says that the rent that I pay should be accounted as an expense.
However, the way that I do it is that I give to my landlord a cheque with
the rent amount, each first day of the month. This seems to me like being a
liability, which disappears when my landlord cashes the cheque.

So, how should I account for it? If I create a Liabilities:Rent Payable
account, and increase it by the rent amount every first of the month, from
where should I transfer the money? If it is my bank account, then my bank
account shows a wrong balance, since it accounts for the cheque that is not
yet cashed..

Thanks a lot in advance.

--
View this message in context: http://gnucash.1415818.n4.nabble.com/How-to-account-for-rent-cheque-tp4676600.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.
(Continue reading)

Picon

Cost of Goods Sold disappears from Invoices

I am new to GNUCash but love that I can track my personal and two small
business with it. I've used QuickBooks and Quicken extensively so have a
decent handle on how GNUCash works.

I have a kitchen and bath design company and my husband has a construction
business. 

We purchase "job materials" for customers and I need to be able to bill
those "job materials" back to the customers when the job is complete.

I've figured out that I need to check the "billable" column on the vendor
invoice after I've entered the customer name and job information.

When it comes time to invoice the customer - the job materials do show up. I
select the income account for the materials to be "income - reimbursed
expenses". I add a labour line with income account of "income-sales" and
click save.

Here's the weird part - when I click on the "post invoice" icon - the
materials lines disappear, but the labour portion remains.

When I check my accounts receivable account and/or the customer report - the
only amount showing up is the labour portion.

I don't understand why the job materials disappear off the invoice.

I have WIN 7, not sure of the version of GNUCash, but it was downloaded in
the last month.

I did check the forums for answers to this question - but didn't see
(Continue reading)

Paula Hendricks | 1 Mar 20:06 2015

legit??? gnucash survey? from gnucas.interest <at> gmail??????

has anyone else gotten this? do we know who these folks are? is this legit? how did they get my email address?

why didn't this come thru the email list?

* * * * * 
Dear GnuCash user,
We are a group of developers exploring the idea of building a free online service based on GnuCash. We'd
appreciate if you can take this 10 second survey and help us gauge interest.
Thanks!

If you have trouble viewing or submitting this form, you can fill it out in Google Forms.
GnuCash Survey

Hello, We are a group of developers exploring the idea of building a free online service based on GnuCash.
We'd appreciate if you can take this 10 second survey and help us gauge interest. Thanks! 

... + more

* * * * * 

thanks.
	
	ph

~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~
paula hendricks ~:~ san francisco ~:~ 415.567.2647
author ~:~ writer ~:~ photographer ~:~  book designer
paulahendricks.com ~:~ cinnabarbridge.com

_______________________________________________
(Continue reading)

EngineInstitute | 28 Feb 17:43 2015

Savings Account Entries

OK, so I have a savings account and I am posting a dividend. When I post it
the software automatically splits the entry and then posts it also as a
debit. 
What is the correct way to handle this.
Thanks.

-----
China Blue
--
View this message in context: http://gnucash.1415818.n4.nabble.com/Savings-Account-Entries-tp4676566.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.

RhysGoodwin | 28 Feb 01:13 2015
Picon

Should I reconcile 3 years worth of transactions!?

Hi, first time poster here.

I've been using GnuCash for about 3 years. I don't ever really enter
anything manually into it. I just import my bank statements via OFX,
(transactional account, mortgage, credit card etc). I then assign
income/expenses to various accounts so I can track where my money is going.
I do this about once a month. 

I've never really used the reconciliation feature as everything in GnuCash
is direct from the bank. I'm about to start being a self employed contractor
and want to make sure I'm doing things right as I will probably need an
accountant to look over my books at the end of the year. 

Even as a contractor the transactions into GnuCash will come from my bank
statements, not manually. (I'll only be issuing 1 invoice a month).

Should I be reconciling transactions or doesn't it matter? Should I go back
and reconcile everything for the last 3 years?

Cheers,
Rhys

--
View this message in context: http://gnucash.1415818.n4.nabble.com/Should-I-reconcile-3-years-worth-of-transactions-tp4676552.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
-----
(Continue reading)

Carl Wilson | 28 Feb 05:55 2015
Picon

Program crashes all the time.

Process:               Gnucash-bin [4101]
Path:                  /Applications/GNUCash/Gnucash.app/Contents/MacOS/Gnucash-bin
Identifier:            org.gnucash.Gnucash
Version:               2.6.5 (2.6.5)
Code Type:             X86 (Native)
Parent Process:        ??? [1]
Responsible:           Gnucash-bin [4101]
User ID:               501

Date/Time:             2015-02-27 20:53:40.765 -0800
OS Version:            Mac OS X 10.10.2 (14C109)
Report Version:        11
Anonymous UUID:        9452F162-412F-6216-82E6-EFCE3692B198


Time Awake Since Boot: 10000 seconds

Crashed Thread:        0  Dispatch queue: com.apple.main-thread

Exception Type:        EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:       KERN_INVALID_ADDRESS at 0x000000000ff656b0

VM Regions Near 0xff656b0:
    CG backing stores      000000000fc7b000-000000000fec6000 [ 2348K] rw-/rw- SM=SHM  
--> 
    CG shared images       000000000ff94000-000000000ffac000 [   96K] r--/r-- SM=SHM  

Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
0   ???                           	0x0ff656b0 0 + 267802288
1   libgwenhywfar.60.dylib        	0x07417034 GWEN_InheritData_freeData + 36
(Continue reading)


Gmane