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

Working Trial Balance Report

Relatively new to QBO but been in accounting for 20 years.  Looking for Working Trial Balance Report - (per account - opening numbers, transactions during the period, closing numbers).  Was not able to find it.  Borh Trial Balance and ADJ Trial Balance cannot be customized to show transactions or opening numbers.  Is it called something different.  Looks like Indian version has it build in (according to Google).  Found WorkPapers report that has opening and closing numbers but no transactions and only gives me FY.  Looking for report that would give me the info I am looking for monthly.

Appreciate pointing me in the right direction.

Thank you

9 Comments
Highlighted
Level 7

Working Trial Balance Report

Hello @slav ,

 

Are you using a QBO Accountant Version?  If not, the working papers are not available.  If you do have the Accountant Version of QBO, see below.

How to access WorkPapers

  1. Login into the QuickBooks Online Accountant firm where you'll see the client you were granted access to.
  2. Select the hyperlink text under the WorkPapers column, or if you're logged into the client file, visit the link: How to access WorkPapers
    Login into the QuickBooks Online Accountant firm where you'll see the client you were granted access to.
    Select the hyperlink text under the WorkPapers column, or if you're logged into the client file, visit the link: https://ca.qbo.intuit.com/app/trialbalance.

    The screen will display a Working Trial Balance. You can adjust entries by clicking on the + button. You can also browse for documents, drag and drop, or leave notes for team members under the WorkPapers column.
  3. The screen will display a Working Trial Balance. You can adjust entries by clicking on the + button. You can also browse for documents, drag and drop, or leave notes for team members under the WorkPapers column.
Highlighted
Level 1

Working Trial Balance Report

Thank you for your reply.  Need some help following your instructions.

1) I am using QBO Accountant.

2) I know how to get to Workpapers but is does not give me what I need as you cannot change the dates from fiscal year to quaters.

3) https://c5.qbo.intuit.com/app/workpaper gives me Page not found error.

This is as far as I was able to get but obviously doing something wrong or using a different version of QBO (ca.obo becomes c5.qbo in my case)

Any ideas?

Thank you

Highlighted
Level 7

Working Trial Balance Report

Hello @slav ,

 

The link becomes c15 when I click it, and it takes me to my login page.  Not sure about why it changes the number.

 

The Trial Balance is only a positional statement as at a certain date.  But it will always include the entire year up to that date because in QBO and QB Desktop, the transfer of net profit or loss to Retained Earnings does not occur until the end of the fiscal year.  Unfortunately, there is no way to change the date of that transfer to periods of different lengths, i.e. monthly or quarterly.

Highlighted
Level 1

Working Trial Balance Report

Thanks for trying Rochelley.  I think that there is a misunderstanding of what I am asking and what you are helping with.  The Trial Balance report works fine and I know how to use it.  I am asking about Working Trial Balance report that is different from Trial Balance as it contain the opening numbers for each account as well as summary of all Debits and all Credits for each account.  It is useful when you need to close the quarter end (or any period) as it easy to find errors and mis-posting.    "Working Trial Balance in Quickbooks" in google returns instructions how to access it but brings it to India QBO.  Is there a similar report in CA version or some other report that would give me :

AccountOpen BalanceDebitCreditCredit

for any period I choose ?

Thank you

Highlighted
Level 7

Working Trial Balance Report

Hi @slav 

 

I'm not aware of any.  Sorry I couldn't help you with the Working Papers . . . I haven't had to use them for quite awhile and simply don't remember much.  Someone else on the forums may be able to help you though.  The moderators may yet reply to your inquiry.

Highlighted
Level 1

Working Trial Balance Report

Thank you for trying.   

Highlighted
Level 1

Working Trial Balance Report

Hi 

When I tried to download the TB with all adjustments, all the data is not getting pulled and providing a report due to which TB is showing a mismatch whereas there is no mismatch in the TB. Kindly help.

Highlighted
QuickBooks Team

Working Trial Balance Report

Hello DeepaMoz,

 

Reports are a great way to get a sense of the figures in your books and having a sharp eye for details helps ensure their accuracy. I appreciate you including the screenshot of your Working Trial Balance report and I want to make sure you get the answers you need.

 

Having more details about how you're expecting your numbers to appear versus how they are will help us with knowing how to direct you in this situation. I see from your screenshot that the URL has c17, which signals to me you're using QuickBooks Online for India's region. In light of that, I recommend getting in touch with India's support team for assistance with your report. Here's how to reach them: QuickBooks Online India Contact Us page

 

You can also consider posting your question in India's QuickBooks Community. There, you'll be sure you're connecting with other users with the same QuickBooks Online interface as you who may be able to help you out.

 

Wishing you the best!

Highlighted
Level 1

Working Trial Balance Report

Check for direct adjustment postings to AR and AP - in my experience QB does not like it ab behaves unexpected. 

Good luck