Trade Receivables Control Excel Spreadsheet Template

Trade Receivables Control Excel Spreadsheet Template

Download this template

Enjoy all benefits of a LUZ Templates subscription:

  • 120+ spreadsheets
  • 80+ presentations
  • Usage lessons
  • Cancel anytime

Gain productivity in your consulting services with ready-to-use templates

Already a member? Download this template in the member’s area

Trade Receivables Control Excel Spreadsheet Template

Customer Registration:

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.

Receivables Report:

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

×

 

Support LUZ

× .