Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
dbuswell
Level 1

How can I get a report of the detail of the Opening Balance Calculation by QBO?

I am doing an manual conversion from QBD to QBO. The accountant has given me the detail to support the AP balance in QBD. The total does not match QBO. How can i get a report from QBO of the detail transactions that make up the QBO calculated opening balance? Thank you for your help.

1 Comment 1
ZackE
Moderator

How can I get a report of the detail of the Opening Balance Calculation by QBO?

Thanks for reaching out to the Community, dbuswell.

 

You can try using your Accounts payable aging detail and/or Accounts payable aging summary reports to show the data you're looking for. You'll want to be aware that QuickBooks tracks all of your option balances for each account in an Opening Balance Equity account. This makes it easy to go back and look at what you entered later on.

 

If you find that you need to edit an opening balance, you'll need to edit its start date and balance if transactions will be added that are older than your opening balance. This sets a new starting point and prevents QuickBooks from counting transactions twice.

 

Here's how it's done:
 

  1. In the left navigation bar, go to Transactions, then Chart of accounts.
  2. Locate your account and click its View register option.
  3. Find the opening balance entry. Sort your date column to show the oldest entries first.
  4. Choose your opening balance entry.
  5. Edit its date, then the amount. If needed, hit Edit to make your changes.
  6. Select Save.

 

In the event you're trying to edit an opening balance while reconciling an account in QuickBooks with your bank or credit card statement, you can refer to our Fix issues the first time you reconcile an account article.

 

I've also included a couple detailed resources about using QuickBooks which may come in handy moving forward:
 

 

Please feel welcome to send a reply if there's any additional questions. Have an awesome Tuesday!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us