Another important consideration for accounting firms planning to have multiple staff members working with financial statements is the multi-user issue. Keep in mind that while ISW can be used while QuickBooks is in multi-user mode, it is not possible to have more than one user access the same ISW file at the same time.
Custom columns can be created that perform math calculations on other data in the report as shown in Figure 7. Preferences The ISW preferences allow you to add your specific preparer information to your statements, including the accounting firm information, name, address, etc., and other defaults such as headers/footers, number formatting, and where data is to be stored on the. Statement properties The Statement Properties pane allows you to modify the title and add job and class filtering to the report (see Figure 3). ROW properties Use Row Properties (see Figures 4 5) to manage the data in a single or in multiple rows.
Features OF THE intuit statement writer, create customized financial statements in Excel from QuickBooks data adding all the additional features and reporting flexibility available in Excel. Create statements from scratch or use the pre-defined templates.
Multiple choices for date type, such as Current/Prior Period, Specific Month, Specific Quarter. Option to select the number of years of data to display. Option to select a specific class or all classes for reporting. Inside Excel, youll see the ISW Document Actions pane that provides specific options used to customize reports. To expand the menu options, click on the drop-down arrow next to each action (row) name.