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

4 Nov, 05:20

Gross

€2,915.00

PSP fee

€46.41

Net to the bank

€2,868.59

Settlement journal

#373938

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a508-57cf-7eaa-b847-8e80c475bc95 is already settled by stl_EUR_2989616 line 120
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • missing linein the books, not in the filecapture:01a1a503-f251-7261-90aa-91febb3e873d is in no file
LineKindReferenceGrossFeeStatus
120capture01a1a508-57f1-7db8-9185-b363d6ad8999€9.00€0.20fee difference
121capture01a1a508-57f1-7db8-9185-b363d6ad8999€9.00€0.20duplicate line
1capture01a1a4fb-5b5c-70a7-879b-51a30e6bf0c3€49.00€0.67matched
2capture01a1a4fe-b53f-7d43-8b34-0e79c9e66ad0€9.00€0.19matched
3capture01a1a4ff-f82b-765b-bbac-d69f26eaddc3€49.00€0.67matched
4capture01a1a500-06d7-7751-9297-6175e6d71636€49.00€0.67matched
5capture01a1a500-1289-7d1f-9af6-41c68e394536€24.00€0.37matched
6capture01a1a500-1809-7118-805d-c9eb0c379ef1€15.00€0.26matched
7capture01a1a500-41e8-7be9-a481-771b3a030baf€9.00€0.19matched
8capture01a1a500-4999-7024-b8d6-2b6a10959b36€15.00€0.26matched
9refund01a1a500-568e-7be9-9ea7-fa8207ca86c5-€8.00€0.00matched
10capture01a1a500-5d6d-7fda-a27f-9243faa025a4€9.00€0.19matched
11capture01a1a500-5ef1-7045-b143-6dc1fc7b4112€15.00€0.26matched
12capture01a1a500-628f-7547-b57d-09c6f1703c9e€49.00€0.67matched
13capture01a1a500-813e-7913-b11d-206e50e2b12e€15.00€0.26matched
14capture01a1a500-8a47-7d13-841f-5e4e26fef4c7€9.00€0.19matched
15capture01a1a500-9036-722a-b539-50698c7b1bc3€24.00€0.37matched
16capture01a1a500-924a-7e11-84df-2d833747f516€24.00€0.37matched
17capture01a1a500-d38c-70a1-b222-1d73f5ce43b4€24.00€0.37matched
18capture01a1a501-0200-7468-b8f0-f7dc56d897d5€35.00€0.50matched
19capture01a1a501-322c-76b2-a6ce-a27483371d71€24.00€0.37matched
20capture01a1a501-47eb-7ed4-9466-0a32a1d18dc7€9.00€0.19matched
21capture01a1a501-5d6f-779b-bc2b-34b6b66c43fc€24.00€0.37matched
22capture01a1a501-693c-7253-9260-571de3ed43c2€35.00€0.50matched
23capture01a1a501-6aea-7548-bbb1-0165c7d1d371€35.00€0.50matched
24capture01a1a501-8d09-7f89-86db-4955a9277599€15.00€0.26matched
25capture01a1a501-bd8e-745f-9acd-adebcdf4eede€15.00€0.26matched
26capture01a1a501-c719-7c4f-a84e-7d72858a84ae€24.00€0.37matched
27capture01a1a501-cb1b-7ca0-b741-88365940e3fe€9.00€0.19matched
28capture01a1a501-cee2-7dda-9aed-5305971be49c€24.00€0.37matched
29capture01a1a501-d3e8-7335-a874-1b29c1a5ef52€9.00€0.19matched
30capture01a1a501-ec6e-7583-814e-71f2ba7a0ee1€9.00€0.19matched
31capture01a1a501-ee35-7586-ad7c-605fd4644e51€9.00€0.19matched
32capture01a1a501-f055-7e9f-8d71-af99065d9796€15.00€0.26matched
33capture01a1a502-030e-7b1f-ad9d-39eac6359b75€9.00€0.19matched
34capture01a1a502-0610-7462-87f2-d346a53f0ad0€49.00€0.67matched
35capture01a1a502-11b9-70ac-9c9b-7d8a1cec1a2e€49.00€0.67matched
36capture01a1a502-3add-7423-b738-3a93e3084293€15.00€0.26matched
37capture01a1a502-5069-7e77-9f4d-95e48cfab7ad€15.00€0.26matched
38refund01a1a502-5fb4-7dd2-8566-85baf521f9c4-€6.00€0.00matched
39capture01a1a502-6171-712e-a3dc-e611514833cf€49.00€0.67matched
40capture01a1a502-6c43-7ba2-8d30-9a3b48fcf6b0€49.00€0.67matched
41capture01a1a502-8ed1-7664-82c3-494b71552a43€49.00€0.67matched
42capture01a1a502-9397-7255-8b93-b0819c46b24f€35.00€0.50matched
43capture01a1a502-9b4b-7333-b248-895a2dd08f1c€24.00€0.37matched
44capture01a1a502-aa5e-70bf-99f7-8745be3b901e€35.00€0.50matched
45capture01a1a502-b286-7f40-a536-0f72b56e23ce€35.00€0.50matched
46capture01a1a502-b805-7ce8-ba9e-f23a19098fe8€49.00€0.67matched
47capture01a1a502-c496-7304-99ac-f4fbd0d1a841€15.00€0.26matched
48capture01a1a502-c588-7f8d-88f6-9e1f7aecbf7e€9.00€0.19matched
49capture01a1a502-cc9f-7803-9798-7c53f906d729€49.00€0.67matched
50capture01a1a502-dd28-7a4a-92d6-399c989e46da€49.00€0.67matched
51capture01a1a502-e903-781e-b92f-d539a96b5288€35.00€0.50matched
52capture01a1a502-f800-7c92-89e2-c56a457ebce6€49.00€0.67matched
53refund01a1a502-f9b3-7d83-990e-51b0a7c22dc1-€29.00€0.00matched
54capture01a1a503-11a2-725e-aafb-c7207c44b0cb€35.00€0.50matched
55capture01a1a503-2262-7006-8cd8-5f3fd1355b00€24.00€0.37matched
56capture01a1a503-2aa1-73c8-a0be-413eb5d7287e€35.00€0.50matched
57capture01a1a503-47da-75fc-878f-1ce6d26ff66c€35.00€0.50matched
58capture01a1a503-586d-7d54-b1f6-834d8f1d4b96€15.00€0.26matched
59capture01a1a503-7adf-7eaf-955a-5a81cdbd7a09€35.00€0.50matched
60capture01a1a503-81b7-7721-9186-c43e204139a2€49.00€0.67matched
61capture01a1a503-850a-7086-85f7-43a8cf54d4fc€15.00€0.26matched
62capture01a1a503-97e2-709d-9b99-54a599b1d67f€49.00€0.67matched
63capture01a1a503-c864-704d-9a16-cbbd4ba11793€49.00€0.67matched
64capture01a1a503-d358-7b2f-8d24-93d604465b3f€24.00€0.37matched
65capture01a1a503-e0bd-7eb6-acad-e6a78b76f247€24.00€0.37matched
66capture01a1a504-0034-7d44-9bf1-f0f75fc91048€9.00€0.19matched
67capture01a1a504-4a3d-736b-aba5-a75d67926ccb€49.00€0.67matched
68capture01a1a504-5541-74cb-a5e8-c684e9cee987€24.00€0.37matched
69capture01a1a504-4f55-77a3-9cab-66f9ee3e7d07€9.00€0.19matched
70capture01a1a504-5cfb-76ec-84db-81bf2f3889ca€9.00€0.19matched
71capture01a1a504-5f8d-7888-8a6a-8f9b2922fb07€15.00€0.26matched
72capture01a1a504-63df-7f60-8cd6-f4c6b41d3ce9€24.00€0.37matched
73capture01a1a504-70b2-78c0-9a53-2f23c62675ef€35.00€0.50matched
74capture01a1a504-850e-78ae-8961-2e3838e54741€9.00€0.19matched
75capture01a1a504-b2c3-736c-b6b7-6953aac96d93€15.00€0.26matched
76capture01a1a504-b847-7552-b3e8-15cd46c598b4€9.00€0.19matched
77refund01a1a504-e563-748a-9fc5-e7c899d008b1-€5.00€0.00matched
78capture01a1a505-1062-71b5-b279-986672c5be6e€24.00€0.37matched
79capture01a1a505-3d5f-7395-aeba-cd717f2053a4€15.00€0.26matched
80capture01a1a505-405f-73ed-b2d4-23a580b7fb95€9.00€0.19matched
81capture01a1a505-652b-77b2-afe2-217057e3b8eb€35.00€0.50matched
82capture01a1a505-6600-7dc4-beae-52ba9a2f4d88€9.00€0.19matched
83capture01a1a505-7e5e-7139-a6e3-fbe82811219a€49.00€0.67matched
84capture01a1a505-8427-7db5-a827-6319350a2910€24.00€0.37matched
85capture01a1a505-87f5-7fd8-bdff-297f41eb5ffb€24.00€0.37matched
86capture01a1a505-8c0d-7ee9-a6e1-c252275a71c0€35.00€0.50matched
87capture01a1a505-ab00-73b4-ac09-539a88e23cb1€49.00€0.67matched
88refund01a1a505-f7b7-759f-9ada-2c37f5dd57be-€13.00€0.00matched
89capture01a1a505-fad3-7830-bdfe-021f2d79183c€9.00€0.19matched
90capture01a1a506-2986-73d0-b4f8-d4b7a3629327€35.00€0.50matched
91capture01a1a506-357a-7fc0-84e1-40d27d46f7d4€35.00€0.50matched
92capture01a1a506-4577-72fa-8253-5f6aa2193e07€15.00€0.26matched
93refund01a1a506-4985-7889-b571-f6c733093248-€7.00€0.00matched
94capture01a1a506-8bc5-7387-bc99-e4c26f783d64€15.00€0.26matched
95capture01a1a506-ab23-7a5d-a5d0-c481eeacc00d€35.00€0.50matched
96capture01a1a506-c414-740d-aa3c-42f2dd9e7768€24.00€0.37matched
97refund01a1a506-cdc6-7068-b28a-0f4e40153218-€9.00€0.00matched
98capture01a1a506-cf86-77b8-9cfb-99308cea88c3€9.00€0.19matched
99capture01a1a506-e241-792d-900c-d285fb2aef0a€9.00€0.19matched
100capture01a1a506-e2b5-778b-948d-244ef7898a12€35.00€0.50matched
101capture01a1a507-1043-7c5d-978f-820b482a6847€15.00€0.26matched
102capture01a1a507-42ee-7d73-b720-597e74d0adf5€49.00€0.67matched
103capture01a1a507-6bf6-7e71-ad52-4867a5f61e9f€35.00€0.50matched
104capture01a1a507-6cfe-7505-9626-18b43d9ab944€9.00€0.19matched
105capture01a1a507-921e-7103-967e-b75160e740e4€24.00€0.37matched
106refund01a1a507-9652-7d37-af0a-9de4503635ba-€8.00€0.00matched
107capture01a1a507-c065-7827-81e4-235b40f662ae€49.00€0.67matched
108capture01a1a507-c801-75e3-bc6c-37da22e58e54€9.00€0.19matched
109capture01a1a507-f97f-7337-ae75-93cae8ff8b23€15.00€0.26matched
110capture01a1a507-fa12-72ac-876b-791b3e2b9c28€35.00€0.50matched
111capture01a1a507-faec-793f-9923-25036f2b6e1c€24.00€0.37matched
112capture01a1a508-0441-7d82-8bc9-a9b44358e544€9.00€0.19matched
113capture01a1a508-0de0-7861-a46f-67893e3d9bf4€15.00€0.26matched
114capture01a1a508-20af-7086-bcbc-f6f3e7f4b1f3€24.00€0.37matched
115refund01a1a508-3801-71d7-a2fc-69cf526df573-€21.00€0.00matched
116capture01a1a508-3bd2-7a18-972f-5f0cffd9ea7a€35.00€0.50matched
117capture01a1a508-3f31-78d3-bbbe-e940162fb1c5€24.00€0.37matched
118capture01a1a508-50b1-72ef-982a-b9ecc262a5b9€15.00€0.26matched
119capture01a1a508-552e-7710-b8d6-d6149dfe9a22€15.00€0.26matched
122capture01a1a508-5c54-7b47-916a-a03686076ee4€35.00€0.50matched
123refund01a1a508-78c7-7dc7-bf90-5b82909dcc83-€15.00€0.00matched
124capture01a1a508-c1ad-7721-97fa-b2926e54c906€15.00€0.26matched
125capture01a1a508-d07b-7220-b3c3-5935d1c9fe6c€9.00€0.19matched
126capture01a1a508-d940-7ffe-adb2-81f22d17bc61€9.00€0.19matched
127refund01a1a508-ef20-754b-8eb1-9cd5d8cdb756-€11.00€0.00matched
128capture01a1a508-fb33-7d50-916e-670aadd42aae€9.00€0.19matched
129capture01a1a508-ff8d-747d-8204-e53694517761€35.00€0.50matched
130capture01a1a509-0060-71d2-b094-62e1f780b847€9.00€0.19matched
131capture01a1a509-0566-7420-a41d-c0cf7570a31c€35.00€0.50matched
132capture01a1a509-08d0-7a50-bc10-5aa44eb0b20e€35.00€0.50matched