I will a construction cash flow and control system in google sheets

H
hasan_santosa
H
hasan_santosa
Hasan Santosa

About this gig


Know How Much Cash Your Construction Business Can Safely Spend

Stop checking multiple bank accounts and spreadsheets. Get one Cash Control Center in Google Sheets to see available cash after reserves, bills, and transfers between accounts.

WHAT YOU GET

  • M1 Core Dashboard: Consolidated bank balances, reserve alerts (OK/WATCH/LOW), transaction cleanup, spending categories, and 12-month history.
  • M2 Inter-Account Loans: Track transfers, outstanding balances, and which accounts owe money to others.
  • M3 Bills & Jobs: Upcoming payments, safe-to-spend cash, and job-level cash flow visibility.
  • M4 Alerts: Low-cash warnings, overdue bill alerts, and weekly email summaries.
  • M5 Mobile Access: Check balances and record transactions from your phone.

BUILT FOR ACCURACY

  • Protected formulas and duplicate detection
  • Flags for uncategorized transactions
  • Reconciliation checks against bank totals
  • Change log showing who changed what and when
  • Easy account and category management

Everything runs in your own Google account: no monthly subscription, no new software, and you own the file.

Not sure which solution fits your business? Message me for a free consultation before ordering.

Get to know Hasan Santosa

Hasan Santosa

Data Analyst and Spreadsheet Specialist

5.0(1)
  • FromJapan
  • Member sinceOct 2025
  • Avg. response time1 hour
  • Last delivery2 weeks
  • Languages

    Indonesian, English, Japanese
I build Google Sheets and Excel systems that replace manual work: dashboards, trackers, booking and cash-flow tools, automated with Apps Script, VBA and HTML web apps. I also clean and migrate CRM data: merge duplicate contacts, extract from Gmail/iCloud, and import into Wix, Mailchimp and other CRMs with labels and segments ready. Engineer in Tokyo, 15+ years in manufacturing and process improvement. You get clear milestones, a quick start guide and support after delivery. Message me first to confirm scope.

My Portfolio