# Sage Intacct Dimension Design Worksheet > Source: https://netray.co/tools/sage-intacct-dimension-design-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable worksheet for designing Intacct dimensions: which standard and custom dimensions to use, value counts, requirements and examples. ## Category cost-finance ## Erp Sage Intacct ## Audience - Controller - Financial analyst - Intacct consultant ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Dimension **Key:** dimension **Type:** text #### Kind **Key:** kind **Type:** select **Options:** - Standard - User-defined - Not used #### Reporting question it answers **Key:** purpose **Type:** text #### Approx. number of values **Key:** values **Type:** number #### Tagged on GL entries **Key:** on_gl **Type:** select **Options:** - Yes - No #### Required on entry **Key:** required **Type:** select **Options:** - Always - Some accounts - Optional #### Value owner **Key:** owner **Type:** text #### Example value **Key:** example **Type:** text **Rows:** **Dimension:** Location **Kind:** Standard **Purpose:** Which plant or legal entity **Values:** 4 **On gl:** Yes **Required:** Always **Owner:** Controller **Example:** 100 - Ohio Plant **Dimension:** Department **Kind:** Standard **Purpose:** Which cost center owns the spend **Values:** 18 **On gl:** Yes **Required:** Always **Owner:** FP&A **Example:** 410 - Machining **Dimension:** Project **Kind:** Standard **Purpose:** Which job or contract **Values:** 120 **On gl:** Yes **Required:** Some accounts **Owner:** Project accounting **Example:** J-2026-044 **Dimension:** Customer **Kind:** Standard **Purpose:** Which customer **Values:** 310 **On gl:** Yes **Required:** Some accounts **Owner:** Sales ops **Example:** C-1021 **Dimension:** Product line **Kind:** User-defined **Purpose:** Margin by product family **Values:** 9 **On gl:** Yes **Required:** Optional **Owner:** Product management **Example:** Hydraulic fittings **Totals:** #### Total dimension values **Key:** values **Agg:** sum **Format:** integer #### Largest dimension **Key:** values **Agg:** max **Format:** integer **Summary:** #### Dimensions listed **Key:** dims **Expr:** count **Format:** integer **Primary:** true #### Average values per dimension **Key:** avg_vals **Expr:** avg_values **Format:** decimal **Notes:** Sage Intacct uses dimensions such as location, department, project, customer, vendor, employee, item and class to tag transactions, plus user-defined dimensions. Confirm availability of dimensions and limits for your subscription with your Sage representative. Each dimension you require on entry adds data entry effort, so keep the list short. ## Content **Intro:** Sage Intacct replaces a long segmented chart of accounts with dimensions that tag every transaction, so design decisions made early shape every report. This worksheet helps finance teams list candidate dimensions, what each one answers, who owns the values and whether it is required on entry. **Sections:** #### How to use the worksheet **Body:** Start with the questions leadership asks of the numbers, such as profit by plant, spend by department or margin by product line. For each question, add a row and decide whether a standard dimension answers it or a user-defined dimension is needed. Estimate how many values will exist and name an owner who approves new values. The totals and averages show whether your design is balanced or has one dimension that will be hard to maintain. #### Design principles **Body:** Keep the general ledger accounts about the nature of the transaction, such as materials or freight, and let dimensions carry the where, who and what. Do not recreate old account segments as dimensions by default. Use required fields only where reports truly depend on them, and rely on defaults and allocation rules to reduce keying. Plan how dimension values relate to each other, for example which departments belong to which location. **Bullets:** - Accounts say what, dimensions say where and for whom - Few required dimensions, more optional ones - One named owner per dimension - Agree a naming standard for value IDs #### Mistakes to avoid **Body:** Common problems include creating a dimension for every request, letting anyone add values, making too many fields mandatory so users enter placeholders, and mixing hierarchy levels in one list. Another is not testing reports on realistic data before go-live. Review the design with the accountants who will do the close and with the managers who read the reports. **Cta:** If you are mapping a legacy chart of accounts to dimensions, we can help build the mapping and validate balances after conversion. **Faq:** #### What are dimensions in Sage Intacct? **Answer:** They are tags on transactions that let you slice financial and operational data, such as by location, department, project, customer, vendor, employee, item or class. You can also create user-defined dimensions for concepts specific to your business. #### How many dimensions should I use? **Answer:** As few as answer your real reporting questions. Many manufacturers start with location, department, project or job, and one or two custom ones such as product line. Add more only when a report needs it. #### Should dimensions be required on every entry? **Answer:** Only where reporting depends on them. Requiring a dimension on every account leads to meaningless values. Use account-level rules or defaults so the system asks only when the answer matters. #### Can I change dimensions after go-live? **Answer:** You can add values and often add new dimensions, but restructuring history is harder. Getting the core design right before conversion avoids reclassification projects later. ## Search terms sage intacct dimensions, sage intacct dimension design, sage intacct chart of accounts dimensions, intacct location department class project, intacct user defined dimension, intacct reporting dimensions template, sage intacct implementation worksheet, intacct dimension strategy --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json