Tax payer ledger action

[rahensonzam]

Fairly major new feature request.

New action to automate collecting the reasons for changes in the amounts from the tax payer ledger.

I'll just post data and method piecemeal.

[rahensonzam]

This is all the values I could find so far for tax payer ledger page. You can see that there are sections of lines you could mix and match.

Description	Negative	Positive
TARPS Balance as of 31/10/2013	11.00	0.00
Advance payment from HENSON Ref. PRN: 100000000000 (Payment Date: 01-JAN-2013) from (Legacy Payment receipt no: 1234567)	0.00	11.00
Advance payment from HENSON Ref. PRN: 100000000000 (Payment Date: 01-JAN-2018)	0.00	11.00
Advance payment from HENSON Ref. PRN: 100000000000 (Payment Date: 01-JAN-2018) for Quarter {Q1}	0.00	11.00
Advance payment from HENSON Ref. PRN: 100000000000 (Payment Date: 01-JAN-2018) for Quarter {Q2}	0.00	11.00
Advance payment from HENSON Ref. PRN: 100000000000 (Payment Date: 01-JAN-2018) for Quarter {Q3}	0.00	11.00
Advance payment from HENSON Ref. PRN: 100000000000 (Payment Date: 01-JAN-2018) for Quarter {Q4}	0.00	11.00
Advance payment from HENSON Ref. PRN: 100000000000 (Payment Date: 01-JAN-2018) via. Reallocation	0.00	11.00
Closing Balance - 01/01/2018 to 31/12/2018	0.00
Closing Balance - 01/01/2018 to 31/12/2018		11.00
Late Payment Interest	11.00	0.00
Late Payment Penalty	11.00	0.00
Late Return Penalty	11.00	0.00
Late Payment Interest-Reversed	0.00	11.00
Late Payment Penalty-Reversed	0.00	11.00
Late Return Penalty-Reversed	0.00	11.00
Provisional Return (01/01/2018-31/03/2018)	11.00	0.00
Provisional Return (01/04/2018-30/06/2018)	11.00	0.00
Provisional Return (01/07/2018-30/09/2018)	11.00	0.00
Provisional Return (01/10/2018-31/12/2018)	11.00	0.00
Revised Provisional Return (01/01/2018-31/03/2018)	11.00	0.00
Original Return	11.00	0.00
Amended Return	11.00	0.00
Audit assessment from Audit Module (Assessment No : 10000000000000) (14 digits)	11.00	0.00
Additional assessment from Assessment Module (Assessment No : 10000000000000)	11.00	0.00
Additional assessment from Assessment Module (Assessment No : 10000000000000)(10000000000000)	11.00	0.00
Fine for Audit assessment	11.00	0.00
Being penalty amounting to 0.00 imposed under section 100(1)(e)(i)(A) for Additional assessment for the Return Period 01/01/2018 to 31/01/2018	11.00	0.00
Amended assessment from Objection And Appeals Module (Assessment No : 10000000000000)	0.00	11.00
Penalty for Amended assessment	0.00	11.00
Refund Offset (PRN: 100000000000 ,Refund Period : 01-JAN-2018 to 31-JAN-2018 )	0.00	11.00
Refund Paid	11.00	0.00
Refund Paid.	11.00	0.00
Being posting of opening balance migrated from multiple account number-10000000/100.	0.00	11.00
Being reversal of a duplicated payment for the period December 2013 receipt number 1234567.	11.00	0.00
Being reversal of a transaction processed on Tax online, replicated on TARPS for the period December 2013.	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against PRINCIPAL LIABILITY (Payment Date: 01-JAN-2018)	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against PRINCIPAL LIABILITY (Payment Date: 01-JAN-2018) for Quarter {Q1}	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against PRINCIPAL LIABILITY (Payment Date: 01-JAN-2018) for Quarter {Q2}	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against PRINCIPAL LIABILITY (Payment Date: 01-JAN-2018) for Quarter {Q3}	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against PRINCIPAL LIABILITY (Payment Date: 01-JAN-2018) for Quarter {Q4}	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against PRINCIPAL LIABILITY (Payment Date: 01-JAN-2013) from (Legacy Payment receipt no: 1234567)	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against PRINCIPAL LIABILITY (Payment Date: 01-JAN-2018) via. Reallocation	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against INTEREST (Payment Date: 01-JAN-2018)	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against INTEREST (Payment Date: 01-JAN-2013) from (Legacy Payment receipt no: 1234567)	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against LATE RETURN PENALTY (Payment Date: 01-JAN-2018)	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against LATE RETURN PENALTY (Payment Date: 01-JAN-2013) from (Legacy Payment receipt no: 1234567)	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against PAYMENT PENALTY (Payment Date: 01-JAN-2018)	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against PAYMENT PENALTY (Payment Date: 01-JAN-2013) from (Legacy Payment receipt no: 1234567)	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against ASSESSMENT LIABILITY (Payment Date: 01-JAN-2018)	0.00	11.00
Payment Reconciliation (PRN: 100000000000 ) against ASSESSMENT MANUAL PENALTY (Payment Date: 01-JAN-2018)	0.00	11.00
REVERSAL OF - Payment Reconciliation (PRN: 100000000000 ) against PRINCIPAL LIABILITY (Payment Date: 01-JAN-2018)
and reversal of all of the above

[rahensonzam]

Found one I didn't have.

Description
Being Penalty amounting 1000.00 imposed for under estimation for Provisional tax for the Return Period 01-JAN-18 - 31-DEC-18

[rahensonzam]

hopefully readable the rough kind of process I do manually

case 1

last week was zero
this week there is an amount
an increase will show in pending liabilites tab, show the period
go to the period
find the amount
no discrepancies between tax payer ledger and pending liabilites tab
write it down (details: reason, period, transaction date), done

case 2

advance payment means paid to your account but not allocated to any period or liability
is a discrepancy between tax payer ledger and pending liabilites tab (payment counts in ledger, doesn't in pending liabilites)
is a system error
write it down (details: reason,prn #, period, transaction date), done

case 3

last week there is an amount
this week is zero
an decrease won't show in pending liabilites tab
find the amount
no discrepancies between tax payer ledger and pending liabilites tab
most common reasons are payment or reversal
write it down (details: reason,[prn #], period, transaction date), done

case 4

sometimes the return is a certain amount
you pay that exact amount
the exact amount shows on the ack return
but the tax payer ledger shows the amount rounded up to the next kwacha but shows the exact payment
the pending liability tab takes it's cue from tax payer ledger so shows a liability
is a system error
is a discrepancy between tax payer ledger and pending liabilites tab
write it down (details: reason, period, transaction date)

case 5

a decrease in the amount
that amount won't show in pending liabilites tab
isolate the amount that decreased
write it down

sort by transaction date, within the last week (plus a day or two, sometimes)

[rahensonzam]

sample of how I write in excel nothing in particular I just try to be kind of consistent after I started doing it like this also try to make fit in the cells, all the lines about as wide as the PRN line

Payment
(PRN:100123456789)
of 01/18
on 01/01/19

Late Payment
of 01/18
on 01/01/19

System error
Payment
(PRN:100123456789)
of 2018
on 01/01/19
not reflected
reflected in ledger

[siphomateke]

@rahensonzam What are all the unique reasons for change? The ones you would write in Excel. For instance, is "Late Payment Interest" the same "type" as "Late Payment Penalty"?

I can see a lot of the ones you posted are the same type just with different dates or reversal state but I don't want to make any assumptions.