Gnucash not correctly reconciling balance sheet and profit & loss
Carsten Rinke
carsten.rinke at gmx.de
Sun Apr 28 03:55:37 EDT 2013
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.
>
More information about the gnucash-user
mailing list