I use Xero on a group of 3 legal entities. We have multiple BUs which use all three legal entities. All three legal entities use the same chart of account.
I want to generate a report to forecast the next 90 days of planned cash flows using the data of unpaid invoices/bills (amount + due date).
I want to use Datadear to get the balance of the accounts I want to monitor (for ex: Sales for BU1 and Costs for BU1), then using the invoices/bills which are awaiting payments and get the sum of all planned cash movements for each of the following 90 days.
And, I want to consolidate these information per legal entity and also per BU.
What is the recommended method to arrange such an excel sheet using Datadear?
Do I need to use one sheet per data table request per Xero company?
Is there a way to make the update of such a document “one click”?
Can I set a date in an excel sheet and use this date in the Datadear request (for ex: get all transactions after date in cell A1?)
Thanks in advance