🧪 Beta: Smarter Reports are currently available to selected businesses. If you do not see Cash Basis Sales reports in your account, contact your account manager or MoeGo Support to check availability.
The Cash Basis Sales Report is designed for business owners and accountants who use cash basis accounting.
In cash basis accounting, revenue is recognized on the day payment is received — not when the service is performed. This report reflects that logic, giving you an accurate daily picture of what money came in, broken down by item and payment method.
👉 See Smarter Invoice Reports Overview for the full list of reports in this suite.
How it works
Most MoeGo reports are based on the checkout or sale date — they show revenue when a service is completed.
The Cash Basis Sales Report is different: Cash Basis Sales reports are based on transaction date.
This means revenue is recognized when payment is collected, not only when the service is performed or the invoice is checked out.
This matters most for businesses that:
Take deposits before an appointment, stay, or service is completed
Collect prepayments before checkout
Process partial payments across multiple dates
Need to review revenue using cash basis accounting
A customer pays a deposit on June 1 and checks out on June 10. The same invoice can affect different reports on different dates because each report answers a different question.
Report type | What it focuses on |
Sales report | The sale connected to the checked-out invoice |
Payment report | The payment transaction on June 1 |
Cash Basis Sales report | Revenue based on when payment is received, depending on cash-basis logic |
💡 Example: If a client pays $100 toward a $200 invoice on November 1st, this report records $100 of revenue on November 1st — not on the checkout date.
⚠️ Note: This report is strictly about cash received. It does not replace the standard Sales Summary or Sales Invoice reports — those remain the right choice for businesses on accrual/checkout-date accounting.
Cash Basis Sales report types
Report | What it shows | Best for |
Cash Basis Sales | Summary-level cash-basis sales totals | Reviewing revenue by payment timing |
Cash Basis Sales Detail | Detailed rows behind the cash-basis total | Investigating which invoices, payments, methods, items, or categories make up the total |
What each payment captures
Payment type | Tip | Tax | Collected sales |
Deposit (before checkout) | No | No | Yes — allocated by item |
Prepayment (before checkout) | No | No | Yes — allocated by original item price ratio |
Full payment at checkout | Yes | Yes | Yes — allocated by item price ratio |
Partial payment at checkout | Yes (allocated first) | Yes (allocated second) | Remaining balance by item price ratio |
Refund | Reversed | Reversed | Reversed at item level |
📝 Note: For partial payments, tip and tax are always allocated before the remaining balance is distributed across items.
What the report shows
Metrics & Definition
Each row represents the collected revenue for a specific payment event, broken down by:
Collected sales — the portion of that payment attributable to each service item
Tips — tip amount collected in that payment
Tax — tax amount collected in that payment
Payment method — cash, credit card, ACH, or store credit
Revenue category — if Revenue Categories are configured, each item maps to its assigned category
📝 Note: Deposits are tracked for item allocation purposes but are not counted as revenue until payment is collected at checkout. They are recorded as a liability until that point.
Filters and controls
Control | Options |
Date range | Filter by the date payment was collected |
Business | Filter by location (multi-select) |
Payment method | Cash, Credit card, ACH, Store credit |
Revenue category | Filter by configured revenue categories |
Download | Export to CSV |
How to access the report
Go to Report > Insights in the main navigation.
Select the Reports tab.
Find Cash Basis Sales Report in the Finance category.
When to use Cash Basis Sales
Use Cash Basis Sales when you want to answer questions like:
How much revenue did we receive during this date range on a cash basis?
Which Revenue Categories contributed to cash-basis revenue?
How much net sales came from each category, tax, or tip row?
How does cash-basis revenue compare across periods?
When to use Cash Basis Sales Detail
Use Cash Basis Sales Detail when you need to inspect the rows behind the summary.
This is useful when:
A cash-basis total does not match what you expected
You need invoice, payment, or item-level detail
You need to understand how payments, refunds, deposits, or applied balances affected the total
You want to check Revenue Category assignment for specific rows
You want to review payment method details, such as cash or card payments
Understand Cash Basis
Why Cash Basis Sales may differ from Sales Summary
Sales Summary focuses on what was sold. Cash Basis Sales focuses on when payment was received.
Scenario | Why totals may differ |
Customer pays before checkout | Payment may appear before the sale is checked out |
Customer pays after checkout | Sale may appear before the payment is received |
Refund happens later | Refund may affect a different date range |
Deposit is applied | Deposit and revenue timing may follow cash-basis logic instead of checkout-date logic |
Cash basis is not payout reconciliation
Cash Basis Sales can help you review revenue based on payment timing, but it is not the same as your bank payout.
Your payout may differ because of:
Payment processor settlement timing
Processing fees
Refund timing
Chargebacks or adjustments
Payout schedule
Other processor-side activity
⚠️ Important: Do not use Cash Basis Sales as the only source for reconciling bank deposits or processor payouts.
Revenue Categories in Cash Basis Sales
If Revenue Categories are set up, Cash Basis Sales can help you review cash-basis revenue by category.
If an item is missing a Revenue Category, it may appear as Category not assigned or a similar uncategorized value.
💡 Tip: If your cash-basis report has too many uncategorized rows, review your Revenue Category setup first.