THE BOLD STROKES

Studio Project Tracker
Sign in to access your projects, clients and invoices.

Dashboard

Brand / Action Completed / Paid Pending / Attention In Progress / Info
Tasks
0
Completed
0
Posters / Creatives
0
Videos / Reels
0
Billing
₹0

Client-wise billing —

Deliverable summary

Recent tasks

TaskClientMovie / ProjectStatusAmount
0 selected
TaskClientMovie / ProjectStatusStartEndTypeAmountEmployee IDDelivery

Clients

Clients are reusable across every monthly folder.
0 selected
ClientContactEmailPhoneTasks — current monthBilling — current monthMain Data ReportExternal ReportActions

Movies / Projects —

Movie/project names are taken from tasks. Add them while creating a task.

Monthly Archive

Each month is a separate folder-like workspace. Nothing from previous months is mixed into the current dashboard.

Reports —

Average task value
₹0
Pending billing
₹0
Completed billing
₹0
Projects
0
Clients
0
Movie / ProjectTasksPosters / CreativesVideos / ReelsOtherBilling

Invoice Generator

Using your supplied The Bold Strokes invoice template. Select a client and billing scope. The invoice below uses the supplied The Bold Strokes invoice template and pulls the selected client's tasks automatically.

Select Tasks

Choose one or more recent tasks. Selected tasks are used directly for the invoice.
TaskClientProjectDateAmount
0 selected

Invoice Register

Global numbering is never reused, even if a saved invoice is deleted.
0 selected
InvoiceClientBilling ScopeTotalSavedActions

Outsource Employee Work Statement

Select approved/main tasks, enter the external employee details, and create a numbered statement.
TaskClientProjectAmount

Outsource Statement Register

Searchable saved statements. Deleting a record never reuses its number.
0 selected
StatementEmployeeTasksTotalCreatedAction

Approval Queue

Employee deliveries submitted for admin review.

Employee Chat

Standalone conversations with employees and live message notifications.
TEAM WORKSPACE

Employees

Manage your team, approvals, conversations and payments from one clean workspace.

Employee Register

A compact people-first view. Open an employee to edit or assign work.
0 selected

Performance Snapshot

Current workload and approved payable value.

Assign Task

Send a clear brief directly to an employee.
SHAREPOINT · ONEDRIVE · V8.0
Secure task resourcesCreate a secure resource link from the OneDrive connected to SharePoint.

Employee Chat

A social-style conversation instead of a server log.
● Live

Employee Task Ledger

Track every employee's tasks by month from one master task dataset. No separate sheet is required for each employee.
Showing all employee tasks
S.NoTask IDEmployeeClient / ProjectTaskAssignedStatusEmployee AmountPaymentActions

Incoming Messages

Recent employee messages first. Older messages continue on the next page.
TimeEmployeeTaskMessageAction

Approval Queue

Employee deliveries submitted for final approval appear here.
0 selected
EmployeeTaskProject / ClientDueRateStatusApprovalResourceDeliveryActions

Share Files

Private files are shared only with the selected employee.
EmployeeFileTaskUploaded byDateOpen

Employee Statements Archive

Statements generated in the Employee Portal are saved here and searchable by statement ID, employee or month.
Statement IDEmployeeMonthTotalPaidBalanceGeneratedActions

Employee Payments

Generate a branded monthly statement matching the main invoice style.
EmployeeMonthTaskApproved amountPaymentAction

Data Inspection

Inspect tracker data directly inside the web app. No need to open Google Sheets for routine checking. Use the views below for month, client, employee and combined employee-client-month analysis.
Showing all data
This section is an inspection and management view of the data already available to the web app: main tasks, employee tasks, employee payments and imported external task data. Editing a task uses the existing task editor; this section does not create a separate dataset.
S.NoSourceTask IDMonthClientProjectEmployeeTask / DeliverableStatusAmountPaymentAction

Activity Log

