Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowSteve - I'm in the process of Importing Bank/Credit Card transactions in EXCEL format into QB 2020 (upgraded from QB 2012) because my bank only makes the Credit Card transactions available in either PDF or EXCEL formats. Since 2012, my credit card account in QB has been set up with the following Column Headers (left to right): DATE; TYPE; PAYEE; ACCOUNT (under PAYEE); MEMO (under PAYEE); CHARGE; PAYMENT; BALANCE. I would like to leave these QB Column Headers in place for the "Importing" process. I was going to change the Column Headers on the Bank Credit Card/EXCEL spreadsheet to Match the QB Column Headers, then do the Import. By doing this Column Header matching between the Credit Card/EXCEL spreadsheet and the existing QB Credit Card account, CAN I AVOID DOING THE MAPPING in the QB Import Process? To me, changing the Excel Spreadsheet Column Headers is much easier than trying to do the Mapping of the QB Account. AM I CORRECT IN USING THIS PROCESS TO IMPORT THE EXCEL SPREADSHEET? I've spent at least 2 hours on the phone with QB Customer Support and they only understand the Importing of QBO files into QB. I just spent $200 for QB Desktop Pro 2020 and hate to spend another $50-$60 on QB "Level 2 Customer Support", when this is the only question that I have. I appreciate your help on this. Thank you GK07