Entry of arrears - LUPMISManual

Go to content

Main menu:

8. LUPMIS Tools > 8.7 Revenue Tools > 8.7.2 Entry of revenue data Manual Entry and Import of Arrears

Level of expertise required for this Chapter: Intermediate; specifically for LUPMIS @ TCPD

Arrears are debts from previous years. They can be included in the new invoices or can be ignored. This choice is made at the definition of fee-fixing (see Chapter Fee-fixing).

If arrears are considered in the debts calculation, they have to be entered in LUPMIS either through a manual entry or through import from a file with the arrears.

A) Manual entry

For a very few arrears to be entered you can choose the manual entry. Enter the UPN or SubUPN of the property (or business) to define a new 'payment', eventhough it is a debt (a kind of a negative payment).

Revenue Tools > Entry > Payment: Property (or Business) > Enter UPN > Continue

> Enter only the amount of arrears in GHc (of the previous year, of course). Don't enter any other figures or values in this screen, and Save Payment.

- - - - -

B) Import of arrears from a CSV file (from Excel)

You have to prepare an Excel file with following columns:
- UPN (and SubUPN, if applicable) (in column A [and B])
- Amount of arrears (in GHc) (in column E for payment)
- Word 'Property' or 'Business' (in column F)
- Word 'Arrears' (in column G)
- Year from when arrears is dating back (e.g. for the assessment in 2015, enter arrears year 2014) (in column O)
- Word 'Payment' in a control column at the right side (in column P)
- Control number -99 in the the very last column (column; R)

This will set the arrears as debit for the date of December 31.

It has to be saved as a CSV file with '_field_data' in its file name.

This special import can be called by ticking the box at the selection screen.


Back to content | Back to main menu