1
CT expense adjustments
Can I import my final profit and loss account and balance sheet from Excel, enter tax adjustments such as depreciation, entertaining and capital allowances, and have the software generate the CT600 and micro-entity accounts?
1 Comment
Log in to comment
**Importing from Excel**
You can import a trial balance from an Excel (.xlsx) or CSV file. Inside the CT600 form, click **Import Trial Balance** in the P&L section, upload your file, and TinyTax will auto-map the accounts to the right categories (turnover, cost of sales, staff costs, etc.). You can adjust the mapping before confirming. Both P&L and balance sheet figures are populated from the same import.
Your file needs to be structured as a trial balance (account name, debit, credit columns) rather than a formatted set of accounts — see: https://tinytax.co.uk/support/trial-balance-import
**Tax adjustments**
Once your figures are imported, the Tax Computation section has dedicated fields for:
- **Depreciation add-back** — entered in the P&L section; automatically added back in the computation (since depreciation isn't tax-deductible)
- **Disallowable expenses** — client entertaining, fines, etc.
- **Capital allowances / AIA** — deducted from taxable profit in place of depreciation
- **Other tax adjustments** — a catch-all for anything else (positive or negative)
These all feed into Box 155 (Tax-Adjusted Trading Profit) on the CT600. More detail here: https://tinytax.co.uk/support/ct600-tax-adjustment-boxes
**CT600 and micro-entity accounts**
TinyTax generates both the CT600 (for HMRC) and micro-entity accounts (for Companies House) from the figures you enter. If you choose "CT600 + Accounts" when starting the filing, both are prepared and can be submitted together. The accounts filed at Companies House are filleted micro-entity accounts (balance sheet only — no P&L is made public).
Since you already have PS:PLANET LIMITED on your dashboard, you can start a filing for it and try the import to see how it looks — you only pay when you're ready to submit.