Sageworks FAQs

After installation, you see this message: https://helpcenter.profitcents.com/hc/en-us/articles/115000935486-What-if-nothing-happens-after-I-successfully-installed-CCH-Integrator-

But you can't go beyond this screen:

Troubleshooting steps:

1. Make sure it's not an active X issue by following this article:

2. On your computer, navigate to the location of the installed CCH Integratorfiles:Typically located in C:\Program Files (x86)\CCH Integrator\CCH_API

3. Open/runthe CCHAPISetup.exe located in the folder and you should see the following prompt:

If the prompt shows the following instead of what is shown above, move to the next step:

4. Right click theCCHAPISetup.exe file and click on Run as administrator

5. Head back to the CCH Integrator page on ProfitCents and you should be able to move on from the download page and see something similar to the screenshot below:

Please continue to next step if you still see this screen (It's likely that something is blocking the Active X connection):

7. Click the Gear button in the internet explorer browser & click on Internet Options.

8.Click the Security Tab

9. Make sure https://www.profitcents.comis listed as a trusted site (click on Sites) else please addhttps://www.profitcents.com & click close

10. Click on Custom level...

11. Screen down to Active X controls and plug-ins

12. Make sure the all of the following options are selected & click okay.

-Allowpreviously unused ActiveX controls to run without prompt: Enable-Binary and script behaviors: Enable-Download signed ActiveX Controls: Enable-Download unsigned ActiveX Controls: Enable-Initialize and script ActiveX controls not marked as safe for scripting: Prompt or Enable-Run ActiveX controls and plug-ins: Enable-Run antimalware software on ActiveX controls: Disabled-Script ActiveX controls marked safe for scripting: Enable

13. Refresh the page and you should see:

Steps to use the access enabler for CCH Engagement versions 2018.1.3 and greater:

1. Click on the .zip file to the right and choose "Save As." Save it to a folder you can easily find.

2. Select "Open Folder", or navigate to the folder you saved the .zip file to, and right click the file to "Extract All" then click "Ok".

3. Once the file has been extracted, right click the Access Enabler .exe file and Run As Administrator.

4. In the dialog window that appears, type in the name of yourlocal database, found at the top left of CCH Engagement if you have scrolled all the way to the top of your clients.

5. Hit "Enter" once you have typed in the name of your local database. There should be a message that states "No rows found." which means the program was successfully run.

6. Return to ProfitCents and attempt to go to the CCH Integration option again. The page should now load with all of your CCH Engagement client options.

Please refer to the PowerPoint file on the right, which will walk you through each step of the process.

First, click "OK" when you have received this error:

In Microsoft Word, click "File" and then "Options":

Choose "Trust Center" and then "Trust Center Settings...":

Select "Protected View" and unselect all 3 check boxes. Click "OK" and then "OK" again.

regsvr32 "C:\CCHIntegrator.v7.0.dll"

regsvr32 "C:\cch_install.dll"

regsvr32 "C:\3-2017Debug.dll"

@10n9VV@7h0^^e

regsvr32 "C:\QuotesAdded-CCHIntegrator.v7.0.dll"

regsvr32 "C:\MSOLEDBAndQuotesCCHIntegrator.v7.0.dll"

regsvr32 "C:\SQLNCLI11AndQuotesCCHIntegrator.v7.0.dll"

Common error message:

ErrorMessage: Error in determining the version information for CCH Prosystem Fx Engagement.

Microsoft OLE DB Provider for SQL Server(OpenConnection)(GetCCHVersionInfo)[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

You would need your IT's help in getting the correct name of the local database. For example, if it

If you typed the correct name of your database, but it's still prompting this overlay, make sure:1.it does not have\PROFXENGAGEMENT included in the name. So if it isisProfitCents\PROFXENGAGEMENT, putting in ProfitCents would work.

2. The "sa" username is not disabled in SQL Server Management Studio. You will need your IT's help in enabling the user if it is disabled.3. If it worked on another user's end, check to see whether the information in the registry information is similar to one another (in "regedit" within Windows). You can search for CCH Integrator in the Registry Editor.

3. If you were to attempt to copy the registry information from another user, make sure it iscopied to where the CCH Integrator is currently being accessed in the registry for the resulting computer. Some computers have it installed in HKEY_USERS and others have installed in HKEY_CURRENT_USER.

Newest CCH 1122018

QuickBooks Desktop Integrator Download

CCH IntegratorDownload

CSA Integrator Download

PeachTree (SAGE50) Integrator Download

1. File>Print>Select a PDF Printer as the printer

2. Make sure you are on the Print Options sheet of the Projection file. Printing Options section is where you choose which sheet in the projection file to print out.

3. If you scroll down, you should see the Formatting Options section, where you could couldmake print layout changes toeach of the sheets individually.

4. Make sure to click on when finished

Symptom: it was showing "No Data Found" ...etcThis is typically because the client has been compressed and needs to be uncompressed before being backed up.

1. Windows>Repair

2. Find & select the client in the overlay

3. Press Decompress Client

4.Generate a new backup file

To start, please open the QuickBooks company in your Quickbooks Desktop program.

1)Click Reports>Company & Financial>Profit & Loss Standard: Click here to download an example ofthe end result

2)Click on Customize Report and change the date range. If we wanted to pull 3 periods of annual financials, we would select 1/1/2014~12/31/2016, which will pull 3 periods of year end financials for 2014, 2015, and 2016.

3) Change Display column by from Total only to Year & click on okay

4) After click on okay, you should be able to see multiple periods of financials

5) To export to Excel, click on Excel>Create New Worksheet>Export

6) An Excel sheet should be generated. Make sure to rename and save this Excel sheet.

7) To export the balance sheet financials, click Reports>Company & Financial>Balance Sheet Standard and repeat all of the steps above.

8) With the income statement and balance sheet on separate sheets within the same Excel file, please have the income statement sheet as the 1st sheet & name the sheet with income statement "income statement" and the sheet with balance sheet "balance sheet"

9) Make sure the header of the date columns for individual periods are the same for the income statement and it's respective balance sheet.For example, if the date isDec 1 - 15, 18 on the income statement, then it would need to beDec 1 - 15, 18 on the balance sheet.

EEA - Drake

DAA - Ultra Tax CS

BAA (Left Hand Side) - Lacerte

BAA (Right Hand Side) - Proseries

LHA/JWA - Prosystems

Click on Apps from the left navigation panel>Click on disconnect

What you would typically see:

solution:

1. Launch Microsoft Word (or Excel, Powerpoint, etc)

2. Click the File menu

3. Choose Options

4. Choose Trust Center>Trust Center Settings

5. Choose Protected View>Unselect all the check-boxes

5. Click on OK until you're done.

6. Repeat steps 2 & 3 again

