Excel Your A/R makes keeping track of your A/R collection activity more organized and efficient. Easily plan your accounts receivable collection activity and stay on top of who needs to contacted. Everything in Excel Your A/R is focused on making your accounts receivable collection efforts faster, easier and more efficient.
Excel Your Accounts Receivables is a tool designed for small to mid-sized companies. Only Microsoft Excel is required to use the software. The whole idea of Excel Your Accounts Receivables is to allow you to simplify he collections process.
How it works…
When an invoice becomes past due you enter information about the invoice into Excel Your A/R. You also enter a note regarding your interaction with the customer (phone call, email or even a fax). You also at that time enter a Follow Up date. Excel Your A/R will keep track of what customers you need to contact and when. Each day you should check the Excel Your A/R Dashboard. Here you can quickly see who needs to be contacted and with just a couple mouse clicks have all the information you need to contact the
customer, including any actions you previously have taken to date to collect the Accounts Receivable.
This brief video will help show you how Excel Your Account Receivables can streamline and simply your collection efforts:
A Better way for small & mid-sized companies to track A/R Collection efforts
After many years working as a Controller in small to mid-sized companies I decided to create Excel Your Accounts Receivables.
Every company I worked for has one area that their software fell short in – keeping track of collection efforts and customers responses.
Some companies would print an A/R Aging each week and write notes on the report. This method made it difficult to compare and track the customer’s promises. My poor A/R employee would spend time digging through piles of old reports trying to see the collection efforts for an invoice or customer.
At another company I worked for, my accounting clerk created a spreadsheet where who would keep track of open invoices. At the end of month week, she would spend hours creating a new sheet for the new month.
I knew there had to be a better way to track your A/R collection efforts. That is why I created Excel Your Accounts Receivables.