Introduction
Money questions are rarely simple. "Can we afford to hire next quarter?" depends on cash coming in, cash going out, when each bill is due, and what happens if sales dip. The answers hide in exports from your accounting tool, your payment tool and a spreadsheet or two. Pulling them together by hand is slow, and one wrong cell can change the answer. It is like a relay team passing a baton: each export has to hand the right number to the next step, or the finish line is wrong.
Finance Analyst builds the model that answers the question, and it shows its working. Each model is built the way a careful bookkeeper keeps a ledger. Inputs sit on one side, calculations sit on the other, every assumption is labelled, and every total traces back to its source. You can audit it yourself. You can also ask "what if" and watch the answer change.
Think of a model like a recipe card with the quantities written down. If the bakery runs short of flour, you change one line and the whole recipe updates. That is what the base, upside and downside cases do for your forecast. Like a pilot's checklist, Finance Analyst confirms every total against its source before you see it. It is also careful with words. Every figure carries its currency and its period, and every estimate is marked as one, so nobody in the room mistakes a guess for a fact. It also keeps your currency, fiscal year and reporting format in mind, so the numbers match how your business already reads them.
What Finance Analyst can do
- Build budgets, forecasts, cash-flow and unit-economics models, each with a base case, an upside case and a downside case.
- Reconcile exports from your accounting and payment tools, and explain any gap between them in plain words. It shows where each figure came from, so a gap is easy to trace back to its source.
- Prepare numbers for investors and your board, with each assumption written next to the figure it supports.
- Compare one period with another, and say what moved and why.
- Build dashboards and written reports on your financial data.
- Remember your currency, fiscal year, chart of accounts and reporting format for the next job.
- Work in the files panel for your exports, the browser panel for research, and the artifact panel for dashboards and reports you can share. Everything it makes stays where you can open it and check the working yourself.
- Work with your connected apps, Stripe, Zoho Books, Google Sheets and Gmail, once your account is linked. It never moves money or pays anything on its own.
Skills and use cases
analyze runs the full Upfyn Analyst Team pipeline on a data project: profile, clean, statistics, dashboard, charts, report and recommendations. For finance, it is the quickest way to see the whole picture of a month or a year. Example: "Give me a full analysis of this year's payment exports."
compare sets two data projects side by side. It shows how the structure, the quality and the key numbers shifted between them, and it writes a diff report that lists each change. This is the tool to reach for when a month looks strange and you need to know which numbers moved. Example: "What changed between our Q1 and Q2 exports?"
dashboard builds a standalone, interactive page with KPI cards, charts and a data table. You open it in your browser, and it works without any other tool. Example: "Build a dashboard I can open in my browser for the board."
report writes a publication-ready Markdown report. It holds an executive summary, a data overview, findings with charts, and recommendations. Example: "Write up the findings from these expense exports for the finance review."
One job, start to finish
This is the job the Finance Analyst's own description leads with. You have exports from your tools and you need to know how cash will move over the next year.
- You drop your exports into the files panel and type: "Build a 12-month cash-flow forecast from these exports."
- Finance Analyst checks what it has. If it does not know your currency, fiscal year or reporting format, it asks you once and remembers the answer.
- It reconciles the exports against each other. Where a total does not match, it shows the gap and explains it. It does not guess.
- It builds the forecast with the inputs on one side and the calculations on the other. Every assumption is labelled, so you can change one input and see its effect on the answer.
- It shows three cases: base, upside and downside. It names the one or two inputs that drive most of the change.
- Any figure it cannot trace to a source is marked as an estimate, with the method written beside it.
- If a point needs a professional, such as a tax question, it says so. It frames that point as analysis and suggests a qualified adviser check it.
- It asks what you want next, such as a board dashboard or a written summary, and builds only what you pick. It never moves money, pays or invoices without your explicit yes for that exact action.
- You get a forecast you can open and audit, with a list of assumptions and any gaps that are still open.
What you get at the end is a model you can check line by line. You see the base, upside and downside cases side by side, so you know the likely result and the range around it. Every estimate is marked as one, and every assumption is written down. Any export that did not reconcile is listed as an open item, so nothing is hidden. The decision stays with you. Finance Analyst gives you the numbers and the working, and it will not move money, pay or invoice anything without your explicit yes.
Works best with
Try it
- Build a 12-month cash-flow forecast from these exports, with a base, upside and downside case.
- Why doesn't this month's revenue match what our payment tool shows? Show me the gap.
- What are our unit economics per customer? List every assumption you used.
