Creating a Trial Balance Report with Opening Balance, Debits, Credits, and Ending Balance

I understand how important it is to have a report that includes the opening balance, debits, credits, and ending balance all in one view into the Trial Balance report, Sarah.

QuickBooks Online doesn't have the option to generate a single report combining all of this information directly. Although this feature isn’t available, here’s a workaround that may help:

• Run and export the Trial Balance report with credit and debit as of the specific end date of your reporting period to Excel.
• Generate the Reconciliation report to see activity summaries and ending balances for accounts you've reconciled during the period.
• Add the beginning balances for your accounts manually into your Excel file.
• Combine all the credits, debits, beginning, and ending balances into one complete Excel.

In the meantime, I encourage you to submit your feedback directly to our team regarding this feature. Here’s how to do it:

1. Click the Gear icon in QuickBooks Online.
2. Under Profile, Select Feedback.
3. Describe your feature request for a Trial Balance that includes both the opening balance and ending balance for a specific time period.

If you need further questions or help, feel free to comment below.

@Sarah N 

"I'm specifically looking for a way to see the Trial Balance for a specific time period so I can see the debits and credits for any period I select, as well as the beginning and ending balances."

Try running a Balance Sheet Detail report.  Click on 'Switch to classic view' and adjust the dates.  For some reason, I can't get modern view to organize by Transaction Date.  That should give you a beginning balance, each debit and credit entry for the period, and the ending balance is the balance on the last line for each GL account.  The "Total" is the net change in each account.  It may not be exactly what you're looking for but maybe it will suffice.