I use a full download of all account transactions to drive excel based P&L and balance sheet reports.
When running this recently, the total of the Journal Lines.Net Amount column no longer equals zero, which of course cannot be right. There are no imbalances in Xero itself so there must be something going on with the data extraction?