Export to QuickBooks

You can export your data from Resource Management for use in QuickBooks (for PC desktop, only).

Who can use this?

Plans:

  • Resource Management

Permissions:

  • Resourcing Administrators
  • Portfolio Editors
  • People Schedulers
  • Portfolio Reporters
  • Project Editors

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Resourcing Administrators, Portfolio Editors, People Schedulers, Portfolio Reporters, and Project Editors can create reports. The projects visible will vary by permission level. For example, Project Editors can only see the projects they own.

If you want to use data from Resource Management in QuickBooks, you need to create a report first and then export it.

This procedure is only for PC desktop.

Create a report

Create a report that includes the data you want to export. For example, you can create a report called October Invoicing. Customize your settings as needed. You can create and export reports on projects, phases, vacation time, or whatever data you want to use in QuickBooks.

  1. At the top of the screen, select Reports
  2. In the left panel, apply the following settings:
    • View: hours
    • Time Frame:  custom date range (October 1 - October 31)
    • First group by:  project (showing all projects in this time frame)
    • Then group by: team member (showing all the hours worked by all people in your company within this time frame).
  3. Select the Run Report button.

Save reports to your personal page or reports page to easily access them in the future.

Export your data

With the report open, select Export on the upper right, and then select Export Time Entries for QuickBooks.

This will save a . IIF file, the QuickBooks-specific file containing all your Resource Management data.

Save this file in an easy-to-find place.

Open QuickBooks

  1. Make sure you have all of your employees with attached bill rates in the system. This is likely already set up if you use QuickBooks for accounting and payroll.
  2. Open QuickBooks. 
  3. Navigate to File > Utilities > Import > Import .IIF file
  4. Select the project you want to invoice. Select Create Invoice at the bottom of the page. 

Your invoice should pull bill rates set up in QuickBooks and align them with hours recorded in Resource Management.

QuickBooks data mapping

The .IFF file you download from Resource Management won’t need additional formatting for import into QuickBooks. However, make sure the data between QuickBooks and Resource Management is properly matched, and you understand where the data fields are mapped to QuickBooks.

Spelling and spacing of all your items must be exactly the same between the two systems.

QuickBooks data is mapped to Resource Management as follows:

  • Quickbooks: customer = Resource Management: client
  • Quickbooks: job = Resource Management: project
  • Quickbooks: employee = Resource Management: people
  • Quickbooks: service item or item = Resource Management: task category
  • Quickbooks: notes or description = Resource Management: notes
  • Quickbooks: rate = Resource Management: bill rate