Blog / Sheets

Guides for Sheets users

84 articles. Practical write-ups, kept current.

Capital costs: what to capitalise and what to put through the P&L
Roles and responsibilities: writing them so people actually use them
How to price a job: labour, materials, overhead and the margin you keep
Production scheduling software: sequencing work the shop floor can actually run
Job estimating software: pricing work from what it actually costs
Job costing software: knowing which jobs made money and which did not
Construction job costing software: tracking cost against the programme
Software license management: staying compliant without overbuying
Contingent workforce: managing the people who are not on payroll
Skills gap analysis: finding out what your team cannot do yet
Salary bands: how to build pay ranges that hold up to scrutiny
Compensation review: running the annual pay cycle fairly and on budget
Workforce planning: matching the people you have to the work ahead
Headcount planning: setting positions, budgets and hiring dates finance can trust
Picking list: what to put on it and how to order the lines
Quality control sheet: recording measurements so the data is usable later
Bid comparison: evaluating quotes fairly when they are not like for like
Production schedule: sequencing the work you can actually do
Data dictionary: agreeing what the fields actually mean
Requirements traceability matrix: proving every requirement was tested
Going concern: the assessment directors sign before the accounts
Business impact analysis: deciding what has to come back first
Planned preventive maintenance: the schedule is the whole system
HS code: a decision you record, not a number you look up once
Allergen matrix: right on the day the recipe changes, or wrong
Statutory books: the records a buyer will ask for first
ALCOA principles: the test any record has to pass
GDPR gap analysis: finding what is missing before someone else does
ISO 27001 risk assessment: risks that name an asset, a threat and a consequence
Risk control matrix: one row per risk, one control that actually addresses it
Balance sheet reconciliation: proving the number, not just agreeing with it
Bill of quantities: pricing the same job the same way twice
Borrowing base certificate: the number the lender actually funds against
Device master record: the recipe somebody else has to follow
Gage R&R: measuring whether your measurements mean anything
IT asset management: the lifecycle, not the spreadsheet
CycloneDX and SPDX: choosing an SBOM format
BOM management: keeping one version true across four departments
Cap table: the document every future round is reconstructed from
Pro forma cap table: modelling the round before you agree the terms
CAM reconciliation: the annual true-up tenants actually check
Experience modification rate: the number that prices your payroll
Form 5500: the annual return that is also a public document
941 Schedule B: reporting liability by day, not deposits
PCI compliance checklist: the recurring tasks behind the annual sign-off
Denied party screening: strict liability, so keep the evidence
Chargeback reason codes: what the number is actually asking you for
Economic nexus: the thresholds that decide where you must register
Unclaimed property reporting: the annual cycle, state by state
Davis-Bacon wage determination: reading it before you bid
CAIQ: the cloud questionnaire worth filling in before anyone asks
FMEA: the analysis is worth what the actions are worth
Certificate of insurance tracking: the expiry nobody notices
OSHA 300 log: what gets recorded and what does not
IFTA reporting: the quarterly return and the records behind it
Master bill of lading vs house bill of lading
Budget vs actual: the monthly comparison that catches problems early
Stocktake: counting what you have without closing for a week
Working capital: the money tied up in running the business
Break-even analysis: the number that tells you whether the price works
Cash flow forecast: the thirteen weeks that decide whether you survive
Media plan template: deciding where the budget goes before it goes anywhere
Supply chain management: the moving parts a small operation actually tracks
KPI dashboard: fewer numbers, checked more often
Warehouse management: the part inventory software does not cover
Cash flow statement: where the money actually went
Customer satisfaction score: measuring CSAT so it changes something
Monthly recurring revenue: calculating MRR so the number means something
Competitive pricing: using rivals as one input, not the answer
SWOT analysis: making one that produces decisions, not adjectives
RACI matrix: settling who decides before the project needs it
Capacity planning: knowing what you can actually take on
Sales forecast template: building one you can defend in a review
Sales report template: the numbers worth reporting weekly
Daily sales report: what a shop or small team should log each day
Editorial calendar: planning content you will actually publish
Shortlisting: getting from fifty applications to five fairly
Days sales outstanding: the number that tells you how you are really paid
Financial projections template: building a forecast you can defend
Employee time tracking without buying a system for it
Inventory management: the small-business version that actually gets kept
Google Sheets templates: which ones are worth using, and how to keep them portable
Introducing real-time collaboration in Sheets
From spreadsheet to dashboard in minutes

About Ettex Sheets All topics

Guides for Sheets users

See all features

Rich text editing

Comments & mentions

Version history

Real-time collaboration

Templates

Export to DOCX/PDF/ODT/MD

Document outline

Styles & themes

Find & replace

Word count

Page setup

Offline access