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

3 Nov, 22:30

Gross

€3,007.00

PSP fee

€47.56

Net to the bank

€2,959.44

Settlement journal

#368660

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a38b-d5a8-74a9-89a7-c4c523d0e62c is already settled by stl_EUR_2989575 line 47
  • duplicate linethe file lists it twicecapture:01a1a391-2682-7ef3-ab69-be642e75b86b is already settled by stl_EUR_2989575 line 121
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • missing linein the books, not in the filecapture:01a1a38b-edd2-75eb-990e-f9eb0a071652 is in no file
LineKindReferenceGrossFeeStatus
48capture01a1a38b-d5d9-7f8e-a933-50ec509a31b0€24.00€0.37duplicate line
112capture01a1a390-7a9a-7be4-b0bb-8603b8a67030€9.00€0.20fee difference
122capture01a1a391-26a9-796a-9dfb-84e9c92b949a€9.00€0.19duplicate line
1capture01a1a383-d094-768e-a8d9-61c6f1311ae3€24.00€0.37matched
2refund01a1a384-2406-7c9c-b6b5-e82c8ce947c6-€6.00€0.00matched
3capture01a1a385-0d8c-77ae-b167-8c830039f3b3€24.00€0.37matched
4capture01a1a385-d1b1-72c0-a6e9-56bf9f14cb87€24.00€0.37matched
5capture01a1a387-cbff-7c49-b912-8e5e0343db69€35.00€0.50matched
6capture01a1a388-b0fb-72a2-a6fc-ea66a311fbc3€9.00€0.19matched
7capture01a1a388-cd9a-7490-9d2f-02267039d2f5€49.00€0.67matched
8capture01a1a388-e1a0-704b-bb9a-62359830e475€24.00€0.37matched
9capture01a1a388-e5dc-7a7d-93ff-6628d7196340€49.00€0.67matched
10refund01a1a389-0dbb-7324-ae61-4f7e83a9e400-€22.00€0.00matched
11capture01a1a389-2704-7fc6-8ef9-57f933ddbfa4€9.00€0.19matched
12capture01a1a389-2a20-7169-888c-65cc60f8dc33€49.00€0.67matched
13capture01a1a389-30b1-783f-ba2a-61160ddf04cb€35.00€0.50matched
14capture01a1a389-3ca7-7550-b4c9-f707ba80da00€15.00€0.26matched
15capture01a1a389-4206-77b1-9269-f696001dba41€35.00€0.50matched
16capture01a1a389-5104-7ef9-95d1-6f164a9a557a€9.00€0.19matched
17capture01a1a389-52ce-7d8b-bbde-d4a9b2cfd019€49.00€0.67matched
18capture01a1a389-89b3-7efc-9cae-a2ef89b1ba36€49.00€0.67matched
19capture01a1a389-92ac-7dea-b7df-54a63bd9e527€15.00€0.26matched
20capture01a1a389-9501-75f7-9b12-6ae48bf89216€15.00€0.26matched
21capture01a1a389-a34e-7ee7-9ac2-b6d014e85013€15.00€0.26matched
22capture01a1a389-c12d-7ca9-9c02-7619f2f61917€9.00€0.19matched
23capture01a1a389-e7d4-7344-94ce-f120c5265243€24.00€0.37matched
24capture01a1a389-ecb2-7dcb-bf4e-7f276870dfd6€15.00€0.26matched
25capture01a1a389-f4f3-7695-811e-22b56a73b40f€35.00€0.50matched
26capture01a1a38a-03b8-72d8-a255-f2b1395efea8€35.00€0.50matched
27capture01a1a38a-27c3-701f-9e83-26a1377bfc99€9.00€0.19matched
28capture01a1a38a-2e47-7a06-a11a-a39f049e8a53€49.00€0.67matched
29capture01a1a38a-3289-7165-87dc-96249d53c270€15.00€0.26matched
30capture01a1a38a-3af4-7f16-89b8-fcdbd3644a62€49.00€0.67matched
31capture01a1a38a-5791-757e-ac9a-86fb120cf9b7€9.00€0.19matched
32capture01a1a38a-5c0c-7634-9cf4-aaccbcb7e34f€35.00€0.50matched
33capture01a1a38a-67f0-7d36-8d51-04565f0df405€15.00€0.26matched
34capture01a1a38a-8139-77c8-801f-2c6e3477fd47€35.00€0.50matched
35capture01a1a38a-9d43-74d2-9ed7-2bcbc8a6cc86€9.00€0.19matched
36capture01a1a38a-b26f-7574-bc7c-22f59dbabaee€15.00€0.26matched
37capture01a1a38a-b8c5-7456-9bfb-4b07ba1289ee€9.00€0.19matched
38capture01a1a38a-f570-74d8-8688-6861f7d76f8b€35.00€0.50matched
39capture01a1a38a-f743-7cb1-8446-bbfc545e8939€9.00€0.19matched
40capture01a1a38b-620a-7e2b-a276-1ff298bc40f2€24.00€0.37matched
41capture01a1a38b-6566-7c48-b025-a6b304c74f35€9.00€0.19matched
42capture01a1a38b-6636-74b8-b564-1eb38f14615e€15.00€0.26matched
43capture01a1a38b-70c5-76e8-9c83-41350c8096ea€35.00€0.50matched
44capture01a1a38b-a1cb-7464-b383-fa70144eaa49€9.00€0.19matched
45capture01a1a38b-a950-75bf-babb-154a9e34f6ca€15.00€0.26matched
46capture01a1a38b-d165-755f-9655-82b25e9d561f€49.00€0.67matched
47capture01a1a38b-d5d9-7f8e-a933-50ec509a31b0€24.00€0.37matched
49capture01a1a38b-de5f-7a15-9a10-596dc5f9f60c€35.00€0.50matched
50capture01a1a38c-058a-7f7d-80d2-69117c4534c1€35.00€0.50matched
51capture01a1a38c-2c1e-71b6-a8b6-af8e09254f3a€49.00€0.67matched
52capture01a1a38c-3e40-78c8-a365-09f789cfec9d€9.00€0.19matched
53capture01a1a38c-41ad-7a21-ae71-5b1ced0dc5f3€24.00€0.37matched
54capture01a1a38c-56ac-7c7c-a89d-ae602888faf6€15.00€0.26matched
55capture01a1a38c-5a43-72e4-98f6-298ce774d1ce€35.00€0.50matched
56capture01a1a38c-6cc0-79be-a244-2088225004ad€15.00€0.26matched
57refund01a1a38c-8bc9-7c2c-9b5f-8652fffbab18-€5.00€0.00matched
58capture01a1a38d-0653-7da6-96c1-e40553a0dedd€9.00€0.19matched
59capture01a1a38d-0ade-7f0c-a2a5-0464497ddd85€49.00€0.67matched
60capture01a1a38d-0c9e-784f-bb91-9ca8e4101f96€49.00€0.67matched
61capture01a1a38d-1c36-740a-a60c-b456359a1db2€35.00€0.50matched
62capture01a1a38d-3773-7de9-8142-66ab1c30d709€24.00€0.37matched
63capture01a1a38d-674a-7724-b75e-99e7797429e5€35.00€0.50matched
64capture01a1a38d-67d5-7857-847a-183de02d8411€49.00€0.67matched
65capture01a1a38d-6fa0-7f79-8bb8-a80c48a2125a€35.00€0.50matched
66capture01a1a38d-7065-78aa-ad02-fa47eadf9c81€9.00€0.19matched
67capture01a1a38d-8dce-78fd-b029-b8e849ac5c46€9.00€0.19matched
68capture01a1a38d-ba03-754b-b1f2-32d0ec2c2f72€9.00€0.19matched
69capture01a1a38d-ca12-7772-8272-80d4de093ad7€24.00€0.37matched
70capture01a1a38d-ca35-728f-a42e-e63f712933bc€24.00€0.37matched
71capture01a1a38d-d636-7b37-9fcf-24b3536c1d32€15.00€0.26matched
72capture01a1a38d-f7a6-719c-aac6-1b89022182b1€9.00€0.19matched
73capture01a1a38e-0b64-7262-9116-f92769a26624€15.00€0.26matched
74capture01a1a38e-0dfd-7e21-bbf6-37f16c0815b9€24.00€0.37matched
75capture01a1a38e-19bb-7757-923c-fea8acf37b45€49.00€0.67matched
76capture01a1a38e-2050-7596-9c6a-77b394ce2cdd€15.00€0.26matched
77capture01a1a38e-3ccc-7a02-9329-1ad82269f896€24.00€0.37matched
78refund01a1a38e-4dc0-7939-b05d-f1cc3d6bd0c3-€9.00€0.00matched
79capture01a1a38e-515a-74c9-a8ca-20f34f741752€35.00€0.50matched
80capture01a1a38e-5eb7-75d5-bd82-d02e732b4aa1€24.00€0.37matched
81capture01a1a38e-77c8-7411-b344-47c313e250aa€24.00€0.37matched
82capture01a1a38e-9898-77ad-8de0-1ba2885d1164€35.00€0.50matched
83capture01a1a38e-d14a-7534-a1d2-4386e3293153€35.00€0.50matched
84capture01a1a38f-1e0d-76c9-9118-77ad2eb66009€49.00€0.67matched
85capture01a1a38f-246d-79fd-afae-f5d2f410bb3a€24.00€0.37matched
86capture01a1a38f-28ba-77d9-8687-cc9ca5f7fc40€24.00€0.37matched
87capture01a1a38f-43c3-72b0-b184-e9ed1e02f5b6€49.00€0.67matched
88capture01a1a38f-4732-7002-b2da-899c854e2939€35.00€0.50matched
89capture01a1a38f-4c4a-7342-908e-a13e570d9c79€24.00€0.37matched
90capture01a1a38f-590a-7a8d-beaf-4052d27710fb€49.00€0.67matched
91capture01a1a38f-59c7-7838-b016-77b86bf5e3f2€35.00€0.50matched
92capture01a1a38f-6f07-748b-ab89-3d3e8e4e4934€24.00€0.37matched
93capture01a1a38f-7227-7562-9081-fe39792994c8€15.00€0.26matched
94capture01a1a38f-745f-7f05-ad4e-b82126088038€9.00€0.19matched
95capture01a1a38f-7ed0-703b-907d-c5f8c3b754f3€9.00€0.19matched
96capture01a1a38f-8f49-7511-8d19-39c34e0e8392€24.00€0.37matched
97capture01a1a38f-9654-702e-87cd-9181c76723de€9.00€0.19matched
98capture01a1a38f-972e-78d1-834e-af88c0cbaa03€24.00€0.37matched
99capture01a1a38f-99d0-7a8d-a20d-98cea1b2defb€35.00€0.50matched
100capture01a1a38f-a9a5-7a54-8e0d-7a3f8a08e68a€24.00€0.37matched
101capture01a1a38f-ac52-704f-b9f1-bd448d78d69e€24.00€0.37matched
102capture01a1a38f-c712-749e-9f4d-8e13ad2d88ec€15.00€0.26matched
103capture01a1a38f-ecb3-7ed6-90f0-c1f1c44aad23€49.00€0.67matched
104capture01a1a38f-f064-737c-b37e-fa7725cde533€9.00€0.19matched
105capture01a1a38f-f1a1-7ca1-b10e-80d3f7d3646a€24.00€0.37matched
106capture01a1a390-4a95-7625-9a75-89cedd8774ed€35.00€0.50matched
107capture01a1a390-4e33-7d5f-a5db-c3557631484e€35.00€0.50matched
108capture01a1a390-5464-70a2-9389-81e73ad739a6€24.00€0.37matched
109capture01a1a390-54ae-73b5-b4ab-238b1e8b7471€15.00€0.26matched
110capture01a1a390-6219-7881-abda-d48d09f822c4€9.00€0.19matched
111capture01a1a390-6ef0-7921-abdc-6108d252c5f5€24.00€0.37matched
113capture01a1a390-7f9f-76cd-a299-1d1605700f01€24.00€0.37matched
114capture01a1a390-a146-7cb4-bce6-21d496631176€35.00€0.50matched
115capture01a1a390-d13e-7225-a223-5ff8a159d2d0€24.00€0.37matched
116capture01a1a390-ef08-76a7-881c-e3ad0b482ed2€49.00€0.67matched
117capture01a1a390-fc03-7d23-964d-07e5c92a8355€49.00€0.67matched
118capture01a1a391-16a0-7571-97a0-100793beeafb€15.00€0.26matched
119capture01a1a391-1a89-7d1a-ada4-ffc0d4f95bbd€15.00€0.26matched
120capture01a1a391-1edc-7aba-83b8-c04f207a5ebf€9.00€0.19matched
121capture01a1a391-26a9-796a-9dfb-84e9c92b949a€9.00€0.19matched
123refund01a1a391-2eb1-7c79-b57b-6274a7943d70-€26.00€0.00matched
124capture01a1a391-3063-732d-a6c4-2d765efe3c38€24.00€0.37matched
125capture01a1a391-4421-7d6e-86bd-dfde8028573e€9.00€0.19matched
126refund01a1a391-4b06-7a99-bade-097ed9831bd0-€48.00€0.00matched
127capture01a1a391-4c71-7f7d-8b00-127a24f1f9ec€15.00€0.26matched
128capture01a1a391-6468-72e4-a451-9a13d0741661€15.00€0.26matched
129capture01a1a391-78c9-712e-bc0d-c76102230c5b€35.00€0.50matched
130capture01a1a391-a790-7f35-b065-45ca161b3fe3€24.00€0.37matched