The Playbook
Your Close Takes 10 Days. The GL Will Tell You Why.
Meghan Garcia, CPA · 3 minute read
What's Working
- Strong, direct headline that promises a specific timeframe and solution
- Excellent opening hook about the "ugly spreadsheet" - very PowerCPA voice
- Good use of specific examples (AP posting at 11pm, depreciation on day eight)
- Clear distinction between symptoms vs. problems
- Practical Power BI solution with realistic expectations
- Strong pre-close concept that challenges conventional thinking
- Good hard stops throughout, no hedging language
What Needs Work
- "Fine. But..." feels slightly soft - could be punchier
- "Maybe" appears three times in one paragraph - too much hedging
- "honestly — people procrastinate" uses em dash (against voice guidelines)
- Some sentences could be shorter and more impactful
- The Power BI section could be more directive
- "The answer will surprise you" is clickbait-y and generic
- Could use more concrete numbers/specifics
Redraft
Your Close Takes 10 Days. The GL Will Tell You Why.
Nobody wants to look at the ugly spreadsheet. That is exactly where you need to start.
Everyone says start with the month-end checklist. The checklist tells you what should happen. The GL tells you what actually did.
Pull the last adjusting entries that hit before close. Sort by timestamp. Look at who posted what and when.
What you find there is the real close calendar. Not the one in the spreadsheet. The one that actually happened.
The Late Entry Problem
If AP is posting accruals at 11pm on the last day of the month, AP is not closing on time. The process is broken somewhere upstream.
Invoices are not getting approved fast enough. The cutoff policy is not being followed. One person is doing the work of three.
The late entry is the symptom. The broken process is the problem.
Same with depreciation. If the depreciation entry is hitting on day eight of close, go find the workbook that produces it. That workbook is the problem. It takes too long to build. It is too manual to trust. And people procrastinate on the ugliest spreadsheets. That is human nature.
Here's What You Do About It
Build a Power BI model that pulls GL entries with user ID and timestamp. Run a trend analysis. Look at which accounts consistently get their last entries in the final hours of close. Those accounts are your bottlenecks.
Power BI does not fix the problem. It shows you exactly where to look. Then you go find the work paper, the process, the person. And you fix it there.
Power BI cuts the detective work from three days to three minutes. The research is still your job.
Pre-Close Is the Real Answer
Pre-close is what nobody talks about.
Anything that can happen before close should happen before close. If you are reclassing a month of Stripe transactions on the last day, that is a weekly task dressed up as a close task. Move it. Do it every Friday. By the time close starts, it is already done.
Look at your checklist. Ask one question about every single item: does this actually have to happen during close, or did it just end up there because nobody moved it?
Most tasks ended up in close by accident. Not by design.
More from The Playbook
How to Reconcile When There Is No Process to Follow →