The bank's file against the books.
At the end of each day the payment provider sends a settlement file: every capture and refund it settled, with its fee. The matcher pairs each line with the ledger by reference. Whatever doesn't pair is a break, and a person looks at it. In the demo a day is compressed to a few minutes.
Settled days
- 19 Oct, 23:20109 lines4 breaks
- 19 Oct, 23:10121 lines1 break
- 19 Oct, 23:00107 lines2 breaks
- 19 Oct, 22:50127 lines3 breaks
- 19 Oct, 22:40121 lines3 breaks
- 19 Oct, 22:30135 lines2 breaks
- 19 Oct, 22:20112 lines5 breaks
- 19 Oct, 22:10125 lines2 breaks
- 19 Oct, 22:00115 lines1 break
- 19 Oct, 21:50115 lines1 break
- 19 Oct, 21:40143 linesclean
- 19 Oct, 21:30147 lines4 breaks
- 19 Oct, 21:20126 lines3 breaks
- 19 Oct, 21:10115 lines3 breaks
19 Oct, 22:20
Gross
€2,793.00
PSP fee
€43.75
Net to the bank
€2,749.25
Settlement journal
#94611
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a15643-233a-75a1-b293-1b60698f88d5 is already settled by stl_EUR_2987414 line 43
- fee differencethe fee is not the contract feethe fee is 52, the contract says 50
- fee differencethe fee is not the contract feethe fee is 4, the contract says 0
- missing linein the books, not in the filecapture:01a15640-3712-7641-bd36-45a4db94163b is in no file
- missing linein the books, not in the filecapture:01a15642-5703-71e9-a3f1-aabc1b58256c is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 44 | refund | 01a15643-233a-7ff1-98b9-e6c9eb79489a | -€22.00 | €0.00 | duplicate line |
| 76 | capture | 01a15645-e8b9-74b4-9531-a265ab3c55b7 | €35.00 | €0.52 | fee difference |
| 106 | refund | 01a15648-a29c-7737-b84a-89a600196349 | -€5.00 | €0.04 | fee difference |
| 1 | capture | 01a15638-17bc-78c3-a124-992ad5e70aa9 | €24.00 | €0.37 | matched |
| 2 | capture | 01a1563e-6598-7efb-8c1c-cd64a8299ca6 | €15.00 | €0.26 | matched |
| 3 | capture | 01a15640-2ba1-7e04-9a9b-51c9aa2e397a | €15.00 | €0.26 | matched |
| 4 | capture | 01a15640-2d36-7fb4-8c24-7e14db65ae03 | €24.00 | €0.37 | matched |
| 5 | capture | 01a15640-397f-7504-a5c1-a44873f4e5ae | €49.00 | €0.67 | matched |
| 6 | capture | 01a15640-3a2f-72cb-8b58-5fd66a48d5e7 | €9.00 | €0.19 | matched |
| 7 | capture | 01a15640-42ca-7530-aff9-2fa0283aa054 | €35.00 | €0.50 | matched |
| 8 | capture | 01a15640-4e3f-74a9-8c75-baeee266427c | €35.00 | €0.50 | matched |
| 9 | capture | 01a15640-5aa5-74b5-925e-012078390119 | €49.00 | €0.67 | matched |
| 10 | capture | 01a15640-5c8f-7025-a149-b9af49a888b3 | €49.00 | €0.67 | matched |
| 11 | capture | 01a15640-60ee-7291-a5ae-94f7ba6d4f74 | €35.00 | €0.50 | matched |
| 12 | capture | 01a15640-6697-7b50-9297-a863f0f8ad4c | €15.00 | €0.26 | matched |
| 13 | capture | 01a15640-735e-72ff-8590-5c175207d5bc | €49.00 | €0.67 | matched |
| 14 | refund | 01a15640-754c-7c4c-bb38-bf418fd771fd | -€33.00 | €0.00 | matched |
| 15 | capture | 01a15640-c913-73ae-a193-95065b9803a1 | €24.00 | €0.37 | matched |
| 16 | capture | 01a15640-d047-73cc-9165-3bc63818b266 | €49.00 | €0.67 | matched |
| 17 | capture | 01a15640-d28b-743e-be61-47c040987a81 | €35.00 | €0.50 | matched |
| 18 | capture | 01a15640-eeff-75f5-86c4-1926f872a0a4 | €35.00 | €0.50 | matched |
| 19 | capture | 01a15640-f891-7b65-8bdc-279f3bafa975 | €15.00 | €0.26 | matched |
| 20 | capture | 01a15641-2d71-7d5f-814d-60ae669d3875 | €15.00 | €0.26 | matched |
| 21 | capture | 01a15641-4bac-75e2-8a99-dcaf9bf91cd9 | €15.00 | €0.26 | matched |
| 22 | capture | 01a15641-58f0-7688-be6d-3be6bccc015e | €49.00 | €0.67 | matched |
| 23 | capture | 01a15641-68ad-7977-8997-9b6ea26114f7 | €35.00 | €0.50 | matched |
| 24 | capture | 01a15641-8041-7626-ab1d-f9a7ec8f4c60 | €49.00 | €0.67 | matched |
| 25 | capture | 01a15641-813b-7dc6-83e6-2f4ec8318d5b | €24.00 | €0.37 | matched |
| 26 | capture | 01a15641-b33a-70c2-b49e-3a75122d3ea4 | €15.00 | €0.26 | matched |
| 27 | capture | 01a15641-d6ed-7274-a8a4-80212d827b2e | €24.00 | €0.37 | matched |
| 28 | capture | 01a15642-419e-7912-8f91-ede4108ea415 | €9.00 | €0.19 | matched |
| 29 | capture | 01a15642-5d2b-7e04-a8b7-2ad9bf9af2b4 | €35.00 | €0.50 | matched |
| 30 | capture | 01a15642-61e2-75db-a0fa-d65110e84328 | €9.00 | €0.19 | matched |
| 31 | capture | 01a15642-678c-71ac-bb7d-991cab46d82f | €49.00 | €0.67 | matched |
| 32 | capture | 01a15642-85b7-799a-8a8b-9d83807f7559 | €9.00 | €0.19 | matched |
| 33 | capture | 01a15642-a01b-7c45-b877-8fcf15b562be | €49.00 | €0.67 | matched |
| 34 | refund | 01a15642-acb9-74b4-bb2c-eefa4a7db3a7 | -€2.00 | €0.00 | matched |
| 35 | capture | 01a15642-b728-7517-bdf4-2369fdeaf43f | €15.00 | €0.26 | matched |
| 36 | capture | 01a15642-c04d-79a6-88fe-5abeb429b37d | €49.00 | €0.67 | matched |
| 37 | capture | 01a15642-c29e-7ed1-ac73-81e4ec82ad68 | €9.00 | €0.19 | matched |
| 38 | refund | 01a15642-c928-7d94-b718-5600fccc6e94 | -€27.00 | €0.00 | matched |
| 39 | capture | 01a15642-d090-79fb-b652-61764ef44407 | €35.00 | €0.50 | matched |
| 40 | capture | 01a15642-de7d-7337-88be-56adc5b7acd1 | €24.00 | €0.37 | matched |
| 41 | capture | 01a15643-0d39-79e3-b1bb-9f52265c5d2f | €9.00 | €0.19 | matched |
| 42 | capture | 01a15643-22cf-7763-916b-bca532582d3a | €9.00 | €0.19 | matched |
| 43 | refund | 01a15643-233a-7ff1-98b9-e6c9eb79489a | -€22.00 | €0.00 | matched |
| 45 | capture | 01a15643-420c-7ec0-82fe-c5f54b49f0e4 | €35.00 | €0.50 | matched |
| 46 | capture | 01a15643-8027-72c9-a457-9f6ef183bdbf | €15.00 | €0.26 | matched |
| 47 | capture | 01a15643-965b-77cd-af1b-43a99e4586fd | €24.00 | €0.37 | matched |
| 48 | capture | 01a15643-ad88-7950-ac3f-7fe722d90704 | €24.00 | €0.37 | matched |
| 49 | capture | 01a15643-ce7c-781f-93a0-75889ed20a8f | €24.00 | €0.37 | matched |
| 50 | capture | 01a15643-dfb4-7b23-9b24-1c6a94575e8e | €35.00 | €0.50 | matched |
| 51 | capture | 01a15643-f051-7756-aa1a-146c464574b8 | €24.00 | €0.37 | matched |
| 52 | refund | 01a15643-f2cc-74e0-b7c1-aab1007b2770 | -€15.00 | €0.00 | matched |
| 53 | capture | 01a15644-1d15-74e2-b767-fa2dbbaea7d6 | €49.00 | €0.67 | matched |
| 54 | capture | 01a15644-318b-7030-bfca-c9fa3243c3a9 | €9.00 | €0.19 | matched |
| 55 | capture | 01a15644-60b7-7852-8a64-b2e9410c40b8 | €15.00 | €0.26 | matched |
| 56 | capture | 01a15644-6a5e-7d2b-bf89-02092e535a04 | €15.00 | €0.26 | matched |
| 57 | capture | 01a15644-7708-7908-b42c-7f0c2cbb9b2f | €35.00 | €0.50 | matched |
| 58 | refund | 01a15644-8e69-721b-939a-cbd6f8d46c48 | -€5.00 | €0.00 | matched |
| 59 | capture | 01a15644-9c07-76ec-ad60-2617b0b72bc7 | €49.00 | €0.67 | matched |
| 60 | refund | 01a15644-a711-7899-a88a-0a361ef83429 | -€6.00 | €0.00 | matched |
| 61 | capture | 01a15644-afd1-767b-9242-e007cc4483c0 | €35.00 | €0.50 | matched |
| 62 | capture | 01a15644-c651-7399-b8b7-8777466abd99 | €24.00 | €0.37 | matched |
| 63 | capture | 01a15644-c791-7db9-b817-eb019346917a | €35.00 | €0.50 | matched |
| 64 | capture | 01a15644-ccd1-7ed4-befa-54d10faf3637 | €35.00 | €0.50 | matched |
| 65 | refund | 01a15644-ef8f-7940-95e2-7a6b499f910e | -€19.00 | €0.00 | matched |
| 66 | capture | 01a15644-fb25-7904-a828-6163db76178e | €15.00 | €0.26 | matched |
| 67 | capture | 01a15645-0344-7d20-986d-b1108faab3ef | €49.00 | €0.67 | matched |
| 68 | capture | 01a15645-2af3-7dab-b206-cd49e53356c9 | €24.00 | €0.37 | matched |
| 69 | capture | 01a15645-2e5f-73e9-9cf6-1f7f30db6ac9 | €49.00 | €0.67 | matched |
| 70 | capture | 01a15645-3b8d-705b-8af0-bc9d08068ad7 | €15.00 | €0.26 | matched |
| 71 | capture | 01a15645-444f-70a5-8c95-c35df2e702e5 | €24.00 | €0.37 | matched |
| 72 | capture | 01a15645-5e67-7656-af58-4796dd459141 | €35.00 | €0.50 | matched |
| 73 | capture | 01a15645-7fce-7981-ad22-8ad96ab2f801 | €24.00 | €0.37 | matched |
| 74 | capture | 01a15645-8b37-7e03-a9a9-4ffd77da7539 | €9.00 | €0.19 | matched |
| 75 | capture | 01a15645-b49a-70f4-8c76-6e94b8aa7373 | €49.00 | €0.67 | matched |
| 77 | capture | 01a15645-ef5d-74df-830e-c5c06aa846fc | €15.00 | €0.26 | matched |
| 78 | capture | 01a15645-f9ed-7ee2-be1c-f0711a56b1b6 | €15.00 | €0.26 | matched |
| 79 | capture | 01a15645-ffe9-734e-b694-98a15e62e1e3 | €35.00 | €0.50 | matched |
| 80 | capture | 01a15646-0173-726b-a759-2922c55ce730 | €15.00 | €0.26 | matched |
| 81 | capture | 01a15646-147e-797b-a50b-44629d247452 | €24.00 | €0.37 | matched |
| 82 | capture | 01a15646-29b2-7882-8dd3-6099303a0ea8 | €49.00 | €0.67 | matched |
| 83 | refund | 01a15646-3818-7654-81b7-2ed3cf994f65 | -€9.00 | €0.00 | matched |
| 84 | capture | 01a15646-560f-7b98-ae67-9fba3408c11a | €35.00 | €0.50 | matched |
| 85 | capture | 01a15646-6c5a-7ece-84da-5b95ce574115 | €24.00 | €0.37 | matched |
| 86 | capture | 01a15646-839b-7c17-af86-ed41e017ee2c | €49.00 | €0.67 | matched |
| 87 | capture | 01a15646-a104-7cc8-b86b-5b299702e27c | €49.00 | €0.67 | matched |
| 88 | capture | 01a15646-a3b3-70be-bb3d-a51a58781520 | €24.00 | €0.37 | matched |
| 89 | capture | 01a15646-f60d-74d4-a3dc-2c7c9ea175c5 | €24.00 | €0.37 | matched |
| 90 | capture | 01a15647-1e55-7de2-8791-2a68d0398132 | €9.00 | €0.19 | matched |
| 91 | capture | 01a15647-32b9-7a49-86d3-dac027f9d965 | €49.00 | €0.67 | matched |
| 92 | capture | 01a15647-34ac-7095-a9d2-92433274b3e3 | €49.00 | €0.67 | matched |
| 93 | capture | 01a15647-7c2a-789b-943b-c9e5b87dc5da | €49.00 | €0.67 | matched |
| 94 | capture | 01a15647-80f1-757c-80b3-7f0d182c15c9 | €49.00 | €0.67 | matched |
| 95 | capture | 01a15647-815c-7f9e-8af1-c5e24eec8fc8 | €24.00 | €0.37 | matched |
| 96 | capture | 01a15647-bd53-747d-a13f-746034d986bf | €35.00 | €0.50 | matched |
| 97 | capture | 01a15647-c6be-7896-8845-f0db41075b0c | €15.00 | €0.26 | matched |
| 98 | capture | 01a15647-e3fd-7aa0-920d-9f2a48b5c686 | €15.00 | €0.26 | matched |
| 99 | capture | 01a15647-ecd4-7463-acb4-222a593b4df9 | €35.00 | €0.50 | matched |
| 100 | capture | 01a15648-04e3-7484-89e7-16d57cb92e19 | €49.00 | €0.67 | matched |
| 101 | capture | 01a15648-32d8-7495-b25f-7ef4255d66b0 | €15.00 | €0.26 | matched |
| 102 | capture | 01a15648-41ac-7f43-a5ce-7281dcb18c41 | €35.00 | €0.50 | matched |
| 103 | capture | 01a15648-4e2f-76e9-a57a-2be466c56101 | €49.00 | €0.67 | matched |
| 104 | capture | 01a15648-51b1-7ef3-ae55-5805f8dc47a9 | €9.00 | €0.19 | matched |
| 105 | capture | 01a15648-5927-780c-8b50-09129e13003d | €15.00 | €0.26 | matched |
| 107 | capture | 01a15648-bdff-7d2d-b03e-e6a4b37ff757 | €35.00 | €0.50 | matched |
| 108 | capture | 01a15648-c91a-7650-be29-0cfd2e814f4b | €49.00 | €0.67 | matched |
| 109 | capture | 01a15648-db11-7f60-8849-4208674ced61 | €15.00 | €0.26 | matched |
| 110 | capture | 01a15648-f471-7437-9318-97667be3f4bd | €35.00 | €0.50 | matched |
| 111 | capture | 01a15648-fc9f-7e41-b931-7da70689fc2b | €9.00 | €0.19 | matched |
| 112 | capture | 01a15649-1316-7100-b0aa-f9f46ed7d991 | €49.00 | €0.67 | matched |