Gnucash not correctly reconciling balance sheet and profit & loss
Marco Tilgner
mt1691 at hotmail.de
Sun Apr 28 22:04:30 EDT 2013
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::QuoteMicrosoft 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