help
David Schamber
proudgecko at hotmail.com
Tue Apr 30 08:31:20 EDT 2013
Please unsubscribe me. Thanks! David
> From: gnucash-user-request at gnucash.org
> Subject: gnucash-user Digest, Vol 121, Issue 43
> To: gnucash-user at gnucash.org
> Date: Sun, 28 Apr 2013 12:00:02 -0400
>
> 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. RE: Importing information from Quicken (johnfaye)
> 2. Re: Gnucash not correctly reconciling balance sheet and
> profit & loss (Carsten Rinke)
> 3. Re: Importing information from Quicken (Colin Law)
> 4. Equity doesn't balance (DutchPro Computer Service)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 27 Apr 2013 23:19:12 -0400
> From: "johnfaye" <johnfaye at ptd.net>
> To: "'Colin Law'" <clanlaw at googlemail.com>
> Cc: gnucash-user at gnucash.org
> Subject: RE: Importing information from Quicken
> Message-ID: <20130428031913.311256A8010 at proxyz16.mailnet.ptd.net>
> Content-Type: text/plain; charset="US-ASCII"
>
> I was able to export a QIF file from Quicken, but it only includes the
> checking account that I have in Quicken and not my other accounts. I cannot
> get it to export the other accounts. The Quicken backup files that Quicken
> uses are QDF files and they are much larger than the QIF file that I
> exported. When I go to export files from Quicken, it gives two options: QIF
> file; and "Quicken Transfer Format (.QXF) Files." (Yes, it does say QXF, not
> QFX.) I tried that a little, but do not think it helped. I will look into it
> further.
>
> Also, my Quicken support expires on April 30th. If I use GNUCash, I hope I
> will be able to download information for all my accounts from the web.
>
> I would appreciate any suggestions you have.
>
> John
>
>
> -----Original Message-----
> From: Colin Law [mailto:clanlaw at googlemail.com]
> Sent: Thursday, April 25, 2013 4:49 PM
> To: johnfaye
> Cc: gnucash-user at gnucash.org
> Subject: Re: Importing information from Quicken
>
> On 25 April 2013 14:29, johnfaye <johnfaye at ptd.net> wrote:
> > I have read the instructions and have tried to import from Quicken, but
> > cannot seem to do it. For one thing, I do not find any QIF files in
> Quicken,
> > but do have QFX file. I cannot import the latter either. The backup folder
> > for Quicken does have QDF files, but I do not think I am supposed to
> import
> > those. I would appreciate your help. Thanks!
>
> See
> http://wiki.gnucash.org/wiki/FAQ#Q:_Which_is_the_best_way_to_import_data_fro
> m_Quicken.28TM.29.3F
>
> To generate the QIF files you have to use the Export function in
> Quicken if I remember correctly.
>
> Colin
>
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 28 Apr 2013 09:55:37 +0200
> From: Carsten Rinke <carsten.rinke at gmx.de>
> To: Marco Tilgner <mt1691 at hotmail.de>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: Gnucash not correctly reconciling balance sheet and
> profit & loss
> Message-ID: <517CD5F9.3040703 at gmx.de>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> Hi Marco,
>
> this is pretty much information, and at least in my mailtool hard to read.
>
> My first question would be whether the price editor has been updated
> with all need exchange rates, but this is just routine. As you write,
> you do not see this in other reports, so I guess the price editor is fine.
>
> To really give a chance to others to understand your setup, it would be
> best if you could create a smallest possible gnucash file that shows
> your described effect. Of course, this file should not contain
> confidential data.
> After that, file a bug report in bugzilla, attach your gnucash file
> there, and let us know about it in this mailing list.
> (see also http://wiki.gnucash.org/wiki/Bugzilla)
>
> Secondly, about the the Start menue:
> At the first glance to me that sounds like a Windows-Start menue. But to
> really get a good hint, it might be helpful that you mention the
> reference where you have this information from so others can see the
> context.
>
> Kind regards,
> Carsten
>
>
> On 04/27/2013 05:35 PM, Marco Tilgner wrote:
> > CAsh FLow non consistent:
> > Money into selected accounts comes from Equity:Opening Balances:OPening Balance USD $20,480.00Equity:Opening Balances:Opening Balance EUR $8,000.00 (8000 EUR not translated into USD)Equity:Opening Balances:Opening Balance HKD $1,600.00Equity:Opening Balances:Opening Balance SGD $17,500.00Money In $47,580.00
> > Money out of selected accounts goes to Expenses:Outside Services:Outside Services SGD $14,700.00Expenses:Outside Services:Outside services EUR $10,400.00Money Out $25,100.00Difference $22,480.00
> >
> >
> > Balance sheet not balancing:
> > Assets Assets $0.00 Current Assets $0.00 Petty Cash SGD 4,000.00 $2,800.00 Checking Account $0.00 Savings Account $20,480.00 $20,480.00HKD 10,000.00 $1,600.00EUR 0.00 $0.00 Accounts Receivable $0.00 Imbalance-USD $0.00Total Assets $24,880.00
> > Liabilities Liabilities $0.00 Credit Card $0.00 Accounts Payable $0.00 Total Liabilities $0.00Equity Equity $0.00 Opening Balances $0.00 Opening Balance EUR EUR 8,000.00 $10,400.00 Opening Balance HKD HKD 18,820.00 $3,011.20 Opening Balance SGD SGD 25,000.00 $17,500.00 OPening Balance USD $20,480.00 Retained Earnings $0.00 Retained Losses $26,511.20Unrealized Gains $2,400.00Total Equity $27,280.00Total Liabilities & Equity $27,280.00
> > Here for reference the trial balance
> > Account Name Debit CreditAssets Current Assets Petty Cash Petty Cash SGD $2,800.00 Checking Account Savings Account Savings Account EUR $0.00 Savings account HKD $1,600.00 Savings Account USD $20,480.00 Accounts Receivable Liabilities Credit Card Accounts Payable Income Interest Income Other Income Reimbursed Expenses Sales Expenses Adjustment Auto Fees Gas Parking Repair and Maintenance Bank Service Charge Books Cash Discounts Charity Depreciation Dining Dues and Subscriptions Education Equipment Rental Insurance Disability Insurance Liability Insurance Workers Comp Licenses and Permits Miscellaneous Office Supplies Outside Services Outside services EUR $10,400.00 Outside Services SGD $14,700.00 !
> Payroll Expenses Postage and Delivery Printing and Reproduction Professional Fees Accounting Accounting HKD $1,411.20 Legal Fees Rent Repairs Building Repairs Computer Repairs Equipment Repairs Janitorial Expenses Taxes Emp-FICA Federal FICA FUTA Local Other Tax Property State/Province Travel and Entertainment Entertainment Meals Travel Utilities Cable Cell Phone Electric Garbage collection Gas Internet Phone Water
> >
> > Equity Opening Balances Opening Balance EUR $10,400.00Opening Balance HKD $3,011.20Opening Balance SGD $17,500.00OPening Balance USD $20,480.00Retained Earnings Imbalance-USD
> > $51,391.20 $51,391.20
> > From: mt1691 at hotmail.de
> > To: gnucash-user at gnucash.org
> > Subject: RE: Gnucash not correctly reconciling balance sheet and profit & loss
> > Date: Sat, 27 Apr 2013 15:24:20 +0000
> >
> >
> >
> >
> > Sorry, profit & loss is OK, but balance sheet and cash flow do not balance.
> >
> > From: mt1691 at hotmail.de
> > To: gnucash-user at gnucash.org
> > Subject: Gnucash not correctly reconciling balance sheet and profit & loss
> > Date: Sat, 27 Apr 2013 15:19:22 +0000
> >
> >
> >
> >
> > Dear ladies and gentlemen,
> > I just started using your program and like the simple layout.
> > However it looks like I start getting problems with multi-currencies that the balance sheet and profit & loss are not reconciling right even though the trial balance is perfectly right.
> > Also where is the GnuCash ?Start? menu ? ... Run Install Online Price Retrieval in the GnuCash ?Start? menu entry in order to get automatic currencies.
> > Thank you for your help,
> > Marco Tilgner
> > Singapore
> > _______________________________________________
> > 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.
> >
>
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sun, 28 Apr 2013 08:57:17 +0100
> From: Colin Law <clanlaw at googlemail.com>
> To: johnfaye <johnfaye at ptd.net>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: Importing information from Quicken
> Message-ID:
> <CAL=0gLvkXa2FOL6qYAcfpvPpCNxL2wYxVMFgtgHKs38gOQ4QWQ at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> On 28 April 2013 04:19, johnfaye <johnfaye at ptd.net> wrote:
> > I was able to export a QIF file from Quicken, but it only includes the
> > checking account that I have in Quicken and not my other accounts. I cannot
> > get it to export the other accounts.
>
> Obviously this is not the best place to ask for help in how to use
> Quicken, but googling for
> how to export multiple accounts qif quicken
> leads to lots of hits, looking through a couple of these it appears
> that on the QIF export dialog there should either be an Export All
> Accounts checkbox or a Drop down list to select which accounts to
> export.
>
> Colin
>
>
> ------------------------------
>
> Message: 4
> Date: Sun, 28 Apr 2013 10:22:22 -0400
> From: "DutchPro Computer Service" <info at dutchpro-computerservice.com>
> To: <gnucash-user at gnucash.org>
> Subject: Equity doesn't balance
> Message-ID: <3EE1F167E93C450484A68BA22BAF7736 at DutchPro>
> Content-Type: text/plain; charset="UTF-8"
>
> Hello Everyone!
>
> I am fairly new to GNUcash and thought I had everything balanced, but my equity doesn?t make sense.
> I thougth my equity should be my ?net worth? but the only thing entered in equity is my opening balance of my
> checking and savings account given in a negative number. Assets, expenses, income and liabilities all balance and are correct.
> What am I missing or doing wrong?
>
> Thanks for your help!
>
> Marty
>
>
> ------------------------------
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> End of gnucash-user Digest, Vol 121, Issue 43
> *********************************************
More information about the gnucash-user
mailing list