📊 Data Analysis👥 HR🧾 Accounting📄 PDF & Office🏪 Business🗓️ Time🧰 EverydayAll tools

Help & FAQ

Search every question in one place, or browse by tool.

⭐ About AllOfficeTools

Is AllOfficeTools free?

Yes. Every tool can be used free online. PDF and office tools, the Order List Filler, Handover Workbook, To-Do List and Guest Counter also have free downloads. Other downloads (spreadsheets, HR, finance and data reports) come with Pro.

What does Pro include?

Pro is £4.99 a month: downloads from every tool, no adverts, unlimited Business Manager items and no "Created with AllOfficeTools" line on invoices and quotes. Cancel any time. See Pricing.

Are my files uploaded?

No. The tools run inside your web browser, so your files and data stay on your own device. Nothing is sent to our server.

Where is my saved work kept?

Lists, designs and business records are saved in your browser on this device. Clearing your browser data removes them, so use the Backup buttons where available.

Can I cancel Pro or get a refund?

You can cancel any time from Manage subscription and keep Pro until the end of the month you paid for. Payments are not refunded, as set out in our Terms.

Does it work on my phone?

Yes. Every tool works on phones and tablets. You can also install AllOfficeTools as an app from the menu.

Is the tax and HR information up to date?

We use the current UK tax year rates and GOV.UK rules, and we update them each April. Results are estimates, not financial or legal advice.

How do I contact you?

Email info@allofficetools.com.

📊 Data analysis & spreadsheet tools

📈 Chart Maker

How do I get data from Excel into the chart maker?

Select your cells in Excel, including the header row, copy them, then paste into the box. You can also upload the file directly.

Can I use the chart in a presentation?

Yes. Download a high-resolution PNG, or click "PowerPoint slide" to get a .pptx with the chart ready to present.

Which chart type should I use?

Use a line or area chart for trends over time, column or bar for comparing categories, and pie or doughnut for parts of a whole (ideally six slices or fewer).

🔁 CSV ↔ Excel Converter

Is it safe to convert confidential spreadsheets?

Yes. Conversion happens inside your browser and your file is never uploaded to a server.

Will my dates and £ amounts survive?

UK dates written as dd/mm/yyyy are kept as real dates, and numbers become proper Excel numbers. Values with leading zeros, like phone numbers, are kept as text.

Can I convert a workbook with several sheets to CSV?

CSV holds one sheet, so choose the sheet you want. Excel and ODS output keep every sheet.

Why do accents look wrong when I open a CSV in Excel?

Our CSV files include a UTF-8 marker so Excel shows £, é and other characters correctly.

🅰️ ABC & Pareto Analysis

How are the class boundaries decided?

Items are sorted from highest to lowest value. An item is in A if the items ranked above it make up less than 80% of the total, so the item that crosses the 80% line is still counted in A. Change the 80% and 95% limits to suit your business.

Can I analyse customers instead of products?

Yes. Choose the customer column as the item and the sales amount as the value.

⚖️ A/B Test Calculator

What does "significant at 95%" mean?

If there were really no difference between A and B, a result this large would happen less than 5% of the time. It is strong evidence the change made a difference.

Can I stop the test as soon as it is significant?

It is better not to. Decide the sample size first (use the Sample size tab) and run for whole weeks, otherwise you are more likely to pick a false winner.

What is statistical power?

The chance the test will detect a real difference of the size you chose. 80% is the usual standard.

🛡️ Data Anonymiser

Does the same person get the same code everywhere?

Yes. With "Same value gets the same code in every column" ticked, an email address or name always becomes the same code, so your analysis still works.

What is the secret key for hashing?

Hashes are mixed with your secret key, so nobody can reverse them by hashing a list of common names. Use the same key to get the same hashes in another file.

Is my file uploaded?

No. Everything happens inside your browser.

🐘 Large CSV Viewer

How big a file can it open?

Files of several gigabytes can be indexed. Only the rows on screen are loaded, so it works within your device memory. Indexing takes a few seconds per hundred megabytes.

Is my file uploaded?

No. Everything happens inside your browser and nothing is sent to our servers.

Why does Excel cut my file off?

An Excel sheet holds at most 1,048,576 rows. Use this viewer to filter or split the file into pieces Excel can open.

🧽 Data Cleaner

Will it change my original file?

No. You download a new, cleaned copy. Your original file is never changed or uploaded.

Why are some numbers not converted?

Values with leading zeros, like product codes 00123 or phone numbers, are kept as text on purpose so the zeros are not lost.

📊 Cohort Retention Analysis

Why is period 0 always 100%?

Period 0 is the period each customer first bought in, so everyone in the cohort is active then.

Why are the bottom-right cells empty?

Newer cohorts have not existed long enough to have later periods yet.

Is my data uploaded?

No. All calculations happen in your browser.

🆚 Compare Two Excel Files

Do the rows need to be in the same order?

No. Pick a column with a unique value per row (like an ID or email) and rows are matched however they are sorted. Without one, rows are compared by position.

Are 10 and 10.00 treated as different?

No. Numbers are compared by value, and dates by date, so formatting differences are ignored.

📅 Date Table Generator

Are the bank holidays correct?

They follow the GOV.UK rules, including substitute days when a holiday falls at a weekend, the moved May holidays (2020 VE Day, 2022 Platinum Jubilee) and one-off holidays such as the 2023 Coronation and Scotland's 2026 World Cup bank holiday. Future one-off holidays are added when they are announced.

How do I use it in Power BI?

Copy the DAX code, choose Modelling → New table, paste it and press Enter. Then mark it as a date table and connect its Date column to the date column in your data.

What is the difference between financial year and tax year?

Most UK companies use a financial year from 1 April. The UK personal tax year runs from 6 April to 5 April. The table includes both.

🧠 DAX Measure Generator

Why does my YTD measure show the same as the total?

Time intelligence needs a separate date table that is marked as a date table and joined to your data. Use the date column from the date table in your visuals, not the date column from your sales table.

Do these work in Excel Power Pivot too?

Yes. The same DAX works in Excel Power Pivot (Power Pivot → Measures → New Measure) and in Analysis Services.

Why use DIVIDE instead of the / sign?

DIVIDE returns blank instead of an error when dividing by zero, so your visuals do not show errors.

