Skip to main content
C
Carissa22
February 5, 2021
Question

Customizing report to show accounts I want to see

  • February 5, 2021
  • 2 replies
  • 0 views

I'm trying to customize the Profit and Loss report so that it will also show me my CCA accounts additions.  I am able to check off the CCA accounts in the customization area of the report, but it still doesn't show them, presumably because they are considered long term asset expenses not current expenses.  However that's not really the case with much of what I have to classify as CCA (for instance tools < $500 all get written off in the first year same as other expenses).  Any idea of a report that would show CCA as well as the income/expense accounts, or is there a way I can start a new custom report from scratch?

2 replies

Rebecca R
Rebecca R
February 5, 2021

Welcome back Carissa22,

 

I love that you're looking to make the most of the Reports section in QuickBooks Online. I can tell that you're keen to use all of the features at your disposal in order to see the most accurate picture of your business' income and expenses. Here at QuickBooks, our experts are trained to support you on all of the technical aspects of using our product. This question aligns more with the support than an accounting professional provides, so let me point you in the right direction.

 

The Profit & Loss report is designed to show you your income and expenses for a specific period of time. Depending on how you've set up your CCA accounts, that'll explain why you're not able to pull the data from them into the report. There are tons of other reports available to you in QBO, and you'll be able to find out more about what each one does by hovering over the name and selecting the ? icon. There isn't an option to create a custom report from scratch, you'll have to work with what's included in the program, using the option for customization where possible. 

An accountant will be able to advise you on how to set up your accounts, as well as how to record your transactions against those accounts accurately. An accountant that's well-versed in QuickBooks will also be able to advise you on how to see the details you're looking to see within the program. I'm sure you're already familiar with how to invite your accountant to work with you in QuickBooks, but here's a refresher:

 

  1. Navigate to the My Accountant tab.
  2. Enter your accountant's email address in the field labeled Accountant's email.
  3. Hit Invite to send an invitation to them.

 

You'll also notice the Find a pro to help button on the same page. This'll take you to our database of QuickBooks-certified accountants that are more than qualified to support you with topics like these. I want to encourage the accounting professionals in this Community to chime in on this post if they have some suggestions to provide. I'd also encourage you to submit Feedback via the Gear icon. This is a great way to let our product developers know that our reports need improved capabilities. We love hearing from users like you.

 

Have a great day and enjoy your weekend!

 

C
cpa_chang
February 18, 2021

Could your CCA account be a balance sheet account and you're trying to see that in Income Statement? If that's the case, QB does not have anything like that. that would be a custom report using QODBC.

 

Suggestion above talks about how to categorize CCA (dr. amortization, and cr. accum amort) is a good start. if your CCA is dr. amortization then I suggest adding a description to the memo line to each asset's CCA entry. when you do a report on the Amorization exp account, add the description and memo fields so that you can export to Excel and filter for the assets you're trying to identify CCA.

 

Chad https://goodreports.ca/ 

Terms & ConditionsAccessibility statement