--- title: Recalculate gl account balances description: This will repost the GL accounts with the transactions from all periods. Execute this query in PGAdmin UPDATE gl_accounts SET last_year = '{0.00,0,0,0,0,0,0,0.00,0,0,0,0,0}', this_year = '{0.00,0,0,0, --- [Skip to content](https://cs.geminilogic.com/en/manual/recalculate-gl-account-balances#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 Systems - General Knowledge Base](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en) 3. [Spire Administration - General Ledger](https://cs.geminilogic.com/en/manual/spire-systems-general-knowledge-base?hsLang=en#spire-administration-general-ledger) # Recalculate gl account balances This will repost the GL accounts with the transactions from all periods. [Execute this query in PGAdmin](https://support.spiresystems.com/solution/articles/13000015301-executing-a-sql-query-using-pgadmin) UPDATE gl\_accounts SET last\_year = '{0.00,0,0,0,0,0,0,0.00,0,0,0,0,0}', this\_year = '{0.00,0,0,0,0,0,0,0.00,0,0,0,0,0}', next\_year = '{0.00,0,0,0,0,0,0,0.00,0,0,0,0,0}', foreign\_last\_year = '{0.00,0,0,0,0,0,0,0.00,0,0,0,0,0}', foreign\_this\_year = '{0.00,0,0,0,0,0,0,0.00,0,0,0,0,0}', foreign\_next\_year = '{0.00,0,0,0,0,0,0,0.00,0,0,0,0,0}'; UPDATE gl\_accounts AS a SET last\_year = r.last\_year, this\_year = r.this\_year, next\_year = r.next\_year, foreign\_last\_year = r.frn\_last\_year, foreign\_this\_year = r.frn\_this\_year, foreign\_next\_year = r.frn\_next\_year FROM gl\_reallocate\_balances() AS r WHERE a.division = r.division AND a.account\_no = r.account\_no AND a.currency = r.currency - [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)