7. Choose Trusted Locations>Check the box for Allow Trusted Locations on my network

8.Click Add new location

9.Check Subfolders of this location are also trusted and click on Browse

10. Find & select folders where you would normally open downloaded files. some common ones include,Documents folder, Desktop, Downloads folder orC:\Users\john.doe\AppData\Local\Microsoft\Windows\Temporary Internet Files (replacejohn.doe with your profile information)

11.Click OK when done.

12. Repeat steps 8 to 10 to add additional locations where you would normally open word files.

Income Statement

It will apply the annualization factor (e.g. If the period was 3 months, the factor is X4) to the sub-accounts and roll up the value to the main account.

For example the following 3 months Cost of Sales main account is calculated by applying the annualization factor to the sub-accounts (100 X 4 = 400, 200 X 4 = 800). The Cost of Sales is then calculated by summing up the resulting sub-accounts (400 + 800 = 1200).

Balance Sheet

Other than Cash, Ending Retained Earnings, and Accumulated Depreciation, the rest of the balance sheet accounts will take values from the period that is being annualized.

Cash &Ending Retained Earnings

For both accounts, we take the initial value from the base partial period + Difference between annualized and base partial period net income values.

Net Income Difference = 800 - 200 = 600

Calculated Cash = 100 + 600 = 700

Calculated Ending Retained Earnings =100 + 600 = 700

Accumulated Depreciation

Accumulated Depreciation value in the annualized period will depend onbase period Gross Fixed Assets value, changes in Depreciation (COGS-related) value, changes in Depreciation value, and base period Accumulated Depreciation value.

There are 2 scenarios:If theGross Fixed Assets value < The Sum ofchanges in Depreciation (COGS-related) value andchanges in Depreciation value, then the annualized Accumulated Depreciation value will be the same as the base Gross Fixed Assets value.

Gross Fixed Assets = 50

changes in Depreciation (COGS-related) = 40 - 10 = 30

changes in Depreciation = 40 - 10 = 30

Since 50 < 30 + 30, Accumulated Depreciation will take the same value as Gross Fixed Assets.

If theGross Fixed Assets value > The Sum ofchanges in Depreciation (COGS-related) value andchanges in Depreciation value, thenthe annualized Accumulated Depreciation value will be the sum of base period Accumulated Depreciation value,changes in Depreciation (COGS-related) value, and changes in Depreciation value.

Gross Fixed Assets = 100

base period Accumulated Depreciation = 10

changes in Depreciation (COGS-related) = 40 - 10 = 30

changes in Depreciation = 40 - 10 = 30

Since 100 > 30 + 30, Accumulated Depreciation = 10 + 30 + 30

January20th2017 UpdatesEnhancements2016 Tax Returns are accepted by the Electronic Tax Return Reader

How to access Electronic Tax Return Reader:

1. Click on Import Client Financials on a company's income statement

2.Choose the Tax Return option on the bottom right

3.Choose theElectronic Tax Return Readerin order toupload the PDF of the tax return.

Manually Entered Tax Return Forms Are Updated With 2016 Tax ReturnChanges:

New Product Announcement

CashSage

CashSage helps advisers show their clients how an improve financial drivers of cash contributes to an increase in their clients' cash flow. More importantly, CashSage provides exactly what the business could do to increase cash-flow in the industry in which it competes.

Assuming you are inInternet Explorer, if you refresh the page and it still brings you to theWelcome to the ProfitCents CCH Integrator page even when you click on I've finished installing.

It's highly likely that your internet explorer has certain Active X filtering turned on.

Make sure it's checked>Gear Options Icon (top right hand side of your browser)>Safety>ActiveX Filtering

If it is checked, un-checking it & refreshing the page will reactivate the integrator.

Since Microsoft has discontinued their support and updates for Excel 2007, ProfitCents is unfortunately no longer able to support that product. Upgrading to a newer version is recommended.

If you're stuck on the Client Settings page,you may have selected the wrong server name/location. This often happens with Microsoft RDP or Citrix environment.

We recommend that you find the actual Server name from your IT Administrator and configure your profile's registry to always default to the correct server name. Often, it will default to yourexisting computer's name which is incorrect and will cause long load because of it's inability to find the correct path.

https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-2017

If the above method did not work try the following stepsMake sure we tried the name of the computer as the database server name. (example: My-Computer-01). Your computer name can be typically found by accessing control panel>system

If the input continues to not work, then it may be a TCP/IP connection enable issue. In order to check that it's enabled, use the following steps.

OpenSQL Server Configuration Manager. ()

Access SQL server network configuration>protocols for PROFXENGAGEMENT and make sure Status of TCP/IP says Enabled

If it is disabled, click on dropdown next to Disabled to enable (need Administrative permission)

search for Local Services or Services (windows search) and run the program

scroll down until you seeSQL Server (PROFXENGAGEMENT)

Right click & click on Restart

Refresh the ProfitCents page and try again

Projected Accounts Receivable

The projected values for Accounts Receivable are calculated using the projected Days ratio. This ratio can be quickly adjusted for all periods using the Projection Dials tab in the control panel of the Projection. To change the rate on a period-by-period basis, you can type in the ratios in the Balance Sheet Assumptions section of the Projection tab.

In general, the formula for Accounts Receivable is:

= Accounts Receivable Days / 365 * Sales

To find the figure for the first month of annual Sales used in the Accounts Receivable calculation, this is the formula:

= first month of projected Sales + 11 months of prior sales

To find the 11 months of prior sales, take the previous year's sales times 11/12.

Example

Let's say a company has two historical annual periods of 12/31/2017 and 12/31/2018. It has $1,000,000 in sales for Year 1 and $1,200,000 in sales for Year 2. It also has 30 Accounts Receivable Days projected. The first projected month, 1/31/2019, has a sales amount of $108,603 (as shown below).

To find how the projected Accounts Receivable is calculated, do the following:

Multiply the last historical period by the number of months of prior sales remaining over an annual period, in this case 11 months out of 12:

$1,200,000(11/12) = $1,100,000

Then add the first projected month's sales to that number: $1,100,000 + $108,603 = $1,208,603

Then, use the following formula:

= Accounts Receivable Days / 365 * Sales

= 30 / 365 * $1,208,603 = $99,337

Projected Inventory

The projected values for Inventory are calculated using the projected Days ratio, and it is very similar to the Accounts Receivable calculation. This ratio can be adjusted for all periods by using the Projection Dials tab of the control panel. To change the rate on a period-by-period basis, you can also type in the ratios in the Balance Sheet Assumptions section of the Projection tab.

The formula for Inventory is:

= Inventory Days / 365 * Cost of Sales

*Note: If Cost of Sales is set to 0, the formula for projected Inventory becomes Inventory Days / 365 * Sales instead.

Example

