LUNAR CARGO
Payroll System
1
Setup
Configure the pay period, company details and route rates.
Pay Period
Company Details
Route Pay Rates (£) — editable
2
Drivers
Manage your active driver roster, bank details and van hire charges.
NameCodeFuel Card #Email UTRVATVAT No. Sort CodeAccount No. Van HireVan £ Next Inv #
Archived Drivers

Drivers removed from the active roster. Their details are saved — click ↩ Restore to add them back.

Import Fuel Charges (Excel)

Upload your weekly fuel Excel file. Driver names and gross totals are extracted automatically.

📊
Drop fuel Excel here
e.g. wk13_fuel.xlsx — gross totals extracted per driver
3
Rota
Assign drivers to routes. Import from Excel or fill manually.
Import Rota from Excel

Export your rota Google Sheet as .xlsx and drop it here. Routes and drivers are populated automatically — Notes/AdHoc rows are ignored.

📋
Drop Rota Excel here
Reads route rows and driver names per day
Rota Table
Wickes Route Counter

Cross-check total Wickes runs for the week.

Fill in the rota to see counts.

4
Invoices
Review driver pay, then generate self-bill invoices.
Pay Summary — Review Before Generating

Go back to the Rota and fill in driver assignments to see the preview.

Ready to generate?

Invoice numbers advance when you click. Review the pay summary above first.

5
Payments
Download Monzo-ready bulk payment CSV for direct upload.
ℹ️ The CSV uses Monzo's exact format: Payee name, Sort code, Bank account number, Bank account type, Payment reference (max 18 chars), Amount. Upload directly via Monzo Business → Payments → Bulk payment.
6
Accounting
Track income, costs and net profit. Export to your Google Sheet.
Income (enter gross amount received — VAT at 20% is extracted automatically)
DESCRIPTION GROSS (INC VAT) NET VAT COLLECTED
Fuel Costs (fuel includes 20% VAT — reclaimable)
Other Expenses

Tick the VAT box if 20% VAT is included in the amount — it will be treated as reclaimable.

DESCRIPTION AMOUNT (£) INC VAT?
Weekly P&L Summary

Add income above to see your summary.