📱 QR Clock In/Out (Aanbevolen)
Scan de QR code bij de post. GPS wordt gechecked. Werkt op telefoon.
🔧 Handmatig clock in/out (alleen voor admin/supervisor)
🏛️ Aruba Tax Information
Under Aruban law, businesses must file a monthly turnover tax declaration (BBO/BAVP/BAZV) with the Departamento di Impuesto. The combined rate is 7% on all taxable revenue: BBO 2.5% + BAVP 1.5% + BAZV 3%. Filing deadline is the 15th of the following month.
📋 Declaration Form —
⚠️ Important — Payroll Assistant
This module calculates gross-to-net wages and generates payslips using the official Aruba 2025/2026 tax rates. You remain responsible for verifying calculations and submitting declarations to the tax authority. This is NOT a replacement for certified payroll software like Celery — use this as a pre-check, review tool, or for small operations.
🏛️ Aruba Wage Tax Overview
As an employer, you must withhold wage tax and social security premiums from employee salaries and remit these monthly to Departamento di Impuesto. This includes: Loonbelasting (wage tax, progressive rate), AOV/AWW premium (employee 5% + employer 9.5%, up to AWG 85,000), AZV premium (employee 1.6% + employer 8.9%, up to AWG 85,000). Filing deadline: 15th of following month.
📋 Declaration Form —
✏️ New Shift Report
📊 Shift Status *
📸 Photos (optional)
🚨 Major incident occurred?
📚 Alle Rapporten
ℹ️ Hoe werkt dit?
- Stel GPS in per post — ga naar Posts, bewerk de post, klik "Use my current location" terwijl je OP de post staat.
- Print de QR code hieronder → plak hem bij elke post op een duidelijke plek.
- Guard scant QR via Clock In/Out page on phone → GPS verified → clocks in.
- Done with shift? Scan same QR again → clockt uit.
ℹ️ Wat zijn checkpoints?
Plaats 3-10 QR codes binnen elke post op strategische punten (deuren, parkeerplekken, achterkant, etc.). Guards scannen ze tijdens hun rondes als bewijs van aanwezigheid. Admin ziet welke checkpoints wanneer zijn gescand.
➕ Nieuw Checkpoint
🏢 Company Information
🏛️ Aruba Tax Rates (update annually)
Aruba updates tax rates and bracket thresholds every year. Edit the values here when new rates are announced — the system will automatically use these everywhere (Payroll, Payslips, Invoices, BBO Aangifte, Wage Tax Declaration). Always verify against impuesto.aw before each new year.
💰 Loonbelasting (Wage Tax) — progressive brackets
Applied to annual income above the tax-free allowance. Edit upper limits (AWG/year) and rates.
| Bracket | Up to (AWG/year) | Rate % |
|---|---|---|
| Bracket 1 | % | |
| Bracket 2 | % | |
| Bracket 3 | % | |
| Bracket 4 (top) | Above bracket 3 | % |
👥 Social Security Premiums
AOV/AWW (pension + survivor) and AZV (health insurance). Both apply up to the premium ceiling.
| Premium | Employee % | Employer % |
|---|---|---|
| AOV/AWW (pension + survivor) | % | % |
| AZV (health insurance) | % | % |
📈 Turnover Tax (BBO / BAVP / BAZV)
Applied to all invoiced services — shown on quotes, invoices, and BBO aangifte.
| Component | Rate % | Description |
|---|---|---|
| BBO | % | Belasting op bedrijfsomzetten |
| BAVP | % | Additionele voorzieningen PPS |
| BAZV | % | Bestemmingsheffing AZV |
| Total combined | 7.0 % | Auto-calculated |
📥 Data Import (from QuickBooks or other systems)
Easily onboard from QuickBooks, Excel, or any system. Export your data as CSV, download the matching template below to see the correct columns, then upload your file. The system will preview and validate before importing.
👥 Clients
Name, contact, address, hourly rate, contract type
👮 Guards / Employees
Name, role, email, phone, ID, hourly rate, hire date
📦 Equipment
Type, serial, description, purchase date, cost
1. In QuickBooks: Reports → Customer Contact List → Export to Excel → Save as CSV
2. Download our template above to see the required columns
3. Match your QuickBooks columns to our template (rename if needed)
4. Click Import, upload the CSV, preview and confirm
Repeat for employees (Reports → Employee Contact List) and equipment/items.
🔍 Data Integrity Check
Find orphaned data — records pointing to deleted clients/posts. Useful when something looks weird.
🔄 Post-Client Reassignment Tool
If a post is showing under the wrong client, fix it here. Pick the correct client per post.
⚠️ Danger Zone — Production Reset
Wipe all data to deliver an empty system to a client. This CANNOT be undone.
👤 Nieuwe Gebruiker
Import Preview
New Client
New Post
📍 GPS & QR Clock-in
New Shift
📅 Bulk schedule
🔄 Replace guard
Add Guard
Add Equipment
New Incident Report
Log Patrol
New Event
New Quote
New Invoice
👮 Manual Clock In / Out
✏️ Edit Clock Entry
⚡ Auto-Generate Invoice from Hours
Automatically bill a client for all hours worked in a month. The system calculates totals per post based on actual clock-in data × client's hourly rate.
New Expense
New Maintenance Job
New Insurance Policy
New License
📅 Generate Guard Schedule
Generate a personal schedule PDF for a specific guard. Send it to the guard via WhatsApp or print.
👥 Per-Client Payroll Report
Generate a payroll breakdown showing how many guard-hours and labor costs were assigned to a specific client — useful for reviewing profitability per contract.