Zoho Books Integration Archives - The Workflow Academy

Course Content

Expand All

Start With a Superb Setup 3 Topics

Lesson Content

0% Complete 0/3 Steps

Enable The Integration from Zoho Books to Analytics

Adjusting The Sync And A Few WARNINGS

Clean Up Folders and Look at The Sync

Dive Into the Data 6 Topics

Lesson Content

0% Complete 0/6 Steps

Where Do All These Tables of Data Come From?

Let’s Look at An Example — Invoices and Invoice Items

The Confusing Product ID Field

Example 2 — Credit Notes and Items/Refunds

Example 3 — Payments

Understanding All Other Finance Tables

Build A “Most Common Items Sold” Report 4 Topics

Lesson Content

0% Complete 0/4 Steps

Identify The Data We Need for This Report

Create A Pivot Table Using the Invoice Items Table

Ensure The Tables Are Connected Properly

Finish And Use Your New Report

Begin Improving Your Finance Reporting with SQL Queries 4 Topics

Lesson Content

0% Complete 0/4 Steps

Our Use Case — A Stock On Hand Report

Write and Test the Code

Build A Pivot Table to Summarize the Data

Wrapping It All Up