Import Matrix: GL Accounts
Technical Documentation
NOTE: Credit Card Account Types require a Vendor ID for setup. Your Credit Card Vendor company record must already be set up before 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 set up before 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 |