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, 16:50

Gross

€2,765.00

PSP fee

€43.42

Net to the bank

€2,721.58

Settlement journal

#364416

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a257-f3d8-7823-ae33-20a4ad7853db is already settled by stl_EUR_2989542 line 5
  • missing linein the books, not in the filecapture:01a1a254-0409-7ca4-bdd5-85868e502d80 is in no file
LineKindReferenceGrossFeeStatus
1capture01a1a251-627e-7eab-ad76-fc0588c4c77e€9.00€0.19matched
2capture01a1a251-75f6-7817-aef9-5c93b4b5d5c8€9.00€0.19matched
3capture01a1a251-8d80-7f06-b15d-beebbf618ced€35.00€0.50matched
4capture01a1a251-cc3e-7252-b5d5-4665ecb2b900€24.00€0.37matched
5capture01a1a251-e720-761f-a4f2-9d8ba6dcae97€24.00€0.37matched
6capture01a1a251-ea0a-7c42-ab34-3808c6d98322€9.00€0.19matched
7capture01a1a252-5949-7c77-9503-e1621dddf668€15.00€0.26matched
8capture01a1a252-5d56-7f71-8d0f-acabf642acf3€24.00€0.37matched
9capture01a1a252-90da-7d19-8529-442630b9c2c9€9.00€0.19matched
10capture01a1a252-98da-71d0-8a68-ff8995240edd€24.00€0.37matched
11capture01a1a252-9ec0-7ff0-9142-198e95f6dd93€49.00€0.67matched
12capture01a1a252-9ee8-7c61-a219-a7d1cff63cf1€15.00€0.26matched
13capture01a1a252-be27-7e7a-b7a8-40f40a1d575a€9.00€0.19matched
14capture01a1a252-ca94-7498-9ca1-0ecc3bc69f42€24.00€0.37matched
15capture01a1a252-e55a-7093-b7f3-f88f9cb3d467€49.00€0.67matched
16capture01a1a252-f83e-7517-aa0b-33630681df49€49.00€0.67matched
17capture01a1a253-145e-7488-b5de-4def5815b539€35.00€0.50matched
18refund01a1a253-2e7c-7084-91b9-4e88da6d54a2-€31.00€0.00matched
19capture01a1a253-2f26-723f-ab91-38261f41ade4€9.00€0.19matched
20capture01a1a253-3ca6-76c4-a2c5-88ca0087ca34€9.00€0.19matched
21capture01a1a253-616f-752b-b4d4-a35169647fe9€9.00€0.19matched
22capture01a1a253-668d-7182-af43-a0a7e69932e3€15.00€0.26matched
23capture01a1a253-694e-71cd-b2c5-23cc1b567d5d€49.00€0.67matched
24capture01a1a253-930d-79cd-8a2a-2b24307f88a0€24.00€0.37matched
25capture01a1a253-ae56-7cb3-92b5-720638f055e3€35.00€0.50matched
26capture01a1a253-ae77-700c-a576-03b8268c5b71€24.00€0.37matched
27capture01a1a253-c0a5-7852-9d0c-6c2399e32bad€49.00€0.67matched
28capture01a1a253-cba3-724f-baac-5c924c2bb4e0€24.00€0.37matched
29capture01a1a253-d7ef-7750-a46a-2369fc84d945€15.00€0.26matched
30capture01a1a253-d886-72c8-acc3-c10c085a31e9€49.00€0.67matched
31capture01a1a253-db9e-7701-bafa-c1df8841c022€35.00€0.50matched
32capture01a1a253-dc00-7350-9103-c26af03ada92€24.00€0.37matched
33capture01a1a253-ef1e-7dd3-88cd-e7496fb7d2da€49.00€0.67matched
34capture01a1a253-f4c3-7edf-8e30-1939b4891d8c€9.00€0.19matched
35refund01a1a254-336d-7472-99b4-009ad6731e1a-€35.00€0.00matched
36capture01a1a254-6451-7251-b28b-670499f99bfa€15.00€0.26matched
37capture01a1a254-6826-75b9-91a4-9f59c5892e5a€9.00€0.19matched
38capture01a1a254-7ce2-7aa4-a5de-5671f625b61b€35.00€0.50matched
39capture01a1a254-8eb0-7ca5-b71f-2b31953d2b3e€15.00€0.26matched
40capture01a1a254-e689-7943-8e7f-b49d10bb7acd€9.00€0.19matched
41capture01a1a254-f32d-7eb2-82e2-d338d7092c7c€24.00€0.37matched
42capture01a1a255-117f-7d45-9b6b-78aeb8b26086€35.00€0.50matched
43capture01a1a255-3d06-7d3d-84d6-f3bd82115517€49.00€0.67matched
44capture01a1a255-4427-7cb1-86df-ffeaa1548a98€15.00€0.26matched
45capture01a1a255-4b68-7728-a7b3-7d7dcbb4f9e2€9.00€0.19matched
46refund01a1a255-53a8-7f3d-9d00-222a2cfbe891-€8.00€0.00matched
47capture01a1a255-5677-7842-8e67-7e12235c7054€35.00€0.50matched
48capture01a1a255-7777-7f41-9732-942bdfcf896b€49.00€0.67matched
49capture01a1a255-7a6e-71e2-81d2-790cb27d44a4€15.00€0.26matched
50capture01a1a255-85cb-759c-88e7-6fe77b217df4€35.00€0.50matched
51capture01a1a255-bb84-714f-8439-b3410b5bd0fc€15.00€0.26matched
52capture01a1a255-d8c7-75ce-af4d-ee1d3151df64€24.00€0.37matched
53capture01a1a255-de1e-7791-93dd-4742f8088cb6€24.00€0.37matched
54capture01a1a255-fc8d-7fb5-b00d-f6ebf70a6823€9.00€0.19matched
55capture01a1a256-040e-7592-9613-7ef9e10bea33€9.00€0.19matched
56capture01a1a256-1d0f-79f0-8c37-de0ffdffc454€15.00€0.26matched
57capture01a1a256-403e-74bb-a73c-0fe1aa49443b€9.00€0.19matched
58capture01a1a256-47b0-7244-986a-3b5e5d7d714e€49.00€0.67matched
59capture01a1a256-5b46-7479-8f41-91b86b8d793c€35.00€0.50matched
60capture01a1a256-6aa9-7c10-b383-2fc52b81c635€35.00€0.50matched
61capture01a1a256-6db4-72a7-a6fa-2322a925260b€35.00€0.50matched
62capture01a1a256-713c-7f7d-a637-9027acdc2371€9.00€0.19matched
63capture01a1a256-714e-7d92-9ac0-d6f5b6d2e828€35.00€0.50matched
64capture01a1a256-77ff-716a-869c-cba3e1d8ce5a€35.00€0.50matched
65capture01a1a256-8860-7d3f-834e-ef415293db4a€35.00€0.50matched
66capture01a1a256-a279-7028-a79f-c6b04f63d86c€24.00€0.37matched
67refund01a1a256-c699-78f9-923e-1cacfba92f21-€17.00€0.00matched
68capture01a1a256-ec9e-7485-abb2-d3ceca895aeb€15.00€0.26matched
69capture01a1a256-fca5-71a5-ad3b-9a726fc2e794€24.00€0.37matched
70refund01a1a257-12bb-706e-9951-c08a5793f5ef-€10.00€0.00matched
71capture01a1a257-1a0e-746a-958d-9d58b48f0a43€49.00€0.67matched
72capture01a1a257-4e36-7ecf-8be8-4e4becf1bad3€35.00€0.50matched
73capture01a1a257-521b-7719-a67a-798118fbc1c9€35.00€0.50matched
74capture01a1a257-58f5-75c3-b392-610a5cd7a4d7€35.00€0.50matched
75capture01a1a257-6e00-7d0a-9a15-c7cb91e667a6€35.00€0.50matched
76capture01a1a257-7000-7f06-b358-b223758a48d8€35.00€0.50matched
77capture01a1a257-78d8-771f-9cd0-86fae3fe42f0€35.00€0.50matched
78capture01a1a257-bf75-7953-9b85-e887e9092d89€24.00€0.37matched
79capture01a1a257-c36c-74a7-a29e-8fab5b9b7944€15.00€0.26matched
80capture01a1a257-ecea-7ba1-8c06-bede726804b6€49.00€0.67matched
81capture01a1a257-f1c1-706f-bda7-27b0ea5e8c5c€49.00€0.67matched
82capture01a1a258-045a-7128-a4bf-43569deacce2€49.00€0.67matched
83capture01a1a258-0b01-7a93-989e-6aa59c853d7c€15.00€0.26matched
84capture01a1a258-2dd9-76fb-9b57-bb89124ccba3€24.00€0.37matched
85capture01a1a258-4603-7c03-b617-b8a8d8a67af1€24.00€0.37matched
86capture01a1a258-57ac-793d-bd36-76c5ccdb0369€49.00€0.67matched
87capture01a1a258-5dd0-77f7-ab2b-a6de7085fdd7€35.00€0.50matched
88capture01a1a258-5f9d-7944-8d58-6463be236e20€35.00€0.50matched
89capture01a1a258-75d0-714a-92f1-7e92e2559260€15.00€0.26matched
90capture01a1a258-7b78-77ab-989e-e382ba258821€15.00€0.26matched
91capture01a1a258-8880-7549-b9cf-ee248a3fa76a€15.00€0.26matched
92capture01a1a258-d0d8-795d-9ebf-c8b42567a5ea€49.00€0.67matched
93capture01a1a258-d42c-7d58-a06d-86e803c25d92€49.00€0.67matched
94refund01a1a258-e05d-7c3e-acc1-36d7b9ea86cc-€6.00€0.00matched
95capture01a1a258-ee8b-73c2-8253-7443ae85f9f2€24.00€0.37matched
96capture01a1a259-1b38-7eae-aa62-2a75d55bba70€15.00€0.26matched
97capture01a1a259-1fa3-772b-abbf-7ca95eb792c9€15.00€0.26matched
98capture01a1a259-4908-7cab-b534-59705c42cf7e€35.00€0.50matched
99capture01a1a259-6c2b-7b30-827d-69e86e2c8de2€35.00€0.50matched
100capture01a1a259-727c-7ce6-9ed8-3aa6a2ff3ab9€49.00€0.67matched
101capture01a1a259-7729-733d-b910-fc45e99d7883€9.00€0.19matched
102capture01a1a259-a79c-76df-ae65-2e862dd786fb€15.00€0.26matched
103capture01a1a259-b914-7a02-816a-346648bab7f6€35.00€0.50matched
104capture01a1a259-beee-7a70-af8d-ce5f492a8251€15.00€0.26matched
105capture01a1a259-c2bf-7e81-b659-7a1d3a0bcbb9€35.00€0.50matched
106capture01a1a259-ea6f-73bf-a2f5-3c870d8d5381€24.00€0.37matched
107capture01a1a259-e8ac-7686-ba7b-99614bd144d1€9.00€0.19matched
108refund01a1a259-ed3a-7d46-9571-889d6bcb49a2-€13.00€0.00matched
109capture01a1a25a-0372-7d84-bf40-bf8820360824€49.00€0.67matched
110capture01a1a25a-1134-77e1-82c9-b2bed8b7ff6a€24.00€0.37matched
111capture01a1a25a-23d7-7147-baff-f37ce1eb090f€15.00€0.26matched
112capture01a1a25a-439a-71a4-ab83-346736256a03€24.00€0.37matched
113capture01a1a25a-44ea-71a2-9709-b86e310de600€24.00€0.37matched
114refund01a1a25a-6ba5-74cf-948a-270ed244e2bd-€10.00€0.00matched
115capture01a1a25a-6c67-706c-9808-c7b1229ed82a€49.00€0.67matched