Expensify.org is accepting proposals for new campaigns. Submit yours here by April 30th to receive up to $100,000 in funding for campaigns dismantling injustice related to: Climate, Homes, Hunger, Reentry, or Youth.
American Express Connection
grant_at_ccag
Expensify Customer Posts: 1
Hello: We have a corporate AMEX Open Small Business account program that I'm trying to link to Expensify, but haven't seen success in making this work for us. Any thoughts out there? We have both Gold and Plum cards but want to link the Gold cards only.
Comments
I am having the same issue.
- Spam
- Abuse
- Report
1 · Accept Answer Off Topic Insightful 1Vote Up AwesomeOur engineering team is looking into this as a known issue with American Express. With that said, if your company is eligible, a Commercial Feed could be a reliable workaround.
If you have a corporate or commercial card account, or are eligible for an Amex @ Work card program, then you may be able to access a daily transaction feed where expenses are sent to Expensify by your bank or American Express, which is a connection that is less prone to these types of connectivity issues. Contact your relationship manager at the bank to see if this is something you'd qualify for.
If not, you're not out of luck. You can still import your card transactions via CSV spreadsheet import. Please find complete instructions here.
We'll also be in touch once we updated the Amex connection, which is coming very soon!
- Spam
- Abuse
- Report
1 · Accept Answer Off Topic Insightful 1Vote Up AwesomeCan you please provide an update to the status of the resolution? This is a significant impairment on our use of Expensify as we only use this for documenting and recording company credit card transactions.
- Spam
- Abuse
- Report
4 · Accept Answer Off Topic Insightful 4Vote Up Awesome@corywbrown I don't have an ETA on a fix for the American Express US Business connection. I would suggest importing those transactions with our CSV import in the meantime.
Please find complete instructions here.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeThe challenge is knowing start dates to use for the csv transations without going through each transaction individually. Based on the last date the accounts synced before the connection issue, there could have pending transactions which did not import, yet when posted they still have always imported with the original transaction date. Additionally when the connection is restored, will this not then duplicate the transactions?
- Spam
- Abuse
- Report
5 · Accept Answer Off Topic Insightful 5Vote Up AwesomeHad this same problem a few months back and uploaded the outstanding items thru the CSV import, but when the Card Connection was restored, there were tons of duplicate entries. Can you let us know exactly when this issue will be fixed? This is a known problem and repeating issue that we have encounter almost every month.
- Spam
- Abuse
- Report
6 · Accept Answer Off Topic Insightful 6Vote Up Awesome@Jeff_T Unfortunately, we aren't able to tell you exactly when this connection will be fixed. While we are working on building a brand new connection because of these issues, there are a lot of moving parts so we don't even have an estimate yet. This is a major bank and we are working to get this connection up and running as soon as possible.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeIt looks like this is still an unresolved incident today... Is there an update you can provide? I have clients that are worried they won't be able to reconcile in their accounting software because of missing transactions - they at least want an update or to know that someone is actually working on it.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeHi @Mikail_Expensify! I'm still unable to provide an ETA on this and it can often take quite some time to make these changes, so it very likely won't be in the next few days. I would highly recommend taking one of the alternate routes mentioned to make sure that your clients' transactions are all accounted for.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWas wondering if we have any update as to when this will be resolved. My billing cycle has ended for my 200 employee cards and they are showing zero expenses from 4/28-5/29.
- Spam
- Abuse
- Report
1 · Accept Answer Off Topic Insightful 1Vote Up AwesomeHey @Jessicamarquis_1608
Apologies for the delay here but I don't have an exact ETA on when this will be resolved. We are actively working on this though, and hope to get it sorted soon.
In the meantime, I would recommend either contacting your Banking Relationship manager to see if you qualify for a Commercial Card feed or uploading transactions via CSV import.
Please find complete instructions for how to do this here.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWill you post on this thread - when it is back up and working
@Zany Renney
- Spam
- Abuse
- Report
1 · Accept Answer Off Topic Insightful 1Vote Up AwesomeHey @Jessicamarquis_1608 !
Yes, we will do our best to update any Community posts as well as send out messaging to previous Amex Business users to inform them of the new connection when it is live.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeWill you be providing credits to the users with AMEX small business? this is creating a lot of manual adjustments costing time for each of our employees. Also, the CSV date format requirement is challenging.
- Spam
- Abuse
- Report
5 · Accept Answer Off Topic Insightful 4Vote Up 1AwesomeHi @Rollin - We're hoping to have this Amex issue resolved soon. Additionally, if you're having trouble uploading a CSV at the domain-level, please reach out to us at [email protected] and we can assist with this!
That said, we likely will not be issuing credits at this time. I appreciate you checking in about that.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeI reached out to concierge about the csv upload and went back and forth for HOURS sharing my mapping and spreadsheet and they couldn't help. No clue what they were doing. I even used their template and it didn't work because i don't think they have any idea what goes in the "Card Number" field to map to the user account.
- Spam
- Abuse
- Report
1 · Accept Answer Off Topic Insightful 1Vote Up AwesomeHi @kdavis — sorry for the continued hassle here! If you're attempting to import a spreadsheet of Amex expenses, Amex usually only lists 15 characters for the card number. However, in order to upload it in Expensify it has to have 16 characters. I recommend adding an X to the middle of the card numbers to help upload those successfully.
If you have any other questions or need anything else, please let me know!
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesomewe tried that....I was told to use an X to fill in all the numbers except the final 5 identifying numbers to make a total of 16 characters. Didn't work.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome@kdavis We were able to discover a strange workaround that fixes the issue of being unable to assign cards. I went ahead and did it on your account and you should now be able to assign your cards. I can now see them in the dropdown. Let me know if you have any questions!
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeI need to assign a card to a new user and unable to connect in the domain. Will an import help with that? Also, how will can mitigate duplicate transactions when the feed is restored?
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome@JMH Solid question! So, the CSV import is viewed as an entirely different card set than your currently assigned cards. That said, there isn't a way to have the CSV import feed data into your assigned cards, rather, you would need to upload the CSV, and then assign cards from the CSV to your cardholders. We recognize that might be a bit cumbersome, but it's the best solution we have while we work toward an improved connection with American Express.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome@John Schuster Following up with JMH's question: How will duplication be mitigated? When the new API is functional, will it start pulling transactions as of the day it is created or will it post retrospectively to May 23rd? Just wondering if I should wait it out or if it is going to be necessary to use the csv import.
Additionally, what is the expected date of completion for the API? Many of us have a month end close schedule that must be adhered to. It would be great to be able to know if it can be met, instead of being kept in the dark.
Thank you.
- Spam
- Abuse
- Report
1 · Accept Answer Off Topic Insightful 1Vote Up AwesomeThis has been going on for over a month - Hearing that you are working on it as a response over and over again is not actually helping. What seems to be causing the issue, why is Expesnify not receiving the American Express charges anymore ?
We need a ETA - the entire reason I pay for this services is for American Express. @Jason_Richards_25 @Alejandro Paz @John Schuster @ExpenseMaster @Amanda DeWitt
- Spam
- Abuse
- Report
4 · Accept Answer Off Topic Insightful 4Vote Up Awesome@Elise_Byron Great questions! Regarding importing historical transactions, every bank/card provider sets what's called a "scrape window".
This refers to how far back from the current date we are able to pull in historical expenses from a given connection. While some banks will allow a scrape window of 90 days, some will only allow 30, and some even less. Once the connection is in place, we'll have a better understanding on how far back we can pull, but I won't know until then, unfortunately.
As far as the expected date of release, we're also unsure of that. We've got quite a bit of the code done, but need to get a few more things put in place before we can release the connection. That said, I don't recommend waiting on the API connection, as I can't guarantee it would be released before next close, and would hate for you to be banking on it.
For now, I recommend importing via CSV, or pursuing a GL1025 feed if your company is eligible.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeThe CSV file, do you need a separate file upload for each card or can you upload one file with all the credit card numbers and then assign the appropriate card to the correct domain member?
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeYou will not need to upload each card individually. We have a great walkthrough on how to upload and assign cards via CSV here. Let us know if you have any trouble!
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeThanks! I used those instructions, but was not clear that you could upload all of the card numbers and then assign...I missed that part. I was able to upload several spreadsheets using individual cards and assign to domain members. Now when I upload and submit a file I can't see the file in the drop down imported cards....
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeHi @ijf - Hmm, I might need some more specific details from you. Can you write to [email protected] so that our product support team can take a look in your account. That will help us diagnose the issue quicker.
Thank you!
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeThey have the info already...sent at 1:23 CST.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up AwesomeGreat, thanks for confirming @ijf I appreciate it. I'll let you continue with Concierge via the private thread then.
- Spam
- Abuse
- Report
0 · Accept Answer Off Topic Insightful Vote Up Awesome