Enter your Supabase project credentials to connect the database. You only do this once.
CREATE TABLE invoices (
id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
month text NOT NULL,
vendor text NOT NULL,
invoice_num text,
due_date date,
invoice_amount numeric DEFAULT 0,
amount_paid numeric DEFAULT 0,
status text DEFAULT 'Open',
pay_agreement text,
remarks text,
created_at timestamptz DEFAULT now(),
updated_at timestamptz DEFAULT now()
);
ALTER TABLE invoices ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all" ON invoices FOR ALL USING (true) WITH CHECK (true);
| Vendor | Invoice # | Invoice date | Due date | Days | Invoice amt | Paid | Outstanding | Status | Current | 1–15d | 16–30d | 31–60d | 61–90d | 90+d | Category | Pay Agreement | Remarks | Source |
|---|
| Vendor | Invoices | Total Invoiced | Total Paid | Outstanding |
|---|
| Invoice Date | Payment Date | Type | Reference | Description | Invoice Amt (₦) | Debit (₦) | Credit (₦) | Balance (₦) |
|---|
⚠ Invoices overdue beyond 90 days — immediate attention required
| Vendor | Invoice # | Due date | Days overdue | Invoice amt | Paid | Outstanding | Status | Category | Pay Agreement | Remarks |
|---|
| Guest Name | Folio # | Room | Amount (₦) | Reason | Status | Expected Date | Method | Remarks |
|---|
Register approved vendors. Only Active vendors appear in invoice dropdown.
| Vendor Name | Category | Contact | Phone | Terms | Bank | Account # | Status | Remarks |
|---|
All payment transactions recorded in the system
| Date & Time | Vendor | Invoice # | Action | Amount (₦) | Total Paid (₦) | Status | Reference | Role | Remarks |
|---|
AP Officer forwards batches to Finance Rep for payment processing
| Batch # | Date Forwarded | Invoices | Total Amount | Forwarded By | Status | Acknowledged By | Ack. Date | Action |
|---|
| Vendor | Invoice # | Invoice Date | Category | Amount | Remarks | Action |
|---|---|---|---|---|---|---|
| No invoices on hold | ||||||
| PO Ref | GRN Ref | Invoice # | Vendor | Amount | Status | Date Received | Action |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Select invoices to forward to Finance Rep for payment processing.
| Vendor | Invoice # | Invoice Date | Category | Amount | Status |
|---|
| Vendor | Invoice # | Invoice Date | Category | Amount | Status | Action |
|---|
| Guest Name | Folio # | Room | Amount | Reason | Method | Status | Action |
|---|
👤 AP OFFICER
• Add Vendor — Go to Vendor Master tab → + Add Vendor. Register all suppliers before raising invoices.
• Add Invoice — Tap + Add Invoice. Select vendor from dropdown, fill in details, save.
• Record Payment — Tap the Pay button on any invoice row to update payment amount and status.
• Edit Invoice — Tap any invoice row to edit details (locked once marked Paid).
• Edit Vendor — Go to Vendor Master → tap any vendor row to edit.
• Filter by Vendor — Type vendor name in the search box → table shows only that vendor → tap Print.
💼 FINANCE REP
• View all invoices, metrics and reports.
• Add Comment — Tap any invoice row to add a remark/comment for AP Officer.
• Share Report — Tap Share Report to copy the link or download a snapshot.
• Export to Excel or CSV for further analysis.
📊 FC
• View all invoices and metrics.
• Print or save PDF summary for management meetings.
📋 TABS
• Aging Report — Full invoice list with aging buckets. Filter by status, bucket, category or vendor.
• By Vendor — Summary per vendor. Tap any vendor to filter aging report.
• Critical (>90d) — Invoices overdue more than 90 days. Requires urgent action.
• Guest Refunds — Track refunds owed to guests. ⚠️ shows when overdue.
• Vendor Master — Approved vendor list. Only Active vendors appear in invoice dropdown.
🔒 FRAUD CONTROLS
• Once an invoice is marked Paid it is permanently locked — no edits allowed.
• A confirmation popup appears before locking any invoice as Paid.
Ask Executive (GM/MD) to fund a bank account. Once approved, the funds are treated as received and posted immediately.