Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
J
jacobs1779
January 8, 2022
Question

reporting

  • January 8, 2022
  • 1 reply
  • 0 views

I am looking for a trial balance I can run monthly that will have the beginning balance for each account, then a column for total debits for the month, total credits for the month and then a column for the ending balance for each account.

1 reply

J
JonpriL
Level 9
January 8, 2022

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.

J
jacobs1779Author
January 8, 2022

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

RenjolynC
RenjolynC
Level 9
January 8, 2022

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:

 

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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement