🔍 ESC
↑↓ navigate↵ openESC close
✏️ Edit
VaultMaverick
Finance & Payroll

Welcome back — sign in to continue

🔐
Two-Factor Authentication
Enter the 6-digit code from your authenticator app
🔑

Google Sheets API Setup

Enter your Google Sheets API key to connect live data

How to get API key:
1. Go to console.cloud.google.com
2. APIs & Services → Credentials → Create API Key
3. Enable Google Sheets API
4. Make your sheet public (Share → Anyone with link → Viewer)
VaultMaverick Finance & Payroll
● LIVE
Year
Month
Company
Sites
All Sites ▾
Category
All Categories ▾
Active Filters:
🛠️ Tools & Expenses
Category
Source
Type
Company
Sites
Card (last digits)
Day
Search Tools (multi-select)
💰 Payment Method Breakdown
Year
Month
Company
📈 12-Month Expense Trend
📊 Project Expenses by Category
💼 Project Cost Breakdown
🔧 Top 10 Tools by Total Cost
Year
Month
Company
👥 Team
Search Name
Search Position
Payment Type
Toggle Columns
📈 AylMonthly Grand Pay Trend
YEAR
MONTH
Method
Type
Source
Search

Payment Methods

0 active
Sorted by balance

📊 Monthly Cash Flow

All Transactions

Company
Search Name
Search Position
Show Rate In
Status
Year
Project
Compare With
🏆 All Projects Overview
📊 Monthly Profit & Loss
📋 Monthly Breakdown
🗂️ Named Transactions
Team
Month
Search
👥 Team Order Admin Only
▸
Sort with ↑↓, delete with 🗑️. New teams added from Payroll form.
👁️ Tab Visibility Admin & Finance
▸

Show or hide tabs from the navigation bar. Settings tab cannot be hidden.

🔑 Change Password
▸
Current Password
New Password
Confirm New Password
🔐 Two-Factor Authentication (2FA) Security
Protect your account with Google Authenticator or Authy
1. Scan the QR code with Google Authenticator:
2. Enter the code and confirm:
🔄 Auto Payroll Rollover Automation
▸
On the 1st of the month, automatically copies the previous month's employees into the new month. No Google Sheets sync needed.
Loading...
How it works:
• On each login the current month's payroll is checked
• If missing, automatically creates the previous month's employees with draft status
• Hour distributions and company info are copied from the previous month
• Bonuses and advances are reset (for the new month)
🔄 Google Sheets Sync Admin Only Optional
▸
Sync latest data from Google Sheets to Supabase. Rarely needed once data is in Supabase — most workflows now write directly.
📅 Sync payroll for one month only: Older months stay untouched
🗄️ Data Management
Add, edit or delete records directly from the app.
📅 New month opening balance
Copies each method's previous-month net balance to the current month as Opening Balance FD.
➕ New Transaction
Month
Year
Amount (USD)
Date
Payment Method
Transaction Type
Frequency
Coin (Crypto only)
Description
📎 Proof of Payment (prnt.sc, drive.google.com, ya da qeyd)
📥 CSV Import (Card Transactions)
Upload a bank/card CSV. Each row will be matched against Card-Rules and split across projects automatically.
Target Month
Target Year
Payment Method
📂
Click or drag CSV file here
Supports: Wio Bank, PayPal CSV formats
➕ New Expense / Tool
Date (GDay/Month/Year)
Cost (USD)
Tool Name
Category
Company
Payment Method
Sites
Frequency
Description
Notes
📥 CSV Import (Card Transactions → Tools)
Upload a card CSV. Transactions will be matched against Card-Rules and imported as tool/expense records per project.
Target Month
Target Year
Card (last 4 digits)
📂
Click or drag CSV file here
Supports: Wio Bank, PayPal CSV formats
🔒 LOCK MONTH SALARIES
Lock a completed month's payroll — writes a snapshot to Tools (category=Salaries) so reports survive even if payroll rows are later edited or deleted. Live auto-split stops for the locked month.
Month
Year
➕ Named Payroll Record
Month
Year
Employee Name
Company
Position
Rate ($/hr)
Bonus ($)
Bonus Reason / Description
advance ($)
🔐 Wallet / Payment Address
Wallet Type
👥 Team
Enter new team name (e.g. "📋 AUDIT TEAM")
Proyekt hours per project
📊 Hesablama Preview
Total Hours: 0 Grand Pay: $0.00
💰 advance Operations
Month
Year
Amount ($)
Employee
$ New advance: Amount will be added to employee's current month payroll
🏢 Company & Project Management
Existing Projects / Companies
➕ Named New Project
Project Name (short)
Full Name (optional)
Tip
Color
Payroll Column (DB key, lowercase)
GS P&L Sheet ID (optional)
➕ Named New Company
Company Name
Short Code
Color
Existing Companies (0)
📋 Rate History — Add / Update Employee Rate
Employee Name
Hourly Rate ($)
Position / Title
Company
Effective From
Effective To (optional)
Fix Settings
Standard Hours (aylıq)
Overtime Rate ($/h)
📊 Project Split (opsional)
Doldurularsa: Payroll-da Total saat avto bu faizlərə bölünür (project saatlar boş olduqda).
Cəm: 0%
Current Rates
🔐 Wallet Management — Employee Payment Addresses
Employee Name
Wallet Type
Wallet Address / Account Number
Current Wallets (${Object.keys(window._walletMap||{}).length} employees)
💳 Card Rules — CSV Import & Categorization
Card Last 4 *
Card Label
Group
Category
Sites (comma-separated)
Split %
Payment Method
Billed Company
Assigned To
Team
Notes
👤 User Management
Users
➕ New User
Username
Full Name
Password
Rol
📑 Tab Access
🔄 Sync Access
🔑 Change User Password (Admin)
User
New Password
Confirm
Your Account
🔑 Change My Password
Current Password
New Password
Confirm
🗂️ Audit Log — Who Changed What
Today
—
total actions
This Week
—
total actions
Most Active
—
user this week
Top Table
—
most edited
Table
Action
User
Date From
Date To
Search
Limit
Click Refresh to load
Audit Detail
➕ Named P&L Transaction
Month
Year
Amount (USD)
Project
Category
Sub Category