When a client of ours began working with our outsourced accounting team, the organization was dealing with a significant accounting cleanup issue. Their point-of-sale system, Zenoti, had not been properly mapped into QuickBooks Online, which caused a substantial amount of duplicated activity, particularly duplicated revenue. Management knew there was a problem, but the accounting records were not reliable enough to support timely decision-making.
During onboarding, we focused on three priorities:
| Priority | What Needed to Happen | Why It Mattered |
|---|---|---|
| Clean up the accounting records | Correct duplicated entries and prior-year issues | Financial reports needed to be reliable |
| Fix system mapping | Properly connect Zenoti activity to QuickBooks Online | Future transactions needed to post correctly |
| Build repeatable monthly processes | Implement bill pay, payroll, reconciliations, reporting, and meetings | Management needed timely financial information |
The end result was simple but important: the accounting became boring. That is exactly what good accounting should be.
The Client Situation
The client had transitioned to Zenoti, a point-of-sale platform commonly used by spa, wellness, and service-based businesses. However, the accounting setup between Zenoti and QuickBooks Online was not implemented correctly.
The main issue was not the software itself. The issue was the way transactions were mapped between systems.
Key Problem
The prior accounting setup caused a large amount of activity to be duplicated in QuickBooks Online.
In practical terms, this meant:
- Revenue was overstated.
- Some activity was recorded to the profit and loss statement.
- Some activity was recorded through accounts receivable.
- Management could not fully rely on the financial reports.
- Monthly decision-making was impaired because the accounting data was not clean.
This is a classic example of the phrase: garbage in, garbage out.
When the front-end system is not mapped correctly, the back-end accounting records will not produce useful information.
Why POS System Mapping Matters
For businesses that rely on a point-of-sale system, the POS platform often drives a large portion of the accounting activity.
That may include:
- Sales
- Customer deposits
- Gift cards
- Refunds
- Sales tax
- Tips
- Merchant processing fees
- Deferred revenue
- Accounts receivable
- Cash deposits
If these items are not mapped correctly, QuickBooks Online may still show activity, but that does not mean the activity is accurate.
Definition: POS Mapping
POS mapping is the process of assigning each transaction type from a point-of-sale system to the correct account in the accounting system.
For example:
| POS Activity | Proper Accounting Treatment |
|---|---|
| Service revenue | Revenue |
| Gift card sale | Liability until redeemed |
| Sales tax collected | Liability |
| Merchant fees | Expense |
| Cash deposit | Asset |
| Customer receivable | Accounts receivable, only if actually owed |
Incorrect mapping can create major reporting problems, especially when sales activity is duplicated or posted to the wrong section of the financial statements.
What We Did During Onboarding
The first phase of onboarding focused on understanding the existing accounting issue and creating a path to reliable reporting.
Step 1: Identified the Root Cause
The team reviewed the relationship between Zenoti and QuickBooks Online and determined that the system mapping was incorrect.
The problem was not simply that entries were messy. The problem was structural.
Transactions were not consistently flowing into the correct balance sheet or income statement accounts.
Step 2: Corrected the Current-Year Accounting
The team identified the reports needed from Zenoti to support proper reconciliation.
The goal was to make sure that:
- Sales agreed to the POS reports.
- Deposits agreed to bank activity.
- Revenue was not duplicated.
- Accounts receivable was only used when appropriate.
- Balance sheet and income statement accounts reflected the actual economics of the business.
This allowed management to begin receiving useful monthly financial information again.
Step 3: Cleaned Up the Prior-Year Accounting
After fixing the current process, the team also cleaned up prior-year activity related to the period after the Zenoti transition.
This was important because incorrect prior-year records can continue to create confusion, especially when comparing current-year performance to historical results.
A cleanup project like this can be significant. Depending on complexity, a full year of duplicated entries and POS accounting cleanup could easily become a substantial hourly project.
Step 4: Implemented Better Accounts Payable Processes
The team implemented Bill.com to improve the bill payment and cash disbursement process.
This helped create:
- More consistent bill payment workflows.
- Better approval processes.
- Improved documentation.
- Easier internal control review.
- A more organized accounts payable function.
For growing businesses, bill payment should not depend on informal emails, scattered approvals, or inconsistent timing. A structured AP process reduces risk and improves visibility.
Step 5: Improved Payroll Processing
The team also helped transition payroll to ADP, which made the payroll process easier to manage.
Payroll is one of the highest-risk recurring accounting functions because it affects employees, cash flow, taxes, benefits, and compliance.
A cleaner payroll process supports:
- Timely payroll runs.
- More consistent payroll records.
- Easier reconciliation.
- Better reporting by department or function, where applicable.
Step 6: Established Timely Monthly Reconciliations
A critical part of the new accounting process was timely monthly reconciliation.
The goal was to provide financial reports between the 15th and 20th of the following month.
That reporting timeline allows management to review recent results while the information is still relevant.
Step 7: Created Monthly Management Meetings
The final piece was implementing regular monthly meetings with management.
These meetings gave the client an opportunity to:
- Ask questions about the financial statements.
- Understand trends in revenue and expenses.
- Discuss cash flow.
- Review pricing decisions.
- Evaluate payroll as a percentage of gross revenue.
- Use CFO-level guidance to support business decisions.
Accounting should not stop at producing reports. The reports should help management understand what is happening in the business.
Before and After Summary
| Area | Before Onboarding | After Onboarding |
|---|---|---|
| POS integration | Zenoti was not mapped correctly to QuickBooks Online | POS activity was mapped to the appropriate accounts |
| Revenue reporting | Revenue was materially duplicated in parts of the records | Revenue reporting became more reliable |
| Accounts receivable | AR activity existed where it should not have | AR treatment was cleaned up |
| Financial reporting | Management was effectively flying blind | Reports were delivered on a consistent monthly timeline |
| Accounts payable | Process needed more structure | Bill.com improved workflow and controls |
| Payroll | Process needed improvement | ADP helped simplify payroll processing |
| Management visibility | Limited reliable data for decision-making | Monthly meetings created regular financial review |
Key Lesson: Accounting Is Supposed to Be Boring
The best outcome of this onboarding was not a flashy dashboard or complicated reporting structure.
The best outcome was that the accounting became predictable, reliable, and repeatable.
That is what “boring accounting” means.
Boring Accounting Means:
- Transactions are recorded correctly.
- Reports are delivered on time.
- Reconciliations are completed monthly.
- Bills are paid consistently.
- Payroll runs smoothly.
- Management understands the numbers.
- Decisions are based on reliable information.
When accounting is exciting, it is often because something is wrong.
Why This Matters for Small and Mid-Sized Businesses
Small and mid-sized businesses often grow into more complex systems before their accounting processes are ready.
That creates risk.
Common triggers include:
- Switching POS systems.
- Adding new locations.
- Increasing transaction volume.
- Changing payroll platforms.
- Moving to QuickBooks Online from another system.
- Implementing bill pay software.
- Expanding management reporting needs.
Each transition can improve the business long term, but only if implementation is handled correctly.
Practical Checklist for POS or Accounting System Transitions
Before switching platforms, businesses should confirm the following:
| Question | Why It Matters |
|---|---|
| What transaction types will flow from the POS system into QuickBooks? | Prevents incomplete or duplicated accounting |
| Which accounts will each transaction type map to? | Ensures activity lands in the right financial statement category |
| How will deposits be reconciled to the bank? | Confirms cash activity is complete and accurate |
| How are gift cards, deposits, or prepaid sales handled? | Prevents revenue from being recognized too early |
| Who reviews the first month of activity after implementation? | Catches errors before they compound |
| What reports from the POS system support month-end close? | Creates a repeatable reconciliation process |
| When will management receive monthly financials? | Sets expectations for timely reporting |
Final Takeaway
A strong onboarding process is not just about taking over the books. It is about understanding the accounting environment, identifying process gaps, correcting historical issues, and building a system that management can rely on.
For the client, the onboarding process moved the organization from duplicated revenue and unreliable reports to a cleaner, more consistent accounting process.
The goal was straightforward:
Turn a double-booking mess into a clean, boring, decision-ready set of accounting records.
Rosalie Claypool, CAS Manager
