Build a cash flow statement for the period
The agent builds a cash flow statement from 1C and your bank feed: receipts, payments and the closing balance broken down by item and account.
Medium · 25 min · once a month
Who it fits
- Reporting for a bank, an investor or the board, where what's needed isn't account turnover but the structure of the cash flow.
- There is profit but no cash — you need to see where it went: into inventory, into receivables or into loan repayment.
- Not a fit if cash flow line items aren't filled in in 1C: there is nothing to assign operations to activity types by.
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.
Copy the prompt or open it straight in a chat with the agent.
Try for freeHow the agent does it
Set the period and the debatable rules
Say where leasing, founder loans and equipment bought in installments should go, if you have an established practice. Otherwise the agent will move them into a separate list.
Build the statement
The agent reads the postings and the statement, assigns operations to activity types and checks the closing balance against the actual account balance.
Check the result
A cash flow statement is verified by one number: the closing balance must match the bank — if it does, look for errors in the classification
Review 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.
What you set
1C, Tochka. From you: the period and the rules for assigning debatable line items to activity types.