Your Item Sales report is cash basis. Is your P&L?

Two reports, same month, different revenue, and neither one is wrong.

If you've ever put Clover's Item Sales report next to your monthly P&L and watched the totals refuse to match, the first suspect is usually the books. Often the real answer is simpler: the two reports count by different rules.

What Clover says the Item Sales report counts

Clover's help article on the Item Sales report is direct about the method: "Item sales reports follow cash basis accounting practices, where sales are recorded at the time of payment and updated when a refund is issued."

The same page carries a disclaimer worth taking literally. Clover doesn't provide tax or accounting advice, and it says to consult your tax and accounting advisors before using these reports for tax or accounting purposes. That isn't boilerplate to skip. It's Clover telling you the report is an operating tool, not your ledger.

What the report does show: how many items you sold, your most popular items, how your revenue classes are performing, cost of goods sold, and gross profit margin. That's a strong list for running the business. It's not the same as "what did we earn this month."

Cash basis vs. accrual, in one paragraph

Under cash-basis reporting, a sale counts when the money comes in. Under accrual accounting, revenue generally counts when it's earned, meaning when you deliver the goods or service, whether or not you've been paid yet. Many small businesses keep their books on an accrual basis, or their bookkeeper makes accrual adjustments at month-end. If yours does, the Item Sales report and the P&L are measuring two different moments for the same sale.

For a counter where the customer pays and walks out with the item, those moments are the same, and the reports mostly agree. The gaps open up wherever payment and delivery are split:

• Deposits or prepayments for orders you fulfill later, such as catering, custom work or special orders.
• Work you deliver now and collect on later.
• Refunds that are issued in a different month from the original sale.
• Month-end entries your bookkeeper makes that never touch the POS at all.

Same month, two right answers

Example (hypothetical round numbers, not a benchmark): a bakery takes a $1,000 payment on September 28 for a wedding order it delivers on October 3. The Item Sales report records the $1,000 in September, because that's when the payment happened. Accrual books record it in October, because that's when the order was delivered. September's Item Sales total is $1,000 higher than the P&L, October's is $1,000 lower, and both are correct by their own rules.

Refunds add a second wrinkle. Because the report is "updated when a refund is issued," the numbers aren't frozen when the month ends. Clover's one-sentence description doesn't spell out which period a refund lands in, so don't assume. Look up one refunded order and see how it shows across both months. Either way, a report you exported last week may not match the same date range today, so note the date you pulled any copy you plan to compare.

What the report answers well

Cash timing barely matters for mix and margin questions, which is where this report earns its place:

• Which items sell, and in what volume.
• Which items are most popular, for menu, shelf and staffing decisions.
• How each revenue class performs against the others.
• Cost of goods sold and gross profit margin by item, so you can see which products carry the business.

One caution on margin. Clover's report article lists COGS and gross profit margin but doesn't explain how they're calculated, so spot-check a few items against what you know they cost before you reprice anything. Your books may arrive at cost of goods sold differently, for example from purchases and inventory counts, so expect those figures to differ too.

What it answers badly

Period-end revenue. If your books are accrual, the P&L is the number for monthly revenue, tax planning and anything you hand a lender. The Item Sales report is the number for what moved across the counter and when it was paid for. Trying to force one to equal the other usually means "fixing" a difference that's supposed to be there.

The useful move is to explain the gap, not erase it. List the timing items (prepayments, collections, cross-month refunds), and what's left over is the part worth investigating.

Practical tips for running it

A few details from Clover's help articles save time:

• Find it under Reports, then Item and Service sales. You need Reporting access permission to run reports.
• Date ranges under three months open automatically. Longer ranges are submitted as a request, Clover emails you when it's ready, and you'll find it under Reports, then Requested Reports.
• Requested reports can be viewed for 7 days. On days 8 to 14 they sit in the history list, and after that you need a new request.
• Historical reports go back up to five years, but only one year at a time. Pull a multi-year comparison as separate yearly runs.
• You can choose Revenue Items or Non-revenue Items. Non-revenue items are the ones marked non-revenue in the Inventory app, so check which view you're comparing to your books.
• Filter by device, employee or order type, and use the arrows to step through previous or next periods of the same length.
• Print or export from the top right. Clover also offers Accounting Sync there to sync your data with QuickBooks Online automatically. If you use it, ask whoever keeps your books how those entries are handled at month-end rather than assuming the sync makes the two reports agree.

If a report comes back empty, Clover's suggestions are the obvious ones, and they're usually the answer: check the date range, clear any employee, device or order type filters, and confirm transactions actually happened in that window.

A monthly habit that keeps both reports honest

• Export the Item Sales report for the month once it's closed, and note the date you pulled it.
• Ask your bookkeeper whether your books are cash or accrual, and which adjustments they make at month-end.
• List the prepayments, later collections and cross-month refunds that explain the gap.
• Use the Item Sales report for item mix, revenue class performance and margin. Use the P&L for revenue.

Neither report is wrong. They're answering different questions, and the trouble starts only when you ask one of them the other's question.

If you'd like help reconciling what Clover reports with what your books say, Gameplan Financials pairs bookkeeping and tax strategy with AI systems work: schedule a conversation.