Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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.
I couldn’t produce this report, so I had a programmer write me a utility many years ago.
It’s listed on Intuit’s third-party add-on site, or you can just google TBX Trial Balance Exporter.
Direct Link: https://asbinc.net/tbx-utility/
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
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 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:
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!
No, the Trial Balance Report in QuickBooks presents the YTD balance of each account "as of" the end date selected. As you found, the beginning date is ignored.
If you only need the "net change" during the month for P&L accounts, obtain this with a regular P&L report.
If you need the "net change" of balance sheet accounts, you can obtain these figures by producing a comparative balance sheet for two months with a difference column.
If you need a Trail Balance with all accounts presenting a period net change, you can manually combine the figures obtained above or use a 3rd party utility such as TBX Trial Balance Exporter.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here