Qodex.ai

Allows you to retrieve report for ExecutiveSummary

GET {{baseUrl}}/Reports/ExecutiveSummary?date=<date>

Request Params

KeyDatatypeRequiredDescription
datestringThe date for the Bank Summary report e.g. 2018-03-31

HEADERS

KeyDatatypeRequiredDescription
xero-tenant-idstring(Required) Xero identifier for Tenant

RESPONSES

status: OK

{&quot;Id&quot;:&quot;068d3505-ac37-43f3-8135-f912a5963d8a&quot;,&quot;Status&quot;:&quot;OK&quot;,&quot;ProviderName&quot;:&quot;provider-name&quot;,&quot;DateTimeUTC&quot;:&quot;/Date(1573755038314)/&quot;,&quot;Reports&quot;:[{&quot;ReportID&quot;:&quot;ExecutiveSummary&quot;,&quot;ReportName&quot;:&quot;Executive Summary&quot;,&quot;ReportType&quot;:&quot;ExecutiveSummary&quot;,&quot;ReportTitles&quot;:[&quot;Executive Summary&quot;,&quot;Online Test 11&quot;,&quot;For the month of November 2019&quot;],&quot;ReportDate&quot;:&quot;14 November 2019&quot;,&quot;UpdatedDateUTC&quot;:&quot;/Date(1573755038314)/&quot;,&quot;Fields&quot;:[],&quot;Rows&quot;:[{&quot;RowType&quot;:&quot;Header&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;&quot;},{&quot;Value&quot;:&quot;Nov 2019&quot;},{&quot;Value&quot;:&quot;Oct 2019&quot;},{&quot;Value&quot;:&quot;Variance&quot;}]},{&quot;RowType&quot;:&quot;Section&quot;,&quot;Title&quot;:&quot;Cash&quot;,&quot;Rows&quot;:[{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Cash received&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Cash spent&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Cash surplus (deficit)&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Closing bank balance&quot;},{&quot;Value&quot;:&quot;79.01&quot;},{&quot;Value&quot;:&quot;79.01&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]}]},{&quot;RowType&quot;:&quot;Section&quot;,&quot;Title&quot;:&quot;Profitability&quot;,&quot;Rows&quot;:[{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Income&quot;},{&quot;Value&quot;:&quot;40.00&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Direct costs&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Gross profit (loss)&quot;},{&quot;Value&quot;:&quot;40.00&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Other Income&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Expenses&quot;},{&quot;Value&quot;:&quot;205.40&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Profit (loss)&quot;},{&quot;Value&quot;:&quot;-165.40&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]}]},{&quot;RowType&quot;:&quot;Section&quot;,&quot;Title&quot;:&quot;Balance Sheet&quot;,&quot;Rows&quot;:[{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Debtors&quot;},{&quot;Value&quot;:&quot;590.00&quot;},{&quot;Value&quot;:&quot;550.00&quot;},{&quot;Value&quot;:&quot;7.3%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Creditors&quot;},{&quot;Value&quot;:&quot;-44.00&quot;},{&quot;Value&quot;:&quot;-44.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Net assets&quot;},{&quot;Value&quot;:&quot;594.16&quot;},{&quot;Value&quot;:&quot;759.56&quot;},{&quot;Value&quot;:&quot;-21.8%&quot;}]}]},{&quot;RowType&quot;:&quot;Section&quot;,&quot;Title&quot;:&quot;Income&quot;,&quot;Rows&quot;:[{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Number of invoices issued&quot;},{&quot;Value&quot;:&quot;1&quot;},{&quot;Value&quot;:&quot;0&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Average value of invoices&quot;},{&quot;Value&quot;:&quot;40.00&quot;},{&quot;Value&quot;:&quot;0.00&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]}]},{&quot;RowType&quot;:&quot;Section&quot;,&quot;Title&quot;:&quot;Performance&quot;,&quot;Rows&quot;:[{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Gross profit margin&quot;},{&quot;Value&quot;:&quot;100.0%&quot;},{&quot;Value&quot;:&quot;&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Net profit margin&quot;},{&quot;Value&quot;:&quot;-413.5%&quot;},{&quot;Value&quot;:&quot;&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Return on investment (p.a.)&quot;},{&quot;Value&quot;:&quot;-334.1%&quot;},{&quot;Value&quot;:&quot;0.0%&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]}]},{&quot;RowType&quot;:&quot;Section&quot;,&quot;Title&quot;:&quot;Position&quot;,&quot;Rows&quot;:[{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Average debtors days&quot;},{&quot;Value&quot;:&quot;442.50&quot;},{&quot;Value&quot;:&quot;0&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Average creditors days&quot;},{&quot;Value&quot;:&quot;-6.426484907497565725413826680&quot;},{&quot;Value&quot;:&quot;0&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Short term cash forecast&quot;},{&quot;Value&quot;:&quot;634.00&quot;},{&quot;Value&quot;:&quot;594.00&quot;},{&quot;Value&quot;:&quot;6.7%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Current assets to liabilities&quot;},{&quot;Value&quot;:&quot;4.0729764675459012154124644427&quot;},{&quot;Value&quot;:&quot;-62.034024896265560165975103734&quot;},{&quot;Value&quot;:&quot;106.6%&quot;}]},{&quot;RowType&quot;:&quot;Row&quot;,&quot;Cells&quot;:[{&quot;Value&quot;:&quot;Term assets to liabilities&quot;},{&quot;Value&quot;:&quot;&quot;},{&quot;Value&quot;:&quot;&quot;},{&quot;Value&quot;:&quot;0.0%&quot;}]}]}]}]}