Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

I am missing 6 months of transactions of my credit card that has been linked to my quickbooks for over 5 years. I am missing 6 months of this year. Yes, its 2020,

I have updated and searched for the transactions and they are no where to be found.
3 Comments
QuickBooks Team

I am missing 6 months of transactions of my credit card that has been linked to my quickbooks for over 5 years. I am missing 6 months of this year. Yes, its 2020,

Let's add those missing transactions to your QuickBooks Online (QBO) account, @jcdavishair.

 

Can you tell us which bank has missing transactions? That'll help us check to see if there's an ongoing issue with it.

 

In the meantime, you can add those missing transactions through the WebConnect process. You’ll have to manually download the transactions from the bank. Then, upload the file to your account.

 

Download bank transactions:

  1. Go to your online banking account to get your file.
  2. Check or follow your bank’s instructions to get a copy of the data and then save on your computer.
  3. Ensure that the data range is at least one day before your oldest transaction to avoid duplicates.
  4. Please take note of the supported file format and size. It should be either a Comma-Separated Values (CSV) or a QuickBooks Online (QBO) file. 
  5. Download your transactions and save the file to your desktop. 

To upload the file to your QuickBooks account: 

  1. Go to the Banking menu and select the bank where you’re uploading the transactions from the Banking tab.
  2. Click the Lin account drop-down and select Upload from file
  3. On the window that appears, click the Browse button and choose the file that you’ll be downloading. 
  4. Click on Open, then Next.
  5. Follow the onscreen instructions. Match the columns on the file with the banking fields in QuickBooks, then select Next.
  6. Click on Let's go. QuickBooks will now add the transactions to your account.

Check this article for more information: Manually upload transactions into QuickBooks Online. From here, you can now categorize  and then reconcile the transactions.

 

Let me know if there’s anything else that I can assist about your bank transactions by leaving a comment below. I’m always here to assist. Have a wonderful day!

Level 1

I am missing 6 months of transactions of my credit card that has been linked to my quickbooks for over 5 years. I am missing 6 months of this year. Yes, its 2020,

Alrighty, I just did an upload of the transactions and it has uploaded the spent and received amounts in the wrong way.  The "spent" was uploaded in the received column and "received" was uploaded in the spent, so my numbers are completely out of whack now.  how do I fix this?

QuickBooks Team

I am missing 6 months of transactions of my credit card that has been linked to my quickbooks for over 5 years. I am missing 6 months of this year. Yes, its 2020,

Thanks for coming back for more support, @jcdavishair. I can help you correct those manually uploaded bank transactions. 

 

First off, we'll need to remove those transactions. Then, reupload them with the correct debit and credit mapping. 

 

Here's how to eliminate the journal entry from your registers: 

 

  1. Go to Accounting, then Chart of Accounts.
  2. Find the bank account where the transactions are recorded.
  3. Click the View register link.
  4. Find and select the journal entries.
  5. Click Delete

jurnal.JPG

 

Once done, re-import a .csv file using either a 3-column or 4-column format. A 3-column format must have a  Date, a Description and the Amount of the transaction. A 4-column has a Date column, a Description column, and both a Credit and a Debit column.

 

You can follow the CSV format sample in these help articles:

 

 

Here's an article that will guide you in matching and categorizing your bank transactions to make sure they're added to your books. 

 

Let me know if you still need more help with importing bank transactions, @jcdavishair. I'd be glad to assist you again.

Need to get in touch?

Contact us