helpwith.salesorder.com
  • Read me first
  • Start!
    • How to move forward
  • Video Index
  • Live in 5
    • Step 4: Solution Plan
      • Workflow Guides
    • Must read: Data Migration
      • Read First: ASIC and presets
      • Transaction Migration Primer
      • Migrate transactions
      • Migrate from Quickbooks
        • How to categorize Quickbooks 'Open' Purchase Orders
    • Step 5: Launch Sequence
      • T -6: System Settings
      • T -5: Baseline preparation
      • T -4: 'Open' transactions
      • T -3: Trial balance
      • T -2: Set Stock levels
      • T -1: User testing / Dry run
  • Customer references?
  • Common Actions
  • Company
    • Workers and Users
      • Add new User login
      • Owners
  • Organizer
    • Memo
    • Contacts
    • Calendar
    • Email
    • Attachments and Linking
  • Expenses/Timesheets
    • Expense Claims
      • Mileage Claims
    • Timesheets
  • Sales Forecasting
  • Sales
    • Leads
    • Prospects
    • Customers
      • Credit Controls
    • Jobs
    • Sales Quote
    • Sales Orders
      • Common Sales Tasks
        • Pre-Authorization/Pre-Payment with BASYS
      • Ordered Item History
      • Stock Allocation
      • Pick-Pack-Ship Process
      • Sales Order List
      • Drop Ship
      • Special Orders (Just in Time)
      • Discounts
      • Prepayment/Deposit
    • Cash Sales
    • Sales Invoices
    • Payments from Customers
      • Processing digital Payments
      • Apply Credit Automatically on Payments
    • Customer Credit Notes
    • Customer Refunds
    • Delivery Notes (a.k.a Packing List)
    • Customer Statements
    • Shipments
      • Pick List
    • RMA
    • Commission automation?
  • Purchasing
    • Suppliers
    • Purchase Quotes
    • Purchase Orders
    • Cash Purchases
    • Item Receipts
    • Bills (Purchase Invoices)
    • Payments to Suppliers
    • Supplier Credit Notes
    • Supplier Refunds
    • PO Generator by Item
    • PO Generator by Order
  • Inventory Forecasting
    • Inventoro
  • Products/Services
    • Items - which ones?
      • Preferred Suppliers
      • Stock Items (SKUs)
      • Stock Assemblies
      • Kits
      • Non Stock Items
      • Group Item
      • 'Calculation' Items
      • Service Item
      • Matrix Item
    • Sites
    • Stock Adjustment
    • Stock Manager
    • Stock Locations
    • Categories, Tags and Attributes
      • Categories
      • Tags
      • Attributes
    • Images on Items
    • Item Extra Info
    • Price Levels
    • Price Lists
    • Advanced Price Lists
  • Banking
    • Cashflow Forecast
    • Checks
    • Bank Reconciliation
    • Petty Cash Accounts
    • Credit Cards
    • Money In and Out
  • Accounting
    • Accounting Periods
    • Payment Terms
    • Tax
      • Sales Tax
        • US Tax Codes
      • Tax Authorities
        • Working with HMRC (UK Specific)
      • Tax Codes
      • Tax Groups
      • Item Tax Options
      • VAT Returns
    • Currencies
    • General Journals
    • Memorized Transactions
    • Reverse Transactions
  • WMS: Warehouse Management
    • Stock View
    • Goods In
    • Goods Out
    • RMA
    • Shipping
    • Pallets
    • Kits and Assemblies
    • Stock Actions
    • Stock Count
    • Locations
    • History
    • Admin
    • Config
    • Barcode Scanner App ⛭
    • Multipacks
    • Overship Tolerance
    • Expiry Date
  • WMS Setup
  • Third-party logistics (3PL)?
  • Shipping
    • FedEx Manager Integration
    • UPS WorldShip Integration
  • Reports
    • Classifications
    • Report Mailer
    • Email Reports on Schedule
    • Accounting Periods
  • Setup
    • Roles
    • Email templates
    • Payment Processors
      • Basys: low fees, VIP service
      • Authorize.net
      • Cybersource
      • PayPal
      • USAePAy
      • Paragon (PAYA)
    • Configuration
      • Company ⛭
      • Memo ⛭
      • Ref # ⛭
      • Leads ⛭
      • Prospects ⛭
      • Customers ⛭
      • Credit Controls⛭
      • Jobs ⛭
      • Sales Quote ⛭
      • Sales Order ⛭
      • Sales Invoice ⛭
      • Customer Credit Note ⛭
      • Cash Sale ⛭
      • Statements ⛭
      • Shipment ⛭
      • Customer Refund ⛭
      • Delivery Notes ⛭
      • RMA ⛭
      • Pick List ⛭
      • Supplier ⛭
      • Purchase Quote ⛭
      • Purchase Order ⛭
      • Item Receipt ⛭
      • Cash Purchase ⛭
      • Bills ⛭
      • Payment to Suppliers ⛭
      • Supplier Credit Notes ⛭
      • Supplier Refunds ⛭
      • 1099 Categories ⛭
      • Kit ⛭
      • Accounts ⛭
      • Accounting Periods ⛭
      • VAT ⛭
      • Email Accounts ⛭
        • OAuth for Outlook 365 ⛭
      • Company Security ⛭
        • Two Factor Authentication
      • Classifications ⛭
      • Document Templates ⛭
      • Shipping Carriers
      • Sales Invoice ⛭
      • Payments from Customers ⛭
      • Sales Opportunities ⛭
    • EasyPost ⛭
    • Shipstation ⛭
    • Web to Lead
    • Import data templates
    • Exporting Data
    • Your Account
  • Shopping Carts b2c
    • ⚠ Live Shopping Carts
    • Shopping Cart controls
    • Shopify ⛭
    • BigCommerce ⛭
    • Magento ⛭
    • Woocommerce ⛭
    • Prestashop ⛭
  • Trade Acceleration Portal 2.0
    • TAP Users
      • Customers
      • Sales Reps
      • Sales Teams
      • Administrators
        • Configure barcode order entry
        • Get your Inventory List from QuickBooks
    • TAP UX
      • Global Brand Style
      • Themes
      • Pages
      • Blocks
        • Group Start
        • Plain Text
        • Image
        • Hyperlink
        • Menu Matrix
        • Title
        • Custom HTML
        • Block Configurations
          • Pixels and Percentages
          • Flex Box Settings
            • Flex Wrap
            • Justify Content
            • Align Items
            • Column/Row Gap
            • Align Content
          • Background
          • Dimensions
          • Border
          • Slider & Carousel
          • Margin Padding
          • Overflow Settings
      • Content Management System (CMS)
  • Trade Acceleration Portal 1.0
    • Configure barcode order entry
    • Get your Inventory List from QuickBooks
  • Customization
  • Volume Automation
  • EDI
    • EDI integration via XML
  • REST API
  • Schema Documents
