Report: Collected vs. pending sales

View sales that have not yet been collected.

Go to Reports > Sales > Paid vs. Pending:

In this report you will be able to have a control of all those sales created that are pending to apply a collection or that have already been applied.

When you enter you will see a window similar to the following:

Filters:

To filter data in the report, use the filters located at the top:

• Group: You will be able to apply filter by executives, sales groups, product lines, origin: country, region, city or industry.
• Sales: Determine the type of report you want to visualize.
1. Realized: It will show the amount of sales according to the creation date. If the contact was created in January, but created a sale in March, it will show the sale in the March column. Regardless of the status of the payments.   
2. Pending: Are those sales that have payments that have not been applied.
3. Effectively collected: It will show the amount of the sales according to the creation date. If the contact was created in January, but created a sale in March, it will show the sale in the March column. TAKING INTO ACCOUNT THAT THE PAYMENT STATUS IS 'COLLECTED / MADE'.       
4. Made vs. collected: This is the comparison of how many sales were collected versus how many sales have been made.           
• Year: Select the year for which you want to see the information.
• Group: By sales force group.
• Currency: Shows you the type of currencies you have registered in the system.
• Save to favorites: You can create the filter you require:

Graph:

• The filtered information will be displayed in a graph.
• If you place the cursor over one of the bars it shows you the type of contact and the amount.
• You can select or deselect the information by clicking on the corresponding colored box so that only the name of the selected executive or group is displayed in the graph.
• It allows you to enter the sales detail where by clicking on the quantity or totals, you will see which are the contacts to whom a sale has been made.
• You can choose between displaying three graphs: stacked column, linear or comparative stacked column.

Export:

• The detail can be exported in CSV, JSON or MailChimp either the display data or all of it.

Important:

• Take into account the date the sale was created regardless of the date the contact was created.  
• For example: If you created a direct sale in September as pending for $1,000, in this report in the 'Pending' filter will appear this amount $1,000.