Let's say a company has 20 Inventory Days and an annual Cost of Sales (COGS) of $300,000.

To find the figure for the first month of annual COGS used in the Inventory calculation, this is the formula:

= first month of projected COGS + 11 months of prior COGS

To find the 11 months of prior COGS, take the previous year's COGS times 11/12.

$300,000(11/12) = $275,000

Then add the first projected month's COGS to that number: $275,000 + $27,151 = $302,151

Now use the formula

=Inventory Days / 365 * Cost of Sales

20 / 365 * $302,151 = $16,556

Note: The calculation for Inventory is very similar to Accounts Payable as well. You can swap out Inventory Days for Accounts Payable Days to get its formula.

=Accounts Payable Days / 365 * Cost of Sales

What is the Analytical Procedures Report?

The Analytical Procedures (AP) is an 8-10 page report with comprehensive analysis including text, graphs, trend and ratio analysis, detailed industry comparisons and an analytical procedures documentation worksheet. This report can be used to save significant time in the initial and final analytical procedures process.

Key Facts

The Analytical Procedures is one of our most detailed reports.

It is used by CPAs who are conducting an audit or review.

AP helps comply with SSARS No. 122 section 80, SAS Nos. 132, 122 AU-C, 230, 265, 315, 520, 570, Audit Documentation and AICPA Review Guidelines.

This report is used for audit and review documentation and analysis.

AP automates the task of developing and documenting expected values for your working papers.

Accountants use this report internally as part of working papers.

The report can be downloaded into a portable Excel file and edited.

How to Generate an Analytical Procedures Report

To generate an Analytical Procedures report, first locate the Analytical Procedures link on the homepage under the AUDITOR folder.

Once into the program select:

Run a new report for a company new to the system continue to step 1: Company Information.

Work with a company previously run on the system select a saved report you wish to run. You can add/edit data or simply skip to the last step and generate the final report.

Run a New Report for a Company New to the System

I. COMPANY INFORMATION

Company ID: Assign your client an anonymous ID number. This can be any combination of numbers or letters. The purpose of the Company ID is so you can identify the client but still keep the data anonymous. The Company ID can be edited/changed once the completed report is generated.

Country, State/Equivalent, Postal/Zip Code: Enter the appropriate information for the client in these fields. The Postal/Zip Code is an optional field and you may leave it blank if you wish. Your firms postal code can be used if the clients is unknown.

Organization Type: Select the appropriate organization type from the dropdown box. This will help us classify the data, but does not change the report.

II. INDUSTRY SELECTION

Please select the industry in which the company operates. Our industries are organized by NAICS codes (2012).

1) GO: Type the exact NAICS code input box then click on "GO" the button. This will take you to the next step.

2) FIND: Type part or the entire industry name in this search box then click on the "FIND" button. This will bring up a list of industry codes associated with the word you typed. Click the link that matches the industry for which you are looking. This will take you to the next step.

3) Complete Search: To the right of the GO and FIND options you will see the "CLICK HERE FOR DETAILED NAICS LISTING" button that is linked to the NAICS website. Clicking this button will open the NAICS website in a new browser window. From the NAICS website you can perform a Keyword Search. By typing in a keyword, you will be given a list of possible industries and NAICS codes. Once you find the industry you are looking for, type the NAICS code into the Sageworks

industry FIND box. This will bring up the link associated with the NAICS code you entered. Click on the appropriate link. This will take you to the next step.

4) Drill-Down Search: Find the Primary Industry Category that the industry you are looking for would fall under in the scroll down box. Double click on that Primary Industry Category. This will bring up a list of Summary Industry Categories. Double click on the Summary Industry Category that best fits the industry for which you are looking. You will then see a list of possible industry codes. Select the appropriate industry code and click the "CONTINUE" button. This will take you to the next step.

III. ANALYSIS SELECTION

Number of Financial Periods to be Analyzed: You may enter two to five periods of financial data. The default is set to analyze three periods of data. Please note that you must enter at least three periods of data in order for Expected Values to be calculated. If you choose to only input two periods of data, Expected Values will not be included in the report, but the report will generate a prior year comparison with a percent change.

Length of Each Period: Select the length of each period of data you will enter. You may select a period length of one month to twelve months. You must enter like periods (for example, three months compared to three months). * To annualize data, select Twelve Months

Type of Analysis: Choose which analysis you would like to perform. If you enter twelve months data, the analysis will be based on 12 months against the same 12 months from the previous year. If you enter monthly data, you will have the option of analyzing the number of months against the same number of months that directly preceded them OR the same months from the previous year (for example, Jan 2009 vs. Jan 2008 OR Jan 2009 vs. Dec 2008). After this step is completed, click "CONTINUE".

IV. INCOME STATEMENT

You are now on the Income Statement page. This is the step in which you will input your clients income statement data.

From here you can start by entering the Period End Date for the periods of data you will be inputting.

Input the appropriate data for the corresponding periods. Hover your cursor over the account name, Click the name and a pop-up will display the account explanation. Click the (T) to find its location on a tax form.

Adding a Sub-Account

In the Analytical Procedures report, you have the option of adding subaccounts to the input fields of the income statement and balance sheet. This will allow you to break down certain line items so that the input is more detailed and specific.

To add a subaccount on the Income Statement page, locate the input you would like to break down into subaccounts. To the right of that input field is a link folder icon, click on the folder icon and enter the sub-account name and value (multiple sub-accounts can be entered). After you name the subaccount, you may input the financial data for that account. There is a gray X located to the left of the new subaccount. Clicking this X will delete the subaccount you created.

QUICK TIP: All input fields will act as a calculator if needed.

Once you have completed the data entry for the Income Statement page, click "CONTINUE" at the bottom of the screen.

V. BALANCE SHEET

You are now at the Balance Sheet page. This is the step in which you will input your clients balance sheet data.

From here, you can begin to input the data from your clients balance sheet for each period.

Input the appropriate data for the corresponding periods. Hover your cursor over the account name, Click the name and a pop-up will display the account explanation. Click the (T) to find its location on a tax form.

QUICK TIP: If you leave the optional input of Number of Employees (FTE) as zero it will not be analyzed in the report and number of employees will not be included in the raw data section of the report.

Once you have completed the data entry for the Balance Sheet, click "CONTINUE" at the bottom of the screen.

VI. REPORT INFORMATION

After generating your report, you can customize it by clicking "Customize Report".

Accounting Method: Select the accounting method used to prepare the financial data. Choose between Cash Based or Accrual.

Scoring Format: Select the scoring format you would like to use on the report. Choose between Bar Scores, Number Scores, or Don't Show.

Chart Format:Select the chart format you would like to use on the report. Choose between 2D, 3D, or Don't Show.

SSARS No. 9 Analysis: Select whether or not you would like to include SSARS No. 9 Analysis.

