Gym
Kelola operasional gym dari satu template — membership, penjualan produk, inventory, invoice otomatis, sampai cashflow. Bisa dipakai langsung di Google Sheets, atau lewat Panel Apps Script biar input makin gampang.Manage your gym's operations from one template — membership, product sales, inventory, automatic invoices, and cash flow. Use it right inside Google Sheets, or through the Apps Script Panel to make input even easier.
Apa Aja yang Bisa Dikelola?What Can You Manage?
Ketuk tiap bagian buat lihat tampilan & fungsinya. Modul bertanda toggle bisa dipakai lewat Spreadsheet atau Panel.Tap each part to see its look & function. Modules with a toggle can be used via Spreadsheet or Panel.
Dashboard
Ringkasan performa gym dalam satu layarGym performance in one screen
Member aktif, pemasukan, dan stok produk kepantau sekaligus — langsung tau kondisi gym tiap periode.Active members, income, and product stock all monitored at once — know your gym's state each period at a glance.
- Member aktif & yang mau expiredActive members & those about to expire
- Pemasukan membership + produkIncome from membership + products
- Ringkasan cashflowCash flow summary
Payment Membership
Bayar & perpanjang membershipPay & renew membership
Catat pembayaran membership tiap member — perpanjangan otomatis ngitung masa aktif, jadi gak ada lagi yang kelewat.Record each member's membership payment — renewals calculate the active period automatically, so nothing slips by.
- Pembayaran & perpanjangan membershipMembership payment & renewal
- Masa aktif kehitung otomatisActive period calculated automatically
- Input via Spreadsheet atau PanelInput via Spreadsheet or Panel
List Member
Check status, kategori member dan paymentCheck status, member category & payment
Semua data member terpusat — status aktif, tanggal gabung, sampai masa berlakunya kelihatan rapi.All member data centralized — active status, join date, and validity period, all neatly visible.
- Data member terpusatCentralized member data
- Status aktif / non-aktifActive / inactive status
- Masa berlaku per memberValidity period per member
Penjualan ProdukProduct Sales
Jual produk, stok berkurang otomatisSell products, stock drops automatically
Jual produk gym (suplemen, minuman, merch) langsung kecatat dan otomatis ngurangin stok inventory.Sell gym products (supplements, drinks, merch); they're recorded instantly and automatically reduce inventory stock.
- Transaksi penjualan produkProduct sales transactions
- Stok otomatis berkurangStock decreases automatically
- Input via Spreadsheet atau PanelInput via Spreadsheet or Panel
Invoice OtomatisAutomatic Invoice
Invoice kebuat otomatis tiap transaksiInvoices created automatically per transaction
Tiap transaksi langsung jadi invoice yang rapi — tinggal cetak atau share ke member, gak perlu bikin manual.Every transaction becomes a tidy invoice instantly — just print or share it with the member, no manual work.
- Invoice otomatis per transaksiAutomatic invoice per transaction
- Rapi & siap cetak / shareTidy & ready to print / share
- Nomor invoice berurutSequential invoice numbers
List Inventory
Pantau stok produk & perlengkapanTrack product & equipment stock
Pantau stok produk & perlengkapan gym — kelihatan mana yang mulai menipis sebelum kehabisan.Track gym product & equipment stock — see what's running low before it runs out.
- Stok masuk & keluarStock in & out
- Kelihatan kalau stok menipisLow-stock visible
- Input via Spreadsheet atau PanelInput via Spreadsheet or Panel
Cashflow
Pemasukan & pengeluaran gym terpusatGym income & expenses centralized
Semua pemasukan & pengeluaran gym tercatat terpusat — arus kas jelas tiap periode buat ambil keputusan.All gym income & expenses recorded centrally — clear cash flow each period for decision-making.
- Pemasukan membership + produkIncome from membership + products
- Pengeluaran operasionalOperational expenses
- Saldo otomatis terupdateBalance updates automatically
Setup Data
Konfigurasi awal sekali di depanOne-time initial configuration
Atur data awal sekali di depan — jenis & harga membership, daftar produk, dan stok awal — biar semua perhitungan jalan otomatis.Set your initial data once up front — membership types & prices, product list, and starting stock — so all calculations run automatically.
- Jenis & harga membershipMembership types & prices
- Daftar produk & stok awalProduct list & starting stock
- Input via Spreadsheet atau PanelInput via Spreadsheet or Panel
Review PenggunaUser Reviews
"Dulu data member berceceran, sering lupa siapa yang udah expired. Sekarang semua kepantau, tinggal perpanjang dan masa aktifnya ngitung sendiri.""Member data used to be scattered and I often forgot who had expired. Now it's all monitored — just renew and the active period calculates itself."
"Jualan suplemen sama minuman sekarang kecatat rapi dan stok otomatis kepotong. Gak ada lagi barang ilang gak jelas pas stok opname.""Supplement and drink sales are neatly recorded now and stock deducts automatically. No more items mysteriously missing at stock-take."
"Suka banget bisa pilih — kadang input langsung di sheet, kadang lewat panel pas lagi buru-buru di depan member. Dua-duanya gampang.""I love being able to choose — sometimes I input straight in the sheet, sometimes via the panel when I'm rushing in front of a member. Both are easy."
"Invoice otomatis bikin keliatan lebih profesional. Member tinggal dikirim, gak perlu bikin manual satu-satu tiap transaksi.""Automatic invoices make it look more professional. I just send them to members — no making each one by hand every transaction."
"Akhirnya cashflow gym keliatan jelas tiap bulan. Pemasukan membership sama produk langsung ketara, keputusan jadi lebih cepet.""Finally the gym's cash flow is clear every month. Membership and product income show up right away, so decisions come faster."
"Dulu data member berceceran, sering lupa siapa yang udah expired. Sekarang semua kepantau, tinggal perpanjang dan masa aktifnya ngitung sendiri.""Member data used to be scattered and I often forgot who had expired. Now it's all monitored — just renew and the active period calculates itself."
"Jualan suplemen sama minuman sekarang kecatat rapi dan stok otomatis kepotong. Gak ada lagi barang ilang gak jelas pas stok opname.""Supplement and drink sales are neatly recorded now and stock deducts automatically. No more items mysteriously missing at stock-take."
"Suka banget bisa pilih — kadang input langsung di sheet, kadang lewat panel pas lagi buru-buru di depan member. Dua-duanya gampang.""I love being able to choose — sometimes I input straight in the sheet, sometimes via the panel when I'm rushing in front of a member. Both are easy."
"Invoice otomatis bikin keliatan lebih profesional. Member tinggal dikirim, gak perlu bikin manual satu-satu tiap transaksi.""Automatic invoices make it look more professional. I just send them to members — no making each one by hand every transaction."
"Akhirnya cashflow gym keliatan jelas tiap bulan. Pemasukan membership sama produk langsung ketara, keputusan jadi lebih cepet.""Finally the gym's cash flow is clear every month. Membership and product income show up right away, so decisions come faster."