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