Hi. I have experimented for the last 3-4 hours attempting to input bank transactions from a vendor that does not have QBO data. So I imported the bank data in to Excel and am now attempting to import Excel in to QB Desktop. The issue I continue to run in to is when I set up the mappings using advanced import, it will not import the amounts of each daily transactions. I am receiving an error message (from the QB error log) stating "You can only set opening balances for new records". That is because the only field when setting up the mapping is the Opening Balance field. Thus I renamed the header in QuickBooks as "Opening Balance". Does anybody know how I can import daily sales transactions in to QuickBooks with the dollar amounts for each transaction? Thank you in advance for your help!