Powered by GitBook
On this page
  • Sales Forecasting - need to know
  • Sales Opportunity Fields
  • Create Sales Opportunity
  • Create a Sales Document from a Sales Opportunity
  • Create Sales Forecast
  • Sales Forecast analysis
  • Cash Flow Forecast input
  • Submit Sales Forecast
  • Setup Opportunity Stage
  • About Opportunity stages

Was this helpful?

Sales Forecasting

Use Sales Forecasting to enable Sales people to record and forecast opportunities, and Sales leaders (and everyone who needs to know), understand and track the Sales pipeline.

Sales Forecasting - need to know

Sales forecasting consists of two elements, the Sales Forecast report, and one or more Sales Opportunity Documents.

Sales Opportunity Documents are used by Salespeople to:

  • Record opportunity detail at the Line Item (SKU) level.

  • Set the probability and weighting (see below).

  • Submit their forecast ‘up the line’.

  • Track their progress against a period target

Sales Opportunity Fields

Field
Notes

Opportunity

A name to identify the Opportunity

Forecast Status

A drop-down field. How far the salesperson estimates the deal is from closing.

The values are:

  • Committed - Confident the business will close in this period.

  • Closed - The business has been closed.

  • Omitted - This Sales Opportunity should be omitted from any forecast.

  • Lost - The business has been lost.

Close Date

The date the business is expected to close, set by the salesperson.

Opportunity Stage

A drop-down field. The current stage of the opportunity.

  • Qualified: Quote terms have been accepted.

  • Requirements Agreed: Product or service specifications agreed.

  • Proposal submitted: Quote submitted to the client.

  • Negotiating: Further discussions.

  • Definite: Opportunity is near to closing.

% Probability

