Import Matrix: GL Accounts
Technical Documentation
NOTE: Credit Card Account Type requires a Vendor ID for setup. Your Credit Card Vendor company record must already be setup prior to importing this account type into the system. Otherwise the import of the account will fail. You may want to manually enter this account type as there are other items on the account type that need to be setup prior to use. See Credit Card Overview
Available Fields
Account Name
Account Number
Account Type
Active
Bank Account Number
Cash Account Type
Description
Facility Expense Account
Labor Income
Next Check Number
No Journal Entries
Payroll Expense Account
Rollup Account
Sub Account Of
Vendor ID
Matrix
|
Field Name |
Key Field |
Required |
Valid Values |
Table Validation |
Table |
Field Validation |
Comments |
|
Account Type (Accrual) |
|
|
Bank Accounts Receivable Current Asset Fixed Asset Other Asset Accounts Payable Current Liability Long Term Liability Equity – Does Not Close Equity – Close Retained Earnings Income Other Income Cost of Goods Sold Expense Other Expense Credit Card
|
|
|
|
Most of the time, the 2 account types will be the same. Use a different account type if you want to specify an Advance Bill Account as a liability for accrual accounting and a sales type for cash basis accounting. If you choose to do this, the parent account will be ignored in the reports when the cash basis option is selected.
NOTE: For Credit Card, a Vendor ID is required. The Vendor record must already be valid in Workamajig prior to the import. |
|
Account Type (Cash) |
|
|
Bank Accounts Receivable Current Asset Fixed Asset Other Asset Accounts Payable Current Liability Long Term Liability Equity – Does Not Close Equity – Close Retained Earnings Income Other Income Cost of Goods Sold Expense Other Expense Credit Card
|
|
|
|
Most of the time, the 2 account types will be the same. Use a different account type if you want to specify an Advance Bill Account as a liability for accrual accounting and a sales type for cash basis accounting. If you choose to do this, the parent account will be ignored in the reports when the cash basis option is selected.
NOTE: For Credit Card, a Vendor ID is required. The Vendor record must already be valid in Workamajig prior to the import. |
|
Account Number |
Yes |
Yes |
|
|
|
|
|
|
Account Name |
|
Yes |
|
|
|
|
|
|
Rollup Account |
|
|
Yes N0/Blank |
|
|
|
Must be set to YES if it is a rollup account |
|
Sub Account Of |
|
|
Must be a valid GL Account Number |
Yes |
GL Accounts |
Account Number |
Rollup account must be set to YES or import will fail |
|
Description |
|
|
|
|
|
|
|
|
Bank Account # |
|
|
|
|
|
|
|
|
Active |
|
|
Yes No |
|
|
|
|