Skip to content

Review sales by folder

The Sales by Folder screen shows sales for each folder, based on the filters you choose. You can print the results or export them to Excel.

On the Reporting tab, select Sales by Folder.

The Reporting tab with Sales by Folder under Analytics

The screen shows your filters, criteria and views across the top, and the matching folders in the grid.

The Sales By Folder screen with filters, criteria, views and the results grid

Sales totals for your filter selections are shown at the bottom right of the screen.

Amount, Discount and Total sums at the bottom right of the grid

Folders with transactions in more than one GL period

Section titled “Folders with transactions in more than one GL period”

A red folder number means the folder has transactions in more than one GL period.

A folder number shown in red in the Sales By Folder grid

To see the GL dates and amounts of its transactions:

  1. Right-click the folder number.

  2. Select View Transaction Details.

    View Transaction Details on the right-click menu

The Details for folder window lists each transaction’s GL Date, Amount, Discount and Total.

The Details for folder window with GL Date, Amount, Discount and Total

Set the time period in one of three ways:

  • Select a period from the Period drop-down.

    The Period drop-down set to This Year

  • Select the Year No Period icon to choose a year and period range.

    The Year No Period icon next to the From date

  • Select the calendar icon to choose a custom date range.

    The calendar icon next to the From date

Select an option from the Group drop-down. The grid totals change to match.

The Group drop-down options

Group option What the grid totals show
By Folder, By Estimate and By GLDate Totals by GL date, with each of the folder’s estimates shown separately.
By Folder, By Estimate Totals for each estimate. A folder can have several estimates, so all of them are listed.
By Folder, By GLDate Totals by folder and GL date. A folder can be listed more than once, depending on how many times it was invoiced.
By Folder Totals for each folder.

You can filter and group the grid, and add or remove columns. See Search, filter and save grid views.

  1. Set your filters and columns.

  2. Select New View.

    The New View button in the Views group

  3. Enter a name for the view and select OK.

    The View Name window with a view name entered

  4. When asked whether you’re creating a system-wide view:

    • Select Yes to make the view available to all employees. You need permission to do this.
    • Select No to keep the view for yourself.

    The Create/Update System View window with Yes, No and Cancel

To see all views, open the View drop-down. System-wide views show 1 in the Sys View column.

The View drop-down with the Description and Sys View columns