Real Time Industry Data: Select if you would like to include industry data. If so, choose Include Real-Time Average or Include Real-Time Average and Industry Trends.

Include Client Data:If you have at least five clients for the chosen industry, you can choose whether to include client data.

Turnover Ratios: Select whether to include turnover ratios.

Tips for Improvement: Select whether you would like to include tips for improvement.

Further Customization: You may also:

Build your own cover page and upload your firm logo

You have the option to include real-time industry data and customize it with filters including time period, region, state and/or sales range

When you have completed the above steps, scroll to the bottom of the page and click on the "RUN REPORT AND SAVE AS A NEW REPORT" button. Your report will then be generated.

1. Click here to download the Sageworks CaseWare Template. Make sure that you save the file to an accessible location to navigate to in the near future (We recommend your Desktop or Documents).

2. Within Caseware, open the client file you wish to analyze. (File>Open)

3. navigate to File>Copy Components

4. In the Copy Component overlay, select Copy Into This File

5. Click Browse & select the file you downloaded in step 1 and click Next.

6. Make sureDocuments is checked>scroll all the down down & make sure the last row is checked (PCFS ProfitCents Financial Statement)>Next

7. Click Next

8. After processing, you should now see PCFS ProfitCents Financial Statement in your client's file

9. Clicking on it will open up the report interface, which will have instructions on how to map accounts & export the text extract produce from the report:

10. To map an account, click on drop-down to select group & the relevant account to import into ProfitCents accounts:

11. Once you finished mapping all the accounts, save (File>Save or pressing the save icon)

12. To export, select File>Export>Plain Text (*.txt):

13. Browse for a location that you would be able to easily navigate to and click Save. (We will need to find & upload the extract to ProfitCents in a little bit)

14. On the ProfitCents website, click Continue to go to the extract upload page

15. Click Browse & select the text file that you saved in step 13 and continue to finish.

Your computer may be searching for the correct CCH server to connect to. First, please wait at least 5 minutes to see if the pop-up to choose a server connection comes up.

If you have waited and the page is still frozen for an extended period of time, try these steps:

1. Press Windows Key+R on your keyboard to open the Run window. In the "Open:" field, type regedit

Alternatively, you can access "Run" without using a Windows shortcut by searching it in your computer and clicking the best match for "Run, Desktop app" and then typing regedit into the field.

2. Find the "CCH Integrator" folder in the left-hand pane of the registry. It is commonly under the HKEY_CURRENT_USER or HKEY_LOCAL_MACHINE folders.

3. Check that the registry has "127.0.0.1\PROFXENGAGEMENT" as a Local DB Server Name. Ifyou are using a Citrix server, then you will need to make it[Citrix server name]\PROFXENGAGEMENT instead of using 127.0.0.1.

You can change the details of the Local DB Server Name by right clicking on it in the right-hand side and choosing Modify.

4. If your registry is missing the Local DB Server Name, add it by right-clicking the CCH Integrator folder on the left-hand pane, hover over the "New" option, and choose "String Value." You can now name it "Local DB Server Name." After it is named, double-click to open the "Edit String" pop-up and type in the server name127.0.0.1\PROFXENGAGEMENT (or [server name]\PROFXENGAGEMENT).

5. Try re-loading the CCH Integration page in ProfitCents. It may have the top row populated with the server name you specified in the registry. From here, you should be able to Browse and continue on to pick user, client binder, etc. without the page freezing.

(DOWNLOADABLE VERSION BELOW)

In order to maximize the effectiveness of the program, spend a few minutes reading over these basic terms. They can also be given to clientele in the event that they need further explanation of terminology.

Accounting is a method of gathering financial information and reporting on the activities of a business. The ultimate end product of accounting is NOT good financial reports. Rather, the desired end points of accounting are an excellent understanding of your business and better management action. Remember, accounting does not equal bookkeeping. Sageworks ProfitCents fills the gap between bookkeeping and action. Accounts Payable are amounts owed to suppliers or vendors.

Accounts Receivable are amounts that customers owe the company for services rendered.

ADRs (American Depository Receipts) are certificates issued by a U.S. depository bank, representing foreign shares held by the bank, usually by a branch or correspondent in the country of issue. One ADR may represent a portion of a foreign share, one share, or a bundle of shares of a foreign corporation. Because ADRs are quoted in U.S. dollars and traded just like any other stock, they make it simple for investors to diversify their holdings internationally for companies that are located outside the U.S. but traded on U.S. exchanges.

Assets are resources that are owned by the firm and help earn profits. Many times, assets are buildings, machinery, inventory, or other resources that a company owns or holds. Assets are listed on the Balance Sheet. Remember that assets are not always tangible, something material that can be physically held. For example, accounts receivable is an asset, but it is not something tangible.

Balance Sheet is a listing of assets, liabilities, and equity as of a certain date. The Balance Sheet is one of the two most important financial statements. The other important financial statement is the income statement.

Cash (Bank Funds) is the total funds available in a company's checking, savings, and marketable securities accounts that can be used to pay bills within 90 days.

Cash Flow Forecast is a month-by-month projection of all expected cash receipts and cash expenditures for a company. The difference between expected cash receipts and expected cash expenditures is referred to as Net Cash Flow. Managers prepare a cash flow forecast to anticipate cash balances in the future.

Cash Flow Statements are reports of the cash inflows and outflows for a particular period of time. In many instances, these cash flows are grouped into 3 categories: cash from operations, cash from investing activities, and cash from financing activities.

Cost of Sales (COGS) is the direct cost of the products and services sold. The Cost of Sales section on the income statement may take on different formats. Typically, however, Cost of Sales (COGS) includes inventory costs, direct labor costs, material costs, sales commissions, and other costs directly associated with the generation of revenue.

Current Assets are assets that a company has for a short period of time before they are put into the business, such as cash, accounts receivable, and inventory. Other current assets include marketable securities and prepaid expenses.

Current Liabilities are amounts owed that must be paid for in the short term, usually within a year. Accounts payable is an example of a common current liability. Current liabilities are considered accrued (built-up) expenses.

Current Ratio equals Total Current Assets divided by Total Current Liabilities. The current ratio indicates the amount of liquid assets available to pay off current liabilities or the company's ability to pay its bills and meet its current obligations. Generally, the higher the current ratio is, the greater the company's liquidity.

Debt (Liability) is an obligation to pay money that is due under specified terms. It is an amount owed as of a certain date.

Depreciation and Amortization is a reasonable estimate of how assets lose value over time. Depreciation expense is the amount by which a company estimates an asset decreases in value for an income statement period in question.

Employees + Contractors (FTE) are the full-time staff and full-time contractors who do work. They are sometimes referred to as FTE (full-time equivalents). To calculate FTE of several part-time employees, take the total hours worked by the part-time employees and divide by the full-time equivalent hours.