🗄️ Excel to SQL

Is my data uploaded?

No. The file is read and converted in your browser, and the test database also runs on your device.

How big a file can I convert?

Tens of thousands of rows work well. Very large files create very large SQL files; for those, your database's own import tool may be faster.

Why does SQL Server use N'text'?

The N prefix keeps accents and symbols (like é or £) correct in NVARCHAR columns.

📇 Extract Emails, Phones & Postcodes

Does it upload my text?

No. Extraction runs entirely in your browser.

Why was a number not picked up as a phone number?

Only valid UK numbers are listed: 10 or 11 digits starting 01, 02, 03, 07 or 08 (or +44). Numbers that are too long or short, such as order references, are ignored on purpose.

Can it read PDFs and Word files?

Yes, text-based PDFs and .docx Word files. Scanned PDFs need OCR first.

🔮 Forecast & Regression

Which forecasting method should I choose?

Leave it on automatic. It compares the methods using AIC, which rewards a good fit but penalises unnecessary complexity. Seasonality needs at least two full years of monthly data.

What does a p-value below 0.05 mean?

That the link between the driver and the target is unlikely to be just chance in this data. It does not prove one causes the other.

Is my data uploaded?

No. All calculations run inside your browser.

🧩 Excel Formula Builder

Why does my formula show #NAME?

Your Excel version does not have that function (for example XLOOKUP or IFS in Excel 2016). Use the "All versions" formula shown underneath instead.

Do these work in Google Sheets?

Most do, including XLOOKUP, SUMIFS, IFS, TEXTJOIN, UNIQUE and FILTER. TEXTBEFORE/TEXTAFTER are Excel 365 only.

Why are there $ signs in some ranges?

The $ locks the range so it does not move when you copy the formula down to other rows.

🔗 Fuzzy Match (Fuzzy VLOOKUP)

What score should I use?

80% is a good starting point. Use 90% or more when wrong matches are costly, for example payments. Always check "Possible match" rows by eye.

How many names can it handle?

Tens of thousands. It narrows each name down to likely candidates first, so it stays quick.

Is my data uploaded?

No. Matching runs inside your browser and nothing is sent to our servers.

🔣 JSON ↔ Excel Converter

Is my data uploaded?

No. Conversion happens in your browser.

How are nested lists handled?

Choose "join" to list them in one cell, "separate sheets" to give each list its own sheet linked by row number, or keep them as JSON text.

🔗 VLOOKUP / Merge Two Sheets

Can I use two sheets from the same file?

Yes. Drop the same file in both boxes and pick a different sheet for each.

What if a value appears twice in the lookup file?

The first match is used, exactly like VLOOKUP, and the tool tells you how many duplicates it found.

🎯 Outlier Finder

Should I delete outliers?

Not automatically. Check them first: many are mistakes, but some are real and important, like a record sales day. You can download the file with outliers flagged, or with them removed.

Which method should I use?

Start with Standard. Use Robust if your data has several big errors, and Z-score for measurements that are roughly bell-shaped.

🧊 Pivot Table Builder

Is my data uploaded?

No. The pivot table is calculated in your browser.

Why are some values blank?

A blank cell means there were no rows for that combination, for example no sales in London in March.

📍 UK Postcode Lookup (Bulk)

Is my file uploaded?

No. Only the postcodes themselves are sent to postcodes.io to look them up. Names, emails and everything else in your file stay on your device.

Why are some postcodes not found?

They may be mistyped, very new, or retired. These rows are marked in the "Postcode check" column.

How many postcodes can I look up?

Thousands at a time. They are looked up in batches of 100.

⚙️ Power Query Snippets

Where do I paste this?

In Excel: Data → Get Data → Launch Power Query Editor. In Power BI: Home → Transform data. Then Home → Advanced Editor. Paste the steps before the word "in", add a comma after the previous step and update the name after "in".

Why does my date column show errors?

Text dates like 03/04/2026 are read using your computer's language. Use the "Fix UK dates" snippet, which tells Power Query to read them as day/month/year.

What is the "previous step name"?

Each Power Query step uses the result of the step before it. Type the name of the step you want to build on, as it appears in the Applied Steps list.

🔄 Unpivot / Reshape Data

What is unpivoting?

Turning columns into rows. A table with one column per month becomes one row per product per month, which is much easier to filter, chart and total.

Are month headings like "Jan 2026" kept as dates?

Yes, if every heading looks like a date, they become real dates so you can sort and group them.

👑 RFM Customer Segmentation

What does an RFM score like 545 mean?

Recency 5 (bought very recently), Frequency 4 (buys often) and Monetary 5 (spends the most). 555 is the best possible score.

What is the analysis date?

The date recency is measured from. It defaults to the day after the latest order in your file, so old exports still give sensible results.

Should I use the order number column?

Yes if your file has one row per product. Frequency then counts orders, not product lines.

🎲 Random Sample Picker

Is it really random?

Yes. When you leave the seed empty, a random seed is taken from your device's secure random number generator, and every row has an equal chance.

Can the same row be picked twice?

No. Each row can only be picked once.

✂️ Split Excel by Column

Does it keep my column headers?

Yes. Every part keeps the header row, and you can choose whether to keep the column you split by.

What happens to empty cells in the split column?

Rows with an empty value are grouped together in a part called (blank), so no rows are lost. The summary shows the counts add up to the total.

Is my data uploaded?

No. The file is split inside your browser and nothing is sent to our servers.

🧮 SQL Query Builder

Is my data uploaded?

No. Your file is loaded into a SQL database that runs inside your browser. Nothing is sent to a server.

Which SQL does "Run" use?

Results are calculated with SQLite in your browser. The SQL shown for MySQL, SQL Server and PostgreSQL uses the right syntax for each, so you can paste it into your own database.

What are the column names in the SQL?

Column names are tidied into database-friendly names: "Order Date" becomes order_date.

✨ SQL Formatter

Is my SQL sent anywhere?

No. Formatting happens in your browser.

Can it fix errors in my SQL?

It formats SQL but does not change or correct it. A missing comma or bracket will still be missing, just easier to spot.

🗄️ SQL Playground

Is my data uploaded?

No. The database runs inside your browser using SQLite compiled to WebAssembly. Nothing is sent to our servers.

Which SQL does it use?

