Car Wash Ledger

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

5 Nov, 20:10

Gross

€2,682.00

PSP fee

€41.66

Net to the bank

€2,640.34

Settlement journal

#403535

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a1ad57-730d-7d70-a925-8a683dbc0932 is already settled by stl_EUR_2989849 line 33
  • duplicate linethe file lists it twicecapture:01a1ad59-b171-73c1-a323-83c1b0912a32 is already settled by stl_EUR_2989849 line 59
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a1ad5c-46e9-7971-ab02-a39b6ee099a5 is in no file
LineKindReferenceGrossFeeStatus
25capture01a1ad57-0629-7cc4-90a9-a11325861163€49.00€0.72fee difference
34refund01a1ad57-730f-760d-9d7e-d4e9a40470f9-€15.00€0.00duplicate line
60capture01a1ad59-b1d1-7f73-837a-85df555a088b€9.00€0.19duplicate line
62capture01a1ad59-e6d5-7d23-bf69-624f17118ff9€49.00€0.72fee difference
1capture01a1ad4d-e710-77dd-9e8b-3e90a16f5e63€49.00€0.67matched
2capture01a1ad55-383d-7422-8129-3adbbd4e9d05€49.00€0.67matched
3capture01a1ad55-3c22-7478-80f0-3574bb1a5fee€9.00€0.19matched
4capture01a1ad55-44b7-7a52-a8d7-ab0391412c3b€49.00€0.67matched
5capture01a1ad55-4af9-793e-ad9d-eb90522fe0ac€15.00€0.26matched
6capture01a1ad55-70f2-7564-9b40-4fe053f8c21a€15.00€0.26matched
7capture01a1ad55-74cf-724b-89d0-6ddb379dbeb8€24.00€0.37matched
8capture01a1ad55-74e1-7ccb-bc63-94bec596f709€35.00€0.50matched
9refund01a1ad55-776d-70ca-bd60-5886014cf53d-€14.00€0.00matched
10capture01a1ad55-7c01-7798-ad9c-77e4f7f790b6€49.00€0.67matched
11capture01a1ad55-7dd3-7187-a4c0-3608a5684e17€24.00€0.37matched
12capture01a1ad55-8a18-710f-96fa-8b3b41b1f3e9€49.00€0.67matched
13capture01a1ad55-c6e2-7ec0-b7cf-11ee798f0fdd€15.00€0.26matched
14capture01a1ad55-c91c-7119-b861-78556809849a€9.00€0.19matched
15capture01a1ad56-322a-7968-9bdc-21b0686beb2a€49.00€0.67matched
16capture01a1ad56-4ffc-74ec-85fd-67fb6363d103€24.00€0.37matched
17capture01a1ad56-7a4a-768f-8a7c-1d5bda4aa51a€24.00€0.37matched
18capture01a1ad56-7cd6-7fac-99df-a4629b0feb6b€49.00€0.67matched
19capture01a1ad56-90a7-7251-a5bf-3277d698b1e9€24.00€0.37matched
20capture01a1ad56-91cf-7fac-91e0-e16ecfe30488€35.00€0.50matched
21capture01a1ad56-a038-714a-b6bc-70a9ba2c7667€49.00€0.67matched
22capture01a1ad56-c773-73c2-b963-28b54ba2b8ef€35.00€0.50matched
23capture01a1ad56-e508-7111-84dd-60bf1d55c08f€49.00€0.67matched
24capture01a1ad57-02e6-7246-9322-4976ece86dd2€24.00€0.37matched
26capture01a1ad57-2880-71d1-975b-5bc5c7fe302d€15.00€0.26matched
27capture01a1ad57-3137-7d14-9f0c-8976f992c773€24.00€0.37matched
28capture01a1ad57-3dcd-733a-9ab3-a7812d427b6d€24.00€0.37matched
29capture01a1ad57-433b-7017-957b-cefcfb190a06€35.00€0.50matched
30capture01a1ad57-420e-7a30-9099-bd908c2263fe€49.00€0.67matched
31capture01a1ad57-4b34-73d5-8d6b-9d3aeee4f463€15.00€0.26matched
32capture01a1ad57-5564-7226-b2b5-f8c021e7502b€35.00€0.50matched
33refund01a1ad57-730f-760d-9d7e-d4e9a40470f9-€15.00€0.00matched
35capture01a1ad57-7b7c-746e-8af7-ef7ffd2023bd€24.00€0.37matched
36capture01a1ad57-7df5-79fb-b5fe-23079ea17986€49.00€0.67matched
37capture01a1ad57-7fc4-77f3-a6ea-ea05e90cc597€15.00€0.26matched
38capture01a1ad57-93a1-7a53-bceb-f48361e157ff€15.00€0.26matched
39capture01a1ad57-a12f-70d5-b0a0-44637cef41b4€9.00€0.19matched
40refund01a1ad57-b2fc-78d5-a79c-264fe8ebc11d-€9.00€0.00matched
41capture01a1ad57-bf56-74a3-b832-357541851b3f€15.00€0.26matched
42capture01a1ad57-cd47-7b53-86d6-7e57e749b5cb€9.00€0.19matched
43capture01a1ad57-e5d5-7185-b381-95f5148aed72€15.00€0.26matched
44capture01a1ad57-ec5a-7f3d-9835-f8746a277691€24.00€0.37matched
45capture01a1ad58-0640-7d61-a830-10003fb03f5e€15.00€0.26matched
46capture01a1ad58-1757-72ac-9f6e-5a8783004d7f€9.00€0.19matched
47capture01a1ad58-19f7-7922-802e-49abae2bbc18€15.00€0.26matched
48capture01a1ad58-1d46-72c4-a35a-147a68594989€24.00€0.37matched
49capture01a1ad58-53ab-775b-a4b8-48e44a3d6799€24.00€0.37matched
50refund01a1ad58-576c-7c2d-999a-52b496abf82e-€5.00€0.00matched
51capture01a1ad58-5a7e-7312-960d-36efbd611390€35.00€0.50matched
52capture01a1ad58-5c70-7215-92b4-c38fdb313e94€15.00€0.26matched
53capture01a1ad58-8def-734e-9160-302607761aaa€35.00€0.50matched
54capture01a1ad58-f208-7d4c-bba9-a698c2617ad9€9.00€0.19matched
55capture01a1ad58-ffac-7bdc-8be0-b89203d2d2fd€49.00€0.67matched
56capture01a1ad59-25f9-7988-8167-b41cf79bd4be€49.00€0.67matched
57capture01a1ad59-2f64-7c3d-9fd1-4e1588f19a7e€49.00€0.67matched
58capture01a1ad59-7294-7251-9101-221ad1a68cad€35.00€0.50matched
59capture01a1ad59-b1d1-7f73-837a-85df555a088b€9.00€0.19matched
61capture01a1ad59-c062-77b2-bef6-4ad5f3339b4b€35.00€0.50matched
63capture01a1ad59-f0f4-7fa5-8d3d-db763b2f208a€9.00€0.19matched
64capture01a1ad59-f5a8-7fa4-8546-e9fba4946517€15.00€0.26matched
65capture01a1ad5a-116c-7864-a97f-470d0d232b3b€24.00€0.37matched
66capture01a1ad5a-3597-71cc-a3d9-c67071522c09€35.00€0.50matched
67capture01a1ad5a-439d-79c6-9e26-bf0de9cf373e€24.00€0.37matched
68capture01a1ad5a-4eff-7fee-9467-1d818b69aa0d€9.00€0.19matched
69capture01a1ad5a-89dc-7715-a22c-0695d0c2249d€9.00€0.19matched
70capture01a1ad5a-ca54-7213-b483-3329f8603aeb€15.00€0.26matched
71capture01a1ad5a-cb31-7faf-a976-fe33a904b4a8€24.00€0.37matched
72capture01a1ad5a-e01a-7d53-a0ff-b8d71ebbcdb1€24.00€0.37matched
73capture01a1ad5a-e320-7f8c-b0a4-2b99a9c51726€35.00€0.50matched
74capture01a1ad5a-f086-726d-be58-dea9ce834b15€15.00€0.26matched
75capture01a1ad5b-1f13-72cc-997e-ad103702cead€15.00€0.26matched
76capture01a1ad5b-2fd7-74b1-b18f-56bdf2ca1cb4€35.00€0.50matched
77capture01a1ad5b-8656-7df1-a379-b5283baaac25€15.00€0.26matched
78capture01a1ad5b-c79c-7c7c-8183-3e7cbfa55e01€9.00€0.19matched
79capture01a1ad5b-da8e-7556-8ce3-d68e9eb7734e€35.00€0.50matched
80capture01a1ad5b-dc09-7a7e-ae86-c3de883724eb€35.00€0.50matched
81capture01a1ad5b-e678-7140-b02b-9f405aa27c74€49.00€0.67matched
82capture01a1ad5c-2fe3-7482-a319-99135d889695€9.00€0.19matched
83capture01a1ad5c-6a02-7c22-847c-503d46178ff7€35.00€0.50matched
84capture01a1ad5c-6d43-7641-bf8e-bd48b052e3b7€49.00€0.67matched
85capture01a1ad5c-79d0-71a0-8840-71cdd3f1ea90€49.00€0.67matched
86capture01a1ad5c-9a34-7fec-88c9-246ff0987154€35.00€0.50matched
87capture01a1ad5c-dd5d-7330-8d79-1300552bc06c€49.00€0.67matched
88capture01a1ad5c-e6ec-779d-ad94-02cba0eaaead€49.00€0.67matched
89capture01a1ad5c-ec10-7745-af7c-29f3166b6e7e€49.00€0.67matched
90capture01a1ad5d-1b5d-7b9a-b730-b34f373405a7€15.00€0.26matched
91capture01a1ad5d-1d69-7d0d-ae5f-46b78d238177€49.00€0.67matched
92capture01a1ad5d-1d8f-7ece-bc79-1f852dfa7061€24.00€0.37matched
93capture01a1ad5d-2088-7c2e-8063-177ca41b0dbb€24.00€0.37matched
94capture01a1ad5d-3d08-76a0-bc6a-61fc667ce96f€24.00€0.37matched
95refund01a1ad5d-4edc-7043-a547-4141456367a7-€28.00€0.00matched
96capture01a1ad5d-59ba-7e73-b440-863d5668480f€49.00€0.67matched
97capture01a1ad5d-b925-75e4-949d-9e5e5e8a941a€24.00€0.37matched
98capture01a1ad5d-e1bc-7c75-a00e-5faf5e10fdca€15.00€0.26matched
99capture01a1ad5d-ee28-70ac-9f45-09995c20f24b€35.00€0.50matched
100capture01a1ad5d-f4cc-72d1-a6bc-aa9beeaa7748€24.00€0.37matched
101capture01a1ad5d-f9c0-76ac-90aa-ec253e2e0ba5€49.00€0.67matched
102capture01a1ad5d-fd03-7a28-a20a-f475915f8d88€35.00€0.50matched
103capture01a1ad5e-26ae-7c1c-bca0-4935c64dd050€15.00€0.26matched
104refund01a1ad5e-347d-76a9-b869-5d610a28c672-€32.00€0.00matched
105capture01a1ad5e-374e-7ea9-a468-935b35e46560€24.00€0.37matched