REKONSILIASI JURNAL & CASHFLOW (LENDER & BORROWER)
Matriks rekonsiliasi: General Ledger vs Cashflow Lender & Borrower serta Hak Penyelenggara
Status Control GL
SEMUA BALANCE
11 dari 11 kategori balanced (0,00)
Total Escrow (GL)
Rp 811.010.340,00
Mutasi Net Escrow Bank pada Jurnal
Total Cashflow
Rp 675.842.973,83
Selisih ESC - CF: Rp 39.678.076,17
Hak Penyelenggara
Rp 248.238.695,91
Selisih dgn TRF: Rp 91.771.752,91
1 MATRIKS GENERAL LEDGER (JURNAL)
| NO | CATEGORY | GENERAL LEDGER (DEBIT) | GENERAL LEDGER (KREDIT) | CONTROL | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ESCROW | PAYDAY LOAN | PERSONAL LOAN | FIXED LOAN | SME LOAN | OTHER DEBIT | TOTAL DEBIT | BORROWER DEPOSIT | INVESTOR FUND | COMMISSION | VAT | PPH | TRX FEE | OTHER CREDIT | TOTAL KREDIT | |||
| 1 | DEPOSIT LENDER | 7.182.101.550,00 | - | - | - | - | 189.715.259,00 | 7.371.816.809,00 | - | 7.371.764.809,00 | 46.846,88 | 5.153,12 | - | - | - | 7.371.816.809,00 | - |
| 2 | DEPOSIT BORROWER | 22.251.592.357,00 | - | - | - | - | 503.683.021,00 | 22.755.275.378,00 | 22.753.370.878,00 | - | 1.715.766,98 | 188.733,02 | - | - | - | 22.755.275.378,00 | - |
| 3 | DISBURSEMENT | -19.776.091.767,00 | 684.500.000,00 | 691.100.000,00 | - | 18.571.217.219,00 | 19.777.430.767,00 | 19.948.156.219,00 | - | 1.254.607,00 | 152.696.455,00 | 16.796.582,00 | - | - | 19.777.408.575,00 | 19.948.156.219,00 | - |
| 4 | REPAYMENT | - | -622.500.000,00 | -1.723.524.998,89 | - | -17.330.013.640,00 | - | -19.676.038.638,89 | -20.495.581.642,18 | 573.260.805,23 | 146.918.249,52 | 14.436.794,96 | 84.927.151,22 | - | - | -19.676.038.641,25 | - |
| 5 | WITHDRAWAL | -6.481.909.595,00 | - | - | - | - | 299.000,00 | -6.481.610.595,00 | - | -6.558.547.348,00 | 304.504,72 | 33.495,28 | - | - | 76.598.753,00 | -6.481.610.595,00 | - |
| 6 | REFUND | -2.331.955.283,00 | - | - | - | - | - | -2.331.955.283,00 | -2.933.916.093,00 | - | 75.298.753,00 | 660.000,00 | 14.400.000,00 | - | 511.602.057,00 | -2.331.955.283,00 | - |
| 7 | TRANSACTION FEE | -1.035.500,00 | - | - | - | - | 1.035.500,00 | - | - | - | - | - | - | - | - | - | - |
| 8 | FACILITY FEE | 123.740.021,00 | - | - | - | - | - | 123.740.021,00 | - | - | - | 12.262.524,00 | - | - | 111.477.497,00 | 123.740.021,00 | - |
| 9 | PEMINDAHAN KOMISI | -155.312.165,00 | - | - | - | - | 155.312.165,00 | - | - | - | - | - | - | - | - | - | - |
| 10 | INTERNAL TRANSFER | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
| 11 | OTHERS | -119.278,00 | - | - | - | - | 506.277,00 | 386.999,00 | 387.000,00 | - | - | - | - | - | - | 387.000,00 | - |
| TOTAL | 811.010.340,00 | 62.000.000,00 | -1.032.424.998,89 | 0,00 | 1.241.203.579,00 | 20.627.981.989,00 | 21.709.770.909,11 | -675.739.857,18 | 1.387.732.873,23 | 376.980.576,10 | 44.383.282,38 | 99.327.151,22 | 0,00 | 20.477.086.882,00 | 21.709.770.907,75 | ✓ 0,00 | |
2 MATRIKS CASHFLOW (LENDER & BORROWER) & HAK PENYELENGGARA
| NO | CATEGORY | CASHFLOW | HAK PENYELENGGARA | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| BORROWER DEPOSIT | INVESTOR FUND | COMMISSION | VAT | PPH | TRX FEE | TOTAL | ESC - CF | AV FOR PB | TRF OF COMMISSION | ||
| 1 | DEPOSIT LENDER | - | 7.371.764.809,00 | 46.846,88 | 5.153,12 | - | - | 7.371.816.809,00 | - | 52.000,00 | - |
| 2 | DEPOSIT BORROWER | 22.753.757.881,00 | - | 1.715.766,98 | 188.733,02 | - | - | 22.755.662.381,00 | -387.003,00 | 1.904.500,00 | - |
| 3 | DISBURSEMENT | - | -19.951.517.219,00 | - | - | - | - | -19.951.517.219,00 | 4.700.000,00 | - | - |
| 4 | REPAYMENT | -20.495.581.642,25 | 20.249.299.446,17 | 146.918.249,51 | 14.436.795,07 | 84.927.151,33 | - | -0,17 | 0,17 | 246.282.195,91 | - |
| 5 | WITHDRAWAL | - | -6.558.547.348,00 | - | - | - | - | -6.558.547.348,00 | - | - | - |
| 6 | REFUND | -2.941.571.649,00 | - | - | - | - | - | -2.941.571.649,00 | 22.715.556,00 | - | - |
| 7 | TRANSACTION FEE | - | - | - | - | - | - | - | - | - | 1.035.500,00 |
| 8 | FACILITY FEE | - | - | - | - | - | - | - | 12.262.524,00 | - | - |
| 9 | PEMINDAHAN KOMISI | - | - | - | - | - | - | - | - | - | 155.312.165,00 |
| 10 | INTERNAL TRANSFER | - | - | - | - | - | - | - | - | - | - |
| 11 | OTHERS | - | - | - | - | - | - | - | 386.999,00 | - | 119.278,00 |
| TOTAL | -683.395.410,25 | 1.110.999.688,17 | 148.680.863,37 | 14.630.681,21 | 84.927.151,33 | 0,00 | 675.842.973,83 | ⚠ 39.678.076,17 | 248.238.695,91 | 156.466.943,00 | |
| SELISIH | 91.771.752,91 | ||||||||||