--- title: No Accounts showing up in Map Accounts screen description: When using the import from Excel Utility the "Use account numbers" checkbox will enforce that you've assigned a column as account numbers on your import file, in order for accounts to be displayed. In --- [Skip to content](https://help.planguru.com/knowledge/no-accounts-showing-up-in-map-accounts-screen#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) # No Accounts showing up in Map Accounts screen When using the import from Excel Utility the "Use account numbers" checkbox will enforce that you've assigned a column as account numbers on your import file, in order for accounts to be displayed. In addition if you check to "Use account numbers" any rows in your import sheet without an account number will get filtered out. In the following example, I've checked the "Use account numbers" checkbox on the Import Option sheet. ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360005804931image.png)   Next I assign the columns on my import sheet, but fail to identify a column as containing account numbers. ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360005764932image.png)   When I advance to the Assign Accounts screen none of the rows show up from the import file. ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360005805011image.png)   The reason no accounts are showing is because the "Use account numbers" was checked, however no column on the import screen was designated as including account numbers.  If you have checked the use account numbers checkbox you must designate a column as containing account numbers, and all rows must have a value in that column.       - [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