1.Find out the frequency of autowithdrawal that you have set.
Go to settings tab > Withdrawal Settings > Autowithdrawal > Frequency of Autowithdrawal
The logic of Autowithdrawal Transactions
Example: Given the frequency that has been set is daily at 9am GMT+7. Then the transactions that include into an autowithdrawal are transaction between transaction type SETTLEMENT_DISBURSEMENT_CREATED at 9 am on autowithdrawal Day - 1 and SETTLEMENT_DISBURSEMENT_CREATED at 9 am on autowithdrawal Day.
Let’s say, you want to reconcile autowithdrawal happened on 22 May, then the transactions that included into 22 May autowithdrawal are transactions between transaction type SETTLEMENT_DISBURSEMENT_CREATED at 9 am on 21 May and SETTLEMENT_DISBURSEMENT_CREATED at 9 am on 22 May
2. By knowing the frequency of autowithdrawal, it helps you to shorten the date range of Cash tab report you have to focus on this reconciliation process
3. Download report from the cash tab
4. Then find out the auto withdrawal transactions by:
a. Identify 2 borders of the transactions. There are 2 borders here which are the start border and the end border. Both border are identified by transaction type SETTLEMENT_DISBURSEMENT_CREATED created at 9am
b. Get the list of the transactions between those 2 borders, copy all of them, and paste to the new sheet
Note: The transactions list include 2 types of transactions which The SETTLEMENT and the (Xendit) FEE
c. Sum the amount of all SETTLEMENT transactions
d. Sum the amount of all FEE transactions
e. Autowithdrawal Amount: Sum the amount of all payment transactions – Sum the amount of all fee transactions