Question

Create a trial balance in QuickBooks Desktop that shows columns by month

Forum|Forum|2 years ago
May 22, 2024
2 replies
0 views

Hello, I wanted to know if there is a way to create a Trial Balance Report in QuickBooks Desktop that shows columns by month instead of one column with an ending balance. For the P&L report, we can click on 'Display Columns' and choose 'by month,' but I cannot find that option for the Trial Balance. Is there a workaround to run a Trial Balance by month?

QuickBooks Desktop

A

ArielI

Currently, there isn't a direct way to produce a Trial Balance report that shows columns by month, @Bea14. Let me share an alternative solution that can help.

As a workaround, you can consider running the Trial Balance report and setting the reporting date to the appropriate month. Then, export the report for each month to Excel separately and consolidate the data from there. Here's how:

Go to Reports, then Accounts and Taxes.
Select Trial Balance.
Set the correct date range (monthly).
Select the Excel drop-down, then Create New Worksheet.
If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
When you’re ready to export, select OK.

Also, you can check out these articles as your reference in case you need assistance in generating, customizing, and memorizing reports in QBDT:

Please keep me posted on how it goes in the comments below. If there's anything else you need and concerns about handling reports in QBDT, I'm always ready to help.

C

CsoCla

Is the Trial Balance able to show the revenue and expense accounts for the time period that is input, let's say for November 1 - November 30, 2024? At this time, it continues to show the year to date figures, not the monthly.

Thank you

A

AnneMariee

I'll gladly list the steps for running a report that shows the income and expense accounts for the month, CsoCla.

A Trial Balance report lists the balances of all your company's general ledger accounts at a certain time. This includes assets, liabilities, equity, revenues, expenses, gains, and losses. To run this report for a specific month, you may customize it by following the steps below.

On the top menu, go to Reports.
Hover on Accountant & Taxes and then select Trial Balance.
Choose the month on the Dates dropdown.

On the other hand, you may run a Profit and Loss report to obtain data about your revenue and expense accounts. To do so, follow these steps:

On the top menu, navigate to Reports and then Company & Financial.
Select a Profit and Loss report.
Customize it by picking a date range on the Dates dropdown.

I'll also leave these helpful resources for more information on running reports in QuickBooks:

It's also efficient to save a report's customization settings so you don't have to set them again every time you generate one. Here's a guide: Create, access and modify memorized reports.

I'm delighted to walk you through the essential steps of refining your reporting process in QuickBooks. If you need further assistance with running reports or customizing them, feel free to drop a reply. It's my goal to help you stay on top of your company's financials this holiday season!