Salary Management System with Advances – Google Apps Script

A salary system that handles advances properly. Most payroll templates manage a monthly figure and leave you tracking loans and advances on paper. This one records the advance, then deducts it automatically from the next salary run.

Advances that settle themselves

An employee takes an advance; the system records it against them; the next payroll run deducts it automatically and the balance carries forward until it clears. That single feature removes the most error-prone part of small-business payroll — the mental arithmetic about who still owes what, done under time pressure on pay day.

Daily, weekly or monthly

Salary processing runs on daily, weekly or monthly cycles, so daily-wage workers and salaried staff live in the same system instead of two parallel records. For businesses with both, that is usually the reason the spreadsheet stopped working.

The record and the view

Every employee carries a complete transaction history — salaries paid, advances taken, deductions applied — so any dispute is settled by opening the record. An interactive dashboard shows key stats and trends, and payslips generate from the same data with detailed reporting behind them.

Who it suits

Small and medium businesses paying a mixed workforce, construction and labour contractors managing daily wages and advances, shops and workshops with a handful of staff, and anyone whose payroll is a spreadsheet plus a notebook of who borrowed what.

Setup

Copy the sheet, add your employees and their rates, run the first cycle. Google Sheets holds the payroll data. The video covers adding staff, processing salaries and managing advances, and support is free if you get stuck.