Report on an accrual or a cash basis

Read the same rows on an accrual basis (by the date each row is due) and on a cash basis (by the date of each allocation to it) for a period, each figure naming its basis and the rows behind it

action basis takes targets { amount_field, date_field }, allocations { list_id }, from, to and basis (accrual, cash or both; the list's saved report_basis, else both, when left out). Answers each basis asked with its total, count and the rows behind it (capped, with truncated said). It reads only the lists handed in.

What it asks for

Nothing: your AI starts it with your words.

Use it from your AI

Connect the AI you already use to Trillion once. Then ask in your own words; your AI finds this tool by what it does and runs it.

Say to your AI: “Use Trillion to read the same rows on an accrual basis (by the date each row is due) and on a cash basis (by the date of each allocation to it) for a period, each figure naming its basis and the rows behind it”