How to prepare and import your own Excel or CSV accounts spreadsheet
Short version. Importing your own spreadsheet fills only the Financial Data figures you approve from your Excel or CSV accounts. It does not need accounting software, change your dates or submit anything. #Simple CompanyTax can import your own Excel or CSV accounts spreadsheet for your CT600 and annual accounts filing. You do not need Xero or QuickBooks. Use prepared profit and loss, balance sheet or trial balance figures. Choose Another spreadsheet or CSV under Where are your figures from?, then confirm the heading row and column roles on the grid before reviewing the mappings.
On this page
If you have a standard vendor export, use the Xero export guide QuickBooks export guide or Sage Accounting export guide. The complete import guide explains filing lines, separate reports and common import problems.
Your own spreadsheetFinancial Data onlyAccounts periods over 12 monthsWhere you see it: Financial Data › Profit & loss or Balance sheet
Before entering figures, the filing setup questions can set the existing destination and CT600 route for an ordinary limited company. They keep the full accounts dates beside the CT600 dates. You can also continue with the controls below without opening the questions.
Importing your own spreadsheet fills only the Financial Data figures you approve from your Excel or CSV accounts. It does not need accounting software, change your dates or submit anything.
- Open the importer with Import profit and loss or Import balance sheet, then choose Another spreadsheet or CSV.
- You choose the heading row and what each column holds. Account code and account type are optional.
- Your figures change only when you select Use these figures. Choosing a file or a column changes nothing.
- For an accounts period that ends more than 12 months after it starts, even by one day, import one full-period total. Amounts that belong to one date then need allocating between the two returns.
- Nothing is submitted to HMRC or Companies House by importing.
Is this the right guide for you?
Use it if all of these are true
- You have prepared account totals in Excel or as a CSV, not a list of bank transactions.
- The totals cover the accounts period you are filing.
- Your report is not a standard Xero, QuickBooks or Sage Accounting export, or you edited one.
Do not use it if
- You have an unedited export from Xero, QuickBooks or Sage Accounting.Use instead: Import Xero, QuickBooks, Sage Accounting or spreadsheet data
- You only have a few totals.Typing them into Financial Data may be quicker than preparing a file.
- You only have bank statements, invoices or receipts.Prepare account totals first. The importer does not turn transactions into accounts.
Common mistake: adding monthly columns to the total
A spreadsheet with monthly columns and a year-to-date total holds the same money twice. Choose one column that covers the whole accounts period, usually the total, and set the monthly columns to Not used. Do not choose a comparative column as this year's amount either. For an accounts period longer than 12 months, the total must cover every month of it, not just the first 12. Importing a column never changes your filing dates.
More help: The Grand total does not match the monthly amounts
Worked example
- Spreadsheet
- The downloadable example workbook below, with a profit and loss sheet and a balance sheet
- Accounts period
- 1 April 2025 to 30 June 2026 (15 months, so two CT600s)
- Profit and loss column
- YTD, which covers all 15 months. The monthly columns are not imported
- Balance sheet column
- The closing balances at 30 June 2026. The earlier column is a comparison
- Result
- Turnover £141,600 and profit before tax £40,950, as shown in Check the result
The company and all figures on this page are fictional.
Before you start
- Your spreadsheet
- One account per row, with an account name and an amount. Profit and loss and balance sheet on separate sheets or files.
- The file
- XLSX, XLS, CSV or TXT, up to 1 MB, 2,000 rows and 200 columns per sheet. Or rows you can copy and paste.
- Your filing
- A filing with its accounting period chosen. Save and resume a filing
The company and all figures on this page are fictional.
Step by step
Open the importer
- Import profit and loss
- Click it in the Profit & loss header, or Import balance sheet for a balance sheet
- Where are your figures from?
- Another spreadsheet or CSV, then Continue
- Your file
- Upload it, or select Paste rows instead and paste the rows
Choose the columns
- Which row has your column names?
- Click the row with your headings, or My file has no heading row
- Above each column
- Account name, Amount, or Not used. Account code and Account type if you have them
- Report type
- Profit and loss, balance sheet or trial balance
- How signs are shown
- Match how your spreadsheet shows income and costs
Click Review mapping.
More help: Column settings in detail
Review and apply
- Amber rows
- Confirm the proposed line, or choose another
- Not used
- For a row that should not fill any figure
- Review changes
- If fields already hold figures, choose Keep current, Replace or Clear
Click Use these figures. Repeat with the balance sheet if it is a separate sheet or file.
More help: Review the mapping
After the import
- Accounts period over 12 months
- Click Allocate beside each amount the notice lists and divide it between the two returns
- Save Progress
- Save, then check the totals against your spreadsheet
More help: Check the result
Sample outcome
1. Prepare your own spreadsheet
Start with your prepared account totals. This import does not turn a list of bank transactions, invoices or receipts into accounts. Put one account on each row and use names you understand, such as Sales, Rent or Business bank account.
Keep profit and loss and balance sheet figures on separate sheets or in separate files. A profit and loss report covers income and costs over the full accounting period. A balance sheet contains assets, liabilities and equity at the period end. If you already have a prepared trial balance with Debit and Credit columns, use that instead.
You can keep your existing column headings and layout. Choose the matching columns when importing. Import is most useful when you already have many account balances to group into the filing headings. With only a few totals, entering them directly in Financial data may be quicker.
Try a realistic Excel accounts example
Download the Excel accounts example. It contains 49 fictional accounts across two sheets, with income, costs, assets, liabilities and equity. The profit and loss includes 15 monthly columns and a YTD total for 1 April 2025 to 30 June 2026. The balance sheet includes the closing balances and a separate comparative column.
The example includes headings, subtotals, a percentage row, sales returns, a rent refund and accumulated depreciation. These show why you should check the selected amount column and mapping rather than adding every visible number. It is prepared account data, not a list of bank transactions.
Fictional example. Use it to practise in a test draft. Replace every account, amount and date before using a copy for your company. The invented account codes are identifiers, not Xero or QuickBooks codes. You do not need to add codes or types to your own spreadsheet.
Prefer CSV? Download the same calculated figures as a profit and loss CSV example and a balance sheet CSV example. Each CSV contains one report. The Excel version keeps both sheets and its formulas.
The minimum layout for a small spreadsheet
Put Account name in cell A1 and Amount in B1. Enter the accounts below them. For this layout, enter both income and costs as positive numbers. Choose Income and costs are positive when importing it.
Fictional example. These are example figures, not figures to use in your filing. Replace every example amount and account with your own prepared figures.
| Account name (A) | Amount (B) |
|---|---|
| Sales | 12000.00 |
| Rent | 2000.00 |
| Bank fees | 100.00 |
This three-row illustration explains the minimum layout. You can add more account rows. In this simple layout, list only the income and cost accounts. Keep your net profit calculation outside the rows you import.
Can I import a profit and loss CSV without column headings?
Yes. A report can have text account names, account amounts and section headings without column titles. Codes are optional and the columns can appear in different positions. You do not need to add a year heading or use particular section names. A separate column holding only calculated totals is not an account amount column.
On the grid, select My file has no heading row. Select the columns containing Account name and Amount. Choose Not included for absent Account code and Account type columns. When the file does not identify its report type, Report type starts on Profit and loss from Import profit and loss or Balance sheet from Import balance sheet. Change it if your file is something else, then choose the matching How signs are shown setting. If several amount columns remain, choose the one covering your full accounts period.
Review the first account and every mapped total before applying. Section headings and recognised calculated totals are left out. Uncertain accounts stay available for your choice. Import does not change your filing dates or unrelated allocations. For a period longer than 12 months, use the existing Allocate controls for amounts that need allocating between the two returns.
A separate balance sheet spreadsheet
Use the same two headings for your prepared balance sheet. In the fictional example below, assets, liabilities and equity are positive amounts. Choose Each line uses its natural sign when importing this layout. Keep an actual negative balance negative, and review where it belongs.
| Account name (A) | Amount (B) |
|---|---|
| Business bank account | 4000.00 |
| Accounts receivable | 2000.00 |
| Accounts payable | 1500.00 |
| Loan | 1000.00 |
| Share capital | 100.00 |
| Retained earnings | 3400.00 |
This is a second minimum-layout illustration, separate from the downloadable workbook. Replace all example data with your own balances. Choose the appropriate loan category during mapping. Do not invent a retained earnings amount to make the balance sheet balance.
What you can leave out
Account code and Account type are optional. Leave both settings as Not included if your spreadsheet only has names and amounts. You do not need to create nominal codes or learn accounting software categories.
Use numbers in the amount cells, with pence if needed. Avoid merged cells, percentage columns and extra subtotal rows in a file you prepare yourself. You can keep an existing report layout, but check that subtotals are not included alongside their detail. If you already have monthly or comparative columns, select the total covering the filing period rather than adding all the columns together.
2. Save your Excel or CSV file
- In Excel, open File, then Save As or Save a Copy.
- Choose Excel Workbook (.xlsx) to keep the workbook and its sheets. You can import this file directly. There is no need to convert it to CSV.
- If you prefer CSV, select the sheet you want to export, choose a CSV format and save it. CSV exports only the active sheet. Save the profit and loss and balance sheet separately if they are on different sheets.
- If an amount uses a formula, make sure the cell shows its calculated number. If the importer cannot read it, make a copy and paste the calculated values before saving that copy.
The importer accepts CSV, TXT, XLS and XLSX, up to 1 MB, 2,000 rows and 200 columns per sheet. You can also copy the heading row and account rows from Excel and select Paste rows instead after choosing Another spreadsheet or CSV in the importer.
3. Import and choose columns
Each import starts with Where are your figures from?. Choose Xero, QuickBooks, Sage Accounting or Another spreadsheet or CSV, then select Continue. This choice is asked again for every import. If you chose a file first, the selected source is a guess from that file.
For your own spreadsheet, choose Another spreadsheet or CSV. Upload the file or select Paste rows instead. The first sheet with at least two filled rows opens first. Keep one report per sheet and use Workbook sheet to choose another.
- Open your filing, go to Financial data and select Import profit and loss or Import balance sheet in the relevant section header. Either button also accepts a trial balance.
- Choose Another spreadsheet or CSV, select Continue, then upload your file or paste your rows.
- At Which row has your column names?, click the row number containing your headings. The heading is highlighted and earlier rows are greyed out. For a headerless report, select My file has no heading row.
- Above each column, choose Account name, Account code, Account type, Amount, Debit, Credit or Not used. Choose one Amount column or both Debit and Credit columns. Changing a column’s role replaces its previous role.
- For a comparative column, select Prior year amount when importing into this year. Check that current and prior amounts are in the correct columns. Monthly columns are not prior-year comparatives.
- Check Report type and How signs are shown, then select Review mapping. If it is greyed out, the line above it says what to change. Changing Report type keeps your chosen Amount column. Recheck the sign setting and totals before applying. The labelled controls under Columns give the same choices as the grid.

