Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Connect and Engage
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Beta
Home
Quicken Classic for Windows
Registers & Transactions (Windows)
How to adjust opening balance and prior transactions?
CamoFree
How to download online banking transaction for date prior to opening balance. Setup was on 3/17/22 so opening balance was that date. I'd like to download back to 1/01/22. I need only enter missing transaction from 1/01/22 to 3/17/22
Find more posts tagged with
Accepted answers
Tom Young
If you're able to selectively download only certain transactions - I think that's rare - then first make a backup of your current file and write down your Current Balance and Ending Balance (if you have entered "future" transactions in the register). Then delete the 3/17/22 Opening Balance and download your 1/1/22 to 3/17/22 transactions. Finally, make a new "Opening Balance" entry as of 12/31/21 that makes your Current and Ending Balances correct; it's a
derived
number, of course.
To make the Opening Balance entry, enter the necessary dollar amount and in the Category box enter the name of the Account you're working in, surrounded by square brackets: [Account Name]. This sort of "self-referential" style of entry will not effect any other Account or Category in your Quicken file.
Tom Young
How far "back in time" you can download transactions is set by the Financial Institution and 90 days is a typical limit, but it does vary. Too, some Financial institutions allow you to download transactions further back then their "usual" limit by downloading an OFX file. You might see if that option is available.
You can also enter those missing transactions manually, if you have the needed information. The process would be exactly the same as described in my original post.
Frankx
Hi
@CamoFree
What are the name or names of the financial institutions involved? We may be able to give you some specific advise if you want to share their name(s).
Frankx
All comments
Tom Young
If you're able to selectively download only certain transactions - I think that's rare - then first make a backup of your current file and write down your Current Balance and Ending Balance (if you have entered "future" transactions in the register). Then delete the 3/17/22 Opening Balance and download your 1/1/22 to 3/17/22 transactions. Finally, make a new "Opening Balance" entry as of 12/31/21 that makes your Current and Ending Balances correct; it's a
derived
number, of course.
To make the Opening Balance entry, enter the necessary dollar amount and in the Category box enter the name of the Account you're working in, surrounded by square brackets: [Account Name]. This sort of "self-referential" style of entry will not effect any other Account or Category in your Quicken file.
CamoFree
Thank you for the reply. I think I might have to create a new account with a 12/31/22 opening date. Hopefully one step update will download from that point. I'm not tech savvy.
Tom Young
How far "back in time" you can download transactions is set by the Financial Institution and 90 days is a typical limit, but it does vary. Too, some Financial institutions allow you to download transactions further back then their "usual" limit by downloading an OFX file. You might see if that option is available.
You can also enter those missing transactions manually, if you have the needed information. The process would be exactly the same as described in my original post.
Frankx
Hi
@CamoFree
What are the name or names of the financial institutions involved? We may be able to give you some specific advise if you want to share their name(s).
Frankx
CamoFree
I have all statements needed, that and a pot of coffee should do the trick.
Thanks again.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of