Power BI with your accounting data

Accounts Receivable - what they are and why they are important

Posted by Hugh Johnson on 22-Aug-2018 13:15:57
Hugh Johnson
Find me on:

What are Accounts Receivable (aka Trade Receivables)?

Accounts Receivable (also known as Trade Receivables) are monies owed to you by customers whom you have invoiced for products or services supplied but for which you have not yet received payment.  Your Trade Receivables are an asset (since you expect to receive cash from them) and in your accounting software, your total trade receivables will be the balance of your Debtors Control Account on your Balance Sheet. 

This should also equal the sum of all of your customer balances in your accounting software.

When you raise a sales invoice, then your accounting software will debit your Debtors Control Account by the gross amount of the invoice.  When you receive money from customers then your accounting software will credit your Debtors Control Account by the gross amount received.

In Sage 50 the default nominal code for your Debtors Control Account is 1100.

Who should be concerned about your Trade Receivables?

Your trade receivables affect many people.

  • Your customers need to pay these receivables
  • Your collections team needs to chase your customers for payment
  • Your sales team may need to know if there is a difficulty in collecting payment from a particular customer
  • Your financial director will need to understand the impact of your receivables on cash flow and the company's need for working capital
  • Your credit control team need to monitor your debtors (customers that owe you money) to reevaulate credit terms in general, or to specific customers or situations
  • Your marketing team should understand the profile of a customer that is more or less likely to present a credit risk so that you are targeting the right kind of customers

When should you monitor your Accounts Receivable / Trade Receivables?

What is right will depend on your business, but here are some suggestions:

Why track your Accounts Receivable?

Cash is the lifeblood of your business.  If you don't get paid for your services you will go out of business.  Tracking your accounts receivable and driving down your debtor days is critical for any company, but especially for a company that is expanding quickly and needs cash to invest in stock.

How should you track your Accounts Receivable?

Your accounting software will have the hard data needed to track your performance, but typically does not present this data in a way that is particularly digestible or actionable.  I would recommend a consistent, clear and automated report that is very focused on the activities listed above. In this report, I would expect to see a number of Accounts Receivable KPI's that can be used to track particular aspects of the health of your receivables book and your ability to collect against it.

Aged Debtor report of Power Bi

Learn more about our Accounts Receivable Reporting solution for Sage 50, built using Microsoft Power BI.

Accounts Receivable Reporting

 

Topics: Sage 50 Accounts, Accounts Receivable

Power BI with your accounting data

Time-saving tips, tricks, templates and tutorials

Subscribe to this blog for practical shortcuts to driving real insights from your accounting data with Power BI.

Expect:

  • How-to videos
  • Example reports
  • Sample formulae
  • Data modeling tips
  • Free Power BI templates
  • Tips for optimising Sage 50cloud

Subscribe to Email Updates

Recent Posts