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, 04:50

Gross

€2,889.00

PSP fee

€44.04

Net to the bank

€2,844.96

Settlement journal

#337011

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19aa0-2f39-757b-88b2-e8cdc35e3c8a is already settled by stl_EUR_2989325 line 100
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
LineKindReferenceGrossFeeStatus
67capture01a19a9c-e385-7bea-a9e0-69f370c71667€35.00€0.54fee difference
101capture01a19aa0-406d-7383-a9d3-deeefd8da951€35.00€0.50duplicate line
1capture01a19a93-dda1-78ec-a018-afd72658f59d€15.00€0.26matched
2capture01a19a97-c9ab-7162-b9a5-1cb34c70f275€9.00€0.19matched
3capture01a19a97-d836-7f1a-a7af-48ec3b4c9ade€24.00€0.37matched
4refund01a19a97-db43-7edc-8838-4dee36bb328d-€6.00€0.00matched
5capture01a19a97-dfe8-71c0-be55-9ac4e2dc880b€35.00€0.50matched
6capture01a19a97-e0ba-7f75-bb99-04cba7eec9a7€49.00€0.67matched
7capture01a19a97-ed96-799f-9d06-f4b31dae7d71€35.00€0.50matched
8capture01a19a98-0beb-78e0-8846-dcc322da937e€49.00€0.67matched
9capture01a19a98-5176-7844-a6b4-2863ca5fb620€35.00€0.50matched
10capture01a19a98-577a-7939-9c75-c77f69ea0b61€49.00€0.67matched
11capture01a19a98-5d65-71c3-aa9b-4a2dd43631b1€24.00€0.37matched
12capture01a19a98-6388-7125-a0d9-12f5f3093398€24.00€0.37matched
13capture01a19a98-924a-78fc-8d59-f288dc727177€49.00€0.67matched
14capture01a19a98-a1ff-7ab5-9c40-99a4c55db2a0€49.00€0.67matched
15capture01a19a98-aff5-7275-9e35-47cf06b817a8€9.00€0.19matched
16capture01a19a98-dcb2-772a-81c3-a1ba071af05d€35.00€0.50matched
17capture01a19a98-eda1-7bc7-b216-22a803cf18f1€49.00€0.67matched
18capture01a19a98-f1f9-7431-b81c-638102146314€15.00€0.26matched
19capture01a19a98-fb0c-737b-9420-55bad805f70c€15.00€0.26matched
20capture01a19a98-fc0c-70bb-8ce6-06ea969ee2ba€35.00€0.50matched
21capture01a19a99-22e4-7ec7-b00f-e59a15d02527€35.00€0.50matched
22capture01a19a99-2a7f-7f29-a58c-145148b451e4€15.00€0.26matched
23capture01a19a99-3dc8-7e6a-99ee-6581fa9962c7€35.00€0.50matched
24capture01a19a99-459b-7eaf-8e54-f664dfc92d30€15.00€0.26matched
25refund01a19a99-6639-7155-a583-b9665e5e70cc-€9.00€0.00matched
26capture01a19a99-b9f0-70f8-967e-cbb7419a91d9€24.00€0.37matched
27capture01a19a99-d595-73fb-8897-aed2bc8f2729€15.00€0.26matched
28capture01a19a99-f0aa-74be-a9a0-0b54fa0451cf€35.00€0.50matched
29capture01a19a99-f2ce-7c74-a4c2-f95a380ba5da€9.00€0.19matched
30capture01a19a9a-0684-7fe4-9d44-7dbb9d817527€9.00€0.19matched
31capture01a19a9a-255a-7faa-87d2-7290b28e2575€15.00€0.26matched
32capture01a19a9a-5202-7b67-85a8-6badd74152d8€9.00€0.19matched
33capture01a19a9a-7c6b-7494-8e16-a3180801976e€49.00€0.67matched
34capture01a19a9a-b49a-7a76-9531-8be10240d478€15.00€0.26matched
35capture01a19a9a-b653-72fa-85e8-9fee34ce2f87€49.00€0.67matched
36capture01a19a9a-dadb-784e-bd92-aed556d37243€9.00€0.19matched
37capture01a19a9a-efb8-79a0-b1b1-f092c24f4406€49.00€0.67matched
38capture01a19a9a-fa21-7732-a39c-fd2dd8267a8a€24.00€0.37matched
39capture01a19a9b-1a98-735f-8da9-20d346e1f05c€24.00€0.37matched
40capture01a19a9b-1fde-7212-8874-a0c7652fa902€35.00€0.50matched
41refund01a19a9b-32e1-70d8-9052-0a0cd7ed8ba8-€15.00€0.00matched
42capture01a19a9b-48e5-7d72-99db-b8f4e022f10d€9.00€0.19matched
43capture01a19a9b-5c1c-7f60-9a64-37e4f9bebd03€15.00€0.26matched
44capture01a19a9b-6166-76d5-b8c0-bb09639ff35e€35.00€0.50matched
45capture01a19a9b-6c18-7ec0-baa0-088e65e15dfe€35.00€0.50matched
46capture01a19a9b-8ec4-7d9e-a5bd-346aeca25faf€15.00€0.26matched
47refund01a19a9b-9084-78f7-982e-09544f9c4be5-€8.00€0.00matched
48capture01a19a9b-94d6-79d8-ba8e-7dd90f0181a0€35.00€0.50matched
49capture01a19a9b-997a-71ca-a686-57501e773932€9.00€0.19matched
50capture01a19a9b-c869-7aa8-b5f7-df29511a1c74€24.00€0.37matched
51capture01a19a9b-d82d-7f65-8edf-7c681dd0fa85€15.00€0.26matched
52capture01a19a9b-daf9-7797-bba1-ecbb3692d3e4€35.00€0.50matched
53capture01a19a9c-0f47-7a54-aefc-d872fe072d6b€15.00€0.26matched
54capture01a19a9c-109a-7e7e-a6ee-400221250432€49.00€0.67matched
55capture01a19a9c-10cc-7e76-9b33-e7d6461f1c6a€9.00€0.19matched
56capture01a19a9c-11fb-7919-a40a-e29f45c959f7€49.00€0.67matched
57capture01a19a9c-3541-776e-bc35-6d458a84bf53€9.00€0.19matched
58capture01a19a9c-37b2-7e61-a2e1-6cd3b8f2bfbf€49.00€0.67matched
59capture01a19a9c-419e-7722-b625-610c38f0ec61€24.00€0.37matched
60capture01a19a9c-64ce-7bbd-8b08-144388d38008€49.00€0.67matched
61refund01a19a9c-6719-7bea-9e65-00b66bc869e6-€8.00€0.00matched
62capture01a19a9c-6b21-73de-8bc5-226d8e9ddfc7€9.00€0.19matched
63capture01a19a9c-69f8-7542-b3e7-1dcc3c3b977b€35.00€0.50matched
64capture01a19a9c-7d84-76f4-aba3-f4abf9683072€49.00€0.67matched
65capture01a19a9c-9f4d-7368-936f-c5dd8aed44bf€15.00€0.26matched
66capture01a19a9c-a442-75cf-b26a-e8157d5edee1€24.00€0.37matched
68capture01a19a9d-1516-7279-8b5d-603c1e77154b€49.00€0.67matched
69capture01a19a9d-318d-7df3-93ee-94678ebf38ea€35.00€0.50matched
70capture01a19a9d-4cda-794c-a5ec-9c92ba650137€24.00€0.37matched
71capture01a19a9d-661c-7e92-9e73-26ec85df1927€15.00€0.26matched
72capture01a19a9d-7cb2-70d8-bc68-c81d54473a67€35.00€0.50matched
73capture01a19a9d-b4bf-7bb4-91cf-5e6795262e24€49.00€0.67matched
74capture01a19a9d-daad-79a6-ad95-64a52243fdaa€9.00€0.19matched
75capture01a19a9d-dd0b-7cc4-8f17-650be7887f75€24.00€0.37matched
76capture01a19a9d-d7ae-7abc-8384-ec244a9b2bc8€24.00€0.37matched
77capture01a19a9d-e320-71c5-91d6-67855eb2ee8c€49.00€0.67matched
78capture01a19a9d-fbb5-76a2-986e-b167b80da41b€24.00€0.37matched
79capture01a19a9e-05f1-7a1a-bc42-126948cba470€15.00€0.26matched
80capture01a19a9e-07af-763a-b718-4600ee60a781€24.00€0.37matched
81capture01a19a9e-1962-7b39-a916-7813003aba6c€24.00€0.37matched
82capture01a19a9e-3fcd-7699-af7e-59205d4ed286€49.00€0.67matched
83capture01a19a9e-4eaa-7787-b6b6-657d60d0c302€49.00€0.67matched
84capture01a19a9e-71df-77b5-9403-59c63fe0a626€9.00€0.19matched
85capture01a19a9e-880f-73ce-bfac-656423cfa6ee€24.00€0.37matched
86capture01a19a9e-8850-7628-887f-b2118a30db26€35.00€0.50matched
87capture01a19a9e-8d77-7f0e-97bd-365916b0d9d6€35.00€0.50matched
88capture01a19a9e-f32b-763c-ab2f-4a90ecdbb5e6€35.00€0.50matched
89capture01a19a9f-05bb-792e-b7da-c0b0ab655e1d€24.00€0.37matched
90capture01a19a9f-1d74-7053-b191-b8c28152e293€35.00€0.50matched
91capture01a19a9f-20ab-7f15-8e46-84129aee4a46€24.00€0.37matched
92capture01a19a9f-2fdd-7514-a556-499f9bd88709€24.00€0.37matched
93capture01a19a9f-40d7-7045-908f-9e31d3190b6a€9.00€0.19matched
94capture01a19a9f-61b6-7708-b88f-91a925ce838b€9.00€0.19matched
95capture01a19a9f-753d-7fc3-a306-61066a18722e€24.00€0.37matched
96capture01a19a9f-aa6a-7ced-b234-5d2f3985e04b€49.00€0.67matched
97capture01a19aa0-1c08-7f4e-b66c-238c6c57720d€49.00€0.67matched
98capture01a19aa0-225c-70da-9b0f-06c3006a1b47€35.00€0.50matched
99capture01a19aa0-3a94-7f19-9e2c-105ae8057f90€15.00€0.26matched
100capture01a19aa0-406d-7383-a9d3-deeefd8da951€35.00€0.50matched
102capture01a19aa0-53c8-704b-ba08-f66261232dbb€35.00€0.50matched
103capture01a19aa0-5b0c-706a-85ca-4845a0dabc21€9.00€0.19matched
104capture01a19aa0-66cd-7c39-a33a-29c0e5f22d1e€15.00€0.26matched
105capture01a19aa0-6c0e-7582-bb3d-412ff1bfdbb0€15.00€0.26matched
106capture01a19aa0-6d48-7296-80a7-e8113d14e640€49.00€0.67matched
107capture01a19aa0-7dc7-7d5a-9dd5-57405b87f0ed€9.00€0.19matched
108refund01a19aa0-869c-7f35-9bb9-dc581452e3ca-€15.00€0.00matched
109capture01a19aa0-a6bf-765c-ae71-fce202e6e779€35.00€0.50matched
110capture01a19aa0-bf73-7bb4-bdbf-2bfdc294b94e€15.00€0.26matched
111capture01a19aa0-dfce-7300-a56e-7f7fd0841f94€9.00€0.19matched
112capture01a19aa0-e5ac-7b97-8cb6-ac30ef0b0aee€35.00€0.50matched