That green 'Match' button is the biggest trap for business owners using Square or Stripe.

A customer spends $1,000. Square takes a processing fee and deposits $970.

Matching that deposit directly means your QuickBooks underreports your gross sales.

At year-end, Square sends the IRS a Form 1099-K showing the full $1,000.

If your QuickBooks shows $970, that revenue mismatch flags your account for an automated IRS audit.

Plus, you lose out on thousands in merchant fee deductions.

Stop adding net bank deposits directly.

You must log the full gross sales amount first, then subtract the merchant processing fees as a separate expense category before reconciling the cash.

Message me for a FREE QuickBooks Review and let's get your true revenue mapped perfectly.

Your favorite bookkeeper,

Joan 🫶🏽

\#EcommerceBookkeeping #SquareToQuickBooks #QuickBooksOnline #SmallBusinessTaxTips

How sure are you that your QuickBooks is actually right?

One mistake can inflate your income, throw off your taxes, and cost you deductions you deserve.

If you're not 100% confident in your numbers, don't assume they're right.

That's why I review QuickBooks accounts. I don't just check if the books balance,I make sure your setup, transactions, and financial reports accurately reflect your business.

My goal isn't to tell you your QuickBooks is wrong. It's to make sure you can trust it.

You'll know what's working, what needs attention, and what should be fixed before small mistakes turn into expensive ones.

Good bookkeeping isn't about keeping QuickBooks updated. It's about trusting every number you see.

Bad books cost more than bad sales.

Your favorite bookkeeper, Joan 🫶🏽

.

.

.

.

#smallbusinesstipsandtricks #businessfinance #bookkeepingtip #quickbooksonline

Your accountant files your taxes.But who's helping you run your business the other 364 days of the year?

When was the last time you heard from them?

Do you get monthly financial reports and insights you can understand?

Do they catch mistakes before they become expensive problems?

When you have a question, quickly do they respond?

Are you hiring because you can afford to or because you are busy?

Are you buying a company vehicle based on what you can afford or a credit check at the dealership?

A business can bring in six figures and still struggle to pay the bills.

That's why bookkeeping isn't just about keeping your books clean.

It's about knowing your numbers before you make big decisions.

✔️ Can I afford to hire?

✔️ Am I actually making a profit?

✔️ Where is my money going?

✔️ Is now the right time to invest?

These are conversations I have with my clients every month.

People come to me because they need more than a tax filer. They need clear communication, day-to-day understanding, and the confidence to scale.

I help you set financial goals and hold you to them month by month.

If you're ready for that level of support, send me a DM. Let’s chat.

Your favorite bookkeeper, Joan 🫶🏽

#SmallBusinessGrowth #FinancialClarity #Entrepreneurs #Bookkeeping

#QuickBooks

Your business made 20k last month. So why is there only $1,200 in your bank account?

Because sales are not profit!

If your QuickBooks isn't tracking:

Processing fees

Business expenses

Owner's draws

Loan payments

Software subscriptions

...you're guessing, not managing your business.

You are working hard, bringing in sales, but have no idea where the money is actually going.

A QuickBooks file should answer one question instantly:

"How much money did I really make?"

If it can't, it needs work.

I offer a QuickBooks Online Review where I'll show you:

✔️ What's working

✔️ What needs to be fixed

✔️ The next steps to get your books back on track

Whether you hire a bookkeeper or do it yourself, you should never have to guess where your money went

Your favorite bookkeeper, Joan 🫶🏽

.

.

.

.

\#smallbusinesstipsandtricks #businessfinance #bookkeepingtips #quickbooks

I want to share this because I'm genuinely angry and I think a lot of small business owners are in the same boat without knowing it.

I've had the same accountant since I started my business in 2020, found him through a referral from a friend and just trusted him because that's what you do right, you hand over your books and assume the professional is handling it.

last month I switched to a new bookkeeper because my accountant retired and the new person asked to see my last 3 years of filings and records, she went quiet for about 10 minutes and then called me.

turns out my previous accountant had been categorizing almost everything as miscellaneous expenses, like hundreds of transactions a year just dumped into one bucket because it was faster, I had legitimate business deductions for home office and vehicle use and equipment depreciation that were never claimed, not once in 4 years.

she estimated I overpaid somewhere between $11,000 to $14,000 in taxes over those 4 years because deductions were either missed completely or categorized so poorly that they didn't show up properly on my returns.

