--- title: GENERAL LEDGER - Reports description: Accessing and generating General Ledger reports for Print / Preview / Email --- [![company logo](https://cs.geminilogic.com/hs-fs/hubfs/Gemini-Logic-Logo%20(1).png?height=120&name=Gemini-Logic-Logo%20(1).png)](https://www.geminilogic.com/) [User Manual](https://cs.geminilogic.com/en/migrated/manual) - [Go to Gemini Logic](https://www.geminilogic.com/) - [New Ticket](https://cs.geminilogic.com/en/migrated/manual/kb-tickets/new) - [Go to Customer Portal](https://cs.geminilogic.com/tickets-view) Spire User Manual - General Ledger - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base) - [Tips and Tricks](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/migrated/manual/analytics-for-spire) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-system-overview) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-settings) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-vendors) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory) - [Pricing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-price-matrix) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-purchase-orders) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-sales-orders) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-keyboard-shortcuts) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-company-settings) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-new-instal-company-setup) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-general-ledger) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-receivable) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-payable) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-payroll) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-production-manager) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-service-manager) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-defined-fields) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-job-costing) - [HubSpot](https://cs.geminilogic.com/en/migrated/manual/hubspot) - [Updates](https://cs.geminilogic.com/en/migrated/manual/hubspot#updates) - [Gemini Logic](https://cs.geminilogic.com/en/migrated/manual/gemini-logic) - [Shipping](https://cs.geminilogic.com/en/migrated/manual/shipping) - [Sales Taxes](https://cs.geminilogic.com/en/migrated/manual/sales-taxes) - [Spire User Manual](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual) - [Customers](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual#customers) [Back to home](https://cs.geminilogic.com/en/migrated/manual) 1. [User Manual](https://cs.geminilogic.com/en/migrated/manual) 2. Spire User Manual - General Ledger - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base) - [Tips and Tricks](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/migrated/manual/analytics-for-spire) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-system-overview) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-settings) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-vendors) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory) - [Pricing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-price-matrix) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-purchase-orders) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-sales-orders) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-keyboard-shortcuts) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-company-settings) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-new-instal-company-setup) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-general-ledger) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-receivable) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-payable) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-payroll) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-production-manager) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-service-manager) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-defined-fields) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-job-costing) - [HubSpot](https://cs.geminilogic.com/en/migrated/manual/hubspot) - [Updates](https://cs.geminilogic.com/en/migrated/manual/hubspot#updates) - [Gemini Logic](https://cs.geminilogic.com/en/migrated/manual/gemini-logic) - [Shipping](https://cs.geminilogic.com/en/migrated/manual/shipping) - [Sales Taxes](https://cs.geminilogic.com/en/migrated/manual/sales-taxes) - [Spire User Manual](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual) - [Customers](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual#customers) # GENERAL LEDGER - Reports ## Accessing and generating General Ledger reports for Print / Preview / Email ### ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-07-57-40-20-AM.png?width=50&height=47&name=image-png-Aug-31-2022-07-57-40-20-AM.png)  - **Access ** - **Accounts** list         ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-06-48-02-21-PM.png?width=625&height=210&name=image-png-Aug-31-2022-06-48-02-21-PM.png) - - - select or multi-select the Account(s) from the filtered or unfiltered list (see [GL Account Filters](https://cs.geminilogic.com/en/manual/general-ledger-accounts-list-functionality#GLAccountFilters)) - select ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-06-49-10-40-PM.png?width=37&name=image-png-Aug-31-2022-06-49-10-40-PM.png) **Print Selected** or **Print All** - **Account Details** **        ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-May-25-2023-12-35-43-3798-PM.png?width=529&height=238&name=image-png-May-25-2023-12-35-43-3798-PM.png)** - - **Transactions** list         ![](https://cs.geminilogic.com/hubfs/image-png-Aug-31-2022-06-48-21-60-PM.png) - - - select or multi-select the Transaction(s) from the filtered or unfiltered list (see [GL Account Filters](https://cs.geminilogic.com/en/manual/general-ledger-accounts-list-functionality#GLAccountFilters)) - select ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-06-48-50-57-PM.png?width=37&name=image-png-Aug-31-2022-06-48-50-57-PM.png) **Print Selected** or **Print All** - **Reports** tab         ![GLReportsTab](https://cs.geminilogic.com/hs-fs/hubfs/GLReportsTab.png?width=554&height=272&name=GLReportsTab.png) - - - select the **Report Template** (section) for the type: - **Financial Report** - **Historical Financial Report** - **GL Transaction** - **GL Historical Transactions** - enter the criteria / parameters - click on ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-06-49-23-17-PM.png?width=22&name=image-png-Aug-31-2022-06-49-23-17-PM.png) **Print **to select from the list of reports in the chosen Template category - **Generating Reports** - from the Spire Reports list, ![CheckBoxCheckedBlue](https://cs.geminilogic.com/hs-fs/hubfs/CheckBoxCheckedBlue.png?width=16&height=16&name=CheckBoxCheckedBlue.png) select the report(s) you wish to run - highlight the report to check the description below to see if it's what you expect![GLReportsList](https://cs.geminilogic.com/hs-fs/hubfs/GLReportsList.png?width=436&height=443&name=GLReportsList.png) - - select the run method:         - - - **Print**  - accept or change the **Printer** - accept or change the **Paper Source** - printer format permitted, select from **Duplex** options - accept or change the number of **Copies** - option to **Save Defaults** so same settings will be used next time this report is selected for printing - - - **Email ** - - - - **Setup** - establish [Company Settings](https://cs.geminilogic.com/en/manual/company-settings-email) - establish [User Settings](https://cs.geminilogic.com/en/manual/user-settings-modular-access-preferences#UserSettingsEmail) - - - - **Recipients**                                   ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Jun-04-2023-01-04-56-8108-PM.png?width=536&height=472&name=image-png-Jun-04-2023-01-04-56-8108-PM.png) - - - - - click into the **To** box and type email address(es) in the **To** box (separate additional email addresses with ‘;’)  - accept or change the **CC** and **BCC** recipient(s) default as set in User / Company settings  - **Attachments** box displays all reports being sent - select from available email addresses for the **From** and **Reply-To** fields - enter the message in the bottom box                                 - - - - option to **Select Template **or setup a new one: - Edit > Email templates                                         ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Jun-04-2023-11-59-54-3167-AM.png?width=140&height=244&name=image-png-Jun-04-2023-11-59-54-3167-AM.png) - - - - - **![](https://cs.geminilogic.com/hubfs/image-png-Jun-04-2023-11-59-40-3281-AM.png) New** template                                   ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Dec-16-2022-07-00-55-9380-PM.png?width=508&height=448&name=image-png-Dec-16-2022-07-00-55-9380-PM.png) - - - - - enter **Template Name** - - - - - enter **Subject** for the email - enter the email message in the **Body** section, in the **Rich Text** tab if you want to use formatting (bullets, etc) or the **Raw HTML** tab if you want to add special formatting or insert an image, or the **Plain Text** tab if you want to avoid any formatting  - option to ![](https://cs.geminilogic.com/hubfs/image-png-May-25-2023-12-39-53-1518-PM.png) **Insert Param** merge field(s) into the subject or message body - option to make this a ![](https://cs.geminilogic.com/hubfs/image-png-Jun-05-2023-10-16-25-5214-AM.png) **Shared Template** (other Users can use it) or  ![](https://cs.geminilogic.com/hubfs/image-png-Jun-05-2023-10-16-29-6514-AM.png) **Personal Template** - - - - if not using a template, then manually enter the **Subject** and **Message,** selecting either **Rich Text, Raw HTML,** or **Plain Text** tab - ** ![](https://cs.geminilogic.com/hubfs/image-png-Dec-16-2022-07-03-28-1995-PM.png) Attach File** of any type - **![](https://cs.geminilogic.com/hubfs/image-png-Dec-16-2022-07-03-38-9173-PM.png) Insert Param** merge field( s) available for the records selected                                 ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Dec-16-2022-07-04-12-5829-PM.png?width=152&height=155&name=image-png-Dec-16-2022-07-04-12-5829-PM.png) - - - - ** ![](https://cs.geminilogic.com/hubfs/image-png-Dec-16-2022-07-03-45-5617-PM.png) Send** the email or ![](https://cs.geminilogic.com/hubfs/image-png-Dec-16-2022-07-03-52-2998-PM.png) **Save / ![](https://cs.geminilogic.com/hubfs/image-png-Dec-16-2022-07-03-56-7601-PM.png) Save Close** and Edit / Send later from the ![](https://cs.geminilogic.com/hubfs/image-png-Dec-16-2022-07-04-04-5053-PM.png) **Email** module (note…emails can be re-sent) - - - **Preview** - see report(s) on screen with additional options (if multiple reports were selected, each report will populate a separate tab) with additional options:![](https://cs.geminilogic.com/hubfs/image-png-Dec-16-2022-07-04-45-1797-PM.png) - Use Ctrl + scroll to zoom in or out  - ** ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-06-57-58-96-PM.png?width=21&name=image-png-Aug-31-2022-06-57-58-96-PM.png) Print** the report currently in the viewer window - ** ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-06-58-13-56-PM.png?width=21&name=image-png-Aug-31-2022-06-58-13-56-PM.png) Print All** reports if multiple reports were chosen (shown by multiple tabs) - ** ![](https://cs.geminilogic.com/hubfs/image-png-May-25-2023-12-40-48-0480-PM.png) Export**![ReportsExport](https://cs.geminilogic.com/hs-fs/hubfs/ReportsExport.png?width=478&height=281&name=ReportsExport.png) - select the **Format** - select the **Destination** - **Application **will open the program on your computer that is associated with the **Format** you chose - **Disk file** will prompt you to save the Report in the **Format** you chose - **Exchange Folder** allows the Report to be accessed through a Microsoft Exchange client such as Microsoft Outlook - click **OK** - ** ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-06-58-37-86-PM.png?width=24&name=image-png-Aug-31-2022-06-58-37-86-PM.png) Find** to search text of the document / report - ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Dec-16-2022-07-06-31-1633-PM.png?width=384&height=25&name=image-png-Dec-16-2022-07-06-31-1633-PM.png) navigate through pages of the report alternatively to scrolling down  - **Security** on Reports can be established at Company Level, User Level or Server Level: - **Company Level** - Edit > Company Settings > Reports![CompanySettingsReportsSecurity-1](https://cs.geminilogic.com/hs-fs/hubfs/CompanySettingsReportsSecurity-1.png?width=622&height=262&name=CompanySettingsReportsSecurity-1.png) - **Disable Security** gives full access to all users for all reports to **Preview** / **Print** / **Export** / **Email** unless Security is Enabled in User Settings (described below) - **Enable Security** gives ability to select which reports can be accessed for all Users to **Preview** / **Print** / **Export** / **Email** - **User Level** - Edit > User Settings > Reports - **Company Default** applies Security settings from Company Settings (described above) - **Disable Security** gives full access to this user for all reports to **Preview** / **Print** / **Export** / **Email** - **Enable Security** gives access to security settings for each report listed, to **Preview** / **Print** / **Export** / **Email** - **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-07-07-32-06-PM.png?width=12&name=image-png-Aug-31-2022-07-07-32-06-PM.png) Use Defaults** establishes settings same as Company settings, with the ability to make changes ![UserSettingsReportReportSecurity](https://cs.geminilogic.com/hs-fs/hubfs/UserSettingsReportReportSecurity.png?width=589&height=247&name=UserSettingsReportReportSecurity.png) - **Server Level** - Tools > Server Administration - ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-07-07-51-97-PM.png?width=17&name=image-png-Aug-31-2022-07-07-51-97-PM.png) select a report in the list - ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-07-08-09-28-PM.png?width=12&name=image-png-Aug-31-2022-07-08-09-28-PM.png) delete or ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-07-08-18-16-PM.png?width=10&name=image-png-Aug-31-2022-07-08-18-16-PM.png) disable                 ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-31-2022-07-08-32-07-PM.png?width=343&height=340&name=image-png-Aug-31-2022-07-08-32-07-PM.png)   **Customizations** to Reports - most customizations will need to be done by your Spire Partner, but you can perform the following customizations: - Enter **Messages** to print on Financial Reports - access in Edit > Company Settings > Reports > Messages tab ![CompanySettingsReportsMessagesGL](https://cs.geminilogic.com/hs-fs/hubfs/CompanySettingsReportsMessagesGL.png?width=688&height=348&name=CompanySettingsReportsMessagesGL.png) - - select the **Report Type** as **Financial Report** - type the message in the **Header** and/or **Footer** text boxes - ie: 'Accounting Firm - Sharp Pencils LLP' / 'These numbers are final for the period identified in the report date' - printed Financial Reports will display messages - Header: ![CompanySettingsReportsMessagesGLTBHeader](https://cs.geminilogic.com/hs-fs/hubfs/CompanySettingsReportsMessagesGLTBHeader.png?width=688&height=200&name=CompanySettingsReportsMessagesGLTBHeader.png) - - Footer: ![CompanySettingsReportsMessagesGLTBFooter](https://cs.geminilogic.com/hs-fs/hubfs/CompanySettingsReportsMessagesGLTBFooter.png?width=688&height=163&name=CompanySettingsReportsMessagesGLTBFooter.png)   - **Available General Ledger Reports** | ***Report Name*** | ***Location*** | | --- | --- | | *Account Reconciliation* | Transactions List > Account Reconcile | | *Balance Sheet* | Accounts List / Reports tab > Financial Report Template | | *Bank Disbursements List* | Transactions List | | *Budgets and Forecasts* | Budgets and Forecasts List | | *Communication Notes* | Account Details > Communication Tab / Transaction > Communications Tab | | *Comparative Financial Statement* | Accounts List / Reports tab > Financial Report | | *Consolidated GL Account Activity* | Transactions List | | *Financial Statement by Period* | Accounts List / Reports tab > Financial Report | | *Financial Summary* | Accounts List / Reports tab > Financial Report | | *Financial Statement by 12 Periods Only* | Accounts List / Reports tab > Financial Report | | *General Ledger Account Activity* | Transactions List | | *General Ledger Journal Transaction* | Transaction Entry / Transactions List | | *GL Chart of Accounts* | Accounts List | | *GL Account Foreign Balance* | Reports tab > Financial Report | | *GL Account Period Balances* | Account Details > Balances tab | | *GL Account Period Balances Foreign* | Account Details > Balances tab | | *GL Foreign Balance* | Accounts List | | *GL Chart of Accounts Revaluation* | Accounts List | | *GL Foreign Balance* | Accounts List | | *GL Transactions by Month* | Reports tab > GL Transactions | | *GL Historical Transactions by Trans* | Reports tab > GL Historical Transactions | | *GL Historical Transactions by Acct* | Reports tab > GL Historical Transactions | | *Historical Balance Sheet* | Reports tab > Historical Financial Report | | *Historical Comparative Financial Statement* | Reports tab > Historical Financial Report | | *Historical Financial Statement* | Reports tab > Historical Financial Report | | *Historical Financial Statement by 12 Periods* | Reports tab > Historical Financial Report | | *Historical Income Statement* | Reports tab > Historical Financial Report | | *Historical Trial Balance* | Reports tab > Historical Financial Report | | *Income Statement* | Accounts List / Reports tab > Financial Report | | *Income Statement compared to Budget* | Reports tab > Financial Report | | *Income Statement compared to Forecast* | Reports tab > Financial Report | | *Invoice Re-Print* | Transactions List > View Source | | *POS Tick Re-print* | Transactions List > View Source | | *Purchase Order Re-Print* | Transactions List > View Source | | *Trial Balance* | Accounts List / Reports tab > Financial Report | | *Trial Post Transactions* | Transaction |   [![company logo](https://cs.geminilogic.com/hs-fs/hubfs/Gemini%20Logic%20-%20Black-1.png?height=120&name=Gemini%20Logic%20-%20Black-1.png)](https://www.geminilogic.com/) Gemini Logic - [![linkedin_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/linkedin_circle_color.png)](https://www.linkedin.com/company/2460588) - [![youtube_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/youtube_circle_color.png)](https://www.youtube.com/user/GeminiLogicInc/featured) - [![twitter_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/twitter_circle_color.png)](https://twitter.com/gemini_logic) - [Go to Gemini Logic](https://www.geminilogic.com/) - [New Ticket](https://cs.geminilogic.com/en/migrated/manual/kb-tickets/new) - [Go to Customer Portal](https://cs.geminilogic.com/tickets-view)