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, 08:00

Gross

€3,011.00

PSP fee

€47.94

Net to the bank

€2,963.06

Settlement journal

#375920

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a596-b8ce-7b9c-911d-105bf1998058 is already settled by stl_EUR_2989632 line 67
  • duplicate linethe file lists it twicecapture:01a1a59a-63fa-7988-99b4-ec3c42992b69 is already settled by stl_EUR_2989632 line 121
  • 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 39, the contract says 37
LineKindReferenceGrossFeeStatus
31capture01a1a594-5e5d-7c72-aeed-00cb6e15b219€49.00€0.72fee difference
68capture01a1a596-b8fe-7473-b57a-6387e79dd846€9.00€0.19duplicate line
90capture01a1a598-0774-7f75-840f-d142c4876c25€24.00€0.39fee difference
122capture01a1a59a-686d-76b1-a93b-fba43f5cf3e1€35.00€0.50duplicate line
1capture01a1a589-dd92-72ba-be0c-b9665b714b9d€24.00€0.37matched
2capture01a1a58c-6b60-75e2-94a4-d823de7f0f1f€49.00€0.67matched
3capture01a1a58c-fc80-791b-bd31-7e5116503d26€49.00€0.67matched
4capture01a1a590-4e53-77de-bb82-88fb8c5fd966€15.00€0.26matched
5capture01a1a592-2472-712c-9ab5-fe1dbeb11980€9.00€0.19matched
6capture01a1a592-7dec-7f3a-a1b8-338a6006951a€15.00€0.26matched
7capture01a1a592-803e-700a-b137-31f6a93d7e0a€9.00€0.19matched
8capture01a1a592-8988-7357-bb73-9411d5aa511a€35.00€0.50matched
9capture01a1a592-a3c4-75a1-a81d-1aa309a569f0€9.00€0.19matched
10capture01a1a592-a8da-750d-8e1f-91ef5abe8033€35.00€0.50matched
11capture01a1a592-c2ab-70ff-a488-38bbe4a7ce93€9.00€0.19matched
12capture01a1a592-df7f-796b-9fbf-89be4bbc6245€24.00€0.37matched
13capture01a1a592-f130-766f-8464-1c4f40fee33c€35.00€0.50matched
14capture01a1a592-fa92-7538-8a01-925de1126204€15.00€0.26matched
15capture01a1a593-148b-7995-8dd9-02ecce83c33a€49.00€0.67matched
16capture01a1a593-2401-743f-9f0d-b9ca6f8e13a1€24.00€0.37matched
17capture01a1a593-3363-74a7-b7cb-cf69754fa8f4€9.00€0.19matched
18capture01a1a593-88e8-74c0-a3cc-9b092ad5b4a2€9.00€0.19matched
19capture01a1a593-b56e-7732-b5f3-f8cdc519b69a€35.00€0.50matched
20capture01a1a593-bedd-79f8-abff-88d1364f00ca€9.00€0.19matched
21capture01a1a593-c1ce-78b2-a09c-7bb5ba826286€35.00€0.50matched
22capture01a1a593-dac4-7f3a-80a8-9a29f65d6286€9.00€0.19matched
23capture01a1a593-f4b2-7ebf-af99-adda25891266€49.00€0.67matched
24capture01a1a594-19bc-7293-8338-9eb6986a6461€35.00€0.50matched
25capture01a1a594-1f5d-7c78-883d-387c0182bd60€9.00€0.19matched
26capture01a1a594-22d8-79b8-827f-01f5da06d176€24.00€0.37matched
27capture01a1a594-3117-7fc0-80a9-65b0e3758c02€15.00€0.26matched
28capture01a1a594-422c-7f76-8345-e7e57a85616c€35.00€0.50matched
29capture01a1a594-515c-781b-ab31-e73d359c145c€15.00€0.26matched
30refund01a1a594-5827-7eae-bd51-051a9958d19c-€4.00€0.00matched
32capture01a1a594-8572-7221-92fb-f990d4adf3b0€24.00€0.37matched
33capture01a1a594-860e-7df5-aa02-79eed1b64330€15.00€0.26matched
34capture01a1a594-97f6-75e6-9743-0a848a6c59c0€15.00€0.26matched
35capture01a1a594-9c92-7c58-8ff7-165cd7c26113€24.00€0.37matched
36capture01a1a594-aac2-778a-af0d-87ada4ef9fc9€15.00€0.26matched
37capture01a1a594-b55f-7923-a218-d3eb4bc9b29b€24.00€0.37matched
38capture01a1a594-c8a9-733b-8c57-8a2f0fce50a3€9.00€0.19matched
39capture01a1a594-d3e5-7cc7-bf11-30324a07956c€49.00€0.67matched
40capture01a1a594-e5a5-7048-9517-c833df860549€49.00€0.67matched
41capture01a1a594-f2bb-7710-b161-77f61e90e8ee€9.00€0.19matched
42capture01a1a595-224d-7255-8985-7780c97b8a4b€49.00€0.67matched
43capture01a1a595-1f21-7558-8912-45e0ffa4ef82€24.00€0.37matched
44capture01a1a595-2ab9-7066-9029-e87a1709564e€24.00€0.37matched
45capture01a1a595-3ac7-77ed-8c77-3f63bbea74fe€24.00€0.37matched
46capture01a1a595-3e6d-709a-911a-83c98b04dd9d€24.00€0.37matched
47capture01a1a595-41ef-7cc9-8c18-99788379e2a8€15.00€0.26matched
48capture01a1a595-46a1-74b5-a4c3-386a8c49c126€35.00€0.50matched
49capture01a1a595-58ed-76ac-a04b-eda6f197e7b8€15.00€0.26matched
50capture01a1a595-5e75-73dc-8662-eb9297963cea€35.00€0.50matched
51capture01a1a595-921f-7869-ad58-a3b4be84be16€9.00€0.19matched
52capture01a1a595-92da-7d27-a9ed-20fbca7de791€24.00€0.37matched
53refund01a1a595-9f2e-7604-8bb6-d506c622884c-€4.00€0.00matched
54capture01a1a595-ad95-7fd7-be55-0d74e038c7fa€9.00€0.19matched
55capture01a1a595-d1ed-7640-a637-1b98fb1b1951€24.00€0.37matched
56capture01a1a595-e040-7a40-9c11-4a7db5dd17d1€49.00€0.67matched
57capture01a1a595-ecb8-79e9-b0e8-bd5ce497a264€9.00€0.19matched
58capture01a1a595-fe15-78e5-9d7c-e0b085a139c8€24.00€0.37matched
59capture01a1a595-fd6f-7707-9131-135542fe0da1€24.00€0.37matched
60capture01a1a596-13d0-7658-b78b-647f65ebeb2c€15.00€0.26matched
61capture01a1a596-38da-7423-880c-57319d8d4147€9.00€0.19matched
62capture01a1a596-594b-7759-b76a-85b3eb44fca7€24.00€0.37matched
63capture01a1a596-71d1-74ef-a73d-54434e956811€35.00€0.50matched
64capture01a1a596-95ec-79b1-9bdd-5a9f02b1cde7€15.00€0.26matched
65capture01a1a596-9660-7c84-b201-7caecee620c4€24.00€0.37matched
66capture01a1a596-ad21-740b-b5af-16cbe0f9d2c3€9.00€0.19matched
67capture01a1a596-b8fe-7473-b57a-6387e79dd846€9.00€0.19matched
69capture01a1a596-d4d6-70ec-97af-ff8fd290dee5€24.00€0.37matched
70capture01a1a596-d538-75fb-bf41-25de04025bcc€15.00€0.26matched
71capture01a1a596-f1c3-7637-9cb8-ccf67af8a8a2€49.00€0.67matched
72capture01a1a597-0823-78e5-ab4c-47b84a0d60a8€15.00€0.26matched
73capture01a1a597-0abf-7bbb-b7cf-6fba475ad841€24.00€0.37matched
74capture01a1a597-1403-7608-8c23-23328ca43c77€15.00€0.26matched
75capture01a1a597-1922-7eae-a27c-b6a359011dc9€15.00€0.26matched
76refund01a1a597-2d8b-7eb7-9d2b-9c3b8a82b5bd-€15.00€0.00matched
77capture01a1a597-3087-7e0f-9668-19fedad77f5c€35.00€0.50matched
78capture01a1a597-44ca-7875-a0ce-1b80c40a5086€24.00€0.37matched
79capture01a1a597-4870-71fa-bc16-a05757d8cdf9€35.00€0.50matched
80capture01a1a597-76a2-7e65-a699-c48505f2761d€24.00€0.37matched
81capture01a1a597-9619-7a50-9cb6-a4e32ce031e1€15.00€0.26matched
82capture01a1a597-a914-7a5e-9fed-6492bc343317€9.00€0.19matched
83capture01a1a597-b31d-7b3f-ba19-2615ac450bb8€15.00€0.26matched
84capture01a1a597-b458-70ad-8540-1da453b9ed92€35.00€0.50matched
85capture01a1a597-d546-7d7b-9a1b-5f75576ea43a€9.00€0.19matched
86capture01a1a597-e5f2-768c-b14b-5df626e21406€24.00€0.37matched
87capture01a1a597-e645-7305-9360-db7d7072f1b2€15.00€0.26matched
88refund01a1a597-ea1e-7d07-87ff-353029e7817a-€21.00€0.00matched
89refund01a1a598-0a34-781b-a865-8318a6904a0b-€6.00€0.00matched
91capture01a1a598-2bec-7025-8591-1821303e18c6€35.00€0.50matched
92capture01a1a598-3310-7d4a-b304-9f6a20660b30€9.00€0.19matched
93capture01a1a598-38e8-7277-b4da-1573a9326e8e€15.00€0.26matched
94capture01a1a598-4b98-78c8-81c4-c2959377b09d€49.00€0.67matched
95capture01a1a598-5125-7692-97c8-86e8ef0dd7a1€24.00€0.37matched
96refund01a1a598-5b00-7e17-9ad4-7a1341609f5d-€16.00€0.00matched
97capture01a1a598-65a8-72ec-8cb0-401e5d659f88€49.00€0.67matched
98capture01a1a598-6f58-71cb-a2d4-51de31df04a8€35.00€0.50matched
99refund01a1a598-9fb2-79c9-ac43-5f4cbd5d7541-€11.00€0.00matched
100capture01a1a598-b338-70ca-87c1-ea72b5fc0e2a€24.00€0.37matched
101capture01a1a598-c4d8-78be-99aa-5565025044df€24.00€0.37matched
102capture01a1a598-dbea-764e-89cb-fce8479099b4€49.00€0.67matched
103capture01a1a598-e033-7684-8a36-d6fc3a0aa711€35.00€0.50matched
104capture01a1a599-1889-7438-ba44-b8fb57eee34e€35.00€0.50matched
105capture01a1a599-1bfa-7472-8133-8784e67e207f€35.00€0.50matched
106capture01a1a599-2278-7d3e-b054-840137243fc8€15.00€0.26matched
107capture01a1a599-3c9d-74f3-8fee-fa98fd97f6c3€9.00€0.19matched
108capture01a1a599-3e93-7261-b3bf-0e07a38c4ec3€49.00€0.67matched
109capture01a1a599-4e22-7d2b-97b0-85f790c5bc31€9.00€0.19matched
110refund01a1a599-48e8-7e05-8995-17db08f3e540-€28.00€0.00matched
111capture01a1a599-91e3-7c76-a5b7-3cb85982d2ca€9.00€0.19matched
112capture01a1a599-95ce-703f-ba84-f64d2c8c410d€35.00€0.50matched
113capture01a1a599-a850-7768-8ae7-d64dfd11b974€9.00€0.19matched
114capture01a1a599-c331-786f-bae3-e23bea4fd93d€24.00€0.37matched
115capture01a1a599-cea8-76d4-a7df-d893dadab115€35.00€0.50matched
116capture01a1a599-df3f-7859-93bc-54f28f891adb€24.00€0.37matched
117capture01a1a59a-0af8-7725-9e28-a830fbd94d0f€49.00€0.67matched
118capture01a1a59a-2af5-7df8-92a1-fb74e22559b9€24.00€0.37matched
119capture01a1a59a-3b66-7265-a731-e750b7a5ae00€24.00€0.37matched
120capture01a1a59a-591a-70e0-aa4e-2d0ccf6b0ba3€35.00€0.50matched
121capture01a1a59a-686d-76b1-a93b-fba43f5cf3e1€35.00€0.50matched
123capture01a1a59a-74e4-71c7-8fbf-468d296c6f5a€24.00€0.37matched
124capture01a1a59a-83db-71f1-a1b7-3b72cecb6919€9.00€0.19matched
125capture01a1a59a-b610-7fd1-a3b0-bca5583025dd€24.00€0.37matched
126capture01a1a59a-e301-76b0-8d65-8391d87af593€15.00€0.26matched
127refund01a1a59a-dce2-730a-ac9d-c984728fab7e-€13.00€0.00matched
128capture01a1a59a-f4ca-7da0-812a-d7e18d750745€35.00€0.50matched
129capture01a1a59b-23c5-71b2-b5ca-eea3ca7bdbb7€49.00€0.67matched
130capture01a1a59b-2db3-7dd8-a94f-1533c2cae863€49.00€0.67matched
131capture01a1a59b-3a03-78e8-905f-12493ec59b0d€9.00€0.19matched
132capture01a1a59b-3de6-781c-85c2-33d6d39df715€49.00€0.67matched
133capture01a1a59b-41bd-798c-a3ba-66eab6f9acd5€9.00€0.19matched
134capture01a1a59b-5498-70d5-89b7-167ebdfb86da€24.00€0.37matched
135capture01a1a59b-56ca-7079-a701-ea5ac4b9e208€9.00€0.19matched
136capture01a1a59b-8436-7760-b081-2117fa13642d€24.00€0.37matched