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

Gross

€2,998.00

PSP fee

€46.48

Net to the bank

€2,951.52

Settlement journal

#343500

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19c70-8523-755f-9987-5165dfa33fa6 is already settled by stl_EUR_2989376 line 81
  • duplicate linethe file lists it twicecapture:01a19c72-dcb5-7b93-812a-ee3a086fc075 is already settled by stl_EUR_2989376 line 109
LineKindReferenceGrossFeeStatus
82capture01a19c70-865f-7115-8be1-b5e8f249eb72€15.00€0.26duplicate line
110capture01a19c72-dea6-78e2-abae-1ad547cea06c€49.00€0.67duplicate line
1capture01a19c65-b6da-7b66-9927-7f1a5ad0abf3€9.00€0.19matched
2capture01a19c68-7763-7fad-ad05-976f85e9bb23€35.00€0.50matched
3capture01a19c6a-b6fd-71b3-a72a-478d76b91673€9.00€0.19matched
4capture01a19c6a-c682-7251-8999-923b08eeea2f€9.00€0.19matched
5capture01a19c6a-c9e7-78eb-91ec-cdaff571148b€49.00€0.67matched
6capture01a19c6a-d397-7e78-a0e3-d743857e9fb9€9.00€0.19matched
7capture01a19c6a-f1ce-7cb0-8007-910bd01d4c50€49.00€0.67matched
8capture01a19c6a-ee5a-7bc6-a446-4afc07df1b40€24.00€0.37matched
9capture01a19c6a-f1c9-74d0-9790-fdc37f00c76d€49.00€0.67matched
10capture01a19c6a-fab9-7787-a076-f45056f73f3e€49.00€0.67matched
11refund01a19c6b-037d-706e-ab93-37116b153c4d-€8.00€0.00matched
12capture01a19c6b-0540-7824-a9e7-af0ff8246237€35.00€0.50matched
13capture01a19c6b-11a4-735c-8bf7-36a2dd39cf7f€15.00€0.26matched
14capture01a19c6b-206b-7f4c-bdaf-3cd7dccc873e€24.00€0.37matched
15capture01a19c6b-455c-71d4-b081-358b859519ef€24.00€0.37matched
16capture01a19c6b-5a01-7a57-ad67-12a60b9e21f1€49.00€0.67matched
17capture01a19c6b-8607-713b-ad83-d3bf7ece7707€15.00€0.26matched
18capture01a19c6b-a8b4-7320-b853-c1d8f86bef99€9.00€0.19matched
19capture01a19c6b-b18f-73ca-867e-ab69d1626bf7€35.00€0.50matched
20capture01a19c6b-c957-79fc-b8d8-54037f8c45e0€15.00€0.26matched
21capture01a19c6b-d159-7950-b6e7-fad1a8c0a2c7€15.00€0.26matched
22capture01a19c6b-e945-7380-ae44-6b5085372d47€49.00€0.67matched
23capture01a19c6c-050a-7904-b0f7-3fd7917e0454€35.00€0.50matched
24capture01a19c6c-2e07-7025-ade0-b855806ee480€15.00€0.26matched
25capture01a19c6c-513d-7ab8-bffb-b05415b8dd5b€24.00€0.37matched
26refund01a19c6c-5780-723f-bbc1-368357952e22-€8.00€0.00matched
27capture01a19c6c-7102-7437-a302-36f5ddf49539€15.00€0.26matched
28capture01a19c6c-7a3b-77f4-a735-4a75a8ded259€24.00€0.37matched
29capture01a19c6c-9974-7d3d-bdc6-f7518ec4ec30€24.00€0.37matched
30capture01a19c6c-9bc6-7bc8-8b87-2cbd2c384247€9.00€0.19matched
31refund01a19c6c-a5b4-7693-9dc8-3e334d3c6810-€15.00€0.00matched
32capture01a19c6c-ba06-72d3-8ddd-588053d04cf6€35.00€0.50matched
33capture01a19c6c-c842-7648-a65d-7fbd58fbc701€24.00€0.37matched
34capture01a19c6c-d048-7806-b346-cac4233065e6€24.00€0.37matched
35capture01a19c6c-eaf1-7217-8784-158dafda0311€24.00€0.37matched
36refund01a19c6d-1026-737f-a2d1-60d9c3e20892-€6.00€0.00matched
37capture01a19c6d-2267-795f-a4ce-cde758e0955e€35.00€0.50matched
38capture01a19c6d-537d-750e-af38-92a8e3ec410b€24.00€0.37matched
39capture01a19c6d-5f27-72e9-bda0-19d6e5f312ef€49.00€0.67matched
40capture01a19c6d-8de1-7a88-b23a-227ed72483ef€15.00€0.26matched
41capture01a19c6d-8e29-76e9-a929-28ffdae023f9€9.00€0.19matched
42capture01a19c6d-8ef2-77d4-afed-8bf24eb4468a€24.00€0.37matched
43capture01a19c6d-a90f-7306-bfbc-1d0937f3c414€9.00€0.19matched
44capture01a19c6d-b338-78ad-962a-a9aa9718fc71€49.00€0.67matched
45capture01a19c6d-bd78-76de-bcc1-b3187925d8ca€24.00€0.37matched
46capture01a19c6d-c2c7-72f4-b3ea-5c186f3127c6€35.00€0.50matched
47capture01a19c6d-cfd7-77e7-a1e1-b070b1b6a1f1€9.00€0.19matched
48capture01a19c6d-dce3-7182-bb07-c53677f8caf4€49.00€0.67matched
49capture01a19c6e-0ca7-7111-b0bd-af2df0d4218c€35.00€0.50matched
50capture01a19c6e-127a-7ed3-a37a-60f4c203764f€9.00€0.19matched
51refund01a19c6e-2d77-71ec-85c6-99773df73089-€19.00€0.00matched
52capture01a19c6e-38de-7989-97e1-16818a4e2961€49.00€0.67matched
53capture01a19c6e-509c-749a-8082-a2687e116984€9.00€0.19matched
54capture01a19c6e-590a-7fca-a439-3174198d5e9b€15.00€0.26matched
55capture01a19c6e-6289-7b56-bdfd-63e0bd341913€49.00€0.67matched
56capture01a19c6e-74a1-7882-a72e-69019c8a0ac1€9.00€0.19matched
57capture01a19c6e-75aa-7339-82ef-890feaee9749€35.00€0.50matched
58capture01a19c6e-7db8-70d0-8b70-d69b6d0ed5dc€15.00€0.26matched
59capture01a19c6e-7ffa-75d4-8993-6a56bb3062b1€24.00€0.37matched
60capture01a19c6e-8614-72ec-ba9e-c45c7291bb57€49.00€0.67matched
61capture01a19c6e-9cfa-708c-bb30-bb67844e638f€24.00€0.37matched
62capture01a19c6e-ac45-7575-ba46-f5d925d36821€15.00€0.26matched
63capture01a19c6e-b80b-76f9-be7c-9080b5a7043c€35.00€0.50matched
64refund01a19c6e-b8cb-7e1e-a95b-0822a175a00e-€14.00€0.00matched
65capture01a19c6e-bbdc-74bf-8528-dbdf634957f5€9.00€0.19matched
66capture01a19c6e-d034-7ab7-9d0d-b9793bc35284€49.00€0.67matched
67capture01a19c6e-d62f-7d80-9af7-4ef379c50357€15.00€0.26matched
68capture01a19c6e-e31a-7964-961e-fb75ce8456f9€49.00€0.67matched
69capture01a19c6f-1515-7cc5-b39f-9a8d46b597b9€24.00€0.37matched
70capture01a19c6f-32b3-79d0-ac3d-9f49ddb8425f€15.00€0.26matched
71capture01a19c6f-34a0-7882-932e-8f72935e4af3€24.00€0.37matched
72capture01a19c6f-7094-75bf-9ed7-67354a815918€35.00€0.50matched
73refund01a19c6f-87eb-7a36-b7fa-98b00f69ba40-€6.00€0.00matched
74capture01a19c6f-ca7b-7a92-9660-98c9ed41f4c4€9.00€0.19matched
75capture01a19c6f-dcc2-79e9-b660-d45cdd10304c€49.00€0.67matched
76capture01a19c6f-fb2a-7900-831b-cc199a4dd139€9.00€0.19matched
77capture01a19c70-3eee-73f6-9851-21f137589133€24.00€0.37matched
78capture01a19c70-432d-7191-b8d1-c354852d5ecf€49.00€0.67matched
79capture01a19c70-6903-735d-b29e-5e00cf93831b€35.00€0.50matched
80capture01a19c70-83a2-7f61-b5dd-39ee9e671c7b€9.00€0.19matched
81capture01a19c70-865f-7115-8be1-b5e8f249eb72€15.00€0.26matched
83capture01a19c70-948d-7681-9a0e-62ae81f809c0€24.00€0.37matched
84capture01a19c70-a945-7241-be0d-e2a6f96d39be€49.00€0.67matched
85capture01a19c70-d91a-7d70-98b7-f8ecfdfdc349€9.00€0.19matched
86capture01a19c70-d7d3-7a5f-8a4a-4f311fa2829c€9.00€0.19matched
87capture01a19c70-e085-7eca-a12b-40f90d72255a€49.00€0.67matched
88capture01a19c70-e5b6-70e7-bdd5-d06dc114d4a0€35.00€0.50matched
89capture01a19c70-ebc3-7dd3-be1c-5c50b831744d€24.00€0.37matched
90capture01a19c70-f237-7d56-8c25-35eb4e2491b8€24.00€0.37matched
91capture01a19c71-22cf-7b1a-98d1-86b72b072b57€49.00€0.67matched
92capture01a19c71-2fa1-713a-8c8f-08f2af684e84€9.00€0.19matched
93capture01a19c71-786f-719a-b1aa-35f58e55de26€9.00€0.19matched
94capture01a19c71-7feb-70d9-afd7-d74c6ecdded4€9.00€0.19matched
95capture01a19c71-a18f-75c2-bf13-d8eb3d1a2cb6€24.00€0.37matched
96capture01a19c71-cd49-79e9-8b8a-00fcd4f043b3€9.00€0.19matched
97capture01a19c71-d518-7768-9c2e-c2de2f7ad00a€24.00€0.37matched
98capture01a19c71-d87f-7527-ae67-bc8e933c0ea1€49.00€0.67matched
99capture01a19c71-e77f-7408-89f6-9fb8a312ff9b€49.00€0.67matched
100capture01a19c71-f1c7-78ea-9a2a-e15bd54615ff€24.00€0.37matched
101capture01a19c72-00b4-7d3a-90f1-cc985b674ab7€24.00€0.37matched
102refund01a19c72-198d-7e91-bacc-b0463cbc1521-€6.00€0.00matched
103capture01a19c72-2b06-7500-b5a1-350d4143277c€35.00€0.50matched
104capture01a19c72-3caf-7d55-8cf5-b5b8e9744b75€49.00€0.67matched
105refund01a19c72-5a91-7f8e-b365-451025a568a5-€13.00€0.00matched
106capture01a19c72-5cdb-7993-999f-8b8871d07f20€9.00€0.19matched
107capture01a19c72-c0de-706f-a06f-3a0f6513a980€15.00€0.26matched
108capture01a19c72-d432-7269-9e13-7ae793611baa€35.00€0.50matched
109capture01a19c72-dea6-78e2-abae-1ad547cea06c€49.00€0.67matched
111capture01a19c72-dff9-70cc-ae8e-2f1d431c6af0€35.00€0.50matched
112capture01a19c72-e231-7bfa-9154-44dcfc6fa730€24.00€0.37matched
113capture01a19c72-fb7f-7663-b61d-c25160895a0e€24.00€0.37matched
114capture01a19c72-fdea-72ae-bf42-ee9ea2626621€9.00€0.19matched
115capture01a19c73-18f1-770d-b933-b186a38602d3€49.00€0.67matched
116capture01a19c73-3888-7dc9-8232-b4d48e22bfd0€15.00€0.26matched
117capture01a19c73-5a4e-768a-92d7-1acb5e372e19€49.00€0.67matched
118capture01a19c73-5bcb-78ed-b7d6-595234c64242€35.00€0.50matched
119capture01a19c73-8a23-7682-a1a2-cf6e8e9657ac€9.00€0.19matched
120refund01a19c73-aa66-71f4-a846-abdead61759d-€7.00€0.00matched
121capture01a19c73-af14-7d6d-8cce-0ab984d64408€35.00€0.50matched
122capture01a19c73-afc4-7d84-8d0c-4a87e14d62d6€49.00€0.67matched
123capture01a19c73-bbb6-72f3-a82a-4060adf02540€49.00€0.67matched
124capture01a19c73-d304-761e-8fec-37c95fab52a0€9.00€0.19matched