Import Matrix: Credit Card Charges
Technical Documentation
Prior to going the route of importing credit card charges in this manner, we suggest you first try using the Credit Card Features that Workamajig offers for this process, or try downloading an OFX or similar file from your banks website and import that file in the Connector Screen.
NOTES:
- When importing Credit Card Charges where you want a single charge split into multiple lines of detail, you need to use the Reference Number to group them together as one charge.
- Just prior to importing, if you want to see the details of each charge, please click on the number in Details columns.
Available Fields
Approved
Approved By
Billable
Charge Date
Class ID
Client ID
Credit Card Account
Department
Description
Exchange Rate
Exchange Rate (Line)
Exclude from 1099
Expense Account
GL Company
Gross Cost
Item ID
Markup
Net Cost
Office
Opening Transaction
Overhead Charge
Posting Date
Project Number
Purchased By
Purchased From
Quantity
Reference Number
Sales Tax Amount
Sales Tax Amount 2
Sales Tax Rate
Sales Tax Rate 2
Task ID
Taxable
Taxable 2
Unit Cost
Unit Description
Unit Rate
Matrix
|
Field Name |
Key Field |
Required |
Valid Values |
Table Validation |
Table |
Field Validation |
Comments |
|
Overhead Charge |
|
|
Yes No |
|
|
|
|
|
Billable |
|
|
Yes No |
|
|
|
|
|
Charge Date |
|
Yes |
Must be a valid date |
|
|
|
|
|
Class ID |
|
Yes – See Comments |
|
Yes |
GL Classes |
Class ID |
If “Class ID” Required is Yes in GL Tracking Options file then a Valid Class ID is required |
|
Client ID |
|
Yes - See Comments |
|
|
|
|
If “Billable” is Yes then Valid Client ID is required |
|
Credit Card Account |
|
Yes |
|
|
|
|
|
|
Department |
|
Yes – See Comments |
|
Yes |
Departments |
Department Name |
If “Departments Required” is Yes in GL Tracking Options file then a Valid Department Name is required |
|
Description |
|
|
|
|
|
|
|
|
Expense Account |
|
Yes |
|
Yes |
GL Accounts |
GL Account Number |
|
|
Gross Cost |
|
|
Numeric |
|
|
|
|
|
Item ID |
|
Yes |
|
Yes |
Items |
Item ID |
|
|
Markup |
|
|
Numeric |
|
|
|
|
|
Net Cost |
|
|
Numeric |
|
|
|
|
|
Office |
|
Yes – See Comments |
|
Yes |
Offices |
Office Name |
If “Offices Required” is Yes in GL Tracking Options file then a Valid Office Name is required |
|
Opening Transaction |
|
|
Yes No |
|
|
|
|
|
Approved By |
|
|
|
Yes |
Employee |
Full Name (First Name+” “+Last Name) |
|
|
Project Number |
|
|
|
Yes |
Project |
Project Number |
|
|
Purchased By |
|
Yes |
|
Yes |
Employee |
Full Name (First Name+” “+Last Name) |
|
|
Purchased From |
|
Yes |
|
Yes |
Vendors |
Vendor ID |
|
|
Quantity |
|
|
Numeric |
|
|
|
|
|
Reference Number |
|
|
|
|
|
|
|
|
Sales Tax Amount |
|
|
Numeric |
|
|
|
|
|
Sales Tax Amount 2 |
|
|
Numeric |
|
|
|
|
|
Sales Tax Rate |
|
|
See Comments |
Yes |
Sales Tax Rates |
Sales Tax ID |
If this field is not blank, then a valid Sales Tax ID must exist in the Sales Tax Rates table |
|
Sales Tax Rate 2 |
|
|
See Comments |
Yes |
Sales Tax Rates |
Sales Tax ID |
If this field is not blank, then a valid Sales Tax ID must exist in the Sales Tax Rates table |
|
Task ID |
|
|
See Comments |
Yes |
Project Schedule |
Task ID |
If this field is not blank, then a valid Task ID must exist in the Project Number |
|
Taxable |
|
|
Yes No |
|
|
|
|
|
Taxable 2 |
|
|
Yes No |
|
|
|
|
|
Unit Cost |
|
|
Numeric |
|
|
|
|
|
Unit Description |
|
|
|
|
|
|
|
|
Unit Rate |
|
|
Numeric |
|
|
|
|