Report for *actual* income??? Cash/check + Stripe (minus fees) combined?
Answered
Where can I find a report that shows my *actual* income for all sessions? So:
- All payments,
- In a given period,
- Listed by session,
- Cash, check, card etc, MINUS any Stripe fees?
- Income Allocation, Invoices, Export Transaction Reports gives a CSV of all appts but do NOT factor in Stripe fees so it does not show my actual income.
- Card Transactions and Payouts Reports show the actual fee but only for card payments so that doesn't help.
It seems very odd that there are several different reports that do the same thing (and only offer partial data) and none that give the full data. This super basic so I must be just missing it.
-
Hi Jenny,
The one report that takes into account Stripe fees will be the Card Transactions page. This report can be exported by pressing the Export option in the upper right corner. The Fee column can be highlighted and summed to give you the total Stripe fees for all appointments within the given date range.
Our one report that indicates income earnings and a break down of appointments would be the Income Allocation report. Notably, it is essential that appointments are invoiced/billed and that payments have allocated (paid) toward those invoices/claims.
The Income Allocation report will then tell you the grand total of all allocations (what invoices/claims got paid) that occurred within the given timeframe, which is your total income. There will be a Download Report button in the upper right corner which will give you the session breakdown.
Subtract the Stripe fees from that total and this will get you the total income, session breakdown, and net totals after processing fees. -
Thanks but that doesn't help with what I need... an easy way to calculate the average session fee for a given time period.
I could follow those steps but I would have to also count up the number sessions and then math it out. And since different services/billing codes have different costs, it really muddies up the information.
It's also more work than my current work around of using an excel macro to calculate a rough estimate of the Stripe fees and subtracting it out that way.
I understand why that option works from an accounting standpoint but from a business/practice management standpoint, it's really lacking. Average session fee (minus any processing fees) is a super basic metric so it's a real omission. There should be an easy, one step report for that.
Post is closed for comments.
Comments
9 comments