I've been using the xero-python library to pull through the trail balance (get_report_trial_balance) for an organization, but there is some information that appears to be visible on the Xero UI via the website, but not via the API. We have some accounts that are affected by foreign exchange rates. These are typically bank accounts, or accounts like accounts payable / accounts receivable, where we might be dealing with currencies other than the base one. On the trial balance on the Xero site, you would typically see them having two blue dots, as shown in the screenshot. Screenshot of account dealing with transactions with foreign currencies It appears that the trial balance endpoint, however, does not have such an indicator to show which accounts are affected by foreign exchange rates. I've gone through the documentation, and the closest thing I could see to what I am looking for is the currency field provided on specifically bank accounts. Seeing as this is not the only type of account of interest to me, this won't be sufficient for my use case. In a nutshell, I get the balances for the various accounts (and for the various days) from the trial balance endpoint. Additionally, I would just like to identify which of these balances are affected by foreign exchange rates. An example of such an account may be Accounts Payable, where you may owe a company money for an invoice charged in a currency other than your own. The value owed would thus fluctuate depending on the exchange rate at the time of querying the trial balance. I am not interested in the exchange rate itself at that point in time, only whether the account is affected by it. Continue reading...