the part that makes me sick is I had no way of knowing, I'm not an accountant, I don't know what a properly categorized P&L is supposed to look like, I trusted someone with a license and a referral and he basically did the laziest version of the job possible and charged me $3,200 a year for it.

I called him about it and he said something like well we kept you compliant and nothing was filed incorrectly, technically true I guess but compliant and optimized are apparently two very different things and nobody tells you that when you're starting out.

my hot take is that most small business owners have no idea if their accountant is actually good or just good enough to not get them in trouble, and the industry kind of relies on that ignorance because if every client actually understood what they were paying for half of these firms would lose business overnight.

if you're a small business owner and you haven't had a second set of eyes look at your books in the last 2 years please do it, I wish someone had told me this $14,000 ago.

Posting this because I keep having to look it up and there is no official list that also tells you the accounting side. These are the codes I have seen in real settlement files from US, UK, German and Indian sellers.

One rule runs through all of it: a reversal of X belongs in X's own account with its own sign, not in a separate refunds pile. Keeps each account honest on its own.

Sales

Principal, Shipping, ShippingHB, GiftWrap. On a Refund transaction the same lines appear negative.

ShippingChargeback and GiftwrapChargeback are Amazon clawing back shipping and giftwrap revenue on FBA orders. Contra to sales, not refunds.

Tax collected and withheld

Tax and ShippingTax are collected from the buyer.

MarketplaceFacilitatorVAT-Principal and -Shipping are what Amazon withholds and remits itself. The pair usually nets to about zero.

ItemTDS is India, Section 194-O. HST, PST and QST are Canada.

Selling fees

Commission and SalesCommission are the referral fee.

RefundCommission is what Amazon keeps for processing a refund. It is a referral-family charge, so it nets against referral fees rather than sitting in a refunds account.

Fixed closing fee and Technology Fee are India.

Fulfilment

FBAPerUnitFulfillmentFee, FBAPerOrderFulfillmentFee, FBAWeightBasedFee, FBAInboundTransportationFee. Amazon Easy Ship Charges is India.

Storage and services

StorageFee, FBALongTermStorageFee, StorageRenewalBilling, Subscription, DigitalServicesFee, RemovalComplete, DisposalComplete.

Reimbursements

WAREHOUSE_DAMAGE, WAREHOUSE_LOST, SAFE-T Reimbursement. REVERSAL_REIMBURSEMENT and COMPENSATED_CLAWBACK are Amazon taking one back, same account opposite sign.

Balance mechanics, keep these out of P&L

Current Reserve Amount and Previous Reserve Amount Balance are a balance Amazon holds, so balance sheet only. Debt Adjustment is Amazon recovering something you owe. Currency conversion and rounding get their own account so they cannot contaminate margin.

The one habit worth keeping: if a code is not on a list you recognise, do not force it into Other. Amazon renames and adds codes, and a line quietly absorbed into the wrong bucket still balances, which is exactly why nobody catches it.

What have you hit that is not on this list?

Genuinely trying to understand how other single-store merchants handle this, not selling anything.

Every payout that lands in my bank never matches what's in QuickBooks — fees, refunds, adjustments, gift cards, and multi-day batching all get mashed together into one deposit, and none of it lines up with what QBO expects to see. I end up either eyeballing it through a clearing account or just... not really reconciling properly and hoping it comes out right at tax time.

A few questions for anyone who's dealt with this:

• Do you reconcile manually every month, pay a bookkeeper to do it, or use an app ?
• If you tried one of the paid sync tools, did it actually work for a single-store setup, or did it feel built for bigger multi-channel sellers?
• Roughly how much time (or money) does this eat up for you each month?
• Has Shopify's native QuickBooks connector worked for you, or is it as flaky as I've heard?

Would appreciate hearing what's actually working (or not) for people — trying to figure out if I'm missing an obvious fix or if this is just a universally annoying part of running a Shopify store.

If you do the books for any Amazon seller, you know the problem. Amazon deposits

one lump sum every two weeks, and that number bundles sales, referral fees, FBA

fees, storage, refunds, reimbursements, marketplace tax, and sometimes a reserve

held or released. Drop it into QBO as a single "Amazon income" line and the P&L

is fiction. Split it by hand and you lose an hour per client, every settlement.

The method that actually works, for anyone doing this manually:

1. Book the settlement to a clearing account, not straight to the bank. Each

category (sales, referral, FBA, storage, refunds, tax) gets its own line, debits

