Account Receivable Overview Dashboard

An Accounts Receivable (AR) can mean the amount of money a customer owes a company for goods or services they received, or the process of converting their debt into cash. 

All elements on this template are editable from a Excel shape, no need another software, editing just on Excel, input your content, replace your images and logos into placeholder, change the color.

Dashboard Contents & Analysis

• Customer account ID number
• Customer Name
• Account Status
• Customer Branch / Location
• Customer Group category
• Total Customer Balance 
• Credit limit 
• (DSO) Days Sales Outstanding
• Risk Status (depend on total DSO) 
• Available Credit limit (Auto-Calculated using a Formula)
• Start date 
• End date (Auto-Calculated using a Formula)
• Current amount (Auto-Calculated using a Formula)
• Overdue (Auto-Calculated using a Formula)
• Before Due (Auto-Calculated using a Formula)
• Key Accounts

Unique Features

• Analysis for +17 types of data
• Wide Screen – Full HD
• Preview images are included
• Free Font & Icons
• Easy Customize
• All objects and database are fully editable

Package Includes

• Excel – XLSX format (673 KB)
• Three sheet tabs (Database, Pivot tables, and Dashboard)
• Light Theme