Reconciling QuickBooks Bills

If your bookkeeper already keyed a vendor bill into QuickBooks, ShelfSpace shouldn't go and add a second one. Here's the cleanup that makes sure every expense posts exactly once.

You connect QuickBooks, and your bookkeeper has already keyed in months of open vendor bills by hand. ShelfSpace pays one of those invoices, creates its own bill for it, and the same expense is suddenly on your books twice. That's not hypothetical — a twenty-five thousand dollar vendor bill got booked twice before this existed. Reconciling fixes it at the source: you tell ShelfSpace which QuickBooks bill is which invoice, and the check attaches to the bill they already have.

It lives in Settings, under Integrations, on the QuickBooks card, and it only appears once QuickBooks is connected and your expense account is mapped. Before you touch it, do one thing: load your invoices into ShelfSpace first. Scan before they're in and there's nothing to match against — real bills land in the pile marked no ShelfSpace invoice. That's the number one way to get this wrong.

Then scan. ShelfSpace pulls every open bill in QuickBooks that still carries a balance, with no age limit — and that matters, because a bookkeeper's backlog is usually older than ninety days. It skips anything ShelfSpace created, so you only ever see theirs.

Two hundred fifty open bills here, none of them ours.

Vendors come first, and this is the part worth understanding. A bill can't be matched until its QuickBooks vendor is connected to a ShelfSpace vendor — the two systems share names, not IDs. Match a vendor once and it covers every bill they have. Thirty-one bills from this one, in a single click.

The closest name match is filled in for you, so you're confirming a name, not hunting for one. And it's saved, so every future payment to that vendor already knows where to go.

When there's no close name match, ShelfSpace says so and stops. It won't guess a vendor for you.

Now the matches. These are suggestions and nothing more — nothing here links itself. ShelfSpace puts a QuickBooks bill next to a ShelfSpace invoice, shows you what it matched on, and waits. Every link is your click.

Look at the second row. That invoice has eighteen hundred fifty dollars of credits applied, so ShelfSpace pays the net — twenty-three thousand one fifty against a twenty-five thousand dollar bill. Their bill keeps that small balance until someone records a vendor credit in QuickBooks. That's expected. It is not a sync failure.

Check the ones that are right.

Then confirm. If a suggestion is wrong, Not a match dismisses it. Nothing is written to QuickBooks yet — you're recording which bill is which invoice, so the check knows where to land later.

Whatever QuickBooks has that ShelfSpace doesn't ends up here. Some are invoices you haven't loaded yet. Some will never be ShelfSpace invoices at all — packaging, freight, rent — and those you dismiss.

And some need you. Two open invoices from this vendor, both at thirty-one fifty. Software can't tell those apart, and shouldn't try.

You pick the invoice yourself, from your own open payables.

And link it.

Linked bills is your record of what's connected. When ShelfSpace pays one of these, the check attaches to the QuickBooks bill that's already there. Their bill closes out, their coding stays put, and no second bill is created.

You can unlink while an invoice is still unpaid — change your mind freely. Once a payment posts against a linked bill, it's permanent. The check has already been recorded against that bill, so there's nothing left to take back.

The last list is just information. These are ShelfSpace invoices QuickBooks has never seen, so there's nothing to reconcile — ShelfSpace will create those bills when you pay them, which is right.

One last thing worth trusting. ShelfSpace never edits, voids, or deletes a bill it didn't create — a linked bill stays your bookkeeper's. And if one gets paid or deleted in QuickBooks before your check goes out, the check still goes out. ShelfSpace flags that one to be recorded by hand, rather than reaching into their books.