How to Parse Xero Reports for Google Sheets

HI there!

How would one parse this into a format that looks good in google sheets. It’s a Trial Balance Report.

All the reports from xero and QBO look like this, and this should be simple as most of the generic connectors do this automatically. There is logic to the way it comes in. I suspect a custom structure is needed maybe?

This is what is looks like, roughly. I didn’t share everything because it shouldn’t be necessary.