If a user pastes the spreadsheet more than once and then successfully uploads it, Internet Expenses creates an expense report with duplicate receipts.Ĭlick Skip to Review or Continue to ensure there is no missing or invalid data in the report. Note: Be sure to paste the spreadsheet only once into the Spreadsheet Import Area. When the spreadsheet is complete, log in to Internet Expenses and click the Expenses Entry link.Ĭlick the Import Spreadsheet Expenses button to display the Import Expense Report Spreadsheet page.Ĭopy the contents of the spreadsheet in Microsoft Excel, then paste the contents in the Spreadsheet Import Area.

Open the spreadsheet template in Microsoft Excel and create a working copy using the Save As command.Įnter expenses in the spreadsheet using Microsoft Excel. To submit a disconnected expense report, an employee completes these steps:Ĭlick the Spreadsheet Export link and save the spreadsheet template to your local computer. Note: If you use the per diem or mileage rate schedules functionality, users need to enter these expenses online. See: Configuring the Microsoft Excel Template for more information. You can configure this spreadsheet template to meet the needs of your company. Internet Expenses provides a Microsoft Excel expense spreadsheet template to create a disconnected expense report. The disconnected expense reporting process involves entering expenses in a Microsoft Excel spreadsheet on a personal computer or laptop and then importing this spreadsheet into Internet Expenses. Testing your Custom Microsoft Excel TemplateĮmployees who are travelling or do not have access to the company's intranet can create expense reports using the disconnected expense reporting process.Setting Up Descriptive Flexfields in the Microsoft Excel Template.

Configuring the Microsoft Excel Template.This chapter covers the following topics: Oracle Internet Expenses Implementation and Administration Guide Oracle Internet Expenses Implementation and Administration Guide Browser version script Skip Headers

Excel expense report template