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

Gross

€3,184.00

PSP fee

€51.51

Net to the bank

€3,132.49

Settlement journal

#354584

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19f8a-0709-78b4-8f0c-edc304a588ca is already settled by stl_EUR_2989463 line 57
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • missing linein the books, not in the filecapture:01a19f88-40e8-7478-bd21-5d3ca71a7a1e is in no file
LineKindReferenceGrossFeeStatus
58capture01a19f8a-2421-7e84-8ead-c0512518c794€35.00€0.50duplicate line
112capture01a19f8d-b546-75a3-9147-51dbb0a68d52€9.00€0.22fee difference
1capture01a19f7f-645d-7a08-b299-62266cae78e8€15.00€0.26matched
2capture01a19f81-0a49-7f11-a745-935f40259c8e€9.00€0.19matched
3capture01a19f81-126d-770b-910d-5f95a698dfaf€15.00€0.26matched
4capture01a19f83-3ccd-7803-a815-349a607c2b07€9.00€0.19matched
5capture01a19f87-4256-73e2-b470-def6e01cf803€15.00€0.26matched
6capture01a19f87-4514-7491-9a37-29112f813ba6€24.00€0.37matched
7capture01a19f87-5a71-7b76-a812-24a236cbeffe€24.00€0.37matched
8capture01a19f87-6860-7508-bf03-1bebd6f7c6b6€15.00€0.26matched
9capture01a19f87-8049-77a9-b6d0-9e2a5418515b€15.00€0.26matched
10capture01a19f87-83c7-735f-bfe1-cd67024d1d40€35.00€0.50matched
11refund01a19f87-8801-74a1-af86-72066451a3c8-€19.00€0.00matched
12capture01a19f87-94b4-780e-8f49-a58a59b39329€35.00€0.50matched
13capture01a19f87-b134-72f7-81d4-62d170316c3c€9.00€0.19matched
14capture01a19f87-c911-7a51-ab96-860d1553c9f7€9.00€0.19matched
15capture01a19f87-cb37-702f-97ab-16ea8624e642€24.00€0.37matched
16capture01a19f87-d900-7f5f-a130-28411a0c731c€15.00€0.26matched
17capture01a19f87-e6c7-7144-bfcd-35894e79016c€49.00€0.67matched
18capture01a19f88-0235-7d1c-a006-3bb3a307a2f8€35.00€0.50matched
19capture01a19f88-0766-71e2-a7fd-d510603f13d4€15.00€0.26matched
20capture01a19f88-086b-75c3-b05e-526c9121fbb3€35.00€0.50matched
21capture01a19f88-09b4-7431-b8e0-de0231ca11b8€9.00€0.19matched
22capture01a19f88-1a19-7bf3-8b97-30c9c9e610d9€9.00€0.19matched
23capture01a19f88-2501-71f8-93ea-29ae4d2ac7ae€49.00€0.67matched
24capture01a19f88-2552-7e0e-970f-dc2d3ef4bb66€9.00€0.19matched
25refund01a19f88-53d2-7ca0-947a-05223b592d8c-€7.00€0.00matched
26capture01a19f88-56e1-7275-9eac-d0a06a9cb353€24.00€0.37matched
27capture01a19f88-73b8-7994-b5c5-fe3d39bd960d€9.00€0.19matched
28capture01a19f88-7765-741d-9034-2f5c562b21e7€24.00€0.37matched
29capture01a19f88-8b43-78c0-8726-4fbb04684eee€49.00€0.67matched
30capture01a19f88-8ecd-7367-8b37-fb209d73f9df€35.00€0.50matched
31capture01a19f88-95b3-7da0-a63b-cffa739f1762€9.00€0.19matched
32capture01a19f88-a4c0-7a0d-aa1d-f298505e482b€15.00€0.26matched
33capture01a19f88-dd87-73d1-89f7-9ede25e85cc3€49.00€0.67matched
34capture01a19f88-ebe0-74b2-9032-14108cb14453€24.00€0.37matched
35capture01a19f88-ec88-7131-a8ff-c70f6ad13983€49.00€0.67matched
36capture01a19f88-f23c-7e62-822a-0961e50ce58b€24.00€0.37matched
37capture01a19f88-ff26-7fda-8f5d-2ef397a89766€24.00€0.37matched
38capture01a19f88-ff5f-7cc6-a037-b37766df8fb3€9.00€0.19matched
39capture01a19f89-02db-7798-a736-35241c7a5405€15.00€0.26matched
40capture01a19f89-0d55-7cf1-99e2-f24e0875f420€49.00€0.67matched
41capture01a19f89-178b-7845-bc39-6bcc3cb1874f€35.00€0.50matched
42capture01a19f89-24b8-7507-99c6-6d387f7aa3d0€24.00€0.37matched
43capture01a19f89-2767-7816-8d01-c34dc131ffc6€35.00€0.50matched
44refund01a19f89-3deb-7778-b737-d5cc7728efcd-€4.00€0.00matched
45capture01a19f89-3e68-7ab7-981c-14eac5ba8fa5€15.00€0.26matched
46capture01a19f89-49a4-79ea-a83f-d7415c10566d€9.00€0.19matched
47capture01a19f89-4bb8-71b2-a5c4-283006b82ec9€9.00€0.19matched
48refund01a19f89-6124-7531-a3b1-07d7ef278888-€19.00€0.00matched
49capture01a19f89-a7dd-7c99-b0a7-8461451bd741€15.00€0.26matched
50capture01a19f89-b3bb-763b-97d0-0b0c2bd56eef€49.00€0.67matched
51capture01a19f89-b548-7ab2-85a5-b6d2dd506bfd€9.00€0.19matched
52capture01a19f89-b9d4-7715-94fa-1282617fe10c€49.00€0.67matched
53capture01a19f89-ddca-7e4a-8af6-b3d1c483f7db€15.00€0.26matched
54capture01a19f89-e9a7-7c65-aca3-da3d627bb46a€35.00€0.50matched
55capture01a19f89-f1a5-792a-abd1-7e2c2a80c33b€15.00€0.26matched
56capture01a19f89-e7c2-7c70-a488-18930f1333ff€9.00€0.19matched
57capture01a19f8a-2421-7e84-8ead-c0512518c794€35.00€0.50matched
59capture01a19f8a-2cbe-7388-b51b-244bae0ed04c€24.00€0.37matched
60capture01a19f8a-3495-7674-be0c-a2d6de94322d€24.00€0.37matched
61capture01a19f8a-35a6-7c48-9744-089a21b40673€9.00€0.19matched
62capture01a19f8a-3be7-7487-b96d-093a7af6e64a€24.00€0.37matched
63capture01a19f8a-4322-7c0d-99a0-f1e70833f3f1€24.00€0.37matched
64capture01a19f8a-480e-739a-9465-5b35bdd1ed67€35.00€0.50matched
65capture01a19f8a-4d74-75bd-a951-72d30b10722c€49.00€0.67matched
66capture01a19f8a-7cfc-7bef-9681-ab42387a8122€15.00€0.26matched
67capture01a19f8a-8000-7cfe-8789-54717de22bc5€24.00€0.37matched
68refund01a19f8a-9bed-71c0-886f-3180c0fad1bb-€19.00€0.00matched
69refund01a19f8a-abbf-7ff6-85bc-25f1dd05012e-€45.00€0.00matched
70capture01a19f8a-b2d9-7938-b0b6-264d68adbf24€49.00€0.67matched
71capture01a19f8a-dac5-745c-9a88-760be863dded€49.00€0.67matched
72capture01a19f8a-efb6-70f2-8ee1-513a0a2d2502€9.00€0.19matched
73capture01a19f8b-0f90-7ab5-9e13-590523f4de43€15.00€0.26matched
74capture01a19f8b-1d10-76f1-84ee-95c27ddc210d€35.00€0.50matched
75capture01a19f8b-2ae6-7f8e-bb71-11dcd1ae6a97€49.00€0.67matched
76capture01a19f8b-2c3f-753e-8529-644ad7bfb90e€9.00€0.19matched
77capture01a19f8b-3039-794c-9711-620bc4580b1a€35.00€0.50matched
78capture01a19f8b-32cc-7bf1-8644-1b1e988f8568€9.00€0.19matched
79capture01a19f8b-37ca-752a-b9c5-cc58e8f9fbda€49.00€0.67matched
80capture01a19f8b-3aa8-74aa-9165-c776bee1ed28€24.00€0.37matched
81capture01a19f8b-4b3a-7f6f-aca7-52696c3256ea€24.00€0.37matched
82capture01a19f8b-4c3f-70ae-9f1b-515a4e18b9b1€9.00€0.19matched
83capture01a19f8b-a0c5-7ce7-a0be-99213a7f9620€35.00€0.50matched
84capture01a19f8b-bb7b-72b3-b703-caacf71e639e€35.00€0.50matched
85capture01a19f8b-cc55-73df-848b-b0fa5325bce7€35.00€0.50matched
86capture01a19f8b-d535-7e63-bfc2-1a002545206a€9.00€0.19matched
87capture01a19f8b-d815-79ee-a667-b6e36c1d10a3€9.00€0.19matched
88capture01a19f8b-ed4a-7a22-8408-285fe3709821€35.00€0.50matched
89capture01a19f8b-fe10-7169-bf87-d888aaae9958€9.00€0.19matched
90capture01a19f8b-ffea-7f18-9938-779effe77e1c€24.00€0.37matched
91capture01a19f8b-fd3d-725e-bf12-23ea456e87a0€15.00€0.26matched
92capture01a19f8c-0d35-7e16-8741-7336fe79cb13€35.00€0.50matched
93capture01a19f8c-0e87-701a-86eb-952193374448€24.00€0.37matched
94capture01a19f8c-1034-7a82-9f68-54434f70bc34€24.00€0.37matched
95capture01a19f8c-16b2-79a2-9351-37ffab90304d€15.00€0.26matched
96capture01a19f8c-3ef2-7f3e-88ca-e8d8fba88220€24.00€0.37matched
97refund01a19f8c-46c5-7177-aeab-4c35c2aeeb62-€7.00€0.00matched
98capture01a19f8c-698b-7297-87aa-9132524efdb1€35.00€0.50matched
99capture01a19f8c-7038-749a-8039-c2aaac046c42€49.00€0.67matched
100capture01a19f8c-8408-753f-8f60-6d497a345a17€35.00€0.50matched
101capture01a19f8c-afd8-7914-9e2d-77c3d55f53c9€24.00€0.37matched
102capture01a19f8c-efff-7846-a8e5-c36083c97162€15.00€0.26matched
103capture01a19f8c-f08b-7db8-8eec-aa23ae6788d8€24.00€0.37matched
104capture01a19f8c-f68a-79f3-8169-0b57985cf02e€15.00€0.26matched
105capture01a19f8d-33f5-76ac-91b3-4d28ece1af4d€49.00€0.67matched
106capture01a19f8d-35dd-7254-9298-a3ca5f382588€15.00€0.26matched
107capture01a19f8d-6143-71fc-b14a-ccf09ea11321€9.00€0.19matched
108capture01a19f8d-63b3-7627-8f3d-b3c6e335ee75€9.00€0.19matched
109capture01a19f8d-73fa-7a4a-b7c0-cf1c86d77fe4€24.00€0.37matched
110capture01a19f8d-93b6-7176-a541-50c979415114€49.00€0.67matched
111capture01a19f8d-9439-71a6-ac16-f5fd5b94b4e1€49.00€0.67matched
113capture01a19f8e-0115-7774-bfc3-8cd652cd84f9€15.00€0.26matched
114capture01a19f8e-142a-7267-bbd6-f73be1b1357d€9.00€0.19matched
115capture01a19f8e-391a-77f6-b47d-ad2e5c72b6dd€35.00€0.50matched
116capture01a19f8e-4223-7fe7-931a-724a71c488e9€35.00€0.50matched
117capture01a19f8e-446d-78c4-bc1b-57ba585b153c€35.00€0.50matched
118capture01a19f8e-5436-7193-9d04-7fc9796fa115€9.00€0.19matched
119capture01a19f8e-57a3-7a04-b89e-d10c02d3ffe8€35.00€0.50matched
120refund01a19f8e-8263-7aa5-86ed-a1423a897dfb-€4.00€0.00matched
121capture01a19f8e-886c-7bf7-8c6e-6a88a38fd4d2€49.00€0.67matched
122capture01a19f8e-9a9f-7149-8ca1-b9c72058d79d€15.00€0.26matched
123capture01a19f8e-a15c-7d23-abda-8377a350d8b7€49.00€0.67matched
124capture01a19f8e-ac70-7a8a-be1d-8a5f571b8e28€49.00€0.67matched
125capture01a19f8e-ac86-7a76-a603-cf9f397c0592€24.00€0.37matched
126capture01a19f8e-b2de-74e3-944d-9cc3717840c1€15.00€0.26matched
127capture01a19f8e-b380-7d4f-8ffb-eea0bd4c0601€24.00€0.37matched
128capture01a19f8e-dd50-76f9-a9ad-6dbf30d18a16€15.00€0.26matched
129refund01a19f8e-f664-7df0-b649-08e2ec7acdb3-€36.00€0.00matched
130capture01a19f8f-0434-7ba9-9046-86edd8fa0b6f€35.00€0.50matched
131capture01a19f8f-3a97-7762-9dd5-40f76841687c€9.00€0.19matched
132capture01a19f8f-5a6d-7858-a051-e10af0868846€24.00€0.37matched
133capture01a19f8f-648b-7cf6-8935-64d1c9601992€15.00€0.26matched
134capture01a19f8f-7bad-7f51-ac85-f3394fc1c39e€24.00€0.37matched
135capture01a19f8f-7fa1-7cf9-bf57-afd6044ebf19€35.00€0.50matched
136capture01a19f8f-b03d-7742-a44d-f650ca0a543f€49.00€0.67matched
137capture01a19f8f-be01-748c-bf34-33ca9319648e€35.00€0.50matched
138refund01a19f8f-cb02-7c23-b7a7-919ae539c817-€19.00€0.00matched
139capture01a19f8f-ee0c-74d4-8946-786309736c77€9.00€0.19matched
140capture01a19f8f-f57f-7e34-b8b5-5cdbcffb8ece€9.00€0.19matched
141capture01a19f8f-f8d0-76f1-8215-57db3bc95558€9.00€0.19matched
142capture01a19f8f-e42c-73ec-8031-b22cd1eb75cb€15.00€0.26matched
143capture01a19f90-1adf-71f0-8efb-d37551cd6346€9.00€0.19matched
144capture01a19f90-2bbc-7608-8871-a5bc1a3c85fc€24.00€0.37matched
145capture01a19f90-40c7-7576-84c1-b0665cb7727e€15.00€0.26matched
146capture01a19f90-4397-7f1a-8b75-c8ff13068de3€15.00€0.26matched
147capture01a19f90-5422-7d2f-9674-ee1cc0f05a92€9.00€0.19matched