Gnucash not correctly reconciling balance sheet and profit & loss
Marco Tilgner
mt1691 at hotmail.de
Sat Apr 27 11:35:29 EDT 2013
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
More information about the gnucash-user
mailing list