Re: [GNC] Multiple Currencies with Balance Sheet not balanced

2024-04-23 Thread Stephen M. Butler
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

2024-04-22 Thread Fred Tydeman
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.