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.
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
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)
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.
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 :
for any period I choose ?
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.
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!