Build a cash flow statement for the period
The report shows profit, the accounts show nothing. The agent lays out how much the business itself earned and how much went into kit and loans.
Medium · 25 min · once a month
What you get
a table in the reply · once a month
Cash movement, March Everyday operations +2,340,000 Equipment purchases -890,000 Loans and borrowings -450,000 Closing balance 4,120,000 ₽ — matches the bank to the kopeck, so the figures add up. Needs your call: leasing of 210,000 — do you count it as borrowing or as everyday operations?
A sample on made-up data — your numbers will be your own.
Who it fits
- A report for a bank or an investor that needs the shape of the cash flow, not account turnover.
- There is profit but no cash — you need to see where it went: stock, customer debt or loan repayment.
When it won't work
Cash flow line items aren't filled in in 1C — nothing to sort operations by activity type with.
How the agent does it
Settle the debatable items
Say where you normally put leasing, founder loans and equipment bought in instalments. With no established practice the agent moves them to a separate list.
Build the statement
The agent reads postings and the bank statement, sorts operations by activity type and checks the closing balance against the actual account balance.
Check one number
This statement is verified by the closing balance: it must match the bank. Once it does, look for errors in the classification, not in the sums.
What you set
You'll need 1C and Tochka. From you: the period and your rules for the debatable items — leasing, founder loans, equipment bought in instalments.
What you'll need
Starter prompt
Copy the prompt or open it straight in a chat with the agent.
Build a cash flow statement for [period] using 1C and bank data. Assign all receipts and payments to three sections: operating, investing, financing activities. For each section — line items with amounts, inflow, outflow and net flow; above and below — the cash balance at the start and end of the period. Don't count transfers between our own accounts or currency conversion as either a receipt or a payment. If the activity type for an operation isn't obvious, don't default it to operating — move it into "needs classification" with the amount and the payment description. Output an XLSX: a "Cash flow statement" sheet by section, a details sheet with links to the operations, and a control line — does the closing balance agree with the bank statement.
Open in chatReview the cash flow statement. List: — the difference between the calculated closing balance and the statement balance, if there is one; — operations from "needs classification" and why the section couldn't be determined; — internal transfers between accounts: did you net them out or count them as turnover; — payments assigned to a section by payment description rather than by the cash flow item in 1C; — large one-off operations that distort the period's operating flow. Whatever you can reclassify by the rule, show as a list; leave the rest to me.
A second prompt — the agent uses it to review its own work and show what's left for you.