Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
usermangaboos
Level 1

How can I add transactions manually if they will not import?

My bank is limited to exporting transactions as .csv files only. Quickbooks says there is information missing. I have double checked to make sure the fields are correctly matched/defined. I also had this problem when trying to import .csv files from another bank (fortunately had a .qbo export option for that one and it worked). How can I add missing transactions without importing when I cannot import files and the bank link is updated?
2 Comments 2
Fiat Lux - ASIA
Level 15

How can I add transactions manually if they will not import?

Utilize the trial version of MT Online to isolate the issue. It is designed to import into any bank or credit card in QuickBooks Online, so there is no specific setting needed. 

https://www.moneythumb.com/?ref=110

 

MariaSoledadG
QuickBooks Team

How can I add transactions manually if they will not import?

Let's make sure you'll be able to add transactions in QuickBooks Online, usermangaboos.

 

Are you getting a specific error when trying to upload transactions to your bank? Generally, the only way wherein you can add missing transactions is by updating your bank manually or manually uploading it in QuickBooks. To manually update your bank, follow the steps below: 

  1. Go to the Banking tab.
  2. Select Update.
  3. If asked, enter your Multi-Factor Authentication (MFA). Then select Continue update.

 

On the other hand, each bank formats CSV files differently. Also, the maximum file size is 350 KB. If the file is too big, shorten the date range and download transactions in smaller batches. You may encounter issues when trying to manually upload transactions from your bank, learn more about CSV formats to successfully import the transactions. I've added this article for more details: Format CSV Files in Excel To Get Bank Transactions Into QuickBooks

 

In addition, to know more details on how you can match transactions with those you've already entered in QuickBooks, I've added this article for your reference: Categorize And Match Online Bank Transactions In QuickBooks Online.

 

Reach out to us if you have any questions about adding transactions. We're here to make sure everything is covered for you.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us