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

Gross

€2,827.00

PSP fee

€45.70

Net to the bank

€2,781.30

Settlement journal

#365572

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a2ab-047c-7402-9c88-ad4cb6b235dc is already settled by stl_EUR_2989550 line 106
  • missing linein the books, not in the filecapture:01a1a2a6-07cf-7e44-9edc-adc58447177c is in no file
LineKindReferenceGrossFeeStatus
107capture01a1a2ab-04af-76b5-aa69-04261f921995€15.00€0.26duplicate line
1capture01a1a29d-1a16-7c98-9887-75740730db74€15.00€0.26matched
2capture01a1a29e-95c6-7ab1-b2e2-4817b465b9e4€24.00€0.37matched
3capture01a1a2a3-bf0b-7dac-8c4c-7331712c6ed4€24.00€0.37matched
4capture01a1a2a3-fcd8-74b1-b35b-630053fb25dd€24.00€0.37matched
5capture01a1a2a4-0005-7f46-af4b-ff0fd349206e€9.00€0.19matched
6capture01a1a2a4-109d-7fc9-9213-4c90c4be8e2e€15.00€0.26matched
7capture01a1a2a4-1509-73dd-a692-a1273d3b9c49€15.00€0.26matched
8capture01a1a2a4-2d33-72eb-81ac-0dd11b5db4ef€9.00€0.19matched
9capture01a1a2a4-3d89-74d0-b7c0-70d05f3217ac€9.00€0.19matched
10capture01a1a2a4-5326-77b0-9de4-d059d83dd1c3€35.00€0.50matched
11capture01a1a2a4-5119-7bdb-8411-7ecb99825d92€24.00€0.37matched
12capture01a1a2a4-5f38-787c-9fc9-fb9073e6a77d€24.00€0.37matched
13capture01a1a2a4-6900-72ca-bf36-ee8ff81da16a€24.00€0.37matched
14capture01a1a2a4-692a-735b-98a9-77daff992e5f€24.00€0.37matched
15capture01a1a2a4-7ee4-7098-9d69-0c72296fa244€35.00€0.50matched
16capture01a1a2a4-8163-701f-b3f0-d3e6f4c1db92€15.00€0.26matched
17capture01a1a2a4-85e0-7bbc-90a1-7a86d15b0ece€49.00€0.67matched
18capture01a1a2a4-868f-7d38-9ca9-6f00849dd69a€24.00€0.37matched
19capture01a1a2a4-86a4-7d78-bb60-f882d41d9b89€15.00€0.26matched
20capture01a1a2a4-98d0-7925-8cab-be5b8710aa46€15.00€0.26matched
21capture01a1a2a4-9bae-77d1-9713-f89077468004€49.00€0.67matched
22capture01a1a2a4-b91f-715b-921d-11a8f6c0a0bd€49.00€0.67matched
23capture01a1a2a4-d377-7f1f-b120-a9edf9cf2de1€15.00€0.26matched
24capture01a1a2a4-dbe2-7b7e-829a-93d492cb7b20€9.00€0.19matched
25capture01a1a2a4-eb69-7dbe-be2c-8bb4aa7f6f4a€35.00€0.50matched
26capture01a1a2a4-ec79-7d4e-947b-8585323e98fb€15.00€0.26matched
27refund01a1a2a5-0688-7693-92fd-d5e6d8e3441a-€40.00€0.00matched
28capture01a1a2a5-20ce-79dc-9cb6-9499830ca4d2€35.00€0.50matched
29capture01a1a2a5-3768-7ab6-9250-5b53f1683aa8€49.00€0.67matched
30capture01a1a2a5-7019-7a2c-9857-4874e6e2fe2f€15.00€0.26matched
31capture01a1a2a5-815f-74b9-b161-6b709c29db2f€49.00€0.67matched
32capture01a1a2a5-8169-7c60-b1d2-578c074d00b1€35.00€0.50matched
33capture01a1a2a5-a00f-7ed8-94b2-58417c88bd70€35.00€0.50matched
34capture01a1a2a5-aa78-705f-bea7-67ba5cf8a6b8€9.00€0.19matched
35capture01a1a2a5-ad4c-7972-a8f1-bc7bcd0aa9a2€15.00€0.26matched
36capture01a1a2a5-bf8b-7f83-bfca-4286d23f40b1€15.00€0.26matched
37capture01a1a2a5-c02b-77be-9c67-cd008b2992b1€15.00€0.26matched
38capture01a1a2a5-c75f-7999-aa4a-f8f309996cbd€24.00€0.37matched
39capture01a1a2a5-cd07-7dd7-98dd-b828004e4dba€9.00€0.19matched
40capture01a1a2a5-d50e-7330-8a38-2f9f4c933ddd€15.00€0.26matched
41capture01a1a2a5-e071-781c-979a-d43a10e2b3a0€9.00€0.19matched
42capture01a1a2a5-e6ea-7767-8a3d-853e27c962e8€9.00€0.19matched
43capture01a1a2a6-1962-79a6-bee7-ec418c1255e3€9.00€0.19matched
44capture01a1a2a6-197c-74be-9f87-5a625ec9cf60€49.00€0.67matched
45refund01a1a2a6-4964-7b6d-9f0c-204d4ac37711-€6.00€0.00matched
46capture01a1a2a6-999a-776a-ab04-a0a9e1b95661€24.00€0.37matched
47capture01a1a2a6-a64d-7de2-9205-686f116fcfaf€15.00€0.26matched
48capture01a1a2a6-beca-79d3-98e9-0d6c5047dc62€35.00€0.50matched
49capture01a1a2a6-d837-7619-855f-38ecaa082bab€9.00€0.19matched
50capture01a1a2a6-dffb-7c00-a36c-607bf12c7b9f€24.00€0.37matched
51capture01a1a2a6-e09c-7541-a5ef-f43df97d0532€35.00€0.50matched
52capture01a1a2a6-e4b5-795d-ba99-b31315a1362d€9.00€0.19matched
53capture01a1a2a6-ecfd-7cb0-8dc7-ffecb1ddee39€49.00€0.67matched
54capture01a1a2a7-14e1-75ea-8da3-e9c86b2459ea€35.00€0.50matched
55capture01a1a2a7-29f4-7e75-b0ab-f0c5e209ce42€24.00€0.37matched
56capture01a1a2a7-2e8c-7795-95f4-4a12a779139d€35.00€0.50matched
57capture01a1a2a7-3735-7500-8422-2f3b05035f97€15.00€0.26matched
58capture01a1a2a7-38d9-7cb9-95e9-60b6fea1709c€15.00€0.26matched
59capture01a1a2a7-47e9-72fb-832c-a3cfff47a901€35.00€0.50matched
60capture01a1a2a7-4933-7f1b-ac03-fb718d8df3bd€15.00€0.26matched
61capture01a1a2a7-4aba-7887-816c-30d7786a9620€24.00€0.37matched
62capture01a1a2a7-4ec1-72f0-b498-75b36ccaebf2€9.00€0.19matched
63refund01a1a2a7-74f8-7886-a38c-799c5a2f12bf-€5.00€0.00matched
64capture01a1a2a7-8dfa-7a4a-b655-c625c9dcd75c€24.00€0.37matched
65capture01a1a2a7-bd5e-7d92-afb3-a554aea59fa4€35.00€0.50matched
66capture01a1a2a7-c0a4-7b98-8cbf-2fa4174cd0f1€9.00€0.19matched
67capture01a1a2a7-cb74-76e1-bc91-3d91efc18349€24.00€0.37matched
68capture01a1a2a7-dcd1-70e7-942f-419b2f2a7d53€49.00€0.67matched
69capture01a1a2a7-f1d1-73c0-8f48-4f12fe6e7da6€9.00€0.19matched
70refund01a1a2a8-025c-74e4-ac4d-3a696e9db52d-€19.00€0.00matched
71capture01a1a2a8-0a55-7ca5-bd3d-6b400243741e€15.00€0.26matched
72capture01a1a2a8-1fb9-704f-adc2-abbf36ee0520€24.00€0.37matched
73capture01a1a2a8-23cb-7b84-93e6-24851e57c0cd€35.00€0.50matched
74refund01a1a2a8-36a4-7fc7-a1b2-0e0c9f9c5599-€34.00€0.00matched
75capture01a1a2a8-53e7-7e00-9c4d-dff5afb3d6ca€24.00€0.37matched
76capture01a1a2a8-9f5b-79ee-a50f-9e7a2f5862f3€35.00€0.50matched
77capture01a1a2a8-abb9-7d95-af45-ffb1ad5a8fec€49.00€0.67matched
78capture01a1a2a8-c055-7e78-b89a-9a9fa9a9038c€49.00€0.67matched
79capture01a1a2a8-cb2e-7159-b3ab-83d87fc451b0€15.00€0.26matched
80capture01a1a2a8-fb18-727f-94fc-c99aa501d9a2€24.00€0.37matched
81capture01a1a2a9-1eb6-79b4-92eb-98c3d3ecb25a€35.00€0.50matched
82capture01a1a2a9-2a10-7cf5-8325-961a9eabfa4a€9.00€0.19matched
83capture01a1a2a9-733c-7984-af0e-ac437069e2e9€35.00€0.50matched
84capture01a1a2a9-835b-7202-87d3-a0fccb95b819€35.00€0.50matched
85capture01a1a2a9-8ce2-7233-a283-fa35457d51e0€24.00€0.37matched
86capture01a1a2a9-a161-7274-89be-40f47c7024ed€9.00€0.19matched
87capture01a1a2a9-a46e-7de1-9b3a-cb51ddcac81e€35.00€0.50matched
88capture01a1a2a9-c746-7448-adcf-b057b79521e7€15.00€0.26matched
89capture01a1a2a9-cb42-7e76-a562-bf5be81ad5dd€49.00€0.67matched
90capture01a1a2a9-e0d0-78f9-acfa-ab2fd26d5a01€49.00€0.67matched
91capture01a1a2a9-f512-7bd9-b331-8f4dc66c8d31€9.00€0.19matched
92capture01a1a2a9-f5f4-7608-89bf-710297a4f45c€35.00€0.50matched
93capture01a1a2a9-f892-78d2-9b19-f1e89b6ef9e5€9.00€0.19matched
94capture01a1a2a9-fcff-71ec-89b5-0d6aebbdf374€24.00€0.37matched
95capture01a1a2aa-3687-796d-91e2-8bdf509fc8cf€24.00€0.37matched
96capture01a1a2aa-b06c-7402-adb5-f86934c8afdd€9.00€0.19matched
97capture01a1a2aa-b1bc-718f-91dd-f33a839bca4b€35.00€0.50matched
98capture01a1a2aa-baaa-78d6-acb7-f28f7bcde2ce€9.00€0.19matched
99capture01a1a2aa-c762-7cd8-b7b7-2bc1aee64b3b€15.00€0.26matched
100capture01a1a2aa-d342-7dd2-ba45-81e26b318711€24.00€0.37matched
101capture01a1a2aa-f72d-7d2e-9443-4a84e477f989€9.00€0.19matched
102capture01a1a2aa-fa89-7d51-8a90-5bcf8306839e€24.00€0.37matched
103capture01a1a2aa-fdaa-70be-9af9-8fd0eb1f107d€9.00€0.19matched
104capture01a1a2aa-fe53-7069-95c3-c95012732bcb€15.00€0.26matched
105capture01a1a2ab-03a0-7aa4-812d-164ffe2f8c70€9.00€0.19matched
106capture01a1a2ab-04af-76b5-aa69-04261f921995€15.00€0.26matched
108capture01a1a2ab-0953-7867-ac61-1f5b78d4712f€9.00€0.19matched
109capture01a1a2ab-0acf-7589-8593-47c7ddee38ff€15.00€0.26matched
110capture01a1a2ab-1a63-7e08-96b6-49faf1788a96€9.00€0.19matched
111capture01a1a2ab-2782-7577-bf0a-4c42585540a2€35.00€0.50matched
112capture01a1a2ab-37a4-7145-b61b-c105c56e9d96€9.00€0.19matched
113capture01a1a2ab-37d0-73b7-826a-cefa809838b9€49.00€0.67matched
114capture01a1a2ab-3b36-7e7b-9c9a-3301ac8df435€9.00€0.19matched
115capture01a1a2ab-3c66-70f2-afb8-a6b5cc969ff5€24.00€0.37matched
116capture01a1a2ab-4981-74a7-b0a8-3e5676e46123€35.00€0.50matched
117refund01a1a2ab-7ae2-7a6d-909b-462ede3f3479-€34.00€0.00matched
118capture01a1a2ab-7c0f-78ae-9c67-6dfaaf79dc6e€15.00€0.26matched
119capture01a1a2ab-8201-7264-a7ec-5135c3750ac9€9.00€0.19matched
120refund01a1a2ab-8830-78c5-8512-dd884e973802-€5.00€0.00matched
121capture01a1a2ab-a4ea-7ce3-9756-0e2bd9c690f7€15.00€0.26matched
122capture01a1a2ab-a5f9-730d-ba35-bd7688f36b8e€35.00€0.50matched
123capture01a1a2ab-a80d-7089-8815-8f560bc31ed7€35.00€0.50matched
124capture01a1a2ab-ba6a-74b2-986f-b0a5f8232484€9.00€0.19matched
125capture01a1a2ab-db32-7b81-8537-84d965ec7471€24.00€0.37matched
126capture01a1a2ac-0ccc-7bd5-b491-01b33b571c75€35.00€0.50matched
127capture01a1a2ac-4bf7-7716-8b5a-ae7e9010c805€49.00€0.67matched
128capture01a1a2ac-77aa-7bf5-9c05-f8ca8e6b080e€49.00€0.67matched
129capture01a1a2ac-a5cb-77c8-a9d9-7773a2c81eb6€35.00€0.50matched
130capture01a1a2ac-d7fd-740a-983b-1c0447c29d50€24.00€0.37matched
131capture01a1a2ac-db10-7715-9e32-cdecec40d0e7€35.00€0.50matched