Intuit® ProLine™ Business Analysis Application
Contents
1. J 18 Create Child BUSINESS P E 19 Sorting Child Businesses by a Category ccccccccccccsssessssececececessesesaeeeeeeeceseeeaeeeeeseseeseeaeaeeeeeeeseeseeaeaeeeeeceseeseaaeeeeeesceseseeaeaeeeescesesaaaeaeeeessessesaaeeesess 20 Monitor Business to Business Relatonsbips eaea eae aE EE EE E E EE a EEEE EEE aE EEEE EEKE EEEE KEES 21 usce 22 Assigning User Roles and Permissions after Inviting a User 23 REMOVING BET 24 Startup Information tor Glients and Users nicer roh eoe erint hats evs ee Dew eee venie a aa pee tet up ee fe bnt o ellos ee OP veas ES 25 Receiving an Invitation from an Administrator 25 Existing User Login Proced tes ce o tree besten EDO ERO SEE mares Ee saute olt pe E ECE E EERE EREA egg 26 Forgotten User ID OF PaSSWOMK PR 26 UE 27 Updating Your Email and Password ccccccesssssaeceeececeeseeaeaeeeeeceseeseeaeaeeeeeceseesaeaeeeeeseeeseeaeaeeeseceseeseaaeaeeeeeceseeseaaeaeeeescassueaaaeeeesesenesueaaaeeeseseeseseaaeas 28 Differences Between User Permission Levels sese nenne enne enne nnne entes tnst sntnnrenteneet nns e tnis en tete eines etr ss nnns entere en rn sett rennen en nnes 29 Sync Application Uploading Files for Clierits nere eiit etri oe E ene x uoa SEEN Ve eR ER aa a CENE TERRE REED GRE A NR RR CREER NER UNE Rp CAE ERR SNR EE 30 Sync Scheduler Incremental Syncing of Non Hosted Quic2. Ad can henes de has vt Step 2 Users and Permissions Step 2 Sync your QuickBooks fies Create a Child Business Intuit ProLine Business Analysis The Administrator can set up parent child business relationship to represent a franchise or a business with multiple locations Once a parent business has been created the Administrator can then create a child business under it 1 Navigate to the Home tab 2 Click Manage Add Businesses 3 Create the child company by adding the business name and clicking Create 4 Once added the Administrator may select hold drag drop the newly created child business under the desired parent company The grouping will be saved automatically Business Management The above screenshot is directing the Administrator to clickshold drag the child company and drop it on the region Colorado The side screenshot now shows the associated parent child relationship with Colorado as the yo The busoest corta typecal profile data ig contact information Each buseess may hne ony one QuckBooke Ee mc d You can group boseet te1 Mul represert dependent ioc oes together 10 represent Chents motq e locaton francheses states regen or other types of tat egong abor Left chch hold and drag to move buyers around or drop them on ancther group w ones to Create parent chid reegt ASS at mary butness as deseed ery step When you are bied adding and mo buseeises
3. Business Management Business Management Add Business Name The buten conta typical profe data Vive Contact information E ach buseess may have ovy G one QuckBooke fle rm d You can group busoettet Put represert edependet loc abont together to represent chents multiple toc ation tanchises states wo or other types of Cat eon abor amp Texas Stores D Ausin Regon Datas Stores i9 Derer Stores ig Co Left chch hold and drag to move buses Durango Stores mound or drop them on another group or burners A 2 to Create garert chid reutbconsos Add pt mary buteness an Geteed durng step 1 When you are fered adding and mo busresses cick Next to goto Step 2 The tates conta f nd s ose dara the Contact amaan Fach buses may haver orty ne Onctfocke Ke wy d Yos can group btt vr I epret ndepem ent oc amore bageta to swpresert derti mapie ox ster KkecZepeg tes gone ohe types vf Seid aon L cica fobs and Greg te rove bverentes word w Sue er of mothe grup o wueno The above screenshot is directing the Administrator cse emm omncm o clidchold draz the child company and drop it on the region Colorado When you ane eov attire aestimare buste ek Nent te goto Step 2 The side screenshot now shows the associated Step 2 Users and Permissions parent child relationship with Colorado as the Add m mar urne se Greg Bum vec Step 3 Sync your Qu kBookst files T Ads Business Name j D te
4. Chick Next to goto Step 2 Business Management Add Business Name B Texas Stores 8 Ausin Regon Datas Stores i9 Denver Stores Coen The teens Cont ema types pese data the Contact edpmmaton Lach tuerwes may haver orty we Quchflockal le wy You can group buten ven hal represet rubependert ox anions Vier to nmpresent Cheeta multiple ox atero bachot Gates ons oF fier types of Eer aon Lef cich Moke and Ei rove Dusmed tes around u dup Der re matta pro w urner te Conato parent MAC onanga Add os marr Tuten pt preot Gong vec t Wiser yo sre ee adire and mans Duvet ve ek Jagat to Qui Sep 2 Step 2 Users and Permissions Step 3 Sync your QuxkBooks files gf 19 Intuit ProLine Business Analysis 20 Sorting Child Businesses by a Category The Administrator can organize Parent Child Businesses in a multitude of ways Grouping child businesses by category under the parent company not only allows for visible organization but assists with reporting as well Parent Child Categories In the list below you will find the company A Lawn Care This is a parent company The Administrator then chose to create a child company underneath it Lawn Care Store 1 Regional Categories In the list below the Administrator chose to create Regions to aid with sorting purposes The Region categories are created using the same steps as create a child business but instead of having a Qui
5. ProLine Business Analysis 39 Reporting Users with Viewing permissions may follow these steps for viewing reports 1 Viewer logs in to their ProLine Business Analysis application 2 Viewer clicks on the Reporting tab at the top checks the boxes for the business es they wish to view reports for and then selects the type of report they wish to view Reporting Dashboard iome Reporting Getting Started Profile Karnes Logout I Es Monthly e ThisCalendar YTO e Grid and Graph O Account map ea i gm El 4 Lawn Care 3 The Viewer is then able to set date filters and view preferences grid only graph only grid and graph for their report A Viewers can change date filters by using the drop down menus B Reports will always display in a single page method with charts above and reports below unless the Viewer opts for a chart only or graph only display Intuit ProLine Business Analysis A0 Exporting to Excel Financial reports may be exported to Excel using the Export to Excel button in the top right corner of each report Note Only grids will export to Excel not graphs Reporting Dashboard ProfitAndLoss Home Reporting Getting Started Profile Karnes Logout Monthly This Calendar YTO e Grid Only LDJAccount map Export to Excel Ordinary Income Activity 16 000 16 000 16 000 Guides 910 910 910 Hotel 31 819 31 819 31 819 Pegasus Other 12 420 12 420 12 420 sts Re
6. The Network Administrator will automatically default to having both Viewer and Contributor permissions for all businesses within his network 1 From the Home tab click Manage All Users 2 Apopup window will appear with all users within the Administrators Network Click on a user in the list that appears 3 Anew popup window will appear showing all businesses within the Administrators Network 4 Save farted potir Karnes j Logout Please Select a Business Select a business to your left to view your company snapshot and set alerts Business Permissions Manage All Users in a Network ECTE 7779 eg Active Kristin Kames Bethany Nage 2 Ade Bethany Nagel Actne Dustin Kames Colorado 4 Actne kristin kames f Add New User Remove Users Note The Network Administrator will automatically default to having Viewer permissions for all businesses within their network Intuit ProLine Business Analysis 24 Removing a User An Administrator can remove a user Removing a user will completely disassociate them from that Administrator s Network and delete all viewing permissions for the businesses they had access to 1 Navigate to the Home tab and select Manage All Users under the Actions column 2 A popup will appear Click the Remove Users button 3 Anew popup will appear listing all Users in the Network Check the box next to the desired Users name and click Remove Piease Select a Busines
7. V Fish Stove Ji Pegasus DJ ses v setter Com eo Texas Stores Ji Two Geothers Lawn Care Report Types Profit and Loss Balance Sheet Cash Flow Benchmarking A R Aging A P Aging Account Name Current Ratio Gross Profit Margin Quick Ratio Acid Test Return on Assets Working Capital Home Grid and Graph e Account map Refresh 6 32 88 88 6 27 42 03 3 933 548 Seller Corp Intuit ProLine Business Analysis Reporting Getting Started Two Brothers Lawn Care Note Each column can be sorted in ascending or descending order simply by clicking on the column header name Note Reports must be re generated for each viewing Profile Karnes Logout 46 Intuit ProLine Business Analysis 47 Ratio Report List A P Turnover Ratio A short term liquidity measure used to quantify the rate at which a company pays off its suppliers Accounts payable turnover ratio is calculated by taking the total purchases made from suppliers and dividing it by the average accounts payable amount during the same period A R Turnover Ratio An accounting measure used to quantify a firm s effectiveness in extending credit as well as collecting debts The receivables turnover ratio is an activity ratio measuring how efficiently a firm uses its assets The A R turnover ratio is calculated by taking the net credit sales and dividing it by the average accounts receivable Altman s Z Score A predictive model creat
8. at the same time and on the same day 3 All QuickBooks files MUST be closed for a scheduled sync to take place If one QuickBooks file is open then only that file will update when the scheduled sync occurs 4 If QuickBooks is running in background mode QBW32 exe then the scheduled sync will not take place QuickBooks must be completely closed Setup a Scheduled Sync for Non Hosted QuickBooks Data Files 1 After a QuickBooks file is linked the Contributor will click the Schedule Sync button in the Sync Application The Sync App Scheduler will then open Qvinci Sync 1 1 3834 15977 Sync App Scheduler Only one version of D vinci Sync can be active at a time Please close the application before the scheduler runs Select Monday Weekly Tuesday Bi Monthly Wednesday Thursday Friday Saturday Monthly Seu Sunday AM wi el os lov Schedule Tasks Clear Tasks Back 2 The Contributor can then select the Day Time Frequency for the incremental syncs to take place 3 Once the desired schedule is reached click the Schedule Tasks button to save the schedule Intuit ProLine Business Analysis 28 Sync Scheduler Incremental Syncing of Hosted QuickBooks Data Files Once a Contributor links the QuickBooks file s in the Sync Application they are able to schedule future incremental syncs so that the data in ProLine Business Analysis is always current with the QuickBooks
9. dewe Stores C ewe D es C sese cor BC ren Store C Austin Region e Dalles Stores a Two Brothers Lawn Ces Profit and Loss Balance Sheet Cash Flow Ratios Benchmarking A R Aging Getbng Started Gnd and Graph v CAccount map Retesh Expor to Excel Jan 10 Feb 10 Mar 10 Apr 10 May 1C dun 10 Aug 10 Sep 10 Oct 10 og a Account Name dan 10 Feb 10 Mav 10 Apc 19 May 10 dun so EIER Avg 10 Sep 10 Oct Ordinary Income Actiaty 16 000 16 000 16 000 910 910 910 31 819 31 819 31 819 12 420 12 420 12420 49 594 49 594 49 594 9 255 9 255 9 255 35 198 25 198 26 954 Note Reports must be re generated for each viewing Intuit ProLine Business Analysis 43 Balance Sheet Reports This is a sample Balance Sheet report grid and graph using a Monthly frequency and This Calendar YTD as the date filter Reporting Dashboard BalanceSheet Home Reporting Getting Started Profile Karnes Logout Businesses Monthly This Calendar YTD Grid and Graph Report Types Profit and Loss Balance Sheet Cash Flow Ratios Benchmarking A R Aging A P Aging Jan 10 Mar 10 A8 Sep 10 Jan 10 Jul 10 Sep 10 Febio Aer HD Jun 0 Aug ng Oct 10 Feb 10 Apri Jun Augi Octi Current Assets Checking Savings Checking 222 238 222 238 222 238 222 238 222 238 B1 Chase Busine 2 716 2 716 2 716 2 716 Intuit ProLine Business Analysis 44 Statements of Cash Fl
10. 3 767 6 188 17 489 1 681 1 661 3447 6 808 9 089 9 089 12 708 30 995 10 512 10 512 14 096 35 120 0 0 11 333 11 333 10 836 10 836 16 689 38 361 0 0 0 99 2 458 2 458 9 666 14 583 5 381 5381 21 523 32 295 767 767 2132 3 665 46 927 46 898 100 181 197 861 Mike the Tiger Company Mike the Tiger So Lonely Pat Gunn Tesco Sandy Shores Tracy Bing 7 Trash Company Two Brothers Lawn Care 0 0 0 0 0 0 0 0 0 0 0 0 0 ZacTesScsinesst Total ZecTestBusiress2 i Report Types Profit and Loss Balance Sheet Cash Flow Note A P reports can be exported to Excel using the Export to Excel button Note Reports must be re generated for each viewing Intuit ProLine Business Analysis 51 Accounts Payable Reports Accounts Payable tables are available in the ProLine Business Analysis application however the date filters do not apply and thus do not need to be set 1 Navigate to the Reporting tab select the desired business es from the Businesses column and select A P Aging 2 Select the Export to Excel button if desired Reporting Dashboard ApAging Home Reporting Getting Started Profile Malone Logout Monthly ThisCalendarYTD GrdandGraph ElAccount map Refresh Bob The Subcontractor 18 000 0 20 000 Business Consulting And Accounting 350 0 350 Dunn Lumber 4750 0 4750 Home Depot 220 0 220 Qwest 100 0 100 Mine t e Tager Coca y Sh
11. Home Reporting Getting Started Profile Karnes Logout Personal Information User Profile Kristin Karnes Update Email Fish Store Never O Sie CR ae 8i Two Brothers Lawn Care Never 7 North Stove Never D Billing Address South Store Never O Credit Debit Cards Texas Stores Never C E Checks Austin Region Never O My Invitations Dallas Stores Never O E Colorado Never D Denver Stores Never O ee Durango Stores Never D Seller Corp Never D Pegasus Never O dfjktajft Never D sdkifjsdf Never D sdfs Never O Lawn Care Store 1 Never D A Lawn Care Never O Never see const 59 Intuit ProLine Business Analysis D Account Mapping Account mapping allows the Administrator to create a unified chart of accounts across multiple businesses to allow for easier report viewing Note Only an Administrator can set up account mapping However all Viewers are able to view reports with account mapping when desired Setting up Account Mapping 1 For the Administrator to set up account mapping navigate to the Home tab and select Account Mapping 2 Select the desired business es from the list on the left for which you wish to map categories for 3 Select a business category from the drop down menu Account Mapping om wm HA RRRRRAS d Reporting Getting Started Profle Maione Logout List of Businesses Business Category Select Check ai M Special Accounts locked ken Busine
12. Intuit ProLine Business Analysis 1 Intuite ProLine Business Analysis Application Startup Guide Contents grub ep H 4 SYSTEMERE LE CN 5 Compatible Web Ree 5 System Requirements for the Sync Applicatton esses esee eene nnne nnne ene nnst sten s nisse eaae sies eaae sies sa diss ss sas n sess sa senses eaae sies sane nsi 5 Compatible QUICKBOOKS VErSiONS RRRRRRRRRRRRRR 5 Getting Started FlOW AST E n 6 Startup Information for Network Administrators eene nnn sse nnns seen rn sisse tn sisse tn sisse ntn ns sse rn sisse tn sess serene nennen nnn 7 Intuit Workplace ACCOUNT E 7 Updating Profile Informatloh oec eicere ceret eget eadein eee caeso ra eve e rude cu aae ANCE a aeger aee quaa een Dee 8 raise tm 9 Sample NCTWORK Layt E 10 Types of Businesses within a Network 11 Differences Between User Permission Levels ete tnr t eere HERE Fg a RE ERE Y sande a RS ERXE RUE eV e ER a eters Ek Rupe ger pb RR ee 12 Setting UP ai BUSINESS NEEDLE OT LIO DODENUS EIER 13 e uleeft KE 16 Intuit ProLine Business Analysis 2 Edit an Existing BUSINESS vit teer eer e x Esdr toa tenens vndique tela tes tellus VE ERE Tener eb n Teese ve Ee Tested base Fee ier ER Fes ERE 17 BINE
13. Report Types Profit and Loss Account Name Balance Sheet Ordinary income Cash Flow Income Ratios 101 Invoice GRP Total Income Merchandise Sales A R Aging Sales Discounts A P Aging Senice Sales Total Ordinary Income Benchmarking Note Side by Side Business analysis reports can be exported to Excel Note Reports must be re generated for each viewing Intuit ProLine Business Analysis Example 2 Multi Company Balance Sheet Report using Side by Side Business frequency and Last 6 Months date filter in grid only format Reporting Dashboard BalanceSheet Report Types Profit and Loss Cash Flow Ratios Benchmarking A R Aging A P Aging Checking Savings B0 Chase Checking B1 Chase Busine B4 Petty Cash B7 Wachowa Checking Bank Accounts Chase Wells Fargo Total Bank Accounts Other Total Bank Accounts Ozona Checking Account Wells Fargo Savings Total Checking Savings Accounts Receivable Accounts Receivable Total Accounts Receivable Other Current Assets Note Reports must be re generated for each viewing Getting Started Profile Karnes Logout 53 Intuit ProLine Business Analysis 54 Viewing Reports in a Parent Child Franchise Company If a viewer is part of a Parent Child Franchise setup the Administrator can grant the user viewing privileges to multiple child companies under that franchise This enables the viewer to compare their company s financials to that of sister st
14. aeeeeeeeeeseeaeaeeeeeeeseeeeaaeaeeeeecessesesaeaeeeeecesseseaaeaeeeeseeeeea 52 Viewing Reports in a Parent Child Franchise Company cccesccccsseceescecesseccssseccssececssecesseecsaesecssecesseecssseccsaesecaseceseecesseccaaececasecessecesaeeeeaaeceeseeeeaees 54 Viewing the Financial Summary of a Business 55 Viewing Multiple Financial Summaries at One Time 56 Setting Alerts and Notifications eicere trennen eee dore eae eae v deeg veau Evi Pe RE cor nibus niece E HERE ege NEEN 57 Early Warning Indicator Alerts n erii te eere ri Ee E qe e aer Ee EE NR EEN AE ade LENA AXE RR ER SEEN A NRI RETE SAFE RE ENEE 57 Financial Summary Notifications ccccccccccessssssseseceeecesseseeaeeeeeeecesseeeaeeeeeeesesseseaaeeeeeeeeeseeseaaeeeeeeeseeseeeeaeseeeseseeseeeaaeeeeeessuuseeaeaeeeeeeeseeseuaeaeeeseessensenaeas 59 Account Mapping cerei datore sea inet cnt whee nd dest dia Dent gen Safed ed uen ee EX d Rea ed ERE dt ches ad Ext dda Mee caves E aah Thess e See v4 ck cha a Ve ERR RE dU chece tel tease dd hase e ERR R addo 60 Setting UP ACCOUNtT MAPPING Per EEE 60 Using Account Mapping when Viewing Report 62 3 Intuit ProLine Business Analysis 4 ProLine Business Analysis delivers instantaneous business reports from 1 to 20 000 QuickBooks files anywhere in the world over the internet The ProLine Business Analysis application has the ab
15. am Stores B Astin Regon i Owtn Soer 21 Intuit ProLine Business Analysis 22 Invite Users The Administrator can invite clients to view the businesses within his or her Network To do this the Administrator need only send an invitation to the desired party Once invited the invitee will receive an email notification containing login information and the URL 1 2 3 4 5 Navigate to the Home tab and click Add New User Enter the new user s name and email on the following screen Click Send Invite to invite the user OR click Add Permissions to assign permissions to the user If you opt for Add Permissions the invite will be automatically sent after saving those permissions The email will contain a URL the client s login information and a temporary password to access the application Select a business to your left to view your company snapshot and set alerts Intuit ProLine Business Analysis 23 Assigning User Roles and Permissions after Inviting a User Setting user roles and permissions are very important Roles and permissions determine the type of access a user has to ProLine Business Analysis The Administrator has sole rights to setting and editing BOTH his own roles and permissions as well as his client s roles and permissions If the Administrator does not set roles and permissions for his users then they will not be able to sync QB files or view reports Note
16. ckBooks company file associated with them they are simply present for sorting purposes Notice how Texas Stores a parent company has Austin Region a child company under it Neither have a QuickBooks file associated with them Instead the QuickBooks files are tied to the North Store and South Store both of which are child companies under Austin Region Home Q Scho zenno State Sia Rassen Add Business Name The tuoness cort ps typca profe Gata e tact eformaten Each business may hee only one Ouchflocks Ge rum d Yos can grovo tyenesses that represert n ependent ko Sven together to represent chects motele location Fgvifetet states Ign of other types of M dag to move busmetses wen o ancthes Group of business ri Rate bt mary bonnets ai Cetees Gung step you are irshod adding and mong nesses cich Nest to goto Step 2 Step 2 Users and Permissions Monitor Business to Business Relationships Intuit ProLine Business Analysis Administrators can re associate and modify Business to Business Relationships between parent and child businesses at any time To move a business out of or into a new parent business regional category 1 Navigate to the Home tab and click on Manage Add Businesses 2 All businesses in the Administrator s Network will appear 3 Left click hold drag the desired company to the new parent company The new grouping is automatically saved
17. d Contributor permissions for every business in their network If the Administrator does not wish to retain Contributor permissions for a specific business they may reassign that privilege to another user Intuit ProLine Business Analysis 15 3 Step 3 The Contributors are able to download and install the sync application and then sync their QuickBooks file A If your QuickBooks files ARE hosted contact your hosting provider to request the Qvinci Sync Application To provide download and installation instructions to your hosting company send them the Hosting Sync Document located here http web qvinci com Content Text hostedlinksync pdf 1 Afterthe hosting company turns on the Sync Application refer to the Link and Sync Guide to sync your files B If your QuickBooks files are NOT hosted refer to the Link and Sync Guide instructions to download and install the Sync Application yourself and then sync your files http web qvinci com Content Text LinkSyncGuide pdf Syncing QuickBooks files t ttort you hwve Jeda route Tungs to REMINDER To run the sa kfhooks Agmn perm sons to k be kefoed most be opened N vin Uter ger Reve Contour permiadenen Es dowd Vo ren Pa company De sicas fre to ur wars Thon enaties Vieser tha ability to emm ra ERNE Pl ace Qe get Intuit ProLine Business Analysis 16 Suspend or Unsuspend a Business If an Administrator would like to prevent a business from acces
18. data file Things to note prior to using the Sync App Scheduler 1 QuickBooks files may be in multi user mode during the incremental syncs that take place in the Sync App Scheduler 2 You may select the files that you wish to sync but the service administrator will define when and how often the files will sync For more information contact your hosting provider 3 All QuickBooks files MUST be closed for a scheduled sync to occur in a hosted environment If a QuickBooks file is open during a scheduled sync then it will be skipped over and another attempt will be made at the next scheduled time Setup a Scheduled Sync for Hosted QuickBooks Data Files 1 After a QuickBooks file is linked the Contributor will click the Schedule Sync button in the Sync Application The Sync App Scheduler will then open A Ifthere are no QuickBooks files checked from the previous screen the Scheduler will instruct the Contributor to return to the previous screen and check the businesses to include in the Sync Scheduler B If QuickBooks files are checked for the Scheduler then the Contributor will be instructed to click the Schedule Sync button to submit the files for incremental syncing 2 The Administrator of the Hosted Server environment is the person responsible for selecting the Day Time Frequency for the incremental syncs to take place Contact your server provider to determine the frequency in which the QuickBooks data will be sync d Intuit
19. e from the requested period of time to its previous year Intuit ProLine Business Analysis 48 Quick Ratio Acid Test An indicator of a company s short term liquidity The quick ratio measures a company s ability to meet its short term obligations with its most liquid assets The higher the quick ratio the better the position of the company Quick ratio is calculated as current assets minus inventories divided by current liabilities Return on Assets ROA An indicator of how profitable a company is relative to its total assets ROA gives an idea as to how efficient management is at using its assets to generate earnings Calculated by dividing a company s annual earnings by its total assets ROA is displayed as a percentage Sometimes this is referred to as return on investment Total Debt to Assets A metric used to measure a company s financial risk by determining how much of the company s assets have been financed by debt Total debt to assets is calculated by adding short term and long term debt and then dividing by the company s total assets Working Capital A measure of both a company s efficiency and its short term financial health The working capital ratio is calculated as current assets minus current liabilities Intuit ProLine Business Analysis 49 Franchise Analysis Benchmarking Reports Benchmarking can be used within ProLine Business Analysis to compare totals within your businesses 1 2 3 4 5 From t
20. ed by Edward Altman in the 1960s This model combines five different financial ratios to determine the likelihood of bankruptcy amongst companies Typically the lower the score the higher the odds of bankruptcy Companies with Z Scores above 3 are considered to be healthy and therefore unlikely to enter bankruptcy Cash Debt Coverage The cash debt coverage ratio shows the percent of debt that current cash flow can retire A cash debt coverage ratio of 1 1 100 or greater shows that the company can repay all debt within one year Current Liability A company s debts or obligations that are due within one year Current liabilities appear on the company s balance sheet and include short term debt accounts payable accrued liabilities and other debts Expense Year over Year YOY A calculation of the percentage change of expense from the requested period of time to its previous year Gross Profit Margin A financial metric used to assess a firm s financial health by revealing the proportion of money left over from revenues after accounting for the cost of goods sold Gross profit margin serves as the source for paying additional expenses and future savings Gross profit margin is calculated as revenue minus COGS divided by revenue Income Year over Year YOY A calculation of the percentage change of income from the requested period of time to its previous year Net Income Year over Year YOY A calculation of the percentage change of net incom
21. ell Oil 125 0 125 REN Union 76 350 0 350 P ae 201 Test Ceca US Bank 350 0 350 Sueco Venzon 125 0 125 Se Lonely Total 0 Tenco tange Sszre o oo en 00000 e co e e e e e e o oo 0000000 0o S Trash Comcery Two bomen Lown Core ZocTestBusinesst ZacTestiivsinens D m Profit and Loss Balance Sheet Cash Flow Note A P reports can be exported to Excel using the Export to Excel button Note Reports must be re generated for each viewing Intuit ProLine Business Analysis 52 Side by Side Business Frequency Reports While the ProLine Business Analysis application can aggregate multiple QuickBooks company files into a single report it also can display company data in a side by side comparison view This allows the viewer instant visibility of any all companies in comparison to others 1 To build a report using the side by side business comparison simply select Business in the frequency menu Example 1 Multi company Profit amp Loss report using Side by Side Business frequency and Last Fiscal Quarter date filter in grid and graph format Home Reporting Getting Started Profile Karnes Logout Reporting Dashboard ProfitAndLoss Businesses Business v Last Fiscal Quarter Grid and Graph e CL Account map BO A Lawn Core SE Denver Stoves C erem v Fish Store e Pegasus o sh v Setter Corp SC Texas stores D Two Brothers Lawn Care
22. er will see Cash A R A P Revenue and Net Income totals Note Calculations for the Financial Summary are as follows A Cash A R and A P Year to date YTD financial totals B Revenue and Income This month to date financial totals Under Company Details the viewer can see the last sync date as well as the closed fiscal date of the file Business Administration Networks Businesses Happy Sunshine Rainbows Fan Stove Seller Corp Pegasus dfjlajh z Kristin s Network Di Texas Stores Home Reporting Getting Started Profile Karnes Logout Company Details QuickBooks file exists Yes Last sync date 10 4 2010 QuickBooks file closed N A 2 Bobcat Ln San Marcos Texas Two Brothers Lawn Care Alerts No Alerts Set Financial Summary Cash 2 500 AR 7 125 AP 7 550 Revenue 700 Net Income 700 Edit Financial snapshot settings Viewing Multiple Financial Summaries at One Time Intuit ProLine Business Analysis 56 The Landscape View allows the Administrator and Viewer to view multiple companies financial summaries at one time 1 2 3 4 From the Home tab click on Landscape View On the following screen all businesses that the Admin or Viewer has viewing privileges for will be present The company can be expanded to see the financial summary by clicking on the Multiple companies can be viewed at one time using this method Note Calculations in the Financial Summary a
23. erver the Sync App should be downloaded to each location and the respective files should be sync d using the Sync App at their location 2 The QuickBooks file s must be in single user mode during the initial Link and Sync After the initial Link and Sync process is complete each QuickBooks file may be returned to multi user mode Future syncs will run in multi user mode 3 If your QuickBooks files are hosted the hosting company must open Port 808 in order for the Sync App to function 4 During the sync process a QuickBooks file can NOT be accessed Downloading and Installing the Sync Application For Non Hosted Files 1 The person responsible for installing the Sync App must have Windows Admin permissions 2 Login to the ProLine Business Analysis application and click Intuit ProLine Business Analysis 31 A Setup tab gt Getting Started gt Download Sync App OR B Or use this link https web qvinci com SyncClient QvinciSyncSetup zip 3 Save the zip file to the same location where the QuickBooks application is installed It should default to being saved in a file called QvnciSyncSetup 4 Navigate to the QvinciSyncSetup file and extract all files from the zip file 5 Once extracted run the QvinciSync installer to install the Sync Application Link and Sync QuickBooks Files Hosted and Non Hosted Files 1 The ProLine Business Analysis Network Administrator grants Contributor permissions to the appropriate
24. ext sync A Lawn Care Company Detada Cat nel Mertens QuctBooks Me eut No NA Date Founded 1062010 What is a Business Note Only the Administrator can edit a company s information Additionally only the Administrator of the Network where that company was created can edit a company s information For example if the Administrator of Network 1 is invited to view the Network of Administrator 2 then Administrator 1 is not able to edit any businesses which Administrator 2 created Intuit ProLine Business Analysis Delete a Business An Administrator can delete a business at any time by using the following steps 1 Navigate to the Home tab 2 Click Manage Add Businesses Note Only the Network Administrator has privileges to delete a business and only a business which they created for their own network 3 Click on the business from the list which appears 4 Select Delete to completely remove the business from the network Network View Please Select a Business Tew Emoy More 2 Pegasus hy Ooes Tes gent Menos Store E Neate y Pietas Teens Stores Di Denver Stores i aeee Lown Core Test Coen t Contact etormaten E one Quectlock yt Ve nyc d You tits ves al rece sent niepentert ux aon topaha ts npprm vant Charts mole Ux gon Maeechenes Males pns OF der fr en Key l Le Chae SOM and drag 16 mode Inh tes e sei in Diy Pem o actus gode re lueeess 10 Chee pmen Meal re green
25. file Usually a contributor will need to be granted viewing privileges as well Intuit ProLine Business Analysis 20 Sync Application Uploading Files for Clients NOTE If your QuickBooks files are hosted contact your hosting provider to request the Qvinci Sync Application To provide download and installation instructions to your hosting company send them the Hosting Sync Document located here http web qvinci com Content Text hostedlinksync pdf After the Sync Application is installed on your server refer to the Link amp Sync QuickBooks Files section below to sync your file Users who have Contributor permissions are allowed to sync the company QuickBooks file to ProLine Business Analysis This enables Viewers the ability to view the reports that are generated By default the Network Administrator is assigned the Contributor permissions for every business in their Network The Administrator may reassign the Contributor permission to another user if desired However there may only be one Contributor for each business The following steps detail the sync process Things to know prior to syncing files 1 The Sync App MUST be downloaded installed to the same location as the QuickBooks 9Application Therefore if the QuickBooks Application is on a server then the Sync App must be installed on the server as well A If QuickBooks files are located in multiple locations ie some on desktop and others hosted on a s
26. he Reporting tab select all businesses you wish to view and then select the Franchise Analysis report option Select your date filter but note that the period filter monthly quarterly business none does not apply It always list by Business All selected businesses will appear in the report You can opt to click the Switch to Ranking button to see the order in which companies rank in each category Note that by clicking on each column header you can sort in ascending descending order The Franchise Analysis Benchmarking report can be exported Excel using the Export to Excel button Ths Calender VTO Gadah Account map Retest Intuit ProLine Business Analysis 50 Accounts Receivable Reports Accounts Receivable tables are available in the ProLine Business Analysis application however the date filters do not apply and thus do not need to be set 1 Navigate to the Reporting tab select the desired business es from the Businesses column and select A R Aging 2 Select the Export to Excel button if desired Home Reporting Getting Started Profile Malone Logout Monthly ThisCalendarYTD e GndandGraph Account map Refresh 39 0 0 39 Alex Adams 0 Empty Store 2 Empty Store 3 Fish Store Alex Adams Job 1 taai Bob Newhart IncomeStatementCompary Henry Mancini Ej incomes Company 2 Jim Smith Joe Hill John Doe Mike Hammer 2 398 2 398 2 398 7 194 3 767
27. he Single QuickBooks File Business Comprised of just one business C The Corporate Business with Multi Location Franchises Comprised of a parent company with multiple child locations The CPA may host the QuickBooks files for the parent company and stores or the parent company may house all the QuickBooks files or each store may house their own QuickBooks files Intuit ProLine Business Analysis 12 Differences Between User Permission Levels 8 fw 8 CreatesaNetwork Ir CreatesaBusiness lz Sets User ec LJ o File VewsRpots Administrator The person responsible for creating the network inviting users creating businesses and monitoring roles and permissions An Administrator by default is always granted Viewer and Contributor permissions If the Administrator does not wish to be the Contributor they may reassign the privilege to another user NOTE There may only be one Contributor for each business Viewer A user who ONLY has privileges to view the reports for a QuickBooks company file They are not responsible for syncing a QuickBooks file A viewer can view other QuickBooks company files if the Administrator invites them to other businesses and gives them viewing privileges for that business Example A business owner of multiple businesses looking at each location s QuickBooks files Contributor A user who maintains the QuickBooks company file whether it is for his own compa
28. ility to consolidate financial and operational data provides users with instant understanding and insight of their company s information Features e Connects to remote QuickBooks files e Provides financial dashboards over the internet e Offers incremental daily updating syncing of QuickBooks data e Low cost monthly subscription with no long term contract free support and updates e Aggregates multiple QuickBooks company files regardless of location in a matter of seconds System Requirements Compatible Web Browsers Internet Explorer Version 7 and up privacy settings must be set to Medium or lower Firefox Version 3 and up Google Chrome Latest version Safari Latest version System Requirements for the Sync Application Windows XP Vista 7 or Server 2008 At least 2 0GHz Pentium 4 processor 2 4GHz recommended At least 512MB RAM for a single user 1GB recommended 1 5 GB of disk space Display optimized for 1024 x 768 screen resolution or higher Microsoft Net 4 0 must be installed Port 808 must be open Internet connection Compatible QuickBooks Versions QuickBooks Pro Premier 2008 and up QuickBooks Enterprise 2008 and up Not compatible with Point of Sale or QuickBooks Online at this time Intuit ProLine Business Analysis 5 Intuit ProLine Business Analysis Getting Started Flow Chart The flowchart below will simply and effectively explain the startup process Getting S
29. information and the URL to access ProLine Business Analysis To log in to the application initially clients users will simply follow the steps outlined in the email invitation Intuit ProLine Business Analysis 26 Existing User Login Procedures Once a user has been invited to the ProLine Business Analysis application they may login at any time by visiting their Intuit Workplace account at http workplace intuit com and clicking the Sign In button On the login page the user may log in by entering the email and password associated with their account i Intuit Account Create one now Enter your email address Do you have password 9 yes O No I m a new customer Forgotten User ID or Password If the login ID or password is forgotten simply click on the corresponding link on the login page to have it sent by email Intuit ProLine Business Analysis 27 The User s Profile A user can view and update their profile information by visiting the Settings tab at the top of the application Intuit Proline Business Analysis An Intuit Prone Solution Personal Information Intuit Account Edit Change Password Change Security Question Kasin Karnes Kristin Karnes Edit Preferences Intuit ProLine Business Analysis 28 Updating Your Email and Password The user can update their email password or security questions by selecting visiting the Settings tab at the top of the application a
30. kBooks Data Files ccccccsssccessssceceesssceeecseeeececseeeeescsesessceseeesseseesecseseeseeseseeaeeeeeeaess 37 Sync Scheduler Incremental Syncing of Hosted QuickBooks Data Files ccccessssccececsssesseaeceeeeeceeseeeaeeeceessessesaeaeeeeecesseseaaeaeeeescessesaaaeaeeeesenseea 38 ET ele t LL E 39 Exporting to EXcel dinner cte aem id ecc ra E de re rre ere re exu vests eo avid eux era Eder eeu og amr eva s T REC dax ener eo rm db va nh e EE RS 40 Creating Reports Using Custom Date Filter 41 Protitand LOSS Reports iret te Ete te te E tete te eve te tr NN 42 Intuit ProLine Business Analysis Balance Sheet Reports 5 o Heer tee tede a Teste uates vidit toca telae tous VE Tenor n Teese ve teas EE Eae EREE ee EEE E AE TAE EAEE 43 Statements of Cash Fl nt M EE 44 Ratio REDONUS NOE ETT 45 Ratio led 47 Franchise Analysis Benchmarking Reports erento eoru eso nae ose e aere eo avr e us ure oue RTENE AEREN ase ee SENE ERES 49 Accounts Receivable Reports rro c rt d Ek e ra n E a xt REENEN eta epe Eh edere ga 50 Leet EE UE lee EE 51 Side by Side Business Frequency Reports ccccccssssssececececseseeeaeeeeeceeeeseseeaeeeeeeeseeseaaeaeeeeeceseesee
31. n Personal Information Intuit Account Edit Change Password Change Security Question Kasin Kames Kristin Karnes Edit Preferences Intuit ProLine Business Analysis 9 What is a Network A network is the entire collection of your clients businesses your client users and the relationships that may exist between them The network facilitates managing the parent child relationships and user roles and permissions A network is created by the Administrator A network contains the Administrative user s profile and staff information A network contains the Administrator s and client s businesses as well as child businesses if any A network defines user roles and privileges Sample Network Layout Intuit ProLine Business Analysis 10 YOUR NETWORK TOPOLOGY Admin Creates administers users and roles Contributor Responsibie EH m mmm ES for setting up QB flle sync RS Iesele IMPORTANT DEFINITIONS Parent Business A business that is the main entity Parents have a QuickBooks company file but may also have child locations undemeath Child Business A business that belongs to a parent entity Children have a is different than the parent s Intuit ProLine Business Analysis 11 Types of Businesses within a Network There can be many types of businesses within a network A The Administrator s Business The Administrator can add their business to the network if desired B T
32. ncy then the ratios will be displayed by the business Example 1 Ratios displayed in a Monthly frequency using This Calendar YTD as the date filter Reporting Dashboard Ratios d d d d d v d d d 7 d 7 d 7 d d E DeiacceS eetD sem Baias co S Her aem 2 Dig Bas Wor Gm Beg Docs Busse Bah Pae Mact Ench Save 2 Emery Save Pian Store hacme Bienen Conger roorraStatermentiomoary 2 Lae re Tiger Conte Mera tare Pagesa CB 201 Ten Company Q WatoTestCompany asto est2o7co 2 Profit and Loss Balance Sheet Cash Flow Ratios Note Each column can be sorted in Ascending or Descending order simply by clicking the column header Monbly ThisCalendar YTD AIR Turnover Days Coming Soon Altman s 7 Score Coming Soon Cash Debt Coverage Cash Turnover Coming Soon Current Liability Current Ratio Expense YOY Expenses YTO vs PYTD Coming Soon Fixed Asset Turnover Coming Soon Gross Profit Margin Income YOY Income YTD vs PYTD Coming Soon Net Income YOY Net Income YTD vs PYTD Coming Soon Operating Income Margin Coming Soon Quick Ratio Acid Test Return on Assets Total Debt to Assets Working Capital Grid and Graph WA WA LH 41 108 5 58 70 3 500 Example 2 Ratios displayed by the Business frequency using Last 24 Months as a date filter Reporting Dashboard Ratios Busine EHO A Lawn Core SC Denver Stores C mag
33. nd clicking on the corresponding link s that appear in the new screen Intuit Proline Business Analysis T An Intuit Proline Solution Personal Intormaton Intuit Account Edit Change Password Change Security Question Kasin Karnes Edit Preferences Intuit ProLine Business Analysis 29 Differences Between User Permission Levels 8 fw 8 CreatesaNetwork y CreatesaBusiness lz Sets User ec LJ o File C Aan ee NN Administrator The person responsible for creating the network inviting users creating businesses and monitoring roles and permissions An Administrator by default is always granted Viewer and Contributor permissions If the Administrator does not wish to be the Contributor they may reassign the privilege to another user NOTE There may only be one Contributor for each business Viewer A user who ONLY has privileges to view the reports for a QuickBooks company file They are not responsible for syncing a QuickBooks file A viewer can view other QuickBooks company files if the Administrator invites them to other businesses and gives them viewing privileges for that business Example A business owner of multiple businesses looking at each location s QuickBooks files Contributor A user who maintains the QuickBooks company file whether it is for his own company client s company or a child company franchise A user must have contributing privileges in order to sync the QuickBooks
34. ny client s company or a child company franchise A user must have contributing privileges in order to sync the QuickBooks file Usually a contributor will need to be granted viewing privileges as well Intuit ProLine Business Analysis 13 Setting up a Business 1 Step 1 An Administrator creates a business A Navigate to the Home tab B Click Manage Add Business in the Actions column on the left of the screen C Follow the prompts in Step 1 to add the business es name Once businesses are added click next to proceed to Step 2 Piease Select a Business Select a business to your left to view your company snapshot end set alerts Business Management Add Burns Name 2 Step 2 The Administrator is directed to click on a business in order to add users and assign permissions A Click on a business name in Step 2 B All users associated with that business will appear in the next screen You may either edit an existing user s permissions or you may Add a New User and click Invite Intuit ProLine Business Analysis 14 C When a new user is added an email invitation is automatically sent to them with login information D After adding the user the Administrator may assign their privileges SU x2 Business Management Permssces fy Texas Stores Ta beet Lire he View Ponts Ime zem nase Vese Note The Administrator of the Network automatically defaults to having BOTH Viewer an
35. o be recreated again For example if a Target is set up ona monthly frequency it will begin anew each month Therefore unless an early warning indicator needs to be edited once it is created it will never expire 1 From the Home tab select the desired business from the Businesses column 2 Onthe Company Details screen click Alerts 3 A popup screen will appear allowing you to select the desired report and corresponding line items for which to base your alert off of 4 Select the desired alert type either Target or Threshold A ATarget is an amount you want to reach and exceed B AThreshold is an amount you do not want to exceed 5 Based upon your selection of Target or Threshold enter an alert value in the field provided 6 Select the frequency to apply the Target or Threshold to Ex a monthly frequency will begin anew each month and therefore the Target or Threshold will begin again on a monthly basis 7 Savethe early warning indicator Intuit ProLine Business Analysis Example Setting up Early Warning Indicators Business Administration Home Reporting Getting Started Profile Karnes Logout Networks Businesses DEI Happy Sunshine Rainbows Fish Store Two Brothers Lawn Care Company Details Alerts Financial Summary Seller Corp QuickBooks file exists Yes No Alerts Set Cash 242 621 Last sync date 9 17 2010 Add Alerts AR 4 396 214 Reg QuickBo
36. oks file closed N A AP 176 872 EI Kristin s Netect 111 Fake Street Revenue 0 G Texas Stoves San Marcos Texas Netihome Bi 78666 kel none gum I m Denver Stores Edit Financial snapshot settings United States wh D Ann Lown Care Early Warning Indicators Balance Sheet 4 Profit and Loss ASSETS f Balance Sheet Current Assets Cash Flow Checking Savings Ratios BO Chase Checking Benchmarking Bi Chase Busine AR Aging B4 Petty Cash AP Aging B7 Wachovia Checking Total Checking S Accounts Recervable AlertType Frequency O Threshold Something you don t want to exceed Based on Month Target Something you want to reach and exceed AlertValue 100000 58 Intuit ProLine Business Analysis Financial Summary Notifications Administrators and Viewers have the ability to set up Financial Summary Notifications to receive emails containing the financial snapshot of their company 1 2 3 4 From the Profile tab click Manage Notifications The company list will appear and the Admin Viewer may check the box next to a company s name After a box is checked select Daily or Weekly from the drop down menu to determine the frequency of which to receive the email notifications Click Save Upon returning to the Manage Notifications link the Admin Viewer can add edit or remove companies from the notification list
37. ores When a viewer visits the Reporting tab in the ProLine Business Analysis application they will see all businesses for which they have viewing privileges to on the left side of the screen The Viewer can then select the desired companies for which they wish to view reports for Example The below viewer has privileges to view all businesses under Texas Stores By selecting the Texas Stores category it automatically selects all child companies for which they have viewing privileges for under that category Now the viewer may run a report for Austin Region and Dallas Stores If the user did not have viewing privileges for Austin Region then when selecting Texas Stores they would only be able to view reports for Dallas Stores Reporting Dashboard Home Reporting Getting Started Profile Karnes Logout Businesses Monthly This Calendar YTD Grid and Graph O Account map My Dashboard C asja C Fish Stoe C Pegasus 2 w Texas Stores SV Austin Region v Osiias Stores Two Brothers Lawn Care Report Types Profit and Loss Balance Sheet Cash Flow Ratios Benchmarking Viewing the Financial Summary of a Business Intuit ProLine Business Analysis 55 Once a business has been created the Administrator and Viewers are able to view a financial summary of the business 1 2 3 4 From the Home tab click on the desired business to view Under Financial Summary the Admin View
38. ow Reports This is a sample Cash Flow grid using a Quarterly frequency and Custom date ranges Reporting Dashboard CashFlow DI two othen Lawn Ces iepod Type Profit and Loss Balance Sheet Ravos Benchmarking A R Aging AJP Aging Adjustments to reconcile Net income to net cash provided by operations Accounts Payable Accounts Recenable Amex Employee Advances Adv to AR Adv to Jasmine Total Employee Advances inventory Asset UP Chase Credit Line Sales Tax Payable Secunty Deposit Total Adjustments to reconcile Net Income to net cash provided by operabons 837 075 1 059 135 279 12 577 1 675 15 000 16 675 305 143 230 15 0 283 347 Note Reports must be re generated for each viewing 58 386 46 342 891 043 563 531 Note A Cash Flow report is not available in graph format only grid 24 405 10 703 70 996 472459 472 349 472 359 20 246 109 068 0 0 809 897 235875 472459 472349 63 848 137511 0 0 760 720 472 459 472 349 472 359 Intuit ProLine Business Analysis 45 Ratio Reports Multiple ratios are offered in the ProLine Business Analysis application Note that ratios are only displayed in grid format and automatically default to grid format 1 From the Reporting tab select businesses and click Ratios for the report type 2 Select a date filter and frequency If Business is selected as the freque
39. r to Custom select the desired month and year date range from the drop down menus and click Refresh Note Custom date filters are only available in a month and year filter Additionally the application only pulls up to 3 years historical data Reporting Dashboard ProfitAndLoss Businesses EHE A Lawn Care i Fj Lawn Care Store 1 E Fish Store v Pegasus al Seller Corp El g Texas Stores go Austin Region d Fl Dallas Stores is F Two Brothers Lawn Care Report Types Profit and Loss Balance Sheet Cash Flow Ratios Benchmarking A R Aging Home Reporting Getting Started Profile Karnes Logout Monthly Custom Grid and Graph Account map Profit and Loss Graph Bi Total Ordinary Income I Total Cost of Goods Sold E Gross Profit Bl Total Ordinary Expense Bl Net Income Jan 10 Feb 10 Mar 10 Apr 10 May 10 Jun 10 Jul 10 Aug 10 Sep 10 Ordinary Income Activity 16 000 16 000 16 000 Guides 910 910 910 Hotel 31 819 31 819 31 819 Other 12 420 12 420 12 420 Restaurants 49 594 49 594 49 594 Transportation 9 255 9 255 9 255 Income Intuit ProLine Business Analysis 42 Profit and Loss Reports This is a sample Profit and Loss report grid and graph using a Monthly frequency and This Calendar YTD as the date filter Reporting Dashboard ProfitAndLoss EE Aros Lown Core E Lown Care Stove t IS C
40. re as follows A Cash A R and A P Year to date YTD financial totals B Revenue and Income This month to date financial totals Home Reporting Profile Karnes Logout TT UI Fish Store Company Details QuickBooks file exists Yes Last sync date 10 11 2010 QuickBooks file closed N A Two Brothers Lawn Care Seller Corp Pegasus open Texas Stores Denver Stores 10 11 2010 Alerts Financial Summary No Alerts Set Cash 15 367 AR 25 110 AIP 11 295 Revenue 970 Net Income 589 Edit Financial snapshot settings 10 4 2010 8 16 2010 9 17 2010 NIA NIA N A Intuit ProLine Business Analysis 57 Setting Alerts and Notifications Administrators and Viewers have the ability to set up early warning indicator alerts and financial summary notifications Notifications are then emailed to the Administrator or Viewer at the frequency they determine while alerts appear in the business profile Note Despite both the Admin and Viewer having access to the same company alerts and notifications are tied to each individual user login Therefore only the person who sets up the alert will be able to view it and only the person who sets up the notification will receive the email Early Warning Indicator Alerts The Network Administrator and Viewer may both set up their own early warning indicator alerts Note Once an early warning indicator Target or Threshold is set it does not need t
41. rivate data Intuit ProLine Business Analysis QuickBooks Application Certificate An application is requesting access to the following QuickBooks company file QVINCI TESTCO Access may include reading and modifying QuickBooks data as well as enhancing the QuickBooks user interface The Application Calls Itself Qvinci Sync Certificate Information Description Developer QuickDash LLC Developer identity has been verified by Thawte Code Signing CA G2 QuickBooks Solutions Marketplace Search for information about this application at the QuickBooks Solutions Marketplace Do you want to allow this application to read and modify this company file C Yes always allow access even if QuickBooks is not running 9 After completing the Application Certificate the Contributor navigates back to the Sync Application 10 If the Contributor wishes to sync additional QuickBooks files now first close QuickBooks entirely then repeat steps 6 9 for each remaining QuickBooks file Otherwise skip to step 11 35 Intuit ProLine Business Analysis 36 11 Check the box in the Sync column next to all QuickBooks files they wish to sync Qvind Sync 2 0 3951 Associate a fle to a company by opening QuickBooks and clicking l nk To Sync files check Sync next to every file to be sent to the server and then click Sync a the bottom Business ee ele Kei Sre Se Popsi i Progress Current S
42. s Select a business to your left to view your company snapshot and set alerts Business Permissions ME e All corm ina oe NE e CI ET 2 Actwe Bethany Nagel Acte Dustin Kames 4 Acte knstin kames Add New User NOTE The deleted User s login information is still stored in the application Therefore if the user is a part of another Administrator s Network they will still have access to the application through that Network However if the deleted User is not a part of other Networks but wishes to log in to the application they will be directed to the registration page where they must enter contact and billing information in order to continue Intuit ProLine Business Analysis 25 Startup Information for Clients and Users Clients and users are granted access to an Administrators Network through an email invitation These invitations are sent to the intended recipient and contain a URL and login information to the ProLine Business Analysis application Once an invitation email is received all the user must do is select the URL within their email invitation and log in to the application They may also visit the Intuit Workplace at http workplace intuit com to log in and access the application Receiving an Invitation from an Administrator The email which the Network Administrator sends will contain login information so that the client user can access the application Inside the email the client user will find login
43. siness Analysis 33 Authorization lt lt Previous Page Refresh Sign in with your Intuit ID and password to authorize this application Intuit Workplace App Center intuit Intuit Account Intuit ProLine Business Analysis will access your Intuit Workplace company data By approving this request Intuit ProLine Business Analysis will access your Intuit Workplace company data You can adjust the connection anytime in the Manage Access page under My Account 2010 Intuit Inc All rights reserved 5 After authorization takes place the Contributor will be connected to the Sync Application Click Return to ProLine Business Analysis to open the Sync Application and begin syncing files Authorization lt lt Previous Page Refresh Sign in with your Intuit ID and password to authorize this application Intuit Workplace App Center intuit Account You are securely connected to Intuit ProLine Business Analysis wh Great You are securely connected to Intuit ProLine Business Analysis If you ever want to revoke access go to the Manage Access page under My Account 4 Return to Intuit ProLine Business Analysis If Intuit ProLine Business Analysis is requesting you to copy paste a code please use 1eq5gyp 2010 Intuit Inc All rights reserved Intuit ProLine Business Analysis 34 6 Once inside the Sync Application the Contributor opens the QuickBooks file they wish to sync ensuring that the
44. sing the ProLine Business Analysis reporting tools they can suspend the business at any time This action will freeze the business and the access for its Contributors and Viewers but not remove it from the Administrator s network 1 Navigate to the Home tab and click on the desired business in the Businesses column 2 Click Edit in the company s screen 3 A popup will appear and the Administrator can check the box next to Suspend Un suspend and save Compan Detais QuckBooks Me ewsts No NA Date Founded 1062010 hocal prote data Wee cor eT mary Neve Oy ore HAHI be yync d You can group bursa fart ecrire oeependert ex atones togeter lo rece heres muto Ic BDO Sechs Mates recor thet type of Categorzabon Note Only the Administrator can suspend or unsuspend a business Intuit ProLine Business Analysis 17 Edit an Existing Business A Network Administrator can edit a business information at any time 1 Navigate to the Home tab and click on the desired business in the Businesses column 2 Click Edit in the company s screen 3 A popup will appear allowing the Administrator to edit and save the new information A If the Sync from QBW file box is checked then the business information will be populated when the business syncs to the QuickBooks file Additionally if the QuickBooks file information is updated the company information will also update at the n
45. ss Category select Jr i Select Income COGS Expense Other Income Other Expense Bank Accounts Receivable Other Current Asset Fixed Asset Other Asset Credit Card Accounts Payable eSheetBusin Other Current Liability atementCo Long Term Liability Equity Non Posting Mike the Tiger Comp ZacTes ZacTestBusiness2 fjasdkljl Qunc Intuit ProLine Business Analysis 61 4 Unmapped accounts will be found on the left side of the screen with mapping categories on the right side of the screen 5 Simply select an account from the unmapped category on the left side of the screen 6 Click hold drag drop into the desired category on the right side of the screen Example Bonds Payable has been dragged to the Bonds Payable category header and Notes Payable has been dragged to the Notes Payable category header Home Reporting Getting Started Profe Malone Logout List of Businesses Business Category Long Term Liab ty lt G Mapped Gre Special Accounts locked Umapped Accounts for LongTenmLiability Mapped Accounts for LongTermiiability Bonds Payable Notes Payable Notes Payatie Securty Deposits Reis Mortgage Payable Long term capital leases Bonds payable Account Mapping Getting Started Luc Malone Logout Business Category Long Temtiabaey E Mapped Grey Special Accounts locked Umapped Accounts for LongTermLiabelty Ai Mapped Accounts for Lorent att Securt
46. staurants 49 594 49 594 49 594 Transportation 9255 9255 9255 Income 101 Invoice GRP 35 108 25 198 26 954 Total Income 35 198 25 198 26 954 Seter Corp 9 Texas Stores Report Types installation Profit and Loss Maintenance Services 4 500 0 0 Merchandise Sales 775 4540 Sales Discounts 20 85 Service Sales 250 800 Ordinary ince Activity 16000 4 16000 4 Guides 510 510 Hotel 31819 44 31819 44 Other 12420 2 12420 2 Restaurants 49594 48 49594 48 Transportati 9255 48 9255 48 income 101 Invoice G 35197 5 25197 5 Materials Costs Total income 35197 5 25197 5 Total Cost of Installation 1500 Goods Sold Maintenance 4500 Green Pente ses a 410 65 4297 ect Merchandise Sales Discour 20 Service Sales Total Ordinary income Cost of Goods Sold Cost of Goods Sold 162 203 150 453 Cana Vie 9 MP ray o The exported Excel file will contain the exact information found in the ProLine Business Analysis grid as well as listing all the company names which have contributed data to compile that spreadsheet Intuit ProLine Business Analysis 41 Creating Reports Using Custom Date Filters Viewers can create reports with custom date ranges by using the following steps 1 Viewer clicks on the Reporting tab at the top checks the boxes for the businesses they wish to view reports for and then selects the type of report they wish to view 2 Once the report appears the Viewer can then change the date filte
47. tarted From Creating Your Account to Viewing Reports Start by setting up amp amp j Contributors Sync QB Files 6 Intuit ProLine Business Analysis Startup Information for Network Administrators Intuit Workplace Account 1 Visit Intuit Workplace at http workplace intuit com AppCenter 2 Click the Sign In button to either sign in or create an Intuit Workplace account Note If you have forgotten your user ID or password select the appropriate link at the bottom of the sign in screen i Intuit Account need a t Create one now Enter your email address Do you have password ves O No I m a new customer 3 Once logged in to your account find the Intuit ProLine Business Analysis App 4 Select the desired plan to purchase 5 Once purchased access the ProLine Business Analysis App by clicking on the application from the My Applications window of your Intuit Workplace 6 Accept the Security Certificate during the initial login 7 Create a Network Name during the initial login 8 You have now logged in to the ProLine Business Analysis App and created an Administrator s Network Intuit ProLine Business Analysis 8 Updating Profile Information A ProLine Business Analysis user may change their profile information by visiting the Intuit Settings tab Intuit Proline Business Analysis An Intuit Prone Solutio
48. tatus EE em bwoke CkkWktsaQudBoks e Co OTOL O O O O Leen Chick k to set QuickBookt file EaxRegon CkkirkistQudiokem Lk E EJ Osaa Chick ink to set QuickBooks file East Stcee 201 QVINCI TESTCO Q8wW East Store 202 Chick link to set QuickBooks fie Noth 101 QVINCI TESTCD QB w Noth 1014 Click inik to set QuickBooks file Noth 101 8 Chick inik to set QuickBooks fie North 102 Click link to set QuickBooks fle Nath Regon Chek link to set QuickBooks file Ense Cerkwi uk C C ve Summermoon Click ink to set QuickBooks file 12 Click the Sync button to begin the sync process for all linked QuickBooks files 13 The sync process has begun Depending upon the size of the QuickBooks files this may take twenty minutes to one hour to complete Reminder A QuickBooks file can NOT be accessed during the sync process Intuit ProLine Business Analysis 37 Sync Scheduler Incremental Syncing of Non Hosted QuickBooks Data Files Once a Contributor links the QuickBooks file s in the Sync Application they are able to schedule future incremental syncs so that the data in ProLine Business Analysis is always current with the QuickBooks data file Things to note prior to using the Sync App Scheduler 1 QuickBooks files may be in multi user mode during the incremental syncs that take place in the Sync App Scheduler 2 All QuickBooks data files must be scheduled to sync
49. user who will be syncing the QuickBooks file This person must have QuickBooks Admin permissions The Administrator may also grant Contributor permissions to them self if they will be the person responsible for syncing the QuickBooks file There may only be one Contributor for each business See the User Manual section on Assigning User Roles 2 Once the Sync Application is installed the Contributor navigates to the Qvinci web Sync icon and opens the sync application Check the box for remember choice and select Intuit Marketplace S Qvind Sync 2 0 3951 Pick your authentication method Remember choice Intuit ProLine Business Analysis 3 On the following screen the Contributor may log into the sync application by entering the username and password for their Intuit Workplace account Authorization password to authorize this application Intuit Workplace App Center tuit Account Sign In to Your Intuit Account Connect Intuit ProLine Business Analysis to your Intuit Workplace company data Sign in to get started Your Intuit A 2 immi Intuit ProLine Workplace Business Analysis Company Data Learn how Intuit protects your data intuit Intuit Account User ID Forgot your User ID Password Forgot your password 4 Once logged in the Contributor will be asked to authorize their Intuit Workplace account data 32 Intuit ProLine Bu
50. y Deposts Refundatte Votes Payable Mortgage Payable term capital leases 7 Once categories are mapped Administrators and Viewers may opt to turn on account mapping when viewing reports Intuit ProLine Business Analysis Using Account Mapping when Viewing Reports Once the Administrator categorizes unmapped accounts both Administrator and Viewers may opt to turn on account mapping when viewing reports A Simply follow the steps for viewing reports check the box labeled Account Map to turn on the mapping functionality Refresh B To view reports without account mapping simply uncheck the box and refresh the report Example The first screenshot below details viewing a report without account mapping turned on while the second displays account mapping enabled This Administrator chose to setup account mapping so that Computer amp Internet Expenses and Office Supplies would be mapped to Misc Expenses when account mapping was enabled Businesses None ThisCalendarYTD GrdOnly FlAccount map Exportto Excel Installation Senices 2200 2200 Maintenance Seraces 4 500 4 500 Cost of Goods Sold Materials Costs 400 400 Total Cost of Goods Sold A 400 6 30 6 300 Report Types Cost of Goods Sold Matenals 400 Expense 62
51. y have QuickBooks Admin permissions for the initial link and sync process and that the file is in single user mode 7 The Contributor clicks the Link button next to the business they would like to link the open QuickBooks file for La Qvind Sync 2 0 3951 Associate a file to a company by opening QuckBooks and clicking Link To Sync files check Sync next to every file to be sent to the server and then click Sync at the bottom 3 i i Business QuickBooks Compary Fie JUNG TESTO RN Chick k to set QuickBooks file f E DE nins East Store 202 Click ink to set QuickBooks file Noth 101 QVINCITESTCO GBW Noth 101 8 Ckk ink to set QuickBooks fie Noth 101 8 Cick ink to set QuickBooks Re North 102 Click ink to set QuickBooks file North Regon Check k to set QuickBooks file Summemoon Click irik to set QuickBooks file kb LILILILILIL FFE iii g IO i yoo Ooo f f f I ooo elle ls i i E 3122221227 8 The Contributor will see a QuickBooks Application Certificate appear in the open QuickBooks file The Contributor must check the following TWO boxes to proceed see below Note The Contributor must check these boxes to allow access to the Admin table of users The Sync application does NOT export any social security numbers credit card information or other p
Download Pdf Manuals
Related Search