Projections are the primary building blocks of the cash flow forecast, and for companies which are not connected directly to an accounting software such as QuickBooks Online, QuickBooks Desktop, Xero and FreshBooks they are the only building blocks.
So what are projections?
Projections are predicted cash flow transactions - payments from customers, planned loans, one-time bill payments or recurring expenses such as rent.
All projections must include the following fields:
The amount of money for the transaction - positive for cash in, negative for cash out.
The expected date of the transaction.
The customer, vendor or account related to the transaction.
The account or account type which is used for classification.
Projections can also include:
Free text details.
Recurrence details for recurring transactions.
Interval - e.g. monthly, weekly, quarterly.
End date.
Trend - increase or decrease by percentage or amount each time.
How do I create projections?
There are three ways to create projections:
Enter projections manually using the projections dialog.
Import projections from Excel or CSV.
Automate using Zapier or Integromat.
To add projections, click the Add Projections button on the right side of the top bar:
To enter projections manually, add lines, enter the details, and click the Add Projections button when you're done:
To import projections from Excel or CSV, switch to one of the import tabs and download the template:
Then, enter the projections to the table:
Next, Click the Upload File button and select the file, and when the upload is complete review the projections before saving.
To automate projections using Zapier please refer to our Zapier Integrations page.