--- title: Account Number, Account Mask & Consolidation Account Setup description: "Account numbers: Use of account numbers is an optional setting in PlanGuru. This setting can only be chosen at company setup and cannot be edited later. If you wish to use account numbers, click the “" --- [Skip to content](https://help.planguru.com/knowledge/account-number-account-mask-consolidation-account-setup#main-content) [![PlanGuru Help Center](https://help.planguru.com/hs-fs/hubfs/logo_PlanGuru_helpcenter.png?width=360&height=50&name=logo_PlanGuru_helpcenter.png)](https://help.planguru.com/knowledge?hsLang=en) - [Your Tickets](https://help.planguru.com/tickets-view) - [Sign out](https://help.planguru.com/_hcms/mem/logout) Open main navigation Close main navigation - [Your Tickets](https://help.planguru.com/tickets-view) - [Sign out](https://help.planguru.com/_hcms/mem/logout) - [Submit a Ticket](https://help.planguru.com/tickets-view/new) [Submit a Ticket](https://help.planguru.com/tickets-view/new?hsLang=en) Hello. What do you need help with? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.planguru.com/knowledge?hsLang=en) 2. [PlanGuru Desktop (Windows)](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en) 3. [Setup & Maintenance](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#setup-maintenance) # Account Number, Account Mask & Consolidation Account Setup **Account numbers:** Use of account numbers is an optional setting in PlanGuru. This setting can only be chosen at company setup and cannot be edited later. If you wish to use account numbers, click the “Use Account Numbers” checkbox during company setup. Using account numbers is useful if you want to import your budget amounts back into your accounting software. ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360004286771image.png) **Defining an Account Mask:** If you chose to use account numbers, the application will ask you to enter an account mask. The account mask defines your account number format. Enter the pound sign “#” to format a character of your mask as a number, a period "." or dash "-" can be entered as a delimiter to follow your ledger's account numbers. If you want to consolidate on part of your account mask that portion must be separated from the rest by a delimiter. For Example, if the accounts number format in your accounting software look like 120.10, 310.20, etc. You would enter your account mask as: ###.##![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360004292872image.png) **Consolidation Account Setup:** If you are using account numbers, enter the portion of the account number you want to use for consolidating purposes. For example: if you have a 3-digit main account number with a 2 digit subaccount number, which indicates a subsidiary number, you only want to consolidate on the main account number. In this case the mask for the consolidation would be "AAA.SS". ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360004286811image.png) **For example:** If your account mask is ###-### and your consolidation account setup is AAA-SSS. Notice that during consolidation the portion of the account assigned “SSS” is ignored. Thus 101-011 from Analysis 1 is combined with 101-021 from Analysis 2 into a single account 101. ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360004292932image.png) Conversely using the same account mask but instead a consolidation account setup of SSS-AA would result in the following:   - [Account numbers.pdf](https://help.planguru.com/hubfs/Account%20numbers.pdf?hsLang=en) - [PlanGuru App (Online)](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#main-content) - [Getting Started](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#getting-started) - [Setup & Import](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#setup-import) - [Company Management](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#company-management) - [Forecasting & Modeling](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#forecasting-modeling) - [PlanGuru Analytics (powered by Reach Reporting)](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#planguru-analytics-powered-by-reach-reporting) - [Standard Reports](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#standard-reports) - [Updates](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#updates) - [PlanGuru Desktop (Windows)](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#main-content) - [Updates](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#updates) - [Getting Started](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#getting-started) - [Navigating PlanGuru Desktop](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#navigating-planguru-desktop) - [Setup & Maintenance](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#setup-maintenance) - [QuickBooks Online Import](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#quickbooks-online-import) - [QuickBooks Desktop Import](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#quickbooks-desktop-import) - [Excel Import](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#excel-import) - [Analysis Setup](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#analysis-setup) - [Forecasting & Modeling](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#forecasting-modeling) - [Installation](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#installation) - [Licensing](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#licensing) - [Managing your PlanGuru Files](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#managing-your-planguru-files) - [Reporting](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#reporting) - [PlanGuru Analytics](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#planguru-analytics) - [Technical Inquiries](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#technical-inquiries) - [PlanGuru Desktop in Cloud Hosting](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#planguru-desktop-in-cloud-hosting) - [Advanced Reporting Excel Add-in](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#advanced-reporting-excel-add-in) - [PlanGuru University](https://help.planguru.com/knowledge/planguru-university?hsLang=en) - [PRODUCTS & PRICING](https://www.planguru.com/products/) - CUSTOMERS - [Small Businesses](https://www.planguru.com/users/small-business/) - [Nonprofits](https://www.planguru.com/users/nonprofit/) - [Accountants / Advisors](https://www.planguru.com/users/accountants-business-advisors/) - LEARNING - [Attend a Live Demo](https://www.planguru.com/products/planguru-webinar-signup/) - [PlanGuru University](https://www.planguru.com/planguru-university/) - [Sign Up for PGU](https://www.planguru.com/planguru-university/) - [PGU Class Materials & Recordings](https://www.planguru.com/planguru-university/class-materials/) - [Video Tutorials](https://www.planguru.com/learning-resources/learning-center/) - [Help Center](https://help.planguru.com/knowledge) - SUPPORT - [Help Center/ Submit a Ticket](https://help.planguru.com/knowledge) - [Downloads / Updates](https://www.planguru.com/support/downloads/) - [Try it FREE](https://www.planguru.com/products/trial/) [![logo\_PlanGuru\_190-1](https://help.planguru.com/hs-fs/hubfs/logo_PlanGuru_190-1.png?width=190&height=55&name=logo_PlanGuru_190-1.png "logo_PlanGuru_190-1")](https://www.planguru.com/) Copyright © 2025, PlanGuru