Gnucash not correctly reconciling balance sheet and profit & loss
Marco Tilgner
mt1691 at hotmail.de
Mon Apr 29 05:37:14 EDT 2013
http://gnucash.1415818.n4.nabble.com/Solution-adding-Perl-to-get-online-downloads-td3889793.html
Carsten,
I found the reason. Perl was in the wrong dirctory.
Thanks.
Marco
Date: Mon, 29 Apr 2013 10:12:50 +0200
From: carsten.rinke at gmx.de
To: mt1691 at hotmail.de
CC: gnucash-user at gnucash.org
Subject: Re: Gnucash not correctly reconciling balance sheet and profit & loss
Hi Marco,
go to the Windows Start menu (don't start GnuCash, it is not inside
GnuCash).
Then go to "All Programs", which will open a folder structure, look
for the GnuCash folder, and inside this folder you should see it.
In German it is called "Online Kursabruf installieren".
At least this is how to find it in XP.
Gruss,
Carsten
On 04/29/2013 04:04 AM, Marco Tilgner
wrote:
Carsten,
just resolved the first issue by using "Reset defaults" in
the reports and now the cashflow and balance sheet work.
As for the GnuCash “Start”
menu I still did not
figure out where it is.
Marco
From: mt1691 at hotmail.de
To: carsten.rinke at gmx.de
CC: gnucash-user at gnucash.org
Subject: RE: Gnucash not correctly reconciling balance sheet
and profit & loss
Date: Mon, 29 Apr 2013 01:47:59 +0000
Hi CArsten,
Danke fuer die schnelle Antwort !
Leider bin ich bei bugzilla verloren.
Ich habe hier nochmal die export Dateien
angehaengt.
Den Price Editor hab ich gepflegt, die Accounts und
Trial Balance passen, aber die Reports Cash Flow und
Balance Sheet rechnen einfach nicht die Waehrungen und
summieren nicht (die Optionen der Reports sind auch
richtig eingestellt)...
Das GnuCash “Start”
menu wurd in
der Docu erwaehnt, wenn es um die Installierung der
automatischen Waehrungsupdates geht.
Installing Finance::Quote
Microsoft Windows:
• Close GnuCash.
• You need to have installed ActivePerl
[http://www.activestate.com/store/activeperl]
• Run Install Online Price Retrieval in the
GnuCash “Start” menu entry.
Viele Gruesse,
Marco
> Date: Sun, 28 Apr 2013 09:55:37 +0200
> From: carsten.rinke at gmx.de
> To: mt1691 at hotmail.de
> CC: gnucash-user at gnucash.org
> Subject: Re: Gnucash not correctly reconciling
balance sheet and profit & loss
>
> 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.
> >
>
>
--Forwarded Message Attachment--
Balance Sheet 12/31/2013
Balance Sheet 12/31/2013
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.00
HKD 10,000.00
$1,600.00
EUR 0.00
$0.00
Accounts
Receivable
$0.00
Imbalance-USD
$0.00
Total Assets
$24,880.00
Liabilities
Liabilities
$0.00
Credit
Card
$0.00
Accounts
Payable
$0.00
Total Liabilities
$0.00
Equity
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.20
Unrealized Gains
$2,400.00
Total Equity
$27,280.00
Total Liabilities & Equity
$27,280.00
Exchange rates
EUR 1.00
$1.30
HKD 1.00
$0.16
SGD 1.00
$0.70
--Forwarded Message Attachment--
Cash Flow - 01/01/2013 to 12/31/2013
Cash Flow - 01/01/2013 to 12/31/2013
Selected Accounts
Assets
Assets:Current
Assets and selected subaccounts
Imbalance-USD
Money into selected accounts comes from
Equity:Opening
Balances:OPening Balance USD
$20,480.00
Equity:Opening
Balances:Opening Balance EUR
$8,000.00
Equity:Opening
Balances:Opening Balance HKD
$1,600.00
Equity:Opening
Balances:Opening Balance SGD
$17,500.00
Money
In
$47,580.00
Money out of selected accounts goes to
Expenses:Outside
Services:Outside Services SGD
$14,700.00
Expenses:Outside
Services:Outside services EUR
$10,400.00
Money
Out
$25,100.00
Difference
$22,480.00
Exchange rates
EUR 1.00
$1.30
HKD 1.00
$0.16
SGD 1.00
$0.70
--Forwarded Message Attachment--
Trial Balance 12/31/2013
Trial Balance 12/31/2013
Account Name
Debit
Credit
Assets
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.00
Opening
Balance HKD
$3,011.20
Opening
Balance SGD
$17,500.00
OPening
Balance USD
$20,480.00
Retained
Earnings
Imbalance-USD
$51,391.20
$51,391.20
More information about the gnucash-user
mailing list