Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
May 14, 2020
Question

I need to run trial balance by month - in desktop I used P&L by class - changed column from class to month & selected all accounts under filter - does not work in online

  • May 14, 2020
  • 2 replies
  • 16 views
No text available

2 replies

Level 5
May 14, 2020

Hi there, 

 

QuickBooks is a great program for managing your reports and making sure your books are in order. I'll be happy to help  with showing you how to run a Trial Balance by month. 

 

A trial balance report summarizes the debit and credit balances of each account on your chart of accounts during a period of time. When running this report, you can always customize the report period to have your monthly Trial Balance report. Here's how:

  1. From the left menu, click Reports.
  2. Search for Trial Balance.
  3. In the Report period section, select the specific month you want to show.
  4. Click Run report.

For more info on customizing reports in QuickBooks, check out this article here. Give this a try and if you have questions, please contact our support team using this link. Let me know if you have other questions by leaving a comment below. I'll be on standby. 

November 24, 2022

Hi there,

 

I am trying to find the way to run the Trial Balance report in QB, BY ACCOUNT (GL account), by customized date, with a cumulative total..

For example, the bank account from 09-01-2022 - 09-30-2022 , cumulative running total.

 

I have played with the customize function, but it seems to only give me ALL accounts, by customized date, no running total. Is this a function within QB?

 

Thank you

 

Kate

November 25, 2022

I think you are looking for a net change for the period. If this the case you dont need the ending balance you need the total of Debits and Credits


I need both- I'm looking for a proper Trial Balance per period selected... including detail, running balance, debit/credit totals.. For example, Sage50 accounting program has exactly this. 

Regardless, what are the options for a detailed trial balance per account then?

May 6, 2022

For all new readers.  I wouldn't waste my time submitting this to feedback.  QB online has so many limitation and there are no intentions on their part to do anything about it.  I'm so disappointed with QB online.  Because this is one of many limitations of really basic features.  I discourage all my clients from using it.  However, running a transaction detail report (data to include as much information as you'd like to see when you drill down but at minimum account, date and amount) and exporting it to excel and creating a pivot table is one of your options.  Qodbc driver link to an excel spreadsheet and create a pivot off that is another.  I don't know if anyone suggested this before but I thought I'd post it anyways.