Gnucash not correctly reconciling balance sheet and profit & loss
Carsten Rinke
carsten.rinke at gmx.de
Mon Apr 29 04:12:50 EDT 2013
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: [1]mt1691 at hotmail.de
To: [2]carsten.rinke at gmx.de
CC: [3]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
[[4]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: [5]carsten.rinke at gmx.de
> To: [6]mt1691 at hotmail.de
> CC: [7]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 [8]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: [9]mt1691 at hotmail.de
> > To: [10]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: [11]mt1691 at hotmail.de
> > To: [12]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
> > [13]gnucash-user at gnucash.org
> > [14]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
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
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
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
References
1. mailto:mt1691 at hotmail.de
2. mailto:carsten.rinke at gmx.de
3. mailto:gnucash-user at gnucash.org
4. http://www.activestate.com/store/activeperl
5. mailto:carsten.rinke at gmx.de
6. mailto:mt1691 at hotmail.de
7. mailto:gnucash-user at gnucash.org
8. http://wiki.gnucash.org/wiki/Bugzilla
9. mailto:mt1691 at hotmail.de
10. mailto:gnucash-user at gnucash.org
11. mailto:mt1691 at hotmail.de
12. mailto:gnucash-user at gnucash.org
13. mailto:gnucash-user at gnucash.org
14. https://lists.gnucash.org/mailman/listinfo/gnucash-user
More information about the gnucash-user
mailing list