---
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,
---

[![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 Administration - 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 Systems - General Knowledge Base](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base)
3. Spire Administration - 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)

# 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

[![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)