Skip to main content
August 15, 2021
Solved

Is there an easy way to change the date range QBO is pulling transactions from a credit card?

  • August 15, 2021
  • 1 reply
  • 0 views
When I synced the card, I chose to sync from 1/1/21—but for some reason it's only syncing from April. Is there a place I can go to confirm that the dates are set from 1/1/21 and repull the data for the missing dates? I'd prefer to not remove the account and start over, I've already categorized 300 transactions.
Best answer by Rose-A

I'd be pleased to help you sync your missing transactions in QuickBooks Online, _bradhall.

 

When syncing your bank for the first time, QuickBooks will automatically download your most recent or 90 days' worth of transactions. To import your missing data, you can use our WebConnect feature.

 

Here's how: Step 1: Pick a start date:

 

  1. In QuickBooks, go to the Accounting menu and then select Chart of Accounts.
  2. Look for the bank or credit card account you want to upload the transactions into.
  3. Click View register.
  4. Find and write down the date of the oldest transaction. Usually, the oldest transaction is the opening balance.

 

Step 2: Get transactions from your bank:

 

  1. Sign in to your bank or credit card’s website.
  2. Follow your bank’s instructions for how to download CSV files of your transactions to your computer. Every financial institution has different steps. For Bank of AmericaChase, and Wells Fargo.
  3. Check the date range for the download. It should be at least one day before the date of your oldest transaction.
  4. Download your transactions. Save the file somewhere you can easily find it, like your computer's desktop.

 

For other steps, you can refer to this article (proceed to Step 3): Manually upload transactions into QuickBooks Online. On the same write-up, you'll find links on how to set up bank rules as well as reconciling your account.

 

Once imported, I recommend editing, assigning, and categorizing your transactions. Also, you can match them to the existing entries in the software. Just go to the For Review tab from the Banking menu. Doing so will help you ensure the accuracy of your financial records.

 

I'm only a post away if you have any questions about this topic or anything else you need in QuickBooks. Have a wonderful day! Take care.

1 reply

Rose-A
Rose-AAnswer
August 15, 2021

I'd be pleased to help you sync your missing transactions in QuickBooks Online, _bradhall.

 

When syncing your bank for the first time, QuickBooks will automatically download your most recent or 90 days' worth of transactions. To import your missing data, you can use our WebConnect feature.

 

Here's how: Step 1: Pick a start date:

 

  1. In QuickBooks, go to the Accounting menu and then select Chart of Accounts.
  2. Look for the bank or credit card account you want to upload the transactions into.
  3. Click View register.
  4. Find and write down the date of the oldest transaction. Usually, the oldest transaction is the opening balance.

 

Step 2: Get transactions from your bank:

 

  1. Sign in to your bank or credit card’s website.
  2. Follow your bank’s instructions for how to download CSV files of your transactions to your computer. Every financial institution has different steps. For Bank of AmericaChase, and Wells Fargo.
  3. Check the date range for the download. It should be at least one day before the date of your oldest transaction.
  4. Download your transactions. Save the file somewhere you can easily find it, like your computer's desktop.

 

For other steps, you can refer to this article (proceed to Step 3): Manually upload transactions into QuickBooks Online. On the same write-up, you'll find links on how to set up bank rules as well as reconciling your account.

 

Once imported, I recommend editing, assigning, and categorizing your transactions. Also, you can match them to the existing entries in the software. Just go to the For Review tab from the Banking menu. Doing so will help you ensure the accuracy of your financial records.

 

I'm only a post away if you have any questions about this topic or anything else you need in QuickBooks. Have a wonderful day! Take care.

_bradhallAuthor
August 15, 2021

Thank you for this answer. I've followed all the steps except uploading the transactions.

 

First, I wanted to ask if I need to enter a starting balance as of 1/1/21? And do I need to remove the starting balance entry for 4/24/21 since we are moving the start point back in time?

 

Thank you.