Fitness Studio or Gym QuickBooks CleanupEach charge needs its own item
A draft and a deposit are two pictures of one morning.
Steven Palmieri, a Tax CFO and the Entrepreneur's CFO, puts each kind of charge on its own QuickBooks item, sets trainer pay up with the provider the studio already runs, and prepares the return from a month that already agrees.
Which item got mixed
You will be talking to the Steven Palmieri practice.
The Tax CFO way with a studio export
An accountant can sort the items after the month has already closed. The Tax CFO job is the split you still have time to make, while that month can still be changed. Floor time, a class, and a bottle at the counter each keep an item. The deposit is rebuilt from those items. The return follows the month that already agrees.
Dues stay off the class
Floor time and a scheduled class are two products. They do not share an item.
Click to see dues and a class ›Tap to see dues and a class ›One item, two jobs
When one item holds two charges, a price change cannot say which one moved.
Click to see the shared item ›Tap to see the shared item ›
The bank kept a cut
The export shows the gross. The bank shows what was left after the card company.
Click to see the net deposit ›Tap to see the net deposit ›Can they share
One question, answered from the file. The share is a bookkeeping problem first.
Click to read the answer ›Tap to read the answer ›
The export is the journal
The billing file lists what members were charged. The bank feed is only the lump.
Click to open the export ›Tap to open the export ›Three different rows
A failed draft, a freeze, and a reversal are not one missing deposit.
Click to see the three rows ›Tap to see the three rows ›Six rows before the deposit is trusted
Open one row when a charge is mixed. The row says what we will separate and what we will leave alone.
1Floor time and a class share one item
We split them before any total is trusted
A later price change has to hit one charge. It cannot rewrite the other.
2The bank is shorter than the export
We look for the cut the card company kept
That cut is a cost of collecting. It is not a smaller sale.
3A freeze still drafted
We want the pause date next to the row
A pause and a sale are different events, even when the software ran both.
4Money that landed was pulled back
We tie the reversal to the original row
A reversal with no twin leaves the member balance as a story.
5A bottle rode on the dues item
We give the counter sale its own item
Retail and floor time do not belong in one bucket if the deposit has to be rebuilt.
6Trainer pay has no login
We set the provider up in the studio's name
The click that sends pay stays with that provider. We stop at setup.
Steven Palmieri
Tax CFO. The Entrepreneur's CFO. The studio export, the month, and the return stay together here so a year is not split across vendors who never see the same file.
Why the export comes before the bank
A studio morning produces two records that do not look alike. The billing export lists every charge, member by member. The bank shows one deposit, or a few deposits, after the card company has taken its cut. QuickBooks will happily accept the bank line as income. That acceptance is how a file starts to lie.
The cleanup starts in the export, not in the feed. Each kind of charge gets an item of its own. Floor time is one item. A class on the schedule is another. A private session is a third. A bottle or a shirt at the counter is a fourth. The cut the card company kept is an expense, not a discount on the sale.
Once those items exist, the deposit can be rebuilt. The gross closes the charges. The cut is booked as the cost of collecting. The bank then matches a number someone can explain. Until that split exists, a reconciliation is a shrug.
We look at the export together on a screen share, from wherever the studio already works. The export is a file. Nobody is asked to stand at a front counter for the conversation. The same practice that splits the items closes the month and prepares the return those months support.
What a cleanup week actually touches
The first sitting is the export and the bank for the same stretch of days. We mark which charges are sharing an item, which deposits are short by a fee, and which rows are a freeze, a failure, or a reversal. Nothing is renamed until that list is plain.
Lines that look like member money but have no name go to a temporary account on the balance sheet. They stay visible. They are not buried in sales to make a report look finished. A line leaves that account only when a document says what it was.
Bank rules come after the items, not before. A rule written while everything still posts to one income account will keep stuffing the lump. We would rather have no rule than a rule that hides the mix.
Trainer pay is a separate conversation. If people are being paid and there is no payroll login, we set the provider up in the studio's name. The provider runs payday. We do not.
The return waits on closed months. A forward guess about a year, built on an open export, is a guess we will not print.
What we will not pretend the file already did
We will not call a net deposit the sales number. We will not leave a class and floor time on one item because the software drafted them together. We will not treat a freeze as income that already happened, and we will not treat a reversal as a deposit that went missing.
Audit, review, and compilation signatures are not offered on a studio file. If a bank asks for an attest report, that request is declined before any item name changes. The disclosures page spells the refusal out for this work.
A hypothetical on this site has no studio name and no member balance. If you want the work on your own export, that starts when both sides sign a scope.
Bring the export
You will be talking to the Steven Palmieri practice.