A percentage indicating the salesperson’s estimate of the progress, relative to the Close Date, where definite would be = 100%.

Note: All these fields can be customized according to your sales team’s prerogatives.

  • Sub-Total (Weighted): This field cannot be changed as it is automatically populated. It is used to calculate the Weighted Sub-total; this is the normal Sub-total (i.e. pre-tax value) of the business, multiplied by the % value. This figure is a statistical estimate of the true value of the potential business.

Create Sales Opportunity

You can create a Sales Opportunity from:

Customer>Action>New sales Opportunity

  • Prospect Action>New sales Opportunity

  • Sales Opportunity>List Sales Opportunities>+

  • Sales Quote>Action>New sales Opportunity

  • Sales Order>Action>New sales Opportunity

The new Sales Opportunity will retain an ‘Our Ref’ link to the originating Document/Trading Partner.

Create a Sales Document from a Sales Opportunity

For the purposes of expediency, you can create these Documents from a Sales Opportunity:

  • Sales Quote

  • Sales Order

  • Sales Invoice

  • Cash Sales

The new sales Document will retain an ‘Our Ref’ link to the originating Sales Opportunity.

The system allows three levels of forecast reports:

  1. Company

  2. Team

  3. Personal (Individual Sales person)

Create Sales Forecast

Sales Forecasting>Sales Forecasts>+

Sales Opportunities update these fields in Sales Forecasts

Standard

The sum of the closed and committed Sales Opportunities during the specified period.

Closed

Committed

Total

Weighted

The weighted sum of the closed and committed Sales Opportunities during the specified period multiplied by the stage probability. Example: $3,186.40 x 100% (Stage is definite, which equals 100%) = $3,186.40.

Closed

Committed (Weighted)

Total (Weighted)

Pipeline

The total committed revenue even if the Opportunities do not lie in the specified period.

Pipeline

Pipeline (Weighted)

Sales Forecast analysis

The Sales Forecast Document has tabs that allow you to view:

  • All opportunities

  • Opportunity by Owner

  • Opportunity by Customer

Cash Flow Forecast input

Opportunities on the Sales Forecast appear in the Cash Inflows section of the Cashflow Forecast. See ‘Using Cash Flow Forecast’. The Cash Flow Forecast is located here:

Cash Flow Forecast users can customize this report to omit/include Sales Forecast inputs, Banking>Cash Flow Forecast>Action Bar>Customise>Cash in tab>Sales Forecast.

Submit Sales Forecast

To submit a Sales Forecast:

Sales Forecast>Submit Forecast

Once a Sales Forecast is Submitted, it cannot be edited and no new Sales Opportunities can be added/removed.

Setup Opportunity Stage

Setup>Configuration>Sales Forecasting>Sales Opportunity>new Opportunity stage.

  • Stage name, i.e. engaged

  • Description, i.e. ‘actively seeking information and attention’

  • % i.e. 40

About Opportunity stages

Opportunity Stages apply the weighting to the entire Sales Opportunity.

Opportunity stages represent the sales funnel stages and their respective probability. The basic idea is, as an opportunity progresses through a series of stages its probability of converting to a sale increases by a percentage.

For example, a stage describing the prospect as being ‘engaged’, meaning they are actively seeking information and repetitively asking for your attention might indicate a probability of 50%, therefore the deal is weighted at 50%, and the deal value is forecast at 50% of its total value.

If you have a wide range, or high flow of Sales Opportunities at every stage of your sales funnel and you need a simple method to forecast potential sales, then using weighted forecasting is probably the best approach.

Each stage would be defined by the information you uncover and confirm. The more you know, the easier it can become to predict the outcomes. For example, “at this stage, if this happens, or we have this information” then in 4 out of 10 cases, the deal closes. In other words, at this stage, the probability of this deal, in these circumstances at this time is 40%.

Regardless of whether you have a high or a small number of Sales Opportunities, if you closely examined the probability of each one, you would probably discover a pattern of stages.

This analysis can be time-consuming, it’s all about recording, measuring and testing assumptions. To do this efficiently you need a sales forecasting system. As we all know, what gets measured gets managed.

Either begin with some simple opportunity stages (you can evaluate the stage’s merit over time) or just transfer your current process into stages.

PreviousTimesheetsNextSales

Last updated 10 months ago

Was this helpful?

Tip: Before you create a Sales Opportunity be sure to .

set up your Opportunity Stages