Xero importation failure

Hi mingo

This is often an issue with API call restrictions i.e. you can only query a certain number of records per day. A way around this is using solutions like Clear Jelly (www.clearjelly.net) that enable you to automatically integrate and consolidate one or multiple entities even from different accounting systems (e.g. also Quickbooks, Sage etc.) and load them in a cloud based data repository optimized for analysis. This typically gives you much better performance,  options to do proper consolidation as well as with Clear Jelly also
budgeting and planning features. 

You can trial it for free - maybe it covers what you are looking for. Of course more than happy to assist with questions.

Martin