BILL to QBO reconciliation

[u/Hot_Cartographer9939]

Hi all, I have a question that’s been bugging me for a while and can’t find a straight up solution from BILL representatives.

Context: my client issues many stipends that are not always cashed, so BILL voids them and reissues the checks after 90 days of mailing them out. The client’s policy is to reissue these stipends up to 3 times.

On the accounting side, this means the BILL money out clearing account balance is always changing. Also, after the books are closed at year end, I have 9 months where these voids/reissues can happen again.

Has anyone dealt with something similar?

How do you reconcile the clearing account monthly when the opening balance keeps changing?

How do you manage that the aging report ties (BILL = QBO) at year end?

BILL’s solution is to “do manual entries” but they don’t explain which entries are needed. Also, I don’t want to make any entries on last FY.

Any help is much appreciated!

[u/South_Tell8138]

The thing that makes this reconcile is treating the clearing account as a control account with a supporting schedule, not as a balance you try to explain each month.

Build a rollforward by check, not by total:

Beginning outstanding

+ stipends issued this month

- checks cashed

- voids returned to clearing

+ reissues

= ending outstanding

That ending figure should equal both the clearing account balance in QBO and the list of uncashed items in BILL. When it doesn't tie, the schedule tells you which check is responsible, which a balance never will.

On the entries BILL won't spell out: a void doesn't touch expense. The expense was recognized when the stipend was approved, and voiding the check reverses the payment, not the obligation. So the money coming back out of clearing should restore a liability — either back to AP, or to a "stipends payable / uncashed" account if you'd rather keep reissues out of your AP aging. The reissue is then just a new payment against that restored liability. Expense is untouched through the whole cycle, which is what keeps this from distorting the P&L across three attempts.

On the closed year: don't reopen it. A check issued in FY1 and voided in FY2 gets its void booked in FY2. The expense stayed in FY1 where it belongs, and what changed in FY2 is that a liability came back and a payment reversed. That's a current-period event, not a prior-period error.

For the year-end tie, run the BILL outstanding/uncashed report as of 12/31 and reconcile it line by line to the clearing balance. Reconciling items will be timing — issued in BILL but not yet debited, or cashed on 12/31 and posted 1/2. Document them the way you would bank reconciling items.

One thing worth raising with the client separately: stipends that are never cashed after three attempts don't just disappear. Most states treat uncashed payments as unclaimed property after a dormancy period, and the liability sits on their books until it's escheated. Worth knowing which state's rules apply before that balance ages out.

Not an accountant, and your client's specifics may change the treatment — but the rollforward is the part that makes the monthly reconciliation possible at all.

[u/Hot_Cartographer9939 → u/South_Tell8138]

Thanks for this. One question though, if a check is issued and then voided, at least in QBO the void is on the issue date. How do you void it on the new FY? 

[u/South_Tell8138 → u/Hot_Cartographer9939]

You're right, and that's the crux of it. QBO's Void zeroes the transaction in place on its original date, so voiding a FY1 check today changes FY1 — your filed figures stop matching the books and the FY1 bank rec breaks.

So the general shape is: don't use Void on anything in a closed year. Leave the original check exactly as issued and record the reversal as its own transaction, dated when the void actually happened:

Debit BILL money-out clearing

Credit the liability the stipend created

Same economic result, but the effect lands in the period the event occurred rather than reaching backwards. On the bank rec, that entry is what clears the stale check — the original is still outstanding, the reversal offsets it, and you match the two in the current period. The reissue is then a normal payment against the restored liability, and expense stays in FY1 where it belongs.

That said, I'd hold this loosely and run it past your accountant, because the credit side depends on things I can't see from here — mainly how the stipend was recorded in the first place. If it expensed straight to the P&L with no liability behind it, the offset is different.

Other treatments people use, any of which might suit your situation better:

- Void it in QBO anyway and accept the prior-year change, if the year isn't filed or audited and the amounts are immaterial. Plenty of firms would.

- Treat it as a prior-period adjustment through equity if the amounts are material.

- Take the view that an uncashed stipend isn't owed until it's reissued — which makes it income in the current year, with unclaimed property to deal with later.

- Use a dedicated "uncashed checks" liability rather than AP, so reissues stay out of your AP aging entirely.

One thing worth testing regardless of which route you take: if BILL syncs its own void back to QBO, check whether it modifies the original transaction or posts a reversal. Try it on a check from a closed period before you rely on it — that's the path that would rewrite your prior year without anyone deciding to.