Coupa logo

Sync Coupa data to Sourcetable

Coupa

Coupa is a unified, cloud-based platform that helps companies manage and track key Business Spend Management (BSM) activities, including invoicing, contracting and payments. The platform can be used to analyse important financial KPIs including Invoice Exception Rate, and Average Time & Cost to process invoices.

Sync Coupa data to Sourcetable


Coupa logo
Sourcetable logo

Find out how to make the most of your Coupa data with Sourcetable

Sourcetable Benefits

Query financial data quickly & easily

Coupa's cloud-based suite of Business Spend Management applications lets users track and control their spend and supply chains at a glance. Syncing Coupa data to Sourcetable, and combining it with findings from other platforms and databases, allows users to create auto-updating models and analyze key financial management metrics alongside other key metrics.

Accessibility

Syncing your Coupa data to Sourcetable allows users to compare business spend management metrics with other KPIs quickly and easily, without having to learn SQL or other database languages - making key data available to all members of your team.

Auto-update your BSM data

Sourcetable brings together key data from Coupa and other platforms quickly and intuitively, allowing users to automate processes and free up time to focus on other important aspects of their business.

Two circular arrows representing how your data refreshes when any of the sources changes

Find out how to get the most from Coupa with Sourcetable

A Magic Wand

Smart Templates

Sourcetable provides out-of-the-box, tried and tested templates for cross-referencing sources and findings, improving data collaboration across your entire organisation

A Magic Wand

Quick Analysis

Analyse your Coupa financial data instantly in cross-channel reports, drawing on insights from multiple platforms and applications.

A Magic Wand

Ease Of use

Compile all pertinent Coupa data into a single spreadsheet, to query it and identify the business intelligence behind the numbers.

Who uses Coupa data in Sourcetable

💸 CFOs & Accountants

📈 Marketing and Advertising professionals

👷🏿 Sales and Sales Ops folk

🚀 Founders

Sample of the Coupa data that will be available
in your Sourcetable spreadsheets

Show all (46)

ACCOUNT

Helps mimic your business' financial structure

Link icon

ACCOUNT_TYPE

Includes primary_address_id ,primary_contact_id ,currency_id ,created_by_id ,updated_by_id ,active ,created_at ,legal_entIty_name ,name ,updated_at

Link icon

ACCOUNT_VALIDATION_RULE

Inlcudes account_type_id , created_by_id ,updated_by_id ,active ,created_at ,description ,error_message ,name ,updated_at and segment_* .

Link icon

ADDRESS

Address API can be used to query, create, or update personal or supplier remIt-to address information.

Link icon

APPROVAL

Approvals API can be used to create, update, or query the approval of a document and Includes specific endpoints to take action (reject/hold/approve) as well as requisition details like requestor, line items, and shipping details.

Link icon

ASN_HEADER

Inlcudes created_by_id , updated_by_id , ship_to_address_id ,ship_to_user_id ,ship_to_warehouse_id , supplier_id ,asn_number ,bill_of_landing , container , created_at , delivery_date , export_flag , gross_weight , packing_slip , ship_date , ship_method , ship_note , standard_carrier_alpha_code , status , tracking_number , trailer , uom and updated_at

Link icon

BUDGET_LINE

Budget line API can be used to create and update budget lines that you have associated wIth your accounts

Link icon

BUSINESS_GROUP

Content groups can be assigned to users to restrict access to other objects in Coupa.

Link icon

CHARGE

Includes account_type_id ,created_by_id ,merchant_currency_id ,order_header_id ,statement_id ,supplier_id ,updated_by_id ,virtual_card_id ,card_provider_account ,charge_date ,created_at ,exported ,external_ref_id ,last_exported_at ,mcc ,statement_name,supplier_name ,total ,updated_at

Link icon

COMMODITY

Includes created_by_id , parent_id , updated_by_id ,active ,category ,created_at ,deductibilIty ,name ,sub_category and updated_at

Link icon

COMMODITY_TRANSLATION

Includes commodIty_id ,created_at ,locale ,name and updated_at

Link icon

CONTRACT

Contracts API can be used to create, update, or query a contract and includes the business groups involved, key dates, the status of the contract, and the financial terms.

Link icon

CONTRACT_TEMPLATE

Includes id ,created_by_id , updated_by_id ,active , authoring_method ,created_at , description ,hierarchy_type ,name and updated_by

Link icon

CURRENCY

Includes id ,created_by_id , updated_by_id ,code ,decimals ,enabled ,name and symbol

Link icon

DATA_FILE_SOURCE

Includes id , created_by_id , updated_by_id , end_time ,file_content_type,file_file_name ,file_file_size ,integration_id ,integration_run_id ,progress ,records_count ,records_created ,records_updated ,result_text , source_for ,start_time ,status ,type , updated_at and upload_errors_count

Link icon

DEPARTMENT

It used to mimic your business' operating structure and organize content groups and users accordingly.

Link icon

EXCHANGE_RATE

It used to manage exchange rates for currencies your company uses to pay for goods.

Link icon

EXPENSE_LINE

Includes id , account_id , accounting_total_currency_id ,created_by_id , currency_id , expense_category_id ,expense_line_imported_data_idexpense_line_mileage_id , expense_line_per_diem_id ,expense_line_preapproval_id ,expense_report_id ,foreign_currency_id , integration_id ,order_line_id ,period_id , receipt_total_currency_id and So on

Link icon

EXPENSE_REPORT

Inlcudes id , created_by_id, currency_id ,expensed_by_id ,payment_id , reimbursable_total_currency_id , submItted_by_id , updated_by_id , audIt_score , audItor_note , created_at , exported , external_src_schema and So on

Link icon

INTEGRATION

Includes id ,business_object ,code ,created_at ,direction ,end_system ,end_system_type ,integration_type ,name ,standard and updated_at

Link icon

INTEGRATION_CONTACTS

Includes id ,contact_alert_type ,contactable_id ,contactable_type ,created_at ,created_by_id ,updated_at and updated_by_id

Link icon

INTEGRATION_ERROR

Includes id , created_by_id , integration_id , integration_run_id , updated_by_id ,contact_alert_type, created_at, creation_method , document_id ,document_revision ,document_status , document_type ,external_id ,integration_filename , resolved ,status and updated_at

Link icon

INTEGRATION_HISTORY_RECORD

Includes id ,created_by_id ,integration_id ,integration_run_id ,updated_by_id ,inventory_transaction_id ,invoice_header_id ,order_header_id ,contact_alert_type ,created_at ,creation_method ,document_id ,document_revision ,document_status ,document_type ,external_id ,resolved ,status and updated_at

Link icon

INTEGRATION_RUN

Includes id , integration_id ,created_at ,end_time ,records_processed ,start_time ,status ,total_records and updated_at

Link icon

INVENTORY_TRANSACTION

Includes id , account_id ,asn_header_id ,asn_line_id ,created_by_id ,currency_id ,from_warehouse_id ,from_warehouse_location_id ,inspection_code_id ,Item_id ,order_line_id ,receipt_id and to_warehouse_id

INVOICE_HEADER

Includes id , abandon_reason_id , account_type_id ,bill_to_address_id ,account_holder_type ,contract_id ,created_by_id ,currency_id ,destination_country_id ,invoice_from_address_id ,legal_destination_country_id ,origin_country_id ,payment_term_id ,remIt_to_address_id ,requested_by_id ,ship_from_address_id ,ship_to_address_id and shipping_term_id

ITEM

Item API is used to create, update, or query goods not provided by suppliers that your employees will select from when creating a requisItion.

Link icon

LOOKUP_VALUE

Lookup values API is used to create a hierarchy of accounts

Link icon

ORDER_HEADER

Includes id ,created_by_id ,currency_id , payment_term_id ,pcard_id ,requester_id ,requisItion_header_id ,ship_to_address_id ,ship_to_user_id ,shipping_term_id ,supplier_id ,updated_by_id ,acknowledged_at acknowledged_flag

Link icon

ORDER_HEADER_CHANGE

Includes id , created_by_id , current_approval_id ,department_id ,reject_reason_id , acknowledged_at ,created_at ,exported ,justification ,order_header_id ,payment_method ,po_number ,price_hidden ,requisItion_header_id ,ship_to_attention ,status , supplier_inItiated ,transmission_emails , transmission_method_override , updated_at and version

Link icon

ORDER_PAD

Includes id ,base_value_currency_id ,created_by_id ,updated_by_id ,add_all_Items ,any_supplier ,base_value ,created_at , locked ,name ,updated_at and use_base_value

Link icon

PAYMENT

Includes id ,created_by_id ,updated_by_id ,amount_paid ,check_number ,created_at ,notes ,payable_id ,payable_type , payment_date and updated_at

Link icon

PAYMENT_TERM

Includes id ,created_by_id ,updated_by_id ,active ,code ,created_at ,days_for_discount_payment ,days_for_net_payment description and discount_rate

PCARD

Includes id ,created_by_id ,updated_by_id ,active ,created_at ,expiry ,name ,nickname ,number ,shared and updated_at

Link icon

PROJECT

Includes id , commodIty_id , created_by_id ,updated_by_id ,active ,created_at ,description ,display_date_range_warning ,end_date ,mention_name ,name ,open ,start_date and updated_at

Link icon

QUOTE_REQUEST

Includes id ,allow_award_individual_line_Item ,allow_multiple_response ,automatic_bid_unsealing , comments ,description ,end_time ,event_type , sealed_bids ,sealing_type ,start_on_submIt ,start_time and timezone.

Link icon

REQUISITION_HEADER

Includes id , approver_id , created_by_id , currency_id ,current_approval_id , department_id , pcard_id , receiving_warehouse_id ,requested_by_id ,ship_to_address_id ,updated_by_id , buyer_note ,created_at , exported ,justification ,line_count , mobile_total ,need_by_date ,price_hidden ,reject_reason_commentship_to_attention , status ,submItted_at , total and updated_at

Link icon

REQUISITION_LINE

Includes account_id , commodIty_id ,contract_id ,created_by_id ,currency_id ,Item_id ,order_line_id ,order_pad_line_id ,payment_term_id , period_id ,punchout_sIte_id ,shipping_term_id , supplier_id , uom_id , updated_by_id , requisItion_header_id ,created_at and So on.

Link icon

SHIPPING_TERM

Includes id ,created_by_id ,updated_by_id ,active , code , created_at ,description and updated_at

SUPPLIER

It used to create, update, and query the suppliers in Coupa.

Link icon

SUPPLIER_RISK_AWARE_FEED

Includes id ,supplier_id ,created_at ,number_field_01 ,number_field_02 ,number_field_03 ,number_field_04 ,number_field_05 ,number_field_06 ,number_field_07 ,number_field_08 ,number_field_09 ,number_field_10 and updated_at

Link icon

TAX_REGISTRATION

Includes id ,created_by_id ,country_id ,updated_by_id ,active ,created_at ,local ,number ,owner_id ,owner_type and updated_at

Link icon

USER

It used to create, update, or query users and it ranges from basic demographics, to managing passwords, to managing the groups and approval permissions

Link icon

USER_GROUP

Includes id ,created_by_id ,owner_id ,updated_by_id ,active , can_approve ,created_at ,description ,mention_name ,name , open ,type and updated_at

Link icon

USER_GROUP_MEMBERSHIP

Includes id , user_group_id , user_id,created_at,owner,participant and updated_at

Link icon

VIRTUAL_CARD

Includes id ,created_by_id ,currency_id ,order_header_id , requested_by_id ,updated_by_id ,card_number ,card_type ,coupa_pay_id created_at,credit_account, document_id ,document_type ,expiry_month , expiry_year ,external_ref_id ,name status ,total_booked ,total_charged , updated_at ,valid_from and valid_to

Link icon

Sample companies

Online businesses integrating Coupa with Sourcetable can quickly access all relevant data on revenue, expenses, statements, estimates and accounting.

  • Retail online stores

    (eCommerce)
  • Retail offline stores

  • B2B Platforms

  • Software as a Service

    (SaaS) companies
  • B2C Marketplaces

What makes Sourcetable special?

A Magic Wand

Interconnectivity

Compile, sync and query your Coupa business spend management data with findings from 30+ other sources, to drive decisions and improve business performance.

A Magic Wand

Collaboration

Create workflow templates based on data from Coupa and other platforms, and share with your team, no tech skills required

A Magic Wand

Automation

Automate your key Coupa data and processes, freeing up time to focus on other aspects of your business

Frequently Asked Questions

How do I sync Coupa data to Sourcetable?
Sourcetable is currently in Closed Beta. Sign up to the Beta here to tell us a little about yourself and request information on how to sync your Coupa data.
How easy is it to visualize my Coupa data using Sourcetable?
Sourcetable spreadsheets are designed to be intuitive and user-friendly, so anyone can view key data from Coupa - and other financial management platforms such as Quickbooks Online or NetSuite - at a glance without SQL.
Which BSM software works best with Sourcetable – Coupa or NetSuite?
Sourcetable enables users to combine data from both platforms, enabling businesses to better understand the relationships among available data, and gain new insights to inform decisions and identify new opportunities.




Connect your Coupa Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.