What is Fluxo?
Fluxo is a financial planning software. We enable you to create a financial model for your business faster by automating most of the tedious tasks and offering an easy to use table interface. Financial modeling with Fluxo facilitates data input, forecasting logic, and sharing:
Data input: with API and database integrations, we're starting with QuickBooks Online and Xero;
Forecasting logic: with an intuitive UI that lets you add assumptions that automatically get transformed into formulas;
Sharing: with customized reports that can be shared with a link.
How to create an account?
To create an account, go to our website and click the Sign Up button. You will be redirected to our sign up process.
The Setup includes:
Company Name: Your company name.
First Name: Your first name.
Last Name: Your last name.
Email: Preferably your work email, this will become your login.
Phone: Your phone number. We might call you to help with your onboarding.
Password: Please, use a secure password, this will be used for your login.
How does Fluxo work?
The core functionality in Fluxo is building financial models with forecasts referencing historical data.
Sounds complicated? It's not, once you understand the pieces, it all fits together beautifully.
In this video we will walk you through the basics. If you prefer reading, just skip the video and keep reading below.
Create your first project
A Project in Fluxo contains all the structure and data that you need for a particular company or project. It's similar to a file, and can contain, for example, your actual and forecasted financial statements, revenue models, hiring plans, or debt schedules.
To create your first project, just click "Create Project".
Project Name: Your company name.
Actuals Start Date: The oldest month of historical data to include. This needs to be a date in the present or past when the project is created.
Forecast Length: Years forecast.
Templates: Check the toggle in case you want to start from a template. Currently, we have 4 templates available. If you don't find what you're looking for, we will release more templates soon, so just let us know what you would like.
What are tables and rows?
Tables are groups of rows. They serve to organize your finance so you know where to look for what.
Rows are line items that contains both historical data (actuals) and forecasts (plans). For example:
Table: P&L. Rows: Revenue, Cost, Gross Profit, General Expenses, Operating Profit, Taxes, Net Profit.
Table: Revenue. Rows: New Clients, Churn, Total Clients, Price, Revenue.
Note in the example above how you can have Revenue as a row of P&L, but you can also have a whole table dedicated to Revenue (breaking down its components). You have total flexibility to decide which tables and rows you create within Fluxo.
If you started your project using a template, there will be already a set of interconnected tables and rows waiting for you when you enter the project.
For more details, see Tables.
What are actuals?
Actuals are your historical data. They can be inputted manually, automatically via formulas, or automatically via sources.
Every 1st of the month, the new calendar month is added automatically to your available actuals, so you can input data on it.
The new month will only show on your tables once you finalize it. Finalizing a month is signaling that the data for that month is ready, so it's not a forecast month anymore. If you input a wrong number, you can still change the data later by editing.
For more details, see Actuals.
What's a source?
Sources are used to extract data from other services or databases to Fluxo. Currently, we have two sources available: Quickbooks Online and Xero. If you would like to see another source in our list, let us know!
Once you add a source and connect it to your rows, the actuals for those rows will be automatically updated with data from the source.
You still need to start and finalize new months on the actuals page, as to ensure that data coming from an external source contains a full month.
For more details, see Sources.
What's a formula?
Formulas allow you to set a row to behave as a function of itself and/or other rows. You can add a formula to a row by clicking the "..." icon, and selecting "Add/Edit Formula To Row".
You can refer to other rows by typing the name of the row and selecting from the auto-complete. You can also auto-refer to the row for which you are creating the formula with the self() function. In both these cases, the interval parameter allows you to refer to a relative value in the past. For example, self(2) is a reference to the row value from 2 months prior.
Once a formula is added to a row, the entire row, including actuals and forecasts, will use the formula to calculate its value.
For more details, see Formulas.
What's a plan?
A plan is a scenario for forecasts. All plans within the same account share the same tables, rows, and actuals, but models and forecasts are different. That's because your past is the same no matter the scenario, but your future is dependent on your assumptions.
You will only see forecasts after you create your first plan.
For more details, see Plans.
What's a model?
A model is how you apply assumptions to a certain row to create forecasts. It can use the same functions as a formula, but it only applies to a certain period in the future and to one plan.
Once you select one of our model types, you will have to select which interval and period you want to apply it to, a name for the model (which will help you visualize your assumptions easier), and the specific inputs to your assumption.
If you add one or more models to a row with a formula, models will overwrite the row formula, which means forecasts will be based on models, not formulas.
For more details, see Models.
What's a report?
A report is a summary of a group of plans created for sharing and quick visualization. In a report, assumptions are the most important models that you have (and want to show), while key metrics are the numbers you want to follow.
Reports allow you to quickly visualize your metrics aggregated by month, quarter, and year, and share these with your team, your management, your board, or investors.
Think of assumptions as why the key metrics will be what you are forecasting.
For more details, see Reports.