Running Reports

Running Reports

Overview

Reports in CustomBooks™ are located in the Reports menu. They are broken down by module and are also available in the menu for modules included in your edition of CustomBooks™.

Common Features Across Reports

Report Command Bar

The Report Command Bar, the yellow bar at the top of your CustomBooks™ reports, offers key tools: Run Report, Settings (Save, Select Saved, Restore Default), Open New Report, Print, and Export.
  1. Run report - Run the report using the selected settings.
  2. Settings - This allows you to save report settings, retrieve and use previously saved report settings, or restore the report settings to the default.
  3. Open New Report - Opens a new report with default settings.
  4. Print - Print to a printer with the Print button.
  5. Export - Click the Export button to save the report in a variety of formats (PDF, XLSX, XLS, DOCX, etc).



Report Settings Tabs

General Tab

The General tab includes report-specific options, including accounting method, display options, sorting, and period selection.



Filter Tab

The Filter tab allows you to filter the report results by a variety of different factors that vary by report.



Header / Footer Tab

The Header and Footer tab allows you to add static text to the Header and Footer as well as change the title of the report.



Charts Tab

Using the Charts tab, create a variety of charts and graphs using the report data.



Format Tab

The Format tab includes page setup options and numeric and/or symbol formatting.



Hide Settings

The hide settings button hides the tabs and the report settings properties panel on the left.  To restore them, click Show Settings in the Settings menu in the Command Bar.

Save Settings

The Save Settings button allows you to save all of the report settings for future use.  Click Save settings, give the settings a name, and choose who can view and change the settings in the Save Settings dialog box.



Select Saved Settings

The Select Saved Settings button allows you to retrieve previously saved Report Settings for use.



Restore Default Settings

The Restore Default Settings button allows you to return the following subset of settings to their default status.
  1. General settings
  2. Rows/Columns settings
  3. Filter settings
  4. Header/footer settings
  5. Chart settings
  6. Format settings
  7. Levels structure setting
  8. All settings

View Mode

There are two view modes that can be chosen when running reports: Present and Analyze. Choose your view before running your report or switch between the two once the report has been run.

Present View Mode

The Present View Mode presents the report in a user-friendly manner and looks similar to a printed report. It is displayed using HTML, so this view is good for presenting to clients or analyzing the results. The web view mode has some limitations: Drill-down functionality is not available in this view, and the level will be shown at the highest level of detail and cannot be changed. Formatting is also not available in web view mode. This mode can be printed and exported to PDF,  but not emailed directly at this time. Hiding variances and totals is also unavailable.

Analyze View Mode

The Analyze View Mode is good if you need to adjust the results or drill down deeper into the numbers. It is presented in a spreadsheet-like view. This view has full functionality with levels, formatting, and drill-down capabilities. This report will appear left-justified. This mode can be printed, exported, and emailed in various file formats.



The Report Level Control

The Report Level control determines the detail at which the report will show. Click a higher number to see more detail or a lower number to see less detail.   



Info
Note:  This is only available when using the spreadsheet view mode.

Show Variance

Some reports have a Show Variance toggle that can display variance in comparisons using actual amounts ($), percentages (%), or both ($+%).  This can also be turned off.



Info
Note:  Variance can not be turned off in web view mode.

Formatting Buttons

The formatting buttons allow for the formatting of certain text in the Header/Footer and Title sections of the report. Unfreeze will cause the header to scroll when viewing the report.



Info
Note:  Formatting is only available when using the Analyze View Mode.

Advanced Report Settings

To change the structure of the report, use the Advanced Settings option in the More Actions.




How to Run a Report?

To run a report:
  1. Navigate to the appropriate module in the Reports module and choose the report to run.
  2. Choose a time range in the Period dropdown (if applicable). For custom date ranges, choose Custom and enter the Start and  End dates. Note: This setting differs per report. Some have a date range, others a single date, and others a period selection.
  3. Click General tab or Filter tab and choose the report filtering needed.
  4. Click Run Report.
  5. Export to Excel or PDF by clicking the Export button. (optional)
  6. Print by clicking the Print button. (optional)
  7. Send via email by using the Send button (optional)

Report Tips and Tricks

  1. In many reports, clicking a figure in the results will allow you to drill down to see what transactions make up that total.
  2. To hide the report parameters from appearing in the results, click the eye icon in the report setting properties window next to the parameter.
  3. To choose more than one option from a dropdown, choose Open selection window and check the checkboxes of the items to include.
  4. To change the precision (number of decimals shown), zero and negative number presentation, highlight a figure(s), and click Format current numeric field*.

    • Related Articles

    • The CustomBooks™ Command Bar

      The CustomBooks™ command bar appears at the top of almost every screen in the application and contains actions that may be taken on the data showing on the screen. For example, on the Sales Orders list view, you can use these actions to create a new ...

    • Getting Started - Settings

      CustomBooks™ Settings After completing the Setup Wizard, users need to review these advanced settings, as the Setup Wizard primarily covers basic and initial account configurations. In this step, you'll learn how to add users and set user profiles, ...

    • Budget vs. Actual Report

      Overview The Budget vs. Actual Report will show budgeted amounts for each account included in the budget along with actual account totals for comparison purposes. This reports on Budgets that have been pre-created in Accounting --> Budgets. Click ...

    • Assembly Bill of Materials Report

      Overview If you have ever wanted to see a quick look at what assemblies a product is used in, this report will do the trick.   Complete the steps below once and save,  and you can run the report whenever you need it.   The report will be grouped by ...

    • How do I share Report settings?

      For all reports (except the Universal Report), If you want to share a previously saved report: Open the saved settings and then click save as. In the bottom of that pop window, checking the  For All Users toggle will allow you save the settings for ...