Importing Financial Data from Excel
Don't use QuickBooks Online, QuickBooks Desktop, or Xero? No problem. Clockwork's Excel import builds your full financial model from a single workbook, with no accounting software integration required.
It's also a great option for businesses switching accounting systems, or for accountants who want to get a client up and running in Clockwork quickly.
What you'll need
Monthly P&L actuals by account. Up to 3 years of history gives the best baseline forecast, and we recommend at least 12 months.
Month-end balance sheet balances.
Open invoices, open bills, and bank transactions, if you have them.
Step 1: Add a new company
On the Select a company screen, click Add new company.
Enter the company name and click Next.
On the Connect your books screen, click Import from Microsoft Excel. It's below the QuickBooks and Xero options.
Step 2: Download the template
Click Download Template Pack (.xlsx). The file saves to your Downloads folder. The page itself doesn't change, so you only need to click once.
The workbook has these sheets:
Accounts: your chart of accounts. Required columns are AccountCode, Name, AccountType, and Classification.
ProfitLoss: your monthly P&L, one row per account per month (AccountCode, Date, Amount).
BalanceSheet: month-end balances, one row per account per month (AccountCode, Date, Balance, Period).
Invoices: customer invoices (InvoiceId, InvoiceDate, DueDate, Amount required).
Bills: vendor bills (BillId, BillDate, DueDate, Amount required).
BankTransactions: deposits and payments.
_Instructions: explains every column. Read it first, and don't delete it.
Step 3: Fill in the template
Start with the Accounts sheet. Give each account a short, unique AccountCode that you make up, such as 1001, RENT, or PAYROLL. That code is what links every row on the other sheets back to the account, so the spelling and case must match exactly everywhere you use it.
Pair each AccountType with the matching Classification:
BANK, ACCOUNTS RECEIVABLE, OTHER CURRENT ASSET, FIXED ASSET, and OTHER ASSET go with ASSET
CREDIT CARD, ACCOUNTS PAYABLE, OTHER CURRENT LIABILITY, and LONG TERM LIABILITY go with LIABILITY
EQUITY goes with EQUITY
INCOME and OTHER INCOME go with REVENUE
COST OF GOODS SOLD, EXPENSE, and OTHER EXPENSE go with EXPENSE
Add your monthly P&L on the ProfitLoss sheet. Use your income and expense accounts, one row per account per month. Date each row with the first day of the month, for example 2025-01-01 for January 2025.
Add month-end balances on the BalanceSheet sheet for your asset, liability, and equity accounts. Date each row with the last day of the month, for example 2025-01-31, and set Period to Month.
Fill in Invoices, Bills, and BankTransactions if you have them. On BankTransactions, Amount is always positive, and Type is either Spend (money out) or Receive (money in).
Rules the importer checks
Don't rename, reorder, or delete any sheets or column headers.
Values only, no formulas. Copy and Paste Values over any calculated cells.
Enter income and expenses as positive numbers. Clockwork knows which is which from each account's Classification.
Leave a cell blank if you don't have the value. Don't type N/A, a dash, or 0 as a placeholder.
Keep date cells formatted as dates, not text.
Save as an Excel Workbook (.xlsx). CSV, XLS, and ODS files aren't accepted. The limits are 25 MB per file and 5,000 rows per sheet.
Step 4: Upload and review
Drag your completed workbook into the upload box, or click Browse Files. Clockwork checks the file before importing anything and shows how many rows it found on each sheet.
If it finds errors, fix the workbook and upload it again.
If it says the workbook is valid but has warnings, read the notes. Warnings don't block the import. Click Continue with import if they look fine, or Fix and re-upload to correct them first.
Step 5: Let Clockwork build your model
Clockwork imports your data and builds your Financial Model, cash flow forecast, and dashboard. This usually takes a few minutes. When you see Welcome to Clockwork!, click Get Started.
Updating your data after import
Once you've imported your data, you can update it as new monthly actuals become available by uploading a revised workbook. Clockwork will incorporate the new data and refresh your model.
You can also connect to QuickBooks Online, QuickBooks Desktop, or Xero at any time after your initial Excel import. Clockwork will migrate your model to the live integration seamlessly.
Want to see it on your own numbers? Book a demo or start a free 14-day trial. Already a customer with a question? Message us in the chat and a person will reply.
