--- title: GENERAL LEDGER - Account Reconciliation description: Use Spire to reconcile your bank accounts, investment accounts, and more --- [Skip to content](https://cs.geminilogic.com/en/manual/general-ledger-account-reconciliation#main-content) English Show submenu for translations [New Ticket](https://cs.geminilogic.com/en/manual/kb-tickets/new?hsLang=en) [Customer portal](https://cs.geminilogic.com/tickets-view?hsLang=en) ![Gemini-Logic-Logo (1).png\]](https://cs.geminilogic.com/hs-fs/hubfs/Gemini-Logic-Logo%20(1).png?height=40&name=Gemini-Logic-Logo%20(1).png) - Home - Products - Pricing - Blog - Company Open main navigation Close main navigation - Home - Products - Pricing - Blog - Company - English Show submenu for translations - [New Ticket](https://cs.geminilogic.com/en/manual/kb-tickets/new) - [Customer portal](https://cs.geminilogic.com/tickets-view) - [Go to Gemini Logic](https://www.geminilogic.com/) [Go to Gemini Logic](https://www.geminilogic.com/) Search the User Manual - There are no suggestions because the search field is empty. 1. [User Manual](https://cs.geminilogic.com/en/manual?hsLang=en) 2. [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/manual/spire-user-manual-general-ledger?hsLang=en) # GENERAL LEDGER - Account Reconciliation ## Use Spire to reconcile your bank accounts, investment accounts, and more **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Aug-30-2022-05-22-09-65-PM.png?width=50&height=43&name=image-png-Aug-30-2022-05-22-09-65-PM.png)**  - **Access** in 1 of 2 locations: - GL Account details:     **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-May-17-2023-09-54-35-0617-PM.png?width=547&height=232&name=image-png-May-17-2023-09-54-35-0617-PM.png)**  - - **Transactions** tab: ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-May-17-2023-10-09-26-7049-PM.png?width=660&height=284&name=image-png-May-17-2023-10-09-26-7049-PM.png) - select from the list which Reconciliation you wish to work in or click ![](https://cs.geminilogic.com/hubfs/image-png-May-17-2023-09-59-46-6639-PM.png) **New** **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-May-17-2023-09-59-35-1200-PM.png?width=588&height=176&name=image-png-May-17-2023-09-59-35-1200-PM.png)** - enter **End Date** / **Opening Balance** / **Closing Balance** of Bank Statement you are Reconciling to - this will confine displayed transactions to only up to that date, that have not been previously reconciled ![](https://cs.geminilogic.com/hubfs/image-png-May-18-2023-10-36-52-9620-AM.png) - - **Show All** will display transactions beyond the End Date entered, if desired - **![CheckBoxCheckedBlue](https://cs.geminilogic.com/hs-fs/hubfs/CheckBoxCheckedBlue.png?width=16&height=16&name=CheckBoxCheckedBlue.png)** flag each of the transactions that are on the statement - **Column Customization** - see [General Ledger- GL Accounts List Functionality](https://cs.geminilogic.com/en/manual/general-ledger-accounts-list-functionality?hsLang=en) - monitor transactions cleared amounts with the accumulated **Credits** / **Debits** - **Variance** shows 0.00 when you have matched all transactions with the Bank Statement - you have the option to post a Reconciliation file that does have a value in **Unreconciled** - **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Jun-05-2023-09-52-20-8324-AM.png?width=26&height=23&name=image-png-Jun-05-2023-09-52-20-8324-AM.png) Import** a bank file (\*.qfx - Quicken Financial Exchange or \*.ofx - Open Financial Exchange format) to automate the reconciliation process where the bank file transactions will appear on the left and match with your Spire transactions based on amount, cheque number, and if the dates are within 14 days of each other      ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Jun-05-2023-09-53-37-1788-AM.png?width=609&height=217&name=image-png-Jun-05-2023-09-53-37-1788-AM.png)   - - matched records will display on the right side in grey and Import references will appear in columns to the right: - **Import Check # / Import ID / Import Date / Import Payee / Import Memo** - select any transaction line to **Select** or **Deselect** to clear / unclear - left side will show only unmatched bank transactions - ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Jun-05-2023-09-53-58-5507-AM.png?width=253&height=139&name=image-png-Jun-05-2023-09-53-58-5507-AM.png)if there is an uncleared transaction that represents one of the automated transaction types, select it then choose the **Add Bank Fees** transaction type…the amount will load into your transaction automatically - **![](https://cs.geminilogic.com/hubfs/image-png-Aug-30-2022-05-24-54-92-PM.png) Post** (or Alt+s) this Reconciliation to mark all flagged transactions as Reconciled and remove them from the Reconciliation file - **![](https://cs.geminilogic.com/hubfs/image-png-Aug-30-2022-05-25-28-92-PM.png) Create Transaction** from this screen - **![](https://cs.geminilogic.com/hubfs/image-png-Aug-30-2022-05-25-33-58-PM.png) View Transaction** selected - **![](https://cs.geminilogic.com/hubfs/image-png-Aug-30-2022-05-25-38-92-PM.png) Open Account** to view / edit details - **![](https://cs.geminilogic.com/hubfs/image-png-May-17-2023-09-51-28-1080-PM.png) Save** or ![](https://cs.geminilogic.com/hubfs/image-png-Aug-30-2022-05-24-42-22-PM.png)  **Save Close** will create and save the Reconciliation file for later retrieval - **![](https://cs.geminilogic.com/hubfs/image-png-Jun-05-2023-09-56-08-9251-AM.png) Print** Account Reconciliation Report (see [General Ledger - Reports](https://cs.geminilogic.com/en/manual/general-ledger-reports?hsLang=en)) - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#main-content) - [Tips and Tricks](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/manual/analytics-for-spire?hsLang=en) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/manual/spire-user-manual-system-overview?hsLang=en) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/manual/spire-user-manual-user-settings?hsLang=en) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/manual/spire-user-manual-vendors?hsLang=en) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/manual/spire-user-manual-inventory?hsLang=en#main-content) - [Pricing](https://cs.geminilogic.com/en/manual/spire-user-manual-inventory?hsLang=en#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/manual/spire-user-manual-price-matrix?hsLang=en) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/manual/spire-user-manual-purchase-orders?hsLang=en) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/manual/spire-user-manual-sales-orders?hsLang=en) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/manual/spire-user-manual-keyboard-shortcuts?hsLang=en) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/manual/spire-user-manual-company-settings?hsLang=en) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/manual/spire-user-manual-new-instal-company-setup?hsLang=en) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/manual/spire-user-manual-general-ledger?hsLang=en) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/manual/spire-user-manual-accounts-receivable?hsLang=en) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/manual/spire-user-manual-accounts-payable?hsLang=en) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/manual/spire-user-manual-payroll?hsLang=en) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/manual/spire-user-manual-production-manager?hsLang=en) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/manual/spire-user-manual-service-manager?hsLang=en) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/manual/spire-user-manual-user-defined-fields?hsLang=en) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/manual/spire-user-manual-job-costing?hsLang=en) - [HubSpot](https://cs.geminilogic.com/en/manual/hubspot?hsLang=en#main-content) - [Updates](https://cs.geminilogic.com/en/manual/hubspot?hsLang=en#updates) - [Gemini Logic](https://cs.geminilogic.com/en/manual/gemini-logic?hsLang=en) - [Shipping](https://cs.geminilogic.com/en/manual/shipping?hsLang=en) - [Sales Taxes](https://cs.geminilogic.com/en/manual/sales-taxes?hsLang=en) - [Spire User Manual](https://cs.geminilogic.com/en/manual/spire-user-manual?hsLang=en#main-content) - [Customers](https://cs.geminilogic.com/en/manual/spire-user-manual?hsLang=en#customers) - Home - Products - Pricing - Blog - Company [![Chill listening crop-3](https://cs.geminilogic.com/hs-fs/hubfs/Gemini%20Logic%20-%20Black-1.png?width=77&height=24&name=Gemini%20Logic%20-%20Black-1.png "Chill listening crop-3")](https://www.geminilogic.com/) Gemini Logic Copyright © 2026, 9858733 Canada Inc. (Gemini Logic)