Scheduling Accounts Receivable


By Peter Emerson


The accounts receivable schedule is a listing of the customers making up the total accounts receivable balance. Most businesses prepare an accounts receivable schedule at the end of each month. Analyzing the accounts receivable schedule may help one identify potential cash flow problems. The typical accounts receivable aging schedule consists of six columns. The first column lists the name of each customer with an accounts receivable balance. The second column lists the total amount due from the customers. Column three is the "current column" that lists the amounts due from customers for sales made during the current month. Column four shows the unpaid amount due from customers for sales made in the previous month. These are the customers with accounts one to 30 days past due. Column five lists the amounts due from customers for sales made two months prior. These are customers with accounts 31 to 60 days past due. Finally, column six lists the amount due from customers with accounts over 60 days past due.

If you're using one of the many available accounting software packages for billing and accounts receivable processing, check it to see if it prepares the aging schedule automatically. Most accounting software packages will prepare an accounts receivable aging schedule at the touch of a button. The schedule allows one to spot problems in accounts receivable early enough to protect a business from major cash flow problems. Overdue amounts attributable to a number of customers may signal that your business needs to tighten its credit policy toward new and existing customers. The aging schedule also identifies any recent changes in the accounts making up your total accounts receivable balance. Almost every business has to deal with customers who are delinquent.


More Resources

Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting

More Management Information:

Related Articles


Understand What Flows Through Your Business to Find Improvement
I remember once seeing a cartoon which showed two people working a counter. On the wall behind them was a sign which read, "Quality Work, Low Price, Fast Service - Pick Two.
Big Company Intelligence on a Small Company Budget
Information is the lifeblood of the economy. That's especially true for businesses, because the ability to identify current customers and locate new prospects makes the difference between boom and bust.
How to Say No
Rejection hurts. No one likes to give it or to receive it.
New Job, New Culture: Do You Fit In?
It seemed like a good decision at the time. A 10-percent raise, an easier commute and a chance to move up the corporate ladder.
9 Strategies for Writing Accounts Payable Procedures
The Cash to Cash CyclePart Four of SeriesNext: Complete Cash to Cash CycleThe white flag is just a nose away?toward the Million dollar prize in cash savings for your business?So far, in Inventory and Accounts Receivable, we've found $250,000 each in cash savings. Then we found another 250K in Sales and Marketing.
Is It Worth To Outsource? How One Can Outsource Wisely
Recent trends in software development market show that it is no longer the most efficient way to work onshore. Competition is too high and in some particular cases, US or European IT people even go farming rather than admit the situation and adapt themselves.
Biometrics and "Return On Investment"
At this time of tight budgets, the mantra of business is "Return On Investment!" With few exceptions, expenditures are measured against the bottom line. Outlays for capital expenses are strictly evaluated in terms of profitability and the total cost of ownership.
Keys to Feeling Powerfull In An Uncertain World
Life has always been full of uncertainties. Over the last several years with downsizing, bankruptcies, scandals, crime, the economic environment, and the threat of war, people are feeling power-less, fearful, and stressed about their present and future lives.
Managing Performance: Don't Let Slackers Bring Down Your "A" Players
As a manager, it is your job to ensure that the work gets done effectively. Coaching and discipline are unpleasant tasks.
The Power of "Ask"
For Call Center managers, it is not a pipe dream to improve employee moral while increasing productivity. It may even come easy to some to find fresh, new ways to reduce performance problems.
Identifying Potential in Ourselves and Others
If there is someone nearby as you read this look in their eyes. Look closely and you will see great potential inside this person regardless of how "successful" or accomplished they are.
This Old Business
Not long ago I was asked to come out and take a look at a business that had been around for about 10 years..
Business Innovation - Organizational Culture
Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation.There are other useful definitions in this field, for example, creativity can be defined as consisting of a number of ideas, a number of diverse ideas and a number of novel ideas.
Increasing the Return on Your Training Investment
Insightful leaders and organizations recognize that training is a valuable tool for personal and professional development and therefore set some sort of an annual training budget.Most everyone I've ever talked to has been to both excellent training (hopefully ours!) and training that was, well, not so good.
Indiscretion Can Kill Your Business
The quickest way to cancel out all the thought, work, energy, time and expense you've poured into promoting your business is with indiscretions. I'm not talking about giving your clients' confidential materials to their competitors, though that certainly will kill your business - I'm talking about the indiscretions that leak out of your mouth, such as: Those inappropriate responses to anyone and everyone within earshot when you are dog-tired and have been up all night trying to meet a deadline.
Organizational Structure, Creativity, Innovation
Organizational structure can inhibit or foster creativity and innovation. The problem with organizational structure though, is that it is resultant of many factors, including history, organic growth, strategy, operational design, product diversity, logistics, marketing, client base, supplier base and so forth.
A Journey of a Thousand Miles
You can't build a reputation on what you are "going" to do. Henry Ford Everyone procrastinates in their own way.
Quick Tip - Effective Meetings Earn a Profit
Most people treat meetings as a free resource that can be used to deal with any issue. As a result, huge amounts of time and money are wasted on trivia.
Creativity and Innovation Management :- Thought Leadership
Leadership is only sustainable when leaders consistently come up with good ideas - when they are dependable thought leaders. It follows then that leaders would be more effective if they knew how to manage creativity and innovation.
Optimizing Your Cash Flow With Proper Accounts Receivable Management
Businesses miss on growth opportunities and even close their doors every day, not because they aren't profitable enough, but because they are strangled by poor cash flow. The problem is that while their profit and loss statement shows success, their bank account cries poor.