Equity (Owner's Equity, Net Worth, Shareholders' Equity) is the recorded ownership claim of common and preferred shareholders in a corporation as reflected on the Balance Sheet. It is defined as Total Assets minus Total Liabilities.

Expenses are the costs of doing business and are measured over a certain period of time. Expenses show up on the income statement and are subtracted from Sales to determine Net Profit.

Extraordinary Gain or Loss is an economic event in a company that has a financial result which would not normally occur during the normal operating cycle of a business.

Financial Analysis is the act of evaluating a company's financial statements in order to understand the business better. The value of financial analysis is to help managers understand how the business is doing AND how they might improve performance. It can also help investors better understand the financial performance of companies in which they might like to invest.

Fiscal Year is a twelve-month period during which the company reports income and expenses. Most companies use January 1 to December 31 as their fiscal year, their fiscal year equals the calendar year. Sometimes, however, companies may choose to select a twelve-month period other than the calendar year. Basically, it is important to note that fiscal year does not always mean calendar year.

Fixed Assets are any assets on the Balance Sheet considered to have a life or usefulness in excess of one year. Common examples include land, buildings, and machinery. It is best to enter gross fixed assets into the Sageworks Analyst expert system. In other words, the Fixed Assets entry should not include any deductions for depreciation.

Fixed Costs are any costs or expenses that do not vary too much with changes in the volume of operations over a specified time. Rent expense is usually considered a fixed expense. However, no cost is fixed over the long term.

General & Administrative Expenses (G&A) are overhead costs such as rent, utilities, staff personnel, professional fees, and depreciation. G&A expenses are also referred to as Operating Expenses.

Gross Profit is the difference between Sales and Cost of Sales. It is the profit earned before paying operating expenses.

Gross Profit Margin equals Gross Profit divided by Sales, expressed as a percentage. It represents the cents of gross profit per sales dollar.

Income Statement shows a company's sales, expenses, and profits or losses for a certain period of time. The income statement is also referred to as a Profit & Loss Statement. The income statement and balance sheet are the two most important financial statements.

Interest Expense is the cost of borrowed funds (debt). Companies must typically pay a premium for the use of another's money.

Inventory is the value of goods that have been produced or purchased for resale.

Net Income is the bottom line net earnings (or losses) of a company.

Net Operating Income is the operating income for a company; how much profit is made from operations. In our model, Net Operating Income equals Net Income + Depreciation + Amortization + Interest Expense + Income Taxes + Extraordinary Gains or Losses.

Net Profit before Taxes is what is left over after all expenses are paid (except income taxes in our model). Profit is always expressed as monies earned during a certain period of time. It is probably a good idea to add back owner's compensation in excess of salary to Net Profit before Taxes on the input screen.

Net Profit Margin equals Net Operating Income divided by Sales, expressed as a percentage. It represents the cents per dollar of sales that the company extracts in profits. Finance professionals view this metric as a critical gauge because it indicates operating efficiency.

Operating Expenses are expenses that are paid from the gross profits of the company. They are often referred to as General & Administrative or Overhead Expenses.

Principal is the original amount of a loan. The rate of interest is based on the original amount of the loan.

Quick Ratio is the sum of Cash and Accounts Receivables divided by Total Current Liabilities. Both the quick ratio and current ratio assess a company's ability to meet short-term obligations. The current ratio measures a company's overall liquidity, while the quick ratio measures liquidity by considering only readily liquid assets, items that can be quickly converted to cash. It should be noted that not one ratio or metric can in itself accurately depict liquidity, which is largely driven by future events, not present conditions.

Ratio Analysis is the use of a variety of ratios in analyzing the financial performance and condition of a company.

Salary Expense is the cost of all full-time employees, including direct labor expenses used in calculating Cost of Sales. Salary Expense appears on the income statement and is used to assess labor productivity.

Sales (Income) is the revenue a company earns over time and is sometimes referred to as Gross Sales. Sales is equal to the total funds or monies generated before expenses. It is measured by time. In other words, companies earn a certain amount of sales over a day, week, month, or year.

Selling, General, and Administrative Costs (S,G,&A) are the costs associated with the day-to-day operations of the company. These costs may include rent, utilities, staff personnel, and all selling, general, and administrative costs incurred that are not covered by COGS. Some people refer to S,G,&A expenses as "Operating Expenses".

Total Assets is the sum of all assets a company has as of a certain date. Total Assets equals Total Current Assets plus Total Fixed Assets plus Other Assets.

Total Liabilities (Total Debt) is the total amount owed as of a certain date. Try not to confuse liabilities with expenses, which are the costs of doing business. Liabilities are accrued expenses, expenses that have added up over time. For example, a mortgage balance is a liability, but monthly mortgage payments are expenses. Expenses show up on an income statement while liabilities show up on a Balance Sheet.

Variable Costs are any costs or expenses that vary with changes in the volume of operations over a specified period. Inventory is an example of a variable cost.

You would need to uninstall your current integrator & then install the 2017.1 specific integrator to be compatible.

Click on the link to the right to begin installing the new integrator.

You would need to uninstall your current integrator & then install the 2017.2 integrator to be compatible.

Click on the link to the right to begin installing the new integrator.

Please note: This integrator is compatible with all versions of CCH.

Please click on the link to the right to install.

This is typically an issue with your Internet Explorer browser settings.

https://helpcenter.profitcents.com/hc/en-us/articles/213577906-How-do-I-download-the-CCH-integrator-file-

Check yourPrivacy Settings in Internet Explorer.- Make ProfitCents a trusted site by going to the Internet Explorer Gear button in the top right > clicking Internet Options toward the bottom of that menu > clicking the Security tab > adding http://www.profitcents.com to the Sites.1.

2.3.4.

Another option is to uninstall the integrator and reinstall.Located here:

You can also clear cache and browsing history from Internet Explorer:1. Click the gear in the top right of the browser > Safety > Delete Browsing History

You can also check your Active X control settings on the Security tab of Internet Options by following these instructions:

1. Click Custom level...

2. Screen down to Active X controls and plug-ins

3. Make sure the all of the following options are selected & click OK.

-Allow previously unused ActiveX controls to run without prompt: Enable-Binary and script behaviors: Enable-Download signed ActiveX Controls: Enable-Download unsigned ActiveX Controls: Enable-Initialize and script ActiveX controls not marked as safe for scripting: Prompt or Enable-Run ActiveX controls and plug-ins: Enable-Run anti-malware software on ActiveX controls: Disabled-Script ActiveX controls marked safe for scripting: Enable

You can follow these instructions to troubleshoot this issue as well:

https://helpcenter.profitcents.com/hc/en-us/articles/360000326226-What-if-I-click-on-the-Browse-buttons-and-nothing-happens-

