cancel
Showing results for 
Search instead for 
Did you mean: 
Lauri1
Level 1

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

How do I create a custom report for just one of my accounts?

Solved
Best answer October 15, 2018

Best Answers
JessT
Moderator

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

Hi Lauri,

You'll want to go to the Chart Of Accounts. Then, run and customize the report of a specific account.

  1. Click on the Gear icon.
  2. Under Your Company.
  3. Choose Chart of Accounts.
  4. Find the account and click the drop down arrow beside View Register.
  5. Choose Run Report.
  6. Customize the report.
  7. Click Save customization.
  8. Enter the details of the customized report.
  9. Click Save.

To find your customized reports:

  1. Go to Reports.
  2. Click the My Custom Reports tab.
  3. Click the name of the report to open it.

Let me know if you need more help.

View solution in original post

17 Comments 17
JessT
Moderator

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

Hi Lauri,

You'll want to go to the Chart Of Accounts. Then, run and customize the report of a specific account.

  1. Click on the Gear icon.
  2. Under Your Company.
  3. Choose Chart of Accounts.
  4. Find the account and click the drop down arrow beside View Register.
  5. Choose Run Report.
  6. Customize the report.
  7. Click Save customization.
  8. Enter the details of the customized report.
  9. Click Save.

To find your customized reports:

  1. Go to Reports.
  2. Click the My Custom Reports tab.
  3. Click the name of the report to open it.

Let me know if you need more help.

amazingfinishesl
Level 1

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

What version of QB are you using? I have QBPro 2015 and do not see a gear icon under My Company.
JessT
Moderator

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!

Loretta
Level 1

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

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

mcgbookkeeping
Level 1

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

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?

IamjuViel
QuickBooks Team

How do I create a custom report for a specific 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:

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

WRI_2110
Level 1

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

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.

JessT
Moderator

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

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.

DawnJ
Level 1

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

Hi Lauri,

 

How do I create a Detailed Client Balance report?

Candice C
QuickBooks Team

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

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. 

AuraMae
Level 1

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

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.

LibbySA2020
Level 2

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

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

jamespaul
Moderator

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

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

 

names1.PNG

 

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. 

Expressit08033
Level 1

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

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

AbegailS_
QuickBooks Team

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

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

Jon Landon
Level 1

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

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 ?

MichelleBh
Moderator

How do I create a custom report for a specific 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:

 

 

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

Need to get in touch?

Contact us