cancel
Showing results for 
Search instead for 
Did you mean: 
mikelv98
Level 2

Why does Quickbooks leave a six month gap in my linked bank card transaction history? I'm missing all purchases between 5/6/20-11/23/20

 
Solved
Best answer April 11, 2021

Best Answers
MadelynC
Moderator

Why does Quickbooks leave a six month gap in my linked bank card transaction history? I'm missing all purchases between 5/6/20-11/23/20

I can help you get all your missing purchases, @mikelv98.


When adding transactions from your bank feed, QuickBooks depends on the information from your bank.


You have the option to add these purchases manually using CSV format. You’ll want to export the events from your bank and then import them into QuickBooks. Once you’re ready, you can follow these steps below to import them:

 

  1. Select the Gear icon.
  2. Click Imports.
    Capture.PNG
  3. Select Import older transactions for the account you want to add transactions to.
    Capture.PNG
  4. Press Browse and find the file you downloaded from your bank.
    Capture.PNG
  5. Select the file and click Open to start the import.
  6. Review the column headers and data. Make sure the Date, Description, and Amount columns on the CSV match the columns in QuickBooks.
  7. Click Continue to complete the import.


You can use this detailed guide to manually import transactions into QBSE. This helps you ensure all purchases will be entered successfully. In addition, here’s a reference to categorize the transactions.


I’ll be here anytime if you need further assistance with your bank entries. Have a good one!

View solution in original post

3 Comments 3
MadelynC
Moderator

Why does Quickbooks leave a six month gap in my linked bank card transaction history? I'm missing all purchases between 5/6/20-11/23/20

I can help you get all your missing purchases, @mikelv98.


When adding transactions from your bank feed, QuickBooks depends on the information from your bank.


You have the option to add these purchases manually using CSV format. You’ll want to export the events from your bank and then import them into QuickBooks. Once you’re ready, you can follow these steps below to import them:

 

  1. Select the Gear icon.
  2. Click Imports.
    Capture.PNG
  3. Select Import older transactions for the account you want to add transactions to.
    Capture.PNG
  4. Press Browse and find the file you downloaded from your bank.
    Capture.PNG
  5. Select the file and click Open to start the import.
  6. Review the column headers and data. Make sure the Date, Description, and Amount columns on the CSV match the columns in QuickBooks.
  7. Click Continue to complete the import.


You can use this detailed guide to manually import transactions into QBSE. This helps you ensure all purchases will be entered successfully. In addition, here’s a reference to categorize the transactions.


I’ll be here anytime if you need further assistance with your bank entries. Have a good one!

mikelv98
Level 2

Why does Quickbooks leave a six month gap in my linked bank card transaction history? I'm missing all purchases between 5/6/20-11/23/20

Thanks for the response MadelynC. I had found this info in the through the virtual assistant as well and it does work! My concern was why the problem occurred in the first place as I am planning to use QuickBooks for tax purposes this year. With the IRS we want to be absolutely certain that everything is accurate so it might be a better practice to upload all transactions with a .CSV file in the first place at least as far as Capital One bank cards are concerned. I also called a representative and she told me that this can happen if you don't log into your QuickBooks account at least twice a week. I had no idea that was a requirement but I'm sure it is somewhere in the instructions and I just missed it. We go months without logging in so this seems to be another good reason not to depend on automatic synchronization between this software and my bank card. Other than that it seems to work well for the most part. 

mikelv98
Level 2

Why does Quickbooks leave a six month gap in my linked bank card transaction history? I'm missing all purchases between 5/6/20-11/23/20

I just wrote a detailed reply that disappeared once I logged in. In short:

 

Thank you for the response. This works! Do not depend on automatic synchronization between QuickBooks and Capital One bank cards. A phone representative from QB told me that I must also log in at least twice a week to prevent this problem from occurring. That may not always happen so I'll be going through my transactions one at a time to make sure everything is recorded properly each year. With the IRS we cannot be too careful about accuracy. 

Need to get in touch?

Contact us