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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill BachPresident and Btrieve GuruCommented:
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
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

JohnBusiness 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
JohnBusiness Consultant (Owner)Commented:
Thank you. I was pleased to assist. ... Thinkpads_User
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
QuickBooks

From novice to tech pro — start learning today.