E-Balance Projects

Projects contain a collection of GAAP (Generally Accepted Accounting Principles) data for a defined company and date range. This topic describes how to create E-Balance Projects.

How to Create an E-Balance Project

  1. Choose the Lightbulb that opens the Tell Me feature icon, enter E-Balance Projects, and then choose the related link.
  2. Choose the New action.
  3. On the E-Balance Project page, fill in the fields on the General FastTab as necessary.
  4. Choose the Create GAAP action to open a request page.

  5. Set the filters to define which G/L Entries to include when creating the GAAP lines as follows:

    • GAAP Account No. Filter - Filter the G/L Accounts to be included when creating GAAP lines; defaults from E-Balance Setup.
    • Split VAT Account No. - Filter the G/L Accounts for which to perform VAT splitting when creating GAAP lines; defaults from E-Balance Setup.
    • Global Dimension 1 Filter - Filter for values of the global dimension 1 (NOTE: The name of the filter field varies in accordance with the defined global dimension 1.)
    • Only Filter Income Statements (Code 1) - If this switch is activated, the Global Dimension 1 Filter is only applied for Income Statement G/L Accounts (where the Income/Balance field of the G/L Account has the value Income Statement)
    • Global Dimension 2 Filter - Filter for values of the global dimension 2 (NOTE: The name of the filter field varies in accordance with the defined global dimension 2.)
    • Only Filter Income Statements (Code 2) - If this switch is activated, the Global Dimension 2 Filter is only applied for Income Statement G/L Accounts (where the Income/Balance field of the G/L Account has the value Income Statement)

  6. Choose the OK button to create a new project line containing the GAAP data.

  7. Select the line on the project card and choose the Open GAAP action in the lines section to view the GAAP data of a project line.
  8. You can create GAAP data multiple times per project, resulting in multiple project lines, but only one project line may be active.
    • The active line is marked with a check mark in the Active field.
    • To change the active line, select the desired line on the E-Balance Project card and choose the Set Active action in the lines section.
    • Only the active line will be included when exporting a project from Dynamics 365 Business Central.
  9. You can run a plausibility check for the GAAP data by selecting the project line to check on the project card and choosing the Check Plausibility action in the lines section.
    • The plausibility check will display a warning if
      • there are missing suffixes
      • there is a difference between the dimension-filtered and the filter free balance amount for an G/L account for the given project period
      • the balance amount of an account is not 0 at the start of the project period
      • there are not yet closed accounting periods within the project period
      • the opening balance of an account is not 0
    • the results of the plausibility check will be logged and can be viewed by selecting the project line and choosing the Open Protocol action in the lines section.
  10. To release an E-Balance project, choose the Release action on the E-Balance project card or list.
    • released projects cannot be modified unless they are reopened by choosing the Reopen button on the E-Balance project card or list
    • projects need to be released to be able to export them from Dynamics 365 Business Central.

Feedback

Submit feedback for this page .