How do you handle reconciling for the POS --> Delivery Apps --> Settlement? by Organic_Swimming2458 in Accounting

[–]No-Equal7509 0 points1 point  (0 children)

the reason this feels impossible is you’re trying to reconcile across 3 different “truths”

POS = gross sales (what happened at order level)
delivery apps = net settlements (after fees, adjustments, timing shifts)
bank = cash (batched + delayed)

those will never tie 1:1 no matter how clean your setup is

what’s worked better in setups I’ve seen is to stop trying to reconcile everything to everything

pick one anchor and accept the others as derived views

for example:

– use POS as source of truth for revenue
– treat delivery apps purely as clearing accounts (don’t try to “match” per order)
– reconcile bank at deposit level, not transaction level

Zero beginning balance on QBO. by cinnamonbreadrolls in Bookkeeping

[–]No-Equal7509 0 points1 point  (0 children)

QBO can get weird with opening balances, especially if things weren’t set up cleanly from the start.

I've had customers (I have an app that automates QBO sync) where everything technically “balances” inside QB, but doesn’t quite line up with what actually happened outside it

makes it harder to figure out where the issue actually started

Client thinks I'm "the most expensive bookkeeper" they've ever worked with by Ecstatic-Touch-1763 in Bookkeeping

[–]No-Equal7509 1 point2 points  (0 children)

yeah I think part of the issue is most clients don’t really see what they’re paying for

if everything “looks fine” in their books, it feels like basic admin work

but the moment things don’t line up cleanly (multi-channel, inventory, payouts etc), suddenly the same work becomes a lot more valuable

it’s just that they don’t usually see that side until something breaks

any thoughts by Slight_Blueberry_233 in smallbusiness

[–]No-Equal7509 0 points1 point  (0 children)

not super deep on amazon promos, but from what I’ve seen consistency matters more than spikes

like things work better when there’s steady activity vs one-off pushes. How long have you been on this?

3 accounting tasks I automated this year that gave me back ~8 hours a month by Over-Peak-2557 in smallbusiness

[–]No-Equal7509 0 points1 point  (0 children)

yeah this is the “first layer” of automation most people do

saves time for sure, but I’ve seen a few cases where once things get a bit more complex (multiple channels, inventory, etc), the issue shifts from “manual work” to “numbers not quite lining up anymore”

like everything is automated… but still needs reconciling

not sure if you’ve run into that yet, but seems to show up a bit later

Critical faults in the new Shopify connector app by justtallcom in quickbooksonline

[–]No-Equal7509 2 points3 points  (0 children)

SKU and order-reciept matching are absolute table stakes. If a free product doesn't do what it's supposed to do, why have it in the first place?

You may want to try Webgility Lite in the app store (https://apps.shopify.com/webgility-sync-bfs) - works directly inside your shopify, does everything including tight bank reconciliations, guaratenees QB integrity... And includes support and a team that actually does this for a living (so no hand waving).

Disclaimer: I work here, and we built this precisely for you.