Trade Receivables Control Excel Spreadsheet Template
The initial area to register all your customer's information for whom the Trade receivables are issued.
Trade Receivables Control:
For each issued Trade receivables, record the issuance and maturity date, related amounts, a discount is applicable or not, and whether it is paid or not. The report and dashboard tabs will collect this information and visualize key indicators and charts.
In this tab, you will see the number of monthly receivables issued, discounted percentage, receivables paid, respective values, and their percentages.
Dashboard with Indicators:
The dashboard contains all key indicators, graphs, and summaries for all receivables of the year.Trade Receivables Control Excel Spreadsheet Template