[GNC] Balance sheet shows 1c imbalance when JPY foreign currency accounts are present

[socket-grips0c at icloud.com]

Hello, I am encountering some rounding discrepancies when using foreign currency bank accounts. This means balance sheet total assets don’t match balance sheet total liabilities.

The issue arises when I have two bank accounts in JPY and using AUD as my home currency. Certain combinations of JPY account balances and exchange rates produce a balance sheet with 1c rounding differences. 

This is problematic as it means I can’t generate balance sheets that balance reliably. This means I’m unable to finalise accurate books to provide to an accountant.

Reports will show different values based on report options, but expected behaviour would be for balance sheets to always balance. I would also expect balance sheet and balance sheet (multicolumn) to produce the same totals.

The desired fix would be able to run the standard balance sheet report and have it consistently produce assets = liabilities.  

A test uncompressed XML file with only two transactions is attached. I have not turned on trading accounts in this test book, but I have observed the same behaviour in my personal books with trading accounts turned on. 

Screenshot 1
Accounts and balances.

Screenshot 2
Standard balance sheet set to default settings. Report correctly combines foreign currency balances to generate correct subtotal. So the subtotals are correct based on foreign currency total holdings. But this means the subtotal of assets is 1c (0.01) different to the subtotal of liabilities. The balance sheet does not balance. 

Screenshot 3
Balance sheet (multicolumn) shows correct totals, but subtotals ignore foreign currency totals. Subtotals appear to roll up based on local currency converted amounts, not underlying foreign currency totals. This is different behaviour to the standard balance sheet. 

Screenshot 4
Trial balance using last up to report date currency conversion shows matching totals, but these differ by 1c from balance sheet (multicolumn). Difference appears to relate to 1c unrealised gain.

Screenshot 5
Trial balance using weighted average of past transactions conversion shows totals that differ by 1c. Also shows fractional exchange rate. 

Screenshot 6
General journal shows 1c lower total.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: test-balance-sheet-foreign-currency.gnucash
Type: application/octet-stream
Size: 17782 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230810/80cafe24/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 1. two bank accounts in JPY.png
Type: image/png
Size: 592639 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230810/80cafe24/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2. balance sheet in home currency AUD shows 1c error.png
Type: image/png
Size: 458998 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230810/80cafe24/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 3. balance sheet multicolumn shows totals correct.png
Type: image/png
Size: 467698 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230810/80cafe24/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 4. trial balance totals dont equal balance sheet totals using last up to report date currency conversion option but show 1c unrealised gain.png
Type: image/png
Size: 432327 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230810/80cafe24/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 5. trial balance using weighted average currency conversion shows different totals.png
Type: image/png
Size: 432484 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230810/80cafe24/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 6. general journal shows differing exchange rates due to real numbers used internally in gnucash.png
Type: image/png
Size: 421393 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230810/80cafe24/attachment-0011.png>