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

Gross

€2,867.00

PSP fee

€45.64

Net to the bank

€2,821.36

Settlement journal

#393799

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a1aaa1-c33c-7d01-8bd4-69f8f319ed6d is already settled by stl_EUR_2989773 line 50
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • missing linein the books, not in the filecapture:01a1aaa1-2f4d-7ff8-a5be-fd892b9f05e7 is in no file
LineKindReferenceGrossFeeStatus
3capture01a1aa99-96be-7050-bded-bd83d25e4c17€15.00€0.28fee difference
17capture01a1aa9e-f308-7593-babd-adf632e23369€24.00€0.39fee difference
51refund01a1aaa1-c33d-7f66-94d0-6d1ff765a791-€6.00€0.00duplicate line
1capture01a1aa95-e295-76a4-8c8f-6e952fc52983€49.00€0.67matched
2capture01a1aa98-8961-7bb8-bc8c-294b44782979€24.00€0.37matched
4capture01a1aa9a-00b5-7521-bb21-727808b5b67a€49.00€0.67matched
5capture01a1aa9a-2bec-7026-9a01-1d51e94d40e8€49.00€0.67matched
6capture01a1aa9d-7ba9-7004-963d-4c613f7ad7e3€35.00€0.50matched
7capture01a1aa9d-d2df-7094-b9cf-093808ba390a€49.00€0.67matched
8capture01a1aa9d-fa78-7de4-86d2-31a70120a6d8€49.00€0.67matched
9capture01a1aa9e-089f-75ab-b2d6-81baeaa220ff€35.00€0.50matched
10capture01a1aa9e-18ce-7ee4-9660-d48708ef9436€24.00€0.37matched
11capture01a1aa9e-1b41-77fd-8536-c66ba7c78f7c€35.00€0.50matched
12capture01a1aa9e-28a6-765c-a887-fcbeffdfbf6a€15.00€0.26matched
13capture01a1aa9e-4fde-7bcb-be72-3651f039d842€49.00€0.67matched
14capture01a1aa9e-52d5-7550-afa9-fd7dccb69d9b€49.00€0.67matched
15capture01a1aa9e-82c1-7e72-8f9e-304e98ad86f4€35.00€0.50matched
16capture01a1aa9e-9760-7095-9fc5-5c40dcdb7561€24.00€0.37matched
18capture01a1aa9e-faaa-76c7-adee-cb3586638a86€15.00€0.26matched
19capture01a1aa9f-008f-7f00-a2ae-52589caeb95c€24.00€0.37matched
20capture01a1aa9f-0734-73f8-b76a-3ab28f90c15e€15.00€0.26matched
21capture01a1aa9f-1dec-7c8d-8c6a-83bf5010b423€15.00€0.26matched
22capture01a1aa9f-3f0f-7e20-a8a0-3fa998148732€15.00€0.26matched
23capture01a1aa9f-6e04-77fe-8134-e3a6518b5869€24.00€0.37matched
24capture01a1aa9f-8a68-754f-b9fc-89a3628d79be€24.00€0.37matched
25capture01a1aa9f-ae2c-7a2a-bc53-5ba2c368b7a1€49.00€0.67matched
26capture01a1aa9f-b2c3-748d-9d11-182885368812€35.00€0.50matched
27capture01a1aa9f-cadb-7a7a-b08f-383e1937af3c€9.00€0.19matched
28capture01a1aa9f-da54-7df0-855e-99195db4f46d€9.00€0.19matched
29capture01a1aa9f-ef5d-7dec-8dfc-89cbb8300dab€49.00€0.67matched
30capture01a1aaa0-1078-7420-81fc-743aed8db9c4€24.00€0.37matched
31capture01a1aaa0-2066-71cb-9b9a-9f0f6b6cfcc7€9.00€0.19matched
32capture01a1aaa0-5edb-7ee5-b620-ad25a126483b€9.00€0.19matched
33capture01a1aaa0-6021-7869-9117-567b4f796f9d€24.00€0.37matched
34capture01a1aaa0-6401-766a-90eb-49afeb3a9b43€35.00€0.50matched
35capture01a1aaa0-72a2-74cc-8e01-027d1d287e7f€35.00€0.50matched
36capture01a1aaa0-ae3d-7795-b316-e158b76a39bb€24.00€0.37matched
37capture01a1aaa0-aeb8-7304-b71e-95cc1d2303e3€35.00€0.50matched
38capture01a1aaa0-d14e-728a-841c-e286329ac779€9.00€0.19matched
39capture01a1aaa0-ffc3-7e2a-a54e-869b37b010d3€15.00€0.26matched
40capture01a1aaa0-e85c-754a-9dd7-ba497268f04f€49.00€0.67matched
41refund01a1aaa1-2b22-7871-8395-aa90599bfa2c-€35.00€0.00matched
42capture01a1aaa1-42ef-721c-92c0-670394e514b3€9.00€0.19matched
43capture01a1aaa1-5a2d-7215-907f-0bd1f73fa358€24.00€0.37matched
44capture01a1aaa1-5eb7-73ae-b498-5971cd269470€9.00€0.19matched
45refund01a1aaa1-6d03-706c-ab49-959f7c461f57-€30.00€0.00matched
46refund01a1aaa1-72c5-7833-b370-423c029fcee2-€5.00€0.00matched
47capture01a1aaa1-9a05-7625-9326-10b85d4638e4€35.00€0.50matched
48capture01a1aaa1-a29c-7ebd-9a3c-5578d1e2aae3€15.00€0.26matched
49capture01a1aaa1-b8dc-726e-bbb3-0e1586560a5b€35.00€0.50matched
50refund01a1aaa1-c33d-7f66-94d0-6d1ff765a791-€6.00€0.00matched
52capture01a1aaa1-ca95-767d-9d4c-2e18b33f6689€35.00€0.50matched
53capture01a1aaa1-b7bf-7bb2-aef6-40716b8edf33€15.00€0.26matched
54capture01a1aaa1-d029-743c-abcd-e1dd6899c146€49.00€0.67matched
55capture01a1aaa1-d1a6-7968-9208-eafbb0fb96f1€9.00€0.19matched
56capture01a1aaa2-01e5-7053-b4cd-08066c63da56€15.00€0.26matched
57capture01a1aaa2-03d4-7982-90ba-b8cf2ff88631€35.00€0.50matched
58capture01a1aaa2-046c-7dee-b653-e4dd8fac8961€9.00€0.19matched
59capture01a1aaa2-20d2-7fa5-ad1d-2e60b2952f47€9.00€0.19matched
60capture01a1aaa2-2411-7fcc-98ca-b123c96d0fb2€49.00€0.67matched
61capture01a1aaa2-249f-7981-9757-7355a3d8c98a€24.00€0.37matched
62capture01a1aaa2-2dde-713a-8f9b-d2e9e9d27a0b€35.00€0.50matched
63refund01a1aaa2-3fef-7d7d-a9a6-4159fecc78c1-€5.00€0.00matched
64capture01a1aaa2-48d4-792d-b54c-e8cf6acd8628€9.00€0.19matched
65refund01a1aaa2-4f2d-7bae-95ac-4715f2f0bb30-€8.00€0.00matched
66capture01a1aaa2-5297-7875-a2d0-ada454d26d66€9.00€0.19matched
67capture01a1aaa2-54ad-7dec-a0d1-1ba24d1b256f€24.00€0.37matched
68capture01a1aaa2-56e7-7a65-82da-944c2499e662€24.00€0.37matched
69capture01a1aaa2-6fee-7f0c-997f-709c22cc1829€9.00€0.19matched
70capture01a1aaa2-7e7e-7eb8-98f7-f2f2c5a40e16€35.00€0.50matched
71capture01a1aaa2-a117-7896-83fe-a38c2e63a8c6€24.00€0.37matched
72capture01a1aaa2-acd0-7de5-b7f1-fcb6392e51dd€24.00€0.37matched
73capture01a1aaa2-d12f-7550-ace2-afef75e9d7f1€35.00€0.50matched
74capture01a1aaa3-11f6-7325-a202-995b6fe39da8€24.00€0.37matched
75capture01a1aaa3-2614-7fcb-bbdb-82f7d4a0cdec€9.00€0.19matched
76capture01a1aaa3-2bc0-7d1e-b0dd-680485279ca3€24.00€0.37matched
77capture01a1aaa3-396d-734a-adaa-36153cf2509f€35.00€0.50matched
78capture01a1aaa3-4454-7495-9cf1-bc4ee27e3650€15.00€0.26matched
79capture01a1aaa3-4ddb-73e9-b7b7-79d69cdc75f1€15.00€0.26matched
80capture01a1aaa3-4ddb-7480-afa1-6e88786e104f€15.00€0.26matched
81capture01a1aaa3-5fb2-7ca3-b7d1-1a5649441ecc€15.00€0.26matched
82capture01a1aaa3-8bc1-7a06-afdb-02995209ffd5€24.00€0.37matched
83capture01a1aaa3-8ff9-7df0-80ad-d9597f87eedf€49.00€0.67matched
84capture01a1aaa3-939c-7044-94d0-46e1e5ac553a€9.00€0.19matched
85capture01a1aaa3-97df-70bb-ae0c-708c41a57f3c€49.00€0.67matched
86refund01a1aaa3-9eb5-7358-a04b-00cb8b61bfa1-€21.00€0.00matched
87capture01a1aaa3-b356-7685-bdca-61f6749842c2€15.00€0.26matched
88capture01a1aaa3-b59f-7821-87e3-e900cefe904d€35.00€0.50matched
89capture01a1aaa3-cd2a-7335-84b1-d43b41fed53d€35.00€0.50matched
90capture01a1aaa3-f922-762c-80c0-b879f4ef68c1€49.00€0.67matched
91capture01a1aaa4-15eb-707a-9c54-bd53976d2063€9.00€0.19matched
92capture01a1aaa4-49e6-7287-a457-9d32516cfdb2€49.00€0.67matched
93capture01a1aaa4-609e-7e31-9c72-85165922488b€35.00€0.50matched
94capture01a1aaa4-6637-7e8e-9d5f-2c1957e522df€49.00€0.67matched
95capture01a1aaa4-755a-7098-9be5-063756441409€49.00€0.67matched
96capture01a1aaa4-8e00-773a-97e0-01b411212c41€15.00€0.26matched
97capture01a1aaa4-952f-7e59-9513-ca77a11880cd€24.00€0.37matched
98capture01a1aaa4-a4d0-7d40-a422-f8e02f122e53€24.00€0.37matched
99capture01a1aaa4-ae2d-7611-b6f2-d352ae8f9d4c€35.00€0.50matched
100capture01a1aaa4-c604-7007-973a-928a6924f0f6€24.00€0.37matched
101capture01a1aaa4-c87f-7d0b-99db-6422ba9957d2€35.00€0.50matched
102refund01a1aaa4-e3c0-7095-a198-01e753171197-€32.00€0.00matched
103capture01a1aaa4-ec9f-76db-932a-6fd428582649€9.00€0.19matched
104capture01a1aaa5-07ab-7ea9-9b8f-d950378b716f€49.00€0.67matched
105capture01a1aaa5-2094-7315-869c-b1b95a031b06€15.00€0.26matched
106capture01a1aaa5-2abb-7236-bcbb-3f3c34cfc5db€15.00€0.26matched
107capture01a1aaa5-2d62-7942-b2c8-e3ec14a8a463€15.00€0.26matched
108capture01a1aaa5-3acb-723b-8ea8-9e4227d47ec9€15.00€0.26matched
109capture01a1aaa5-4b83-78c5-aa9e-9aef33cff64a€9.00€0.19matched
110refund01a1aaa5-5d48-70fa-9b34-9ff65bf17606-€8.00€0.00matched
111capture01a1aaa5-6d95-736a-a1fe-6c0652a417bf€35.00€0.50matched
112capture01a1aaa5-92ab-75d2-82e8-1ec3ce472a61€9.00€0.19matched
113capture01a1aaa5-a004-7025-a1ef-7260cbbf498e€15.00€0.26matched
114capture01a1aaa5-bbc6-7cff-97ed-e51312467ef2€15.00€0.26matched
115capture01a1aaa5-bd45-749f-94a9-c77215e746e8€35.00€0.50matched
116capture01a1aaa5-c0c6-7e6d-a142-6dd7dd9f00e9€15.00€0.26matched
117capture01a1aaa5-d202-7bf5-9fa8-dfa3f1116c2c€35.00€0.50matched
118capture01a1aaa6-1889-7eed-9164-1e6513a21410€15.00€0.26matched
119capture01a1aaa6-1e08-7fdb-9716-8b90f48baa4d€35.00€0.50matched
120capture01a1aaa6-1e31-7087-ad09-6f5b6e6b2df1€15.00€0.26matched
121capture01a1aaa6-28bd-7370-852c-6bab8df11216€15.00€0.26matched
122capture01a1aaa6-4d51-7b7b-9eb6-37342f9c2886€9.00€0.19matched
123capture01a1aaa6-510f-75c0-8c51-e0dfd7afe7f0€49.00€0.67matched
124capture01a1aaa6-5e4e-7f33-8ed9-045ff07c07fb€35.00€0.50matched
125capture01a1aaa6-703b-7b13-924a-4ea356c1a18d€35.00€0.50matched