APSync Training

All Training Areas Help Main

QBO Reporting: The Simple Version

A couple of reminders before you start, from How to Use These Docs: this page is meant to give you the shape of the idea, not every answer — check the Accounting FAQ for a quick specific question, and once you're past this page, general QuickBooks/HubSpot questions are often best asked directly to ChatGPT or similar — this doc is here for what's specific to this app.

Here's the whole idea, in one sentence

You're already doing this today in MOM and QuickBooks. We're just going to let QuickBooks do more of the adding-up for you — automatically, the moment a sale happens, instead of you (or someone) typing in one big number at the end of the month.

That's a good way to think about it going in — everything below is just explaining how.

First, what does "perpetual" even mean?

Think about your checkbook.

Both get you the same answer eventually. Perpetual just gets you there all the time, not just once a month.

How MOM works today

You probably do something like this today: wait for the month to close, get a report with a handful of big numbers on it, and enter each one as its own line in QuickBooks.

What you're doing in QuickBooks today

Now here's what's about to change

Now we're going to let real invoices flow into QuickBooks directly from HubSpot — and QuickBooks will calculate the cost of each sale itself, automatically, the moment it happens. This is easier for you because you stop being the one who has to add everything up — QuickBooks does that part now, in real time, all day, every day.

Nothing about the destination changes. Same accounts. Same monthly reports. Just filled in automatically instead of by hand.

The report that matters most: the Income Statement

You've probably heard this called the Income Statement, or Profit & Loss, or just "the P&L." It answers one question:

Did we make money this period?

The formula behind it is genuinely this simple:

   Revenue  (money from sales)
 − Cost of Goods Sold  (what those sales actually cost us)
 ────────────────────────────────────────────────────────
 = Gross Profit

Everything below is just showing you where the numbers on that report actually come from — starting small, at one line, and working up to the whole month.

What's a "journal entry," really?

Every time money moves, it moves from somewhere to somewhere. A journal entry is just the record of that: one side is called a debit, the other a credit, and for any single transaction, they always add up to the same total on both sides. That's really all "debit" and "credit" mean here — not good or bad, just "which side of the move."

You don't need to memorize which accounts normally go on which side. Just follow the examples below — the pattern repeats every time.

Level 1: One line on an invoice

A physical item — say, a $20.00 parent guide book that cost the company $8.00 to have printed:

 SALE (the revenue side)
 Account                              Debit       Credit
 ------------------------------------------------------------
 Accounts Receivable                  $20.00
     Sales (Product Income)                       $20.00

 COST (the "what did that book actually cost us" side)
 Account                              Debit       Credit
 ------------------------------------------------------------
 Cost of Goods Sold                    $8.00
     Inventory Asset                              $8.00

Two things happened, not one: the sale itself, and a separate entry moving that book's cost out of "inventory we're holding" and into "cost of a sale we just made." That second part is the piece MOM never sent to QuickBooks before — it only ever arrived as one lump number, once a month.

A service — say, a $50.00 online class registration — is simpler, because there's nothing physical to track:

 Account                              Debit       Credit
 ------------------------------------------------------------
 Accounts Receivable                  $50.00
     Service Income                               $50.00

That's the whole entry. No Cost of Goods Sold line at all — a webinar doesn't get pulled off a shelf, so there's nothing to move out of inventory.

Where to see this in QuickBooks: open the Chart of Accounts, find an account like Cost of Goods Sold, and click Run Report. Every real line like the ones above is sitting right there, one row per sale.

Level 2: One whole invoice

An invoice is just several of those line-level entries added together. Say one invoice has both the book and the class from above:

 Account                              Debit       Credit
 ------------------------------------------------------------
 Accounts Receivable                  $70.00
     Sales (Product Income)                       $20.00
     Service Income                               $50.00
 Cost of Goods Sold                    $8.00
     Inventory Asset                               $8.00

Same two pieces as before — the sale, and the cost — just combined onto one invoice, the same way it looks on the invoice itself.

Where to see this in QuickBooks: open any real invoice and look for a Transaction Journal option (it shows you the exact debit/credit breakdown behind that one invoice — the same shape as the box above, real numbers).

Level 3: A whole month

Now imagine a real month with, say, 200 invoices like the one above. Every one of those small entries lands in the same handful of accounts, and QuickBooks just keeps a running total:

 Account                              Debit         Credit
 --------------------------------------------------------------
 Accounts Receivable                  $14,000.00
     Sales (Product Income)                          $4,000.00
     Service Income                                 $10,000.00
 Cost of Goods Sold                    $1,600.00
     Inventory Asset                                 $1,600.00

And this is exactly what shows up on the Income Statement for that month:

   Revenue           $14,000.00   ($4,000 Sales + $10,000 Service Income)
 − Cost of Goods Sold  $1,600.00
 ──────────────────────────────
 = Gross Profit       $12,400.00

Where to see this in QuickBooks: Reports → Business overview → Profit and Loss, with the date range set to that month. One report, the whole month's total, automatically.

Why the month-end report should look the same either way

Whether that $1,600.00 in Cost of Goods Sold arrived as one big number someone typed in (today) or as 200 small automatic entries adding up to the same total (after this goes live), the Income Statement doesn't know the difference. It just adds up whatever's in the account for that month. Same total, same report — you're just not the one doing the adding anymore.

One more thing before you go looking

The products are already set up pointing at the correct accounts (or will be, before this goes live) — so this isn't some new, unfamiliar account structure to learn. It's the exact same one already in use today.

Go take a look — right now, while it's fresh

If you've got QuickBooks open already, this is a good moment to go look at one simple thing: Reports → Business overview → Profit and Loss. Pick last month. That's the exact report we just walked through above — real revenue, real Cost of Goods Sold, real Gross Profit, all on one page.

Don't panic if something on the screen looks unfamiliar or doesn't quite match what you expected. That's completely normal, and it's exactly what the next document — the advanced one — is for. This page was just here to give you the shape of the idea. The advanced doc answers the "wait, why does it say that?" questions in detail, with real examples. You're not expected to have all of that figured out from this page alone.

Quick specific question and don't want to read the whole advanced doc? Check the Accounting FAQ first.

Bottom line

Same accounts. Same monthly report. Just filled in automatically instead of by hand — and now, for the first time, you can actually see the real detail underneath it, any time you want, instead of waiting for month-end.