Submit a ticket My Tickets
Welcome
Login  Sign up

Importing Budget from Excel

How can I import my project budget from an Excel template?

Creating a budget within Projectmates from scratch can be cumbersome, especially if you already have the project budget stored elsewhere. Let's discuss how to import the budget using the provided Excel template for budgets.  Click the Import/Export data link from the more button in the upper right corner of the budget area.  The Import/Export Entries for Budget screen will display.

Helpful Hint: If don't see 'Import/Export items' in the left-side menu under your budget thread name, then you don't have the proper authority to import the budget. If you are an Administrator, you can check your role in the project to see if it needs to be changed or recopy the template project into the project to update the role rights. If you are not an Administrator, please reach out to your Administrator for assistance.

  1. Click the Download Template Icon.
  2. Update the template file and save it to your computer.
  3. In Projectmates, click the Select button to select the template file you created.
  4. Optionally, mark the check box for Delete all existing items on import (use caution).  Only use this if you want to completely delete the budget and any existing linked items before importing a new budget. Alternatively, to keep all existing items, DO NOT mark the check box (Highly Recommended).

    Helpful Hint: Deleting existing items will remove links to any items from other modules, including Bids, Contracts, Purchase Orders, and Invoices.

  5. Click the Import button. Values from the spreadsheet will be imported to the budget.

Click here for more information on budgets and importing an excel budget into Projectmates.



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.