Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
pictureperfectpr
Level 1

Can I manually upload bank transactions to quickbooks?

 
2 Comments 2
AnneMariee
QuickBooks Team

Can I manually upload bank transactions to quickbooks?

Hi there, pictureperfectpr.

 

Yes, you can manually upload your bank transactions to QuickBooks, and I'm here to guide you through the process.

 

To start, you'll need to obtain a CSV file of your transactions from your bank. It's essential to ensure that the file is in the correct format to avoid errors in QuickBooks. You can use either the 3-column format with the Date, Description, and Amount columns or the 4-column format with the Date, Description, Credit, and Debit columns.

 

Once you've confirmed that the file is formatted correctly, you can proceed to upload the transactions to QuickBooks. Here's how:

 

  1. Go to Transactions, then select Bank transactions.
  2. Select the tile for the account you want to upload the transactions.
  3. Click the Link account▼ dropdown, then Upload from file.
  4. Click Drag and drop or select files and select the file you downloaded from your bank. Then, press Continue.
  5. In the QuickBooks account▼ dropdown, choose the account you want to upload the transactions into. Then, press Continue. You can also add a new account.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
  7. Select the transactions you like to import. Then select Continue.
  8. Hit Yes. Then, Done.

 

For more detailed steps, you can refer to this article: Manually upload transactions into QuickBooks Online.

 

Once done uploading your transactions, make sure you categorize them to ensure they're under the right accounts.

 

Come back to this post if you have any other questions about manually uploading transactions to QuickBooks. I'll be around to help you out.

4Gal
Level 11

Can I manually upload bank transactions to quickbooks?

@pictureperfectpr 

You can use MT Online or one of the converter tools (e.g csv2qbo @ $60 one time license) as a workaround.

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

 

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

Need to get in touch?

Contact us