Ntobua - District Local Revenue

Important Notice

Before sending SMS Bill Notices, please ensure:

All bills have been generated as PDFs
The quality of all bills has been verified

SMS Testing

SMS Bill Notices (Bulk)

Bill Notice : Sample SMS Body

The STMA wishes to remind you of your Business Operating Permit payment of Ghc200
Location : Kodwokrom Ave.
Account number (SubUPN) : 641-0548-0187-1.
Hard Copy Bills will be sent to you in due time.
Helpline: Help Desk : 0312299552.
Thank you.

Defaulters Notice : Sample SMS Body

PROPERTY RATE BILL From HOHOE MUN.
Bill Date: Jan - Dec 2021
Account No: 884-0792-0394
Owner: ADZOKATSE WISDOM
Arrears: GHS 240.00
Current: GHS 15.00
Total: GHS 255.00
Visit Municipal Assembly for payment. Always request receipt.
Helpline: 0204696925

Open SMS

Message Content

Send to All Rate Payers

Business Categories

Property Categories

Parcel Map
Collector Zones

Browse files... (.shp .shx .dbf .prj or .zip)

Map each shapefile attribute to the corresponding database column. Geometry is mapped automatically.

Database Column	Shapefile Attribute
`UPN` (varchar 15)
`Address` (varchar 50)
`street` (varchar 50)
`housenumber` (varchar 50)
`Landuse` (varchar 50)
`ParcelOf` (varchar 200)
`sp_boundary` (polygon)	Auto-mapped from geometry

Browse files... (.shp .shx .dbf .prj or .zip)

Map each shapefile attribute to the corresponding database column. Geometry is mapped automatically.

Database Column	Shapefile Attribute
`colzonename` (varchar 100)
`sp_polygon` (polygon)	Auto-mapped from geometry

📄

Drop an Excel or CSV file here, or click to browse

Accepted formats: .xls, .xlsx, .csv · parsed in your browser, nothing is uploaded yet

Match each source column from the Excel/CSV to a property field. Unmapped columns are ignored. Each target field can be used only once.

Source column	Example (first data row)	Maps to

UPN
Sub UPN
District Name
Entry Date	2026-09-27

UPN
Acct.#
Entry Date	2026-09-27
GCR Receipt
System Receipt
Date	27-09-2026 @ 06:14:45pm
Address
Owner
Old balance *
Paid value:
New Balance *	* negative value indicates credit
Print in PDF

dLRev Reporting - Map -