Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Limited time. 50% OFF QuickBooks for 3 months.
Buy now & saveI am the treasurer of a nonprofit organization.I am keeping the books in Quickbooks Online. I recently opened an account with Charles Schwab and purchased some treasury bills. I linked my Quickbooks Online account with my Schwab account. It brought over all my transactions, but did something I do not understand. It took the market value of my T-bills on the date I linked the accounts, and placed it in an Equity account called "Opening Balance Equity." This entry was dated the day before my initial deposit to the Schwab account, which was more than a week before I purchased the T-bills, and more than a month before I connected the accounts. I can make the Schwab account match yesterday's value if I categorize the T-bill purchases in an expense account. But when I update the connection, the "opening balance equity" doesn't update, and so now the amounts don't match in my Schwab and my Quickbooks account.
This seems completely wrong to me. I don't have any interest in day-to-day tracking of the "equity" in my T-bill accounts. I'm going to hold them to maturity, cash them in, and buy new ones.
How do I fix this? What do I do with this "opening balance equity" account?
I'll help you match your opening balance from your Schwab and Quickbooks account, engrProf.
The Opening Balance Equity account is created automatically by QuickBooks Online when you enter opening balances for your accounts during the setup process. This is the balance of your real-life bank account for whatever day you choose to start tracking transactions.
Let's review all transactions in the Opening Balance Equity account to ensure they are accurate and correctly categorized. It's important to understand that the Opening Balance Equity account should ideally have a zero balance once the setup process is complete.
If you find any transactions in the Opening Balance Equity account that are incorrect or need adjustment, you will need to move them to the appropriate accounts. To do this, you can create a Journal entry to transfer the amount from the Opening Balance Equity account to the correct account.
To create a Journal entry, here's how:
However, if you are unsure about how to handle the Opening Balance Equity account or if you need assistance in making adjustments, I recommend consulting with an accountant to guide you through the process. If you don't have an accountant, we can help you find one. Feel free to visit this page to find an accountant for your business: Find a QuickBooks ProAdvisor.
I'll leave some articles to help you further with the process:
Moreover, I'll add these articles that tackle year-end guide and closing books in QBO for more information:
If I can be of any additional assistance, please don't hesitate to leave a comment below. Have a great rest of the day.
Thank you very much for taking the time to reply to my question. However, this does not seem like the right approach to me.
I chose to address the problem by editing the amount of the opening balance equity to zero, which was the actual value of the account on the date I opened it. I recorded the T-bill purchase transactions as transfers to a new "other current assets" account I created for T-bills. I think this will work for my purposes. I am using Quickbooks to track my T-bill purchases and any interest earned. I have no need to track the day-to-day market value of my T-bills. Therefore this seems to be the appropriate solution.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here