Quick Reference: Automating Corporate Income Tax Returns in Kenya
What is corporate income tax returns automation?
Corporate income tax returns automation is the process of using technology to auto-populate Kenya’s IT2C income tax return, a macros-enabled Excel spreadsheet, directly from trial balance data, eliminating the manual line-by-line entry that typically takes accountants 1–3 hours per return.
What tools are used?
The automation stack consists of Microsoft 365 (where the IT2C Excel sheet lives), Airtable (as the database for storing filings, trial balance lines, and bucket key mappings), N8N (as the automation layer connecting Airtable to Excel via webhooks), and a local Python runner that executes the final IT2C population.
How does it work?
The process has three steps:
- Upload a trial balance through a form into Airtable, where an automation maps each line item into individual records
- Assign bucket keys to each line item – a bucket key maps a trial balance figure to a specific cell in the IT2C sheet.
- Change the filing status to “approved for filing,” which triggers an automation that retrieves the mapped data, groups it by bucket key, prepares a JSON payload, writes it to disk, and executes a script that fills in the IT2C.
Who is this for?
Accounting firms, tax consultants, and businesses in Kenya that file company income tax returns using the IT2C format.
Why does this matter now?
KRA announced in November 2025 that they will start validating income and expenses for company returns, making accuracy in tax filing more critical than ever.
Frequently Asked Questions
Can the IT2C Excel sheet be auto-populated without coding?
The core workflow uses no-code tools (Airtable forms, N8N visual automation), but the system includes JavaScript within N8N nodes and a Python runner for the final Excel population step.
What is a bucket key in IT2C automation?
A bucket key is a mapping identifier that connects a trial balance line item to a specific cell in the IT2C income tax return. It tells the automation system where each figure belongs in the return.
Can AI assign bucket keys automatically?
Not yet in this version. Bucket key assignment is currently manual, but AI-assisted suggestions based on account names and prior filings are planned for a future version.
The Full Story
If you’ve ever filed a company income tax return in Kenya, you know the IT2C. It’s the macros-enabled Excel sheet that every accountant dreads. You take numbers from an audited trial balance, and you manually enter them, line by line, cell by cell, into this guided spreadsheet. It can take anywhere from one to three hours per return. Multiply that across dozens of clients during filing season, and you start to understand why accountants are exhausted by June.
I’ve run the finance function for my company, The Digital Monkeys, for nine years. I’ve been on both sides of this — as the business owner submitting records late, and as the person watching the returns get filed. After KRA announced in November 2025 that they’d start validating income and expenses for company returns, I started thinking seriously about whether technology could remove some of the friction.
The short answer is yes. I built a working automation that takes a trial balance, processes it through a pipeline, and auto-populates the IT2C. Here’s how it works and what I learned building it.
The Problem Worth Solving
Three problems converge around IT2C filing. First, it’s repetitive. The work of entering numbers into the return is almost entirely manual transcription from data that already exists in your trial balance. Second, clients are last-minute. If your accounting year ends in December, you have until June to file — but most businesses push everything to May, creating a compressed workload. Third, accuracy matters enormously. A misplaced zero on a tax return isn’t a formatting issue; it changes how much tax you pay and can trigger compliance problems.
The Tech Stack
I deliberately chose tools that don’t require deep coding experience. Microsoft 365 is the base because the IT2C lives in Excel. Airtable serves as the database layer; it’s essentially a spreadsheet with the power of a relational database, which gives you far more control over how data is structured and linked. N8N handles the automation, it’s the orchestration layer that connects Airtable to Excel through webhooks, scripts, and API calls. Finally, a local Python runner executes the final step of writing data into the IT2C sheet.
How the Workflow Operates
The process has three steps. Step one: you upload a trial balance through a simple form that feeds into Airtable. An automation triggers and maps each line item from the trial balance into individual records. Step two: you manually assign bucket keys to each line item. A bucket key is essentially an address — it tells the system which cell in the IT2C a particular figure belongs to. This is currently the manual step, though it’s where AI will eventually come in. Step three: you change the filing status to ‘approved for filing.’ This triggers a second automation that retrieves the mapped data, groups it by bucket key, prepares a JSON payload, writes it to disk, and executes a script that opens Excel and fills in the IT2C.
Where AI Fits In
The bucket key assignment is the most obvious place for AI integration. Right now, someone with accounting knowledge has to look at each trial balance line and decide which IT2C cell it maps to. An AI layer could suggest these mappings based on account names, prior filings, and the universal tax brackets table. Expense validation, matching expenses to supporting documents like invoices and withholding tax certificates, is another area where AI could add significant value, especially with KRA’s new validation requirements.
What This Means for Accounting Firms
This is still a minimum viable product. The bucket key library isn’t comprehensive yet, and the system handles P&L items but not the full IT2C. But even in its current state, it demonstrates that the core workflow, trial balance to IT2C, can be automated with accessible tools. For accounting firms handling dozens or hundreds of returns, the time savings compound quickly. For businesses, it means less back-and-forth with your accountant and fewer errors in your filing.
Watch the Full Walkthrough
I’ve documented the entire build process in a detailed video walkthrough that covers every node, every connection, and every step of the Airtable and N8N setup. Watch the full walkthrough here: https://youtu.be/L739rBjQpvY?si=s7ckqlEc6HhqDDBR
