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.



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.



Watch the video below for a visual representation of the view modes of the reports.




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

    • CustomBooks™ Reports

      Reporting CustomBooks™ has a complete set of financial, operational and project based reports. Our advanced reporting customization features allow you to create the report you want. To run a report, Navigate to Reports → Report Category (Ex. Sales) → ...
    • AccountingSuite™ Product Perks: May 2024 - Financial Comparative Reports

      Financial Comparative Reports Open cbdee363-686a-425d-9459-f15fc928e703.gif This month’s Product Perks video highlights our Comparative Financial Reports. Checking to see how you’re doing in relation to past periods is always a good thing and these ...
    • Multi-currency Financial reports (extension)

      Multi-currency reporting offerings include the Income Statement, Balance Sheet, A/P Aging, A/R Aging, and General Ledger reports Introduction Now available with multiple currencies, CustomBooks™’s Financial Reports are available in multi-currency ...
    • Expense Reports (extension)

      Overview The Expense Reports extension allows users of your organization to submit expense reports and managers to approve the expense reports. Installation Please view this article for installation instructions. Setup A few setup tasks are needed In ...
    • Using Charts in Reports

      Charts are available in reports.    Adding a chart To add a chart, Click Charts in the header links. Click " Add Chart ". Select the type of chart from the dropdown.  The chart properties editor will be displayed. Choose the fields to report on by ...