Home Resources Blog

How to determine who owes you money

1 min to read
How to determine who owes you money

The ability to determine how much outstanding money is owed to your company is vital to the ongoing management and sometimes survival of a business . As such, it’s important that relationship managers have the ability to examine which accounts are overdue or have a credit freeze on them so they can work with finance and customers to rectify the situation.

In this video tutorial, we’ll show you how to determine which customers owe you money.

After opening your accounts receivable database click the ‘ageing’ function then select the ‘91-120’ and ‘120+’ ageing values. Next, click the ‘Focus’ button and ‘account’ dimension tab to see a list of accounts that are more than 90-days past due.

In our example’ we have a list of 436 customers with overdue accounts. From here, you can see the names of the account owners by selecting the ‘owners’ dimension. Now you can easily examine how outstanding money is broken down by account owner. From here you can export the report into an Excel spreadsheet or click the star button to save it as a favorite. Print or share this report with your customer care representatives so they know which overdue customer accounts to prioritize.

Examine accounts receivable over 90 days
Written by Katrina Walter
Katrina Walter

Katrina is a professional writer with experience in business and tech. She explains how data can work for business people without all the tech jargon. She is always on the look out for new ways data is being used by business people to know more and be sustainable.

Related blog posts
The value of integrating financial and operational data image

The value of integrating financial and operational data

Why accounting is important in business image

Why accounting is important in business

Branch accounting made easy image

Branch accounting made easy

Management reporting versus financial reporting image

Management reporting versus financial reporting

Browse by category
Key data in one easy to understand view
Get a demo

Find out how our platform gives you the visibility you need to get more done.

Get your demo today