Re: [GNC] Multiple Currencies with Balance Sheet not balanced
Tried that and tried last before date. Both had same results. Only PHP rates are in the price database and the entry for 7/5/23 is correct. Stephen M Butler stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 4/22/24 22:41, Fred Tydeman wrote: A guess on my part. In the Balance sheet: Click on Options Click on Commodities Click on Price Source Try Closet to Report Date You might also check if the conversion rate between PHP and USD was recorded: Tools Price Database Currencies Look in both USD and PHP for the date in question. On Mon, Apr 22, 2024 at 3:52 PM Stephen M. Butler wrote: This has been a thorn in my flesh for some time but I've been too busy to deal with it. The non-profit where I volunteer works in two currencies: PHP and USD. The main currency is set to USD. Chapter 12 of the Guide implies two ways of tracking multiple currencies: Manually (without trading accounts) and Automatically (with trading accounts). I do not have trading accounts activated. Every time I exchange USD into PHP I enter the exact number of PHP received for he exact USD value. Today I tracked down the first instance of the Balance Sheet going out of balance. On July 4, 2023, Assets = Liabilities + Equity. [$6562.90] On July 5 there is a single transaction moving $626.80 USD to 34,250 PHP. But the Balance Sheet for that date shows Assets of $6518.06 vs Liabilities + Equity of $6516.45 There is only one price entry for 7/5/2023 in the price database. I did click on the transaction to verify the $626.80 to 34,250 PHP was entered correctly. This transaction was between two asset accounts. One in USD and the other in PHP. So why did my Asset value drop? And why is the Balance Sheet out of balance? I suspect I'll find more of these as I move forward toward today. --Steve -- Stephen M Butler stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Multiple Currencies with Balance Sheet not balanced
A guess on my part. In the Balance sheet: Click on Options Click on Commodities Click on Price Source Try Closet to Report Date You might also check if the conversion rate between PHP and USD was recorded: Tools Price Database Currencies Look in both USD and PHP for the date in question. On Mon, Apr 22, 2024 at 3:52 PM Stephen M. Butler wrote: > This has been a thorn in my flesh for some time but I've been too busy > to deal with it. The non-profit where I volunteer works in two > currencies: PHP and USD. The main currency is set to USD. > > Chapter 12 of the Guide implies two ways of tracking multiple > currencies: Manually (without trading accounts) and Automatically (with > trading accounts). I do not have trading accounts activated. > > Every time I exchange USD into PHP I enter the exact number of PHP > received for he exact USD value. > > Today I tracked down the first instance of the Balance Sheet going out > of balance. On July 4, 2023, Assets = Liabilities + Equity. [$6562.90] > On July 5 there is a single transaction moving $626.80 USD to 34,250 > PHP. But the Balance Sheet for that date shows Assets of $6518.06 vs > Liabilities + Equity of $6516.45 > > There is only one price entry for 7/5/2023 in the price database. I did > click on the transaction to verify the $626.80 to 34,250 PHP was entered > correctly. > > This transaction was between two asset accounts. One in USD and the > other in PHP. So why did my Asset value drop? And why is the Balance > Sheet out of balance? I suspect I'll find more of these as I move > forward toward today. > > --Steve > > -- > Stephen M Butler > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Multiple Currencies with Balance Sheet not balanced
This has been a thorn in my flesh for some time but I've been too busy to deal with it. The non-profit where I volunteer works in two currencies: PHP and USD. The main currency is set to USD. Chapter 12 of the Guide implies two ways of tracking multiple currencies: Manually (without trading accounts) and Automatically (with trading accounts). I do not have trading accounts activated. Every time I exchange USD into PHP I enter the exact number of PHP received for he exact USD value. Today I tracked down the first instance of the Balance Sheet going out of balance. On July 4, 2023, Assets = Liabilities + Equity. [$6562.90] On July 5 there is a single transaction moving $626.80 USD to 34,250 PHP. But the Balance Sheet for that date shows Assets of $6518.06 vs Liabilities + Equity of $6516.45 There is only one price entry for 7/5/2023 in the price database. I did click on the transaction to verify the $626.80 to 34,250 PHP was entered correctly. This transaction was between two asset accounts. One in USD and the other in PHP. So why did my Asset value drop? And why is the Balance Sheet out of balance? I suspect I'll find more of these as I move forward toward today. --Steve -- Stephen M Butler stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.