cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
_bradhall
Level 2

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

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.
Solved
Best answer August 14, 2021

Best Answers
Rose-A
Moderator

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

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.

View solution in original post

5 Comments 5
Rose-A
Moderator

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

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.

_bradhall
Level 2

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

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.

_bradhall
Level 2

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

Thank you!

 

Before I upload, do I need to do anything about the opening equity balance? Do I need to add a balance for the new start date (1/1/21)? Do I need to remove the old one?

Fiat Lux - ASIA
Level 15

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

@_bradhall 

Another option, utilize the trial version of SlickConnect to import the missing transactions.

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

 

Consider to utilize the trial version of a backup restore app as an additional option.

https://rewindio.grsm.io/quickbooks

 

Test2Go
Level 6

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

Yes, remove the opening balance trans on 4/24 and create one dated 1/1.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us