SQLite, which supports standard SELECT queries, joins, GROUP BY, subqueries, CTEs (WITH) and window functions such as ROW_NUMBER() and SUM() OVER().

How big can the files be?

Hundreds of thousands of rows work well on most computers. Very large files depend on your device memory.

📐 Statistics Calculator

What does "statistically significant" mean?

A p-value below 0.05 means a result this strong would happen less than 5% of the time by pure chance, so it is probably a real effect. It does not tell you the effect is large or important. Check the effect size too.

Which t-test should I use?

Use "Two columns" or "Values + group column" for two separate groups (like men vs women), and "Paired" when the same people are measured twice (like before and after training).

Do results match Excel?

Yes. Standard deviation, quartiles, skewness and kurtosis use the same formulas as Excel, and t-test p-values match Excel's T.TEST.

🧪 Test Data Generator

Is any of this real?

No. Every value is randomly generated. Names, addresses and postcodes are combined at random, so a postcode or name may happen to look real, but it is not linked to any real person.

How do I get the same data again?

Enter the seed number shown after generating, and you will get exactly the same rows.

🌐 Web Table to Excel

Why not just enter a web address?

Browsers block one website from reading another for security, so the safest way that works on every site is to copy the table and paste it here. Nothing you paste is uploaded.

It found several tables. Which is mine?

Each table shows its size and first headings. Click through them, or download all of them at once, one sheet each.

📈 Instant Dashboard

Is this really like Power BI?

It gives you the same kind of interactive dashboard (KPI cards, slicers, cross-filtering, trend, matrix and top-N visuals) but builds it automatically. For complex data models with many related tables, Power BI is still the better tool.

Is my data uploaded anywhere?

No. The file is read and analysed entirely in your browser. Nothing is sent to our server.

How big can my file be?

Files with up to about 200,000 rows work well on a normal laptop. Very large files may be slow on phones.

How is the forecast worked out?

It fits a trend line to your most recent periods and, if you have at least two years of monthly data, adjusts for seasonality. Treat it as a guide, not a guarantee.

Can I edit the charts in PowerPoint?

Yes. With Pro, the PowerPoint export uses real PowerPoint charts, so you can change colours, labels and data inside PowerPoint.

🧹 Duplicate Row Remover

How do I find duplicates in only one column, like email?

Untick every column except the one you care about (for example Email). Rows sharing that value are treated as duplicates even if other columns differ.

Does "ignore case" matter?

With it on, "John@Mail.com" and "john@mail.com" count as the same. Turn it off for an exact, case-sensitive match.

Is my original file changed?

No. Your original stays as it is. You download a new, cleaned copy.

🧩 Excel File Merger

What if my files have different columns?

Columns with the same header name are lined up automatically. Any extra columns are added on the end, and rows without them are left blank.

Can I merge CSV and Excel files together?

Yes. You can mix .csv, .xlsx, .xls and .ods files in one merge.

Is there a file limit?

There is no fixed limit. Merging happens in your browser, so very large merges depend on your device memory.

🏪 Business manager (stock, orders, money)

🏨 Guest Counter for Hotels

Which hotel systems does it work with?

Any system that can print or export an in-house, arrivals or rooming list as PDF, Excel or CSV, including HotelKey, Opera, Mews, Guestline and others. If a column is guessed wrong, you can change it before you start.

Can two people count on different devices?

Each device keeps its own count. For one shared count, use one tablet at the restaurant entrance.

What if only some guests have breakfast included?

Before starting, open "Only count some rows" and choose the rate or package column, then type the text that means breakfast is included, such as BB.

Is guest data stored?

Only in this browser on this device, and it is deleted automatically 36 hours after loading. Nothing is uploaded to a server. You can also delete it at any time.

📋 Shift Handover Workbook Builder

Can I change the design after downloading?

Yes. It is a normal Excel file, so you can type, add rows, change colours or add tabs in Excel or Google Sheets.

How do I make next month's workbook?

Your design is saved in this browser. Come back, change the month and download again. Every tab is renamed and dated for you.

Does it skip weekends?

If you want. Choose "Monday to Friday" or "Weekends only" under Days.

Is it free?

Yes. Designing and downloading the workbook are free, with no account needed.

Is my data uploaded?

No. The workbook is built inside your browser and nothing is sent to a server.

🛒 Order List Filler

What kind of file can I upload?

A PDF, Word (.docx), Excel or CSV file, or a plain text list. Order forms, supplier price lists, stock-take sheets, menus and shopping lists all work. Each line becomes an item with an empty quantity box. Numbering like "1." or bullets are removed automatically.

How do I fill it in quickly?

Type part of the item name in the search box, for example "redbull", press Enter, type the number and press Enter again. You go straight back to the search box for the next item. Even faster: type "redbull 24" and press Enter to set Red Bull to 24 in one go.

Is my list saved?

Yes. Your list saves automatically in this browser on this device while you type. Open it again any time from the "Your saved lists" section on this page. Nothing is uploaded to us.

Can I print it or send it to my supplier?

Yes, for free. Print it, or download it as PDF, Excel, Word, or your original PDF with the numbers written in. You can fill in and save as many lists as you like.

My PDF shows no items. Why?

Scanned PDFs are pictures of text, so there is nothing to read. Use the Paste or type a list button and type the items, or upload the original Word or Excel file instead.

💷 Money: Income, Expenses & VAT

Is my financial data uploaded?

No. It is saved only in this browser on this device. Download backups in Settings.

Can it file my VAT return or Self Assessment?

No. It helps you keep records and see the numbers. Filing must be done through HMRC or MTD-compatible software.

How do I record VAT on an expense?

Enter the total you paid and pick the VAT rate. The VAT part is worked out for you, or choose "Custom VAT amount" to type it from the receipt.

🧾 Orders, Invoices & Customers

Where are my orders and customers saved?

Only in this browser on this device. Nothing is uploaded. Download a backup in Settings regularly.

Can I send the invoice by email?

Download the PDF and attach it to your email as normal.

What does Pro add?

You can manage up to 100 orders and 100 customers at no cost. Downloading invoice PDFs and Excel exports needs Pro, which also removes the limits and the small AllOfficeTools line on invoices. Backups are always.

📊 Business Reports

Where does the report data come from?

From the products, orders and money entries saved in this browser. Nothing is uploaded.

