Service Charge Budget Excel
Budget, levies, arrears & sinking fund for OMCs
- Budget in the 9 categories of the MUD Act, vs actual
- Levy per unit from the lease share or floor area
- Arrears aged 0–30 / 31–60 / 61–90 / 90+ days
One-off purchase – no subscription
Sole Trader Bookkeeping Template Excel
Income and expenditure books, bank reconciliation, VAT and Form 11 figures for Irish sole traders – with a tax estimate
€49incl. VAT
Your books kept the way the Form 11 asks for them – all year, not in a panic in October
10sheets
600expense lines
0macros
- Sales ledger with VAT, payments received, days overdue and invoice status
- Expenses ledger: VAT you can reclaim, business-use share and the Form 11 line filled in from the category
- Monthly bank reconciliation with lodgements and payments not yet cleared
- Bi-monthly VAT3 figures (T1–T4), due dates, sales by rate for the RTD and a VAT threshold monitor
- Form 11 extracts from accounts, add-backs for private use and wear and tear at 12.5% over 8 years
- Income tax, USC and PRSI Class S estimate, preliminary tax options and a tax calendar
STARTSETTINGSINCOMEEXPENSESBANK RECVATCAPITAL ALLOWANCESFORM 11 SUMMARYTAX ESTIMATEDASHBOARD
Found an error in the template? We'll fix it – or refund you.
Bookkeeping for Irish sole traders – from the first invoice to the Form 11
Record each invoice and each receipt once. The workbook sorts every cost onto its Form 11 line, works out the VAT, reconciles the bank and shows roughly what tax to set aside for 31 October.
Most sole traders don't need accounting software – they need tidy books. Invoices in one place, receipts with the VAT and the business share worked out, the bank agreeing with the books, and a clear idea of the tax bill before the accountant sends it. Instead, October arrives with a bag of receipts, a year of bank statements and a Form 11 that asks for figures nobody has added up.
This workbook keeps the income and expenditure books the Irish way. Each expense category is mapped to a line of the Form 11 'Extracts from Accounts' panel, the private share of the van, phone or home is added back automatically, and VAT-registered traders get the bi-monthly VAT3 figures. Wear and tear on tools, vans and computers, a monthly bank reconciliation and an estimate of income tax, USC and PRSI Class S – with the preliminary tax options – complete the picture.
Without a template
- Receipts in a shoebox and the bank statements to trawl through every October
- Unsure which costs count, which VAT you can reclaim and what to do with the private share
- No idea of the tax bill until it is nearly due
- The bank balance never quite matches what you think you have
With ExcelGrand
- One line per invoice or receipt, with checks for missing dates, categories and receipts
- Category rules for business use, VAT reclaim and the Form 11 line – editable in SETTINGS
- A running tax estimate and the minimum preliminary tax, with a monthly amount to set aside
- A month-by-month bank reconciliation that lists what has not cleared yet
What's in the file
START
Key figures, quick links and a step-by-step guide.
SETTINGS
Business and trade description, tax year, VAT registration and basis, VAT rates, income and expense categories mapped to the Form 11 with business use and VAT rule, and the 2026 tax figures with source and date checked.
INCOME
400 invoices and credit notes: customer, category, net, VAT, gross, date received (bank or cash), cleared date, outstanding, days overdue, status and checks.
EXPENSES
600 receipts: supplier, category, paid from, gross, VAT on the invoice, business use, VAT reclaimable, cost in the accounts, allowable part, add-back, Form 11 line and checks.
BANK REC
Twelve months: opening and closing book balance, drawings, tax paid, lodgements and payments not yet cleared, statement balance, difference – plus the uncleared items for any month.
VAT
Bi-monthly VAT3 figures (T1–T4) on the invoice or cash basis, due dates and status, sales and purchases by rate for the RTD, and a VAT registration threshold monitor.
CAPITAL ALLOWANCES
25 assets: type, cost, business use, car limits, year of claim, wear and tear this year, claimed to date and still to claim – with a check against EXPENSES.
FORM 11 SUMMARY
Extracts from accounts (lines 128–143), net profit, add-backs (160–168), adjusted net profit, capital allowances (114) and balance sheet items, against last year.
TAX ESTIMATE
Income tax, USC and PRSI Class S – year to date and projected – preliminary tax at 90% / 100% / 105%, and a tax calendar with the pay & file, ROS and VAT dates.
DASHBOARD
Turnover, adjusted profit, estimated tax and unpaid invoices, with four charts.
Take a look inside
Specifications
Format.xlsx
RequiresExcel 2016+ / Microsoft 365
Sheets10
Capacity400 invoices · 600 expenses · 35 expense categories · 25 assets · 12 months bank reconciliation
Tax figures2026 rates, bands and VAT rates – all editable
MacrosNone
Who is it for?
- Tradespeople
- Consultants & freelancers
- Home-based businesses
- Shops, salons and cafés run as sole traders
- Accountants collecting client records
Frequently asked questions
How do I do bookkeeping as a sole trader in Ireland?
Keep a record of every sale and every business payment, with the invoices and receipts behind them, and check it against your bank statements. Revenue expects full and accurate records from the start and asks you to keep them for six years. In this workbook that means one line per invoice in INCOME, one line per receipt in EXPENSES and a monthly reconciliation in BANK REC.
What expenses can a sole trader claim in Ireland?
Costs incurred wholly for the business: goods for resale, materials, wages, rent and bills for business premises, running costs of a van or machine, accountancy fees and interest on business borrowings. Only the business share of mixed costs (car, phone, home) counts, and business entertainment, your own drawings and everyday clothing do not. Equipment and vehicles are claimed through capital allowances – 12.5% a year over 8 years. The categories in SETTINGS carry these rules and you can change them.
How much tax does a sole trader pay in Ireland?
Income tax at 20% up to your standard rate band and 40% above it, less your tax credits, plus USC and PRSI Class S on your profit. For 2026 the single person's band is €44,000 and PRSI Class S is 4.2% up to 30 September and 4.35% from 1 October. The TAX ESTIMATE sheet works out an estimate for the year to date and for the projected full year.
When is preliminary tax due?
By 31 October of the tax year, together with the Form 11 and the balance for the previous year. If you file and pay through ROS the date is extended – to 18 November in 2026. To avoid interest you pay at least the lowest of 90% of this year's liability, 100% of last year's or 105% of the year before last (direct debit only). The workbook calculates all three.
Do I need to register for VAT as a sole trader?
Once your turnover passes the threshold – €42,500 for services or €85,000 for goods in the current or previous calendar year – you must register. Below that, registration is voluntary. The VAT sheet tracks your turnover against the threshold; if you are registered it gives you the T1–T4 figures for each bi-monthly VAT3 return.
Does this replace my accountant or my Form 11?
No. It keeps your records in order and shows the figures the Form 11 asks for, but it does not file anything with Revenue and it is not tax advice. Many sole traders use it to hand clean books to their accountant – or to complete the self-employed panel themselves with a clear view of each line.
Other templates you may need
Fire Safety Register Excel
Fire safety log book with due-date alerts for Irish buildings
- Weekly fire alarm test log with call point rotation
- Monthly checks of fire doors, escape routes and emergency lighting
- Service due dates for extinguishers, alarm and other equipment
Risk Assessment Template Excel
Hazard register, 5×5 risk matrix, action plan & Safety Statement checklist
- Hazard register by area with who is at risk and existing controls
- 5×5 likelihood × severity scoring with colour-coded ratings
- Action plan with owner, target date from the rating and overdue alerts
Sole Trader Bookkeeping Template Excel
Income and expenditure books, bank reconciliation, VAT and Form 11 figures for Irish sole traders – with a tax estimate · €49
Sole trader bookkeeping template in Excel for Ireland
A sole trader bookkeeping template gives you a simple income and expenditure template that matches Irish tax: invoices and receipts in one bookkeeping spreadsheet, VAT on each line and every cost sorted onto the lines of the Form 11. It is an income and expenses spreadsheet for the self-employed that also reconciles the bank month by month.
Use it as a bookkeeping spreadsheet for Ireland, a self-employed accounts template with a VAT3 summary, or a simple tax calculator for sole traders with income tax, USC, PRSI Class S and preliminary tax – in Excel, with no macros and no subscription.
Sole Trader Bookkeeping Template Excel€49