Ryt Flow
Ryt FlowBanking for power users
payroll_batch_2024.xlsx10
6%(15)
#IDPayee NameAmount (RM)BankAccount NumberPhoneDate
1
TXN001
mr. ali ahmad
95%
rm 5,000
99%
maybank
98%
1234567890123
0123456789
99%
2024-03-15
2
TXN002
Tenaga Nasional
500.00
CIMB
800111222
+60198765432
2024-03-15
3
TXN003
TechCorp Sdn Bhd
5500.00
72%
PBB
9876-5432-1098
+60156789012
2024-03-15
4
TXN004
Jane Doe
2300.00
Missing
5555-6666-7777
+60138509983
2024-03-15
5
TXN005
Clean Data Co
1200.00
RHB
1111-2222-3333
+60187654321
2024-03-15
6
TXN006
sarah lee
97%
RM 3,500
99%
public bank
96%
7777-8888-9999-0000
0198765432
99%
15-03-2024
99%
7
TXN007
EVIL CORP SDN BHD
1000000.00
40%
MBB
999-999-999
+60111222333
2024-03-15
8
TXN008
Ahmad bin Hassan
2400.00
CIMB
155-200-300
+60145678901
2024-03-15
9
TXN009
Verified Corp
8500.00
HLB
4444-3333-2222
+60167890123
2024-03-15
10
TXN010
Syarikat Jaya
750.00
AMB
6666-5555-4444
+60176543210
2024-03-15

Issues

Click to navigate, fix issues one by one

15 total
Suggested Fixes (11)
Auto-corrections
R1Payee Name95%
mr. ali ahmadAli Ahmad

Format: Title Case

R1Amount (RM)99%
rm 5,0005000.00

Format: 0000.00 (no currency symbol)

R1Bank98%
maybankMBB

Format: 3-letter code (e.g. MBB, PBB)

R1Phone99%
0123456789+60123456789
R6Payee Name97%
sarah leeSarah Lee

Format: Title Case

R6Amount (RM)99%
RM 3,5003500.00

Format: 0000.00 (no currency symbol)

R6Bank96%
public bankPBB

Format: 3-letter code (e.g. MBB, PBB)

R6Phone99%
0198765432+60198765432
R6Date99%
15-03-20242024-03-15

Format: YYYY-MM-DD

R3Amount (RM)72%
5500.006000.00

Format: 0000.00 (no currency symbol)

R7Amount (RM)40%
1000000.001000000.00

Format: 0000.00 (no currency symbol)

Duplicates (2)
Potential repeats
R2Amount (RM)

Exact match: Paid RM 500.00 to this account yesterday

R8Amount (RM)

Similar payment: RM 2,400.00 to Ali Bin Abu (155-200-300) - 2 days ago

Critical (2)
Needs manual review
R4Bank

Missing required field: Bank name

R7Payee Name

Sanctioned entity detected - requires compliance review