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

6 Nov, 03:50

Gross

€2,747.00

PSP fee

€43.38

Net to the bank

€2,703.62

Settlement journal

#409360

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1af00-10c6-721c-8801-4aa49df7ab1e is already settled by stl_EUR_2989895 line 74
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • missing linein the books, not in the filecapture:01a1af03-5645-7d2e-8bc4-d60bf9fe725b is in no file
LineKindReferenceGrossFeeStatus
14capture01a1aefb-544a-753e-9250-19ea3e337457€24.00€0.41fee difference
67capture01a1aeff-6bed-736b-bbea-ae330a5b951c€15.00€0.31fee difference
75capture01a1af00-1124-714b-a913-73af9e414e97€9.00€0.19duplicate line
1capture01a1aef1-a2e7-702f-ab5a-1ec7793f848e€24.00€0.37matched
2capture01a1aefa-70a1-763f-ab6e-bd85573ccf67€35.00€0.50matched
3capture01a1aefa-7606-72d5-87d4-6de6715825d2€35.00€0.50matched
4capture01a1aefa-916d-7605-add4-e328fcdc4601€49.00€0.67matched
5capture01a1aefa-95a4-733c-bd10-cffebaa67659€15.00€0.26matched
6capture01a1aefa-9de4-740b-8deb-3133f71a76b4€24.00€0.37matched
7capture01a1aefa-9f81-78d2-8b2b-ac8c219e730e€15.00€0.26matched
8capture01a1aefa-a9a9-77f3-8cb2-7dccabafa6c2€49.00€0.67matched
9capture01a1aefa-b357-7a24-b4b0-4c3d6c5b26c3€9.00€0.19matched
10capture01a1aefb-113b-7c6e-a285-b9f32cf7204e€35.00€0.50matched
11capture01a1aefb-23c9-76d8-9c27-33ccddc1d774€49.00€0.67matched
12capture01a1aefb-2ec2-74cf-a614-db3fac61fe8a€24.00€0.37matched
13capture01a1aefb-32f6-7937-8832-2c2cb76366cb€49.00€0.67matched
15capture01a1aefb-66a0-7213-9386-b2b536bcff10€15.00€0.26matched
16capture01a1aefb-abb4-7ed2-a5a7-a14fe31614ac€35.00€0.50matched
17capture01a1aefb-ae47-739f-a14b-2ebb39f2809a€9.00€0.19matched
18capture01a1aefb-eccf-7701-9592-4317a78bfffc€49.00€0.67matched
19capture01a1aefb-f0b0-7e0c-917c-f6930e0ff503€35.00€0.50matched
20capture01a1aefc-1905-72f4-bb0e-447f9cac71a1€24.00€0.37matched
21capture01a1aefc-194e-7dea-bb7a-087dcbafc18f€35.00€0.50matched
22capture01a1aefc-3b63-7f5e-a870-1695b5003f92€9.00€0.19matched
23capture01a1aefc-4076-727e-a870-d5d1de048cc5€49.00€0.67matched
24capture01a1aefc-4de6-7f43-8bdc-1804a954b3c4€24.00€0.37matched
25capture01a1aefc-668b-72ae-a770-1d8581f028ad€49.00€0.67matched
26capture01a1aefc-6a92-776f-8fbd-eec6b19d1adb€9.00€0.19matched
27capture01a1aefc-7f03-7a4f-8315-4dd02197e3da€49.00€0.67matched
28capture01a1aefc-9045-7a39-b8f1-3b9b5ad29e68€15.00€0.26matched
29capture01a1aefc-9cd1-751e-a092-87d741967635€49.00€0.67matched
30capture01a1aefc-ba65-7361-b9f5-82c86eb5e977€35.00€0.50matched
31capture01a1aefc-d056-7fbb-aa2a-2b798e38c83c€24.00€0.37matched
32capture01a1aefc-da87-7e69-be9b-cebf414a73fa€24.00€0.37matched
33capture01a1aefc-e48b-74f6-be9a-a67b5d7df14d€35.00€0.50matched
34capture01a1aefc-f61e-72a0-86ba-a04c4e2d7329€49.00€0.67matched
35capture01a1aefc-f8f3-738d-b30a-d4de5328bffe€24.00€0.37matched
36capture01a1aefd-1b96-7103-a667-c04f706f8336€49.00€0.67matched
37capture01a1aefd-5b18-743e-9f85-ff84e91d0098€15.00€0.26matched
38capture01a1aefd-5f1f-725b-a231-d5db30333f67€15.00€0.26matched
39capture01a1aefd-cadf-729c-ada1-c7459d22ebc9€24.00€0.37matched
40refund01a1aefd-c7eb-7c6c-a9c8-33ec40dd4601-€7.00€0.00matched
41capture01a1aefd-e244-7c51-97d1-5ec41e1af44f€35.00€0.50matched
42capture01a1aefe-0c1b-7dd5-b295-11aa45fe549f€15.00€0.26matched
43capture01a1aefe-17e7-7db8-9410-adf08ec97d7a€49.00€0.67matched
44refund01a1aefe-1a82-7e74-bf75-c7709c74ac21-€23.00€0.00matched
45capture01a1aefe-1df0-7706-b5f9-7ab8a827d797€9.00€0.19matched
46capture01a1aefe-25fe-7b2e-b956-26ed6294ea22€24.00€0.37matched
47capture01a1aefe-273b-7518-817d-c9d1a2dd72f8€15.00€0.26matched
48capture01a1aefe-556e-7a35-85f3-4c1ce8f8b4ca€35.00€0.50matched
49capture01a1aefe-557d-75b3-b040-91bb08d912c9€49.00€0.67matched
50capture01a1aefe-6a6f-753b-a443-68de6f6bf1f9€24.00€0.37matched
51capture01a1aefe-7edc-79ca-a306-61f4bb7b73c6€15.00€0.26matched
52capture01a1aefe-9156-7e7c-a225-a08ca60ffbe8€15.00€0.26matched
53capture01a1aefe-9705-7a7d-b14b-8cbf17ad3125€35.00€0.50matched
54capture01a1aefe-b226-75e0-8b43-68f44ab3b57a€24.00€0.37matched
55capture01a1aefe-b226-7493-be44-91bd68225f72€15.00€0.26matched
56capture01a1aefe-b6bd-7348-8395-d222e773ad03€15.00€0.26matched
57capture01a1aefe-b732-7aaa-9162-39d5a8c438e7€9.00€0.19matched
58refund01a1aefe-d589-706f-b826-f5718536cd74-€4.00€0.00matched
59capture01a1aefe-e9d4-761e-9ead-cc217f3186dd€15.00€0.26matched
60capture01a1aefe-ed36-7d1d-a109-dbadcfb03556€35.00€0.50matched
61capture01a1aefe-fe1d-7278-aae2-a472c9167269€49.00€0.67matched
62capture01a1aeff-0b13-7441-b52c-0bacf7aa26ac€15.00€0.26matched
63capture01a1aeff-1751-77f7-925b-cce4ed97597c€35.00€0.50matched
64capture01a1aeff-23c6-715b-b329-acb1f8c0b8a7€24.00€0.37matched
65capture01a1aeff-25de-7421-9552-a1ee131d7da6€9.00€0.19matched
66capture01a1aeff-68f0-7818-bbc2-6462d551be2f€35.00€0.50matched
68capture01a1aeff-8ae0-72ad-8e8c-b0d8ea20ac98€15.00€0.26matched
69capture01a1aeff-a63c-7f11-9985-c041763dbaff€9.00€0.19matched
70capture01a1aeff-cd71-7850-8d00-f321149fbf97€49.00€0.67matched
71capture01a1aeff-eb2c-7c74-84da-fc67b32a1ae3€35.00€0.50matched
72capture01a1aeff-ec8a-7d00-8a4c-6ed9ec502fc9€35.00€0.50matched
73capture01a1aeff-f1b3-7046-8e6b-6db25b7e2616€35.00€0.50matched
74capture01a1af00-1124-714b-a913-73af9e414e97€9.00€0.19matched
76capture01a1af00-1ce3-71f8-9407-e7ff3a0e1a13€15.00€0.26matched
77capture01a1af00-3477-76e5-b5a5-ffe6e5c87c3e€35.00€0.50matched
78capture01a1af00-3d84-7dd4-b3f7-b12a74ae0122€49.00€0.67matched
79capture01a1af00-754d-7771-ab48-2ca825f681dd€24.00€0.37matched
80refund01a1af00-7a77-7dc7-bc24-9823f83395ff-€11.00€0.00matched
81capture01a1af00-9914-79ee-b537-8ec1748c7e93€35.00€0.50matched
82capture01a1af00-a9c1-754b-b524-f9cffb76fb28€49.00€0.67matched
83capture01a1af00-b1e2-79f6-868f-9b37e5a2ce29€35.00€0.50matched
84capture01a1af00-b43f-78e2-9200-ae1826c294d3€15.00€0.26matched
85refund01a1af00-d50d-718c-b92c-535971b91cf4-€21.00€0.00matched
86capture01a1af00-d5f3-7c56-a5cf-b6bcfe9a1415€9.00€0.19matched
87capture01a1af01-09d9-7ec7-8a4b-c7319afcf0f3€24.00€0.37matched
88capture01a1af01-0c03-7646-990f-9fc2dc2868e9€24.00€0.37matched
89capture01a1af01-1406-72a5-ac43-58cf1b6d95b6€49.00€0.67matched
90capture01a1af01-3fae-7689-b41b-91652f1bf149€9.00€0.19matched
91capture01a1af01-43dc-71a0-af67-dffa0ab1164b€24.00€0.37matched
92capture01a1af01-48a7-7f4a-a5b2-30b5d34bb0a8€9.00€0.19matched
93capture01a1af01-4f21-77bb-b24e-02c70ab65ffe€9.00€0.19matched
94capture01a1af01-8144-720e-be9e-9acd1dfc2fa2€35.00€0.50matched
95capture01a1af01-a5c0-7513-abc0-de60b4754c14€35.00€0.50matched
96refund01a1af01-c323-7522-93ad-fae5ae36ad86-€20.00€0.00matched
97capture01a1af01-ca99-777e-b323-2ded78e1bad4€15.00€0.26matched
98capture01a1af01-f019-7590-a438-bc46a60fa763€9.00€0.19matched
99capture01a1af01-f809-77fe-b3fc-a0f7d6b3287e€15.00€0.26matched
100capture01a1af01-fae3-7d6a-a59e-21f1ae3e7959€15.00€0.26matched
101capture01a1af02-01b3-7508-99cb-0df513827d05€49.00€0.67matched
102capture01a1af02-0549-7a5d-a7e3-86f02aa62d4a€24.00€0.37matched
103capture01a1af02-0dca-733a-819f-74f84a7f140c€15.00€0.26matched
104capture01a1af02-2b38-7771-8639-b74bb1810989€9.00€0.19matched
105capture01a1af02-59ac-7cd5-aa07-3e98832de7cb€15.00€0.26matched
106capture01a1af02-5b16-7a80-b1d0-e938a5f0519b€9.00€0.19matched
107refund01a1af02-6c89-75f6-82ac-0ee8aa48d633-€6.00€0.00matched
108capture01a1af02-a1de-7c78-9d4c-06f46d1a6fa9€9.00€0.19matched
109capture01a1af02-adeb-7e90-b6b5-e8c68e30c64f€35.00€0.50matched
110capture01a1af02-d42d-72a1-8b1b-7b068a203c36€15.00€0.26matched
111capture01a1af02-d632-7c54-8dbc-6444acd3bf2d€49.00€0.67matched
112capture01a1af02-e74e-7b22-a4ba-d4862d12d8f0€24.00€0.37matched
113capture01a1af02-efee-76a1-b7e3-6cb77dac7798€15.00€0.26matched
114capture01a1af02-fd89-7f3e-97be-e2d4469529bf€9.00€0.19matched
115refund01a1af03-0729-7d4a-90ea-dffb70d9bad0-€25.00€0.00matched
116capture01a1af03-3815-71f1-89ee-4dd58e725c59€9.00€0.19matched
117capture01a1af03-540e-7815-909f-c2d306f33edf€35.00€0.50matched
118capture01a1af03-67ea-797d-a186-5965980614c5€9.00€0.19matched