cancel
Showing results for 
Search instead for 
Did you mean: 
fmuriukiw
Level 1

Can the opening balance date range be changed for banks after downloading transactions?, e.g transactions downloaded for 3 months how to change to current one month?

 
1 Comment 1
Jen_D
Moderator

Can the opening balance date range be changed for banks after downloading transactions?, e.g transactions downloaded for 3 months how to change to current one month?

I appreciate you checking this with us, @fmuriukiw,

 

If you're referring to editing the opening balance date of an account in QuickBooks, do it in the Chart of Accounts. Find the journal entry to update the a beginning balance using the steps below:

 

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Locate the account you want to edit then press View register.
  3. Find the entry that has an Opening Balance Equity description in the Payee/Account column, and Opening Balance in the Memo column.
  4. Click on it and start editing the start date.
  5. Hit Save then done.

However, if you're referring to changing the period downloaded by QuickBooks during the first connection, this is currently unavailable. The program automatically fetch the last 90 days of transactions during the online banking setup. If you want to get rid of the transactions and only import the current data, you may exclude them. Here's how:

 

  1. Go to the For Review tab.
  2. Mark the box next to each transaction you want to exclude.
  3. Select Exclude from the pop-up at the top.

Excluded transactions are then moved to the Excluded tab, and won’t be added to QuickBooks or be downloaded again. To entirely delete the bank entry, mark the excluded items then hit Delete.

 

You can also import transactions manually into the system. The steps and set of links below will help you:

 

  1. Still from the Banking menu, click the Link Account drop-down.
  2. Click on Upload from file from the options.
  3. Press Browse and choose the file you want to upload.
  4. Choose an account from the list, then Next.
  5. Follow the on-screen instructions to map the fields.
  6. Select the transactions to import.
  7. Click Yes then Let’s go.

To learn more about mapping and uploading bank entries, see the following article:

 

If you have any additional questions, let me know by clicking the Reply button below. I'll be right here if you need anything. Have a nice day!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up