Common expense exporting errors

This article is a guide to common error messages that may be displayed when exporting Expenses to QuickBooks or Xero, and how to manage them.

In some instances the exporting of expenses from Projectworks to an accounting system will fail. If one or more expenses fail to export, an error message will be displayed in the right hand panel. In many instances these errors can be remedied by making a simple change to the mapping within Projectworks or the accounting system.

Common expense export error messages

In most cases, a Projectworks administrator can manage the accounting system integrations and edit the mappings to enable the expense export. In some instances a change may also be required in the accounting system that the expenses are being exported to. See error messages and steps to rectify below:

 

Please see: Exported - may need attention

1. Open the Projectworks expense

2. Select an alternate Sales Tax option from the dropdown

3. “Save” the expense

4. Re-export the expense

If the only Sales Tax option in the dropdown is “No sales tax” and this is not acceptable, a new Tax Rate will be required to be set up in Projectworks

1. Go to Settings > System > Tax Types

2. Select the Add Tax Type “+” icon in the top right

3. Enter the New Tax Types' Name, Jurisdiction, Currency and Tax Rate

4. Select (or remove) the organisation(s) that the tax rate can be applied to

5. Select “Create Tax Type”

6. Update accounting system Tax Types mappings

   1. Go to: Settings > Integration > Accounting (Read more about editing QuickBook organisation mappings →)

If a sales tax type is not available in the mappings, this may be because it doesn’t exists in the accounting system, and will need to be set up accordingly.

The currency the user is paid in doesn't match the currency that QuickBooks is expecting for the expense (based on the expense's GL code and its associated Quickbooks Product or Service currency)

1. Check the the Expense Type in the Projectworks expense maps to a QuickBooks Product or Service that is associated to a QuickBooks account that operates in the same currency as the user is paid in.

   1. The Expense Type can be viewed:

      1. on any of the Projectworks expense screens if the “Expense Type” column is selected; or

      2. in the Projectworks expense; 

2. If the Expense Type is incorrect, update the Expense Type and re-export the expense claim from Projectworks;

3. If the Expense Type does not exist in Projectworks, create a new Expense Claim Type (go to Settings > System > Settings > Expense Claim Types);

   1. A new GL code may also need to be created to associate to the Expense Claim Type (go to Settings > System > Settings > GL Codes);

   2. Update the mappings in Projectworks (go to: Settings > Integration > Accounting > Expenses)

 

• Update the the expense integration's tax types mapping in Settings > Integration > Accounting > Expenses

 

The currency that the user is paid in does not match the currency that they are set up for as a QuickBooks vendor/ supplier. 

1. Go to the Person > Postings > Edit Posting to identify what currency the user who raised the expense is being paid in

   1. If the currency is incorrect in Projectworks, update the currency the User is paid in (or create a “New Posting” if their posting has changed)

2. Remove the “Contact Reference” ID for the Person in Projectworks. Go to: Person > Settings > *Accounting System & Other Services

   

3. Check the currency for the vendor or supplier in QuickBooks.

   1. If the currency is not correct and the “open balance” = 0.00:

      1. Inactivate the existing vendor/ supplier;

   2. If the currency is not correct and the “open balance” is not 0.00:

      1. Reimburse the vendor or supplier in QuickBooks;

      2. Inactivate the existing vendor/ supplier;

4. Re-export the expenses for this user.

The QuickBooks product mapped to the Projectworks Expense GL Code is an inventory product that has a start date later than the expense purchase date

• If you are exporting an expense that you track quantities of, ensure that the “As of date” for the QuickBooks Product mapped to the expense GL code is before the purchase date of the expense claim

• If you are exporting an expense that you don’t need to track quantities of, the QuickBooks Product mapped to the expense GL code should be a Non-inventory Product or Service

To update expense GL code mappings go to: Settings > Integration > Accounting > Expenses > Edit Mappings

 

A unique identifier linking the Projectworks user to the accounting system contact no longer exists in the accounting system. This can happen if you have re-mapped to an alternate version of the accounting system.

1. Remove the “Contact Reference” ID for the Person in Projectworks. Go to: Person > Settings > *Accounting System & Other Services

   
2. Re-export the expense that failed

1. If the purchase date is in the future, wait for the “purchase date” to occur and re-export the expense.

