GL Reports
Menu File | GL | Reports
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 BS1 costing over $199) for creation of custom reports via MS Access or Crystal Reports, mail merge with MS Word, and to import BS1 data to MS Excel, etc. There is also a free utility for importing and exporting data. Source Code is available so that programmers can modify the built-in reports and screens, and add new features.
|