How to force reconcile old transactions prior to opening balance?
I've recently decided to use Quickbooks Online mid-year and began by linking a few bank accounts and credit cards and establishing their balances as of the dates I linked them to QBO. The feed was able to pull the past 90 days of transactions. I manually imported from CSV files the remaining transaction data from the beginning of the year, making sure that duplicates were not uploaded. I didn't experience any difficulties until I began to "add" (note, not match) these transactions by classifying them as income/expense etc. After adding these transactions, the balance per QBO for one of my credit cards for instance, is greater than the true bank balance. I have tried to use the reconciliation tool to force reconcile these historical transactions to no avail. I have also tried to manually switch the status of transactions to "R" within the account's register without any success either. Is there a way to force the QBO balance to reconcile to the bank after adding the historical bank/credit card transactions? Thank you!