Balance Sheet Report

A balance sheet is a financial statement that compares a company's assets to liabilities in order to establish the "net worth" of the company. Net worth is the difference between the assets (what a company owns) and liabilities (what a company owes). This difference is referred to as "owner's equity" (aka. "retained earnings") which is also listed on the balance sheet report below the liability section. The total of all asset accounts should equal the total of all liability accounts (again, including the owner's equity/retained earnings balance). These two (2) sides (assets & liabilities) should always balance (assuming the report is run for the entire ledger). Your company's net worth is reflected by the balance of the owner's equity account.

An Important Note for New Users

Before doing any posting in General Ledger and after beginning balances are loaded, a balance sheet should be run to ensure that assets and liabilities (including retained earnings/owner's equity) do balance exactly. If posting is done and the balance sheet does not balance, there is no easy way to correct it, and it may be necessary to start General Ledger set up over (reload balances, re-enter the chart of accounts, and do manual journals to duplicate any journals that were posted). For this reason, carefully check all financial statements before actively using General Ledger.

Watermarks

Watermarks can optionally be printed on financial statements. This is only done when (1) the watermark option has been enabled and (2) the statement includes cycles that are not closed. The word "**DRAFT**" is included if these conditions exist.

General Ledger: Watermark Example

General Ledger: Watermark Example

Controlling the Report Output

To minimize the length of the report, try using the Group Summary option in the totals panel. You can also use the Filter option "Exclude Zero Balance Accounts" to potentially reduce the number of accounts listed. Many users expect their Balance Sheet to be the standard two (2) page report; however, whether or not this is possible depends on a few factors:

1. The settings selected when running the report.

2. How your company's Chart of Accounts is organized.

3. Use of a Custom Template (see below).

If your Chart of Accounts doesn't make use of Group and Title type accounts to organize and summarize the asset and liability accounts, you are probably not going to wind up with a two (2) page report (with more than just a minimal amount of detail). Using group and title accounts can help you better organize your accounts for the purposes of financial reporting.

Custom Statements

With release 11.3.5 (March 2016), we added a custom report option for use with the Balance Sheet and Income Statement reports. This allows your company to create its own customized financial statement. Once you have defined at least one custom report, using the Custom Report Setup utility (on the Utilities menu in the General Ledger area), a drop down is provided on the Balance Sheet (or Income Statement) forms in the Selection panel. Custom templates allow you to determine the order and level of detail included on your financial statements; however, you also control whether or not the statement accurately reflects all of your finances. Some report features are not available or enabled when a custom template is enabled.

Main Menu > General Ledger > Reports > Balance Sheet

Selection: Custom Template

Balance Sheet Styles

The balance sheet may be with the following variations: "to date" summary, previous year comparative, or MTD (month-to-date) change. As a default setting, the report is set to run in "comparative" mode.

Balance_Sheet_Report_Versions

Previous Year Comparative version includes the selected year, prior year (same relevant cycle), and the balances as of the end of the prior fiscal year:

Main Menu > General Ledger > Reports > Balance Sheet

Balance Sheet: Previous Year Comparative

To Date Summary only includes the selected year only:

Main Menu > General Ledger > Reports > Balance Sheet

Balance Sheet: To Date Summary

The MTD (month-to-date) Change variation is almost the same as the "Previous Year Comparative" except that the column named "Last Year End" is replaced with "MTD Change." The "change" column compares the selected cycle (month) and year with the prior month's balance (not the "last year" balance which is shown) and provides the dollar ($) difference between these two (2) periods. Please note: the prior month's balance is not displayed on the report. This is not the difference between the "this year" and "last year" figures.

Main Menu > General Ledger > Reports > Balance Sheet

Balance Sheet: MTD Change

Selection

Users must specify a particular cycle; however, to run a balance sheet for an entire fiscal year, select the "Adjustment" cycle and enter the fiscal year (FYR). Cycles are listed in the drop down based upon your fiscal year (not necessarily the same as the calendar year). This panel may also display a custom template drop down for selection if custom reports have been set up. The menu marker Menu_Marker_Icon1 offers a menu for setting the "cycle" month as either the current or prior month. This must be used when saving and scheduling a report that you want to always run for either the current or prior month's general ledger cycle; otherwise, if the menu is not used, the actual month and year listed are saved and won't be refreshed automatically when the report is run via the scheduler.

Main Menu > General Ledger > Reports > Balance Sheet

Report Selection by GL Cycle

G/L Department

Financial Statements and reports may allow users to designate departments for inclusion (or exclusion). If you make no selections, all departments (consolidated) are included by default. Limiting financial statements to specific departments can result in that statement appearing out of balance. There is no requirement for transactions to "balance" at the department level, and this should not be expected. Departments are often used to indicate that an account belongs to a specific branch location; however, they may be used for other reasons as well. Departments can be mapped to a specific branch by assigning offsets to each location in Parameters. User security can prevent access to any branch location. You may not be able to run or view an complete financial statement when departments are linked to a branch your user doesn't have permission to access.

G/L Department Selection

G/L Department Selection

Companies with the software are given a choice of four (4) account formats for use with their ledger. Three (3) of these account formats include a department segment (4-digits). The department is the 2nd segment (left to right) of the account number (when used). There are four (4) different account number formats available (shown below):

Ledger Account Format Choices

Ledger Account Format Choices

Please Note: The ledger is treated as a whole entity. Departments cannot be used to produce different financial statements for individual branch locations as if they were separate companies. This is because some accounts are always shared, and, even when possible, there is no guarantee that branch accounts are being used wherever necessary. To separately produce financial statements by location, you would need an entirely separate ledger and Spruce instance. In addition, there should be no expectation that financial statements "balance" or report reliable and reportable information when the report is not run for all accounts.

Filter On

Filters apply conditions to the data for inclusion (or exclusion) when the report document generates. Use the radio button clip0795 to designate the selected filter option.

Filter On Selections

Filter On Selections

None

"None" includes all accounts regardless of balance.

Exclude Zero Balance Accounts

If selected, this filter excludes zero balance accounts.

The exclude zero balances only considers the current period's balance when running the "to date" summary version. "Previous Year Comparative" and "MTD Change" versions apply the filter to both the current year and prior year balances. If neither balance is zero, the account is included; otherwise, if both the current and prior year balances are zero, the account is excluded.

Sort By

There are currently no "sort by" options available for the Balance Sheet. Assets are listed first and Liabilities second.

Totals

When running the Balance Sheet, totals may be printed using three (3) options: group summary, title/account summary, or all accounts. Use the radio buttons to designate your selection. A "group summary" prints totals for groups only. The "title/acct summary" option prints totals for each title and those posting accounts that are owned by a group (not those owned by title accounts). The "all" option prints totals for every account. This panel is disabled when a custom template is selected.

GL_Balance_Sheet_Totals

Changing total's selections alter the appearance of the financial statement when displayed or printed as well as the length of the statement.

Group Summary

Below is an example of the Balance Sheet run for group summary only. This is the most condensed version that users can run because only the group account totals print, no titles or posting accounts are included.

clip0802

All Accounts vs. Title/Acct Summary

The all accounts option is the least condensed version and will print all the asset and liability accounts. If you don't use Title accounts, there is no difference between these 2 versions. Totals print for each account type, so there will be a total for each header, group, and title (if using "all accounts") in addition to the posting account balances. When using the "Title/Acct Summary" title accounts are listed the same as Posting Accounts that aren't assigned to a Title. In this case, no separate Title subtotals are necessary, and the details of Posting Accounts owned by the Title account are not included.

Balance Sheet: Mock-up with Account Levels

Balance Sheet: Mock-up with Account Levels

Title type accounts will only print if used (title accounts allow a further breakdown for an additional level of posting accounts). The use of "title" accounts is optional in the set up of a Chart of Accounts, so if you're company doesn't use them, a blank heading line will be printed if using the "all accounts" totaling option.

Print and Output Options

Most reports share the same common print control. This allows the report to be either printed or saved as a file. When printing, a user can select either 1 or 2 printers and can also set the number of copies for each. When saving as a file, you can select from a number of different types (PDF, Microsoft Excel®, HTML, and TIFF). Neither printing nor saving as a file are required. These would only be done if you wanted to save a copy of the report and data for a given point in time. Certain types of activity and changes can affect data, including what is commonly viewed as "history," so anytime a "snapshot" at a particular point in time is desired, having a saved or printed copy is suggested. Reports are often also used for inquiry purposes. In many of these cases, viewing a report is sufficient. Printing and saving are optional unless you have a reason to do them.

The Process (F12) function is used to either print the report or generate a report file. We suggest using the Preview (F8) function prior to printing or saving to ensure that the report results match what you want to print or save. You can also use the Viewer to print a report and allows you to choose to print only selected pages from a report.

Reports

Reporting: Print Options

1st Printer and # Copies

The drop down control next to the label "1st Printer" provides a listing of available printers. An available printer is a printer that is either installed on your local machine or a server accessible printer if you are connected via Remote Desktop services (aka. Terminal Services). The default selection is the backroom printer assigned to the current station (if any). The listing of printers may contain devices that are specialty types, such as label printers, etc. that are not suitable for printing reports. This printer is only used if the "Print Report" check box is checked and the number of copies is greater than zero (> 0). The application does not print the report until you choose Process (F12).

2nd Printer and # Copies

The drop down control next to the label "2nd Printer" also provides a listing of available printers (see above). This allows you to print a report at two (2) separate locations if desired. Even if a selection is made, the second printer is only used if the "Print Report" check box is checked and the number of copies is greater than zero (> 0). The application does not print the report until you choose Process (F12).

Print Report

This check box determines whether printing is to be done if the user chooses Process (F12). The default selection is checked (true).

Save In

This is a text area with a Browse button that allows you to select a location where a report is to be saved as a file. Choose the Browse button to select an accessible file location. This might be on a local machine or a shared network location of some sort.
The application does not save your report as a file until you choose the Process (F12) function and only if you select the Output to File check box. Directory and file permissions can prevent you from saving files in some locations. It's best to choose a location you'll remember such as your "Documents" or "Desktop" locations.

Filename

This area allows you to set the file name you want to save the file with. The extension will automatically be set based on your selection from the "Type" drop down control. Saving (as a file) is not done until the user chooses Process (F12) and is only done if the "Output to File" is checked.

Output to File

This check box determines whether the report will be saved as a file when the user chooses Process (F12). The default selection is not checked (false).

Type

This determines the output format of the report when saved as a file. Choices currently include: PDF (Portable Document Format, .PDF), Microsoft Excel (Spreadsheet, .XLS), Hypertext Markup Language (Web Page, .HTM), or Tagged Image File Format (Fax, .TIF). The 97-2003 version of Microsoft Excel is used since it is forward compatible with newer versions. Free Adobe Acrobat Reader® software is required to access PDF format files. Any browser can be used to open HTML (HTM) files. TIF files is an older image format commonly used with faxing.

Functions

A number of functions are available with reports.

Preview (F8), allows you to preview the report before printing or saving it to a file.

Process (F12), allows you to print, save the report to a file, or transmit it, based on the report settings. These options are available with all reports.
Others, such as those related to saving and scheduling, are available with many but not all reports.

Select (F5)

Use the Select (F5) function to choose and load previously saved report settings. You can save report settings using the Save (F6) function, when applicable (report saving and selection is not provided for all reports).

The "Select Report Settings" dialog box offers a drop down control for report selection. Only public and the user's own private saved reports will be included in the listing. After selection, the report's associated description is displayed below. Click or choose "Accept" to continue and load the selected settings.

Select (F5)

Select Report Settings

Deleting Saved Reports

To delete a saved report, choose the Menu Marker Menu_Marker_Icon1 to display a context menu and choose the Delete option to delete the previously saved report settings. The Menu Marker only appears after report selection and if you have permission to delete the report. You can only delete a private report that you created or a public report. User security can restrict the ability to view or access Menu Marker functions. In addition, deletion may be restricted if the report settings are currently used with report scheduling.

Save (F6)

This function is provided for saving the current report settings (selection, filter on, totals, branch, etc.) for future use or scheduling. The ability to save report settings is not provided for all reports. Additionally, users may have to make a change in the report form before this function becomes available (since there is usually no need to save the default or initial settings).

Once all desired settings have been made and you have previewed the report to make sure it's what you need, choose Save (F6) to save your settings for future use or scheduling. Saved reports can be deleted (with certain restrictions) using the Menu Marker Menu_Marker_Icon1 found on the Select Report Settings form (accessed by the Select (F5) function). See the "Deleting Saved Reports" section for more details.

Save (F6)

Save Report Settings

Report Name

This defaults to the name of the current report, but can be modified. The "name" will be used for selection in the future.

Description

The description also defaults to the current report's name, but can be modified. This might be used for longer or more descriptive information about the report.

Save As

The "private" and "public" options determine whether your report settings will be available for use by others in your company.

  • Private : Private report settings are only visible to the user who created them.

  • Public : Public report settings can be accessed by any user with permission to use the current report.

Schedule (F7)

The Schedule (F7) function is used to process a saved report (using previously saved "settings") as a file based upon a defined schedule (once, daily, weekly, etc.). Reports must be saved prior to scheduling so that settings for selection, totals, sort by, etc. are determined in advance. Scheduled reports are processed by application services and are saved as files on the server, not the user's local machine. A built in delay between reports of two (2) minutes (120 seconds) is used by services for processing scheduled reports. So if multiple reports are scheduled for the exact same time of day, it would be normal for there to be a difference in process times. Files with the same name and save location (directory) will be overwritten. The default directories (on the server) for scheduled reports and scheduled user reports are determined by parameters.

Note: this function will only be available (enabled) AFTER and IF a report has been saved and the saved settings have been selected. Some reports do not support saving and scheduling.

Schedule (F7)

Frequency

It's possible to schedule a report to run once or on a more regular basis. Options include the following: once, daily, weekly, monthly, and yearly. The daily and weekly options change the file names used to prevent overwriting report files (continue reading for more information). For additional details regard frequency selections, click here

Start Time

The time of day (Eastern Standard Time) that the scheduler should process this report.

First Occurrence

The current or future date that the scheduled report should begin on. This might be a one time occurrence or it may repeat based on your "timing" selections in this form.

Save Filename

This is the file name that will be used. In certain cases, such as daily processing, the file name is used to indicate a day of the week.

Daily and Weekly Files and Naming Conventions

If a report is scheduled for daily or weekly processing and is being saved as a PDF format, the file name of the report will be automatically adjusted to reflect the day the file is created for. For example, if the report's file name is normally saved as mydailyreport.pdf, is scheduled daily, and run on a Monday, the file name is going to be mydailyreport(1).pdf. This prevents overwriting that would occur should the same file names be used daily. Weekdays are assigned numbers representing the day of the week. Sunday is day zero (0) and Saturday is day 6 (six).

myreport[0].PDF (Sunday's Report)

myreport[1].PDF (Monday's Report)

myreport[2].PDF (Tuesday's Report)

myreport[3].PDF (Wednesday's Report)

myreport[4].PDF (Thursday's Report)

myreport[5].PDF (Friday's Report)

myreport[6].PDF (Saturday's Report)

Copy Pathname

The "Copy Pathname" is optional and allows you to designate a secondary save location for the report. This allows two (2) copies to be retained. The same file name logic as described above is applied.

Type

This determines the output format of the report when saved as a file. Choices currently include: PDF (Portable Document Format, .PDF), Microsoft Excel (Spreadsheet, .XLS), Hypertext Markup Language (Web Page, .HTM), or Tagged Image File Format (Fax, .TIF). The 97-2003 version of Microsoft Excel is used since it is forward compatible with newer versions. Free Adobe Acrobat Reader® software is required to access PDF format files. Any browser can be used to open HTML (HTM) files. TIF files is an older image format commonly used with faxing.

Add Time-Stamp to File Name

This feature basically makes the report file name unique and prevents any overwriting of the file by a future schedule run (such as in cases where you want to save a monthly copy but not overwrite each month).

Save for User

If a user is selected, the report will be saved in the "users" report directory within a folder matching the user's name.

Notify User

If checked, the user will be notified each time the scheduler processes this report.

How are reports saved and where do I find them?

The path names entered determine the primary, and optional copy, save location(s) of the file on the server within either (1) the report or (2) user report directories specified in Parameters.

"User" reports are created under a folder matching the user's name in the designated "User Reports" directory. For example, if your user name is BOBG and you schedule a report using the "Save for User" option and the "user report" directory in parameters is "C:\SavedReports\Users\," the following path would be used for BOBG's reports:

C:\SavedReports\Users\BOBG\

This directory could then be shared with the user's Client machine either as a shared network location or drive. It is not possible to specify a drive or network location as the path name. Doing so will simply create a directory on the server matching the name you entered.

The client must have any necessary software installed in order to open the file format you specify. For example, a PDF (Portable Document File) file requires Adobe Acrobat Reader software and an Excel (XLS or XLSX) spreadsheet requires Microsoft Office Excel or other software capable of opening the file.

Preview (F8)

The Preview (F8) function can be used to display a report in the Viewer form. Viewing a report is strongly suggested before choosing to either print or process a report as a file since this can be used to both see the printed length in pages and also to check the report format based on the options you have selected. In addition, reports can be printed directly from the viewer itself which also allows for the added benefit of printing only selected page or pages and well as additional options your printer may offer.

Each time preview is selected, the report will be generated which requires a retrieval of data. In some cases, and based on the criteria selected, you may be warned about the quantity of data being retrieved. Often, receiving a message such as this indicates that your report's selection criteria are too broad.

Reporting_Large_Data_Request

When should I save or print a copy of a report?

Despite the fact that most reports can be run at any time and usually for any period, the data used for reporting is rarely static. Anytime you want or need to retain a "snap shot" at a particular point in time, the only reliable way to do so is by saving the report as a file (PDF, etc.) or printing a hard copy for your records. Later changes such as merging, renaming or renumbering, deletions, and other changes can all affect whether data appears on reports or where it appears in some cases. For example, if you ran a sales analysis for inventory group 11 at the end of the year, and then modified one item in that group to now belong to 62, future reports would no longer show the same total for group 11 or 62. For the most part, changes such as those described here only affect data when viewed in parts rather than as a whole. Using our previous example, viewing total entire sales for all inventory wouldn't be affected by a change to one item's group at a later time.

Using the Viewer

The same viewer is used for both reports and documents. The primary different between viewing a document and a report is that reports don't have document links. Some reports offer dynamic links to documents (within the report) which indirectly provide access to links for those documents. The same viewer window is shared by reports and documents. When more than one report and/or document is viewed (without closing the viewer in between), the prior reports (or documents) can still be viewed by toggling the current document using the "PrevDoc" and "NextDoc" buttons. This is not true when viewing more than one version of the same report or document, however. Although you can change the page size and quantity of pages visible in the viewer (side by side or tiled, for example), you cannot view different documents (or reports) at the same time or side-by-side. The only way to do this would be to open a second viewer from another application session or to save one or more reports/documents prior to viewing and open them as PDF (Portable Document Format) or some other type of file.

Viewer

Viewer with EOD Cashier Report

For additional information about tools available in the viewer, please click here.

Cancel (F9)

The Cancel (F9) function reloads the current form, clearing any changes.

Process (F12)

The Process (F12) function prints and/or saves the report as a file based on your selections in the Print Options panel.