)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Bring live Purchasing Price Lists from Sage Intacct into Excel to compare vendor rates and discounts. In this guide, you’ll install Coefficient, import price list data, and configure auto-refresh for up-to-date pricing.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Choose “Import from Objects” > “Purchasing Price Lists” > Import.
-
Step 3:
Apply filters if needed, then confirm.
-
Step 4:
Enable auto-refresh to keep data updated automatically.
Step-by-Step Guide
What Sage Intacct Data Is Imported?
Rate Table Timesheet Entries
- Rate Table Credit Card Entries
- Rate Table Employee Expense Entries
- Rate Table Accounts Payable Entries
- Rate Table General Ledger Entries
- Standard Tasks
- Contract Expenses
- Contracts
- Employees
- Expense Adjustments
- Adjustment Lines
- Expense Payment Types
- Expense Reports
Related Sage Intacct Use Cases
How to Import Vendors Data from Sage Intacct into Google Sheets
Learn how to easily import live Sage Intacct Vendors data into Google Sheets using Coefficient for streamlined vendor management and reporting.
How to Import Users Data from Sage Intacct into Google Sheets
Learn how to easily import live Sage Intacct Users data into Google Sheets using Coefficient for streamlined user analysis and reporting.
How to Import Tax Details Data from Sage Intacct into Google Sheets
Learn how to easily import live Sage Intacct Tax Details data into Google Sheets using Coefficient for streamlined tax analysis and reporting.
Frequently Asked Questions
-
How do I import Purchasing Price Lists into Excel?
- Install Coefficient and connect your Sage Intacct account.
- Select “Import from Objects” > “Purchasing Price Lists.”
- Click Import to fetch vendor pricing.
Coefficient keeps your price lists live and accurate.
-
Can I filter price lists by vendor?
- Click “Add Filter” in the import dialog.
- Select Vendor field and set criteria.
- Import filtered results.
Only matching price lists will load.
-
How do I update price lists back to Sage Intacct?
- Edit price list rows in Excel.
- Click “Export to Sage Intacct.”
- Map columns and confirm export.
Two-way sync keeps rates aligned.
-
Is auto-refresh available for price lists?
- Click “Refresh” in the sidebar.
- Choose your schedule and save.
- Data updates automatically.
Your price lists stay current without manual effort.
-
Where can I learn more about Sage Intacct objects?
- Visit Coefficient’s Sage Intacct integration guide.
- Explore Platform Services > Web Services.
Consult docs for full definitions.
Trusted By Over 50,000 Companies
