Streamline Your Billing with Our Overdue Invoice Template for Sales

Overdue invoice template for Sales

this Sales Management Excel file includes a sales quote template invoice template sales analysis report accounts receivable report Financial commitments report it is quite easy to use enter your settings enter customer data create and save sales quotes create and save sales invoices enter payments received for each invoice enter Financial commitments data this sheet allows you to create a sales quote to save it as a PDF file and to save quotes data quote number appears automatically from last saved quote number check the box if the quotation is exempt of vat enter quotation date and expiration date select the customer select products or services enter quantities and vat rates quotation subtotal bat total amount and text amount appear automatically this sheet allows you to create an invoice to save it as a PDF file and to save sales data invoice number appears automatically from last saved invoice number Select payment terms select construction or sales contract number if any check the box if the invoice is exempt of vat enter invoice date select the customer select products or services enter quantities and vat rates invoice subtotal vat total amount text amount and do date appear automatically sales analysis report allows you to monitor total sales excluding vat and year-over-year variance number of active sales quotations and quotes amount month over Monon sales growth an actual versus previous year monthly sales variance sales amounts by customer an output vat based on issued invoices accounts receivable report shows cash collection kpis total amount of receivables exceeds 95 Millions out of which 53% are overdue 155 invoices are overdue total overdue amount exceeds 51 Millions on average company collects cash after 75 days on a total sales amount of nearly 377 Millions 74% were collected invoices du amount to collect at the end of October is 8,687 th000 total receivables as of October 31st exceeds 53 Millions 26% of receivables are overdue for more than 90 days 46% of due amounts are not overdue customer 11 has the highest balance 72% of which is overdue more than 3 millions of his balance is overdue for more than 90 days and 2.6 million still not overdue this is the oldest unpaid invoice customer 2 is still not paid the amount of 145,50 188 Financial commitments report track submitted and returned Financial commitments amounts like performance bonds Advanced payment guarantee hold back guarantees or Tender bonds total amount of financial commitments on construction contracts projects and other sales contracts exceeds 500,000 62% of which were returned to the company the highest submitted amounts are for performance bonds 46% of which are for project three this financial commitment has still not been returned to the company while the performance bond for project 2 has been fully returned [Music] [Music] [Music] [Music]