QuickBooks Reconciliation Shortcuts: When Plugs to the P&L Go Wrong
Small reconciliation variances often get dumped to the P&L by busy one-person teams. We cover when a plug is defensible and when it hides real trouble.
A familiar confession turns up in accountant forums: one person runs the entire close, time is short, and small unexplained differences get dumped to the P&L. The thread usually ends with a shrug. We think the shrug deserves a second look, because plugs are cheap today and expensive later.
Plugging variances is triage, not reconciliation
A plug is a journal entry that forces an account to agree with a statement, without finding why it disagreed. The memo often says something like “true-up” and nothing else. The books look clean. The cause is still there, waiting.
QuickBooks Online will not let you finish a bank reconciliation while a difference remains, so plugs there happen as manual journal entries instead. Desktop can post an automatic adjustment to a reconciliation discrepancies account. Either way, the software records that something did not tie. It does not record why.
When is a plug acceptable?
Materiality is a judgment, and it belongs to the business owner rather than to habit. A defensible plug is small against the account, one-off rather than recurring, sits in a low-risk account, and is documented with the reason you could not chase it.
A written threshold helps. Agree with the owners that anything under a set amount gets plugged and logged, and anything above it gets investigated. The exact number depends on the business. The point is that it is a decision, made once, in daylight.
Where do plugs hide real trouble?
Small differences cluster in ways that mean something. An identical variance every month points to a systematic error: a duplicate transaction, an accrual that never reverses, or a payroll liability posting to the wrong account.
Card feeds are another hotspot. Syncs drop transactions, and a card balance that drifts a few hundred each month can hide a missed charge or a duplicate payment. Growth in a catch-all “other expenses” account deserves attention too. It is the classic home of items nobody explained, and occasionally of items nobody should have paid.
Auditors and lenders also read a balance sheet full of plugs as evidence that the books are not truly reconciled. A reconciled balance sheet built on plugs asserts an accuracy it does not have.
Should you chase every $10 variance?
No, and nobody should. Effort should scale with size and risk. A practical compromise is to time-box the hunt: give a variance twenty minutes, and if it survives, plug it, log it, and move on.
Age matters more than size. A plug from this month is triage. A plug still sitting after two quarters is an error you have normalized. Review the plug list quarterly and clear the oldest one first.
A routine that fits a one-person close
None of this needs a second hire. Four habits cover most of it.
Reconcile bank and card accounts monthly and save the reconciliation report, so the tie is provable. Keep plugs in one clearing subaccount instead of scattering them, so they can be counted and aged. Write a real memo on each entry: amount, account, what you think happened, and the date you will revisit it. Once a quarter, spend an hour clearing the oldest plug before it calcifies.
QuickBooks tools that shorten the hunt
The fastest trick is searching an account register by exact amount. Type the variance into the register search and matching pairs tend to surface, such as a charge entered twice or a payment that cleared for slightly less than booked. Filters by payee and date narrow down duplicates fast.
The audit log shows edits and deletions, which is useful even in a one-person shop, since feeds and rules change things quietly. Bank feed matching catches duplicates before they post, as long as transactions are reviewed rather than bulk-accepted.
If a plug traces back to damaged or tangled company data rather than a transaction you can find, that is a repair job rather than a reconciliation job, and it is work our team does. Otherwise the next step is small: open the books, list the plugs, and give the oldest one thirty minutes this week. That is how shortcut habits retire, one entry at a time.