When I downloaded my credit card expenses to Quickbooks for 2019, my bank for whatever reason was unable to provide list of my credit card purchases from 1/1/19 to 2/15/19. I called tech support to find out how I can add lines (like you would in a spreadsheet) to MANUALLY add those credit card expenses.
I was told that cannot be done and referred to a site that would convert my PDF bank downed statements to XML. That didn't work. So bottom line, I cancelled my subscription. All I needed to do was add a few lines to the Quickbooks credit card ledger. Was I given wrong advice?
Hello there, @nitecapt.
You'll want to import bank transactions using Excel CSV (comma-separated values) files. QuickBooks can import either a 3-column or 4-column format.
For credit card accounts CSV files may display transactions in reverse. Let's make sure that your credit card accounts are posted correctly in your company file.
Here's how to import transactions using a CSV file:
- Go to the Banking menu and select Banking.
- Click File upload.
- Select Browse and choose the file you downloaded from your bank.
- Tap Open, then hit Next.
- From the QuickBooks Account drop-down list, select the bank or credit card account then select Next.
- Choose a Date, date format, Description, and Account.
- Tap Next.
- Click the checkboxes of the transactions to import and select Next.
- Hit Yes.
- Click Let's go! when the Import completed notification appears.
Once done, you can find the downloaded transactions in the For Review tab.
You can check out this article for more information about importing bank transactions in QuickBooks:Import bank transactions using Excel CSV files.
Also, I'm adding this helpful article about adding and matching downloaded transactions:Match and categorize bank transactions in QuickBooks Online.
If you have any follow-up questions, don't hesitate to leave a comment below. I'm here to assist you further. Take good care.