Why Do My Sales Spreadsheet, My Invoices, and My Bookkeeping Show Three Different Revenue Numbers?

You open your sales spreadsheet: $18,000.

You open your invoicing system: $13,500.

Your bookkeeping report says $11,200.

It is tempting to assume someone made a mistake. Sometimes they did. More often, each tool is counting a sale on a different date.

Your sales spreadsheet may count a deal when the client signs. Your invoicing system may count it when you send the invoice. Your bookkeeping may count it when payment arrives—or, depending on your accounting method, when you earned it.

The numbers disagree because the question changed without anyone saying so.

One sale can have several important dates

Take a $4,000 project:

• Proposal accepted: June 26
• Invoice sent: July 1
• Deposit paid: July 8
• Work completed: August 5
• Final payment received: August 12

Which month did you make the sale?

There is no single answer. It depends on what you are trying to understand.

If you want to measure sales activity, June matters. If you want to know how much you billed, July matters. If you want to plan cash, July and August matter. If you need formal financial reporting, your accountant may use another rule.

The problem is not multiple dates. The problem is calling every number “revenue” with no label.

Give each number a job

Use clear language in your weekly and monthly reporting.

Booked revenue means deals signed during the period. Use it to assess sales performance and future workload.

Invoiced revenue means invoices issued during the period. Use it to track billing progress.

Collected cash means payments received during the period. Use it for bank balance, payroll, and spending decisions.

Recognized revenue may mean work earned during the period under your accounting method. Use it with your bookkeeper or accountant for financial statements.

For most 1–15 person businesses, the first three labels solve most confusion.

Your monthly dashboard might say:

Now the numbers tell a story instead of starting an argument.

Do not force tools to agree when they should not

You do not need your CRM, invoicing tool, and bookkeeping software to show the same monthly total. You need each one to have a trustworthy purpose.

A CRM should show the signed deal date and amount. An invoicing system should show when bills were issued and whether they are paid. Your bookkeeping system should follow the accounting method you use with your accountant.

Trying to make all three reports match exactly can create worse data. For example, moving a deal’s close date from June to July just because payment arrived in July damages your ability to see when your sales work succeeded.

Instead, connect the records. Put the client name, deal ID, or invoice number where practical so you can trace one sale across systems.

Use a monthly reconciliation ritual

At month-end, take 30 minutes to compare the three lists.

Start with signed deals. For each one, ask:

• Was an invoice sent?
• Was it sent for the agreed amount?
• Has payment arrived?
• If not, when is it due?
• Does bookkeeping show the payment correctly?

Then do the reverse for invoices. If an invoice exists with no matching CRM deal, find out why. Maybe it is an expansion, a renewal, or a one-off charge that should be recorded differently.

This is not about making every number identical. It is about making every difference explainable.

Avoid “monthly revenue” without a label

When you say, “We made $18,000 this month,” decide what you mean before you make plans around it.

Say, “We booked $18,000, invoiced $13,500, and collected $11,200.” Your team, accountant, and future self can act on that.

Key takeaway: Your reports can show different numbers without being wrong; they must use clear date definitions for different decisions.

Next step: Rename the revenue rows in your spreadsheet to “booked,” “invoiced,” and “collected,” then write which date each one uses.