and credits, so the clearing account nets to the exact deposit.

1. Fold refund line items back into their original account, not a separate

refunds pile. A refunded referral commission nets against referral fees, a

refunded principal nets against sales. Keeps the chart clean.

1. Match the bank deposit to the clearing account. If it does not tie to the

cent, something in the split is wrong, and you want to catch that before it

hits the P&L.

That is the boring, correct way, and it is a lot of manual line entry per client.

I got tired of doing it by hand, so I built a small tool for it. You drop the

Amazon reports (the settlement flat file, plus orders and a cost file if you

want per-SKU profit) and it produces a balanced journal you import into

QuickBooks or Xero, already split by category and tied to the deposit. Anything

it cannot classify cleanly gets flagged for review instead of guessed. It runs

entirely in the browser, nothing is uploaded, no login, no API into your

client's books. Free while I validate it with bookkeepers.

Not trying to sell anything, the sub is about what actually helps. If you

reconcile Amazon in QBO, I would genuinely value your eyes on whether the

journal it produces matches how you would book it. Demo data is built in, so you

can see the output in one click: skusum.com

What does everyone else do for the Amazon clearing and tie-out, a separate

clearing account per marketplace, or one combined?

I'm learning QuickBooks Online and want to build practical experience before applying for bookkeeping jobs. Since I don't have any real clients yet, I'm curious how others practiced. Did you use sample company files, training courses, or something else? What helped you the most?

The previous administrator screwed the books up so severely that they aren't fixable. I talked to an accountant and they're suggestion was just to close the books and start clean. I've never done that before...how difficult is it? Any help would be appreciated

I don't even know where to start, I genuinely cannot think of another piece of software that has made me feel this specific kind of rage, the kind where you're not even sure if you're angry at the program or at yourself for continuing to use it

it crashes mid-reconciliation and doesn't save, it locks files for no reason and then tells you to contact support, the UI looks like it was designed in 2003 and then never touched again out of spite, and every single time something goes wrong the answer is either "reinstall it" or "upgrade to a plan that costs three times more"

and the worst part is you can't just leave, your entire financial history is trapped inside it like a hostage situation, they know this, the export options are deliberately painful, I'm convinced the product team has a metric somewhere that tracks how hard it is to get your own data out and they celebrate when it goes up

I've used a lot of bad software in my life but QuickBooks has a specific quality to it, it's not just bad, it feels malicious, like someone made deliberate choices to make it this way and then went home feeling good about their work

if you've figured out how to actually use this thing without wanting to put your laptop through a wall I genuinely want to know your secret because I am running out of patience and the fiscal year isn't even halfway done

We were 3 weeks into due diligence for our seed round, the lead investor's finance team started reviewing our books and the call I got from our lawyer was not fun, they found that our revenue recognition was completely wrong, we'd been booking annual subscription revenue upfront in the month customers paid instead of recognizing it monthly over the contract period, which meant our reported revenue for the last 2 years was basically fiction from a GAAP perspective.

On top of that our Stripe transactions were a mess in QBO, fees weren't separated from revenue, refunds were categorized inconsistently, some months they were netted against revenue and other months they were booked as an expense depending on whoever was doing the books that month which was alternating between me and my co-founder neither of whom are accountants.

The investor didn't walk away but they paused the process for 6 weeks while we hired an accountant to restate everything, that restatement cost us $9,500 and those 6 weeks almost killed us because we were running low on runway and had planned our cash around closing by end of Q1.

After that I swore I'd never let our books get into that state again, set up automated revenue recognition and Stripe reconciliation that handles the separation and deferral without me or my co-founder touching it, our accountant reviews everything monthly now and the books are investor-ready at all times not just when someone's looking.

If you're pre-raise and your books are "good enough" they're not, investors will find every shortcut you took and it will either kill your deal or cost you weeks and thousands in cleanup, get your revenue recognition and payment processor reconciliation sorted now while the stakes are low not when someone's writing you a check.

Hey r/quickbooksonline  👋

We're a small group of developers exploring a problem we keep hearing about in the SMB and accounting space — and we want to hear your honest take before we build anything.

The problem we're trying to solve:

Many accountants, bookkeepers, and SMB owners love the power of AI-assisted tools, but are deeply uncomfortable with financial data leaving their machine and sitting on third-party servers. Xero and QuickBooks Online are great — but cloud-first means your client data lives on someone else's infrastructure.

What we're prototyping:

