Quickbooks AR Aging

In quickbooks, I want to be able to age my receivables strictly by month.  As far as I can tell, all the options age from either the date of the invoice, or the due date of the invoice.  I want anything and everything that is billed in March, whether on the 1st or 31st or anything in between to be due in April.  If it is not paid in April, once May 1st hits, it would be past due (0-30 days past due).  The way it is now, If I look at an aging report mid month, the items in the 30 day column might be from the current month or last month.  I need it to strictly put it in buckets by month.
DollarBillIAAsked:
Who is Participating?
 
John HurstConnect With a Mentor Business Consultant (Owner)Commented:
For aging to work properly, you need to put terms in your invoices. Invoices without terms will generally land in the wrong bucket. Once your invoices have terms, the current invoices will land in the newest bucket (that is, the one at the left starting from the date you selected).

If you put terms to each customer (terms are customer specific), then aging will work properly. If you start it at a month end, it will age current, 30-days, 60-days, 90-days and over 90-days. Under the Modify tab for the report, you have some flexibility over aging periods.

The real key is to have terms for each customer (nominally net 30 days) and then the aging report will work wonderfully well. I use it all time and the monthly buckets work fine.

... Thinkpads_User
0
 
Bill BachPresidentCommented:
I've not tried this, but there may be another solution.  Go to your TERMS list, and you should see a default item there called "20th".  Create a new one just like it to play with.

Try experimenting with different numbers in there.  For example, for all invoices to be due the first of the month, try setting "Net due before the " to 1.  See if that works.  If not, try adjusting the second line to 15, or perhaps even 30.  

0
 
DollarBillIAAuthor Commented:
I appreciate it.  I will try this and get back with you.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
John HurstBusiness Consultant (Owner)Commented:
I am fairly sure you still need to wind up with terms on all invoices as that is what makes aging work.
... Thinkpads_User
0
 
DollarBillIAAuthor Commented:
They always say check the obvious first.  Found a number of accounts with no terms.  Thanks for the help.
0
 
John HurstBusiness Consultant (Owner)Commented:
Thank you. I was pleased to assist. ... Thinkpads_User
0
All Courses

From novice to tech pro — start learning today.