FAQ: Troubleshooting company card import via spreadsheet

Options
Christina Dobryzynski
Christina Dobryzynski Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 267 Expensify Team
edited November 2021 in Integrations and API

I'm not immediately seeing my CSV uploaded transactions after following the instructions on this page. Why is that?

The most common mistake in this scenario is that you need to wait 1-2 minutes for the CSV transactions to upload. This isn't an instantaneous process, so please ensure you wait 1-2 minutes after you've clicked [I understand, I'll wait!].

image.png

I’m getting a red alert when trying to upload a spreadsheet. What does this mean?

If you are seeing an attribute-value mapping is missing’ error, that likely means your spreadsheet is missing critical information. 

Your spreadsheet must have the following details before it will successfully upload: Account, Merchant, Date, Amount, and Currency. 

If any of these attributes are missing, you will see an error. 

image.png
  1. To resolve this error, click the ‘X’ button at the top of the page to close the mapping window. 
  2. Add a new column to your spreadsheet and add the missing detail.
  3. Upload the revised spreadsheet by clicking the Manage Spreadsheet button.
  4. Create a Layout Name for the contents of your spreadsheet.
  5. Click Upload CSV.
  6. Review the mapping for any additional errors. If none are present click Submit Spreadsheet and follow the steps in this support article.

I’m getting “We’ve detected an error while processing your spreadsheet feed.” 

This error usually occurs when there’s an upload issue. To troubleshoot this, 

  1. Click the Manage Spreadsheet button on the Domain > Company Cards page. 
  2. Click the Saved Layouts dropdown list.
  3. Look for the Layout Name you created.
  4. If it doesn't exist, create a new Layout Name and upload the spreadsheet again by following the steps in this support article.
image.png

I’m getting “An unexpected error occurred and we were not able to retrieve the list of cards…”

This error occurs when there’s an upload issue. To troubleshoot this, 

  1. Click the Manage Spreadsheet button on the Domain > Company Cards page. 
  2. Click the Saved Layouts dropdown list.
  3. Look for the Layout Name you created.
  4. If it doesn't exist, create a new Layout Name and upload the spreadsheet again following the steps in this support article.

 

image.png


I added a new card(s) to an existing spreadsheet and imported it through a Saved Layout but the new card isn’t available for assignment. 

It’s important to use a Saved Layout to upload a new CSV that is in the same format as the initial one.

Check the revised spreadsheet to make sure the layout is the same as the original spreadsheet.  

If you’re sure the layout is the same, the first step in troubleshooting this is to compare the number of rows on the revised spreadsheet to the Output Preview and make sure the row count matches the revised spreadsheet. 

To check this, 

  1. Click the Manage Spreadsheet button on the Domain > Company Cards page. 
  2. Find the Saved Layout in the drop-down list.
  3. Click Upload CSV and upload the revised spreadsheet.
  4. Compare the Output Preview row count to your revised spreadsheet to make sure they match.
  5. If not, Save the revised spreadsheet with a new name.
  6. Try again to upload the revised spreadsheet by clicking > Upload CSV > upload the file from your computer > checking the row count on the Output Preview match the spreadsheet > click Submit Spreadsheet. 
image.png
image.png

I added a new expense(s) to an existing spreadsheet and imported it through a Saved Layout but the new expenses are not uploading to an assigned card.  

It’s important to use a Saved Layout to upload a new CSV that is in the same format as the initial one.

Check the revised spreadsheet to make sure the layout is the same as the original spreadsheet.  

If you’re sure the layout is the same, the first step in troubleshooting this is to compare the number of rows on the revised spreadsheet to the Output Preview and make sure the row count matches the revised spreadsheet. 

To check this, 

  1. Click the Manage Spreadsheet button on the Domain > Company Cards page. 
  2. Find the Saved Layout in the drop-down list.
  3. Click Upload CSV and upload the revised spreadsheet.
  4. Compare the Output Preview row count to your revised spreadsheet to make sure they match.
  5. If not, try again to upload the revised spreadsheet by clicking > Upload CSV > upload the file from your computer > confirm the row count on the match the spreadsheet > click Submit Spreadsheet. 
  6. If the row count does match the revised spreadsheet, try to pull in those new transactions by clicking Actions to the right of the cardholders card > click Update to try and manually pull in those new transactions. 
User: "image.png"
image.png
image.png


I'm trying to import a negative expense, why isn't it uploading?

Make sure the negative expense is formatted as a number and not an amount/currency. I.e. the number needs to be wrapped in parentheses, example bellow. This should allow you to upload the negative expense.

image.png


If you’re still running into an issue, please reach out to us at concierge@expensify.com so we can help you.


RELATED ARTICLES


Tagged:
Flag · Accept Answer Off Topic Insightful Vote Up Awesome

Categories