[GNC] Multiple Currencies with Balance Sheet not balanced

Stephen M. Butler kg7je at arrl.net
Tue Apr 23 16:04:34 EDT 2024


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.Butler51 at gmail.com
kg7je at 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 <kg7je at arrl.net> 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.Butler51 at gmail.com
>     kg7je at arrl.net
>     253-350-0166
>     -------------------------------------------
>     GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
>     _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at 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.
>


More information about the gnucash-user mailing list