[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