GL Reports                                        

Reports menu.

General Ledger

This report shows opening balance, transactions, and closing balance for each account for the selected period.

Tip: You can also display and print GL transactions via the GL History screen, which has options to filter and drill down to JV and/or invoice, etc.

Trial Balance

This report shows net change and balance (actual and buget) for each account for the selected period. For revenue and expense accounts the balance is the net change year-to-date.

Tip: This information can also be displayed and printed via the GL Totals and Budget screens, which have options to sort, filter, and drill down (total -> history -> JV and/or invoice, etc.)

Financial Statements

The Financial Statements are user-definable reports. You define the how the GL accounts should be summarized, the text for each line, and the columns to print. You can create reports such as an Income Statement (sometimes referred to as a Profit and Loss) showing sales, expenses and profit. Or a Balance Sheet showing assets, liabilities, and equity.

Financial statements can be run for selected subaccounts without having to set up separate statement formats. For example an income statement for product group "Frozen Pies", and/or division "West", etc. Or select no subs to get a summary consolidated report.

If “Validate” is selected, a warning shows any missing accounts, duplicate accounts, or account type discrepancies such as assets or liabilities included on an income statement.

Lists

These list screens have a print option, and can be filtered and sorted in different sequences.

GL Accounts

Journal Vouchers

Budget

GL Totals

GL History

Other

An ODBC driver is available (free upon request for end-user versions of Pilot) for creation of custom reports via MS Access or Crystal Reports, mail merge with MS Word, and to import Pilot data to MS Excel, etc.