metafresh logo and link to homepage

Format example for importing chart of accounts data

Overview

For importing chart of accounts data, you require an import format that is configured with the database table Import Account.

The example below compares the data content of a file from a spreadsheet software (here, e.g., an Excel file prior to its conversion to a CSV or TXT file) with the import format for chart of accounts data:

Explanatory Notes to the Example

Some useful notes

The mandatory fields are essential for a successful data import!

Mandatory Field Field Name Example Note
X Element Name Accounts Import Name of the chart of accounts
X Value 10 Search key of the accounting element (is also used to structure the elements among each other).
X Name Circulating Assets Name of the accounting element
  Parent Value 1 Search key of the parent (summary) account (is also used to structure the elements among each other).
  Account Type • A = Assets
• E = Expense
• O = Owner’s Equity
• R = Revenue
• M = Memo
• L = Liabilities
Type of the account
  Account Sign • N = Natural
• C = Credit
• D = Debit
Indicates the natural sign of the account as a debit or credit.
  Summary Level • Y / true = Yes
• N / false = No
In a tree structure, summary entities represent a superior branch that combines child entries and can therefore be used for reporting.
  Post Actual • Y / true = Yes
• N / false = No
Indicates whether actual values can be posted to an element.
  Post Budget • Y / true = Yes
• N / false = No
Indicates whether budget values can be posted to an element.
  Post Statistical • Y / true = Yes
• N / false = No
Indicates whether statistical values can be posted to an element.
  Document Controlled • Y / true = Yes
• N / false = No
If an account is controlled by a document, you cannot post to it manually.

Next Steps


Zur Quelldatei auf github.com