--- title: Tips to Create a Chart of Accounts description: General ledger accounts are the building blocks for balance sheet, equity, and profit and loss statements. As the foundation for Sage 300 subsidiary ledger tracking and reporting, thoughtful planning around building a chart of accounts makes a big difference in accounting and reporting processes. image: https://www.equationtech.us/hubfs/Tips%20to%20Create%20a%20Chart%20of%20Accounts.png --- [866.436.3530](tel:+8664363530) | [** Customer Portal Login](https://na.myconnectwise.net/support/index.htm?Company=equationtech) [Speak With an Expert](https://www.equationtech.us/speak-with-an-expert) [![Equation Technologies - Sage Business Partner | San Diego](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?width=230&name=logo.png "Equation Technologies - Sage Business Partner | San Diego")](https://www.equationtech.us/) - [Sage Services](https://www.equationtech.us/sage-services) - Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300-cloud) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage Payroll](https://www.equationtech.us/sage-services/sage-payroll) - [Sage HCM](https://www.equationtech.us/sage-services/sage-hcm-software) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - Services We Offer - [Software Selection](https://www.equationtech.us/software-solution-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Cloud](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) - [Extend Sage](https://www.equationtech.us/sage-integrations) - [Magento eCommerce](https://www.equationtech.us/sage-integrations#magento) - [ADP](https://www.equationtech.us/en/sage-300-sage-intacct-payroll-powered-by-adp) - [Aloha POS](https://www.equationtech.us/sage-integrations#aloha) - [Salesforce](https://www.equationtech.us/sage-integrations#salesforce) - [TimeClockPlus](https://www.equationtech.us/timeclockplus) - [Other Solutions](https://www.equationtech.us/other-solutions) - Industries - [Distribution](https://www.equationtech.us/distribution-management-software-solution) - [Education Nonprofit](https://www.equationtech.us/education-nonprofit-accounting-software) - [Financial Services](https://www.equationtech.us/financial-services-software) - [Franchise](https://www.equationtech.us/franchise-management-software) - [Healthcare](https://www.equationtech.us/healthcare-finance-software) - [Hospitality](https://www.equationtech.us/hotel-restaurant-accounting-software-solutions) - [Metal Processors & Distributors](https://www.equationtech.us/erp-for-metal-industry-businesses) - [Nonprofit](https://www.equationtech.us/nonprofit-accounting-software) - [Professional Services](https://www.equationtech.us/professional-services-software) - [SaaS & Technology](https://www.equationtech.us/erp-software-for-technology) - [Resources](https://www.equationtech.us/sage-software-resource-library) - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Online Videos](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) - [About](https://www.equationtech.us/about-us) - [Meet The Team](https://www.equationtech.us/management-team) - [Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. # Tips to Create a Chart of Accounts ![technology blog](https://www.equationtech.us/hubfs/Tips%20to%20Create%20a%20Chart%20of%20Accounts.png) **twitter **linkedin **facebook   **How Detailed Should Your Accounts Be?** ![Accounting Records - Yellow Ring Binder on Office Desktop with Office Supplies and Modern Laptop. Accounting Records Business Concept on Blurred Background. 3D Render.](https://www.equationtech.us/hs-fs/hubfs/Stock%20images/Accounting%20Records%20-%20Yellow%20Ring%20Binder%20on%20Office%20Desktop%20with%20Office%20Supplies%20and%20Modern%20Laptop.%20Accounting%20Records%20Business%20Concept%20on%20Blurred%20Background.%203D%20Render..jpeg?width=261&name=Accounting%20Records%20-%20Yellow%20Ring%20Binder%20on%20Office%20Desktop%20with%20Office%20Supplies%20and%20Modern%20Laptop.%20Accounting%20Records%20Business%20Concept%20on%20Blurred%20Background.%203D%20Render..jpeg) The basic categories of a standard chart of accounts are assets, liabilities, equity, revenue, cost of goods sold, expenses and other income and expenses which are typically segregated by numerical grouping (for example, 1XXXX for assets, 2XXXX for liabilities, 3XXXX for equity, 4XXXX for revenue, 5XXXX for cost of goods sold, 6XXXX for expenses and 8XXXX or 9XXXX for other income or expenses, respectively). This numbering schema will support most balance sheet, equity, and profit and loss statement formats.    The challenge is determining the level of detail each category should be broken out into individual accounts. Building a lot of detail into the chart of accounts may seem like a good idea, but it can also slow your data entry down, result in coding errors and misinformation. Not building enough detail can curtail your ability to adequately and efficiently budget, analyze and report on your business’ activities. So how do you determine an appropriate balance? **What do you Want (and Need) to Know?** The level of detail by which each account category should be broken out primarily depends on the information you plan to report on. This includes requirements for audit, tax and compliance, and management reporting purposes. Every business and industry has its own specific focus, but here are some common issues you should consider around your reporting needs: ![Sage 300 Reports Reporting](https://www.equationtech.us/hs-fs/hubfs/Stock%20images/Graphs%2c%20charts%2c%20business%20table.%20The%20workplace%20of%20business%20people..jpeg?width=444&name=Graphs%2c%20charts%2c%20business%20table.%20The%20workplace%20of%20business%20people..jpeg)  **Audit** - Will the company prepare audited financial statements under GAAP, IFRS or some other accounting standard? - What financial statement level disclosures are required for your industry? - What footnote level disclosures require account level breakout? - Is the entity a corporation, partnership or sole proprietorship? - Do you require contra or allowance accounts?   Whether your financial statements are designed using Business Intelligence or Financial Reporter, having sufficient level of account detail will enable the system to pull the data directly into the reports and minimize manual adjustments. You should think not only about what will be reported in the financial statements, but also what values or additional schedules will be reported in the footnotes. Tip! If you are unfamiliar with the audit reporting requirements for your company, request a pro forma financial statement template from your auditors for your industry to give you a starting point. **Tax and Compliance** - What information will you need to breakout in detail for tax purposes, for example organization expenses, fixed asset categories, meals and entertainment, etc.? - Is the company a partnership for which partner equity transactions must be tracked for K-1 reporting? - Do you have work-in-process inventory for which you must track direct and indirect costs? - Do you have property tax reporting for which specific categories of purchases must be tracked? - Do you have sales and use tax reporting which requires locational tracking? - Do you have other domestic or foreign statutory reporting requirements? The more you can segregate reportable values in the general ledger, the less manually prepared schedules and analysis you’ll have to do for your various tax filings – saving you both time and money. Tip! Speak with your tax preparer about your tax filing and reporting requirements – most tax preparers can provide a tax questionnaire for your industry that will help you determine what general ledger information should be broken out in detail. **Management** - How will the company track its performance and activities? Are there multiple departments, divisions or locations for which segregated reporting is necessary? Use of segment codes and multiple account structures may be beneficial if so. - What information or account detail is most important to management? What account categories will routinely be analyzed in detail vs. in summary? In what level detail will budgets be created and tracked? For example, if the CFO wants to track actual vs. budgeted insurance costs by type, it would make sense to create a separate GL account for each insurance expense type. - Are there multiple entities that need to be consolidated or combined? Will the entities be tracked in separate databases or within a single database? Using a consistent chart of accounts across entity databases will make consolidation reporting easier. If multiple entities will be tracked within a single database, leverage the use of segment code and account structures to define and segregate each entity’s transactions. ![Sage 300cloud Financial Reports](https://www.equationtech.us/hs-fs/hubfs/Stock%20images/Magnifing%20glass%20and%20documents%20with%20analytics%20data%20lying%20on%20table.jpeg?width=300&name=Magnifing%20glass%20and%20documents%20with%20analytics%20data%20lying%20on%20table.jpeg) Knowing in advance the type of information that management will want to receive will help you determine which general ledger categories to break out in further detail and to what extent. Building an effective chart of accounts is an important first step to implementing any accounting system. Taking the time to think ahead about the information you want and need to produce out of your general ledger can save you a lot of time and effort in the long run.   Need help building a new chart of accounts? [Contact Equation Technologies](https://www.equationtech.us/speak-with-an-expert). Our team of consultants include many CPAs and MBAs with 10+ years of business experience. ### Related Articles ##### [Sage 300 & Windows 10 End of Life: What You Need to Know](https://www.equationtech.us/sage-accpac-blog/sage-300-windows-10-end-of-life-what-you-need-to-know) There’s been a lot of conversation lately around Windows 10 end of life and what that means for... ##### [From Start-Up to Quarter Billion – How Sage 300 Scaled Success](https://www.equationtech.us/sage-accpac-blog/from-start-up-to-quarter-billion-how-sage-300-scaled-success) We also have a [video version](https://drive.google.com/file/d/1ssdM9iHt6Wz86A-VDvAER03NdXkAodg9/view?usp=sharing) of this article, where you can hear directly from one of our ERP... ##### [How to Simplify Payroll and Job Costing with Sage 300](https://www.equationtech.us/sage-accpac-blog/how-to-simplify-payroll-and-job-costing-with-sage-300) Getting payroll to play nice with your job costing system is like fitting a square peg into a round... ## Need Help Now? [![Request a Call](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/41683/0d27fa16-1614-41b4-9caf-f9597d262c41.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/41683/0d27fa16-1614-41b4-9caf-f9597d262c41) Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage HRMS](https://www.equationtech.us/sage-services/sage-hrms) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - [Sage Financials](https://www.equationtech.us/sage-services/sage-live) Services We Offer - [Software Selection & Licensing](https://www.equationtech.us/sage-services/erp-software-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Hosting](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) Resources - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Software Video Tutorials](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) About - [Meet The Team](https://www.equationtech.us/management-team) - [Certifications & Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) - [San Diego Location](https://www.equationtech.us/sage-300-support-san-diego) - [Orange County Location](https://www.equationtech.us/sage-300-support-orange-county) - [Seattle Location](https://www.equationtech.us/sage-300-support-seattle) [![Equation Technologies - Sage 300 Authorized Partner](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo-footer.png?width=220&name=logo-footer.png "Equation Technologies - Sage 300 Authorized Partner")](https://www.equationtech.us/) **Equation Technologies** United States: 533 2nd Street Encinitas, CA 92024 Canada: #301 - 220 Brew Street Port Moody, BC V3H 0H6 Phone: 866.436.3530  •  E-mail: [info@equationtech.us](mailto:info@equationtech.us) Equation Technologies ©2016 [Contact Us](https://www.equationtech.us/contact)  | [Privacy Policy](https://www.equationtech.us/privacy-policy) ```json { "@context" : "http://schema.org", "@type" : "Article", "author" : { "@type" : "Person", "name" : "EQ Tech" }, "dateModified" : "Wed, Oct 3, 2018", "datePublished" : "Wed, Oct 3, 2018", "description" : "Sage 300 (formerly Sage Accpac) blog with informative articles in reference to financial software processes and procedures including payroll taxes, training, product information, custom development.", "headline" : "Tips to Create a Chart of Accounts", "image" : { "@type" : "ImageObject", "height" : 800, "url" : "https://www.equationtech.us/hubfs/Tips%20to%20Create%20a%20Chart%20of%20Accounts.png", "width" : 800 }, "mainEntityOfPage" : { "@id" : "https://www.equationtech.us/sage-accpac-blog/building-a-chart-of-accounts-that-will-work", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "height" : 60, "url" : "https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?t=1474998725496&width=230&name=logo.png", "width" : 600 }, "name" : "Equation Technologies Inc." } } ```