reporting

I'll be happy to help share how you're able to run a trial balance, @jacobs1779.

You can pull up and customize a transaction detail of your report to see the list of accounts with beginning and closing balances. I'll show you how.

1. Go to Reports.
2. Enter Trial Balance in the Search address.
3. Open your Trial Balance report by clicking the name suggestion.
4. Under the Report period menu, select the date that'll reflect the closing balance of your account.
5. Select Run report.
6. Click the amount for each account to view the list of beginning and closing balances.

From here, the deposit at the top is your beginning balance and the total amount shown at the bottom of your transaction list is the account's closing balance.

I'm adding this article to understand more about the other custom report to get a better view of your business's financial activity: Run Basic Financial Reports in QuickBooks Online.

It'll always be my pleasure to help if you've got questions other than generating a report. Use the Reply option below and leave your comment for me to help you move forward.

Thanks for the advice.

But I am looking for a report that will show the information as follows:

Account                 Beg Bal               Debits                  Credits                Ending Bal

1020 Cash             500,000              250,000               50,000                 700,000

1101  A/R                 25,000                50,000               25,000                   50,000       

And I would like this for every account in the trial balance.

Thanks

Hello, jacobs1779.

I'd like to share a report that includes the information you're looking for.

You can run the Transaction Detail by Account and customize the columns by following these steps:

1. Go to Reports on the left panel.
2. Type Transaction Detail by Account in the search field.
3. Select the Report period and click the Customize button.
4. In the Rows/Columns section, remove the columns you don't want to include by un-checking their boxes.
5. Put a check mark on the Account, Open Balance, Debit, Credit, and Balance boxes.
6. Hit Run report.

I've got this sample screenshot for a visual reference:

To learn more about the different reports you can run in QuickBooks Online and how you can customize them, please check out these articles:

• Reports included in your QuickBooks Online subscription
• Customize reports in QuickBooks Online

If you need more help regarding the report I've shared above, please feel free to get back to me by leaving a reply below. I'll be around to help you out again. Keep safe!