Invoices & Payments

Dashboard goals

List of available reports

Here is the list of reports that can be accessed via this dashboard.

Let's take a closer look at each of these reports.

1.Turnover

Sales lists the total sales of goods and services by a company. It is equal to the amount (excluding VAT) of all sales transactions carried out by the company with third parties in the course of its normal and ordinary business. Sales can be calculated for any period of time, but are often calculated on a monthly, quarterly or annual basis. This notion is the primary sales performance indicator of a company.
In Frisbii sales are broken down as follows:

Underlying report structure:
Filters:

• Show me: All invoices

• Date: Current fiscal year (January 1 N - December 31 N)

• Status: Equal to issued

• Omitted: Equal to false

Group by: Invoice date

Columns:

• Invoice date

• Amount before Taxes

Report type:

• Invoices with invoice line items:

2.Accounts receivable

Frisbii's receivables break down as follows:

• Report type: Accounts with invoices

Trade receivables represent amounts owed by customers to a campany. A customer receivable becomes collectible when the payment period granted to it expires. In most cases, the deadline is 45 days from the end of the month, or 60 days from the date of invoicing (although there are exceptions, particularly in the transport sector, where the threshold is a maximum of 90 days). If no agreement has been reached between the two parties, a period of 30 days is deemed to have been granted to the creditor.

Report structure:

Filters:

• Show me: All accounts

• Invoice Date: All time

• Status: Equal to issued

• Balance Due: greater than " € 0, 0000"

• Omitted: Equal to false

Group by:

• Due date

• Account name

Columns:

• Due date

• Account name

• Outstanding balance

3.Overdue invoices

• Report type: Accounts with invoices

Before claiming any penalties from your debtors, make sure you comply with the billing rules. The General Tax Code lists the various obligations in this area (supplier and customer details, invoice date and number, amount before tax, VAT …). Among these are the terms of payment which authorize a creditor to claim penalties from his customer:

• Discount rate for early payment

• Due date (payment on receipt of invoice, within 30 days …) Payment terms may not exceed 60 days from date of invoice or 45 days from end of month.

• Interest rate for late payment: This rate may not be less than 3 times the legal interest rate.

• Flat-rate indemnity of €40 for invoices sent to professionals (B to B).

Report structure:
Filters:

• Show me: All accounts

• Last activity: All time

• Status: Equal to issued

• Due date: Less or equal to Today

• Balance Due: More than "€ 0, 0000 "

• Omitted: Equal to false

Group Rows:

• Account name

• Invoice: Record Name

Group Columns: Invoice Date

Columns:

• Account name

• Invoice date

• Invoice name

• Balance due
  
  
  

4.Average payment duration per month

• Report type: Accounts with invoices

The average payment duration per month refers to the limited period of time during which a company reports all the economic facts concerning it. This will enable to draw up a balance sheet at the end of the financial year. Traditionnally, an accounting period lasts 12 months and is established during a calendar year. However, nothing prevents a company from carrying out an accounting period over a different period. At the end of the accounting year, the company proceeds to the establishment of a financial statement.

Report structure:

Filters:

• Show me: All Accounts

• Date: Current FY

• Status: Equal to issued

• Balance Due: Equals to €0,00

• Omitted: Equals False

Group by: Invoice Date

Columns:

• Invoice date

• Average Age

5.Outstanding payments D+7

6.Customers in arrears

• Report type: Accounts with invoices

Late payment appears in the dashboard as soon as the contractual payment deadline indicated on the invoice is exceeded.

Report structure:
Filters: 

• Show me: All accounts

• Last activity: All time

• Status: Equal to issued

• Due date: Less or equal to Today

• Balance Due: More than "€ 0, 0000 "

• Omitted: Equal to false

Group Rows: 

• Account name 

• Invoice: Record Name

Group Columns: Invoice Date

Columns: 

• Account name

• Invoice date

• Invoice name

• Balance due

7.Amounts due by dunning level

• Report type: Accounts with invoices

  Customer dunning may be a thankless task, but it is essential to the company's cash flow management.

  
  

  In difficult times, good customer dunning management can help to alleviate difficulties (bank overdraft, or even the impossibility of'honoring debts). Many companies are experiencing difficulties, not least because their customers were in arrears on payments that were not properly monitored. This tool allows you to classify your reminders by level and quantify the amounts due.

  
  

  Report structure:

  Filters: 

• Show me: All accounts

• Last activity: All time

• Status: Equal to issued

• Balance due: dispute of "€ 0, 0000 "

• Omitted: Equal to false

Group rows: Due date

Group columns: Dunning level

Columns:

• Dunning level

• Due date

• Sum Amount exl. VAT

8.Monthly Sales Trend

Report type: Invoices with invoice lines

Sales = selling price * quantity sold. Sales can be calculated for any period, but are often calculated monthly, quarterly, semi-annually and annually. This is the primary sales performance indicator.

Underlying report structure:

Filters:

• Show me: All invoices

• Date: Current fiscal year (January 1 N - December 31 N)

• Status: Equal to issued

• Omitted: Equal to false

Group by: Invoice date

Columns:

• Invoice date

• Amount before Taxes

9.Overdue Payments (30 days)

• Report type: Accounts with invoices

L’article L441-10 of the French Commercial Code lays down the general rules: unless otherwise agreed by the parties, the settlement period is 30 days from the date of receipt of goods or performance of the service.

Report structure:
Filters:

• Show me: All accounts

• Deadline: next 30 days

• Status: Equal to issued

• Omitted: Equal to false

Group rows:

• Account name

• Invoice Record Name

Group columns:

• Due date

Columns:

• Account name

• Due date

• Sum Balance Due

• Invoice name

10.Key accounts

• Report type: Invoices with invoice lines

The notion of key account is mainly used in B-to-B marketing. A key account generally refers to a customer who is particularly important to the company. This importance can be measured by the sales represented by this company or by its share in the total sales.

Report structure:

Filters: 

• Show me: All Invoices

• Invoice date: Current fiscal year (January 1 N to December 31 N)

• Status: Equal to issued

Group rows: Account name

11.Average payment term

Report type: Accounts with invoices

The payment period is the time between the invoice issue date and the date the customer makes the payment.

This payment period is regulated by law, which sets a limit of 60 days from the invoice date or 45 days end of month. Payment terms were reduced by the LME Law of August 4, 2008, and by a European directive that had to be transposed before March 16, 2013.

Report structure:

Filters:

• Show me: All accounts

• Invoice date: Current fiscal year ( January 1 N to December 31 N )

• Status: Equal to issued

• Amount Due: Equal to 0€

• Omitted: Equal to False

Group by: Invoice date

• Invoice date

• Average Age