This pending amount is all incoming payments from the aggregator payment method that still has not been settled to your balance. This happens because this payment method has no real-time settlement time.
1. Find out what kind of Aggregator payment method that you use to be able to know the longest settlement time
|Payment Method||Sub-Payment Method||Settlement Time (Normal)|
|Virtual Account||Fixed Virtual Account||Real-Time|
|Non-Fixed Virtual Account||Real-Time|
|Retail Outlet||Fixed Payment Code||T+5|
|Non-Fixed Payment Code||T+5|
2. By knowing the longest settlement time, it helps you to shorten the date range of pending tab report you have to focus on this reconciliation process
Example 1: You find out that you only use Virtual Account and e-wallet and You do reconciliation on Today, 1st October. Then you can expect that the current pending balance is contributed by the transaction paid from 2 days before until today (The inverse of the T+2 Settlement time for ewallets becomes T-2 for filter the Pending tab report). So, you can filter the date range on pending tab from date 29th September - 1st October.
Example 2: You find out that you use ewallet, Retail Outlet, and cards and You do reconciliation by Today, 1st October. Then you can expect that the current pending balance is contributed by the payment 7 days before until today (The inverse of the T+7 Settlement time for credit card becomes T-7 for filter the Pending tab report). So, you can filter the date range on the pending tab from the 24th September - 1st October.
3. Download the CSV report and find out which transaction that is already being settled (move to the cash tab) and which transaction that hasn’t settled yet.
There are 2 important columns to be focused on the CSV report for Pending Tab:
Showing transaction type. If the value stated “SETTLEMENT” means that the payment has been settled to cash tab. Meanwhile, if the value stated “PAYMENT” means that the payment hasn’t settled yet.
If in column type stated “SETTLEMENT”, then it will have value “FALSE” in this column. Meanwhile, if the column type stated “PAYMENT”, then it will have value “TRUE” in this column.
To find out the transactions:
a. Filter the column is_credited “TRUE”, copy all the filtered data, and paste to the new sheet
b. Filter the column is_credited “FALSE”, copy all the filtered data, and paste to the other new sheet
c. Both sheet has the same column id so that we can vlookup data from “TRUE” in “FALSE” data by that id
=VLOOKUP(cell of the id, table range of FALSE data sheet, column of the id in FALSE sheet, 0)
- Do this vlookup in the new column in sheet TRUE
- 0 means you only want the value that is EXACT match
d. You’ll see in the column vlookup now can have value of the id or #N/A. If it is #N/A means that the transaction hasn’t been settled yet. So, filter the column vlookup to only show the #N/A.
e. Then, see the column Type, there may be several transaction type. Filter to only the transaction stated “PAYMENT” and you’ll get the transaction that the payment is still pending.
Note: Do not filter for type with hint “DISBURSEMENT” cause this reconciliation is for money-in product only
f. To make you sure, you can see the sum of column amount for all the filtered transactions you get in poin e, this amount should be the same with the amount stated on the pending balance when you exported the CSV from pending tab
Tips: Pending balance will change quickly because of new incoming payment or payment settled when you do the reconciliation, so better for you to take a screenshot of it when you export the CSV