Importing Budget Items

Objective

After completing this lesson, you will be able to execute the steps to import additional budget items.

Introduction

Budget Item Import allows you to add and update the Expense, Invoice, and Request budget items by importing an Excel spreadsheet (on demand), saving time and reducing manual effort.

How to Import Additional Budget Items

Follow these steps to import additional budgets. We'll walk you through each part of the process, complete with detailed instructions and screenshots to help you along the way.

Once you complete these steps, a demo video will be available to reinforce what you've learned and provide a quick recap.

Steps

  1. On the Budget Items tab, select the More dropdown menu. Choose Import.

    The image shows a screenshot of the Budget Configuration interface with tabs for various settings. Buttons include: New, Modify, More (with options for Import (highlighted in yellow), Adjustments Import and Export, Change Logs, and Bulk Exports), and New Team Budget. The table lists four budgets.

  2. Select Download Import Template. Alternatively, use Send to Excel for an existing budget.

    The image shows a screenshot of a Budget Import window. It explains the imported budget items will be added for new budgets or updated for existing ones. There is a button labeled Download Import Template (highlighted in yellow) and a section titled New Upload, which prompts users to upload a budget import file in .xlsx format or .xlsx.

  3. Populate and save the budget import template file.

    The image shows a screenshot of a spreadsheet with headings related to budgeting information. Columns are labeled: Budget Name, Budget Group, Fiscal Year, Currency, Owner, Budget Category, Approval Process, Managing Director, Budget Viewers, Fiscal Period Name, Start Date, End Date, Amount, and more specific details like Project ID and Department. Entries show sample budgets with details like budget categories, fiscal years, amounts, and currency.

  4. Choose Upload Budget Import File to browse for and select the completed file.

    The image shows a screenshot of a Budget Import window. It explains the imported budget items will be added for new budgets or updated for existing ones. There is a button labeled Download Import Template and a section titled New Upload, which prompts users to upload a budget import file in .xlsx format or .xlsx. Under New Upload, there is an Upload Budget Import File link highlighted in yellow.

  5. Review the results under the Upload History section.

    The image shows a screenshot of a Budget Import window. It explains the imported budget items will be added for new budgets or updated for existing ones. There is a button labeled Download Import Template and a section titled New Upload, which prompts users to upload a budget import file in .xlsx format or .xlsx. Under New Upload, there is an Upload Budget Import File link. An Upload History section presents columns and entries for Date, Status, Initiated by, File Name, Records Processed, and Records Failed.

Result

References

TitleLink
Budget Admin Guide - Budget Item ImportBudget Admin Guide - Budget Item Import

Summary

  • Import budget items using an Excel template to save time and reduce manual entry.
  • Download and complete the import template with all required budget details.
  • Upload the completed file to add or update budget items in the system.
  • Review upload results in the Upload History section to confirm successful import.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn