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

3 Nov, 12:10

Gross

€2,540.00

PSP fee

€41.05

Net to the bank

€2,498.95

Settlement journal

#360865

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a152-0cad-7336-be73-57cbfcce84ca is already settled by stl_EUR_2989513 line 19
  • duplicate linethe file lists it twicerefund:01a1a153-fec2-7f27-867d-9c14762cf6a1 is already settled by stl_EUR_2989513 line 45
  • 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 42, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
  • missing linein the books, not in the filecapture:01a1a153-2053-7c33-8266-abcde2d7fb0f is in no file
  • missing linein the books, not in the filecapture:01a1a157-5d1c-7fd1-ba5f-e6acd3492c95 is in no file
LineKindReferenceGrossFeeStatus
7capture01a1a151-1b8f-7a30-8c72-40644485c70b€24.00€0.41fee difference
20capture01a1a152-0cdd-793c-9ff4-f6087efabdb8€9.00€0.19duplicate line
46refund01a1a153-fec4-7155-a0a6-d2bf13cc31d1-€8.00€0.00duplicate line
87capture01a1a157-52db-7a5c-a0a3-96dca17ed214€24.00€0.42fee difference
99capture01a1a158-bd96-7333-bcaa-72f3ac284fab€9.00€0.21fee difference
1capture01a1a148-3bb6-78fd-8826-7dde26e5797f€9.00€0.19matched
2capture01a1a14e-06f3-7faf-a06a-02370861f184€49.00€0.67matched
3capture01a1a14f-a363-7a90-8556-d892ca754b1a€24.00€0.37matched
4capture01a1a14f-f5ff-78ea-a86d-141941432aa1€24.00€0.37matched
5capture01a1a150-fb2f-72de-8a72-fe9753f74288€35.00€0.50matched
6refund01a1a151-1469-7da2-bdc7-7665abc73099-€19.00€0.00matched
8capture01a1a151-5617-79c5-8b39-147d5243c775€49.00€0.67matched
9capture01a1a151-5ffa-7837-88f5-dd061f941568€9.00€0.19matched
10capture01a1a151-7484-7830-b265-92b55ec6cdd2€9.00€0.19matched
11capture01a1a151-8a63-7a90-b00b-fdc47ca80ac0€24.00€0.37matched
12capture01a1a151-a81d-794f-8789-76592a03e177€15.00€0.26matched
13capture01a1a151-c5c4-730d-9471-6d5726853f93€15.00€0.26matched
14capture01a1a151-df60-70fe-b5b3-81e5481c04eb€35.00€0.50matched
15capture01a1a151-e3b1-7194-b94d-9134539ef76d€24.00€0.37matched
16capture01a1a151-de12-73ef-af68-aa49eda3185c€49.00€0.67matched
17capture01a1a151-eafb-7380-a561-e448ce4713b9€24.00€0.37matched
18capture01a1a151-f439-714d-afcc-a65a8e2fdc0b€9.00€0.19matched
19capture01a1a152-0cdd-793c-9ff4-f6087efabdb8€9.00€0.19matched
21capture01a1a152-3986-720e-9ca7-f42b02a4c638€15.00€0.26matched
22capture01a1a152-5376-70f9-934e-86af875f1ffe€24.00€0.37matched
23refund01a1a152-9082-7c8a-a143-d944ed61b07c-€3.00€0.00matched
24capture01a1a152-ad51-737c-a854-ec44522c3ead€24.00€0.37matched
25refund01a1a152-be92-71b1-adcf-a7efdcf33d22-€14.00€0.00matched
26capture01a1a152-d42b-7a2f-a72c-b44675fa28cd€49.00€0.67matched
27capture01a1a152-e0e8-7861-b682-cfe86554f799€9.00€0.19matched
28refund01a1a153-0874-74cf-9836-4246eaaef3ca-€13.00€0.00matched
29capture01a1a153-2125-7e1f-a1d2-4f4a3688f51f€9.00€0.19matched
30capture01a1a153-41f4-7078-bb0f-19426e296a2d€24.00€0.37matched
31capture01a1a153-4663-7c16-ba9f-689fb7c6d518€35.00€0.50matched
32capture01a1a153-7a89-7390-a72d-3766697ebb03€49.00€0.67matched
33capture01a1a153-866c-7aa5-839d-e9c7c2da4eae€9.00€0.19matched
34refund01a1a153-8672-7b15-abd2-eb0d031e88c9-€35.00€0.00matched
35capture01a1a153-8c44-7711-a7ac-d5dc1acd620b€9.00€0.19matched
36capture01a1a153-8c5d-7dcb-841b-a04ad7302626€15.00€0.26matched
37capture01a1a153-9968-7393-a25f-d398b89eb4b3€9.00€0.19matched
38capture01a1a153-a9c4-7844-a876-84424e16b846€24.00€0.37matched
39capture01a1a153-b145-7ed4-9ae6-931068328a01€15.00€0.26matched
40capture01a1a153-b786-7a71-ad01-569e280c9c03€24.00€0.37matched
41capture01a1a153-b968-7841-b9de-948274c11380€24.00€0.37matched
42capture01a1a153-ce06-7dfa-8883-b1882f6895a1€35.00€0.50matched
43capture01a1a153-eead-7a8d-ac6b-9fe08c450f98€9.00€0.19matched
44refund01a1a153-f8ed-7052-b840-89e2e4061232-€7.00€0.00matched
45refund01a1a153-fec4-7155-a0a6-d2bf13cc31d1-€8.00€0.00matched
47capture01a1a154-085e-7989-8511-fabbfe71b523€9.00€0.19matched
48capture01a1a154-0bf4-7e3e-aa27-7cb9f406e454€49.00€0.67matched
49capture01a1a154-1e99-707d-ad41-306d110f23e7€49.00€0.67matched
50capture01a1a154-322f-71de-99a5-dc075ad91bab€9.00€0.19matched
51capture01a1a154-5b56-7b43-9e74-1b58ed998b18€35.00€0.50matched
52refund01a1a154-58c7-7272-8bd3-1d8ab3d85d1d-€3.00€0.00matched
53capture01a1a154-686b-7254-bc8a-8da234b9e03f€49.00€0.67matched
54capture01a1a154-7107-7272-9d7a-e997527c3de9€24.00€0.37matched
55capture01a1a154-8bc3-7cb4-9508-c54e28075ada€24.00€0.37matched
56capture01a1a154-a288-7ee5-a800-2a9fdfc9d696€15.00€0.26matched
57capture01a1a154-a821-74b3-b903-93b26848f8fc€35.00€0.50matched
58capture01a1a154-b5f4-7db2-98c7-c6098b16ab05€35.00€0.50matched
59capture01a1a154-b655-79cd-92d8-ff9a36a35399€35.00€0.50matched
60capture01a1a154-c9dd-70e2-894e-35727ebf8421€15.00€0.26matched
61capture01a1a154-ec4d-7780-b11d-a715734cc216€9.00€0.19matched
62capture01a1a154-ef73-73d6-9afd-4dab1278c228€24.00€0.37matched
63capture01a1a155-1374-7518-a0ee-997ae8ea06a8€24.00€0.37matched
64capture01a1a155-1d7c-7da0-ba16-99e9eb192cf8€49.00€0.67matched
65capture01a1a155-2b1a-7c61-8f5b-c55e3e54e591€24.00€0.37matched
66refund01a1a155-37e8-7603-b3a5-5d68d42f34fe-€4.00€0.00matched
67capture01a1a155-4e4d-7077-91fd-79b5e422cd93€9.00€0.19matched
68capture01a1a155-a526-77d5-af7b-28eb5596e2d4€49.00€0.67matched
69capture01a1a155-c30f-79de-8624-f03dea827d86€35.00€0.50matched
70capture01a1a155-cb51-79bd-b186-8a3f059c2d44€24.00€0.37matched
71capture01a1a155-dddb-7a49-bafe-c0dd962fbb64€35.00€0.50matched
72capture01a1a155-e656-7d95-b353-eb82dc7bd169€9.00€0.19matched
73capture01a1a155-ed11-7363-ae0c-351f30a876fd€35.00€0.50matched
74capture01a1a155-f0f0-737f-ab77-ea041c478bbb€15.00€0.26matched
75refund01a1a156-4220-7ff5-9a81-ad84f66f81e5-€26.00€0.00matched
76capture01a1a156-4b14-7100-af70-97813283a081€9.00€0.19matched
77capture01a1a156-4f2c-722a-814a-eaf37685b24b€35.00€0.50matched
78capture01a1a156-5210-7a47-8563-5130be1c5002€35.00€0.50matched
79capture01a1a156-572c-774c-8480-d8ea2f6dc456€15.00€0.26matched
80capture01a1a156-8a8b-7711-b18e-59242ffd945b€35.00€0.50matched
81capture01a1a156-9f1b-7e7b-8525-78e403b52fa6€9.00€0.19matched
82capture01a1a156-fa5b-7e5f-9a56-c57500501b18€49.00€0.67matched
83capture01a1a156-ff7c-7f04-849a-3b23226270c0€15.00€0.26matched
84capture01a1a157-2d2f-7605-9ecf-21866242d322€35.00€0.50matched
85capture01a1a157-3ea5-73da-bae4-177ad9d80462€24.00€0.37matched
86capture01a1a157-4863-7256-9e56-c181f37c6541€24.00€0.37matched
88capture01a1a157-8f07-7c78-ab06-a0538e6c033d€24.00€0.37matched
89capture01a1a157-978f-757a-869d-6ca1592358b5€24.00€0.37matched
90capture01a1a157-cea6-7c20-9123-a97c49d54c46€15.00€0.26matched
91capture01a1a157-d54d-7147-a461-a7353c820efc€9.00€0.19matched
92capture01a1a157-d983-7888-8f58-26364acbbc54€49.00€0.67matched
93capture01a1a157-fb44-7ca0-aa58-9489cd924ed3€15.00€0.26matched
94capture01a1a158-17ae-712d-8237-b070890aae49€9.00€0.19matched
95capture01a1a158-2a73-7f31-a819-8be9a2d66d1e€15.00€0.26matched
96capture01a1a158-2e3e-7e43-b953-50ced8007ad5€24.00€0.37matched
97capture01a1a158-55ba-749a-bf3c-f6068ada66ce€9.00€0.19matched
98capture01a1a158-a2bd-70d1-a1d1-b69958d113be€49.00€0.67matched
100capture01a1a158-d149-7439-899f-cc24e8f4e1a4€15.00€0.26matched
101capture01a1a158-e8d5-7c7d-8f29-06e87806f404€15.00€0.26matched
102capture01a1a158-f759-7732-95c2-3d543476eb44€24.00€0.37matched
103capture01a1a158-fdaf-7efd-95c2-a931b0b7e9b7€35.00€0.50matched
104capture01a1a159-07e5-7c23-a3b1-00c940fa5811€9.00€0.19matched
105capture01a1a159-1706-7c2a-8120-d8a7a86f4e5e€49.00€0.67matched
106capture01a1a159-2012-727c-82fb-9277ed3019b8€35.00€0.50matched
107capture01a1a159-2a75-77d1-adb4-46c250045a86€15.00€0.26matched
108capture01a1a159-54d9-7ee1-b7a2-f6a05fb60a59€24.00€0.37matched
109capture01a1a159-56db-701b-a63b-5ce17bf1299a€15.00€0.26matched
110capture01a1a159-60fc-76a6-a72b-f7af4fc88abd€49.00€0.67matched
111capture01a1a159-6310-73f4-b69d-85c2637807de€35.00€0.50matched
112capture01a1a159-6553-73f9-b31a-38b2ec9ac61c€35.00€0.50matched
113capture01a1a159-80dc-7b35-91d1-75590bfecdde€24.00€0.37matched
114capture01a1a159-8af2-70c9-ac75-6054db45e14a€15.00€0.26matched
115capture01a1a159-9cf3-7355-9e7b-7ef66ffaaf20€9.00€0.19matched
116capture01a1a159-a8fd-78cc-bdef-11e04702655c€15.00€0.26matched
117capture01a1a159-ed72-7233-b6b9-42a190ce223e€49.00€0.67matched
118capture01a1a159-eed6-7215-9003-55d0928263e7€24.00€0.37matched
119capture01a1a159-f9d4-77e9-98af-72f091e48943€49.00€0.67matched