How is gross profit worked out?

Sales before VAT minus the cost price of the products sold, using the cost recorded on each product when the order was created.

⚙️ Settings & Backup

Is my business data private?

Yes. It never leaves your device. It is stored in your browser's own database (IndexedDB).

What happens if I clear my browser history?

If you clear "site data" or "cookies and other site data", your business records are deleted too. Keep a recent backup file.

Can I use it on my phone and laptop?

Each device keeps its own data. Move data between them with Download backup and Restore from backup.

📦 Stock & Inventory Manager

Where is my stock data saved?

In your web browser on this device, using its built-in database. It is not sent to us or anyone else. Clearing your browser data or using a different device will not show it, so download backups regularly.

Can I import my existing stock list?

Yes. Click Import from Excel and choose your spreadsheet. Columns like SKU, Product, Quantity, Cost and Price are recognised automatically. Products with a matching SKU are updated.

Is there a limit?

The version holds up to 100 products. Pro removes the limit.

💷 Money & business calculators

🍛 Restaurant Food Cost Calculator

Why does the suggested price include VAT?

Eat-in meals and hot takeaway food in the UK carry 20% VAT, so what the customer pays must cover VAT on top of your target price. Choose 0% for zero-rated cold takeaway items.

Where are my saved recipes stored?

In your own browser on this device. Nothing is uploaded. Download the Excel costing sheet to keep a permanent copy.

How often should I re-cost my menu?

At least every quarter, and whenever a supplier changes prices. Small rises in meat, oil or rice prices can quietly wipe out your margin.

💷 Profit Margin Calculator

What is a good profit margin?

It depends on the industry. Restaurants usually aim for a 65–75% gross margin on food (a 25–35% food cost). Retail often runs at 25–60%.

Should I include VAT when calculating margin?

No. Remove VAT first, because it belongs to HMRC, not you. Tick "Selling price includes VAT" and the calculator does this for you.

How do I set a price for a target margin?

Price = cost ÷ (1 − margin). For a 70% margin on a £3 cost: £3 ÷ 0.30 = £10.

💷 Take-Home Pay / Salary Calculator

How much tax do I pay on £30,000 in the UK?

For an employee in England with no pension contribution, it is about £3,486 income tax and £1,394 National Insurance, leaving roughly £25,120 take-home (£2,093 a month). Enter your own figures above for an exact estimate.

Does a pension reduce my tax?

Yes. Pension contributions get tax relief, and through salary sacrifice they also cut your National Insurance. Enter a percentage above to see the effect.

Why is my payslip slightly different?

Payroll works out tax and NI each pay period using your tax code. Bonuses, overtime, student loans and benefits in kind can all make your payslip differ from this annual estimate.

🧾 UK VAT Calculator

Do restaurants charge 20% VAT?

Yes. Eat-in food and hot takeaway food are standard-rated at 20%. Most cold takeaway food (for example a cold sandwich) is zero-rated, but cold soft drinks, alcohol and confectionery are standard-rated.

What is the VAT registration threshold?

You must register for VAT when your VAT-taxable turnover goes over £90,000 in a rolling 12-month period. Check GOV.UK for the current figure.

How do I work out VAT from a total?

Use "Remove VAT" mode. At 20%, the VAT is the total ÷ 6.

👥 HR & payroll tools

📐 Bradford Factor Calculator

What is the Bradford Factor?

A score that weights frequent short absences more heavily than one long absence: S² × D, where S is the number of spells and D is total days. Ten one-day absences score 1,000, but one ten-day absence scores just 10.

Is the Bradford Factor fair?

It is a prompt for a conversation, not an automatic decision. Exclude absences linked to disability or pregnancy to avoid discrimination.

🧮 True Cost of an Employee

Can I claim Employment Allowance?

Most employers can, including small businesses and charities. Companies whose only employee is a director paid above the secondary threshold can't. It applies to the company's total NI bill, not per employee.

How much more than salary does an employee cost?

Typically 15% to 30% more once employer NI, pension and overheads are included.

📉 Staff Turnover & Absence Dashboard

Is my staff data uploaded?

No. Everything is calculated in your browser, and the file never leaves your computer. This matters for personal data under UK GDPR.

What columns do I need?

Staff sheet: Name, Department, Start date, Leave date (blank for current staff). Absence sheet: Name, Date, Days, Reason. Download the template to see the format.

⚖️ Gender Pay Gap Calculator

Is gender pay gap the same as equal pay?

No. Equal pay is about paying men and women the same for the same work, which is a legal requirement. The pay gap compares average pay across the whole organisation.

Is my data private?

Yes. The calculation runs entirely in your browser, and no pay data is uploaded.

🏖️ Holiday Entitlement Calculator

Do bank holidays count towards holiday entitlement?

They can. The 5.6 weeks can include bank holidays, but your contract may give them on top. Check your employment contract.

What happens to unused holiday when I leave?

You must be paid for statutory holiday you've built up but not taken. Tick the part-year box and enter your leaving date and daily pay.

Can my employer refuse a holiday request?

Yes, with notice that is at least as long as the holiday requested. They must still let you take your full entitlement during the year.

✉️ HR Letter Templates

Are these HR letters legally binding?

They are practical starting templates in plain English. For complex cases such as dismissals or redundancies, follow the ACAS Code of Practice and take professional advice.

Do I need to give a written contract on day one?

Yes. Employees and workers must receive a written statement of employment particulars on or before their first day of work.

What should a reference include?

Many employers give factual references only (dates, job title). Anything you include must be true, accurate and fair.

✅ Minimum Wage Checker

Does salary count for the minimum wage?

Yes. Divide total pay by the hours actually worked, including any unpaid overtime, to get the effective hourly rate.

Do tips count towards the minimum wage?

No. Tips, gratuities and service charges cannot be used to top pay up to the minimum wage.

📅 Notice Period Calculator

When does a notice period start?

Usually the day after notice is given, unless the contract says otherwise.

What is pay in lieu of notice (PILON)?

The employer pays the notice period instead of having you work it. It is taxed as normal pay.

Do I get paid during my notice period?

Yes, at your normal rate. You also keep building up holiday during notice.

🧭 Onboarding Checklist

What must UK employers do before a new starter begins?

