How do I create a custom report for a specific account?

Thank you for commenting,  @amazingfinishesl!

The steps above were for QuickBooks Online. There's a different set of steps for QuickBooks Desktop. Please check this out: Create, access and modify memorized reports

Let me know when you need help. Have a good one!

Hello,

We are using Quick Books online.  We are a few very basic custom reports.  Most used is a Budget Vs, Actual Report for our fiscal year with under the heading "Total"  This time around when we set up the report we are picking up an extra set of columns under the heading "Operating", so now we have 2 sets, 1 listed under Total and the other under Operating.  The setting are as we have always used them but I cannot get rid of the extra set.  They are duplicates of each other

But can I create a P&L and Balance Sheet and GL for 2018 for only the transactions that came out of the 1 specific checking account?

Hello there, @mcgbookkeeping.

Yes, you can create a Profit and Loss Report report for a specific account only. Let me walk you through in doing so.

To generate a Profit and Loss report, here's how:

1. Go to the Reports menu.
2. Choose Profit and Loss report in the Business Overview section.
3. Click the Customize button.
4. Expand the Filter section.
5. Select the Distribution Account drop-down arrow.  
6. Put a check mark on the specific account that you want to be included on the report.
7. Click Run Report.

On the other hand, a Balance Sheet report shows the overall financial snapshot of your company at a particular point in time. Thus, it will include all your company's assets, liabilities and shareholders' equity not just a specific account.

For additional insights, you may check these articles:

• FAQ: Basic troubleshooting for balance sheets
• Run a Profit and Loss report by bank account
• How to customize your Profit and Loss report

Keep me posted if you have other questions about creating account specific reports. I'm just a post away.

Under CHART OF ACCOUNTS, I found the account I want but there is no option to VIEW REGISTER so I can't go any further than that.

Hi WRI_2110,

Aside from the View Register option, you can also click on Run Report or double click the account itself. This will let you see the transactions under that account. 

Alternatively, you can run the Transaction Detail by Account report. Then, customize it to filter a specific account.

If you still need more help with your account, please let me know.

Hi Lauri,

How do I create a Detailed Client Balance report?

Good Afternoon, @DawnJ. 

Thanks for joining in on this thread. I've got you covered. I can walk you through the steps on how to run a detailed client balance report.

In QuickBooks Online (QBO), the report is called Customer Balance Detail. No worries. It's a simple process.

Here's how: 

1. Go to the Reports tab on the left-hand menu bar. 
2. Choose the Reports section at the top of the screen. 
3. Enter Customer Balance Detail in the search bar and then click on the option. 
4. From here, you'll be able to see the information on the report. 

For a future reference, you can customize reports for an easier layout for your business. 

Let me know if you have any other questions or concerns. The Community is always here to help. Wishing you and your business continued success. 

I followed these instructions, selecting the account I wish to see. I hit Run and I get a report full of zeros. There is data in this account. (years and years worth) The tech I spoke with found a workaround, but it's only something I can do going forward. If I add a "location" for every account I want to report on, and as new transactions are entered, I label them with the location, I can then run the report by location. Luckily it's only Jan 5 so I can change the transactions that are new this month and I can do it going forward, but that means that I won't be able to view reports on specific accounts for anything before Jan 1. This is very frustrating. It seems a basic bookkeeping thing to want to run a categorized report on a single account. I can't be the only person who needs this. PS, I upgraded to Plus because it was supposed to offer me "comprehensive reporting" but I can't do the ONE THING I need my software to do.

Is there a way to see all of the names in the detailed chart of account transaction report?

Hello, LibbySA2020. 

Yes, there is. I'll show you the steps to help you get all of the names in the report. 

Are you referring to the Chart of Accounts register or the Transaction Detail by Account report? If so, either report displays the names.

Just make sure to enable the Names column. Click on the small gear icon located at the top of the header, then check Names. 

However if your transaction has multiple names associated with it, you'll want to pull up a different report instead. For deposits, pull up the Deposit Detail report to see all of the names. 

For journal entries, you'll want to pull up the Journal report then customize it to show only the journal entries. Here's how: 

1. On the Reports page, search for Journal.
2. Open the report, then click the Customize button.
3. Expand the Filters section, then check Transaction Type.
4. Check Journal Entry.
5. To show all of the names, open the Rows/Column section then click the Change columns link.
6. Check Vendor or Customer (or both).
7. Once done, click Run report. 

If you need more help running your reports, you can check this article: Run reports in QuickBooks Online.

Need to work on other areas in QuickBooks? Or need to record other transactions? You can read our articles for details and guides about the processes. 

If you have other concerns, I'll hear you out. I'll shed some light or guide you along the way to help you manage your business in QuickBooks. 

But it doesn't provide the total amounts, just individual. I would like a total amount at the bottom.

Hi there, @Expressit08033. 

I'd like to help and get this issue sorted out right away. Before we accomplish your goal, can you tell me more about the concern you initially raised?

Would you mind explaining your concern further? This way, I can provide you with the best fix for it. Any additional information is much appreciated. 

Keep me in the loop by replying to this thread. I hope to hear from you soon. Stay safe

Is there a way once this report is memorized to quickly edit just the "account" so that all these steps don't have to be repeated and customized every time you want to view a different account ?

I'm here to help you customize the reports in QuickBooks Online, @Jon Landon. 

Yes, there's a way to modify the customized report. Just make sure to save it again to preserve the changes. Let me show you how: 

1. Go to the Reports menu on the upper left side. 
2. Select the Custom reports tab. 
3. Double-click the report you want to modify the account. 
4. Click the Save customization button again to keep the changes.

For more information, see this link: Memorize reports in QuickBooks Online.

In addition, read the following articles to learn about the various reports available in your subscription and how to manage them:

• Reports included in your QuickBooks Online subscription.
• Run, print, email, and export reports in QuickBooks Online.

You're always welcome to reply if you have other questions about managing your reports. I'm enthusiastic about helping you again. Keep safe!