No. Every calculation is a formula you can trace. There is no VBA in the file.

Which Excel versions does it work in?

It is built without macros or dynamic-array functions and tested in Excel 365 for Windows. The Excel 2019, Mac and Google Sheets checks are listed on the How we test page as they are completed.

What format does my trial balance need?

Closing (year-to-date) balances, one row per entity and account, with debit and credit columns as most ledgers export them. Add the Period and Entity columns, then paste. A trial balance of period movements gives a wrong month P&L, so export closing balances.

Does it eliminate intercompany balances?

No. Version 1.0 adds entities together. Eliminations are in the consolidation workbook.

Is my data uploaded anywhere?

No. The workbook runs on your computer. We never see your ledger.

Why not ask an AI assistant to build a close file?

You can, and you then need to check what it built. This workbook is the checked version: the same formulas in every file, every check visible, and each release tested against an independent recompute before it ships.

What does the licence allow?

Excel: one named user, for their own organisation. Team: up to 10 named users in one organisation, for its own work. Practice: up to 5 named users in one accounting firm, for any number of clients. You may give completed files to your auditors and reviewers. Outputs you create are yours.

When we release an update, it is free within the same major version for as long as we sell it. You get an email and download it from your library.

What if it does not work for me?

Ask within 14 days of purchase for a full refund, for any reason.

Month-End Close and TB Tie-Out Kit

Tie out the trial balance and run the close from one workbook.

Paste your trial balances, map each account once, and the workbook ties out sub-ledgers, flags flux, tracks reconciliations and builds the management pack. Every check shows PASS or FAIL.

Up to 10 entities and 6,000 trial balance rows of closing (year-to-date) balances, pasted from your ledger with a Period and Entity column added. No macros.
A 30-task close calendar from D-3 to D+7 with due dates on your working week, and close metrics that count themselves.
A management pack (P&L, balance sheet, indirect cash flow) that ties to the movement in cash.

See pricing Sample output (PDF)

Who it is for

Controllers and finance managers closing 1 to 10 entities in Excel.
Outsourced accounting firms who close several clients each month, under the Practice licence.
Teams that want every close check visible in one file, without buying close software.

Who it is not for

Groups that need intercompany eliminations in the close file (see the consolidation workbook).
Teams already running a close platform with workflow and approvals.
Ledgers that export period movements only: the workbook needs closing (year-to-date) balances.
Anyone who wants us to do the close: this is a tool you run.

Tab by tab

Settings: Month end, currency, fiscal year start, materiality (percent and absolute), tolerance, working week, entity list.
Close Calendar: 30 standard tasks with owner, due day, due date on your working week, status, reviewer and evidence.
TB Import: Paste closing (year-to-date) trial balances for current, prior, the month before and budget, for every entity, with debits and credits as exported and a Period and Entity column.
Mapping: Map each account once to a statement line, with contra and sub-ledger flags.
TB Tie-Out: Sub-ledgers (AR, AP, fixed assets, bank) and reported statement lines against the TB, plus new and dormant accounts.
Flux Analysis: Month on month and against budget for every line, with your thresholds and a comment for each breach.
BS Reconciliation: One row per reconciliation: balance pulled from the TB, reconciled balance, difference, preparer and reviewer sign-off.
Management Pack: P&L, balance sheet and indirect cash flow, consolidated, with KPI tiles.
Close Metrics: Tasks done on time, working days to close, open reconciling items.
Checks: Every check visible, PASS or FAIL, with one cell that tells you whether everything passes.

The checks

Every check is visible on the Checks tab and shows PASS or FAIL.

C01Trial balance debits equal credits for every entity and period, with no duplicate or invalid rows.
C02No account with a balance is missing from the mapping, and the mapping itself is valid.
C03Sub-ledgers and reported statement lines tie to the TB within tolerance.
C04Every flux breach has a comment.
C05The balance sheet balances.
C06A Prior TB is present for every entity and balances, so month figures are never silently wrong.
C07Every reconciliation is prepared, reviewed by someone else and signed off, and coverage is complete.
C08No P&L account carries an abnormal sign beyond materiality, unless it is a contra account or accepted with a reason.
C09Intercompany balances net to zero.

How we test each release

How it compares

Typical setups, not a review of any one product.

	Free template	Close software	This workbook
Close calendar with working-day due dates	Varies by template	Usually	Yes
TB tie-out to sub-ledgers	Varies by template	Usually	Yes: AR, AP, fixed assets, bank
Checks you can show a reviewer	Varies by template	Varies, often inside the platform	Every check visible, PASS or FAIL
Where your data lives	Your machine	Usually cloud hosted	Your machine
Price	Free	Usually per user, per year	USD 69, once

Sample output

Download the sample output (PDF): the Checks summary and the management pack from the sample entities.

Pricing

Excel

USD 69

USD 51.75 with code FOUNDING25 until 1 December 2026.

Up to 10 entities, one named user

Choose this if one person runs the close file.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

Team

USD 199

USD 149.25 with code FOUNDING25 until 1 December 2026.

Up to 10 entities, up to 10 named users in one organisation

Choose this if up to 10 colleagues in one organisation share the close file.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

Practice

USD 249

USD 186.75 with code FOUNDING25 until 1 December 2026.

Up to 10 entities per file, up to 5 named users in one accounting firm, any number of clients

Choose this if your firm runs month-end closes for clients.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

One-time price. Updates within the same major version are free for as long as we sell it.

You can ask for a full refund for any reason within 14 days of purchase. This is our own promise. The statutory withdrawal right you give up at checkout is a separate legal right.

Prices are in USD. Depending on your country, sales tax is either included in the price or added at checkout, and Paddle shows the total before you pay. Your checkout may show a local price.

After a purchase we may email you tips for your tool and about similar Hayatiq tools; every email has an unsubscribe link.

This is a tool, not tax, accounting or financial advice.

Questions

Does it need macros?: No. Every calculation is a formula you can trace. There is no VBA in the file.
Which Excel versions does it work in?: It is built without macros or dynamic-array functions and tested in Excel 365 for Windows. The Excel 2019, Mac and Google Sheets checks are listed on the How we test page as they are completed.
What format does my trial balance need?: Closing (year-to-date) balances, one row per entity and account, with debit and credit columns as most ledgers export them. Add the Period and Entity columns, then paste. A trial balance of period movements gives a wrong month P&L, so export closing balances.
Does it eliminate intercompany balances?: No. Version 1.0 adds entities together. Eliminations are in the consolidation workbook.
Is my data uploaded anywhere?: No. The workbook runs on your computer. We never see your ledger.
Why not ask an AI assistant to build a close file?: You can, and you then need to check what it built. This workbook is the checked version: the same formulas in every file, every check visible, and each release tested against an independent recompute before it ships.
What does the licence allow?: Excel: one named user, for their own organisation. Team: up to 10 named users in one organisation, for its own work. Practice: up to 5 named users in one accounting firm, for any number of clients. You may give completed files to your auditors and reviewers. Outputs you create are yours.
How do updates work?: When we release an update, it is free within the same major version for as long as we sell it. You get an email and download it from your library.
What if it does not work for me?: Ask within 14 days of purchase for a full refund, for any reason.

Who built it

Omer Hayat Khan, FCCA. 8 years in Big Four audit. Every workbook is generated from source code written for Hayatiq and checked by an independent test suite before release.

How we test | About

Changelog

v1.0.0 (2026-10): First release.

Full changelog