How can I build a custom QBO month-end close review tool that flags unreconciled accounts, uncategorized entries, and other close issues, instead of relying on a third-party tool like Keeper/Zenit?

Ben built an internal tool (a QBO 'month and close' reviewer) after having issues with a third-party tool (referred to as Zenit), particularly around unreconciled bank accounts — that tool required manually opting in each bank account, which led to missed reconciliations and client issues. His custom tool instead automatically scans all bank accounts, credit cards, and any account with 'clearing,' 'loan,' 'mortgage,' or 'escrow' in the name, and flags any unreconciled transactions.

The tool also checks for: uncategorized entries ("ask my accountant/client" type items), transactions posted to a parent general ledger account, entries missing a class, expenses without payee names, AP/AR items over 30 days old, new entities and how they're being coded (with client lead approval), GL posting consistency (flagging when a transaction type is coded differently than historical pattern), balances left in undeposited funds, duplicate vendor names, and any equity account transactions.

Workflow: the bookkeeper is gated to see only their own clients and must mark each of the eight review sections as reviewed/clean, or if there's an issue, they must leave a comment explaining why it's okay to proceed. The manager or client lead then does a second review before the QuickBooks file is finalized. The tool pulls data directly via the QuickBooks API — Ben registered the app (Arch) as an internal-only developer app with Intuit, which required minimal scrutiny since it wasn't public-facing. He said Claude walked him through the entire developer registration process (about 30 minutes), including telling him what to enter at each step from screenshots.

The tool does not currently generate a PDF of the completed checklist — Ben felt that would just be another artifact no one would look at — though results are stored so a given month's review can be pulled up later. It runs on Supabase at the base/cheapest tier (~$25/month), which he said is sufficient for this level of complexity.