Check their right to work in the UK before employment starts. On or before day one, give them a written statement of employment particulars.

When do I need to enrol a new starter into a pension?

Assess them on day one. Eligible workers (aged 22+ earning over £10,000 a year) must be enrolled, and sent a letter about it, within 6 weeks of their start date.

🌙 Overtime & Shift Pay Calculator

Is overtime pay a legal right in the UK?

No. There is no legal right to extra pay for overtime. It depends on your contract. However, your average pay for all hours worked must not fall below the minimum wage.

Does overtime count towards holiday pay?

Regular overtime usually has to be included in holiday pay for the first 4 weeks of statutory leave.

What is time and a half?

Your normal hourly rate × 1.5. At £12.71 an hour, that is £19.07 an hour.

👶 Maternity & Paternity Pay Calculator

Is maternity pay taxed?

Yes. Statutory Maternity Pay is paid through payroll, with income tax and National Insurance deducted like normal pay.

Can my employer pay more than SMP?

Yes. Many employers offer enhanced (contractual) maternity pay, such as full pay for a set number of weeks. It can never be less than the statutory amount.

Is paternity leave a day-one right?

From April 2026, paternity leave is a day-one right. Statutory Paternity Pay still requires 26 weeks of service and earnings above the lower earnings limit.

👥 Team Payroll Cost Calculator

How is employer NI worked out per employee?

15% of each employee’s annual pay above £5,000 (the secondary threshold). The Employment Allowance then reduces the company’s total bill by up to £10,500.

Who must be auto-enrolled into a pension?

Workers aged 22 to State Pension age earning over £10,000 a year. Employers pay at least 3% of qualifying earnings.

🧾 Payslip Generator

Do employers have to give payslips?

Yes. All employees and workers must get an itemised payslip on or before payday, showing gross pay, deductions and net pay. For hourly-paid staff, it must also show hours worked.

Why might tax differ from my payroll software?

Payroll uses cumulative tax across the year, so earlier pay periods affect each payslip. This tool estimates each period on its own, which matches when pay is steady or the tax code is on a Month 1 / Week 1 basis.

⏱️ Pro-Rata Salary Calculator

How do I calculate a pro-rata salary?

Divide your hours by the full-time hours and multiply by the full-time salary. For example, 22.5 ÷ 37.5 × £32,000 = £19,200.

Is holiday pro-rata too?

Yes. Part-time workers get 5.6 weeks of their working pattern. Use our holiday entitlement calculator.

What is FTE?

Full-time equivalent: your hours as a fraction of full time. 0.6 FTE means 60% of full-time hours.

📦 Redundancy Pay Calculator

Is redundancy pay taxed?

Statutory redundancy pay, and the first £30,000 of a total redundancy package, is normally tax-free. Pay in lieu of notice and holiday pay are taxed as normal earnings.

Can my employer pay more than statutory redundancy?

Yes. Many employers have enhanced schemes. Check your contract or staff handbook.

What if I have less than 2 years of service?

You're not entitled to statutory redundancy pay, but you're still due your notice pay and any unused holiday.

🗓️ Staff Rota & Wage Planner

Do staff get a legal break?

Workers aged 18+ are entitled to a 20-minute uninterrupted break if they work more than 6 hours a day. Many employers give 30 minutes unpaid. Set the break length above.

Why include holiday accrual?

Hourly and shift staff build up paid holiday as they work, at 12.07% of hours for irregular-hours workers. Including it shows the true weekly cost.

📏 Salary Benchmarking Tool

How do I set fair pay bands?

Use the lower and upper quartiles of each role as a starting band. Check outliers for a reason (experience, performance, market pressure) and compare against external salary surveys.

Is my salary data uploaded?

No. Analysis runs in your browser, so the file never leaves your device.

📝 Interview Scorecard

Why use a scorecard?

Scoring every candidate against the same weighted criteria makes hiring fairer and easier to justify, and reduces bias from first impressions.

Where are saved candidates stored?

Only in your own browser on this device. Nothing is uploaded.

🤒 Statutory Sick Pay Calculator

Is SSP paid from the first day off sick?

Yes. Since 6 April 2026, SSP is paid from the first qualifying day of sickness. The old 3 waiting days no longer apply.

Do low earners get SSP now?

Yes. The lower earnings limit was removed, so everyone qualifies. Lower earners get 80% of their average weekly earnings if that is less than £123.25.

Does SSP get taxed?

Yes. SSP is paid through payroll like normal wages, with tax and National Insurance deducted where due.

🧾 Tax & accounting tools

📆 UK Tax Deadline Calendar

What if a deadline falls on a weekend?

HMRC usually expects payment to arrive by the last working day before. Some electronic payments can clear on the deadline itself, so check GOV.UK for the exact rule for each tax.

Can I add these to Google or Outlook?

Yes. Click "Add to my calendar" and import the .ics file. Each deadline includes a reminder 7 days before.

🏠 Capital Gains Tax Calculator

Do I pay CGT when I sell my home?

Usually not. Private Residence Relief covers your main home, though it may be restricted if you let it out or used part of it for business.

Can I offset losses?

Yes. Losses in the same year reduce your gains, and you can carry reported losses forward to future years.

🏢 Corporation Tax Calculator

When is Corporation Tax due?

For most small companies, payment is due 9 months and 1 day after the accounting period ends. The CT600 return is due 12 months after.

What counts as an associated company?

Companies under common control, for example two companies owned by the same person. Dormant companies and passive holding companies are usually excluded.

💰 Dividend Tax Calculator

How do I pay dividend tax?

Through Self Assessment if your dividends exceed £10,000. Below that, you can ask HMRC to collect it through your tax code.

Do dividends in an ISA get taxed?

No. Dividends inside an ISA or pension are tax-free and do not use your allowance.

🧑‍💻 IR35 Contractor Calculator

What is IR35?

Rules that make contractors pay employment-level tax if they work like an employee. Medium and large clients decide the status. Small clients leave it to the contractor’s company.

Why is inside IR35 take-home lower?

Inside IR35, employer NI and the apprenticeship levy usually come out of the contract rate, and all pay is taxed as salary, with no dividend savings.

🚗 Mileage Allowance Calculator

What is the HMRC mileage rate for 2026/27?

55p per mile for the first 10,000 business miles in a car or van, then 25p. The rate went up from 45p with effect from 6 April 2026, the first rise since 2011.