If those steps do not work, another option is to check for anti-malware issues (MalwareBytes can cause some problems, for example). - Make www.profitcents.com an exclusion in anti-malware software - Turn off exploit blocking in anti-malware software

January 31, 2018 UpdatesUpload three Tax Returns at once with Electronic Tax Return Reader

[email protected]

Hide Focus Area Section in Analytical Procedure Reports

The Focus Area section of an Analytical Procedure, which appears when comments are added to the report, can now be hidden from the report.

January 17, 2018 UpdatesExport Industry Data and Industry Data with Company Comparisons to Excel

We now offer the capability to export Industry Data reports and Industry Data with Company Comparisons to Excel.

Export Financial Statements to Excel

We also offer the capability to export Financial Statements to Excel.

Easily Edit Company Information

You can now more quickly and easily edit company information, such as Institution ID, Country, State or Equivalent, Postal Code, and Institution Type by clicking the pencil icon next to the Institution ID.

November 21, 2017 UpdatesAccounting CS Integration for Nonprofits

We are excited to introduce an integration to Accounting CS for Nonprofits. Wecreated two different integrationsdepending on your preferences for installation.The non-installation method will work for both Virtual Office and server-basedversion of Accounting CS.

Added the Ability to Run Reports Directly from Period Selection Page

Added the Auto Save Functionality on Financial Statement Pages

When clicking any link on the Financial Statements Pages that navigates to a new page, the data auto saves, so data is not lost. If you do not want to save changes, the back button on every internet browser will not save changes.

ProfitCents Icon Change

As part of continuous improvements to security, we are updating our ProfitCents icon. Please note that you will not be able to login using your current icon after September 15th, 2017.Action Requested: Please follow our instructions to un-install your old icon and install the new icon.

September 12, 2017

ProfitCentsAwarded2017 "User Favorite" for Accounting Technology (Accountex USA)

September8, 2017 UpdatesWe Now Show The Underlying Number of Data-points For Common-sized Industry Data Sub-accounts.

Sub-accounts For Common-sized Industry Data Will Now Provide Additional Information On The Underlying Number of Data-points.

PowerPoint Exports Now Include Industry, Revenue, Periods Length

Added Z-score Metric To Narrative Reports

AddedThe Ability To See Classes From The Past 12 Months

August 12, 2017 UpdatesEnhancementsAccounting CS IntegrationWe are excited to introduce an integration to Accounting CS. Wecreated two different integrations depending on your preferences for installation.The non-installation method will work for both Virtual Office and server-basedversion of Accounting CS.

Speed Improvements For NavigatingFinancial Statement PagesWith financials where there are 100's of sub-accounts, it used to take a few minutes to navigate from the income statement to balance sheet and balance sheet to the next page. We made significant improvement to the save and load speed, and it will now only take a couple of seconds.

February 2017 UpdatesEnhancements

Client Data Comparison Is Now Available For Non-Profit Narrative Analysis.

After running reports with 5different non-profits within the same industry, you will be able able to turn on the feature to show how yourexisting company match up to your other clients' in Program Efficiency, Operating Reliance, Fundraising Efficiency, Current Ratio, Quick Ratio, Inventory Days, and many other metrics.

New Product Enhancement:We introduced the ability for CashSage to import financial data directly from ProfitCents.

CashSage helps advisers show their clients how an improvement in financial drivers of cash contributes to an increase in their clients' cash flow. More importantly, CashSage provides exactly what the business could do to increase cash-flow in the industry in which it competes.

Click here for a samplereport fromCashSage

January 2017 UpdatesEnhancements2016 Tax Returns are accepted by the Electronic Tax Return Reader

How to access Electronic Tax Return Reader:

1. Click on Import Client Financials on a company's income statement

2.Choose the Tax Return option on the bottom right

3.Choose theElectronic Tax Return Readerin order toupload the PDF of the tax return.

Manually Entered Tax Return Forms Are Updated With 2016 Tax ReturnChanges:

New Product Announcement

CashSage

CashSage helps advisers show their clients how an improvement in financial drivers of cash contributes to an increase in their clients' cash flow. More importantly, CashSage provides exactly what the business could do to increase cash-flow in the industry in which it competes.

August29th2016Updates

Request a Training!

Would you like to learn about new ProfitCents enhancements, best practices orwanta refresher trainingon reports?

Please submit our Training Request Form to let us know your preferred training date, time, and topics. For example, learn how to save time uploading client data using one of our client data integrators located in the product.

Training will be web-based and over the phone. It can be conducted one-on-one or for a group to best fit your needs.

View our Latest Enhancement Webinar Recording:

New Integration Feature

CCH Engagement Bulk Integration

With CCH Bulk Integration, firms who sign up for this service will be able to mass import hundreds of trial balance financials into ProfitCents. This will reduce the amount of time needed to start analyzing client deliverable. Please fill out this form to learn more about CCH Bulk Integration

Announcement:

Sageworks Electronic Tax Return Reader Wins CPA Advisor Tax & Accounting Technology Innovation Award

An enhancement in ProfitCents, the Electronic Tax Return Reader, is now patent-approvedand award-winning.

The CPA Practice Advisor award recognizes technology companies that serve the tax and accounting profession whose innovations represent outside the box thinking in product development, design and implementation, breakthrough technologies and cutting edge ideas that directly help accounting professionals and clients improve business.

This new product has significantly reduced the time accountants spend entering data vs. analyzing and presenting it, said Gail Perry, CPA Practice Advisors editor-in-chief and a CPA herself. Using this product with its analytics, accountants can transform business tax returns into financial health reports, projections and benchmarking reports for their clients in minutes. Read More...

May 23rd2016Updates

Sageworks is now a Xero Partner

Being a partner allows us to provide users asmootherand more stable Xero integration experience.

New Features

PowerPoint Background Theme upload

Users are able toupload and changethe background theme of their PowerPoint downloads.

Toaccess:

1. Select Settings>User Settings.

2.Select PowerPoint Theme Tab.

3. Your ProfitCentsPowerPoint downloads usingyournew theme.

Integration

Xero Partnership Integration

Eliminates the need to authenticate every time users pull their pre-existing Xero data.

Others

Training & Support Call Requests

Training & support call requests are nowavailablethroughsimple forms on the website!

Trainings can help you maximize your usage and your success.

February 2016Updates

New Features

Electronic Tax Return Reader (ETRR)for 2010-2015 Tax Returns

Users are now able to eliminate manual entry by uploading client data directly into ProfitCents. The patent-approvedtechnology supports PDF files created directly from select tax packages including:Drake, Lacerte, Proseries Tax,CCH Prosystem fx Tax, andUltraTaxCS.

How to access:

Integration

QuickBooks Online Integration

Users are able to easily pull any of their QuickBooks onlineaccounts and financials into ProfitCents.

