Spreadsheet: 875565d1722178743-calculating-accounts-receivables-excel-forum-sample-jumanarimawi-
Sheet: Revenue

Revenue
Sanad Credit Financial Model |  |  |  |  |  |  |  |  |  | Index!A1
Financial Model Currency: JOD
 |  |  |  | Metric
 |  |  | Financial Month End |  | 2024-09-30 00:00:00 | 2024-10-30 00:00:00 | 2024-11-30 00:00:00 | 2024-12-30 00:00:00 | 2025-01-30 00:00:00 | 2025-02-28 00:00:00 | 2025-03-28 00:00:00 | 2025-04-28 00:00:00 | 2025-05-28 00:00:00 | 2025-06-28 00:00:00 | 2025-07-28 00:00:00 | 2025-08-28 00:00:00 | 2025-09-28 00:00:00 | 2025-10-28 00:00:00 | 2025-11-28 00:00:00 | 2025-12-28 00:00:00 | 2026-01-28 00:00:00 | 2026-02-28 00:00:00 | 2026-03-28 00:00:00 | 2026-04-28 00:00:00 | 2026-05-28 00:00:00 | 2026-06-28 00:00:00 | 2026-07-28 00:00:00 | 2026-08-28 00:00:00 | 2026-09-28 00:00:00 | 2026-10-28 00:00:00 | 2026-11-28 00:00:00 | 2026-12-28 00:00:00 | 2027-01-28 00:00:00 | 2027-02-28 00:00:00 | 2027-03-28 00:00:00 | 2027-04-28 00:00:00 | 2027-05-28 00:00:00 | 2027-06-28 00:00:00 | 2027-07-28 00:00:00 | 2027-08-28 00:00:00 | 2027-09-28 00:00:00 | 2027-10-28 00:00:00 | 2027-11-28 00:00:00 | 2027-12-28 00:00:00 | 2028-01-28 00:00:00 | 2028-02-28 00:00:00 | 2028-03-28 00:00:00 | 2028-04-28 00:00:00 | 2028-05-28 00:00:00 | 2028-06-28 00:00:00 | 2028-07-28 00:00:00 | 2028-08-28 00:00:00 | 2028-09-28 00:00:00 | 2028-10-28 00:00:00 | 2028-11-28 00:00:00 | 2028-12-28 00:00:00
 |  |  | Financial Year |  | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028
 |  |  |  | 7 | 2773.382614181486 | 2773.382614181486 | 2773.382614181486 | 2773.382614181486 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4170.481704423547 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4662.17109545804 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 4976.021785312889 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695 | 5118.860302505695
 |  |  |  | 14 | 5149.026344370504 | 5149.026344370504 | 5149.026344370504 | 5149.026344370504 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 7742.862472342167 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 8657.994192050159 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9243.966736862829 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912 | 9513.589224016912
 |  |  |  | 21 | 1026.520403582637 | 1026.520403582637 | 1026.520403582637 | 1026.520403582637 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1543.632869286716 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 1792.956598334144 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2006.562278312428 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517 | 2190.98752137517
 |  |  |  | 30 | 29433.38398143477 | 29433.38398143477 | 29433.38398143477 | 29433.38398143477 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 44260.53180191101 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 49245.4101048723 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 52238.59480732624 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242 | 53298.63574625242
 |  |  |  | 60 | 0 | 0 | 0 | 0 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 1369.805731875 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 2999.501003953126 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 5231.797079315626 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056 | 8145.032589631056
 |  |  |  | 90 | 0 | 0 | 0 | 0 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 3805.015921875 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 7828.484889750002 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 13300.73784840938 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195 | 20409.39200620195
 |  |  |  | 120 | 0 | 0 | 0 | 0 | 10146.709125 | 10146.709125 | 10146.709125 | 10146.709125 | 10146.709125 | 10146.709125 | 10146.709125 | 10146.709125 | 10146.709125 | 10146.709125 | 10146.709125 | 10146.709125 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 19411.66429863282 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 31885.33045851563 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433 | 47980.79542742433
 |  |  |  | 150 | 0 | 0 | 0 | 0 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 19025.079609375 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 34781.44781179688 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 55831.86435389065 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005 | 82854.64186004005
 |  |  |  | 180 | 0 | 0 | 0 | 0 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 39318.49785937501 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 69243.79977210939 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 108930.7003827657 | 159623.914543919 | 159623.914543919 | 159623.914543919 | 159623.914543919 | 159623.914543919 | 159623.914543919 | 159623.914543919 | 159623.914543919 | 159623.914543919 | 159623.914543919 | 159623.914543919 | 159623.914543919
 |  |  | Total revenue | JOD | 38382.3133435694 | 38382.3133435694 | 38382.3133435694 | 38382.3133435694 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 131382.6170954634 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 198623.4297669569 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 283645.5757307113 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666 | 389135.8492213666