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, 11:00

Gross

€2,493.00

PSP fee

€39.66

Net to the bank

€2,453.34

Settlement journal

#396495

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ab63-0bf7-77bd-8fe9-c6b81b37c38d is already settled by stl_EUR_2989794 line 79
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
LineKindReferenceGrossFeeStatus
43capture01a1ab60-f303-7e2e-8f20-8c996f5fa43a€49.00€0.71fee difference
80capture01a1ab63-0c23-7744-907c-8f053b9dd423€24.00€0.37duplicate line
1capture01a1ab5d-ba8f-7964-94ab-1a717eb8912c€9.00€0.19matched
2capture01a1ab5d-db4a-782e-889d-05dcc24acea7€24.00€0.37matched
3capture01a1ab5d-ea56-7282-adc7-a38452d4ac04€35.00€0.50matched
4capture01a1ab5d-ef89-78c5-8849-de0d702fa5e2€9.00€0.19matched
5capture01a1ab5d-f4bb-7b8e-87f8-e6fa143f664b€49.00€0.67matched
6capture01a1ab5d-faed-75dc-8efd-f6e81fd793f2€24.00€0.37matched
7capture01a1ab5e-0850-7d5f-935a-c13da6509a58€9.00€0.19matched
8capture01a1ab5e-4e27-7b6b-8075-c6ff2e7fc707€35.00€0.50matched
9capture01a1ab5e-72dd-7a7e-8eca-d25d6806b460€24.00€0.37matched
10capture01a1ab5e-8d9d-7038-8f9f-dda3eef2087a€15.00€0.26matched
11capture01a1ab5e-b5bf-72c0-a2d7-90143cec5b96€9.00€0.19matched
12capture01a1ab5e-e003-7e7d-95aa-6cb2338ea557€9.00€0.19matched
13capture01a1ab5e-e3de-777b-bb85-76fdf723a32b€24.00€0.37matched
14capture01a1ab5e-ece7-7b8c-98a9-f6f4568d5099€24.00€0.37matched
15capture01a1ab5e-f531-74a1-ab9b-e6a91c8efe9e€35.00€0.50matched
16capture01a1ab5e-f5dc-763d-91f4-c86f1f47c253€49.00€0.67matched
17capture01a1ab5e-f955-7cd5-aad0-4ee6ff2923ef€15.00€0.26matched
18capture01a1ab5f-0a28-795f-a7b0-26fd796edc9e€24.00€0.37matched
19capture01a1ab5f-26e4-7965-8409-ee5565c26460€35.00€0.50matched
20capture01a1ab5f-2934-710d-b217-71f78156de5d€49.00€0.67matched
21capture01a1ab5f-2b89-7a41-a023-f41ff92bd670€49.00€0.67matched
22refund01a1ab5f-3af8-788e-ac43-022a96f1091d-€7.00€0.00matched
23capture01a1ab5f-5955-75e0-98eb-f6505e200177€24.00€0.37matched
24capture01a1ab5f-8570-7474-812d-9f6f274b2f40€24.00€0.37matched
25capture01a1ab5f-8e7c-799c-a739-c692c1b8bbc4€15.00€0.26matched
26refund01a1ab5f-9946-7464-963d-5bda6af73623-€14.00€0.00matched
27capture01a1ab5f-9d78-7f77-b14c-06a326b83ba8€35.00€0.50matched
28capture01a1ab5f-a261-7fdf-8ad2-b49fb5bd3caa€15.00€0.26matched
29capture01a1ab5f-b9af-77f1-a2dd-4740e937d510€35.00€0.50matched
30capture01a1ab5f-e24a-7679-99d4-893640e23b41€9.00€0.19matched
31capture01a1ab60-07c5-7dfb-9d5b-39c4aed36cb0€9.00€0.19matched
32capture01a1ab60-15e6-7ee6-8f86-bb27f570edac€24.00€0.37matched
33capture01a1ab60-592f-75aa-825a-ee97515bf153€9.00€0.19matched
34refund01a1ab60-639e-7df7-b7c4-9fd8f8783c7b-€6.00€0.00matched
35capture01a1ab60-6c4f-7a0a-8d51-032cb685fa16€35.00€0.50matched
36capture01a1ab60-8551-79ef-8754-1b9915f62045€35.00€0.50matched
37capture01a1ab60-bec2-7a74-9582-428ada0e8ef7€24.00€0.37matched
38capture01a1ab60-c89d-7bbb-a1e3-a6dc6f39378e€35.00€0.50matched
39refund01a1ab60-d1f7-72f1-9ba6-04cb9def92fc-€8.00€0.00matched
40capture01a1ab60-d227-72c7-8d33-88f478cca786€24.00€0.37matched
41capture01a1ab60-e424-7698-b91a-e3236a0a61e1€9.00€0.19matched
42capture01a1ab60-e9f9-7216-b554-97671f01a110€15.00€0.26matched
44capture01a1ab61-04cc-7b66-84df-3bc25f8313d8€9.00€0.19matched
45capture01a1ab61-09b7-70ea-bd15-94cfe20ce6c8€9.00€0.19matched
46capture01a1ab61-15a3-7262-83e1-ba79833b634b€15.00€0.26matched
47capture01a1ab61-1d14-7e30-b5b1-62cd632ac869€35.00€0.50matched
48capture01a1ab61-2215-7893-ba75-1322ec840932€24.00€0.37matched
49capture01a1ab61-24a1-7fd0-a056-6da605b770e8€35.00€0.50matched
50capture01a1ab61-2570-79d2-a74b-aa5395c75938€35.00€0.50matched
51capture01a1ab61-2b36-741f-8db4-c50fddb21b6c€9.00€0.19matched
52refund01a1ab61-310f-7043-82d3-1524c65d2684-€8.00€0.00matched
53capture01a1ab61-369a-7391-b24d-085f0773c368€15.00€0.26matched
54capture01a1ab61-3b30-7fcf-8c63-9c1b54a6a563€35.00€0.50matched
55capture01a1ab61-446e-7c47-b92f-e4bfddd2df0e€49.00€0.67matched
56refund01a1ab61-45ce-7f79-9432-90cd14cedad9-€6.00€0.00matched
57capture01a1ab61-4c7c-7e48-bae8-5fd3060cbe8d€24.00€0.37matched
58refund01a1ab61-541d-7561-8612-b5ea2c4cb90e-€3.00€0.00matched
59capture01a1ab61-723c-7c94-9797-646ea61bae92€49.00€0.67matched
60capture01a1ab61-7a33-7f09-b9e2-72ca2844a3a8€24.00€0.37matched
61capture01a1ab61-a64e-724a-a1a2-884c76ff87af€49.00€0.67matched
62capture01a1ab61-bde1-76f4-9bd0-71582c584610€35.00€0.50matched
63capture01a1ab61-c767-7a34-a30a-60e43424c617€24.00€0.37matched
64refund01a1ab61-e583-75ae-9cf3-9cb60e574eca-€9.00€0.00matched
65capture01a1ab61-f859-7c5b-b1d3-cb459a1db51d€15.00€0.26matched
66capture01a1ab61-faa9-7899-ad75-ec22a58d57b2€49.00€0.67matched
67capture01a1ab62-09cd-7424-ac86-882a02f40a65€49.00€0.67matched
68capture01a1ab62-0c9e-77cb-bccc-b90143a1cc06€35.00€0.50matched
69capture01a1ab62-2e4e-7de8-aae4-e27da56d3f10€35.00€0.50matched
70capture01a1ab62-3d14-73c3-be2e-28cac4673415€9.00€0.19matched
71capture01a1ab62-51d2-7c4c-a088-dd663971a67a€9.00€0.19matched
72capture01a1ab62-6106-73f8-a844-35f6b5bf8344€49.00€0.67matched
73capture01a1ab62-6402-766f-8a91-921ef1e23167€9.00€0.19matched
74capture01a1ab62-7510-7eb7-8b39-47d1a8b90c1d€24.00€0.37matched
75capture01a1ab62-cb45-76e8-aed3-321c3b52cedc€15.00€0.26matched
76capture01a1ab62-cfaf-724f-acf7-6e1b73c02e57€49.00€0.67matched
77capture01a1ab62-db06-70aa-921b-fd6536430d4c€15.00€0.26matched
78capture01a1ab63-09c1-7076-bb5e-e52f78d72003€35.00€0.50matched
79capture01a1ab63-0c23-7744-907c-8f053b9dd423€24.00€0.37matched
81capture01a1ab63-11a7-7ba7-9077-85dc9bd41827€49.00€0.67matched
82capture01a1ab63-18ca-760f-8b60-9f6021d15b0a€24.00€0.37matched
83capture01a1ab63-49e0-7574-a5b7-94e10213aaf4€24.00€0.37matched
84capture01a1ab63-c185-72ad-9865-ca6a1720be9b€15.00€0.26matched
85capture01a1ab63-c9f8-7919-8ed7-0cd7683d58c9€9.00€0.19matched
86capture01a1ab64-13d2-7f87-a61b-74b2398265cf€15.00€0.26matched
87capture01a1ab64-391c-754d-b80e-9f5246d86824€24.00€0.37matched
88capture01a1ab64-3fbd-703a-9ca2-64884867fe04€9.00€0.19matched
89capture01a1ab64-4741-752d-b799-bd0dddc9efab€9.00€0.19matched
90capture01a1ab64-5eb5-7cbe-870a-3ade555f3486€24.00€0.37matched
91capture01a1ab64-967c-7b9a-984b-6758d1ab91dd€9.00€0.19matched
92capture01a1ab64-9e80-7f8c-b7e0-474984421c47€24.00€0.37matched
93capture01a1ab64-c85b-7fda-8bd1-a6948ef08932€49.00€0.67matched
94capture01a1ab65-0113-79e1-90c5-4fa599322d74€49.00€0.67matched
95capture01a1ab65-0f73-7cc6-aaa7-0272afc0fc09€24.00€0.37matched
96capture01a1ab65-42e1-73d1-b71c-a2881575d844€35.00€0.50matched
97capture01a1ab65-4977-78fc-b456-01e6638f5760€15.00€0.26matched
98capture01a1ab65-4a45-7526-984b-4a8a0db019a9€15.00€0.26matched
99capture01a1ab65-6e9a-7a25-8155-73c660386376€9.00€0.19matched
100capture01a1ab65-7d78-7020-8435-7273aa7da1d9€9.00€0.19matched
101capture01a1ab65-9723-79d8-823c-6e1fd0528f9e€15.00€0.26matched
102capture01a1ab65-aa52-7893-b5df-f61217252870€15.00€0.26matched
103capture01a1ab65-cf8d-7cea-a977-3ebca1bcfb63€49.00€0.67matched
104capture01a1ab65-d04c-7181-b3fa-e2a3ae957fa0€35.00€0.50matched
105capture01a1ab65-f375-7323-9079-c2fef4d266f5€9.00€0.19matched
106capture01a1ab66-01e3-78c9-bfe7-a767cc932f0e€49.00€0.67matched
107refund01a1ab66-02dc-7183-99c4-91b8f8725081-€37.00€0.00matched
108capture01a1ab66-2c3b-7fc7-964c-31b469167f33€9.00€0.19matched
109capture01a1ab66-46b6-7cd9-8306-e0c27569d41e€24.00€0.37matched
110capture01a1ab66-5017-77f5-8e22-21653364b6bc€15.00€0.26matched
111refund01a1ab66-8d3e-72c2-8a9b-c09c30619006-€13.00€0.00matched
112capture01a1ab66-a35f-7123-b183-52ad8d833dbc€35.00€0.50matched
113capture01a1ab66-bead-7644-9ce5-36b331af1b92€9.00€0.19matched