I'm trying to find a way to create a report for foreign currency liability accounts that is entirely in the foreign currency. For brief context, we're a branch of a US nonprofit based in another country. All our bookkeeping for reporting purposes happens in USD, but a lot of our day-to-day operations are in the currency of our host country, let's say XAF. Aside from our own funds, we act as a 'bank' (for want of a better word) for about 40 individuals and orgs, holding cash and processing transactions for them in XAF. These funds do not belong to us, so they are recorded as liabilities on our books. In our current system (two separate QB Desktop companies, one USD, one XAF), we send these individuals reports of their accounts at the end of each month, showing opening balance, transactions and closing balance.
I am in the process of moving us to a single multi-currency QBO company and have run into a problem – I cannot seem to generate a report entirely in the foreign currency. In the register I can see the balances and transactions in XAF, but reports generate the balances in USD. I've found tips on this forum to add columns like currency, foreign amount etc, and those are helpful, but they do not show the opening/closing/running balance of the account in XAF like the register does.
Is there something that I'm missing? I have found that I can filter and download the register, which is more or less what I need, but given the quantity (40+) of these to do per month, we really need to be able to create saved reports that can be emailed from QBO. The attached screenshots show the register of the example account with the balances in USD, and the register showing the actual amounts and balances in XAF, that I need to display on the report.
Thanks in advance.
