Reports Topics
Set Filters (Sales Reps and Multi-Locations)
Overview Tab: Contracts/Deposits/Balance Due
Overview Page Reports
There are 5 tabs on the left side of the overview page. We will go over each.
Set Filters (Sales Reps and Multi-Locations)
If you are using sales reps or have multiple locations, you will have the option to filter the reports to see only that location or sales reps events.
When a sales rep logs in, the system will automatically set them in the filter by default. If you want to disable that you can remove the ‘Overview Filter’ option on that workers account settings. (A sales rep can always see other sales reps performances).
For multiple locations, the filtering is done automatically based on the logged in users access to their locations. A user will not be able to see details of a location they do not have access to.
Overview Tab: Flagged Leads
This page is designed to help you see any events that might need you to take action. The Flagged Leads table shows why various leads might have been flagged.
Click on the lead to see the details
Here are the different scenarios where a lead can be flagged:
Conflict - This event has an item that is in conflict with another event
Survey - A survey has been recently completed
Flag - The event was manually flagged as needing follow-up
Call - The customer has requested that you call them
Booking - Customer has automatically begin booking this event, you may want to verify it.
Clearing A Flag
To remove a flag from an event, you can go to that event, and remove it by hovering over the exclamation next to the event name.
At this time you cannot clear a Conflict flag. To clear a flagged-for-follow up lead (shown as Flag on the overview page), you’ll need to edit the event.
Clearing or setting a lead for follow-up
Overview Tab: Contracts/Deposits/Balance Due
This table shows upcoming events that either need to pay their deposit and/or need sign their contract.
The Rcvd column (abbreviated for Received) lets you know when the contract has been received and signed. If it says DUE, then they still need to sign it.
The $ Dep (abbreviated for Deposit) shows the amount they have paid for the deposit or DUE if they have paid none.
Once the full deposit has been paid and the contract has been received or signed, the event will disappear from the chart. If you need to make adjustments to when the contract was received or the required deposit, you can edit the Contract tab of that event.
If a customer has not signed the contract online, you can fill in the date for when you received a physical copy of the contract on the Contract tab for that event.
Sales Tab
First, the sales amounts are based on the event total, so they do include tax. If you want tax to be excluded from the sales amount you’ll need to email us and we’ll make the change for you.
YTD Sales by Month (top-left chart)
This chart will show you your total bookings up to today. It helps you compare how your bookings are this year compared to the same time for previous years. For example, if today is June 4th 2012, then the 2011 column will only include sales that were booked between January 1st - June 4th 2011.
YTD Sales Difference (top-right chart)
This is the most important chart to look at because it will help you see how your bookings are this year compared to previous years. The amounts shown will help you quantify how much better or worse you are doing in that month compared to previous years. Red negative numbers mean you are behind for that month compared to how you were doing last year for that month.
Sales by Month (bottom-left chart)
This shows your total sales by month.
Sales Difference (bottom-right chart)
Shows the difference in sales compared to previous years.
Projected Sales
This is calculated by taking the average yearly sales for the last 3 years, plus the average YTD sales difference.
Charts Tab
The charts tab will give you insight into your Lead->Event conversion rate, which rentals are the most profitable, and more.
You can change the time period to anything you would like to see
Stats Tab
Most of the details on this page are self-explanatory. You can hover over the text to get an explanation of what it means.
Workers Tab
These reports are only used if you have the worker add-on. It will help you know what events have no workers assigned and also if workers have or have not acknowledged their shift. In order to allow for workers to Accept or Decline their shift you must use the Email button on the Shift tab of an event to email the workers.
Lead Reports
Export Leads
This enables you to generate custom reports. You can decide what information you want to export and you can save the reports for future use. Only the leads that match your filter settings will be exported.
(see existing data)
Packing List
Use the filter first to show the leads you want to print a packing list for. The packing list is meant to inform your delivery crew what items are going to each event. One packing list in generated for each event. If you want to specify the packing list for an item, then go to Settings->Rental Inventory, click an item, then click on the "Options & PL" tab.
Vehicle Packing List
(get from the email template)
Step 1) Filter Your Leads:
Currently reporting only occurs from the leads page. The first step is to tell the software what leads you want in your report by using the filters on the left side as shown below. You can also use preset filters as shown below in the center. We've added a couple more just for fun. You can also order the data by clicking on any of the sortable columns, such as the Date column pictured on the right.
Filter Leads
|
Preset Filters
|
Sort Data
|
Step 2) Click the Export Button:
Here is where you define the columns that you want in your report and their order by dragging them into position as shown below. Columns are sorted alphabetically in the available columns box.
Step 3) Save, Export to Excel, or View Your Report:
After you've defined your columns, you can choose to group by a certain column to force dollar values to sum if you want. If it is a report you will use frequently, you can save it for quick retrieval later. When you are ready to see your report, either use the Export button to send it to Excel, or use the View button to open a new browser tab with the report in it. After saving the report, it is accessible below the leads filter via the quick report drop-down for quick access.
Save Reports
|
Quick Reports
|
To get started, we've pre-populated your account with a couple reports.
© InflatableOffice, LLC | info@inflatableoffice.com | 440-385-4080