"Foreign Balance" column option no longer available; needed for reconciling USD asset accounts
My company switched to Quickbooks Online Plus this year in 2018. Previously we had a 2014 Desktop version. We have an office in Nicaragua that uses the NIO as the home currency, but also has various assets in USD (cash, bank accounts, loans receivable, security deposits).
In the report, "Transaction Report", we used to add the column "Foreign Balance" to make sure we could reconcile our non-cash accounts in USD. In Quickbooks Online Plus, there is not an option to choose "Foreign Balance", only "Foreign Amount", "Foreign Credit" and "Foreig Debit".
Since this option is not available, is there a workaround that we could use to close the books this year? Are there any plans to make this a column option in the future? It's very useful and even necessary information.
I'd like to share some information on why the option to choose a foreign balance is unavailable in the Transaction Report.
I can see how it would be useful to have the foreign balance in the transaction report. However, all reports in QuickBooks Online is on its first version as of this time and we're developing it to edit/customize all reports to have easy access in QBO.
For your future reference, you might also want to read this article to learn more about the customization of reports: How to Customize Reports.
Please know that you can always get back to us if you have any questions about QBO.