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

5 Nov, 07:10

Gross

€2,554.00

PSP fee

€40.20

Net to the bank

€2,513.80

Settlement journal

#393536

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aa8b-1eab-7015-8346-099e8f41acd0 is already settled by stl_EUR_2989771 line 1
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a1aa8e-f78c-7ccc-8095-ddea857d5515 is in no file
LineKindReferenceGrossFeeStatus
2capture01a1aa8b-1f1b-7cb7-9fe0-e6461e223090€49.00€0.67duplicate line
10capture01a1aa8c-350b-700e-8959-54d50cc0069e€49.00€0.68fee difference
49capture01a1aa8f-c16a-79e9-87ea-187ed4e74e7c€9.00€0.23fee difference
51capture01a1aa8f-ded7-767c-b24a-d86fa9e564a8€49.00€0.72fee difference
1capture01a1aa8b-1f1b-7cb7-9fe0-e6461e223090€49.00€0.67matched
3capture01a1aa8b-4e71-7bb6-974e-d0affe721671€15.00€0.26matched
4capture01a1aa8b-5048-7931-abd7-2a558fab1a01€24.00€0.37matched
5capture01a1aa8b-6399-779c-b1a9-3d36c867f3fe€35.00€0.50matched
6capture01a1aa8b-8ba0-747a-b8c4-710491f61439€35.00€0.50matched
7capture01a1aa8b-9e77-73a9-af2b-13b99080914b€49.00€0.67matched
8capture01a1aa8b-e64e-7fe3-ac08-c8abed90ad6a€49.00€0.67matched
9capture01a1aa8c-27d0-70b4-bc14-7a03fe30b15c€35.00€0.50matched
11capture01a1aa8c-4bcd-7de3-9ed8-96f9d127aa97€9.00€0.19matched
12capture01a1aa8c-4ce4-702b-b9ae-658bb8d705ee€15.00€0.26matched
13capture01a1aa8c-58f5-7f2b-bbcb-ac7b32800a92€9.00€0.19matched
14capture01a1aa8c-5d6c-771d-b885-b1cd2da501c6€15.00€0.26matched
15refund01a1aa8c-9660-79c6-825a-8e17b1e1fbb0-€21.00€0.00matched
16capture01a1aa8c-ac65-7b49-9244-e93c63877e48€49.00€0.67matched
17capture01a1aa8c-eb74-740c-9793-f17e833507d5€35.00€0.50matched
18refund01a1aa8c-fcc2-7649-bbae-872a15e91833-€44.00€0.00matched
19capture01a1aa8d-13ca-79c7-a4a4-53eee877033f€35.00€0.50matched
20capture01a1aa8d-1e5c-754c-abfd-5c074aedd309€49.00€0.67matched
21capture01a1aa8d-20c2-7e4e-960d-dc4dbe76459d€49.00€0.67matched
22capture01a1aa8d-6772-762c-94ca-8d48ed6c782e€9.00€0.19matched
23refund01a1aa8d-8726-7ceb-87d8-cd871b52a0e1-€15.00€0.00matched
24capture01a1aa8d-b187-7607-ac0e-748474392f68€49.00€0.67matched
25capture01a1aa8d-e5d8-70c7-a158-5eae4bc2a475€35.00€0.50matched
26capture01a1aa8d-f008-7c33-ab71-5a8644dbb398€9.00€0.19matched
27capture01a1aa8e-00c9-7261-974c-8811a08427d4€9.00€0.19matched
28capture01a1aa8e-03f7-7e64-9216-5763e39e70c7€9.00€0.19matched
29capture01a1aa8e-2f24-7f8c-94e3-6bdea184c5c4€35.00€0.50matched
30capture01a1aa8e-6cd7-79f5-a2d5-c9147f13342e€49.00€0.67matched
31capture01a1aa8e-76f9-7e3a-a5f7-01eabaa8a0a0€15.00€0.26matched
32capture01a1aa8e-837e-77cb-972f-98758c45050b€24.00€0.37matched
33capture01a1aa8e-92c7-7574-8906-fc793eb04b31€35.00€0.50matched
34capture01a1aa8e-96b4-7fe3-808d-5e5cca5e5055€9.00€0.19matched
35capture01a1aa8e-a680-7bfd-bc5c-2f2df4968d66€35.00€0.50matched
36capture01a1aa8e-bfd0-7f14-ac85-4c61087b5dfb€24.00€0.37matched
37capture01a1aa8e-e498-7620-babc-388fcc172d20€49.00€0.67matched
38capture01a1aa8e-f75b-7ed3-b61e-a3ad88b150cb€24.00€0.37matched
39capture01a1aa8f-02e6-7baa-bdbe-ffb841d6b9f8€15.00€0.26matched
40capture01a1aa8f-14c0-708f-9431-b36f39f0e218€15.00€0.26matched
41capture01a1aa8f-5130-7d79-bfa6-df926bb23289€24.00€0.37matched
42capture01a1aa8f-6abd-7b93-9e83-8941742d83d0€24.00€0.37matched
43capture01a1aa8f-6f0c-7428-99e4-e0f44c65989e€49.00€0.67matched
44capture01a1aa8f-7399-7dc7-968d-ddd31e580508€15.00€0.26matched
45capture01a1aa8f-8047-7099-8364-7b17aab01939€24.00€0.37matched
46capture01a1aa8f-8f88-764e-b558-236fb0dba5fa€24.00€0.37matched
47capture01a1aa8f-aa50-7e90-8480-75726001ba13€9.00€0.19matched
48capture01a1aa8f-c09e-73c7-b241-93502413b24b€35.00€0.50matched
50capture01a1aa8f-d865-7199-a6dd-21ec1c20a243€9.00€0.19matched
52refund01a1aa8f-e555-7923-b9ef-f635e37f61c8-€23.00€0.00matched
53capture01a1aa8f-f1ea-72d2-b80f-7a7a5b6f31f3€24.00€0.37matched
54capture01a1aa90-281e-7fa1-a5ad-3a6eb422f39f€24.00€0.37matched
55capture01a1aa90-299b-78e6-a3f8-058460082261€24.00€0.37matched
56capture01a1aa90-31ad-7440-ac56-20edcb4f2292€24.00€0.37matched
57capture01a1aa90-4e4c-7afb-a059-6c8613193ee3€49.00€0.67matched
58capture01a1aa90-5051-7101-b629-5ff2a588ebbb€15.00€0.26matched
59capture01a1aa90-6416-7e72-a556-5240a831da58€49.00€0.67matched
60capture01a1aa90-69d5-7f3a-a30a-17706ccd7738€24.00€0.37matched
61capture01a1aa90-8281-7c8a-a1ef-599b3a2c7158€49.00€0.67matched
62capture01a1aa90-9401-74d5-a4f5-3877813d732b€35.00€0.50matched
63capture01a1aa90-ac98-7714-b2fe-fa91f1ed6284€15.00€0.26matched
64capture01a1aa90-e4cc-74c9-af09-07c760f2bf98€24.00€0.37matched
65capture01a1aa90-f1c6-74e9-ac25-d3068fdfaca0€24.00€0.37matched
66capture01a1aa90-f956-7775-bc9a-abd810bfeb9f€9.00€0.19matched
67capture01a1aa91-0f8e-7e8c-a80c-5b4c702f5121€35.00€0.50matched
68capture01a1aa91-2d6c-7978-8723-09b014105b70€35.00€0.50matched
69refund01a1aa91-4301-7da9-a48f-6e22fcd6843f-€6.00€0.00matched
70refund01a1aa91-49ca-73dc-8ded-e24c4c4e5463-€17.00€0.00matched
71capture01a1aa91-4e9f-7383-8bbb-3b82773df45c€9.00€0.19matched
72capture01a1aa91-50fd-7290-a019-b951d8156c5e€15.00€0.26matched
73capture01a1aa91-8784-7769-8d70-d89686dc7043€15.00€0.26matched
74capture01a1aa91-aefe-707e-8ceb-357b5c6ed453€49.00€0.67matched
75capture01a1aa91-b7d7-7aaa-91cc-a2e2e4fb58a8€9.00€0.19matched
76capture01a1aa91-bbdc-7267-9c9b-3fcfce468b05€24.00€0.37matched
77capture01a1aa91-e6c2-7e8c-b4a6-2db230cb4046€35.00€0.50matched
78capture01a1aa91-e8e5-7cec-8c5c-ac0037c5a7ad€49.00€0.67matched
79capture01a1aa91-f18b-75b6-b636-691bb307e9c3€9.00€0.19matched
80capture01a1aa91-f380-7f06-bb86-ee453d753b3c€9.00€0.19matched
81capture01a1aa91-fe96-7110-880a-6a679de7b184€49.00€0.67matched
82capture01a1aa92-2fb3-7db1-b34c-591d820e47e9€24.00€0.37matched
83capture01a1aa92-47e9-782b-96ff-eb495661a1c1€35.00€0.50matched
84capture01a1aa92-53d0-71a1-995a-143a6fdfa4a7€35.00€0.50matched
85capture01a1aa92-5e09-7c3a-816f-a9bc6817e0ed€24.00€0.37matched
86capture01a1aa92-8920-7c2e-b8b4-42c750ec0556€9.00€0.19matched
87capture01a1aa92-9219-75f5-a2d8-5cfde7a8932f€9.00€0.19matched
88capture01a1aa92-a627-7ee7-a5c1-d7366297f2f6€24.00€0.37matched
89capture01a1aa92-d05c-7975-89e4-14e08b93ee17€24.00€0.37matched
90refund01a1aa92-e811-77b9-8191-4fa6487e605a-€4.00€0.00matched
91capture01a1aa92-e8eb-7613-8fee-4ff4aed32f05€49.00€0.67matched
92capture01a1aa92-ff7c-7336-87ab-935a9d12e736€9.00€0.19matched
93capture01a1aa93-29a2-7fcf-bcdd-dbdfa16aef0f€9.00€0.19matched
94capture01a1aa93-5082-797c-a433-6fd4f68fe219€49.00€0.67matched
95capture01a1aa93-5f70-7d8b-92d0-fd798f0fc7ba€49.00€0.67matched
96capture01a1aa93-6c06-726a-a6db-290446076c9a€35.00€0.50matched
97capture01a1aa93-9a40-7cd1-9484-c60ebaaeb29c€15.00€0.26matched
98capture01a1aa93-aabd-78cd-bab8-72f3fbd3b412€15.00€0.26matched
99capture01a1aa93-c279-7f41-932e-0efb9989db35€49.00€0.67matched
100capture01a1aa93-c802-7370-869d-ff509c15a46f€24.00€0.37matched
101capture01a1aa93-cbd3-7770-afee-4ec8825f6074€49.00€0.67matched
102capture01a1aa93-cec8-72cd-b89e-47ac758f9996€15.00€0.26matched
103capture01a1aa93-da93-76b6-8309-62a58bc85816€35.00€0.50matched
104refund01a1aa93-e025-7a8e-8c70-1192c7b66906-€7.00€0.00matched