cancel
Showing results for 
Search instead for 
Did you mean: 
WorldWiseTutoring
Level 1

It looks like my bank (Chase) disconnected from QB. I am now missing transactions from May, June, and July in Quickbooks. I have re-connected and updated already.

How can I get those 3 months to load in QB?
3 Comments 3
MadelynC
Moderator

It looks like my bank (Chase) disconnected from QB. I am now missing transactions from May, June, and July in Quickbooks. I have re-connected and updated already.

I’ll make sure these transactions will be entered in QuickBooks, @WorldWiseTutoring.


I’d be happy to share some information to get your issue resolved.


QuickBooks Online banking downloads 90 days of your recent transactions automatically once connected. Since these events are from your past months, we can utilize the Webconnect tool to import them.


Here’s how:

 

  1. Sign in to your bank or credit card’s website.
  2. Follow your bank’s instructions for how to download transactions to your computer.
  3. Make sure the date range for the download is at least one day before your oldest transaction.
  4. Download them, then save.
  5. Review the file format and size.
  6. Go back to your QBO account, then select Banking.
  7. Choose Banking.
  8. Select the Blue tile for the account you want to upload the transactions into.
  9. Hit the Link account dropdown, then click Upload from file.
    Capture.PNG
    Capture.PNG


You can use this reference in the future about categorizing and matching online transactions. It contains complete instructions and troubleshooting steps in case QuickBooks matches the incorrect event.


Keep me posted if you have any other questions with banking. I’m always here to help further. 

WorldWiseTutoring
Level 1

It looks like my bank (Chase) disconnected from QB. I am now missing transactions from May, June, and July in Quickbooks. I have re-connected and updated already.

I followed these directions. But when I try to load the file, I get the error message "Error while reading the file. Verify that file type is CSV."

But it IS a CSV!
 
Also, the spreadsheet I downloaded has transactions for my credit card and checking account all together. And it has 11/1/2018 til 11/2/202 (but I am only missing transactions from 4/28/20 - 8/2/20). Will QuickBooks know to put the checking into my checking account list and credit card transactions into my credit card list? And will it know not to duplicate or override the transactions that are already categorized and reconciled?
Rasa-LilaM
QuickBooks Team

It looks like my bank (Chase) disconnected from QB. I am now missing transactions from May, June, and July in Quickbooks. I have re-connected and updated already.

Thanks for coming back to the Community, WorldWiseTutoring.


I appreciate for adding more information about your concern. Let’s review the mapping and settings of the CSV file so you can seamlessly import the transactions.


When importing bank entries, QuickBooks requires either 3 or 4 columns. If an incorrectly formatted file is uploaded, the option will gray out, or you will receive an error.csv template.png

 

Make sure that it doesn’t break the following formatting restrictions.csv template.png

 

  • Special characters are not allowed.
  • Zeros (0) are not allowed anywhere in the file.
  • Correct any transactions that display an amount in the Description column.
  • Remove the word amount if it appears in the name of the Credit or Debit column.
  • MAC  users must save the file as a Windows CSV file.
  • Correct and standardize the Date format to a single format (for example, dd/mm/yyyy).
  • Some financial institutions provide the day of the week and include it in the Date column (for example, 20/11/2018 TUE in column A) which is not an acceptable format. To resolve, split the date and the day of the week into two separate columns.

After reviewing the template, you can now import your Chase transactions. I suggest following the solution shared by my colleague above.


For your other concerns, make sure the transactions transferred are the ones that are missing (4/28/20 - 8/2/20) to avoid duplication. By the time you download them into QuickBooks, you’ll have to manually select the correct posting account (checking or credit card). Also, the entries will not override the categorized or reconciled ones as long they’re not yet added to the account.


I’m adding links to guide you on how to move past banking issues and tips to successfully bring in entries via CSV.

 

Reach out to me if you have additional questions while working in QBO. I'm always ready to lend a helping hand.

Need to get in touch?

Contact us