Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
GK07
Level 1

Reply to message

Steve - 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

Need to get in touch?

Contact us