Microsoft Excel and Microsoft Word integration

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

For licensed users of Accounting CS Workpapers

When you open a Microsoft Word document or Microsoft Excel workpaper from within Workpaper CS, you can use the Workpapers CS add-in ribbon to combine the formatting and calculation capabilities of these applications with client data that is linked directly to Accounting CS. 

Workpapers CS add-in ribbon

The following commands are available in the Workpapers CS add-in ribbon when you open an Microsoft Excel spreadsheet or Microsoft Word document from the Workpapers Dashboard.

Ribbon command and image Function

Procedure N/A

Proc na button

Insert the text "N/A" in the selected cell. (Available in the Workpapers CS ribbon in both Microsoft Word and Microsoft Excel.) 

Procedure completed

Proc comp button
Insert your Staff ID and date in the selected cell. (Available in the Workpapers CS ribbon in both Microsoft Word and Microsoft Excel.)

Checkmark

Proc checkmark button
Insert a checkmark in the selected cell. (Available in the Workpapers CS ribbon in both Microsoft Word and Microsoft Excel.)

Hide/Show zero balance rows

Hide show zero-bal rows button
Hide or show rows with zero balances on custom Excel workpapers. Affected rows remain hidden or revealed until the opposite option is selected, even if the balances change. You can choose to apply this option to the active worksheet or to all worksheets in the current workbook. (Available in the Workpapers CS ribbon in Microsoft Excel.)

Recalculate

Recalculate button
Recalculate the workpaper(s) for changes made to the client data since the Excel workbook was last opened or created (for example, changes to the trial balance or journal entries). (Available in the Workpapers CS ribbon in both Microsoft Word and Microsoft Excel.)

Properties

Properties button
Add or modify properties for existing columns in the current custom Excel workpaper, and change the orientation of the workpaper. (Available in the Workpapers CS ribbon in Microsoft Excel.)

Tickmarks

View legend
Tickmark legend
Insert a tickmark in the selected cell. (Available in the Workpapers CS ribbon in both Microsoft Word and Microsoft Excel.) Custom tickmarks that are added from the Setup > Firm Information > Tickmarks screen are also available to be inserted.

Insert Legend

Insert legend button
Insert the Tickmark Legend in the selected cell. (Available in the Workpapers CS ribbon in both Microsoft Word and Microsoft Excel.)

Insert Workpaper Link

Insert formula button
Inserts a hyperlink to a selected workpaper in the current engagement binder. (Available in the Workpapers CS ribbon in both Microsoft Word and Microsoft Excel.)

Insert Formula

Insert formula button
Insert text variables such as client name, or workpaper reference. (Available in the Workpapers CS ribbon in both Microsoft Word and Microsoft Excel.)

Calculator

Calculator
Opens the built-in calculator which can be left open while you perform other tasks in the application.

Clear During Roll Forward

ClearRollFwd

Marks the contents of the selected cell for deletion during roll forward. A comment (red tag) is attached to the cell in the worksheet when the content is marked to clear during roll forward, but the formatting remains unchanged. Click the Clear During Roll Forward button a second time to remove the flag and retain the roll forward behavior.

Format Variables

ClearRollFwd

Opens the Format dialog that enables you to format selected amounts. (Available in the Workpapers CS ribbon in both Microsoft Word and Microsoft Excel.)

Note: Format changes are applied to new variables only and not existing ones.

Note: Integration with Microsoft Excel and Microsoft Word is a one-way link from the Accounting CS database. The Microsoft Excel workpaper and Microsoft Word document are refreshed automatically when opened for the first time in Accounting CS. Subsequent updates made to the database are updated in the Microsoft Excel workpaper and Microsoft Word document when you choose Recalculate Recalculate button in the Workpapers CS ribbon.

Related topics

Add Workpaper Wizard

Defining columns in an Microsoft Excel workpaper

Inserting variable formulas

Inserting links from the Workpapers CS ribbon in Microsoft Word and Microsoft Excel

Adding a custom Microsoft Excel workpaper

Top of page

Share This