First let me start by saying that I am a pro advisor and have Quickbooks experience. The problem I am about to plead for help with is one I have NEVER seen before. I use Desktop for MAC. I'll try to keep this brief. This particular company started in April of 2017. For reasons I won't go into now, I ran a previous bank reconciliation report for April of 2017. The Beginning Balance was shown (in grey, intimating that it was now different from when it was originally closed out) as $12,000 and change. The original report, ran May 1st 2017 shows a beginning balance of ZERO, which is correct. The first transaction in the register of the bank is on 04/07/17. There was NO opening balance entered at the time the bank account was created in the chart of accounts. There are NO changes to ANY reconciliation reports when I go to reconciliation discrepancies under reports. Each reconciliation is listed all with ZERO dollar amount changes next to them... they do not expand or give more details. WHERE is this ghost beginning balance possibly coming from that it would not be anywhere in this bank register??? Also, there are only about 4-5 transactions in the ENTIRE company accounts that pre-date 04/01/17 and they only total up to about $1,200.... they are all entered into Owner Loans (Long-term liability) as journal entries and NONE of them are tied to this bank account. HELP!!!!
The beginning balance will be incorrect if a previously cleared transaction in the register was voided, deleted, changed, or a new transaction was added and cleared since your last reconciliation.
To check this further, you may trace the account activity since the last reconciliation until you find any discrepancy. You can also check the audit trail report to identify any deleted or added transactions.
The beginning balance is the sum of all transactions marked as reconciled. Whenever they occur. You probably have a transaction that has been marked as reconciled (dark check mark) in the register that occurs _after_ the starting date.