- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Is there an easy way to change the date range QBO is pulling transactions from a credit card?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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:
- In QuickBooks, go to the Accounting menu and then select Chart of Accounts.
- Look for the bank or credit card account you want to upload the transactions into.
- Click View register.
- 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:
- Sign in to your bank or credit card’s website.
- 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 America, Chase, and Wells Fargo.
- Check the date range for the download. It should be at least one day before the date of your oldest transaction.
- 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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Yes, remove the opening balance trans on 4/24 and create one dated 1/1.