My employer still pays 45p. What can I do?

Claim Mileage Allowance Relief on the difference from HMRC, using form P87 or your Self Assessment return.

💻 Making Tax Digital Checker

Do limited companies need MTD for Income Tax?

No. MTD for Income Tax covers sole traders and individual landlords. Companies use MTD for VAT if VAT-registered, and Corporation Tax is separate.

Does employment income count towards the threshold?

No. Only gross self-employment and property income count.

📑 Self Assessment Tax Estimator

What are payments on account?

Advance payments towards next year’s bill: two instalments, each half of this year’s bill, due 31 January and 31 July. They are not needed if your bill is £1,000 or less, or if more than 80% of your tax is already taken through PAYE.

Do I still pay Class 2 NI?

No. Since April 2024, self-employed people with profits above the small profits threshold get NI credits without paying Class 2. You can still pay voluntarily if your profits are low.

What is the trading allowance?

You can deduct a flat £1,000 instead of your actual expenses. It is useful if your expenses are small, and income under £1,000 does not need declaring.

⚖️ Salary vs Dividends Optimiser

Why did dividend tax go up?

From 6 April 2026, the basic and higher dividend rates rose by 2 percentage points to 10.75% and 35.75%. The additional rate stays at 39.35%.

Should I take a salary of £12,570?

It uses your personal allowance on salary. Without the Employment Allowance, though, the employer NI above £5,000 often makes a lower salary slightly better. Compare both in the table.

🧾 VAT Return & Flat Rate Checker

When is my VAT return due?

1 month and 7 days after the end of the VAT period, submitted through Making Tax Digital compatible software.

Is the Flat Rate Scheme worth it?

It can be for service businesses with few VAT-able costs. If you buy lots of standard-rated goods, or you’re a limited cost trader at 16.5%, standard VAT is often cheaper.

📈 Finance & analysis tools

⏳ Aged Debtors Report

Can I charge interest on late invoices?

Yes. Under the Late Payment of Commercial Debts Act, businesses can claim statutory interest at 8% above the Bank of England base rate, plus fixed compensation, on overdue business invoices.

What does 90+ days mean for my accounts?

Debts that are very overdue may need a bad-debt provision or write-off. Speak to your accountant about the right approach.

🔗 Bank Reconciliation Tool

How are transactions matched?

By exact amount, with dates within the tolerance you set (5 days by default). Each bank line is matched to the closest cash book line with the same amount.

Is my bank data uploaded?

No. Matching happens entirely in your browser, and your files never leave your computer.

📍 Break-Even & CVP Calculator

What is the contribution margin?

Selling price minus variable cost per unit: the amount each sale contributes towards fixed costs, then profit.

What does margin of safety tell me?

How far sales can fall before you make a loss. A 20% margin of safety means sales could drop 20% and you would still break even.

💸 Cash Flow Forecast

Why forecast cash, not profit?

A profitable business can still run out of cash if customers pay late, stock is bought up front, or VAT and loan payments bunch together. A cash flow forecast shows when the bank balance will dip.

Where is my forecast saved?

In your browser on this device, when you click Save. Download the Excel file to share it with your accountant or bank.

📉 Depreciation Calculator

Is depreciation tax-deductible in the UK?

No. For tax, depreciation is added back and you claim capital allowances instead (for example the Annual Investment Allowance). Depreciation is still needed for your accounts.

Straight-line or reducing balance?

Straight-line spreads cost evenly and suits buildings and furniture. Reducing balance charges more in early years and suits vehicles and computers, which lose value quickly.

🏦 Loan Amortisation Calculator

How is the loan payment calculated?

With the standard annuity formula: payment = P × i ÷ (1 − (1 + i)^−n), where i is the rate per period and n is the number of payments.

Does overpaying save money?

Yes. Extra payments reduce the balance sooner, so less interest builds up. Check whether your lender charges early repayment fees.

🎯 NPV, IRR & Payback Calculator

NPV or IRR: which is better?

NPV, because it measures the value added in pounds and handles unusual cash flows correctly. IRR is useful as a percentage return, but can mislead when projects differ in size or cash flows change sign more than once.

What discount rate should I use?

Your cost of capital (for example WACC), or the minimum return you would accept. Use our formula solver to work out WACC.

📊 Financial Ratio Analyser

Which ratios matter most for a small business?

Gross margin, the current ratio, receivable days and the cash operating cycle. They show whether you make money on each sale and whether cash is coming in fast enough.

How do I use this for ACCA exams?

Enter the figures from a past-paper scenario to check your ratio calculations. Then use the comments as a starting point for your own analysis, which is where the marks are.

🎓 ACCA & CA student tools

✍️ Double-Entry & T-Account Practice

What does DEAD CLIC mean?

A memory aid. Debits increase Expenses, Assets and Drawings. Credits increase Liabilities, Income and Capital.

Does the trial balance always balance?

With double entry, yes: every debit has an equal credit. A trial balance can still balance with errors such as wrong-account postings, which is why examiners test error correction.

🧠 ACCA & CA Formula Solver

Which ACCA papers use these formulas?

WACC, CAPM, dividend growth and annuities appear in Financial Management (FM) and AFM. EOQ, break-even, learning curves and residual income appear in Management Accounting (MA) and Performance Management (PM). Gearing, EPS and P/E appear in Financial Reporting (FR) and SBR.

Are the formulas the same as the exam formula sheet?

They follow the standard textbook formulas. Always check against the formula sheet provided in your exam, and learn which formulas aren't given.

🎓 ACCA / CA Study Planner

How many hours should I study for an ACCA paper?

It depends on the paper and your background. Applied Knowledge papers often need around 100–120 hours, Applied Skills 150–200, and Strategic Professional 200–250 or more. Adjust the "recommended total hours" to suit you.

Why split study into phases?

Examiners repeatedly say that question practice under timed conditions is what separates passes from fails. The plan gives roughly the last 40% of your time to questions and mocks.

📐 Variance Analysis Calculator

Why does the operating statement reconcile?

Under absorption costing, budgeted profit plus all sales and cost variances equals actual profit, assuming production equals sales. The check figure confirms the maths.

What causes an adverse labour efficiency variance?

