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, 23:20

Gross

€2,700.00

PSP fee

€41.24

Net to the bank

€2,658.76

Settlement journal

#405854

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ae0a-9b53-79df-89c2-c5ca09fde9c1 is already settled by stl_EUR_2989868 line 86
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a1ae05-c3ae-7fc1-8aa0-7d0d80d23e5c is in no file
LineKindReferenceGrossFeeStatus
25capture01a1ae05-36b6-7d2f-9598-538536554769€49.00€0.72fee difference
87capture01a1ae0a-9b8c-737a-a914-cc5f1310a4bf€9.00€0.19duplicate line
1capture01a1adfb-b075-7a0d-a7bd-840c7d426912€24.00€0.37matched
2capture01a1adfb-ebd2-7a9e-b9dc-fda4feefd4d7€24.00€0.37matched
3capture01a1adfc-deaa-73dc-8c9f-7360f9b05952€35.00€0.50matched
4capture01a1ae03-6f35-79c6-ada8-b1289b66fbd6€9.00€0.19matched
5capture01a1ae03-8f43-78bd-907b-326ed53f9ba9€49.00€0.67matched
6capture01a1ae03-a296-723c-b815-9f4dc064b111€49.00€0.67matched
7capture01a1ae03-b6b1-72ca-8731-675cb5a8bcc6€35.00€0.50matched
8capture01a1ae03-dc7b-7da1-9d52-f4272b7673f9€35.00€0.50matched
9refund01a1ae03-e2a5-7dad-9f08-554f369eb1f4-€25.00€0.00matched
10capture01a1ae03-e8ea-71f7-b5fb-a416e49f034d€35.00€0.50matched
11capture01a1ae03-ea29-7e6d-bf1f-f6083089eb22€15.00€0.26matched
12capture01a1ae03-f3f4-7ed9-bed4-b79be542fa08€15.00€0.26matched
13capture01a1ae03-f8b9-7751-b101-c8f17f60e47f€35.00€0.50matched
14capture01a1ae04-27ce-78d9-bc14-9f3ccda01a8e€9.00€0.19matched
15capture01a1ae04-343a-724e-84de-c5d6328cb196€49.00€0.67matched
16capture01a1ae04-35c2-7c3b-aa5b-4c86188b02c8€9.00€0.19matched
17capture01a1ae04-5366-7802-a311-961ec679d803€35.00€0.50matched
18capture01a1ae04-53b7-7cd0-8ef2-66072820c1ab€24.00€0.37matched
19capture01a1ae04-7793-7087-a688-ebc70ebf2974€9.00€0.19matched
20capture01a1ae04-aeac-7608-98ad-3360dec11352€24.00€0.37matched
21capture01a1ae04-e021-7401-b079-1d3374dbbc52€35.00€0.50matched
22capture01a1ae04-fa36-7e44-99b1-75d197a438bb€24.00€0.37matched
23capture01a1ae05-2a26-7bf4-b35e-1f00a5eb495f€9.00€0.19matched
24capture01a1ae05-2e55-70ff-b54d-37ed1bdd4f54€35.00€0.50matched
26capture01a1ae05-50b4-7be6-abaf-271dd10d5867€9.00€0.19matched
27capture01a1ae05-74eb-7be9-b5bb-1473b6ef97b6€9.00€0.19matched
28capture01a1ae05-7821-7628-b02a-629835f76a88€9.00€0.19matched
29capture01a1ae05-7abb-7e3e-abd3-9004ca00cf1a€49.00€0.67matched
30capture01a1ae05-829a-7324-89be-257ea5013524€49.00€0.67matched
31capture01a1ae05-986c-7bee-b328-b95a11f0be35€35.00€0.50matched
32capture01a1ae05-9d33-70ab-9a90-f38723da0563€24.00€0.37matched
33refund01a1ae05-b8cc-7ef7-b1ca-485c474ce23f-€4.00€0.00matched
34capture01a1ae05-d63d-7d76-b7e9-62927a982aeb€49.00€0.67matched
35capture01a1ae05-d8bd-78fc-967f-b63dcdb438ad€49.00€0.67matched
36capture01a1ae05-e29e-7358-8a9d-46df78fe860f€24.00€0.37matched
37capture01a1ae05-ee72-7462-9190-66d3640d7926€24.00€0.37matched
38capture01a1ae05-f13e-7656-8db0-11f0582abba8€15.00€0.26matched
39capture01a1ae05-fa8d-71eb-a79a-ba4b8a5c194d€35.00€0.50matched
40capture01a1ae06-0448-7d1c-872b-5b87722d45f9€24.00€0.37matched
41capture01a1ae06-22b0-7eb3-8293-8a23d53b3e9d€35.00€0.50matched
42capture01a1ae06-2e59-73bd-8d07-42acbac224f1€35.00€0.50matched
43capture01a1ae06-3d0f-71ee-962d-8346e0b7c084€49.00€0.67matched
44capture01a1ae06-4b92-7556-a302-18a12fab9c43€15.00€0.26matched
45capture01a1ae06-500c-72cb-864f-bfc11e1d2ce8€15.00€0.26matched
46capture01a1ae06-5a37-77c0-a39a-ce3642aabe4d€24.00€0.37matched
47capture01a1ae06-5a97-7f99-8ad4-a484d45f2111€35.00€0.50matched
48capture01a1ae06-5c8d-7467-bd97-1b75426cf6b1€9.00€0.19matched
49capture01a1ae06-6512-70eb-8824-75dc157fc674€49.00€0.67matched
50capture01a1ae06-a5aa-758e-bf84-85cda10f72bb€9.00€0.19matched
51capture01a1ae06-e130-72a0-941c-f76c31177f13€15.00€0.26matched
52capture01a1ae07-326d-7981-969e-61ecfcd5f61f€35.00€0.50matched
53capture01a1ae07-347d-70fd-8efc-be539e3443d4€24.00€0.37matched
54capture01a1ae07-3920-76db-85ac-a90f5708ff99€15.00€0.26matched
55capture01a1ae07-3a7d-78c6-9a6a-016bf313025d€9.00€0.19matched
56capture01a1ae07-3c5e-749d-9fd1-933d644fbefa€49.00€0.67matched
57capture01a1ae07-4845-78cf-9784-45e4fe3bc4a8€24.00€0.37matched
58capture01a1ae07-715c-7911-9f06-7db3d5be02f4€9.00€0.19matched
59capture01a1ae07-8250-7c55-9422-96bcdbb8aac7€35.00€0.50matched
60capture01a1ae07-8d39-713d-8884-5673b38ec236€35.00€0.50matched
61capture01a1ae07-98f9-7643-9b7a-d4fb38d57711€9.00€0.19matched
62capture01a1ae07-bbb1-7fb6-a893-c87f1c3b795f€24.00€0.37matched
63capture01a1ae07-cb61-7d8e-9e05-fcbc7fd65622€15.00€0.26matched
64capture01a1ae07-dbbe-73d2-933e-f48acd77c376€15.00€0.26matched
65capture01a1ae07-ff0a-71fc-b9eb-678bd27cdc9e€24.00€0.37matched
66capture01a1ae08-02ec-7280-a006-e063c0e42d82€49.00€0.67matched
67capture01a1ae08-6159-7d09-aca2-a28d0f59b37a€49.00€0.67matched
68capture01a1ae08-9622-7657-b33f-911e665ed88c€24.00€0.37matched
69capture01a1ae08-ae9e-7451-91db-a7df443f38d9€9.00€0.19matched
70capture01a1ae08-b2f6-7668-902c-274d8c3c64e4€49.00€0.67matched
71capture01a1ae08-bb4a-7428-b6e8-3894133a71a4€35.00€0.50matched
72capture01a1ae08-bdcf-7f8d-b8b4-0329babebefb€24.00€0.37matched
73capture01a1ae08-c1f1-7800-82c9-2220e579adac€35.00€0.50matched
74capture01a1ae08-d1ac-7d38-ac2e-c762be015e2f€24.00€0.37matched
75capture01a1ae08-fd95-7757-af35-1a66ea76e47b€35.00€0.50matched
76capture01a1ae09-4ab5-7670-b423-16fa87559581€9.00€0.19matched
77capture01a1ae09-57ca-7fee-b0c9-4c5e5fcf7e4f€9.00€0.19matched
78capture01a1ae09-8013-7aab-bc05-2cb70fba79d8€35.00€0.50matched
79capture01a1ae09-9eed-70cc-9258-b715904b28b7€9.00€0.19matched
80capture01a1ae09-ebbc-78a2-bfdb-bbadd46a166d€9.00€0.19matched
81capture01a1ae0a-5a9a-75be-8c5b-6baccfe5a4fc€24.00€0.37matched
82capture01a1ae0a-5cff-771a-bdde-17b4ada8c489€35.00€0.50matched
83capture01a1ae0a-6bf5-727b-a291-49b68a00999b€35.00€0.50matched
84capture01a1ae0a-7817-7ed5-b170-45873193ce66€9.00€0.19matched
85capture01a1ae0a-99a2-70e6-8a4a-b75681196c62€15.00€0.26matched
86capture01a1ae0a-9b8c-737a-a914-cc5f1310a4bf€9.00€0.19matched
88capture01a1ae0a-a106-7d66-b6e3-35e1521150cf€9.00€0.19matched
89capture01a1ae0a-d5e1-718a-b297-c9457ce1fc71€15.00€0.26matched
90capture01a1ae0b-1176-7d72-9227-a47fcdb7e582€49.00€0.67matched
91capture01a1ae0b-24df-756d-a33c-9ffe9fbf3ad8€35.00€0.50matched
92capture01a1ae0b-34a0-721a-9d60-9a6be9e062ce€9.00€0.19matched
93capture01a1ae0b-45cf-7d90-bfe4-329742790961€49.00€0.67matched
94capture01a1ae0b-4c34-7131-93f3-0bd1cbcd924f€35.00€0.50matched
95capture01a1ae0b-4de6-7b64-b578-3f811902f7ed€49.00€0.67matched
96capture01a1ae0b-4f35-70d6-b33f-3f91db67ee85€24.00€0.37matched
97capture01a1ae0b-5952-77fd-b99c-324b66b947d8€15.00€0.26matched
98capture01a1ae0b-78a8-7901-a667-9b7da5971959€24.00€0.37matched
99capture01a1ae0b-966c-7ca6-98ab-e47a0d6c2bff€15.00€0.26matched
100capture01a1ae0b-beae-7f8e-83cd-a58f46e68be1€35.00€0.50matched
101capture01a1ae0b-ee73-7d0b-b5ec-0057493c3e0b€15.00€0.26matched
102capture01a1ae0b-fad0-7e51-b6f7-29b6a3211ac6€15.00€0.26matched
103capture01a1ae0c-00d3-739a-8b86-91ee3517a22d€35.00€0.50matched
104capture01a1ae0c-133a-78f0-8631-557b37a9d5d2€35.00€0.50matched
105capture01a1ae0c-2255-7fde-9010-8ce00ef30939€15.00€0.26matched
106capture01a1ae0c-33c9-7bc9-b50f-f194e75bfda8€24.00€0.37matched