Account Receivable Analysis Dashboard

Great Microsoft Excel template for multipurpose presentation business or personal needs, ready to use.

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) Solar Dynamics Observatory
• 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)
• Instruction File
• Help & Contents File
• Light Theme