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, 04:30

Gross

€2,654.00

PSP fee

€42.39

Net to the bank

€2,611.61

Settlement journal

#409852

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1af27-99ff-77e5-bfe9-98b44f65f4da is already settled by stl_EUR_2989899 line 107
  • missing linein the books, not in the filecapture:01a1af22-e25d-7d5b-8c28-5c0a1cad6b25 is in no file
  • missing linein the books, not in the filecapture:01a1af26-19ea-7de8-a34e-6ee2d7d5d6ea is in no file
LineKindReferenceGrossFeeStatus
108capture01a1af27-a996-7766-9807-c58d22dc0c14€24.00€0.37duplicate line
1capture01a1af19-ade0-7668-857a-a8cb61958964€49.00€0.67matched
2capture01a1af1a-2d76-7d49-ac61-71fdc0a90be9€49.00€0.67matched
3capture01a1af1e-efa3-7fe0-bb05-e0622a1c5685€49.00€0.67matched
4capture01a1af1e-f56e-736e-a0c9-db2e98b9a872€24.00€0.37matched
5refund01a1af1f-2608-7672-b9b4-a4772fc405fd-€7.00€0.00matched
6refund01a1af1f-26c0-78c5-9fff-bd2a9a01544c-€34.00€0.00matched
7capture01a1af1f-6a88-7034-94c4-210d85df7040€35.00€0.50matched
8capture01a1af1f-723f-719a-9052-b6752836b2c5€24.00€0.37matched
9capture01a1af1f-7c3a-77ed-a739-91c12b9b4732€49.00€0.67matched
10capture01a1af1f-b90d-756d-b1fa-90a81c0d6376€24.00€0.37matched
11capture01a1af1f-b9c7-735b-a46e-8ec5acdc1d7b€49.00€0.67matched
12capture01a1af1f-be8f-72d0-9b7e-4b16b2ffb5a5€35.00€0.50matched
13capture01a1af1f-e50c-7010-b0f2-0c055d8b5b15€9.00€0.19matched
14capture01a1af20-0aaf-7dbf-bbd9-2024898765c3€9.00€0.19matched
15refund01a1af20-2413-7778-9e73-29646e22a8dd-€6.00€0.00matched
16capture01a1af20-2778-7ebb-b725-5cf7a4f69b2d€35.00€0.50matched
17capture01a1af20-2a54-7048-bd24-ffd400df54ab€24.00€0.37matched
18capture01a1af20-2ab2-795b-ac9c-d2701cfcbd85€35.00€0.50matched
19capture01a1af20-39bf-7dda-b50f-ef1fea93d84d€35.00€0.50matched
20capture01a1af20-6dd8-77b2-b341-64ea6eb13fb4€15.00€0.26matched
21capture01a1af20-7b36-7b3f-b11a-8bd113caae64€49.00€0.67matched
22capture01a1af20-c28e-7eef-9c8a-e44dcf193616€9.00€0.19matched
23capture01a1af20-d3ba-77a3-905c-0907e7a6f939€9.00€0.19matched
24capture01a1af20-efd6-7030-9ef7-9cb26868f1be€24.00€0.37matched
25capture01a1af20-f0d6-769c-874e-9fa711dc1b44€15.00€0.26matched
26capture01a1af21-0f9e-73bf-b7a2-c39c183c826a€24.00€0.37matched
27capture01a1af21-167a-7909-a19a-e5a3965d009d€35.00€0.50matched
28refund01a1af21-2da4-7dde-b68f-7e142c2984cc-€19.00€0.00matched
29capture01a1af21-51ad-727b-a492-78a44cd2f02f€9.00€0.19matched
30refund01a1af21-83e3-7c06-a544-a7af82ef1a32-€24.00€0.00matched
31capture01a1af21-a9ac-71c5-80ca-e75442a7b82a€35.00€0.50matched
32capture01a1af21-e3dd-7e25-9e9f-9f206d3abdfb€9.00€0.19matched
33capture01a1af21-eee7-731e-b5d2-39c994401899€9.00€0.19matched
34capture01a1af22-0017-7d99-9f4f-7ded435bdb0f€35.00€0.50matched
35capture01a1af22-05b6-7b8f-9614-1ff2ed7d693b€15.00€0.26matched
36capture01a1af22-2646-7a08-935b-930bd6bb2b77€9.00€0.19matched
37capture01a1af22-4c7e-787a-b092-c6d953e2c686€24.00€0.37matched
38capture01a1af22-658c-7f4d-852c-1cca5ea0f8c2€49.00€0.67matched
39capture01a1af22-903c-7774-859e-47d372f3f3c0€35.00€0.50matched
40capture01a1af22-9778-75a6-b9cc-0273d3308847€35.00€0.50matched
41capture01a1af22-b0c7-7285-892a-b3d3de7434a0€9.00€0.19matched
42capture01a1af22-b2cf-7cc1-ad92-2c9305c4c7d0€49.00€0.67matched
43capture01a1af22-b57a-768f-b563-24df664c3605€49.00€0.67matched
44capture01a1af22-bf25-79ae-bff4-93ea5a5c481a€15.00€0.26matched
45capture01a1af22-d6d2-7489-8b54-fbb9682cb3e7€35.00€0.50matched
46capture01a1af22-d85f-7330-bf09-c0f58332ef79€49.00€0.67matched
47capture01a1af22-d896-725e-9f31-f7a7817b2cd5€49.00€0.67matched
48capture01a1af22-dee2-7c16-97a3-a22922828b2d€9.00€0.19matched
49capture01a1af22-df47-777e-9b29-0e08b0b03f90€9.00€0.19matched
50capture01a1af22-e398-72b0-86b3-6c08b07118d3€35.00€0.50matched
51capture01a1af22-e60a-78cf-afd1-39328549f4bc€24.00€0.37matched
52refund01a1af22-e9e2-7d4f-8fce-80425fadec44-€30.00€0.00matched
53capture01a1af23-20fc-722b-9389-7c17029d6d8e€15.00€0.26matched
54capture01a1af23-2957-76e9-a255-0fa22274ff88€49.00€0.67matched
55refund01a1af23-33ef-7871-b528-d9852216e867-€7.00€0.00matched
56capture01a1af23-4c18-71a6-8640-8a483b603c7a€24.00€0.37matched
57capture01a1af23-5415-77c6-ab8c-fe7feaf01ac5€15.00€0.26matched
58capture01a1af23-7306-7538-8256-75e5fc18d91b€49.00€0.67matched
59capture01a1af23-9de5-7ede-a616-45698eafc156€15.00€0.26matched
60capture01a1af23-ba1e-7ce1-88fb-239935af65fe€24.00€0.37matched
61capture01a1af23-c1a2-7000-aca4-de04a37ea732€24.00€0.37matched
62capture01a1af23-c35f-7ea8-b422-b1b5847eb8be€9.00€0.19matched
63capture01a1af23-fa44-7461-83d0-5b701a9a518f€49.00€0.67matched
64capture01a1af24-17a3-761f-8c03-f834c5036986€24.00€0.37matched
65capture01a1af24-2f8e-72c4-81bb-3b7b8c57766c€35.00€0.50matched
66capture01a1af24-3fa1-776a-84d7-b4bbf8218f98€15.00€0.26matched
67capture01a1af24-49b2-743f-9d7a-cfe214b65d6f€9.00€0.19matched
68capture01a1af24-5806-7b83-b78d-8911bf97c1da€15.00€0.26matched
69capture01a1af24-61d0-783e-aa4f-8d9eb347be1f€9.00€0.19matched
70capture01a1af24-6d04-7fd5-80ff-b76347f297a1€15.00€0.26matched
71capture01a1af24-7842-762a-87e4-009bb31a1c74€9.00€0.19matched
72capture01a1af24-91f4-782c-840a-62be017d8e05€49.00€0.67matched
73capture01a1af24-92cd-72a9-ac09-9a053b87484d€49.00€0.67matched
74capture01a1af24-990d-7375-aae3-c60ccc07e6c3€9.00€0.19matched
75capture01a1af24-b4bb-7015-acb4-e568f6a6f1f8€15.00€0.26matched
76refund01a1af24-d491-796b-b9cc-5b133cbe72dc-€30.00€0.00matched
77capture01a1af24-f09d-75d1-89b8-5d0fa2f68b11€49.00€0.67matched
78capture01a1af25-1872-734b-bd00-c689725f99c6€15.00€0.26matched
79capture01a1af25-22cb-7f6c-8e29-61a27831c666€35.00€0.50matched
80capture01a1af25-5492-74b1-9973-f10083a904d8€9.00€0.19matched
81refund01a1af25-56af-7a0b-8de6-35e9bd25a41b-€10.00€0.00matched
82capture01a1af25-65d8-79b6-ba66-bce67a7dd9d6€9.00€0.19matched
83capture01a1af25-88c9-71e9-8f82-32f61150318b€9.00€0.19matched
84capture01a1af25-9c99-78cc-b375-fe715bda333e€24.00€0.37matched
85capture01a1af25-be55-7644-800e-67da718f17a3€9.00€0.19matched
86capture01a1af25-de7a-7027-884e-c602f12b646c€35.00€0.50matched
87capture01a1af26-1ea1-7eb8-b14f-c976ef05bb61€24.00€0.37matched
88capture01a1af26-1f0e-78c3-ba29-f70fd171a04b€49.00€0.67matched
89capture01a1af26-2126-7e8c-af78-648753033925€9.00€0.19matched
90capture01a1af26-4cb7-7a89-bb60-daefcb2dde1d€35.00€0.50matched
91capture01a1af26-58d4-7914-a5b8-eddafdc241b4€24.00€0.37matched
92capture01a1af26-7051-707f-a5d5-017240217fdb€24.00€0.37matched
93capture01a1af26-87a6-744e-b81c-0103a88ab58f€24.00€0.37matched
94capture01a1af26-baa2-7734-b285-9895c04f9704€49.00€0.67matched
95capture01a1af26-bd56-7a83-9476-c7430ccb0439€24.00€0.37matched
96capture01a1af26-ed58-73f1-b8cd-e739a89d2193€35.00€0.50matched
97capture01a1af27-0c1b-77f6-8a99-1196ad10fbe1€49.00€0.67matched
98capture01a1af27-316d-7db3-8ab2-601f7ac36f13€35.00€0.50matched
99capture01a1af27-31fc-7965-8c33-e85152b736e2€24.00€0.37matched
100capture01a1af27-4aff-759b-8ef0-79061b24d219€15.00€0.26matched
101capture01a1af27-6c2f-7ecb-a522-d39909291aef€49.00€0.67matched
102capture01a1af27-6c90-7c17-9f17-4f5b0c214cb0€24.00€0.37matched
103capture01a1af27-8a8c-7a9b-97b2-2f2adc80c923€24.00€0.37matched
104capture01a1af27-8ee9-71cc-a7f9-42ad67a46252€35.00€0.50matched
105capture01a1af27-925d-755e-9190-f93a6b6f316d€24.00€0.37matched
106capture01a1af27-a676-7ffe-b470-92bf5d1afda1€9.00€0.19matched
107capture01a1af27-a996-7766-9807-c58d22dc0c14€24.00€0.37matched
109capture01a1af27-b95e-77ee-a0c1-bef45452f9a4€15.00€0.26matched
110capture01a1af27-c5aa-711b-b3d2-7c1f9906f705€49.00€0.67matched
111capture01a1af27-c87e-740a-8295-1592854ca02b€9.00€0.19matched
112capture01a1af27-fb4d-7167-b66a-7d4fbea864fe€35.00€0.50matched
113capture01a1af28-0a46-7e75-9538-8885dd5d40d7€35.00€0.50matched
114capture01a1af28-0b1a-7f34-8a28-2c9bb769dc6d€15.00€0.26matched