A chronological record of important Admin and Employee actions for review and accountability.
TimeUserActionDescriptionTask
Loading activity…
CONNECTED STORAGE

Cloud Files

Browse and manage your connected cloud files without leaving Studio.
Connecting to cloud files…
CURRENT FOLDER—
Drop files here to uploador choose Upload Files
Open Cloud Files to load your connected storage.
Files remain in the connected cloud account. Reconnect the drive from SharePoint if access needs to be refreshed.
G

Google Account & Sheets — Automatic Sync

Connect the Google account that owns or has access to your studio spreadsheet.
Not connected
Use a folder you control. The app will create the contract backup structure inside it automatically.
The account you choose in Google's sign-in window is the account used for the Sheet connection. The app does not ask for your Google password. For the live connection, a Google Cloud OAuth Web Client ID must be configured for this site's domain, and the Sheet must be accessible by that account. The Sheet ID is the part between /d/ and /edit in the Google Sheets URL.
BACKUP HEALTH
Not connected — no Google backup check has been completed.

External Database

Upload an external CSV / Excel sheet as a separate dataset. Columns are automatically mapped into the studio structure, each row receives a separate External Task ID, and external records never overwrite Main Tasks.
EXTERNAL DATASET
0 selected
SelectMonthSourceRowsColumnsImportedClient ReportsAction
Standardized external columns: External Task ID, Task, Client, Project, Status, Start Date, End Date, Deliverable, Amount, Delivery Link, Notes. Unrecognised source columns are retained after these fields so no uploaded information is silently lost.

Data / Backup

This version stores data locally in the browser. Use JSON backup regularly. Google Sheets uses month-wise tabs. The Main Sheet syncs two-way automatically; the Separate Backup Sheet is mirrored automatically after each successful Main Sheet sync.

Google Sheet structure

The Google Sheet uses one master table ALL TASK DATA plus live MONTH VIEW and CLIENT VIEW tabs. Select a month/client from the dropdowns instead of creating a new tab for every month. New tasks automatically appear in the master table and the views, and Google Sheet edits can be imported back into the tracker.

Client Agreements

Client service agreements are managed separately from employee agreements.
01

Client Agreement Setup

Choose the exact client-facing document. Employee fields and employee workflows are not used here.

02

Client Details

The contracting client or production entity.

03

Project & Commercial Terms

Only the commercial information applicable to the client project.

04

Scope, Deliverables & Approval

Define exactly what The Bold Strokes is engaged to deliver.

05

Rights, Confidentiality & Termination

Commercial and legal provisions for the client relationship.

06

Custom Clauses

Add only clauses relevant to this client agreement.

07

The Bold Strokes

Company details printed on the agreement.

LIVE AGREEMENT PREVIEW
08

Saved Client Agreements

Client agreements are separate from employee agreements and use their own document types.

Admin Center

Manage public client-report links. Revoked links stop working on the server.

Change Admin Password

Change the login password without editing index.html. The new password is stored securely on the server.

Full System / Site Backup

Creates one complete backup containing the deployed site code, PHP files, tracker data, employee register, employee tasks, payments/statements, agreements, local data, uploaded employee files, and a restorable snapshot of both configured Google Sheets. Google OAuth tokens and passwords are excluded.
Safety: restoring first creates an automatic rollback backup on the server. Full-site backups created by this version also restore the saved tracker/browser data and the backed-up Google Sheet contents to the currently configured Main and Backup spreadsheets.

Global ID Search

Search Task IDs from Main / Employee / External data, canonical Client IDs (TBS-CLI-####), canonical Employee IDs (TBS-EMP-####), client names, or employee names. Client/employee ID results also show the latest task.

Client Report Social Embed Banner

Upload the image that should appear when a public client-report link is shared on WhatsApp, Facebook, LinkedIn and other platforms that read Open Graph metadata.
No custom social embed banner uploaded.
0 selected
SelectClientMonthSourcePublishedReport LinkStatusAction
Open Admin Center to load reports.