📊 a journal entry
ProAdvisor Prep: Level 2 — Reporting, Financial Planning & Making the Numbers Mean Something
September 24, 2026
We made it.
Final module of Level 2.
Nobody died.
Gertrude threatened several people.
Gladys went from shelter dog making an unauthorized guest appearance in Module 2 to actually becoming mine before we finished the course.
Honestly, I consider that the most successful outcome of the entire curriculum.
But we still have one thing left to do.
Level 1 taught us how to produce reports.
Level 2 asks whether we can look at those reports and understand what the numbers are actually telling us.
Because handing a client a Profit and Loss statement isn’t advisory.
Helping them understand why this quarter looks different from last quarter, why cash doesn’t equal profit, where performance changed, and what those patterns might mean for the next quarter?
Now we’re doing something useful.
Cash vs. Accrual: Same Business, Different Question
This distinction matters enormously in reporting.
Under cash-basis accounting, income and expenses generally appear when money is actually received or paid.
Under accrual accounting, income and expenses are generally recognized when invoiced or billed, regardless of whether the money has changed hands yet. QuickBooks lets you change the accounting method on an individual report so you can examine the difference.
Let’s make this human.
Resistance Coffee & Books sends a customer a $60,000 invoice on September 20.
The customer doesn’t pay until November.
Run the Q3 Profit and Loss on Accrual:
That $60,000 of revenue belongs in the Q3 report because that’s when it was invoiced.
Run the same Q3 P&L on Cash:
That unpaid invoice isn’t included as Q3 cash-basis income because the customer hasn’t paid it yet.
Same business.
Same invoice.
Same quarter.
Different reporting method.
Different question.
Profit Is Not Your Bank Balance
This is where clients—and occasionally perfectly competent humans who haven’t had enough coffee—get tripped up.
A Profit and Loss statement is not a bank statement.
Profit ≠ cash sitting in checking.
A company can report accounting profit while struggling for cash.
It can collect substantial cash during a period while reporting a loss.
Loan proceeds can put money in the bank without becoming revenue.
Paying down loan principal removes cash without becoming an expense on the P&L.
Timing matters.
Balance-sheet activity matters.
So if a CEO says:
“That can’t be right. We collected more cash than we spent.”
Our response isn’t:
“Then the P&L must be wrong.”
Our response is:
“Okay. Let’s find out why those two things are telling different stories.”
That’s considerably more useful.
A/R and A/P on a Cash-Basis Balance Sheet: Investigate, Don’t Diagnose From Across the Room
The original draft said that seeing Accounts Receivable or Accounts Payable on a cash-basis Balance Sheet means a data error occurred.
Too absolute.
Intuit specifically documents situations where A/R or A/P balances can appear on a cash-basis Balance Sheet. Causes can include transactions affecting those accounts or unapplied payments, and QuickBooks has specific troubleshooting procedures for them.
So if you see A/R or A/P where you didn’t expect it:
Don’t immediately “fix” it.
Investigate what created the balance.
Look at the underlying transactions.
Look for unapplied payments.
Determine whether the balance reflects the way QuickBooks is handling the transaction or whether something genuinely needs correction.
Level 2 should be tattooing this onto your accounting brain by now:
Unexpected does not automatically mean incorrect.
Comparative Reporting: One Number Is Lonely
A report showing that the company made $42,000 tells us something.
But without context, it doesn’t tell us very much.
Was that better than last month?
Worse than last year?
Normal for this season?
A spectacular recovery from an absolutely catastrophic Tuesday?
This is why comparative reporting matters.
QuickBooks supports side-by-side comparisons for many reports, including:
- previous period;
- previous year;
- year-to-date where available;
- dollar change;
- percentage change.
Now we’re no longer just looking at:
What happened?
We’re looking at:
What changed?
Example
Suppose Q3 revenue was:
2025: $300,000
2026: $360,000
The $60,000 increase is useful.
The 20% increase gives us another way to understand its scale.
Neither number independently tells us why revenue increased.
That’s where the human comes back in.
Maybe prices increased.
Maybe volume increased.
Maybe one enormous customer landed.
Maybe last year’s Q3 was terrible.
Maybe this year’s Q3 contained an unusual event.
The report identifies the pattern.
You investigate the reason.
Collapse the Shit You Don’t Need
Sometimes a technically complete report is a terrible presentation.
Your client does not necessarily need every subaccount displayed while you’re trying to explain the larger picture.
QuickBooks lets you collapse report sections/subaccounts so the parent-level information remains visible without all of the underlying detail cluttering the presentation. The details haven’t been deleted; you’re changing how much of them are displayed.
That makes Collapse useful when you’re presenting to somebody who needs:
the story
rather than:
every individual line responsible for the story.
And if somebody needs the detail?
Expand it again.
No Chart of Accounts was harmed in the making of this presentation.
Management Reports: Make the Damn Thing Presentable
Now we get to one of the genuinely useful Level 2 tools.
A Management Report lets you combine financial information into a presentation-ready package rather than emailing somebody seventeen unrelated PDFs and wishing them luck.
Current QuickBooks Management Reports can include things such as:
- a cover page;
- table of contents;
- preliminary/narrative pages;
- financial reports;
- charts;
- KPI elements depending on subscription;
- end notes;
- custom branding.
QuickBooks currently provides Management Reports under Reports → Management reports, with feature availability varying by subscription. Advanced and Intuit Enterprise Suite include additional content and visualization capabilities.
So if the board wants:
Profit and Loss
plus
Balance Sheet
plus
an explanation of what the hell happened
you don’t necessarily need to staple three PDFs together metaphorically.
Build the package.
Narrative Is Part of Reporting
I particularly like the preliminary-page option because numbers rarely explain themselves completely.
You can provide context:
Revenue increased 18% year over year, primarily due to…
Operating expenses increased because…
Cash declined despite positive net income because…
That’s where accounting starts becoming communication.
And advisory requires both.
Budgets: Stop Looking Only Backward
Reports tell us what happened.
Budgets help us describe what we expected to happen.
Then Budget vs. Actuals lets us compare the two.
QuickBooks budgeting can use monthly, quarterly, or yearly intervals, and you can pre-fill budget information using actual historical data instead of beginning with twelve completely empty columns. Current budgeting tools also support subdividing budgets by criteria such as Customer, Class, or Location, depending on configuration and product capabilities.
That historical pre-fill is particularly useful for seasonal businesses.
Imagine an ice-cream shop.
January:
please God somebody buy something
July:
HOLY SHIT WE NEED ANOTHER FREEZER
Taking an annual average and copying it into twelve months would completely flatten the actual business pattern.
Prior-year actuals give us a starting shape.
But Historical Data Is a Starting Point
Last year’s numbers aren’t a prophecy.
Maybe rent increased.
Maybe staffing changed.
Maybe the company opened another location.
Maybe the product mix changed.
Maybe last year involved a hurricane, a supply shortage, or one customer who bought half the company’s inventory.
Historical data can establish a baseline.
Human judgment builds the budget.
There’s that theme again.
Budget vs. Actuals: Variance Needs Context
Once a budget exists, QuickBooks can run Budget vs. Actuals reporting so you can compare expected performance with what actually happened.
But be careful about interpretation.
If you’re halfway through September and compare:
the entire September budget
against
September actuals through the 15th
you’re comparing a complete target with an incomplete period.
That isn’t necessarily useless.
But it needs to be labeled and interpreted as partial-period information.
So it’s not:
“Always filter to completed, fully reconciled periods.”
That’s too rigid.
Sometimes management absolutely needs a mid-month view.
The correct rule is:
Compare equivalent periods when that’s the question—and clearly identify partial periods when they’re intentionally being used.
Don’t manufacture a scary variance by pretending half a month is a whole one.
Sharing Custom Reports: Saved Doesn’t Mean Shared
You spend an hour building a beautiful custom report.
You save it.
Your teammate says:
“Where is it?”
You begin questioning your life choices.
Current QuickBooks lets saved custom reports remain private or be shared with others who have access. In the current interface, Share with others controls that visibility; some classic-view workflows still use All/None terminology.
So don’t memorize one ancient screenshot.
Remember the concept:
Saving preserves your customization.
Sharing determines who else can see it.
🚨 Three Reporting Sabotages
Sabotage 1: Assuming the Summary Tells the Whole Story
A summary is useful precisely because it hides detail.
That also means the detail may contain the explanation for something strange.
If an account total looks suspicious, drill down or run the appropriate detail report rather than staring harder at the summary and hoping enlightenment arrives.
QuickBooks includes Balance Sheet Detail and other detail-level reports depending on subscription.
Sabotage 2: Confusing Cash With Profit
“There is money in the bank” does not mean “the business was profitable.”
And:
“The P&L shows profit” does not mean “the bank account contains that amount.”
Different reports answer different questions.
Use the correct one.
Sabotage 3: Presenting a Variance Without Explaining the Period
Budget vs. Actuals can be useful mid-period.
Just don’t let somebody interpret fifteen days of actual activity as though it represents thirty days.
Dates are not decorative.
🕵️ The Final Resistance Accountants Scavenger Hunt
The Situation
Resistance Coffee & Books has reached the quarterly board meeting.
Congratulations.
Apparently we’re corporate now.
The CEO says:
“We collected a shitload of cash this quarter, but the P&L still looks terrible. Something must be wrong.”
Maybe.
Maybe not.
Your job is to investigate before agreeing with anybody.
Task 1: Check the Reporting Method
Open the Profit and Loss report.
Where can you determine whether the report is using Cash or Accrual accounting?
What difference would changing that setting make?
Task 2: Follow the $60,000 Invoice
The company sent a $60,000 invoice on September 20.
The customer won’t pay until November.
How does that invoice affect:
Q3 Accrual-basis income?
And:
Q3 Cash-basis income?
Task 3: Explain Why Cash Still Doesn’t Equal Profit
The CEO keeps pointing at the bank account.
Name at least two kinds of activity that could change cash without having the same effect on P&L net income.
Don’t merely say:
“Cash and accrual are different.”
Explain the business event.
Task 4: Build the Board Package
The board wants:
- the adjusted P&L;
- Balance Sheet;
- a professional cover;
- and a narrative explaining the important variances.
What QuickBooks tool is designed to combine those elements into one presentation-ready package?
🛑 ANSWERS BELOW
Gladys would like everyone to know that she has completed the scavenger hunt.
Gladys has also eaten part of the scavenger hunt.
Her results are therefore unavailable for independent verification.
🕵️ Scavenger Hunt Solved
Task 1 — Cash or Accrual?
Check the report’s Accounting method setting.
Current QuickBooks reporting lets you select Cash or Accrual for an individual report.
Switching methods changes when income and expenses appear.
It does not change what happened at the bank.
Task 2 — The $60,000 Invoice
Under Accrual, the September invoice contributes $60,000 of Q3 revenue even though it hasn’t been collected yet.
Under Cash, that unpaid invoice doesn’t contribute Q3 income; assuming payment arrives in November, the cash-basis income would be recognized when payment is received.
And here’s the correction to the original answer key:
That invoice raises accrual-basis Q3 income.
It cannot simultaneously be our explanation for why accrual-basis net income is $45,000 lower.
Nice try, Gemini.
Task 3 — Why Cash Isn’t Profit
Possible examples include:
Loan proceeds: Cash comes in, but borrowing money isn’t business revenue.
Loan principal payments: Cash goes out, but principal repayment isn’t a P&L expense.
Owner contributions or distributions: Cash changes without necessarily becoming operating income or expense.
Timing of customer/vendor payments: Cash timing and accrual recognition may fall in different periods.
The point:
Bank movement and P&L activity overlap, but they are not identical universes.
Task 4 — Management Reports
Use Management Reports.
They are specifically designed to combine financial reports and supporting presentation content into a polished package for clients or stakeholders.
📝 Final Level 2 Practice Quiz
Question 1
You’re creating a budget for a highly seasonal client. What gives you the most useful starting baseline?
A. Put the annual average into all twelve months.
B. Pre-fill using prior-year actual data, then adjust it for what you expect to change.
C. Enter the current bank balance into every month.
Question 2
You save a custom report and another authorized user can’t see it. What’s one of the first things you should check?
A. Whether the report was shared with others.
B. Whether QuickBooks emailed it automatically.
C. Whether the other user has completed Level 2 and pleased Gertrude.
Question 3
You want an executive report to show parent-level categories without every underlying subaccount cluttering the page. What should you do?
A. Delete the subaccounts.
B. Collapse the appropriate report sections.
C. Switch from Accrual to Cash and hope for the best.
Question 4
A CEO says the P&L must be wrong because the bank balance increased.
What’s your best response?
A. Immediately change the report to Cash.
B. Delete anything that doesn’t match the bank.
C. Investigate which business activities affected cash, which affected income/expense, and which reporting method and period you’re examining.
🔑 Quiz Answers
Question 1 — B
Historical actuals preserve the client’s existing seasonal pattern better than flattening everything into an average.
But they’re the baseline, not the finished budget.
Question 2 — A
Saved and shared are separate concepts.
Check the report’s sharing configuration and the user’s access.
Question 3 — B
Collapse the detail.
The underlying accounts remain intact.
Question 4 — C
Of fucking course it’s C.
If you’ve made it through two levels of this course and chose “delete things until the numbers match,” Gertrude would like your address.
One Last Thing: You Passed. Now What the Hell Do You Do With the ProAdvisor Profile?
A bunch of you have asked me about this.
Here’s the current process if you want to publish your ProAdvisor profile.
First: The Profile and the Certification Aren’t the Same Thing
Passing your certification gives you the credential.
A ProAdvisor profile is the public-facing profile that can appear on Intuit’s Find a ProAdvisor website so potential clients can find you.
Current Intuit guidance says you need a QuickBooks Online Accountant/Intuit Accountant Suite firm, a current valid QBO certification, and the required ProAdvisor eligibility before publishing. Intuit’s current benefits table lists public profile publishing at Gold tier or higher.
So if you passed the exam and immediately wonder why QuickBooks hasn’t launched your face onto the internet:
Certification does not automatically equal public listing.
Build the Profile
In Intuit Accountant Suite/QuickBooks Online Accountant:
Profile icon → Go to ProAdvisor profile
Fill out your information.
You can edit it later and use Preview to see what the public profile will look like before publishing.
This is where you can describe your experience, services, specialties, industries and credentials.
And unlike your résumé:
Write it for the client who needs you.
Not for the robot screening applicants.
Ready to Be Perceived by the Public?
When you’re eligible and actually want the profile public:
Profile icon → Go to ProAdvisor profile → Publish profile
Intuit currently requires identity/eligibility verification and asks for a valid government-issued ID during publication. Intuit says confirmed profiles are generally published within two business days; if they can’t confirm your information, they may request additional notarized business documentation.
Yes.
There is paperwork after the fucking exam.
Of course there is.
Make Sure People Can Actually Find You
A published profile can appear on the Find a ProAdvisor site. Intuit says your credentials, services and supported industries can affect profile placement, and accurate address information matters for location-based searches.
There’s also an Include in search results setting associated with appearing in searches, so if you’re published but seemingly invisible, check the profile/search configuration before assuming Intuit has banished you.
And keep your certification current. Intuit currently requires a current valid QuickBooks Online certification for the public ProAdvisor profile.
Please Don’t Get Weird With the Branding
If you put your credential on your own website, read Intuit’s current brand-use rules.
Among other things, Intuit says ProAdvisors shouldn’t use the Intuit logo as though they’re Intuit themselves, and specifically flags descriptions such as “Intuit Certified ProAdvisor” as inaccurate representations.
You’re certified in QuickBooks.
You have not been adopted by Intuit.
There’s apparently a process for that too, and Claude probably administers it.
And That’s Level 2
Level 1 taught us to use QuickBooks.
Level 2 asked us to understand what QuickBooks is representing.
We dealt with advanced sales workflows.
Expenses and vendors.
Banking rules and cleanup.
Reporting and financial planning.
But underneath all of it has been the same lesson:
Software can process information.
It cannot absolve you of understanding the information.
The better the automation becomes, the more important that distinction gets.
Use AI.
Use automation.
Use bank rules.
Use suggested matches.
Use historical budget data.
Use every tool that saves you from doing repetitive shit a computer can do perfectly well.
But when something doesn’t make sense:
Stop.
Look at the evidence.
Understand the business event.
Then decide what belongs in the books.
That’s what separates somebody who learned where the buttons are from somebody who understands what those buttons do.
And One More Faculty Update
When Gladys first appeared in Level 2, she was our Visiting Distinguished Bulldog.
She lived six hours away.
She was a rescued shelter dog.
I wanted her desperately, had already renamed her in my head, and apparently decided putting her into accounting course artwork was a perfectly normal manifestation technique.
Well.
It fucking worked.
Gladys is mine. She will be coming home on Oct 4.
So for our final Level 2 module, it seems appropriate to announce that her visiting appointment has become permanent.
Her qualifications remain questionable.
Her snack-approval numbers are extraordinary.
Gertrude has filed an objection.
Wallace has welcomed her to the department.
And I couldn’t think of a better way to finish this lovely project than with one more reminder that sometimes the thing you’re working toward quietly becomes real while you’re busy doing all the work required to get there.
So from Wallace, Gertrude, Professor Gladys, and me:
Use the machine. Train the human.
Level 2 complete.
✦ enjoyed this entry?