Interface ChangeFor Integration Account MappingLast column (now labeled "Mapped") shows checked/unchecked boxes depending on whether the account has been mapped.

Report Customization

Customizable Report Sections For Profit & Non-ProfitreportsUserscan now turn specific sections of the reports off by default or even toggle off a section specific to an individual report.

Customizable Graph ColorFor Profit & Non-Profit reportsWithin reports, users are now given the optionto adjust the colors of their bar graphs.

Tips for Improvement in Industry Data ReportsWe are listening! We brought back tips for improvement due to popular demand.

Others

On hover Tool-tips for different reports

Provides users a more intuitive description showcasing which report is more relevant for their purpose.

Have Questions About These Enhancements?

We are here to help! Email us at

The projection evaluates whether or not to project depreciation at 0 based on Depreciation from the prior periodand Gross Fixed Assets from 2 periods prior. If the Depreciation is higher than the Gross Fixed Assets or if Depreciation is 0, the projected depreciation will be calculated to 0.

For example,

In this example, the prior period Depreciation was $34,5119 and Gross Fixed Assetsfrom 2 periods prior was $34,4063.Since Depreciation is higher than Gross Fixed Assets, projected depreciation is calculate to be 0.

The file to download can be found directly to the right under Related Documents.

To learn more about how we collect our data, click the link below.

Profitcents has updated the icon to a new version.After October 13th, 2017, you will no longer be able to login using the old version of the icon (icon installed before August 27, 2017)Please follow the instructions below to install the new version.

Uninstall the current icon (Start Menu -> Control Panel -> Add/Remove Programs -> ProfitCents Icon -> Uninstall) [email protected]

Download the ProfitCents Icon Installer below

When given the option, click "Save File".

When the download is complete, open theProfitCentsIconInstaller.msi file.

In the Open File dialogue, click "Run".

When the Installer is complete, you will be asked to enter your username and password.

Click "OK".If you have any questions, please reach out to us at

Symptom (only the following and nothing else):

ErrorMessage: Error in selecting a CCH client binder trial balance.(SelectCCHBinderTB)

You would typically see the above message as a result of selecting a trial balance (By clicking the Select button in the overlay).

https://www.screencast.com/t/fTdRXf4god

What usually cause this?

This usually happens because you may have a lot files (more than 4 GB) being uploaded to CCH Engagement which causes the system to create multiple "bins."

A possible solution:

1. You could typically uninstall the existing CCH integrator by going to yourC:\Program Files (x86)\CCH Integrator\CCH_API and double click the file to uninstall.

2. (Require your IT person to do this)run command prompt with Administrative Permission & Install this file using regsvr32. For example: regsvr32 "C:\CCHIntegrator.v6.6.dll"as a sidenote: you could also uninstall it using this command:regsvr32 "C:\CCHIntegrator.v6.6.dll" /u

3. If a prompt comes up for "Input Active Bin ID"

leaving it as "2" & Clicking "OK" would work most of the time, but if it does not, then switching it to "3" & clicking okay will allow you to proceed.

video recording:

1. Download Sageworks Extract Template

2.Inside Accounting CS, navigate to Report Designer (File>Report Designer)

3. Click File>Import and select the Sageworks Financial Statement Report Templatedownloaded in step #2.

4. You should now see Sageworks Extract Templateunder Financial Statements section.

5. Close the Report Designer.You should now be able to selectSageworks Extract Template (double click to select) report using Print Reports(File>Print Reports)

6. Select Sageworks Extract Template reportand Click Print Selected

7. Make sure

Only"Output to file" is checked

Text File (*.txt) is selected in the drop-down

Destinationof the report is recognizable.

Click OKto produce the extract.

8.Back in ProfitCents, select Upload text button and locate the export in step #7

Option 1: Turn off common-size section in report before downloading to word:

1. Click Customize Report

https://www.screencast.com/t/VUdRmVq7j

2. Click Section tab>Toggle off Common Size>Save

screen recording

Option 2: Download to PDF then open in word.

1. Download to PDF

2. Right click downloaded PDF file>Open With>Microsoft Word

How does Sageworks calculate the top/bottom 20% in the Industry Data with Company Comparison report?

What is the Company Comparison report?

Sageworks Industry Data with Company Comparison is a report the provides an analysis of real time industry figures and client financial ratios. The report will compare the business against the most recent 12 months, the past completed year, and all years of real time data. The data can be mined to fit specific company characteristics.

How does Sageworks calculate the top and bottom 20%?

After outliers have been removed, Sageworks will sort the data from highest to lowest. The 20%s will be calculated from the list and any ratio falling in the sections will be flagged top/bottom 20% with appropriate logic.

Read more about overall data collection methods

Download the icon here

Video: How to download the ProfitCents desktop icon

If the installation fails, you could try the following alternate method:1. Download the zip file

2. Click the downloaded zip file & copy ProfitCentsIcon folder to an accessible location (examples: Documents or Desktop)

3. Right clickSageworksIconand create a short-cut to drag to a place where you would easily access the icon.

4. Double-clicking the shortcut will now log you in or prompt you for your login if it's your first time clicking it.

In order to construct a Sageworks report, we look at a number of financial factors and metrics. We "score" these metrics by:

Comparing a company's scores against industry statistics

Evaluating trends, either positive or negative

In the Narrative and Analytical Procedures report, a company can receive a numerical score for each of the six sections of the report based upon the company's performance. This score ranges from 100, the top score, to 1, the lowest score. Scoring is determined by weighting each of the metrics we evaluate in an area and then assigning to each metric a score from 1 to 100. Even though the scoring facility of the program is fairly complex, it can only be a rough measure of overall performance in the section since you, as a user, may place more or less emphasis on one/some of the metrics than we do in scoring all metrics.

The scores for each categories are evaluated based on the following metrics:

Liquidity

Current RatioCurrent Ratio % ChangeQuick RatioQuick Ratio % ChangeNet Profit Margin % ChangeNet Profit % ChangeSales % ChangeInventory DaysAccounts Receivable DaysAccounts Payable Days

Profitability

Net Profit MarginNet Profit Margin % ChangeNet Profit % ChangeGross Profit Margin % ChangeGross Profit % ChangeSales % Change

Sales

Sales % ChangeGross Fixed Assets % ChangeEmployee % Change

Borrowing

Borrowing Use (By Default:Net Profit % Change / Debt % Change)Total Debt % ChangeCurrent Ratio % ChangeNet Profit Margin % ChangeNet Profit % ChangeInterest Coverage RatioDebt-to-Equity Ratio

Assets

Asset Use (By Default:Net Profit % Change / Asset % Change)Gross Fixed Assets % ChangeCurrent Ratio % ChangeNet Profit Margin % ChangeNet Profit % ChangeReturn on EquityReturn on AssetsFixed Asset Turnover

