Financial Statements

The financials tool turns general ledger or transaction data into a formatted income statement (P&L) or cash flow statement.

Who can see this: anyone who can open the project. Building a statement adds a step, so you need to be able to edit the project.

1. The Financial Statements step: in the Data Flow panel.
2. Line Item and Amount: the statement as a table.
3. The report: the same statement, formatted.

When to use it

Use it for formal statements:

• a profit and loss (income) statement
• a cash flow statement
• a comparison of periods, like month over month

It doesn’t build balance sheets.

Data it needs

The financials tool needs flat data: one row per account or entry, with the account code or name and the amount in columns.

• Summarized is best. It works best with general ledger data under about 50,000 rows. For bigger data, ask Querri to total it by account and period first.
• Nested exports need flattening. Some accounting exports keep line items nested inside each entry. Querri flattens those in an earlier step before building the statement.
• Accounts are classified for you. Querri sorts accounts into revenue, cost of goods sold, operating expenses and so on, using account numbers, names or account types.

In the Curio sample data, a summarized general ledger table works better than invoices alone, which only give revenue lines.

Ask for it

Ask in project chat, and say which statement and which periods. For example:

Build a monthly P&L from the GL.

Mention “cash flow” to get a cash flow statement. Otherwise you get an income statement.

What you get

1. The statement as a table. For one period, the columns are Line Item, Amount and Type. Type marks each line as a header, account, subtotal or total, and line items are indented to show the structure. For several periods, each period gets its own column, and you may also get Variance and Variance %.
2. A check. Querri reviews the statement’s math and how accounts were classified.
3. A formatted report titled “Income Statement” or “Cash Flow Statement”, laid out in the usual statement order.
4. A summary in chat, such as “Generated Income Statement with 42 line items”, with up to three key totals.

Limits

• No balance sheets.
• Amounts in the report are formatted in dollars, whatever currency your data uses.
• Large, unsummarized ledgers should be totaled first.

Credits

Asking uses a credit for the question, as usual. The financials tool doesn’t add a separate charge. Your plan may differ; see How credits are counted on Monitor usage.

Tips

• Name the periods. “Monthly for 2025” or “Q3 versus Q2” avoids guesswork.
• Ask for comparisons outright. Period columns and variance appear when you ask for them.
• Check the classification. If an account lands in the wrong section, tell Querri which section it belongs in and ask again.

Related

• Chat
• Projects