Should the 'Bank Balance' and the 'in Quickbooks' amounts be fairly close in amount or can there be a vast difference between the two?

Hi Matthew56, the Bank Balance is what your actual bank shows, while In QuickBooks reflects all transactions you've recorded, including uncleared checks, pending deposits, or transactions not yet posted by the bank.

A negative In QuickBooks balance with a positive Bank balance suggests you may have: 

• Uncleared checks or payments recorded in QuickBooks that haven't hit the bank yet
• Duplicate transactions
• Transactions are categorized in the wrong account
• Missing deposits that cleared the bank but aren't in QBO
• An incorrect opening balance when the account was set

For uncleared checks or payments, simply wait for the vendor to deposit the check and for the customer to send the payment to your bank. To address duplicate transactions, exclude them by going to your bank register. For transactions that are not categorized correctly, you can categorize them as needed. If there are missing deposits, you can record them in your QuickBooks account. Lastly, to correct the opening balance in your account, locate it in your Chart of Accounts and make the necessary adjustments.

Moreover, did you know that we provide a complimentary session with our QuickBooks Live Expert Assisted service? Our experts excel at making financial management effortless and offer tailored advice, especially in managing your bank transactions.

Feel free to return to this thread if you have any other questions or concerns about QuickBooks. We're always happy to help.