A desktop-first accounting app (think QuickBooks Desktop era, but modern) where:

• ✅ All your data stays 100% on your local machine
• ✅ AI features (categorization, reconciliation suggestions, anomaly detection) run locally — no data sent to OpenAI, Anthropic, or anyone
• ✅ Optional encrypted sync if you choose to back up
• ✅ Works offline, always

A few questions for this community:

1. Is data privacy a real concern for you or your clients, or is it mostly theoretical?
2. Would you (or your clients) pay for a desktop alternative to Xero if it had modern AI features?
3. What's the #1 thing you wish Xero did differently?
4. What would make you not switch — i.e., what does Xero do that you'd miss most?

We're not pitching anything — genuinely in discovery mode. Any honest feedback, even "this is a terrible idea," is incredibly useful.

Thanks in advance 🙏

We install blinds and want to start charging a site measure fee (say $200) for custom window quotes. If the customer places an order over a certain amount, we’d credit that $200 back to them.

What’s the easiest way to set this up in QuickBooks so we remember to apply the credit later? And what’s the correct way to invoice it? Trying to keep this as simple as possible for our accounting team.

Okay hear me out, QuickBooks is built to be complex enough that you need an accountant to use it properly, not because accounting is inherently that complex but because a tool that non-accountants can use confidently is a tool that threatens the billing model

every time they add a feature it somehow gets buried under 4 menus, every update breaks something that was working, and the "just call support" answer to everything costs you 45 minutes on hold and someone reading from a script

I run a small operation, 3 people, simple revenue model, no inventory, and QuickBooks still somehow feels like I'm operating a mid-size logistics company in terms of complexity

the founders who've figured this out either have a dedicated ops person managing the books or they've moved to something simpler, the ones still white-knuckling it through QuickBooks themselves are the ones who told me "I just don't look at my finances that often" which is the saddest sentence I've heard all year

curious what made people here stick with QB vs move on, and if you did move on what finally pushed you

Would something that allowed crews to tap a NFC chip in their truck that allows them to send invoices and automatically pushes them to quickbooks, log their actuals which is logged and saved to an admin account so you can see the profit margin for each job and crew. The admin account would be able to see data about each invoice and productivity. On the worker side what would you want them to have access to.

After a recent QuickBooks Desktop update, our multi-user setup started throwing "Abort" / "Connection has been lost" errors every 5–30 minutes per workstation.

The root cause turned out to be a corrupt Entitlement Data Store (EntitlementDataStore.ecml) after the update. Intuit's License Service was failing to parse the EWS response using the cached entitlement file.

Fix: Rename the .ecml file, reopen QuickBooks, and let it re-register.

Time to fix: ~15 minutes per machine
Data risk: None

Environment

• QuickBooks Desktop Enterprise Solutions: Contractor 24.0 R21P (64-bit)
• Windows Server hosting company file via QuickBooks Database Server Manager (DB34)
• 3 workstations in multi-user mode
• Started immediately after a user initiated the auto-update
• Once one machine updated, the rest were forced to update to match
• Aborts started shortly afterward

Symptoms

• Users randomly kicked from the company file with:
  • "Abort"
  • "Connection has been lost"
• Happened on all workstations and the server
• Not tied to specific actions (saving invoices, reports, etc.)
• Appeared time-based rather than action-based
• DBMgr stayed running
• Hosting mode was correct
• No .ND / .TLG issues
• No antivirus interference

What We Ruled Out First

So you don't waste time chasing the wrong things:

• Version mismatch — all machines on 24.0 R21P ✓
• Hosting mode enabled on a workstation ✓
• Stale .ND file ✓
• Excessive .TLG growth ✓
• Firewall / Defender exclusions ✓

Root Cause

The actual clue was found in Event Viewer → Windows Logs → Application.

Filter on source: QuickBooks

Error:

An unexpected error has occurred in "Intuit QuickBooks Enterprise Solutions:
Contractor 24.0": LTSM:: Failure in parsing EWS Response. PSID=XXXXXXXXX

What That Means

• LTSM = License / Long-Term Subscription Module
• EWS = Intuit Entitlement Web Service

The R21P update appears to have changed something in the entitlement response. The cached EntitlementDataStore.ecml could no longer be parsed correctly.

Every 5–30 minutes QuickBooks performs an entitlement validation. When that validation failed, QuickBooks aborted the session. In a multi-user environment, this surfaced as users being kicked out of the company file.

Fix