Workers took more hours than standard for the output achieved, for example because of poor-quality materials, inexperienced staff or machine problems. It often links to other variances.

📄 PDF tools

🗜️ Compress PDF

Why is my PDF too big to email?

Usually because of high-resolution scans or photos. Compressing re-saves them at a sensible quality. Most email services limit attachments to about 20–25 MB.

Will compression reduce quality?

A little. "Recommended" keeps text readable for printing and screen. Use "Light" for documents with fine detail.

🖼️ Image to PDF

Can I turn receipts into one PDF for my accountant?

Yes. Drop all the photos in, put them in order, and download a single PDF.

Are my photos uploaded?

No. The PDF is created in your browser, so your images never leave your device.

📄 Word to PDF

Does it keep my formatting?

Headings, paragraphs, bold text, lists, tables and images are kept in a clean layout. Exact fonts, colours and complex page designs may differ. For a pixel-perfect copy, use "Save as PDF" in Word.

Is my document uploaded?

No. The conversion runs in your browser, and the file never leaves your computer.

📎 Merge PDF

Are my PDFs uploaded to a server?

No. Merging happens inside your browser, and your files never leave your computer. That makes it safe for contracts, payslips and bank statements.

Is there a file size or page limit?

No fixed limit. Very large files depend on your device’s memory.

Can I merge password-protected PDFs?

Remove the password first in your PDF reader. Encrypted PDFs cannot be combined reliably.

🔄 Rotate & Organise PDF

How do I fix a scanned page that is upside down?

Click ↻ twice on that page, then save.

Is my PDF uploaded?

No. Everything happens in your browser.

✒️ Sign PDF

Is a signature added this way legally valid?

In the UK, electronic signatures are generally accepted for most business documents, such as contracts and forms. Some documents, like certain deeds, need witnessing or other formalities. Check if unsure.

Is my document uploaded?

No. Signing happens in your browser, and the PDF never leaves your device.

✂️ Split PDF

How do I extract just a few pages?

Choose "Extract pages" and type the pages you want, for example 1-3, 7, 10-end.

Is my PDF uploaded?

No. Splitting is done in your browser, so the file stays on your device.

📗 PDF to Excel

Is my PDF uploaded?

No. The PDF is read and converted entirely in your browser, so bank statements and invoices never leave your device.

Will it work with scanned PDFs?

Not yet. A scanned page is a picture, not text. The tool will tell you if your PDF has no text.

Why are some numbers kept as text?

Values with leading zeros (like account numbers 01234567 or product codes 00123) and sort codes are kept as text so Excel does not drop the zeros.

Which date format is used?

UK day/month/year. 03/12/2026 becomes 3 December 2026.

📝 PDF to Word

Which mode should I choose?

"Editable Word" rebuilds the document so you can change the text, keeping headings, bold, bullet points, tables and page breaks. "Exact look" makes the Word file look identical to the PDF, but each page is an image, so the text can’t be edited.

Why isn’t the layout 100% identical in editable mode?

A PDF stores text as positioned pieces, not paragraphs, so every converter has to rebuild the structure. Simple documents (letters, CVs, job descriptions, reports) convert well. Complex magazine-style layouts with columns and text boxes are simplified. For those, use "Exact look", or open the PDF directly in Microsoft Word (File → Open), which also converts it.

Why does it say no text found?

Scanned PDFs are pictures of pages, so there is no text to extract. Use "Exact look", or OCR software, to make the text editable.

Is my PDF uploaded?

No. The conversion runs in your browser, and your file never leaves your device.

💧 Watermark & Page Numbers

Can I choose where the watermark goes?

Yes. Pick one of nine positions (corners, edges or centre) or click anywhere on the preview to place it exactly. You can also choose the angle, size, colour, opacity and which pages it goes on.

Can I remove the watermark later?

Keep your original file. The watermark is drawn onto the pages of the new copy.

Is my PDF uploaded?

No. Everything happens in your browser.

🗂️ Invoices & business documents

🧾 Invoice Generator

What must a UK invoice include?

A unique invoice number, your business name and address, the customer’s name and address, the invoice date, a description of the goods or services, and the amount due. VAT-registered businesses must also show their VAT number, the tax point, and the VAT rate and amount.

Are my invoices stored online?

No. Your business details are saved only in your browser on this device, and invoices are created on your computer.

Do I charge VAT?

Only if you are VAT-registered. Untick "VAT-registered" if not, and no VAT will be shown.

🪪 Letterhead & Business Cards

What must a UK company letterhead show?

Limited companies must show their full registered name, registered number, place of registration (for example England and Wales) and registered office address on letters and order forms. Add your company number above to include it in the footer.

What size are UK business cards?

85 × 55 mm. The A4 sheet fits 10 cards with cut marks.

📦 Purchase Order Generator

Why use purchase orders?

POs confirm exactly what you ordered and at what price. They make checking supplier invoices much easier and help control spending.

Is my data uploaded?

No. POs are created in your browser.

💬 Quote / Estimate Generator

Quote or estimate: what is the difference?

A quote is a fixed price the customer can accept. An estimate is an approximate guide. Either works with this tool. Just change the notes to say which it is.

Is my data uploaded?

No. Quotes are created in your browser.

🧷 Receipt Generator

When should I give a receipt?

Whenever a customer pays, especially for cash, deposits and large purchases. It is proof of payment for both of you.

Is my data uploaded?

No. Receipts are created in your browser.

🗓️ Time & planning

🗓️ Date Calculator

How many days until Christmas?

Set the end date to 25 December. The total days update instantly.

What happens when adding months to 31 January?

If the target month is shorter, the result moves to the last day of that month (for example 28 or 29 February).

🏝️ Team Leave Planner

Are weekends and bank holidays counted as leave?

No. Only working days (Monday to Friday, excluding England and Wales bank holidays) are deducted from allowances.

Where is my team data stored?

Only in your browser on this device when you click Save. Export to Excel to share it.

🍅 Pomodoro Timer & To-Do

What is the Pomodoro Technique?

Work in focused 25-minute blocks ("pomodoros") with 5-minute breaks, and take a longer break after every four. It helps you concentrate and avoid burnout.

Does the timer keep running in another tab?

Yes. It uses the real clock, so switching tabs doesn’t affect the time, and a chime plays when each session ends.

