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

2 Nov, 11:20

Gross

€3,222.00

PSP fee

€51.25

Net to the bank

€3,170.75

Settlement journal

#341964

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a19c02-3a20-7134-9142-0536d4869a48 is already settled by stl_EUR_2989364 line 93
LineKindReferenceGrossFeeStatus
94refund01a19c02-3a21-72f6-87ed-c7127d712d76-€8.00€0.00duplicate line
1capture01a19bf5-424b-77e4-b0c2-48ff9c92692c€24.00€0.37matched
2capture01a19bf5-76f3-7c71-bb9a-4cfd49fa474f€49.00€0.67matched
3capture01a19bfd-0d04-78c1-8b0c-67005c9e60f1€15.00€0.26matched
4capture01a19bfd-1cb5-7213-9f9e-cdbc471b348a€9.00€0.19matched
5capture01a19bfd-4aab-77af-9a38-65cac11d92ef€49.00€0.67matched
6capture01a19bfd-4cd5-74b5-93c0-3e1f72d078a0€49.00€0.67matched
7capture01a19bfd-4f56-7e28-a8ed-c02be9fec81b€9.00€0.19matched
8capture01a19bfd-53aa-7bc2-bdea-512ff374df7e€24.00€0.37matched
9capture01a19bfd-592c-7d97-bbbb-ed7774c85507€35.00€0.50matched
10capture01a19bfd-729e-772c-ab90-8c822dbd9b73€9.00€0.19matched
11capture01a19bfd-7a07-753e-866b-e1b82d92ec15€9.00€0.19matched
12refund01a19bfd-a8ff-7129-86a6-7e9b67c740cb-€6.00€0.00matched
13refund01a19bfd-ad61-76f6-afe7-b1e49494e0a9-€29.00€0.00matched
14capture01a19bfd-b8d7-718b-bae1-503ab8665e98€9.00€0.19matched
15capture01a19bfd-bb0a-757b-850d-787264261252€35.00€0.50matched
16capture01a19bfd-c695-7839-be1c-3f3d13e30415€35.00€0.50matched
17capture01a19bfd-d9a8-730a-a8cd-e858fe1ea156€15.00€0.26matched
18capture01a19bfd-e7f4-710d-b1a5-02ab507de3fd€9.00€0.19matched
19capture01a19bfd-e983-74a1-b23f-b71426396ad6€24.00€0.37matched
20capture01a19bfd-f06b-7683-9742-893506c6633d€35.00€0.50matched
21capture01a19bfd-f8b5-762e-9e64-e74104c3bdba€15.00€0.26matched
22capture01a19bfe-1013-7d48-825d-5d18bbd70914€15.00€0.26matched
23capture01a19bfe-1bbb-761a-8d94-cd7a3aef9b0e€35.00€0.50matched
24capture01a19bfe-200e-7062-8b5f-baa032d91166€9.00€0.19matched
25capture01a19bfe-29fd-7c69-9150-469ee779fcf3€24.00€0.37matched
26capture01a19bfe-324d-793a-91f9-30b09085ade4€24.00€0.37matched
27capture01a19bfe-4a0a-7c12-be93-a96d4f75a864€24.00€0.37matched
28capture01a19bfe-5754-7f68-acc8-d25a9d7b8504€35.00€0.50matched
29capture01a19bfe-6ce7-779b-ab7d-6c2dcdfe358f€15.00€0.26matched
30refund01a19bfe-6ed0-7f0c-86ba-ac0fed1f1098-€20.00€0.00matched
31capture01a19bfe-7abe-7b8d-a269-416dabecb7bd€49.00€0.67matched
32capture01a19bfe-8421-71d8-b727-474595fde069€9.00€0.19matched
33capture01a19bfe-8ba6-7403-a4fc-165bac295d60€15.00€0.26matched
34capture01a19bfe-9c1c-7e0f-82a5-6724c3f3f2c3€49.00€0.67matched
35capture01a19bfe-b3a2-7ff4-b4d5-dd9dd7c6e8ad€15.00€0.26matched
36capture01a19bfe-b906-7b2f-a122-83feea26e777€24.00€0.37matched
37capture01a19bfe-c4d3-73fd-9337-625a1307f9ee€35.00€0.50matched
38capture01a19bfe-ee04-7c2b-b6bd-1c2030179833€9.00€0.19matched
39capture01a19bff-1f92-7a9b-84a1-c8b04a14f6f9€9.00€0.19matched
40capture01a19bff-2a27-7fca-ada4-6fbf15180833€15.00€0.26matched
41capture01a19bff-3163-7955-8165-17cebca54ebb€15.00€0.26matched
42capture01a19bff-6f89-7224-8774-edda82c1a375€24.00€0.37matched
43capture01a19bff-796b-7308-a88d-d28e6f28a1e4€49.00€0.67matched
44capture01a19bff-fc7a-7a82-912c-8ad0014a09dc€24.00€0.37matched
45capture01a19c00-0de7-76f6-aa06-ad9ad93e8f8d€24.00€0.37matched
46capture01a19c00-10bc-739c-a0a0-8389c4517708€49.00€0.67matched
47capture01a19c00-36be-7283-aa58-53a47c1dbf05€49.00€0.67matched
48capture01a19c00-3c2c-70c7-b919-968dfd6b7a70€49.00€0.67matched
49capture01a19c00-3e1b-7593-8c6c-b3e47552890a€9.00€0.19matched
50capture01a19c00-5179-7981-a8ce-f0af2f06ded2€35.00€0.50matched
51refund01a19c00-5de9-7f14-b338-d99355c0476b-€9.00€0.00matched
52capture01a19c00-5e53-76d0-822e-7872370f7582€35.00€0.50matched
53capture01a19c00-614c-7391-8682-278145419764€24.00€0.37matched
54capture01a19c00-8ee2-7ccf-ac8b-e1b2c7c531fc€24.00€0.37matched
55capture01a19c00-8fce-7234-aedf-96dca5180d6f€35.00€0.50matched
56capture01a19c00-92a2-721a-ad0a-1c4727feda50€49.00€0.67matched
57capture01a19c00-9abe-77f6-8265-a091d8f4376a€9.00€0.19matched
58capture01a19c00-9cb2-72e5-892d-e571177b0169€15.00€0.26matched
59capture01a19c00-bb75-7060-9a40-adc7763f8788€35.00€0.50matched
60capture01a19c00-c1ec-774f-9d10-55ccdd5da356€35.00€0.50matched
61capture01a19c00-d16a-743d-8fec-de68d6c21b20€9.00€0.19matched
62capture01a19c00-d52c-7729-8709-eed35ec0cbed€24.00€0.37matched
63capture01a19c00-eaf1-7b98-a5e4-21f8d50590f7€24.00€0.37matched
64capture01a19c00-fe0a-7588-b06c-68fc09ca3cca€9.00€0.19matched
65capture01a19c01-050c-754b-b698-a61f944fa18e€35.00€0.50matched
66capture01a19c01-0e93-75a2-a02b-89e599bc05d9€35.00€0.50matched
67capture01a19c01-1f38-791a-9441-b7c239fbc8fc€15.00€0.26matched
68refund01a19c01-28cf-7f71-ada6-0c3b15f3d40b-€20.00€0.00matched
69capture01a19c01-4087-7d2b-894c-7cd5b3bd61bc€35.00€0.50matched
70capture01a19c01-4753-77c6-bdb9-fab2cb63a9e4€15.00€0.26matched
71capture01a19c01-5652-751a-a307-cbd74049aff6€35.00€0.50matched
72capture01a19c01-6473-706e-8213-d8ff60fab112€35.00€0.50matched
73capture01a19c01-6483-76c2-9a36-0ac2b174d5c2€35.00€0.50matched
74capture01a19c01-656c-7c82-a57e-eabb432d6b8d€15.00€0.26matched
75capture01a19c01-96dc-774f-bfe1-7846dff4b13b€49.00€0.67matched
76capture01a19c01-9dc0-7232-bd1d-6014ca9c5f39€35.00€0.50matched
77capture01a19c01-b71f-7e1b-95ec-69ce3f379c08€35.00€0.50matched
78capture01a19c01-bbee-704c-92bc-cd1cd5429cb8€9.00€0.19matched
79capture01a19c01-c222-7ea5-b26b-50fd0ae075cf€24.00€0.37matched
80refund01a19c01-c33f-7031-8971-ad9de5eef1be-€24.00€0.00matched
81capture01a19c01-cf92-7999-be5d-f474eb7be089€35.00€0.50matched
82capture01a19c01-dca0-73cd-b51b-b67ea8799048€9.00€0.19matched
83capture01a19c01-e3aa-754e-a472-a4f6e860af9e€49.00€0.67matched
84capture01a19c01-e8b8-7948-b38b-ca472b7034c1€35.00€0.50matched
85capture01a19c01-f1a2-738d-bd5d-20f0a14bbc82€24.00€0.37matched
86capture01a19c01-f313-728a-8e03-518e27778083€9.00€0.19matched
87capture01a19c02-0103-7b20-a57e-49f596a8c7b8€24.00€0.37matched
88refund01a19c02-0609-7bbc-9649-4d90e1a9a1f0-€20.00€0.00matched
89capture01a19c02-09c7-71c6-bb93-926b825dbde5€49.00€0.67matched
90capture01a19c02-09d7-7718-8ce1-5a09f986a2e1€24.00€0.37matched
91capture01a19c02-1d78-7e72-8b79-f615dcdb9805€24.00€0.37matched
92capture01a19c02-3957-72d2-b874-8941784db122€9.00€0.19matched
93refund01a19c02-3a21-72f6-87ed-c7127d712d76-€8.00€0.00matched
95capture01a19c02-3a76-760b-86b4-f9dd405d657d€15.00€0.26matched
96capture01a19c02-3e75-709a-92eb-4f98a9d7bd93€9.00€0.19matched
97capture01a19c02-5032-74a3-9954-98504b2f5e5f€15.00€0.26matched
98capture01a19c02-8b2c-747d-98e5-f0e14a406d92€35.00€0.50matched
99capture01a19c02-8b89-7067-870e-b46425635654€49.00€0.67matched
100capture01a19c02-9db3-7ff2-af28-d8f176826590€35.00€0.50matched
101capture01a19c02-a524-7d26-b962-d941f42b7bff€49.00€0.67matched
102capture01a19c02-bfc4-7b36-8fbf-ff6c25cf60e6€49.00€0.67matched
103capture01a19c02-e4c4-7e20-bd0c-932db76f03fe€35.00€0.50matched
104refund01a19c02-ea79-7c66-8bac-c64210bb047c-€46.00€0.00matched
105capture01a19c03-0efb-7519-add7-e4d7a8d1c8e7€24.00€0.37matched
106capture01a19c03-1350-782e-b778-1118fe4ba890€24.00€0.37matched
107capture01a19c03-1643-7719-8ca1-686231243566€49.00€0.67matched
108capture01a19c03-274e-784f-839f-88d1b3a074a0€15.00€0.26matched
109capture01a19c03-4d04-7844-86e7-1013c519b9c0€15.00€0.26matched
110capture01a19c03-6eb3-78a7-ad63-a22761bd9b2a€49.00€0.67matched
111capture01a19c03-80c4-7d3e-b367-bab24d12aa59€15.00€0.26matched
112capture01a19c03-8476-77c3-84b8-b88fe4fbb859€24.00€0.37matched
113capture01a19c03-9391-7e1a-9202-247f0cbc0fc4€49.00€0.67matched
114capture01a19c03-b11c-7868-8a06-32b659b21a37€15.00€0.26matched
115capture01a19c03-bc9a-7771-8ad4-3c61abaef28d€24.00€0.37matched
116capture01a19c03-d93b-7052-a306-7c892e55e3c0€49.00€0.67matched
117capture01a19c03-ea90-77af-8acb-74288c4881e8€9.00€0.19matched
118capture01a19c04-1c40-7f69-9e35-e9da718305e3€9.00€0.19matched
119capture01a19c04-44aa-7315-bbaf-989a69fddb6d€49.00€0.67matched
120capture01a19c04-4765-7484-a902-0d6c410b163c€24.00€0.37matched
121capture01a19c04-5b8e-7f1c-82ae-65e06fb82976€9.00€0.19matched
122capture01a19c04-a33d-7d50-a992-e61cfc30d19b€24.00€0.37matched
123capture01a19c04-e78f-7d06-8494-cd9127a981a2€35.00€0.50matched
124capture01a19c04-e847-745f-99b6-db9fdc661ccb€15.00€0.26matched
125capture01a19c04-e9f0-72c5-b6f7-869f1f7f2e1a€24.00€0.37matched
126capture01a19c04-f7ea-7711-9897-e61dde8208c3€49.00€0.67matched
127capture01a19c04-fa81-78d0-b72f-e50b02ee0a4c€35.00€0.50matched
128capture01a19c05-0206-7f53-aefe-a7e447abeb5f€49.00€0.67matched
129capture01a19c05-0c21-7c3c-ae7b-ad68637d270e€35.00€0.50matched
130capture01a19c05-29f4-77e3-8b27-54be6da3bd73€9.00€0.19matched
131capture01a19c05-2f71-71c6-9d92-0d8fa0e066c3€35.00€0.50matched
132capture01a19c05-37fb-7920-bfe1-abf52d6f6b25€35.00€0.50matched
133capture01a19c05-452c-7a73-9d1d-9ecde74cdf75€15.00€0.26matched
134capture01a19c05-5bec-72d5-9176-6ceb9e2b9005€24.00€0.37matched
135capture01a19c05-7d1f-7113-9272-651dbcae3627€15.00€0.26matched
136capture01a19c05-b2f5-70de-81a9-eaa82bfd1200€35.00€0.50matched
137capture01a19c05-eef2-70ac-8236-b4cff3746575€15.00€0.26matched