A heading row naming each column gives the best preselection. If two roles share a column, choose a different column for one of them. If a selected amount cell holds text, correct the file or mark that account Not used during review. A formula without a saved value needs an export containing values.
Bank statements and transaction lists cannot be imported. Prepare a trial balance, profit and loss report or balance sheet first.
- Workbook sheet and Report type
- Profit and loss first, then Balance sheetImport one sheet at a time into the same draft. CSV files have no Workbook sheet selector.
- Heading row
- Row 6: Account code · Account description · Account typeRows above it contain the report title and example period.
- Account name
- Account description (2)Column B has the account names. Column A has codes, not names.
- Account code and Account type
- Account code (1) and Account type (3)These columns exist in this example. Leave them Not included when absent from your own file.
- Amount layout
- One amount columnChoose one full-period column. Do not add monthly amounts and YTD together.
- Profit and loss amount
- YTD (19)Column S covers all 15 months. Choose YTD under Amount column if prompted. The individual months are not additional import amounts.
- Balance sheet amount
- 30 Jun 2026 (4)Column D contains the closing balances. The 31 Mar 2025 column is a comparison, not an amount to add or import into this filing’s closing balances.
- How signs are shown
- Income and costs are positive (profit and loss) or Each line uses its natural sign (balance sheet)Keep the negative returns, refund, accumulated depreciation and dividends paid as they appear. Check their combined filing line totals.
For practice, the workbook’s accounting period is 1 April 2025 to 30 June 2026. When importing your own report, select a total covering your own filing dates. Importing a column does not change the draft’s dates. This example does not include a charitable donation or capital allowance. If your own report updates an amount needing allocating between two returns, follow the Allocate actions after applying.
If you are using the small two-column illustrations instead, use these simpler settings:
- Heading row
- Row 1: Account name · AmountThe row containing the column headings.
- Account name
- Account name (1)Column A contains Sales, Rent or the balance sheet account descriptions.
- Account code and Account type
- Not includedThese examples do not have either optional column.
- Amount layout
- One amount columnThere is one Amount column, rather than separate Debit and Credit columns.
- Amount
- Amount (2)Column B contains the prepared figures.
- How signs are shown
- Income and costs are positive (profit and loss) or Each line uses its natural sign (balance sheet)Use the convention described beside the example. If your own profit and loss shows negative costs, choose Income is positive, costs are negative instead.
For an existing trial balance with separate Debit and Credit columns, choose Debit and credit columns under Amount layout and select each named column. Keep the balances as they appear in your prepared trial balance. Under How signs are shown, choose Debits are positive, credits are negative for a Debit and Credit layout. You do not need to turn them into the single-amount examples above.
Select Review mapping if the file step is still open. If you are already on Review, continue with the mapped accounts below.
4. Review the mapping
- Check where every account will go. Amber rows need your choice. Select the proposed line to read its description and examples or choose a different line.
- Select Apply change to assign and confirm a line. Assign saves the choice in amber for later confirmation. Select Confirm when the proposal agrees with your prepared accounts. Use Not used for a row that should not contribute.
- If you see Review changes, open it and choose Keep current, Replace or Clear for existing filing figures.
- Select Use these figures to fill the financial fields. Choosing the file or a column does not apply the figures to your filing.
- If you imported profit and loss first, repeat the process with the balance sheet sheet or file in the same draft. Review any changes before applying the second report.
You can search accounts and select several rows for a bulk move. Select Use this total when an existing report contains no detail, or Split between two lines when one account contains two categories. Enter amounts that add back to the account total. Read the filing line descriptions and complete mapping guide if you need help choosing a line.
When the balance sheet shows Corporation Tax payable, review any separate tax liability mapping. If your file has no separate tax liability, the payable keeps its current setting. After applying, check Total creditors: due within one year and Closing retained earnings against your accounts. If the creditors you imported already include the tax, enter 0 in the payable box or take the tax out of the other creditors. If imported retained earnings already include this period’s tax charge, add back the signed charge from the profit and loss. Subtract it instead if it is a tax credit.
For a long accounting period, apply the full-period figures first. The notice lists amounts still needing allocating between the two Corporation Tax returns. Select Allocate beside each amount to open its existing controls. Your dates, figures and allocation stay under your control.
5. Check the result
For the downloadable example, Turnover is £141,600, Cost of raw materials and consumables is £42,600, Staff costs are £30,600, Other charges are £24,750, Depreciation is £2,400 and interest paid is £300. Profit before tax is £40,950. The report’s subtotals and percentage row should not appear as additional accounts.
After importing its balance sheet, total assets are £53,970, liabilities are £14,520 and equity is £39,450, giving a £0 difference. Fixed assets are £9,000 after accumulated depreciation. Prepayments are £750 on their own line. Retained earnings are £38,450, from £7,500 brought forward plus the example profit of £40,950 less £10,000 dividends paid. Confirm the dividends paid proposal as a reduction of retained earnings for this fictional example.
The small two-column illustrations have different figures. Their profit before tax is £9,900 and balance sheet equity is £3,500. For your own filing, compare the imported totals with your prepared accounts rather than with either example.
Review the profit before tax, net assets and balance-sheet difference before applying. Then check the Financial data fields, generated accounts and tax computation. Fix the source report or mapping if the figures do not match your prepared accounts.
Import last year's figures
You can import the comparatives from the same report or from a separate last-year file. Companies House figures still prefill as usual. Imported prior-year figures replace the supplied lines without another prompt. Lines missing from the import keep their existing figures.
- For a report with both years, keep Import into set to This year. Open Columns and select Prior year amount. Ordered year or full-date headings propose the latest column for this year and the immediately preceding annual column for prior year. Check both selections. Monthly columns are never selected as prior year automatically.
- For a separate file, choose Prior year under Import into, upload last year's report and review its mappings. For a trial balance with separate prior Debit and Credit columns, use a separate prior-year file.
- Review the prior-year amounts and destination totals before selecting Use these figures. If you split an account between lines in a two-year report, enter each year's split amounts separately.
- Check the comparative column and prior period dates in Financial data, then save progress. The import keeps those dates unchanged. Prior-year figures are for the accounts comparatives and do not change this year's tax or two-return allocations.
Prior-year import controls are hidden for a first accounting period or when you have selected that there is no prior year.
Not the right guide?
Open the guide that matches your report.
Looking for a different field or step? See all filing wizard guides →
Official sources
Whether this route matches your filings is for you to decide, yourself or with your accountant.
Example companies and figures are fictional. Field names match the filing wizard as of 12 October 2026.
The import preview and resulting balance sheet show Net assets (liabilities). The caption is the same for a positive, zero or negative total.