⏰ Timesheet Calculator

How do I work out hours from start and finish times?

Finish time minus start time, minus any unpaid break. For example, 09:00 to 17:30 with a 30-minute break is 8 hours. Overnight shifts are handled automatically.

Are breaks paid in the UK?

Workers aged 18+ are entitled to a 20-minute break if they work more than 6 hours, but it doesn’t have to be paid. Check the contract.

🌍 Meeting Time Zone Planner

Does it handle clock changes (BST/GMT)?

Yes. Times are calculated for the exact date you choose, including daylight saving changes in every country.

What time is good for a UK and India meeting?

Usually 9–11am in the UK, which is early-to-mid afternoon in India (4.5 or 5.5 hours ahead, depending on the time of year).

✅ To-Do List

Where are my tasks saved?

In this browser on this device. Nothing is sent to a server. Use Backup to save a file you can restore on another computer or phone.

How do repeating tasks work?

Set Repeat on a task, or type "every week" or "every monday" when adding it. When you tick it off, the next one is created with the next due date.

Can I edit the Excel file?

Yes. Change a Status to "Done" using the drop-down and the Summary sheet updates. Filters, colours and print settings are already set up.

Will I get reminders?

Open a task and choose Google Calendar, Outlook or iPhone / other. It goes into your calendar with an alert 15 minutes before, so you are reminded even when this page is closed. "Add all to calendar" does the same for every dated task in the view.

📅 Working Days Calculator

Which bank holidays are included?

Official UK bank holidays from GOV.UK for England and Wales, Scotland or Northern Ireland, loaded live. If that fails, the built-in England and Wales dates are used.

Can I use this for notice periods or deadlines?

Yes. "Add working days" gives you the date that is, for example, 10 working days from today, skipping weekends and bank holidays.

✍️ Text & writing

🔠 Case Converter

What is title case?

Main words are capitalised, while short words like "and", "of" and "the" stay lower case unless they start the title, for example "The Lord of the Rings".

What are camelCase and snake_case?

Naming styles used in programming and spreadsheets: camelCase joins words with capitals (totalSales), and snake_case uses underscores (total_sales).

🧽 Remove Duplicates & Sort Lines

Can I remove duplicate emails from a mailing list?

Yes. Paste one email per line, keep "Ignore case" on, and copy the clean list.

Is my list uploaded?

No. Everything runs in your browser.

📃 Lorem Ipsum Generator

What is lorem ipsum?

Scrambled Latin placeholder text, used since the 1500s to fill layouts so designers can judge spacing without being distracted by real words. It comes from a work by Cicero.

🔍 Find & Replace Text

What does "whole words only" do?

It replaces "cat" but not the "cat" inside "category".

Can I use regex groups?

Yes. With regular expressions on, use $1, $2 and so on in the replacement to reuse captured groups.

✉️ Email Signature Generator

Why doesn’t my logo show?

Email signatures can only show images hosted online. Upload your logo to your website and paste its full web address (starting https://).

Should a UK company email include company details?

Yes. Limited companies should show their registered name, number, place of registration and registered office in business emails. Add them in the disclaimer.

🔤 Word & Character Counter

How long is a 1,000-word essay to read?

About 4 minutes to read silently, or around 7 minutes to say out loud.

Is my text saved or uploaded?

Your text stays in your browser. It is kept on this device only, so it’s still here if you refresh.

🧰 Converters, images & utilities

║ Barcode Generator

Which barcode should I use for stock?

Code 128 for internal stock, asset tags and shelf labels: it handles letters and numbers. Use EAN-13 only with official numbers if you sell through retailers.

Can I print barcodes on labels?

Yes. Download the SVG for sharp printing at any size.

💱 Currency Converter

Where do the rates come from?

European Central Bank reference rates, updated every working day. They are mid-market rates. Banks, card providers and bureaux usually add a margin.

Why is the rate different at my bank?

Providers add a spread or fee on top of the mid-market rate. Compare the rate here with what you are offered to see the real cost.

🗜 Image Compressor & Resizer

Which format gives the smallest file?

WebP is usually 25–35% smaller than JPG at the same quality, and all modern browsers support it. Use JPG for maximum compatibility, such as email attachments.

Are my photos uploaded?

No. Images are compressed in your browser and never leave your device.

🔁 Image Converter

How do I convert WebP to JPG?

Drop the WebP files, choose JPG and click Convert. Useful when a website or form will not accept WebP.

Does PNG keep transparency?

Yes. PNG and WebP keep transparent backgrounds. JPG cannot, so transparent areas are filled with the background colour you choose.

🛂 Passport Photo Maker

Can I print these at a shop?

Yes. Download the 6×4" print sheet and print it as a standard 6×4 inch (10×15 cm) photo at any photo kiosk or online print service. Cut along the light lines.

Will this guarantee my photo is accepted?

No tool can guarantee that. Check the official rules: plain light background, neutral expression, eyes open, no glasses or shadows, and a recent photo.

Is my photo uploaded?

No. Editing happens in your browser.

🔐 Password Generator

How long should a password be?

At least 12–16 characters for important accounts, or a 4+ word passphrase. Use a different password for every site, ideally stored in a password manager.

Are these passwords stored anywhere?

No. They are generated in your browser with a cryptographically secure random generator and never sent to any server.

% Percentage Calculator

How do I work out a percentage of a number?

Divide the percentage by 100 and multiply. For example, 15% of 240 = 0.15 × 240 = 36.

How do I remove VAT or a markup?

Use "Reverse a % increase". For example, £276 including 15% is £276 ÷ 1.15 = £240. For VAT, use our VAT calculator.

🔳 QR Code Generator

Do these QR codes expire?

No. They are static codes containing your link or details directly. There is no tracking and no subscription, and they work forever.

How do I make a menu QR code for my restaurant?

Choose Website, paste the link to your online menu, add the caption "Scan to see our menu", and download the SVG for sharp printing on table cards.

Can guests join my Wi-Fi by scanning?

Yes. Choose Wi-Fi, enter the network name and password, and most phones will connect automatically.

📏 Unit Converter

How many kg is a stone?

1 stone = 14 pounds = 6.35 kg.

Is a UK pint the same as a US pint?

No. A UK pint is 568 ml and a US pint is 473 ml. Choose the right one in Volume or Cooking.