We are allowed to trade in USD and ZWL. For the purposes of tax filings such as VAT returns, amounts are assessed in the base currency (ZWL), but are payable in USD and ZWL according to the proportion of income generated in the respective currencies.
Is there a built-in report I can use, or a custom report I can generate, that will show me all income for a specified period separated into the two currencies?
The “Sales Invoice Totals by Customer” report comes very close to what I need, except that it shows amounts for the USD customers in USD. I would like to see the base currency (ZWL) equivalent amounts. Since the exchange rate has changed multiple times during the period in question, I can’t just do a conversion using the information in the report.
I do not need to see customer- or transaction-level detail – all I really need is two figures:
- The income for the period from ZWL transactions
- The income for the period from USD transactions, expressed in ZWL using the exchange rates from the dates of the transactions
All my customers denominated in USD have “ (USD)” appended to their names, which could be useful for filtering in custom reports. The ZWL customers just have their names.