Quickbooks Trial Balance v. Bank, throw me some bread crumbs
I had a fail of a year in QBO.
The bank card which tied the bank feed to the bank was cut up by a teller (that's a story for a completely different board). They cancelled it outright, it could no longer login to the bank.
I then had to switch the login to a different style of bank portal. You can't just change that, so QBO rep told me to make a new bank account, and then merge.
End result: Bank feed works, My reconciliation history is gone. Probably f***ed up my balance.
I only have my pdf copy of the bank rec to work from. I had to make some significant leaps since then, which have changed my trial balance. (Yes, hindsight tells me I should have just kept importing statements until I had year end locked, but that's hindsight).
Bank balance of $228,270.72 CAD per the bank statement
Trial Balance 222,538.40 CAD
Uncleared Payments -3,960.26
Uncleared Deposits +1,447.49
Difference $3,219.55
I take issue with some of the Payments. For example, the accountant has a year end adj. journal from 2021 showing a cheque expense to cancel a cheque expense. But they're historical and they've been in for almost a dogs age now.
To tell you I've done every report and scoured everything is to tell you I've been at this for two days, with countless fruitless hours.
Except to go back and undo my reconciliations for this year and re-reconcile the whole account for all of last year to build the history. But I'm not sure that will change anything.
The accountant (yes, who made the entry for the cheque expense to cancel a cheque) isn't helping me. Just riding me to find the issue. We are both external from this company and don't interface except on this client.
The bank does about 500 transactions per month. Many deposits are combined from Stripe and two other credit card processing platforms.
Other clients send EFTS, others cheques.
I've checked my other banks: petty cash, cash clearing (they have a small business within their business that does small transactions that would be silly to enter one at a time), and the USD account.
Petty Cash doesn't have anything, the USD account balanced at year end.
Honestly, I'm out of ideas.
Bread crumbs appreciated.