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

2 Nov, 14:50

Gross

€2,649.00

PSP fee

€42.05

Net to the bank

€2,606.95

Settlement journal

#344613

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19cc1-112a-7859-bb3e-d06bf36b934c is already settled by stl_EUR_2989386 line 1
  • 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 31, the contract says 26
  • missing linein the books, not in the filecapture:01a19cc3-8db2-7849-87e8-2fd1c825ab53 is in no file
LineKindReferenceGrossFeeStatus
39capture01a19cc0-b966-797f-9f30-a138ca79bb10€24.00€0.42fee difference
54capture01a19cc1-9bae-7510-9094-ce5f81716a81€15.00€0.31fee difference
1capture01a19cbd-2643-7a78-85ff-8436cb778402€9.00€0.19matched
2capture01a19cbd-2d24-74b6-8ca8-baa8bedd0b14€35.00€0.50matched
3capture01a19cbd-396f-7518-9c79-6074ae4ee332€49.00€0.67matched
4capture01a19cbd-41e5-7a7d-b145-4b2f70decb53€49.00€0.67matched
5capture01a19cbd-47e6-7077-b7c2-bcec381bec1b€15.00€0.26matched
6capture01a19cbd-5a51-7d75-a766-c69bd83f9337€15.00€0.26matched
7capture01a19cbd-68b5-74e4-a0c9-bede2e1ed755€15.00€0.26matched
8capture01a19cbd-795f-70fc-9814-2b7c5b64ddf2€24.00€0.37matched
9capture01a19cbd-9607-7f49-b31d-a0d11b64cf94€49.00€0.67matched
10capture01a19cbd-d789-7dd1-8c98-09061716fcac€49.00€0.67matched
11capture01a19cbe-106e-794a-a38a-9bd69b2468d1€15.00€0.26matched
12capture01a19cbe-491c-7f75-afbf-1ba14027fc3a€24.00€0.37matched
13capture01a19cbe-6883-72f0-a9c4-8d864c090d85€35.00€0.50matched
14capture01a19cbe-793c-7665-9b9f-80d8d203c577€15.00€0.26matched
15capture01a19cbe-874f-70a4-bd25-f6fc4a5b60ee€15.00€0.26matched
16capture01a19cbe-8c75-74cb-8227-5070976a4c35€9.00€0.19matched
17capture01a19cbe-92d2-7366-b019-e4cc998cd5c2€35.00€0.50matched
18capture01a19cbe-96d2-78ca-afa9-f116a811dce4€24.00€0.37matched
19capture01a19cbe-9b56-7b71-8a3c-d3f732695d99€24.00€0.37matched
20capture01a19cbe-ccab-7900-aa75-39d0b1a74d9b€9.00€0.19matched
21capture01a19cbe-d142-7905-9cc4-6b1c3f717752€24.00€0.37matched
22refund01a19cbf-2a2e-7453-8699-c1ed2cbabd68-€5.00€0.00matched
23capture01a19cbf-2bc2-74df-bf00-f4f939909028€49.00€0.67matched
24capture01a19cbf-4884-77a2-9a42-6cd1a55fb291€49.00€0.67matched
25capture01a19cbf-4b3c-7bc7-8ec2-4c31fad74c3e€15.00€0.26matched
26capture01a19cbf-5769-7c38-bf8b-237d173cf2ab€49.00€0.67matched
27capture01a19cbf-7ec6-752f-8920-488059f0f88c€49.00€0.67matched
28capture01a19cbf-9be9-77c3-bddb-b4423c26bb7b€35.00€0.50matched
29capture01a19cbf-bde6-7238-93c5-88e4fea709ba€24.00€0.37matched
30capture01a19cbf-c81a-7296-9972-8ab322e30fc5€49.00€0.67matched
31capture01a19cbf-e461-7ea6-9581-95f1777d3549€24.00€0.37matched
32capture01a19cbf-f948-7a67-af7a-b418e780cc20€15.00€0.26matched
33capture01a19cc0-064a-78f6-b3dd-729264c93132€49.00€0.67matched
34capture01a19cc0-289c-758b-b5c8-e662d7434911€15.00€0.26matched
35capture01a19cc0-3b0e-7d19-b684-4a5461bb9c14€9.00€0.19matched
36capture01a19cc0-3d72-7908-9280-9dbae1232f92€49.00€0.67matched
37capture01a19cc0-41d4-73f2-b143-1d55ae629c95€24.00€0.37matched
38capture01a19cc0-937d-785a-b8e6-201f219eba6a€24.00€0.37matched
40capture01a19cc0-cbdb-7cbb-8e6a-ae18ab95f781€24.00€0.37matched
41capture01a19cc0-df80-748c-8787-45a200add6d6€24.00€0.37matched
42capture01a19cc0-e14a-7c17-8dda-92e0c5c01dfb€49.00€0.67matched
43capture01a19cc1-010f-73db-82c8-4f1db0cbde55€24.00€0.37matched
44capture01a19cc1-19f0-7531-9590-c3a7133413bb€15.00€0.26matched
45capture01a19cc1-1df2-7134-9942-e819ae167b8c€24.00€0.37matched
46capture01a19cc1-228f-762e-a432-2fb63bccf40b€49.00€0.67matched
47capture01a19cc1-4b2f-7de6-8e3e-4552ab331de7€9.00€0.19matched
48capture01a19cc1-4437-7d90-bfd8-3fcb7f842f7a€24.00€0.37matched
49capture01a19cc1-5962-7c29-99b9-86648de9b35d€9.00€0.19matched
50capture01a19cc1-5de9-7e6c-934d-3524b5fe17a5€35.00€0.50matched
51capture01a19cc1-7a74-78a0-b708-7e2a9164fcb2€9.00€0.19matched
52capture01a19cc1-90f8-7316-bc6d-6976c4d2e397€35.00€0.50matched
53capture01a19cc1-9540-7712-add9-838f7405bbc5€9.00€0.19matched
55capture01a19cc1-a4ab-7f41-8d7c-53ec87af1774€24.00€0.37matched
56capture01a19cc1-adb4-7a79-b488-c424bd5bb707€24.00€0.37matched
57capture01a19cc1-b6d9-7b64-80c9-c467db37eef5€15.00€0.26matched
58capture01a19cc1-bbb4-7267-b09a-7bf8c750075b€15.00€0.26matched
59capture01a19cc1-e715-709a-98b3-5a51d90e1e68€35.00€0.50matched
60capture01a19cc2-3359-765a-ad36-002cc3e5599f€35.00€0.50matched
61capture01a19cc2-34c3-7110-a31d-df1b6b2dbbb1€35.00€0.50matched
62capture01a19cc2-399e-786d-b0fe-a64017923c15€9.00€0.19matched
63capture01a19cc2-3cf5-7442-82c4-60d5a5689d57€15.00€0.26matched
64capture01a19cc2-434e-739e-8d3c-db82090f4745€24.00€0.37matched
65capture01a19cc2-5622-79ef-8697-26a5ab5c472b€35.00€0.50matched
66capture01a19cc2-6bdf-70c4-bf36-f5af02a9efdd€35.00€0.50matched
67capture01a19cc2-7618-7aa6-b68b-d73a3ec29941€15.00€0.26matched
68capture01a19cc2-77d7-7211-a924-4615b1810bd9€9.00€0.19matched
69capture01a19cc2-88c6-7658-bce7-afe85d52f2dc€49.00€0.67matched
70capture01a19cc2-9179-7511-91e0-e54f89e82433€35.00€0.50matched
71capture01a19cc2-af3d-7143-be75-d1303ec7226f€49.00€0.67matched
72capture01a19cc2-cd42-704b-862b-dfb174cdf464€15.00€0.26matched
73capture01a19cc2-dafd-7875-965b-5a1baae342b3€49.00€0.67matched
74capture01a19cc2-de33-7e0b-83f7-5e1fd8a104d1€24.00€0.37matched
75capture01a19cc2-eaaa-754e-8cbe-5b281945a7de€35.00€0.50matched
76capture01a19cc2-f42f-7402-91a3-bfd6375a33df€49.00€0.67matched
77capture01a19cc2-fa4e-75ef-b1af-a4954c19c67e€15.00€0.26matched
78capture01a19cc2-fc18-7f41-b59d-495c8c51aa86€35.00€0.50matched
79refund01a19cc3-06b0-72b1-8f9b-e279979dd5a9-€8.00€0.00matched
80refund01a19cc3-3645-7be2-992d-ab94a7b4e39b-€45.00€0.00matched
81capture01a19cc3-4fce-7623-9990-39886110798c€24.00€0.37matched
82refund01a19cc3-5dd8-72f8-b9f4-72e9de854ff8-€34.00€0.00matched
83capture01a19cc3-9134-76a8-a50d-268a2b346f9d€9.00€0.19matched
84refund01a19cc3-b339-72c9-98cf-ae63524a71c4-€5.00€0.00matched
85capture01a19cc3-d4f0-7985-b951-de2cda72c5c8€15.00€0.26matched
86capture01a19cc3-e205-7f8d-ba62-d1d48bed0d1c€9.00€0.19matched
87capture01a19cc4-347d-7f82-9539-76cf9395061c€9.00€0.19matched
88capture01a19cc4-3a9a-7dfa-b55b-4b286997fc4c€24.00€0.37matched
89capture01a19cc4-7333-7d92-b4ec-f796a36c112a€9.00€0.19matched
90capture01a19cc4-79c3-7c25-8fcb-e721d5b49b66€15.00€0.26matched
91capture01a19cc4-a401-78ef-a68d-4dffbef0229c€15.00€0.26matched
92capture01a19cc4-ae6d-7a2f-a7d1-126b35f22b5f€9.00€0.19matched
93capture01a19cc4-b81b-7224-a9ef-c66d3c68acb6€24.00€0.37matched
94capture01a19cc4-b8f1-72a4-a83b-93bbda506260€15.00€0.26matched
95capture01a19cc4-e02b-7a9f-a00b-792476894c90€49.00€0.67matched
96capture01a19cc4-ebd9-7dc5-b940-413b01e40269€49.00€0.67matched
97capture01a19cc5-289f-7f73-948e-51d15b9157ed€9.00€0.19matched
98capture01a19cc5-2b74-7620-9028-e066a3f8def3€24.00€0.37matched
99refund01a19cc5-231f-7d8e-8488-797a78f6d97e-€39.00€0.00matched
100capture01a19cc5-337e-76a9-adcf-1c494ec4fe8a€35.00€0.50matched
101capture01a19cc5-39a5-7238-bc7e-ee9753056442€35.00€0.50matched
102capture01a19cc5-3d11-72f5-b7a9-d365e09e6f25€24.00€0.37matched
103capture01a19cc5-a743-7a4c-b0a9-d703f5ecc47c€49.00€0.67matched
104capture01a19cc5-a85d-7400-9877-3fa98062cf33€24.00€0.37matched
105capture01a19cc5-b64a-73e7-ab48-83ee752e989f€49.00€0.67matched
106capture01a19cc5-e87c-7399-8e4a-9b89cd2c9492€15.00€0.26matched
107capture01a19cc5-f1cb-78be-b871-083fffd5e5c8€24.00€0.37matched
108capture01a19cc5-f295-7285-95ff-e797279b271e€24.00€0.37matched
109capture01a19cc5-f3eb-7bf4-8981-8d4ab4a8eb14€24.00€0.37matched
110capture01a19cc6-1c38-7c41-9bcb-bfe657436216€35.00€0.50matched
111capture01a19cc6-1fef-7df5-8dfb-7e8e5fe5a314€15.00€0.26matched