Datadear is an excel plugin that enables powerful reporting from using the Xero database to be done in excel. As well as having a portfolio of templates which compliment Xero’s native reporting, the API provides Datadear with additional information that Xero’s front-end reporting cannot, which can be useful for creating powerful customised reports.

Multiple sheets can call on information independently, allowing you to design cover sheets and roll forward monthly reporting packs with ease – even when consolidating Xero organisations.

Datadear can create transactions in Xero, so can be used for uploading significant volumes of transactions, which Xero natively wouldn’t be able to do in one go.