Wizard DataWizard Data

The Data tab of the Wizard helps you understand the progress your team is making in grooming your data for use. While you don’t actually enter data here, this is where you learn all about data.

So what data is needed for iPoint? There are 3 primary data types needed:

  1. Items – this is the basis of what you sell to your customers, what you purchase from your vendors, and how you push accounting and inventory details to QuickBooks.
  2. Customers – if you don’t have customers, is there really a business?
  3. Vendors – you gotta buy stuff to be able to sell it. Vendors are where those things come from!

Data can come from multiple places

  • We can import it directly from QuickBooks or QuickBooks Online.
  • We can import data from your old software. If your old program can export a .csv file, we can import it into iPoint.
  • If you are a member of Portal.io, you can import items from the Portal database.
  • As long as it is formatted correctly, we can import price sheets from your vendors.
  • You can enter data the old fashioned way, manually and by hand.

University Videos

You’ve become accustomed to watching videos in the Wizard in the previous tabs. But this time there is a slight twist.

We have the normal Required videos. You, or someone in your organization, will have to watch each of these videos in order to advance to the next Wizard step.
We also have some Recommended videos which give you more advanced tricks and tips. You don’ have to watch these, but we sure think it would be smart if you do!

Again, click the Watch Now link to see the associated video. And once anyone from your organization has watched a video, you’ll see the date and time that it was watched.

Data Progress

The list of data items needed to make iPoint function are displayed with some information you’ll find helpful.

  • Data Type – this is the name of the data field
  • Progress – this will list how many items have the associated data, or if you’ve pulled in specific data elements.
  • Goal – this is the number of data elements you should have. We populate this list based on industry averages of all companies your size that are using iPoint .
  • Status
    • If you’ve met your goal, you’ll see DONE.
    • If you haven’t quite achieved the goal, you’ll see Not Yet.
  • Ignore – there may be a data field that you do not want to utilize. If that is the case, place a check in the Ignore checkbox for that field. Then iPoint won’t count that field in your data progress.
    • Note: Here at iPoint, we think all of these data fields are important! That’s why we created them in the first place. So if you opt to ignore a data field, we’ll ask you to confirm your decision to opt-out of that particular milestone by presenting a pop-up window.

So, let’s look at each data field in a bit more detail.

  • QB Chart of Accounts – In order for iPoint to synchronize financial details to QuickBooks, we need to import the chart of accounts. This is done in Settings > QuickBooks > Chart of Accounts.
  • QB Defaults – Defining a set of default accounts will ensure that financial details get synced to QuickBooks even in the event that the item itself doesn’t have a specific Chart of Accounts association.
  • Modifier Items – Modifiers give your sales staff the flexibility to account for additional markup on a job. [ Read More ] This field indicates how many of the modifiers have been defined.
  • RFP/Summary Item – If you have chosen one of the RFP accounting methods, there is some setup that has to take place. This lets you know if those settings have been completed. [ Read More ]
  • Items – The item in iPoint is the basis of nearly all transactions in iPoint and as such, there is a lot of information to capture. The average iPoint Community Members have about 1,900 parts in their item database. We’re not asking you to get all those parts in at first. To get started, you need to be sure to have 400 of the items you use most frequently. GOAL 400 items
    • Note: The following fields are on the Item itself. The goal listed is a percentage of the items you have in your database based on the industry average for a company your size.
    • Manufacturer – Who makes the product. This is also used to sort and find products in iPoint. GOAL: 95% of items should have a manufacturer.
    • Category – This would be a breakdown of kinds of equipment and is used to sort and find products. (e.g. Speakers, Display Devices, Network Equipment) GOAL: 72% of your items should have a category.
    • Type – This is a secondary sort and find field for each category. (e.g. Speakers might have In-Wall, Free Standing, or Two Channel, while Display Devices might have Projector, LED, or Monitor. GOAL: 45% of your items should have a type.
    • Cost – How much money do you pay for the item when you purchase it. This will be used on POs and for calculating job costs. GOAL: 89% of your items should have a cost.
    • Price – What does the customer pay to buy this item? GOAL: 92% of your items should have a price.
    • Inventory Location – Where in your company is this item stored? If you have multiple stores, you can set multiple defaults for each location. This also helps you put the product in the correct warehouse if you have multiple storage locations. GOAL: 50% of your items should have a default inventory location.
    • Vendor – Who do you buy the product from? This is used in the purchasing process. GOAL: 60% of your items should have a vendor listed.
    • Labor Phase – This tells iPoint what amount to charge customers for the installation of an item. Labor Phase is also used to sort items on proposals, sales orders, work orders, and purchase orders. GOAL: 50% of your items should have a labor phase.
    • Labor Time – Used in conjunction with the Labor Phase, this tells iPoint how much to charge for an item. For example, .5 means that the customer will be charged a half an hour of whatever the labor phase price is. GOAL: 50% of your items should have labor time.
    • Synced with QB – This number tells you how many items have been synced to QuickBooks. GOAL: 50% of items should be synced to QuickBooks.
  • Customers – How many customers are in iPoint? GOAL: Based on our experience, you’ll have at least 50 customers.
    • Synced with QB – This indicates how many of those customers have been pushed to QuickBooks. GOAL: 50% of your customers should be synced to QuickBooks.
  • Vendors – How many vendors do you have? GOAL: Nearly every customer has at least 10 vendors.
    • Synced with QB – How many of your vendors have been pushed to QB? GOAL: 50% of your vendors should be synced to QB.
    • Punch Lists – This is a list of sub-tasks that you want technicians to complete when installing an item. GOAL: We want you to have at least 2. [ Read More ]
    • Notifications – You can customize how iPoint lets your staff know that certain things have been completed in iPoint. GOAL: We think you should have at least 2 notifications built. [ Read More ]


Once you’ve watched the required videos and all data elements are either DONE or ignored, you’ll be able to advance to the next step by clicking the Let’s Go button.

Last modified: 3 Aug 2020

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.