This mapping allows us to map a project in OpenAir to a project in Quickbooks.
As a OpenAir administrator:
- Navigate to Application Settings -> Projects
- If the external ID field is not visible, make it visible using the column setting menu on the right hand side of the table.
- Ensure that the Account Name for each project is set in the External ID field. This will allow the correct project name to be pulled across as part of the expenses import.
**The External ID needs to match the Project in Quickbooks exactly.**account numbers as follows:
The list page for the projects should show up the
This mapping allows us to map an expense item category to both a chargeable and a non-chargeable project code in Quickbooks.
As a OpenAir administrator:
- Navigate to Application Settings -> Expenses settings
- If the external ID field is not visible, make it visible using the column setting menu on the right hand side of the table.
- In the external field ensure the correct quickbooks account numbers are used in teh following format:
COGS=5011, Chargeable=6129
N.B. The comma is important here
The codes for the specific category mapping should match exactly the codes in Quickbooks.
The list screen should look like this:
