Data Sources is where you connect the systems Tesorio pulls data from, check that your syncs are healthy, and load data from files.
To open it, go to Settings → Data Sources. The page has four tabs:
Connected apps: the systems Tesorio connects to, such as your ERP, CRM, billing system, email inboxes, and Slack.
Bank files: bank statement and lockbox files.
One-time uploads: CSV files you upload once to update records in bulk.
Notifications: who gets emailed when a sync or an import fails.
Most setup tasks on this page have a built-in wizard that walks you through each step. This article explains what each tab shows so you know where to look.
Availability: Not every account sees every app or tab. What you see depends on your plan and setup.
Connected apps
This tab lists every system connected to Tesorio, one row per connection.
Reading the list
App: the system's name, plus the account, site, or email address it connects to.
Status: whether the connection is working. For example, Connected, Onboarding failed, or a count of failing items such as 8 failing.
Last sync: when Tesorio last pulled data, and whether that sync was Complete or Failed. Apps that don't pull data on a schedule show Doesn't sync. Connected inboxes show Live.
Duration: how long the last sync took.
30-day average: the average sync time over the last 30 days, and how many syncs completed.
Recent syncs: one bar per recent sync, so you can spot failures at a glance.
Adding an app
Click Add app.
Pick the system you want to connect.
Follow the on-screen setup steps.
Looking inside a connection
Click the arrow at the left of a row to expand it. The tabs you see depend on the app. A NetSuite connection, for example, has these tabs:
History: every sync run, with its Started time, Type, Status, Duration, and Error (if it failed). Filter by Status, Type, Started from, and Started to. Expand a run to see more detail.
Credentials: the account Tesorio uses to sign in to the system.
Filters: which records Tesorio imports.
Custom fields: extra fields from your system that you want to bring into Tesorio.
Test connection: checks that Tesorio has the permissions it needs.
To see more actions for a connection, click ⋯ at the end of the row.
Special kinds of connections
Tesorio Connect reads CSV files placed in an SFTP folder. Its row shows how many file importers you have and the overall status. Expand it to see each importer.
Salesforce Canvas shows Tesorio on Salesforce account pages. It doesn't sync data, so its Last sync shows Doesn't sync.
Connected Shared Inbox connects a Gmail or Outlook inbox so Tesorio can log customer emails.
Slack connects your Slack workspace to Tesorio.
Bank files
This tab lists the importers that bring bank statement and lockbox files into Tesorio.
Importer: the importer's name, its file format (for example, BAI2, CAMT.053, BAI lockbox, or Automated), and where the files come from (for example, Tesorio SFTP).
Status: Processed or Failed for the latest file.
Last import: when a file was last imported.
Result: what the last import brought in, for example 2 imported.
To add a new bank file importer, click Add bank file. Lockbox files need extra setup for each bank, which the Tesorio team does with you. Contact your Tesorio team to get started.
One-time uploads
Use this tab to upload a CSV that updates records in bulk, such as customer or invoice tags and assignees.
To start, click Upload file and follow the steps.
The list shows each upload's File, when it was Uploaded, its Import type, and its Result (Processed or Failed).
Use All import types and All results to filter the list.
Note: Uploading the same file twice can import its rows twice.
Notifications
Choose who gets an email when a sync or an import fails.
Open the Notifications tab.
In Recipients, type a teammate's name or any email address.
Common questions
A connection shows Onboarding failed or a number of failing items. What do I do?
Expand the row and open History. Set Status to the failed status and read the Error column. If the error points to a sign-in or permission problem, check Credentials and run Test connection. If you're still stuck, contact Tesorio Support and tell them which app failed and when.
Data looks out of date in Tesorio.
Check Last sync for the app. If the last sync was a long time ago or failed, open History to see why.
Some records are missing.
Check that connection's Filters tab. A filter may be excluding those records.
Why don't I see an app or tab mentioned here?
Some apps and tabs depend on your plan or account setup. Contact your Tesorio team if you need one you can't see.
A bank file or upload shows Failed.
Click ⋯ on that row to see what went wrong.




