Revenue Explorer
The Revenue Explorer shows your organization's revenue for a date range, in one place. You can break it down by stream, facility, item, customer, or payment method. You can compare it with an earlier period, open the invoice lines behind any number, and export to Excel.
On a paid plan, the Earned view is your revenue number.
Who can open it
The Revenue Explorer is available on paid plans, to anyone with the View Organization Statistics permission. Account owners have this permission. If you do not have it, ask your account owner.
To open the explorer, go to Reports and select Open Revenue Explorer at the top of the page.
Earned and Cash collected
The Show switch changes what the page counts.
| View | What it counts | What it leaves out | Dated by |
|---|---|---|---|
| Earned (the default) | Sales on Open and Paid invoices, at the adjusted price, less refunds of those sales | Reservation Deposits, store credit sales, and sales tax | The invoice date. A refund is dated by the refund date. |
| Cash collected | Payments you received, less refunds you paid back out, whatever the invoice's status is now | Complimentary, store credit, and deposit-applied payments, refunds to store credit, and sales tax | The payment date. A refund is dated by the refund date. |
Each view answers a different question:
- Earned tells you what your business earned. An Open invoice counts, even if the customer has not paid it yet. A deposit does not count when it is paid, because the stay has not happened yet. The stay counts when it is invoiced.
- Cash collected tells you what money came in. A deposit counts on the day it is paid. If you void an invoice later, its payment stays on the date you received it.
The cards at the top of the page follow the view. Earned shows Net revenue, Gross sales, Discounts, and Refunds. Cash collected shows Cash collected (net), Card payments, Cash, and Refunds paid out.
Choose the dates and filters
Filters apply as soon as you change them. There is no Apply button.
- Quick ranges: This month, Last month, This quarter, or Last 12 months.
- From and To: Any date range. The page opens on the current month.
- Compare to: Same period last year (the default), Same weekdays last year, Previous period, or No comparison.
- Facility: All of your facilities, or one of them.
- Stream: All streams, or one of them.
The explorer covers up to two years at a time. If you ask for more, it shows the two years ending on your last date, and a note on the page says so.
If your range runs past today, the cards and the table compare only the days so far, and they say "prior to date". The chart still shows the whole comparison period.
Read the projection
When the Earned view covers a range that has not ended, a Projected tile estimates the total for the whole range. It has three parts:
- Earned so far: What the range has earned to date.
- On the books: Reservations that have not been invoiced yet. Canceled reservations are left out.
- Expected, not yet booked: What Petsoft expects beyond your reservations, based on last year and recent growth.
The projection is an estimate. It makes no allowance for reservations that cancel later. If stays in the range are past their departure date but not invoiced, a note on the tile tells you. They are not part of the total.
Expected revenue is only split by stream. When you break down by facility, item, or customer, the column is Projected (booked): earned so far plus what is on the books.
Break down and drill down
Under Break down by, select Stream, Facility, Item, or Customer. Cash collected also offers Payment method. The table shows the top 100 rows. The export has every row.
Select a row to see its lines: the invoice, date, facility, customer, item, status, gross, discount, refunded, and net. Use Find to search by invoice number, customer, or item. Select an invoice number to open the invoice.
Export to Excel is on both the main page and the lines page. The lines export has every matching line.
If your account has access to an enterprise, the All organizations button shows net revenue across its organizations.
Schedule an export
Select Schedule to get a daily or weekly email with a link to your Excel file. Choose how often and whether it shows Earned or Cash collected. A daily email covers the day before. A weekly email covers Monday through Sunday. If an email is missed, the next one covers the days you missed, up to 14 days.
The email itself has no revenue in it. You sign in to download the file, and the file shows what your access allows that day. If you lose access, the schedule turns off and shows why under Your schedules. You can turn a schedule off there at any time.
If your account has access to an enterprise, you can also schedule totals for all its organizations, from the All organizations page or here. Those exports show totals only, on the earned view. You manage them on the All organizations page, which also lists your schedules and lets you turn one off.
When the totals update
The page reads saved daily totals, and the latest days are live. A note on the page shows when the totals were last updated. A recent change appears within about an hour. A change to an older invoice, such as voiding it, can take until the next day. Until then, the lines you drill into can differ from the total above them, because lines are always live.
Why the totals differ from other reports
Every revenue report keeps its own definition, so their totals will not match the explorer's. A difference does not mean a report is broken. Each one answers a different question.
| Report | The question it answers | How it differs from the explorer |
|---|---|---|
| Sales Revenue Report | What was invoiced and paid, with everything on those invoices | Also counts deposits, store credit, and tax. Does not subtract refunds. Leaves out Open invoices. |
| Customer Revenue | What each customer spent | Also counts store credit and tax. Does not subtract refunds. Leaves out Open invoices. |
| Credit Card Revenue Report and other card reports | What settled, so you can tie it to your processor | Card payments only, by payment date. See the Financial Reporting Guide. |
| Store Credit and Remaining Balance | What balances are outstanding | These are balances, not revenue. |
| Invoice Revenue Reconciliation | Why Sales Revenue and Credit Card Revenue differ | It explains the gap between those two reports. |
| Year-End Deliverables reports | Which services and their payments fall on either side of the new year | These are for year-end work, not a period's revenue. |
The notice on Sales Revenue and Customer Revenue
On a paid plan, Sales Revenue and Customer Revenue show a notice. Both will be removed in an upcoming release, and until then you can still run them. The other reports in the table above stay.
The Free plan does not include the Revenue Explorer. Sales Revenue stays on the Free plan and is your revenue report there. Deposits inflate it, because a deposit counts when it is paid and the stay counts in full when it is invoiced.
If you see the notice but cannot open the explorer, ask your account owner for the View Organization Statistics permission.
Where to find sales tax
The Revenue Explorer never counts sales tax as revenue, and it does not list it. Today, sales tax appears here:
- Payment Method Summary shows Sales Tax and Tax Refunded for each payment method. This report stays.
- Sales Revenue Report shows Sales Tax for each item. On a paid plan, this column goes away when the report is removed.
If your accountant uses the tax column on Sales Revenue, tell them now, while the report is still available.
Still stuck?
Our team is happy to help. Reach out and we'll get you back on track.
Not a Petsoft customer yet?
These are the same guides our customers use. Prices are on our site, and the demo is a working account with sample pets and bookings already in it.