Every tutoring agency, at some point in its journey, faces the dilemma of juggling several aspects, including student bookings, tutor sessions, payout splits, commissions, refunds, gateway fees, and tax reporting. When money flows in different directions simultaneously, a single error can ripple through your finances.
It is where monthly reconciliation can feel like your financial safety net. When starting your tutoring agency, if you prioritize operational control, it is important to reconcile your split payments each month to ensure smooth operations.
This guide provides a highly actionable, step-by-step system for auditing split payments, detecting errors early, and keeping both your tutors and your accountant happy.
Why Monthly Reconciliation Matters More Than Ever?
Automated split payments are the backbone of a successful tutoring agency. Especially when you use tutoring or tutor management software, your financial ecosystem has many touchpoints. Reconciliation is how you ensure that all those touchpoints communicate properly with each other.
Why reconciliation is needed every month:
- Prevents tutor underpayments or overpayments
- Detects duplicated charges or missing commission
- Ensures GST/VAT filings are accurate
- Protects business profitability
- Builds tutor trust with transparent payouts
- Keeps your agency audit-ready
- Helps you scale confidently when you expand your tutoring business
Blueprint for Step-by-Step Monthly Reconciliation
Confusing logs and scattered spreadsheets can become a burden for a tutoring agency. Tutoring agencies can use a refined workflow, making the whole process much smoother and more efficient.
Here is the step-by-step process that you can follow for monthly reconciliation:
Step 1: Start With a Complete Data Pull
For accurate reconciliation, it is necessary to pull the complete data. Gather everything, no assumptions, no shortcuts.
Here is the data that you must download or export:
- Student payment logs from your tutoring software
- Tutor payout reports
- Commission summaries
- Bank settlement statements
- Refund and chargeback logs
- Tax/GST/VAT summaries
- Session data from your tutor scheduling software
Pro-tip: Always export in CSV or Excel for easy comparison
Step 2: Set Up a Clean, Accountant-Friendly Reconciliation Sheet
A spreadsheet can neatly record all the information. You can opt to create more than just one tab to organize everything. It is wise to include different tabs, such as:
- Transactions Master: Every student’s payment
- Tutor Earnings: Earnings before payouts
- Agency Commission: For every session
- Adjustments: Refunds, cancellations, bonuses
- Bank Match: What hit your bank
- Exceptions: Discrepancies needing investigation
Step 3: Match Student Payments With Actual Transactions
Your first major checkpoint needs to be – what the student paid vs. what your system recorded. If your tutoring software integrates with your gateway, this step is easier, but it is still best to never skip it.
Here are some of the things that you need to check:
- Payments captured but not logged in the software
- Sessions logged, but payment is missing
- Wrong discounting
- Duplicate charges
- Price mismatches due to outdated session rates
Step 4: Audit All Split Payment Breakdown
Split payments are very simple and convenient until they are not. One wrong percentage can lead to a mistaken interpretation of your whole month’s numbers. In fact, incorrect splits can lead to payout disputes. It is necessary to verify things like:
- Tutor rate matches contract details
- The commission percentage is right
- Session duration is correct
- GST/VAT is correctly applied
- Bonuses and penalties are mapped correctly
Step 5: Detailed Verification Tutor Payouts Detail
Tutor payout accuracy is very important for correct reconciliation. Happy tutors mean stable operations. The review process can become even faster and more accurate if you use tutor management software.
Make sure to review:
- Every completed session is included
- Cancelled-but-payable sessions accounted for
- Refunds deducted properly
- Extra sessions not missed
- Tutor bank details and payout dates are correct
- Negative balances handled correctly
Step 6: Reconcile Commission Earnings
As a tutoring agency, commission is your primary source of revenue. Even small errors here affect profitability. A slight percentage mismatch may look small, but across hundreds of sessions it snowballs.
Here are the things that you need to look for:
- Commission calculated BEFORE vs. AFTER discounts
- Demo/free sessions accidentally earning commission
- Inconsistent percentages
- Manual overrides not logged
Step 7: Match Settlement Data With Bank Statements
This step will ensure that your software reality matches your cash in hand. There are several aspects that you must confirm, such as:
- Daily settlements match gateway reports
- No delayed settlements
- Gateway fee deductions are accurate
- Payout charges recorded
- Total student payments reconcile with bank inflows
Step 8: Verify Refunds, Chargebacks & Adjustments
Refunds often slip through reconciliation unnoticed, which can be quite dangerous for accuracy. Refund mismatches can create hidden revenue leakage. It is therefore necessary to check the following:
- Refund is deducted from the commission
- Tutor payout adjusted
- Refund is reflected in the bank statement
- Chargeback fees included
- Credit notes are issued if needed
Step 9: Create an Exceptions Log (Your Financial “To-Do” List)
Every mismatch found must be documented to prevent recurring errors. To avoid the mismatch, ensure to track:
- Type of discrepancy
- Amount
- Affected tutor/student
- Reason
- Who must fix it
- Status
Step 10: Prepare a Complete Monthly Finance Report
Your final step is to have a clean, readable summary of the entire month. This is quite helpful for managers and investors, especially if you plan to expand your tutoring business.
It is best to include the following in the summary:
- Total revenue
- Commission earned
- Tutor payout totals
- Refunds + adjustments
- Settlement summary
- GST/VAT collected
- Outstanding issues/exceptions
Common Errors that You Must Look for in the Monthly Reconciliation
Even when a tutoring agency is organised, it can still run into financial inconsistencies. It mostly happens when the reconciliation process isn’t closely monitored.
Identifying the common errors early not only protects your revenue but also strengthens trust with tutors and ensures your tutoring software, tutor management software, and accounting tools stay perfectly aligned.
Here are the common errors that every tutoring agency needs to look out for:
- Incorrect tutor rates applied due to outdated or misconfigured settings.
- Sessions marked completed even when the tutor or student didn’t attend.
- Duplicate student charges or duplicate tutor payouts from system glitches.
- Wrong discounts are being applied, affecting the commission and revenue split.
- Tutor bonuses or penalties are missing from the final payout sheet.
- GST/VAT is being calculated on the incorrect amount or is inconsistently applied.
- Manual overrides were made without documentation or approval notes.
- Negative tutor balances left unresolved month after month.
- Payment captured by the gateway but not reflected in the software transaction log.
- Settlement amounts in the bank do not match the gateway payout breakdowns.
High-Alert Red Flags You Must Investigate ASAP
Some issues are small, while others can be financial time bombs. Here are some of the major red flags:
- Sudden spike in refunds
- Tutors are consistently underpaid or overpaid
- Frequent negative balances
- Settlement delays from the gateway
- Commission unusually low
- Sessions are missing in the system
- Large discrepancy between system revenue vs. bank inflows
Conclusions
Monthly reconciliation is a stability strategy for tutoring agencies. You can eliminate uncertainty and build a predictable, scalable business foundation by integrating your accounting system with tutoring management software. A lean, reliable reconciliation process ensures that the money always tells the truth.
Frequently Asked Questions
What is monthly reconciliation in a tutoring agency?
Monthly reconciliation is the process of comparing all student payments, tutor payouts, commission calculations, refunds, and bank settlements to ensure everything aligns accurately. It keeps your financial system clean, especially if your agency uses automated tutoring software or split payment tools.
Why is reconciliation necessary when using split payments?
Split payments involve multiple aspects like automated transfers, student fee, tutor share, and agency commission, which increases the risk of mismatches. Monthly reconciliation checks every step of the way to catch discrepancies early and protect your revenue.
How often should tutoring agencies reconcile their finances?
A full monthly reconciliation is necessary, but weekly mini-checks help catch mistakes faster. The balanced approach helps in reducing month-end stress and also helps in keeping tutor payouts accurate.
Why do tutor payout discrepancies occur?
Discrepancies have the tendency to arise from faulty tutor rates, session logs being missing, manual adjustments without proper notes, refunds not properly linked to payouts, or a mismatch in session duration.
