Welcome to Portal
Advanced Analytics for Expensify enables import and analysis of expense data, providing detailed reports and visual dashboards. It helps businesses gain insights into spending patterns, optimize expense management, and monitor financial performance. This integration offers a comprehensive view of expenses, identifies cost-saving opportunities, and streamlines financial reporting.
A user with administrator privileges (Account admin and Org admin) can configure the integration.
Note:
Modules |
Fields |
Policy | Policy ID, Policy Name, Owner, Role, Type, Currency, Created Time |
Reports | Report ID, Old Report ID, Report Name, Report Status, Submitted Date, Account E-mail, Account ID, Approved Date, Created Date, Currency, Latest Reimbursement ID, Is ACH Reimbursed, Last Approver E-mail, Last Approver User ID, Last Approver Payroll ID, Last Approver First Name, Last Approver Last Name, Last Approver Full Name, Policy ID, Reimbursed Date, Employee Custom Field1, Employee Custom Field2, Submitter First Name, Submitter Last Name, Submitter Full Name, Total |
Expenses | Report ID, Expense ID, Bank, Is Billable, Category, Comment, Amount, Converted Amount, Created Date, Currency, Currency Conversion Rate, Is Tax Applied, Inserted Date, MCC, Merchant, Modified Amount, Modified Created Date, Modified MCC, Modified Merchant, Receipt File Name, Receipt ID, Receipt Transaction ID, Receipt Type, Receipt URL, Is Reimbursable, Tag, Tax Amount, Modified Tax Amount, Tax Rate Name, Expense Type, Expense Unit Count, Expense Unit Rate, Expense Unit |
Expense Attendees | Expense ID, Attendee Name, Attendee E-mail |
Report Approvers | Report ID, Approver E-mail, Approved Date, Approver First Name, Approver Last Name, Approver Full Name, Approver Employee ID, Approver Employee Payroll ID |
Report History & Comments | Report ID, Action, Account E-mail, Created Date, Message |
Categories | Category Name, Are Comments Needed, Is Enabled, Policy ID, Payroll Code, GL Code, Description Hint, Maximum Expense Amount |
People | E-Mail, Role, Policy ID, Submits To, Forwards To, Employee ID, Employee Custom Field1, Employee Custom Field2, Over Limit Forwards To, Approval Limit |
Tax | Tax Rate Name, Tax Name, Tax Rate, Tax Rate ID, Policy ID |
Tags | Tag Name, Tag Option Name, Tag GL Code, Is Tag Enabled, Policy ID |
Zoho Analytics offers flexible sync schedules to ensure that your data is always up-to-date for effective analysis. These schedules allow you to automate the process of updating your data, ensuring that your analyses are based on the latest information.
Data synchronization can fail,
In any of the above mentioned cases, the data sync will be paused. You will be notified via email and in- app notification with the exact reason for failure along with the solution.
To resolve the sync failure, delete or restructure the views, or restore the specific modules and fields from the source application. Refer to Data Sync failure and solutions article for more details.
Once you have made the changes, click the Sync now option in the data source tab to resume data sync. If the issue persists, contact support@zohoanalytics.com
The Data Sources tab provides essential information to monitor and manage the integration setup. It also allows you to edit the settings as needed. Users with administrator privileges will be able to view and modify the connection settings.
The Data Source Permalink helps you easily access the data source tab. Only the Organization Admin and Account Admin can make changes in the Data sources page, other users can know the synchronization details like whether the last data sync was successful or not, when the last data sync happened, when the next sync is scheduled to happen, etc. This link can also be pasted in dashboards so that everyone accessing the dashboard can know about the sync status.
The Edit Setup tab allows you to add or delete modules or fields, change the schedule interval, and modify other settings specific to the business application.
To modify the settings,
Re-authentication will be helpful when the API key or password is changed. In this case, the data sync will be paused, and the administrator who configure the connector setup must re-authenticate to resume the data sync.
The Sync History tab provides details about the data sync for the last 45 days. A successful data sync is marked in green, and a sync failure is marked in red.
To view the Sync history,
Zoho Analytics logs all the user activities and system events within the Expensify workspace. The following actions that are logged in Zoho Analytics,
To view the audit history,
Zoho Analytics allows you to remove the integration if needed. Removing the integration will suspend further data synchronization. The data tables and the reports will be available.
Click the Settings icon in the Data Sources tab, and select Remove Data Source from the drop-down menu.
Zoho Analytics allows you to combine data from various sources such as Files, Feeds, Databases and Business Applications for an in-depth analysis. Query Tables allows you to combine data from different tables to create reports.
While blending data from other data sources, Zoho Analytics automatically identifies similar columns and provides suggestions for lookups. Refer to the Joining Tables article for more details.
Visualization |
Types
|
Bar
|
Stacked bar, Histogram, Horizontal bar
|
Stacked Bar
|
Horizontal Stacked bar, 100% vertical and horizontal stacked bar
|
Area
|
Area with markers, Smooth Area, Smooth area with Markers
|
Line and Bar Combination chart
|
Bar with Line, Bar with Bubble, Bar with Scatter, Bar with Area, Area with Bubble, Line with Bubble and Custom Combination
|
Bubble Chart
|
Bubble Pie, Packed Bubble, Word Cloud
|
Stacked Area
|
Stacked area with markers, Smooth stacked area, Smooth stacked area with markers
|
Map
|
Heat Map, Map Scatter, Map Bubble, Map Pie, Map Bubble Pie, Map Filled, Geo Heat Map
|
Pie
|
Pie, Ring, Semi Pie, Semi Ring
|
Tree map
|
Default View
|
Sankey | Default View |
Sunburst
|
Default View
|
Race Chart
|
Default View
|
Doughnut
|
Default View
|
Matrix View
|
Pivot table
|
Tabular
|
Summary and Tabular view
|
Dashboards and KPI widgets
|
Single Numeric Widget, Dial Chart Widget
Bullet, Chart Widget
|
We offer 24x5 technical support (Monday to Friday). In case if you need our assistance kindly do mail us your questions to support@zohoanalytics.com.
You can also reach out to us on our toll-free numbers.
United States: +1 (888) 900 9646
United Kingdom: +44 (20) 35647890
Australia: +61-2-80662898
India: 044 - 69656060
Subscribe to receive notifications from this article.