Dashboard 'Sales Analysis Financial (8014)': general explanation

Target audience

• Controllers
• Sellers

Where in MKG?

1. Open the module My Company.
2. If the dashboard is not immediately displayed: click on the hamburger
   in the top right of the button bar and select the option 'Forms' » 'Dashboard'.
3. Click the Views
   button and select Sales Analysis Financial (8014).

Parameters

• From Period: the period from which the dashboard shows data.
• Until Period: the period up to and including which the dashboard shows data.

Special notes

This dashboard can analyze the following types of postings (sales postings):

• Sales Invoice (transaction type 02)
• Sales Cost Price (transaction type 03)
• Sales Installment Invoice (transaction type 04)
• Debtor Payment (transaction type 10)
• Manual Sales Invoice (transaction type 14)

Margins

This section is intended to provide insight into sales results per customer and the associated margins. The debtor table can be zoomed in at the invoice level. This tab is a more detailed specification of the 'Sales Result' tab. The data is filtered on:

• Revenue (transaction subtype 02)
• Cost Price Material (transaction subtype 47)
• Cost Price Man (transaction subtype 48)
• Cost Price Machine (transaction subtype 49)
• Cost Price Outsourcing (transaction subtype 50)

Sales Result

This section is intended to provide insight into sales results and the associated postings. The data is filtered on:

• Revenue (transaction subtype 02)
• Cost Price Material (transaction subtype 47)
• Cost Price Man (transaction subtype 48)
• Cost Price Machine (transaction subtype 49)
• Cost Price Outsourcing (transaction subtype 50)

These transaction subtypes determine the order result when there is a setup with 'Revenues posted through an intermediary account'.

This tab provides an overview of all sales postings in the relevant period. These are presented in:

Each table can be selected, and the other tables will respond. The debtor table can be zoomed in at the invoice level.

Invoice Analysis

This tab provides insight into invoicing. The data is filtered on:

• Revenue (transaction subtype 02)
• Balance (invoiced via intermediary account) (transaction subtype 82)
• Advance (installment invoices) (transaction subtype 83)

This tab provides an overview of all the above postings in the relevant period. These are presented in:

Each table can be selected, and the other tables will respond. The debtor table can be zoomed in to the invoice.

Debtors

This section is intended to provide insight into the debtor status and the associated postings. The data is filtered on:

• Invoice (transaction subtype 01)
• Debtor (transaction subtype 32)
• Advance (installment invoices) (transaction subtype 83)

This tab provides an overview of all sales postings in the relevant period. These are presented in:

Each table can be selected, and the other tables will respond.

General Ledger

This tab provides an overview of all sales postings in the relevant period. These are presented in:

Each table can be selected, and the other tables will respond.

This section is intended to provide insight into the booking process for financial connection control. It provides insight into the relationship between the type of postings and the general ledger accounts. As a selection, it can be indicated what should be displayed:

1. All journal entries
2. Recorded journal entries
3. Unrecorded journal entries

Unrecorded journal entries are the postings that cannot be found on a general ledger account. The financial setup determines which postings are included or not.