Need a customized project? We build it to your exact requirements.Contact us on WhatsApp

Free Royalty Report Generator – Google Sheets Apps Script

R18 CRUD & Dashboards Premium Plan Weekly Plan VIP Premium Plan
❤️
Need a Custom Business Solution?
Connect with us on WhatsApp to discuss your requirements. Our team will design and develop a tailored software solution aligned with your business workflow, operational needs, and growth objectives.
R18 | How to Generate / Create Reports from Google Sheet using Web Apps script
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help

Key Features

Reports generated for any customer or user ID Summary report with gross volume and net payable Net payable calculated after contract and tax Product report showing earnings per product Platform report showing earnings per service Artist and label reports from the same data Country report with total net revenue Every report drawn from a single sheet Report type chosen from a dropdown Totals summed on each report Print any report Download any report as a PDF

Description

R18 is a report generator for anyone who pays other people from shared revenue — a distributor settling with artists, an agency reporting to clients, a marketplace paying sellers. You type an ID, choose which report you want, and it is built from the raw transaction data on the spot.

Six views of one dataset

Summary, products, platforms, artists, labels and countries. The same rows produce all of them, so the product breakdown and the country breakdown always agree with the summary — there is no second sheet to keep in step, which is exactly where reporting usually goes wrong.

The summary does the arithmetic

It returns gross volume, the number of transactions, the contract figure and the total tax, then the net payable — gross minus contract minus tax. That last number is the one the conversation is actually about, and it is calculated rather than typed, so it can be defended.

Breaking it down

The product report shows what each item earned. The platform report shows the same money split by service, with its own total. Countries shows where the business came from and the net revenue behind it. Artists and labels work the same way. Each view is a dropdown selection, not a different tool.

Sending it out

Print produces a clean copy, and Download PDF gives you the file to email. The person receiving it sees one document per report rather than a spreadsheet they have to interpret.

What changed in this version

The earlier build kept a separate sheet per report type. This one pulls everything from a single sheet, which is less to maintain and impossible to get out of sync.

Requirements

  • A Google account with Drive and Sheets
  • Your own copy of the provided spreadsheet
  • One sheet holding the transaction rows
  • Columns for product platform artist label and country
  • Deploy as a web app with access set for your users

What's Included

  • Complete Apps Script code for the report generator
  • Google Sheet with the transaction layout
  • ID lookup with a report type dropdown
  • Summary report with gross contract tax and net payable
  • Product report with earnings per item
  • Platform report with earnings per service
  • Artist and label reports
  • Country report with net revenue
  • Totals on every report
  • Print output and PDF download
  • Step-by-step video walkthrough of the full build
  • Free support from the developer

Item Details

Versionv1.0
PublishedAug 22, 2025
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryCRUD & Dashboards
Tagsgoogle sheets report generatorgenerate reports from google sheetroyalty report google sheetsroyalty statement generatornet payable calculation reportper product earnings reportplatform wise revenue reportcountry wise sales report
VideoWatch walkthrough
LicenseRegular License
Subscription Verification Required
This is a free file. Subscribe to our YouTube channel to unlock the source code + Google Sheet. One click — no payment. Google only confirms you are subscribed.
Verify Now
Free download

Subscribe & Unlock Source Code

Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.

What you get

  • Code.gs + HTML filesThe complete Apps Script project
  • Google SheetYour own copy with the data
  • Setup guideInstall steps from start to finish

Not subscribed yet? Subscribe to our channel

Browse More Free Files

Related Files

Admin Dashboard with Google Apps Script & React | Complete CRUD System | E21

Admin Dashboard with Google Apps Script & React | Complete CRUD System | E21

Apps Script CRUD & Dashboards
View price
Watch Video
How to Build a Dashboard in Google Appscript | Free Code

How to Build a Dashboard in Google Appscript | Free Code

Apps Script CRUD & Dashboards
Free
Watch Video
Build a Complete Dynamic CRUD Web Dashboard using Google Sheets + Apps Script + React | E14

Build a Complete Dynamic CRUD Web Dashboard using Google Sheets + Apps Script + React | E14

Apps Script CRUD & Dashboards
View price
Watch Video
How to Build DYNAMIC CRUD Admin Panel with Import/Export | Google Sheets Dashboard | D45

How to Build DYNAMIC CRUD Admin Panel with Import/Export | Google Sheets Dashboard | D45

Apps Script CRUD & Dashboards
View price
Watch Video
Google Sheets Web App: Display Filtered Data Using Apps Script | D12

Google Sheets Web App: Display Filtered Data Using Apps Script | D12

Apps Script CRUD & Dashboards
Free
Watch Video
Build a Dynamic CRUD Web App Dashboard: Admin & User Roles with Google Sheets & Apps Script | C46V3

Build a Dynamic CRUD Web App Dashboard: Admin & User Roles with Google Sheets & Apps Script | C46V3

Apps Script CRUD & Dashboards
View price
Watch Video
Build a Complete Dynamic Admin & User CRUD Web App with Google Apps Script | C46V2

Build a Complete Dynamic Admin & User CRUD Web App with Google Apps Script | C46V2

Apps Script CRUD & Dashboards
View price
Watch Video
How to Make a Complete CRUD App Using Apps Script & DataTables | All in One Crud Web App | C46

How to Make a Complete CRUD App Using Apps Script & DataTables | All in One Crud Web App | C46

Apps Script CRUD & Dashboards
Free
Watch Video
View More
Custom development

Need this customized for your business?

Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.

400+Projects delivered
91+Countries served
Get a free quote on WhatsApp

20–30% advance to start · Clear quote before work begins · Support after delivery

What we customize

  • Features & functionsNew features, changes to existing scripts, custom formulas and automations
  • API & integrationsWhatsApp, payment gateways, CRM and more
  • Design & UI changesYour branding, layout redesign, dark mode, mobile layout
  • Full custom projectsDashboards, billing, inventory, CRM, built from scratch
Free
Source Code File

People choose these

Paid picks from the same category

Admin Dashboard with Google Apps Script & React | Complete CRUD System | E21 Admin Dashboard with Google Apps Script & React | Complete CRUD System | E21 181 views this month Apps Script Build a Complete Dynamic CRUD Web Dashboard using Google Sheets + Apps Script + React | E14 Build a Complete Dynamic CRUD Web Dashboard using Google Sheets + Apps Script + React | E14 376 views this month Apps Script How to Build DYNAMIC CRUD Admin Panel with Import/Export | Google Sheets Dashboard | D45 How to Build DYNAMIC CRUD Admin Panel with Import/Export | Google Sheets Dashboard | D45 142 views this month Apps Script

Reviews & Feedback

What buyers and YouTube viewers say about this project.

@zohairdilawar116 via YouTube
Very thoughtfully designed , Happy to see the video , Pray for your Success