Please note: If you have raised an expense for today in a country that is ahead of the Xero or QuickBooks country version, the expense will not be able to be exported until the following day when the exchange rate is available.

The amount in the expense exported from Projectworks differs from the total amount calculated in the accounting system expense.

This is a notification that the amounts exported differ from the amounts calculated in Projectworks, due to an alternate tax rate being applied and/ or rounding differences. No action may be required, but we recommend that the QuickBooks expense is reviewed to ensure the correct amount is being reimbursed.

1. Search for the vendor or supplier’s email address in QuickBooks.

2. Inactivate the duplicate vendor/ supplier;

3. Re-export the expenses for this user.

 

The currency the expense claim has been raised in, or the currency the person who has raised the claim is paid in, does not exist in Xero.

Go to: Settings > Integration > Accounting > Invoicing to create the currency

Read more about mapping currencies in Xero →

To update expense GL code mappings go to: Settings > Integration > Accounting > Expenses > Edit Mappings

 

1. Go to: Settings > Integration > Accounting

2. Re-connect to the accounting system

3. Re-enable expenses

4. Re-export expense

Read more about integrating to an accounting system →

 

1. Remove the “Contact Reference” ID for the Person in Projectworks. Go to: Person > Settings > *Accounting System & Other Services

    

2. Re-export the expense for this user.

Please note: if the Projectworks organisation the user has moved to is not connected to an accounting system, the expense will not be able to be exported.

To connect to an accounting system organisation, go to: Settings > Integration > Accounting

 

The exchange rate for the currency that the person who raised the expense gets paid is not available in Projectworks for the purchase date of the expense.

1. If the purchase date is in the future, wait for the “purchase date” to occur and re-export the expense.

2. If the purchase date is today or in the past, please contact support@projectworks.io
   
   

One or more receipts could not be attached to the exported expense claim. This might be due to special characters in the attachment file name.

1. Review the expense claim in the accounting system and manually upload any missing receipts.

 

The expense mappings have not been fully enabled to allow expenses to be exported for the user’s Projectworks organisation.

1. Go to: Settings > Integration > Accounting > Expenses

2. Ensure expenses for the accounting system organisation has been enabled, and all cost tax types and GL codes have been mapped.

 

To identify the person’s organisation:

1. If you are exporting expenses from the expenses screen:

   1. Go to the All Expenses tab

   2. Select group by User Organisation filter

2. Or if you are exporting expenses from the person or project screen:

   1. Go to the Person > Postings of the user who raised the expense to view the organisation they are associated to for their current Posting

       

Please note - if the organisation is incorrect, you can amend it in the current posting or create a new posting for the person if their employment circumstances have changed.

If the person is posted to the correct Projectworks organisation:

1. Go to Settings > Integration > Accounting

2. Go to “Map Organisation” and click on the three horizontal dots to “Edit Mappings”

3. Select the accounting system organisation from the dropdown for the Projectworks organisation you are mapping to

4. Select “Update Mappings”
5. Re-export the expenses that failed for this reason
   
   

The Xero tax rate mapped to the tax rate in Projectworks must be the same type (sales or purchase tax rate) as the default tax setting for the Xero account mapped to the invoice line in the invoice.

1. Check the default tax setting for the Xero account;

2. Update the Tax Types and Cost GL Codes mappings in Projectworks as required (go to: Settings > Integration > Accounting > Expenses)

3. Update the expense if required;

4. Re-export the expense.

The user is paid for in a currency that your version of QuickBooks does not support. To enable a vendor or supplier to be created and the user’s expenses to be exported, turn-on multicurrency in QuickBooks. 

 

The vendor or supplier name must be unique to any other name in QuickBooks. When creating a vendor or supplier name, Projectworks adds “(vendor)” or “(supplier)” to the user’s name (dependent on the version of QuickBooks you are using).

1. If the existing vendor or supplier is no longer required, and the “open balance” = 0.00:

   1. inactivate the existing vendor/ supplier;

   2. re-export the expense.

2. If the existing vendor or supplier is still required:

   1. update the vendor/ supplier display name e.g. “Joe Bloggs (vendor)” to “Joe Bloggs (vendor_1)”;

   2. re-export the expense.

---

 If you cannot resolve your issue, contact support@projectworks.io.