Financial data analyze
Let number talk ——from flow account to financial insight
Do financial analyze person, who not ever break down
Sales data at ERP, expense report at OA, bank flow at web bank export Excel, invoice info at tax system……every month just collect data together is one war.
Manual reconcile more bad: few hundred flow row by row check, wrong 8 cents find half day, find already exchange rate round cause. Do once over, next door say data update, back to start.
Most annoying is: abnormal find always late. Wait month end do report just know project over budget 30%, boss ask "why not say early"——I also want say early, I just know now also.
No matter your data is Excel, CSV or PDF financial report, all throw OpenClaw, it all read parse.
Auto do multi-table associate, same period compare, previous period compare——you only say "help me check this month what spend more", it list over budget item, reason why, improve suggest.
All calculate process show code, logic transparent can check. AndData whole process local process, one byte not upload, financial data safe, this bottom line.
3 financial analyze Prompt
From profit table break to cash flow forecast, financial people efficiency tool.
Please analyze this profit table (attachment), focus gross margin change:
1. Calculate recent 6 month gross margin trend (same period last year + month before compare)
2. If gross margin drop, help break down reason:
- Is high margin product sell less?
- Or raw material cost go up?
- Or discount too heavy?
3. List product line gross margin contribute rank
4. Period cost rate (sales/admin/research) change trend
Output need:
- Use table + chart show key data
- Give 2-3 practical improve suggest
- Write 200 word below summary, can direct send bossBase history data forecast next 3 month cash flow:
Data: [past 12 month cash flow statement path]
Forecast need:
1. Separate forecast operate, invest, finance three type cash flow
2. Think about seasonal change (like Q4 busy, Q1 slow receive)
3. Give optimistic/middle/bad three scenario
4. Mark possible tight money time node
5. Draw one line chart: history trend + forecast range
If forecast show one month net cash flow minus, please highlight important and give deal suggest.
Use Python statsmodels or Prophet do time series forecast.Compare recent two quarter cost detail:
- Q3 cost table: [file path]
- Q4 cost table: [file path]
Analyze need:
1. Every cost item compare, calculate growth rate
2. Sort by growth rate high to low, mark Top 5
3. Divide fixed cost and variable cost change
4. Cost occupy revenue ratio change (cost rate trend)
5. Mark abnormal: growth rate over 20% cost item must explain
Output one compare table (Excel), plus one para explain,
tone professional but simple, can direct put in quarterly report.Financial analyze: OpenClaw vs traditional Excel manual analyze
Excel old friend, but some thing really no good.
- Ask need big word, no need write formula no need pull pivot table
- Multi-table associate second finish, no need one by one VLOOKUP
- Auto find abnormal value and trend corner point
- Analyze logic show code, can check can do again
- Data local process, financial info safe no worry
- Simple summary ok, complex analyze formula stacks formula
- Multi-table associate easy error, one reference break all break
- Abnormal find all by eye scan, look blur maybe also no find
- Every analyze start from zero, no reuse
- Version manage messy, who change what ghost not know