Thursday, 22 August

Good morning

Workflow

Order pipeline

This month

Financial overview

EUR

Latest activity

Recent orders

Priorities & alerts

My Tasks

Everything needing your attention, in one place.

Data connection

Google Sheets Sync

Preview incoming changes and send app updates back to a dedicated sheet tab.

Connection

Order sheet

Not connected

The sheet must be accessible to the server. A standard Google Sheet link is converted to a read-only CSV export automatically.

This endpoint writes app changes to an App Orders tab without changing the original order tab.

For automatic notifications and write-back, download the Apps Script template.

Safe by default

Nothing changes during preview

  • Orders are matched by JH order number.
  • Blank spreadsheet cells never erase app data.
  • New orders are selected automatically.
  • Potential conflicts require explicit selection.
  • App-only fields, artwork, payments and costs are preserved.

Product master

Products + Pricing tabs

Match variant codes, wood, format, thickness, and internal costs before updating the catalog.

Management reporting

Finance

Revenue, cash, receivables, discounts, repairs, and order profitability.

Performance

Revenue and payments

RevenuePayments

Cash collection

Receivables ageing

Commercial impact

Discounts and repair costs

Order economics

Profitability by order

Order / clientInvoiceNet revenueReceivedOutstandingCostsRepairsProfitMargin

Expense ledger

Costs

Record supplier expenses, German input VAT, payment status, and related orders.

DateSupplier / descriptionPaid byCategoryScheduleOrderStatusNetVATGross

Purchasing contacts

Suppliers

Manage supplier details, terms, recurring expenses, and spending history.

SupplierPaid byContactDefault categoryTermsCostsNet spendRecurringStatus

Team collaboration

Ideas & Projects

Discuss ideas, agree decisions, assign actions, and move approved work forward.

OrderClient / projectStatusOwnerNetOutstandingDue

After-sales workflow

Repairs and requests

Track every repair, complaint, replacement, and additional client demand.

RequestOrder / clientTypeStatusPriorityAssigned toTarget
ClientCRM stageType / contactOrdersNext follow-upLatest orderTotal valueOutstanding

Internal product catalog

Products and variants

Choose the correct model, wood and size before adding it to an order.

0 models 2 wood types 4 menu sizes
Prices shown in EUR, including German VAT Open storefront ↗

Order details

New order

Catalog items

Ordered products

Products can only be selected from the Products catalog.

Personalised graphics

Add artwork

Artwork file
Drop an image or vector hereor click to choose SVG, AI, EPS, PDF, PNG, JPG, or PSD