I will build a google sheets cash reconciliation system

Japan

I speak Indonesian, English, Japanese

1 order completed

Data Analyst and Spreadsheet Specialist

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 da...
About this Gig

Stop guessing at the end of the day. Know exactly how much cash each location and each cashier should have deposited, and what actually came in.


I build a cash deposit system in Google Sheets with a simple phone form for your staff:


Cashiers submit the day's cash in under a minute (location, cashier, counted amount, note)

Difference vs expected cash calculated automatically: Balanced, Over or Short

Dashboard by day, location and cashier, with short days flagged for review

Multiple locations in one system, compared side by side

Staff only use the form; formulas and history stay protected

Premium: expected cash pulled from your POS (Clover or Square, if API access is available), so nobody types sales totals


Based on a system I built for a two-location bakery that uses it every day and has extended it over several phases.


Everything stays in your own Google account. No passwords needed.


Please message me before ordering with:

Number of locations and cashiers

Your POS (Clover, Square, other)

How you track deposits today

Technology:

Google Sheets

Expertise:

API integration

•

Data acquisition

•

Data flow

My Portfolio