We're currently experiencing a site outage. Please visit our status page for more details and to subscribe to updates.

Expensify.org/hunger SNAP campaign status 

The number of families signing up for reimbursement has vastly outnumbered the limited funds available. Though we’re unable to provide a specific timeline on when your report will be reimbursed, we’re doing our best to drive donations and keep our fund moving forward. Rest assured, we’ll review every report that’s submitted per our instructions. 

Thanks for your patience! 

How-to: Import personal card expenses via a spreadsheet

Mark LouisMark Louis Expensify Team Posts: 96 Expensify Team
edited April 28 in How-to Docs

You can import any bank into Expensify using a spreadsheet, as long as it is in the file format CSV, XLS, OFX, or QFX. This option can be useful, for example, if your bank is not supported, or if you need to import earlier transactions beyond the default 30-90 day period banks allow.

To import expenses incurred on a personal card via a spreadsheet, follow these steps:

  1. Download a spreadsheet of your expenses directly from your online banking account. 
  2. Once you have this file, log into Expensify and click Settings > Account > Credit Card Import.
  3. Click "Import Transactions from File"
  4. On the next screen, select "Upload"
  5. Next, you'll need to define the details of your file. Set the date format and currency to your needs. If you've previously imported a spreadsheet, choose your preset mapping and everything will be filled in.
  6. Scroll down and select which columns have the merchant, date and amount – these are required presets which must be assigned. If necessary, you can also map the Category and Tag.
  7. Check the preview of your selection under Output Preview. If it looks good, you can then select "Add Expenses".

You're done! The CSV spreadsheet import will now appear under Imported Card Feeds. You can view the imported transactions by clicking "View Expenses" under the file feed.

Related articles:

Sign In or Register to comment.