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

[john]

This is not uncommon, different banks have different rounding policies and GnuCash can't guess what they might be for your bank. The solution is to tell GnuCash the value in both currencies and let it calculate the price, because while currency amounts have to be rounded, prices don't.

Regards,
John Ralls


> On Aug 9, 2023, at 20:11, socket-grips0c--- via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> 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.
> 
> <test-balance-sheet-foreign-currency.gnucash><1. two bank accounts in JPY.png><2. balance sheet in home currency AUD shows 1c error.png><3. balance sheet multicolumn shows totals correct.png><4. trial balance totals dont equal balance sheet totals using last up to report date currency conversion option but show 1c unrealised gain.png><5. trial balance using weighted average currency conversion shows different totals.png><6. general journal shows differing exchange rates due to real numbers used internally in gnucash.png>_______________________________________________
> 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.