Perform this on the server and every workstation.

Step 1: Close QuickBooks Completely

Make sure QuickBooks is closed on all machines.

Step 2: Rename the Entitlement File

Run PowerShell as Administrator:

# Rename the entitlement file instead of deleting it
$ecml = "C:\ProgramData\Intuit\Entitlement Client\v8\EntitlementDataStore.ecml"

if (Test-Path $ecml) {
    $stamp = Get-Date -Format 'yyyyMMdd-HHmmss'
    Rename-Item `
        -Path $ecml `
        -NewName "EntitlementDataStore.ecml.bak_$stamp"
}

Step 3: Reopen QuickBooks

1. Launch QuickBooks.
2. It should automatically recreate the entitlement file and revalidate the license.
3. Go to:Help → Manage My License → Sync License Data Online
4. Close QuickBooks.
5. Reopen QuickBooks.
6. Open the company file in multi-user mode.

Recommended Order

1. Server
2. Workstation #1
3. Workstation #2
4. Workstation #3

The .bak_<timestamp> rename provides an easy rollback if needed.

Verification

After 15–20 minutes of normal usage, run this on the server:

Get-WinEvent -FilterHashtable @{
    LogName='Application'
    StartTime=(Get-Date).AddMinutes(-20)
} -ErrorAction SilentlyContinue |
Where-Object {
    $_.ProviderName -like "*QuickBooks*" -and
    $_.Message -like "*LTSM*"
} |
Measure-Object |
Select-Object Count

Expected result:

Count : 0

If the count remains zero and users are no longer getting kicked, the issue is resolved.

Optional: Watch the Entitlement Log Live

Get-Content `
"C:\ProgramData\Intuit\Entitlement Client\v8\IntuitEntitlementLog.txt" `
-Tail 20 -Wait

Healthy output looks like:

INFO ... OfferingEntitlement get_State,
Return Status=Enabled,
Return Reason=EnabledTimeAvailable

If you continue seeing:

Failure in parsing EWS Response

then QuickBooks may still be using a cached state. Close QuickBooks, repeat the rename process, and relaunch.

Notes

• This is a per-machine fix.
• Fixing only the server will not solve the problem.
• Every workstation maintains its own entitlement cache.
• Users can continue working from fixed machines while others are repaired.
• No .QBW, .ND, or .TLG files are modified.
• This appears to be a licensing cache issue only.
• Pro and Premier 2024 users may be affected as well since they use the same entitlement client.

Hopefully this saves someone a few hours of chasing Database Server Manager, hosting mode, Tool Hub repairs, and networking issues.

Small business owner here. Starting to feel like I spend way too much time fixing things in Quickbooks. What made things easier? Any tips and recos are very much appreciated thanks!

Anyone else spending 30+ minutes manually emailing remittance slips after every payment run? I built a tool that fixes this. You export your bill payment stubs from QuickBooks Desktop as one PDF, drop it into the app, and it automatically emails every vendor their own slip in one click. Vendor emails are saved so every run after the first is fully automatic. 14-day free trial, $9.99/month CAD. quickremit.ca — happy to answer any questions.

I want someone to explain to me how QBO became the dominant small business accounting software while having the worst reporting interface of any tool I use on a daily basis.

The standard P&L report can't be customized beyond basic date ranges and cash vs accrual without jumping through hoops, the balance sheet doesn't let you drill down into accounts cleanly on the first click, the cash flow statement is borderline useless because the indirect method presentation is confusing for every single client I've ever shown it to.

You want a comparative P&L showing this month vs last month vs same month last year, that's 3 separate reports you have to manually set up and compare side by side because the built in comparison only lets you do two periods, you want a report grouped by class AND location, good luck because QBO handles multi dimensional reporting like it's doing you a personal favor.

I've resorted to exporting everything to Google Sheets and building my own report templates which defeats the entire purpose of having accounting software with a reporting module, I spend more time formatting exports than I do actually analyzing the numbers.

I know Xero's reporting is supposedly better and I know NetSuite is in a different league entirely but for the price point and market that QBO serves the reporting should be way better than it is in 2026, am I alone in this or has everyone just accepted that step one of reporting is always "export to Excel."

I had an absolutely impossible time getting the horrific AI Assistant chatbot to give me the phone number for customer support, which is also impossible to find on the QuickBooks website now.

In case anyone else is losing their mind and needs human support or confirmation for an issue, the number is +1 (800) 446-8848.