Skip to main content
The Best QuickBooks Prices & Service, Since 2001

Call Today 352.742.0800

11313 Davison Lane Tavares, FL 32778
Home

Speak to An Expert

  • Home
  • Bookkeeping
  • About Us
      1. News
      2. Our Team
      3. Enix & Associates, LLC
      4. Enix/Mendelson
      5. Industries Served
  • Tips & Articles
  • Contact Us

This Week's Question: Excluding Invoices from Accounts Receivable Summary Report

  • June 2014
  • Reporting
Accounts Receivable Reporting

Q : I want to be able to run an Accounts Receivable Summary report for my company but exclude specific invoices for specific customers.  There are certain invoices on our aging that are tied to a legal issue that must remain on our books so we want to run an Accounts Receivable Aging for internal purposes that excludes these invoices.  Is this possible?

A : Yes this is possible.  We just have to get a little creative in the way we record the "legal" invoices.  Below is an example of an A/R aging and we will assume the remodeling jobs for Robert Allard and Heather Campbell are the ones that we do not want to show up on our "internal" aging because they are the ones in litigation.

QuickBooks A/R Aging Summary

An easy way to accommodate this is to create a 2nd Accounts Receivable account in your Chart of Accounts called Accounts Receivable : Legal.

Creating a second accounts receivable account

Then you can pull up the invoices in question and change the Account to "Accounts Receivable : Legal."

Accounts Receivable - Legal

 

Now when you run the internal A/R Aging you filter the report to show only Accounts Receivable.  You do this by clicking on the Customize Report button, Filters Tab, Choose Account and select the appropriate account via the drop-down menu.

 

Modify A/R aging summary QuickBooks


Finally, if you want to run the A/R Aging just for the "legal" receivables you merely filter the report the same way but choose the account "Accounts Receivable : Legal."  This will return the report as shown below.  Also you can see that I modified the report title to include "Legal" by using the same Customize Report button and choosing the Header/Footer tab to make this change.

A/R Aging Summary

Categories

  • Agiliron (1)
  • Enterprise (16)
  • Inventory (8)
  • Payroll (2)
  • PCI Compliance (2)
  • Point of Sale (21)
  • QuickBooks (38)
  • QuickBooks Online (15)
  • Reporting (7)
  • Taxes (8)

Recent Posts

  • Accounting for contractors
    Utilizing QuickBooks Online Advanced for the Construction Industry
  • accounting software for law firms
    The Best Accounting Software for Law Firms
  • streamlined processes
    Streamline Business Operations with QuickBooks Enterprise Platinum with The Diamond Package
  • QuickBooks 2020
    New and Enhanced Features in QuickBooks Enterprise 2020

Footer Logo

A multi-national award winning Intuit Premier Reseller and 3-time named Top 100 ProAdvisor serving Tampa & Orlando, Florida. Specializing in QuickBooks Point of Sale, QuickBooks Pro & Premier, Enterprise Solutions and QuickBooks Online.

Services

  • QuickBooks Support
  • QuickBooks Consulting
  • QuickBooks Data Conversion
  • QuickBooks File Review
  • QuickBooks Reporting
  • Software Needs Assessment
Intuit Premier Reseller - Advisory Council Member
Intuit Quickbooks Certified ProAdvisor - Online
Intuit Quickbooks Certified ProAdvisor - Point of Sale
Intuit Quickbooks Certified ProAdvisor - Desktop
Intuit Quickbooks Certified ProAdvisor - Advanced Desktop
Intuit Quickbooks Certified ProAdvisor - Enterpriser
Top 100 ConsultantCertified Consultant500K Club

© 2021 Enix & Associates, LLC   |   Website: Precision Pages Inc.