Importing Financial Data from Excel or CSV
Don't use QuickBooks Online or Xero? No problem. Clockwork's Excel/CSV import lets you build a full financial model from a spreadsheet — no accounting software integration required.
This is also a great option for businesses in the process of switching accounting systems, or for accountants who want to get a client up and running in Clockwork quickly.
What you'll need
You'll need your financial data in a spreadsheet format. This typically means a P&L with monthly actuals — the more history you have (up to 3 years), the better Clockwork can build your baseline forecast.
Step-by-step: importing from Excel
When adding a new company, select Import from Excel/CSV from the data connection options.
Download the Clockwork import template. The template is pre-formatted with the column structure Clockwork expects.
Fill in your financial data using the template:
Each row represents a financial account (e.g. "Product Revenue", "Payroll", "Rent")
Each column represents a month
Make sure account categories (Revenue, COGS, Operating Expenses) are labeled correctly
Save your completed file and return to Clockwork.
Upload the file using the file uploader. Clockwork will process and validate the data.
Review the import summary to confirm accounts were mapped correctly, then confirm.
Clockwork will then build your Financial Model from the imported data — including a baseline forecast based on the history you've provided.
Updating your data after import
Once you've imported your data, you can update it as new monthly actuals become available by re-uploading a revised file. Clockwork will incorporate the new data and refresh your model.
You can also connect to QuickBooks Online or Xero at any time after your initial Excel import — Clockwork will migrate your model to the live integration seamlessly.
Tips for a clean import
Use the provided template wherever possible — it eliminates most mapping issues.
Avoid merged cells, blank rows, or extra formatting in your spreadsheet.
Make sure your account names are consistent across months.
Include at least 12 months of history for the best baseline forecast quality.
Have questions about your import? Reach out to our support chat in the bottom right of your screen — we're happy to help.