Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 25, 2018
Solved

Accounts Receivable by Class

  • October 25, 2018
  • 25 replies
  • 176 views

Is there a way to run the A/R Aging by Class?  I am using QB online for Contractors.

Best answer by vpcontroller

Currently, such an option to run the A/R Aging by Class report is not available in QBO yet.
The workaround is to run the Account Receivable transaction report from the Balance Sheet (Run the Balance Sheet report and click the Account Receivable balance amount link). You can Group this report by Class. You can also customize and add a Class column to the report. But it will in AR detail format, not AR Aging format. See screenshot below for reference.

.

25 replies

vpcontroller
Level 7
October 25, 2018

Currently, such an option to run the A/R Aging by Class report is not available in QBO yet.
The workaround is to run the Account Receivable transaction report from the Balance Sheet (Run the Balance Sheet report and click the Account Receivable balance amount link). You can Group this report by Class. You can also customize and add a Class column to the report. But it will in AR detail format, not AR Aging format. See screenshot below for reference.

.

November 7, 2018

Thanks for this response.  I cannot figure out why "class" isn't available in my group by menu.  Can you advise?  I assign classes in AR and AP.  Thanks!

July 25, 2019

Hello there, @BaileyJr.

 

It's nice to have you in the Community. I'd be happy to help walk you through creating accounts receivable by class report in QuickBooks Desktop Premiere.

 

You can run and customize the Custom Transaction Detail Report to get the information you need. Let me show you how:

  1. From the top menu, select Reports.
  2. Choose Custom Reports then select Transaction Detail.
  3. At the top left, click Customize Report. 
  4. From the Display tab, click the Total by drop-down and select Class.
  5. Click the Filters tab.
  6. Under FILTER, select Account.
  7. Click the drop-down and select Multiple accounts.
  8. Mark Accounts Receivable then click OK.
  9. Under FILTER, select Paid Status.
  10. Click the drop-down and select Open then click OK.

I've attached an article and screenshots for additional reference: Customize reports in QuickBooks Desktop.

 

 

 

 

That should point you in the right direction today. Feel free to drop a comment below if you have any other questions about reports in QuickBooks. I'll be happy to help you further. Have a great rest of the week. 


Can you customize this report to show the invoices that get paid in this time period, but were from an earlier month? (ie. the time period is June 1-June 30, the invoice was dated April 30 but not paid until June 15.)  Ideally I would like to find a report that shows $x paid during a specific time period per class and $x in invoices still due and owing per class.  Is that possible?   Thank you.