Personal Credit Cards
Welcome to the world of effortless expense tracking! Connecting your personal credit card for importing transactions is a breeze, and we’re here to guide you through it. Let’s dive in and get your financial journey started.
How to connect your personal card to import expenses
Importing your card or bank via Account Settings will: Automatically sync your bank/card transactions with your Expensify account. These will merge seamlessly with any SmartScanned expenses in your account. Generate IRS-compliant eReceipts, provided your Policy Admin has enabled this feature. Discover below the numerous ways to easily bring your personal card expenses into Expensify below.
Important terms to know:
- Transaction Start Date: When you first import your card, you can choose a specific transaction start date. Depending on your bank, you can go back up to 90 days. If you need to include transactions from an earlier date, you can upload a spreadsheet of those transactions separately.
- Deleted Cards: If you delete an imported card from Expensify, all unsubmitted expenses associated with that card will also be removed from the system. Don’t worry, though – any imported card transactions within a processing, approved, closed, or reimbursed report will remain unaffected.
Importing expenses directly from your credit card or bank (in the web browser)
- Log into your Expensify account.
- Navigate to Settings > Account > Credit Card Import.
- Click the Import Bank/Card button.
- Choose your bank from the list provided. If you don’t see your bank, use the search box below to find it. If your bank isn’t listed, you can use our CSV method to import your expenses instead.
- Select a transaction start date using the calendar dropdown, then click Take me there.
- Enter the same username and password you use for online banking to connect.
- We’ll display all the accounts linked to your username. Select the account(s) you want to import.
- Once your card(s) are successfully imported, you can click Update next to the importing card(s) to fetch the latest transactions into your account.
Importing expenses directly from your credit card or bank (in the mobile app)
In your Settings, tap Import a card and follow the directions (similar to the instructions above) for your bank to start importing transactions.
Importing expenses via a spreadsheet
Spreadsheets can be uploaded as long as they are in one of the following formats:
To import expenses via a spreadsheet:
- Download a spreadsheet of your expenses directly from your online banking account. Please note: an OFX file type will require no editing but not all banks’ OFX files are compatible, so CSV is a good fallback option.
- If you need to, delete any extra header rows so that you have one header row. At minimum, you should include the merchant, transaction date and amount. It’s fine to have extra columns, but make sure you know which ones you’ll need so the data gets imported correctly.
- Format the date column — if you use Excel, you can do this by navigating to Format Cells > Custom. You can choose your preferred format (e.g, yyyy-mm-dd or mm-dd-yyyy), but remember to use the same format each month.
- Once your file is saved and ready, log into Expensify and click Settings > Account > Credit Card Import. Then click Import Transactions from File and on the next screen, select Upload.
- Now, let’s set up your file details. If this is the first time you’re uploading for this card, keep the layout as Default and choose a logical Mapping Name, such as ‘Platinum Visa.’ You might use this layout again in the future so be sure to choose something that’s easy to remember.
- Set the date format to match your CSV and adjust the currency to match your bank account currency.
- If you’ve previously imported expenses for the same card, choose the default layout of a previously uploaded spreadsheet.
- Scroll down and select which columns map to the merchant, date and amount (as a number without a currency symbol) – these are required presets which must be assigned.
- If applicable, you can also map specific Categories and Tags as long as you don’t have an integration connection to your default group policy. If you have an integration connected, you’ll want to add the Categories and Tags to the expense after the expense is uploaded.
- Check the preview of your selection under Output Preview. If everything looks good, you can then select Add Expenses.
- For checking accounts, you may need to “Flip Amount Sign” as transactions are often exported as negative amounts.
Removing or managing settings for imported personal cards
Changing How Card Appears: If you’d like to change the name of how your imported card appears, click Settings located under the card listed. Here, you can rename the account as well as decide whether these transactions should be reimbursable by default.
Reimbursable Status of Imported Transactions: Expenses can be imported as either reimbursable or non-reimbursable. Select the option that best fits your card.
- Reimbursable expenses are expenses that are owed back to you by the person/company you are submitting them to. If you incurred an expense on a personal card you, it is likely reimbursable.
- Non-reimbursable expenses are expenses that are not owed back to you. This is likely spend incurred on a company card or any card that someone else pays the balance for that you incur spend on and must track the expenses for.
Remove a card: If you need to remove a card, you can select the red trash can icon. Please remember this will remove all unreported and un-submitted transactions from your account that are tied to this card, so be careful!
Is the bank/credit card import option right for me? If you incur expenses using your personal or business card and need to get them accounted for in your company’s accounting, then you might want to import your bank/credit card. Please note, if you have a company-assigned corporate card, check with your company’s Expensify admin on how to handle these cards. Often, admins will take care of card assignments, and you won’t need to import them yourself.
Is the personal card spreadsheet import option right for me? Spreadsheet import is a great option for manually creating expenses in bulk when you run into any of the below scenarios. Take advantage of this time-saving option if:
- You have already imported your bank/credit card, but you need earlier transactions beyond the default 30-90 days (this varies depending on your bank).
- Your bank is not supported through a direct connection with Expensify, but you still need to get your transactions into the system. The best way to find if your bank is supported is to try importing it. If the bank is not listed, we do not support it at this time.
- You would like a way to do either of the above and would like to have the transactions merge with your SmartScanned receipts.
I’m not able to see the transactions I have imported when I click “View expenses”. Why? If you aren’t able to see the expenses imported when you click “View expenses”, try using the filters at the top of the Expenses screen to open up search criteria (such as the date) which often reveals “missing” expenses.
How do I remove an imported spreadsheet? If you need to remove an imported spreadsheet, you can select the red trash can icon. Please remember this will remove all unreported and unsubmitted transactions from your account that are tied to this import, so be careful!