Articles in this section

GL accounts template

The following table lists the fields in the GLA general ledger (GL) is used for recording transactions related to business assets, liabilities, equity, revenue and expenses. accounts template. All values input to the template are case sensitive. The maximum file size allowed is 20 MB.

Field Display Name isMandatory? Description Field data type Level Value Display Names
Category No

The category of the GL account (not case sensitive).

Only accounts set as "Expense" (and active AP accounts set as "Other") are available on all bill records/ filters

 List Header Other, Expense
Currency No The currency of the GL account String Header  
Description No A description of the GL account String Header  
Entity name No

List of payer entities for which each GL account should apply.

A GL account can be associated with more than one entity, entity names should be separated by ";"

To apply the GL account to all payer entities, use '[]'

 String Header  
External ID Yes An ID that uniquely identifies the GL account in the accounting system/ ERP String Header  
MiscBox1099 No

The number of the corresponding box on the 1099-MISC form.

If the field is left empty (NULL), the account will be considered "unmapped"

 List Header
  • nec1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 12
  • 13
  • 14
  • 15A
  • 15B
  • 16
  • 17
  • 18
  • 1
  • Non applicable
  • 11
  • nec2
Name Yes The name of the GL account String Header  
Number No The number of the GL account String Header  
Sync type No Whether to update or close the GL account. GL accounts that are currently active (i.e., assigned to outstanding unpaid bills) cannot be closed List Header Close, Create / Update
Type No The type of GL account List Header

  • Long Term Liability

  • Other assets

  • Fixed assets

  • Other current assets

  • Accounts receivable A_R

  • Expenses

  • Income statement account

  • Balance sheet account

  • Receivable account

  • Unbilled Receivable

  • Deferred Expense

  • Deferred

  • Revenue

  • Other Expense

  • Other Income

  • Cost of Goods Sold

  • Income

  • Equity

  • Expense

  • Accounts payable

  • Bank

  • Credit card

  • Accounts Receivable

  • Other Current Asset

  • Fixed Asset

  • Other Asset

  • Other Current Liability

  • Other current liabilities

  • Long term liabilities

  • Liability

  • Liabilities

  • Asset

  • Assets

  • Revenue

  • Other