Consultancy Billing System
Stop chasing hours in spreadsheets. Track time, generate PDF invoices, and get paid faster — all from Google Sheets, for the cost of a single billable hour.
A complete billing dashboard for freelance consultants and boutique agencies. Log hours against multiple clients with different day rates, generate branded PDF timesheets and invoices with automatic VAT calculations, track overdue payments, and see your revenue at a glance — all inside your own Google Workspace. No monthly fees. No server to maintain. One purchase, you own it forever.
The Problem
Why this matters
You're a consultant or small agency, and billing is eating your evenings. Hours are scattered across notebooks and spreadsheets. Each client has a different day rate, VAT arrangement, and payment term — but you're building invoices by hand in Google Docs or Word, copy-pasting totals, and hoping the maths is right. By the time you've formatted the PDF and chased a late payment, you've burned an hour of unpaid admin. Meanwhile, 'proper' invoicing software costs $15–$50 per month, locks your financial data on someone else's servers, and half the features are overkill for a 3-person team. You don't need a SaaS empire — you need a system that turns logged hours into sent invoices in under a minute.
The Solution
How we solve it
Consultancy Billing System is a self-contained billing dashboard that lives right inside your Google Workspace. Open the web app, log your hours with a description and category, and the system tracks everything against each client's unique day rate. When the week ends, click Generate Timesheet — a professional PDF is created, totalled, and saved to Google Drive. Ready to bill? Click Generate Invoice — VAT is calculated, bank details are pre-filled, and the PDF is stored in a client-specific folder. The dashboard shows you exactly who owes what, which invoices are overdue, and how your revenue has trended month by month. Your data never leaves your Google Drive. There's no server to configure, no subscription renewal email, and no third party who can see your financials.
The Results
What you get
- Go from logged hours to a sent PDF invoice in under 60 seconds
- $0/month forever — one payment replaces $180–$600/year in invoicing SaaS subscriptions
- See overdue invoices, outstanding amounts, and revenue trends the second you open the dashboard
- Automatic VAT calculations — set each client's rate once, never do the maths manually again
- Every timesheet and invoice is saved as a PDF in your own Google Drive — exportable, auditable, yours
- Dark and light mode for comfortable use during late-night billing sessions or bright offices
Interactive Product Tour
A click-through demo with realistic sample data. Browse tabs, filter tables, explore the UI. Save, import, and other write actions happen for real in the live app — one click away.
Key Features
Time Tracking That Takes Seconds, Not Minutes
Open the Time Entry page, pick the client, enter hours with a description and category (Design, Development, Meeting, Travel, Admin), and hit Add. Entries are tracked as billable or unbillable, so you always know how much to invoice — and how much time went to overhead.
Multi-Client Rate Management
Each client gets their own profile with a unique day rate, VAT percentage, contract type, and NEC status flag. Add unlimited clients, set individual billing terms, and the system applies the right rate to every timesheet and invoice automatically.
One-Click PDF Timesheets & Invoices
Generate branded, calculation-ready PDF timesheets grouped by week, or full invoices with line items, VAT breakdown, bank details, and company registration info — all auto-populated from your settings. PDFs are saved to client-specific Google Drive folders for easy retrieval.
Revenue Dashboard With Overdue Tracking
See your financial health at a glance: active clients, hours logged this month, outstanding invoices, total paid revenue, and a dedicated overdue invoices panel that shows exactly which payments are late and by how many days. Bar charts show monthly revenue trends; progress bars break down hours by client.
Reports & Analytics
A dedicated Reports page with total invoiced vs. paid breakdowns, revenue by client tables, hours-by-client progress charts, and monthly trend visualizations. Export any report as CSV for your accountant or end-of-year filing.
Light & Dark Mode
A modern interface that works however you like to work — toggle between light and dark mode with one click. Your preference is saved and remembered across sessions.
Your Data, Your Google Drive
Every timesheet, invoice, and client record lives in your own Google Sheets and Drive. No third party (including us) can see your financial data after purchase. Google's built-in version history acts as your automatic backup.
Fully Configurable & Extensible
Set your company name, email, bank details (name, account, sort code), VAT registration number, payment terms, and currency from the Settings page. Since you get 100% unobfuscated source code, you or any developer can add custom modules — recurring invoices, email reminders, multi-currency support.
Google Workspace Integration
Works seamlessly with your favorite Google apps
What Does It Bring to Your Business?
Real business value, not just cool tech
Pay Once, Invoice Forever
A single one-time payment replaces $15–$50/month invoicing subscriptions. That's hundreds of dollars saved in the first year alone — and you never pay us again.
Your Financial Data Stays Private
Your invoices, rates, and client details live in your own Google Drive. No third-party SaaS can mine your billing data, discontinue your account, or raise prices on you.
From Hours to Invoice in 60 Seconds
Stop rebuilding PDFs from scratch. Log your hours during the week, click Generate, and a branded, VAT-calculated invoice is in your Drive ready to send.
100% Yours to Modify
The source code is unencrypted, readable JavaScript in your own Apps Script. Add custom fields, change the PDF layout, or build integrations — no reverse engineering needed.
Simple Pricing
Choose the plan that fits your needs
Standard
Script only — install it yourself, no support
- Interactive dashboard with revenue charts & overdue tracking
- Unlimited clients with individual day rates & VAT
- One-click PDF timesheet & invoice generation
- Reports & analytics with CSV export
- Dark & light mode
- Company, bank & VAT settings panel
- Client search, filter & inline editing
- Mobile-responsive web app interface
- 100% unobfuscated source code — yours forever
- 1 year of free updates (renewal at 50% after)
Managed
Script + professional installation + 2 weeks free support
- Everything in Standard
- We install the script in your Google Workspace
- We configure your system settings & up to 5 initial clients
- 2 weeks of priority support
Custom+
Everything in Managed + custom features built on top
- Everything in Managed
- Custom feature development on top of the script
- Tailored to your specific workflow
- Delivered via Upwork (escrow protection)
- Full source code ownership
Frequently Asked Questions
Everything you need to know
Not at all. You copy a Google Sheet template, open the Apps Script editor, paste the code, and click Deploy. The whole process takes about 10 minutes following our step-by-step guide with screenshots. If you'd rather skip setup entirely, our Managed plan includes professional installation — we do everything for you.
Everything — timesheets, invoices, client records — lives in your own Google Drive and Google Sheets. After purchase, MageSheet has zero access to your data. We can't see your invoices, revenue, or client details even if we wanted to. Google's built-in version history acts as your automatic backup.
Yes. The PDF template is generated in Apps Script code, so you can change fonts, layout, logo, colors, and add custom fields. If you're not comfortable editing code, our Custom+ tier covers design changes — or any developer familiar with Apps Script can do it.
No arbitrary limits. You can add as many clients, timesheets, and invoices as you need. The only technical ceiling is Google Sheets' standard limits (10 million cells), which is more than enough for years of billing at any boutique consultancy.
Yes. Each client profile has its own VAT percentage. When you generate an invoice, the system calculates the correct VAT automatically based on that client's rate — including zero-rated or VAT-exempt clients.
The system supports currency setting (GBP, USD, EUR) from the Settings page. All invoices and reports display in your chosen currency. If you need to invoice different clients in different currencies simultaneously, that's a straightforward Custom+ addition.
Yes. The web app interface is fully responsive — it works on desktop, tablet, and mobile browsers. You can log time from a client site on your phone and generate invoices from your laptop at home.
The dashboard automatically flags invoices that are past their payment due date. You see a dedicated red-bordered panel showing the invoice reference, client name, amount, and exactly how many days overdue. No manual tracking needed — the system watches your payment terms for you.
Your purchase includes 1 year of free updates — new features, bug fixes, and improvements. When a new version ships, you get the updated files and a guide to apply them. After year 1, you keep your version forever; renewal is available at 50% of the then-current price.
Absolutely. Since you get 100% unobfuscated source code, you can modify anything yourself. Or choose our Custom+ tier — we build on top of the base system via Upwork (escrow-protected) for things like recurring invoices, 3rd party API integrations, or mass data migration. Note: The Standard and Managed tiers cover script installation only; bespoke development or extensive data entry is scoped separately.
Ready to get Consultancy Billing System?
Starting from $49