Skip to main content

Importing Financial Data from Excel

Build your Clockwork financial model from an Excel workbook, no accounting software required

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

  1. On the Select a company screen, click Add new company.

  2. Enter the company name and click Next.

  3. 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.

Did this answer your question?