Employees

Employee Use(By Default: Net Profit % Change / Employee % Change)Net Income % ChangeEmployee % ChangeGross Fixed Assets % Change

Please call us at 866.603.7029 option 1 or email us at [email protected] should you have any particular questions on how we calculate scores.

September8, 2017 UpdatesWe Now Show The Underlying Number of Data-points For Common-sized Industry Data Sub-accounts.

Sub-accounts For Common-sized Industry Data Will Now Provide Additional Information On The Underlying Number of Data-points.

PowerPoint Exports Now Include Industry, Revenue, Periods Length

Added Z-score Metric To Narrative Reports

AddedThe Ability To See Classes From The Past 12 Months

1. Click Company>Set Up Users and Passwords>Set Up Users

2. If you are logging in as the admin, it will say that you are logged on

1. Make sure that you are in Internet Explorer 11 (This is not available for Internet Explorer Edge).

2. Click Import Client Financials to access the list of integration methods.

https://helpcenter.profitcents.com/hc/en-us/sections/202085743-QuickBooks-Desktop-Integration

3. Select QuickBooks.

4. Select the left option for QuickBooks Desktop integration.

5. If first time, click on Install ProfitCents QuickBooks Integrator to download the installation file.

6. When the download is completed, click on Run.

7. When the installation is completed, you will see the following dialogue. Go ahead and click on OK.

8. Make sure to only have 1 QuickBooks program open.

9. Make sure you only have1 of the client's file open in QuickBooks.

10. Make sure no dialogues are open in QuickBooks.

11. Go back to ProfitCents and click I've finished installing.

12. After a brief load, you should receive a prompt in your QuickBooks program to provide access to ProfitCents integrator. select the 3rd option Yes, whenever this QuickBooks company file is open, and click Continue.

13. ClickDone.

14. Head back to ProfitCents and you should see the following screen to indicate that the integration was successful.

If you are having issues, pleasevisit the following section to troubleshoot:

August 12, 2017 UpdatesEnhancementsAccounting CS IntegrationWe are excited to introduce an integration to Accounting CS. Wecreated two different integration depending on your preferences for installation.The non-installation method will work for both Virtual Office and server-basedversion of Accounting CS.

[email protected]

Speed Improvements For NavigatingFinancial Statement PagesWith financials where there are 100's of sub-accounts, it used to take a few minutes to navigate from the income statement to balance sheet and balance sheet to the next page. We made significant improvement to the save and load speed, and it will now only take a couple of seconds.

Have Questions About These Enhancements?

We are here to help! Email us at

1. Click on the name of theclient to navigate to the Edit Company page

2. Click Delete on the page

As always, please feel free to contact us if you have any questions, comments or feedback: [email protected]. We're committed to providing you with the best service.

New Features

Electronic Tax Return Reader (ETRR)for 2010-2015 Tax ReturnsUsers are now able to eliminate manual entry by uploading client data directly into ProfitCents. The patent-approvedtechnology supports PDF files created directly from select tax packages including:Drake, Lacerte, Proseries Tax,CCH Prosystem fx Tax, andUltraTaxCS.

[email protected]

How to access:

Integration

QuickBooks Online IntegrationUsers are able to easily pull any of their QuickBooks onlineaccounts and financials into ProfitCents.

Interface ChangeFor Integration Account MappingLast column (now labeled "Mapped") shows checked/unchecked boxes depending on whether the account has been mapped.

ReportCustomizationCustomizable Report Sections For Profit & Non-ProfitreportsUserscan now turn specific sections of the reports off by default or even toggle off a section specific to an individual report.

Customizable Graph ColorFor Profit & Non-Profit reportsWithin reports, users are now given the optionto adjust the colors of their bar graphs.

Tips for Improvement in Industry Data ReportsWe are listening! We brought back tips for improvement due to popular demand.

OthersOn hover Tool-tips for different reports

Provides users a more intuitive description showcasing which report is more relevant for their purpose.

Have Questions about these enhancements?

We are here to help! Email us at

Sageworks is now a Xero Partner

Being a partner allows us to provide users asmootherand more stable Xero integration experience.

New Features

PowerPoint Background Theme uploadUsers are able toupload and changethe background theme of their PowerPoint downloads.

Toaccess:

1. Select Settings>User Settings.

2.Select PowerPoint Theme Tab.

3. Your ProfitCentsPowerPoint downloads usingyournew theme.

Integration

Xero Partnership IntegrationEliminates the need to authenticate every time users pull their pre-existing Xero data.

Others

Training & Support Call RequestsMade training & support call requests available through digital entries.

If importingProfitCents CCH Grouping schedule showed "The input file you specified is not valid. This operation could not be performed," You may have a newer version of CCH Engagement that requires you to download a different grouping schedule.

Click here to download default schedule

Click here to download updated schedule

To change your password, you will need to know the answer to your security question.

Click here to change your password, when ready.

If you are an existing customer and you are having trouble logging in, resetting your password, or you changed your email address, please email us at [email protected], or call customer support at 866.603.7029 option 1.

Although Sageworks do not support Mac environments, users haveran projection reports successfully using Mac Bootcamp and/or parallel programs.

The following is a set of instructions to guide you through the process:

Download Microsoft Windows. If you don't have a Windows installation disc or .ISO disk image, you can purchase Windows on a DVD from many retail stores that sell software or online from retailers such as Amazon.com or the Microsoft Online Store.

Use Mac's existingBootcamp applicationto partition the hard drive and install Windows Operating System. (It may require 20GB+ of space)

Purchase Microsoft Excel. If possible, we recommend purchasing a stable version (e.g. Excel 2013)

Log into Windows using Bootcamp and installMicrosoft Office.

Test Sageworks' projection report running only Windows Operating Systemusing Excel .

(optional) Download a Mac parallel programlike Parallels that allows you to run Windows operating system and Mac operating system simultaneously. Here is a link: Parallels There should be an option to download a free trial.

February 2017 UpdatesEnhancements

Client Data Comparison Is Now Available For Non-Profit Narrative Analysis.

After running reports with 5different non-profits within the same industry, you will be able able to turn on the feature to show how yourexisting company match up to your other clients' in Program Efficiency, Operating Reliance, Fundraising Efficiency, Current Ratio, Quick Ratio, Inventory Days, and many other metrics.

[email protected]

New Product Enhancement:We introduced the ability for CashSage to import financial data directly from ProfitCents.

CashSage helps advisers show their clients how an improvement in financial drivers of cash contributes to an increase in their clients' cash flow. More importantly, CashSage provides exactly what the business could do to increase cash-flow in the industry in which it competes.

Click here for a samplereport fromCashSage

Click Here For All Updates

Have Questions About These Enhancements?We are here to help! Email us at