cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here

Reply to message

View discussion in a popup

Replying to:
MJoy_D
Moderator

Reply to message

I can show you how to add your QuickBooks transactions to your account, @MikeMaggio

 

The first time you connect your bank, QuickBooks will pull up 30 to 90 days (or more) of transactions. To add your data beyond that, you’ll have to upload them manually.

 

To do it, you’ll have to manually download the transactions from the bank and then don’t forget to set the date range to avoid duplicates. Then, make sure to use the supported file format for QBO. Lastly, upload the file to your account.

 

Download the 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. With a maximum file size of 350 KB.
  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 Update drop-down and select File upload.
  3. On the window that appears, tap 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 categorise 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!