Formal/Informal Label Equivalence and Importing CSV

From GnuCash
Revision as of 04:11, 2 April 2021 by DaveC49 (talk | contribs) (Created page with " The use of the formal accounting or the informal labels in the GNuCash registers can some times lead to some confusion for some users when importing data when combined with t...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The use of the formal accounting or the informal labels in the GNuCash registers can some times lead to some confusion for some users when importing data when combined with the use in statements supplied by a bank which will generally be reversed from the usage within GnuCash for a user's accounts. The following table is intended to give new users of the CSV importer some assistance when trying to match the importer's column headers to match the data labels in the imported data and sign conventions where debit/credit amounts are represented by signed integers. This description is of common usage by organisations like banks however there is no guarantee that their exported data will necessarily conform.

Table of equivalence between informal and formal accounting register labels in GnuCash and label usage in imported records
GnuCash Internal Labels External (Bank Record) Labels
Account Type Formal Informal Balance Effect Formal Informal Sign
Asset Debit(Dr) Deposit Increase Credit Deposit +