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

Gross

€3,174.00

PSP fee

€50.92

Net to the bank

€3,123.08

Settlement journal

#391602

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a9fc-13e2-74da-8433-db8721018aec is already settled by stl_EUR_2989755 line 57
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
LineKindReferenceGrossFeeStatus
6capture01a1a9f8-a0ef-7360-8bcc-1f645d6dfcfe€35.00€0.55fee difference
58capture01a1a9fc-1452-77de-8aba-0be299b4342e€9.00€0.19duplicate line
99capture01a1a9fe-f168-72c6-8c3d-072c523494fb€35.00€0.55fee difference
1capture01a1a9f2-0da9-7a4d-98b5-e7244092f6dd€15.00€0.26matched
2capture01a1a9f2-a4c7-7918-915a-f334db67cecd€24.00€0.37matched
3capture01a1a9f7-408f-7ccc-9967-de05ef9beb5f€49.00€0.67matched
4capture01a1a9f8-94e3-7bba-8c4c-fa4275d20762€24.00€0.37matched
5capture01a1a9f8-97eb-7307-99de-fc9c4d884b08€49.00€0.67matched
7capture01a1a9f8-a654-791c-8665-60cf2fd30e3c€49.00€0.67matched
8capture01a1a9f8-a767-7c34-8746-0c3766d354d6€35.00€0.50matched
9capture01a1a9f8-ab06-7648-862a-0b87ebf85ebb€15.00€0.26matched
10capture01a1a9f8-b2fd-7142-bff9-3e554e79a192€35.00€0.50matched
11capture01a1a9f8-bd00-775b-8e62-b2118cccfb11€15.00€0.26matched
12capture01a1a9f8-f1a2-7255-a602-59248252f536€9.00€0.19matched
13capture01a1a9f8-f6b7-7ec6-a534-ba7448a22218€9.00€0.19matched
14capture01a1a9f9-171d-74b7-a7c5-5d78cce0a0ae€35.00€0.50matched
15capture01a1a9f9-1fd7-7653-8e08-4224769fe6a5€15.00€0.26matched
16refund01a1a9f9-2c1b-7c44-9920-327052dfcb10-€6.00€0.00matched
17capture01a1a9f9-2ff4-7536-a6ac-87ebf710129f€35.00€0.50matched
18capture01a1a9f9-4e5b-7552-81fc-4664f2144b2b€49.00€0.67matched
19capture01a1a9f9-574b-7aaa-be4e-1621ae30c11b€24.00€0.37matched
20capture01a1a9f9-7ed8-72ba-bc30-45eaf42db66e€15.00€0.26matched
21capture01a1a9f9-83b4-7198-95e0-9cc22ba60856€24.00€0.37matched
22capture01a1a9f9-97e6-7a24-bbfa-9fb5c06e92ab€24.00€0.37matched
23refund01a1a9f9-9c20-780a-878b-20d8772fd3ae-€21.00€0.00matched
24capture01a1a9f9-aa66-76d1-97f0-228159319c3e€9.00€0.19matched
25capture01a1a9f9-ad55-7964-a574-1018e7e88e04€15.00€0.26matched
26capture01a1a9f9-e0ee-73db-a0d1-1ff5ef84954e€9.00€0.19matched
27capture01a1a9fa-07be-73d9-91bf-ceee571dfbde€24.00€0.37matched
28capture01a1a9fa-1051-7ee0-b882-bf360fd9f182€15.00€0.26matched
29capture01a1a9fa-14c1-7b25-bfff-3624f81a788f€24.00€0.37matched
30capture01a1a9fa-1f9e-7db2-bb12-bf3f6cb3b14e€24.00€0.37matched
31capture01a1a9fa-1da9-7f27-b448-73c668a93591€35.00€0.50matched
32capture01a1a9fa-2724-7ff7-a5c9-881c98c6934d€35.00€0.50matched
33capture01a1a9fa-5b0b-7868-af4d-cfa71e24da6a€24.00€0.37matched
34capture01a1a9fa-5c31-7a53-92b7-a8da8aa21154€24.00€0.37matched
35capture01a1a9fa-62d8-7c92-a52d-9a5075676c5d€35.00€0.50matched
36capture01a1a9fa-7351-7b2c-962e-baeef19f4c61€15.00€0.26matched
37refund01a1a9fa-d0b7-7d2d-9f59-8958928a7e4f-€21.00€0.00matched
38capture01a1a9fa-f225-7580-af0b-10c9ef563257€35.00€0.50matched
39capture01a1a9fa-feaa-7cf2-ac6b-53d9a0e558f8€24.00€0.37matched
40capture01a1a9fb-2490-7faf-b586-db598d143bd0€9.00€0.19matched
41capture01a1a9fb-3003-71ca-96ce-fade94d9f10c€24.00€0.37matched
42capture01a1a9fb-5772-7762-b84e-6fd4ae7a538b€35.00€0.50matched
43capture01a1a9fb-6185-741a-bcf2-9d0225067529€35.00€0.50matched
44capture01a1a9fb-63f9-777d-98b3-ff512cf64915€24.00€0.37matched
45capture01a1a9fb-67d0-7932-b97e-9319d4a4886e€15.00€0.26matched
46capture01a1a9fb-68e0-7ee2-89ef-8418a232a2ac€49.00€0.67matched
47capture01a1a9fb-802f-7953-b0a5-93694be81aef€24.00€0.37matched
48refund01a1a9fb-954e-729b-a711-5df00ec41dfc-€6.00€0.00matched
49capture01a1a9fb-a6b1-71e9-8e5b-21f74b862eb4€49.00€0.67matched
50refund01a1a9fb-bf55-7e7e-888e-1eb5af57dd25-€33.00€0.00matched
51refund01a1a9fb-bfff-7042-9cfb-9aa6a44bcb21-€20.00€0.00matched
52capture01a1a9fb-dfb5-77e5-aa27-8c008177bfc8€24.00€0.37matched
53capture01a1a9fb-e9c4-737d-a5e8-59978d2d144d€35.00€0.50matched
54capture01a1a9fc-0357-74d3-886e-feb685ddcd04€15.00€0.26matched
55capture01a1a9fc-04da-7821-8387-4426481ae4fc€15.00€0.26matched
56capture01a1a9fc-0bb9-7e36-a443-733c462518e2€35.00€0.50matched
57capture01a1a9fc-1452-77de-8aba-0be299b4342e€9.00€0.19matched
59capture01a1a9fc-1c12-7d43-a5a4-5f871568dcea€49.00€0.67matched
60capture01a1a9fc-384d-799e-abb8-7f1ead822492€24.00€0.37matched
61capture01a1a9fc-3f53-7b37-81ca-d29e50678854€24.00€0.37matched
62capture01a1a9fc-5bd4-7d0f-be80-14ed5145b326€15.00€0.26matched
63capture01a1a9fc-61b3-75a6-904a-132511b0c3af€35.00€0.50matched
64capture01a1a9fc-4f8a-7ea9-bc0e-7fafc7d69f65€24.00€0.37matched
65capture01a1a9fc-75cf-7a82-ac21-abd32c253a31€9.00€0.19matched
66capture01a1a9fc-8530-7f02-8d38-8b177e4ca0a8€35.00€0.50matched
67capture01a1a9fc-953c-725b-90c4-b7634c104dc7€24.00€0.37matched
68capture01a1a9fc-9c16-72b3-b34e-904d086cc144€35.00€0.50matched
69refund01a1a9fc-bf91-79ab-a196-66f694aa0730-€7.00€0.00matched
70capture01a1a9fc-c19c-71eb-99b0-c0374072ff32€15.00€0.26matched
71capture01a1a9fc-c987-7e8d-b070-b1429240be2f€9.00€0.19matched
72capture01a1a9fc-ceaf-78cf-8cfc-916166ec833e€9.00€0.19matched
73capture01a1a9fc-da9e-7640-953b-9a724234fc3e€35.00€0.50matched
74capture01a1a9fc-ef22-7699-9d7a-7379775f2c17€15.00€0.26matched
75capture01a1a9fc-f59b-70d7-8f1d-90f83f2c27e4€49.00€0.67matched
76capture01a1a9fd-0ae2-7f8a-bf74-c63381508c68€35.00€0.50matched
77capture01a1a9fd-2078-7499-9287-27951445721e€24.00€0.37matched
78refund01a1a9fd-35df-75c7-b4cf-524a99508cf9-€16.00€0.00matched
79capture01a1a9fd-5252-79f6-9489-751c001994a6€35.00€0.50matched
80capture01a1a9fd-5c6d-75bd-a707-bbad6ad00673€24.00€0.37matched
81capture01a1a9fd-8db1-748e-8fc8-669f1db001b1€49.00€0.67matched
82capture01a1a9fd-f63e-7801-bbe8-1ac9c70ac344€35.00€0.50matched
83capture01a1a9fd-fca4-7fed-8ce1-cb048771c82e€24.00€0.37matched
84capture01a1a9fe-0cb1-7c49-bc35-080038723e6b€15.00€0.26matched
85capture01a1a9fe-41ad-79b5-8a1b-134fca8b480e€15.00€0.26matched
86capture01a1a9fe-5fc7-7df4-aaa7-523fc60a27d8€15.00€0.26matched
87capture01a1a9fe-77d8-7fee-a0ac-fc7a87584b31€9.00€0.19matched
88capture01a1a9fe-9602-7eb8-a352-619bd1487eb8€15.00€0.26matched
89capture01a1a9fe-a7e9-7cc2-b981-afcf01200a6c€9.00€0.19matched
90capture01a1a9fe-a932-79b1-bc40-97e9b60780ec€35.00€0.50matched
91capture01a1a9fe-a9e3-7f42-8fde-861fb370e2e0€35.00€0.50matched
92capture01a1a9fe-bac0-7060-ab06-443f5ce6d273€15.00€0.26matched
93capture01a1a9fe-c051-7782-a4fd-12ce76372318€24.00€0.37matched
94capture01a1a9fe-c3d5-75a7-b538-78c14fd9e7fa€49.00€0.67matched
95capture01a1a9fe-c3f5-7e84-a2cf-840570078a0a€15.00€0.26matched
96capture01a1a9fe-c9dc-7c5b-9787-cc3fd3f2ad22€15.00€0.26matched
97capture01a1a9fe-b95f-77b0-b3fd-716163a86c3b€15.00€0.26matched
98capture01a1a9fe-dad6-7e24-aaa6-39265bb269fe€9.00€0.19matched
100refund01a1a9ff-0ac0-7a22-abfa-46877e76ce6b-€11.00€0.00matched
101capture01a1a9ff-3edd-713a-be26-fb4196b8b88c€15.00€0.26matched
102capture01a1a9ff-5694-7d01-bb42-c7beaa351a47€49.00€0.67matched
103capture01a1a9ff-6171-7988-9a1d-ab972968b19c€35.00€0.50matched
104capture01a1a9ff-7025-75e4-ba5d-4e411913ebb0€15.00€0.26matched
105capture01a1a9ff-709f-702b-b264-3f39a989dbdb€24.00€0.37matched
106refund01a1a9ff-75b5-7070-a19a-76fd0ae9aa67-€5.00€0.00matched
107capture01a1a9ff-7cd7-7057-930b-cab579f93213€15.00€0.26matched
108capture01a1a9ff-9299-7506-a30d-d854da1d44d8€49.00€0.67matched
109capture01a1a9ff-a236-75b5-8ee5-5168b315616d€9.00€0.19matched
110capture01a1a9ff-a83e-771e-a190-938060ffe469€9.00€0.19matched
111capture01a1a9ff-b1d7-723b-9f1f-0631c793ef39€24.00€0.37matched
112capture01a1a9ff-b396-76f4-a7a4-15eba003ed62€9.00€0.19matched
113capture01a1a9ff-d36b-7098-b29e-8ccf894a00ab€49.00€0.67matched
114capture01a1a9ff-f179-71ea-844a-0d88aba3462c€24.00€0.37matched
115capture01a1a9ff-f978-7846-8d89-3680f18e3945€24.00€0.37matched
116capture01a1a9ff-fae4-7dc9-8406-08ac4029db67€49.00€0.67matched
117refund01a1aa00-260e-7d2e-bb91-8edc55cfd6fa-€30.00€0.00matched
118capture01a1aa00-2690-7e1d-9a14-04b3a1ebb5aa€24.00€0.37matched
119capture01a1aa00-3351-707d-a5d5-94df53a9514f€9.00€0.19matched
120capture01a1aa00-3553-7a68-a957-136cd7ab525d€9.00€0.19matched
121capture01a1aa00-38ee-7584-89bc-0f2382bf40b4€49.00€0.67matched
122capture01a1aa00-38ef-7526-8d5f-d111e4ed7fe9€9.00€0.19matched
123capture01a1aa00-a942-7e3d-a82c-851742d46719€15.00€0.26matched
124capture01a1aa00-c03b-7f88-a4e2-0ec92451f1eb€35.00€0.50matched
125capture01a1aa00-cd25-7ef8-8823-34959695cc40€24.00€0.37matched
126capture01a1aa00-e04f-74ad-975d-e740549a0527€49.00€0.67matched
127capture01a1aa00-f765-74a8-ad2c-e244a6c5b3ed€15.00€0.26matched
128capture01a1aa00-fbda-7ef0-855e-c321d8bb4733€35.00€0.50matched
129capture01a1aa01-00c2-74f3-b012-fd236ce77dd1€35.00€0.50matched
130capture01a1aa01-0fe1-74a2-a01c-f247f87b47dd€49.00€0.67matched
131capture01a1aa01-15aa-745b-9018-122a7ee19c1a€15.00€0.26matched
132capture01a1aa01-1693-7031-9cbd-a9c116dfa0c6€15.00€0.26matched
133capture01a1aa01-1966-7073-8ed5-ebf96ef808ae€35.00€0.50matched
134capture01a1aa01-339e-788b-b244-3a30cccd66c6€49.00€0.67matched
135capture01a1aa01-33c8-7f1b-a084-d3c823e8249d€9.00€0.19matched
136capture01a1aa01-3454-7d4a-93a2-7cb42e25b506€9.00€0.19matched
137capture01a1aa01-37a7-7041-adae-9c7c79d68bf5€24.00€0.37matched
138capture01a1aa01-5a77-7c01-945c-78c6c8bcba67€35.00€0.50matched
139capture01a1aa01-7805-7887-b289-b405cbfc4f64€24.00€0.37matched
140capture01a1aa01-8c25-7b4e-a21c-c8475e28381c€15.00€0.26matched
141capture01a1aa01-9c4e-7fb9-a17b-edb0130fbf80€35.00€0.50matched
142capture01a1aa01-a61e-7f17-ba97-0647d09c7e3a€35.00€0.50matched