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

Gross

€3,094.00

PSP fee

€51.50

Net to the bank

€3,042.50

Settlement journal

#334505

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a199e6-4f40-70e1-9872-b845c97e7c20 is already settled by stl_EUR_2989305 line 92
  • duplicate linethe file lists it twicecapture:01a199e7-d049-77fd-9cae-c2ab5bccc9d6 is already settled by stl_EUR_2989305 line 108
  • missing linein the books, not in the filecapture:01a199e0-fd30-7464-9881-681c6f857460 is in no file
LineKindReferenceGrossFeeStatus
93capture01a199e6-62c0-74e0-ab41-9b51cf845bb0€35.00€0.50duplicate line
109capture01a199e7-d075-7184-b1b0-ebae52f8f659€49.00€0.67duplicate line
1capture01a199d8-c69e-7641-9a44-549ce922dd8b€9.00€0.19matched
2capture01a199e0-bf98-7eed-8df0-a7af34fb97d6€15.00€0.26matched
3capture01a199e0-d923-7823-af11-9a47d3f92e7d€49.00€0.67matched
4capture01a199e0-da7d-7757-9cbd-937f906499e3€15.00€0.26matched
5capture01a199e0-defe-7c6d-94cb-253a0681e94f€24.00€0.37matched
6capture01a199e1-0bfc-7f26-a022-cd1d2e9139e0€15.00€0.26matched
7capture01a199e1-0f7a-774a-8a2e-57d5d8c5fa34€35.00€0.50matched
8capture01a199e1-18ee-70e7-aaf2-967f10577ada€35.00€0.50matched
9refund01a199e1-1b85-7055-905b-25afa5ebb00d-€14.00€0.00matched
10capture01a199e1-1d98-75b8-b889-8702b0aa9077€49.00€0.67matched
11capture01a199e1-4bc4-7703-8c71-25b704dab6ab€49.00€0.67matched
12capture01a199e1-5fb1-713a-8b8c-684c4426b151€49.00€0.67matched
13capture01a199e1-625d-70d2-b15b-d6b24493c322€15.00€0.26matched
14refund01a199e1-72c2-778e-bb04-fb2f77364358-€8.00€0.00matched
15capture01a199e1-7f96-7190-9669-296618c73089€49.00€0.67matched
16capture01a199e1-89b6-79d4-a025-bc0cd036faec€35.00€0.50matched
17capture01a199e1-90d4-7aab-af2f-8106fc527e2f€24.00€0.37matched
18capture01a199e1-9840-71ec-bf5d-7a07b50884a0€9.00€0.19matched
19capture01a199e1-9c6c-7d94-aaee-e5aeb93d7b2c€49.00€0.67matched
20capture01a199e1-9e31-704d-9742-0f6356d2ed31€49.00€0.67matched
21capture01a199e1-a554-738b-b486-4d387a373b79€49.00€0.67matched
22capture01a199e1-c1ef-7a8b-9d29-a13802527cd6€15.00€0.26matched
23capture01a199e1-c294-7968-827c-effa9227d3a2€24.00€0.37matched
24capture01a199e1-c52e-76b4-a2b7-056bc738a6b7€35.00€0.50matched
25capture01a199e1-df6b-775e-a3f9-d9b20ef45c4a€24.00€0.37matched
26capture01a199e1-e054-7a61-b6b3-20157fcb5e92€15.00€0.26matched
27capture01a199e1-eb6f-7a1d-91e0-1466dd960435€15.00€0.26matched
28refund01a199e1-ef23-7243-8549-576fe0f5dcd6-€33.00€0.00matched
29refund01a199e2-0ab6-7ab3-b015-14b70e46a8e7-€7.00€0.00matched
30refund01a199e2-297d-7ed8-a67f-d0064bf88b1d-€11.00€0.00matched
31capture01a199e2-3c3d-7934-bc23-997e7301e70d€49.00€0.67matched
32capture01a199e2-3e94-7381-b6f4-cb4285be4774€9.00€0.19matched
33capture01a199e2-54c9-7170-90a5-f56859f16e23€15.00€0.26matched
34capture01a199e2-855e-7828-ab7e-2d7555bc2e82€9.00€0.19matched
35capture01a199e2-8c9b-7326-b5cf-c0e47ba53521€24.00€0.37matched
36capture01a199e2-92bc-7a36-991c-5574e3505d5e€35.00€0.50matched
37capture01a199e2-aa86-7f9e-8a27-594ab5bac42f€15.00€0.26matched
38capture01a199e2-b21a-769a-a462-66af14c213d2€49.00€0.67matched
39capture01a199e2-b280-7cb2-a0f8-6eff1c59084e€9.00€0.19matched
40capture01a199e3-0822-7f5d-91d1-14a8738c85d5€15.00€0.26matched
41capture01a199e3-309b-7ab3-83e4-36eea4b92b2b€15.00€0.26matched
42capture01a199e3-3d6e-7b9b-a51a-1a77e64de1e8€49.00€0.67matched
43capture01a199e3-3f3a-7080-85f6-bd86b7c44b0f€35.00€0.50matched
44capture01a199e3-482c-7c5e-aa0e-6be889335fbf€15.00€0.26matched
45capture01a199e3-4b1d-7877-80cd-88854e6e7213€9.00€0.19matched
46capture01a199e3-5eca-766a-837a-ab6f9c23eacd€9.00€0.19matched
47capture01a199e3-631a-7901-80eb-8dcd5a52270c€49.00€0.67matched
48capture01a199e3-732c-770a-8f06-8015d0633f3e€35.00€0.50matched
49capture01a199e3-746b-7df1-8844-781605e79328€35.00€0.50matched
50capture01a199e3-736c-77bb-9176-4f2b1a77abbf€15.00€0.26matched
51capture01a199e3-88ba-7650-97e5-bf2ff78d9795€35.00€0.50matched
52capture01a199e3-938b-724a-a773-c530467071f8€15.00€0.26matched
53capture01a199e3-b58c-7f6f-aaa8-54869ad1ad9b€9.00€0.19matched
54capture01a199e3-b615-7254-8bb6-9a4efd20b9dc€15.00€0.26matched
55capture01a199e3-cba9-7924-ac93-f541bf3ae5ce€35.00€0.50matched
56capture01a199e3-ce61-7ed7-a198-38be1fe78a7f€9.00€0.19matched
57capture01a199e3-e2d3-7ff0-9287-2155ea8193ca€24.00€0.37matched
58capture01a199e3-f307-73b6-b078-bcf0673b7ecb€49.00€0.67matched
59capture01a199e4-16bb-72ae-b3bc-e7e9abf4a216€49.00€0.67matched
60capture01a199e4-11c8-78c2-9dc0-9c2514ee5ddc€15.00€0.26matched
61capture01a199e4-1c54-7000-b22d-aeb303ec6cd0€35.00€0.50matched
62capture01a199e4-20e7-7e63-a702-35e26d7ab4fe€49.00€0.67matched
63capture01a199e4-26b5-7123-8345-e020fb58c6ed€15.00€0.26matched
64capture01a199e4-3eae-7dba-a82f-656d3d57a400€9.00€0.19matched
65refund01a199e4-4ba8-7430-881c-c32e87f430f1-€6.00€0.00matched
66capture01a199e4-5484-7ca0-bb7d-f1ba62f7a59a€35.00€0.50matched
67refund01a199e4-57c2-72cf-ac54-d2bfdb9ea6ea-€32.00€0.00matched
68refund01a199e4-5b25-72f8-9823-cbf706d3c4aa-€12.00€0.00matched
69capture01a199e4-5b7f-79b8-8143-eae128904c56€24.00€0.37matched
70capture01a199e4-8b96-78a1-ba14-9d0e2d032bfa€9.00€0.19matched
71capture01a199e4-92ba-7961-98d2-5897afa96c7d€9.00€0.19matched
72refund01a199e4-b677-7db2-b69d-1436847f0e9d-€22.00€0.00matched
73capture01a199e4-db74-79b2-8c77-96e836b3947d€9.00€0.19matched
74capture01a199e5-0c88-7941-b5ab-2e8ed9a6f57a€9.00€0.19matched
75capture01a199e5-0e1f-75cf-a6ae-af9bd8598a14€9.00€0.19matched
76capture01a199e5-12c9-79ef-83ee-692400721b2b€35.00€0.50matched
77capture01a199e5-2e2f-7fd7-b476-ae10b37524e4€9.00€0.19matched
78capture01a199e5-3465-7ffc-8425-ca86b1160bdb€24.00€0.37matched
79capture01a199e5-6245-7336-a85b-814c0288b9cb€35.00€0.50matched
80capture01a199e5-86e0-7d55-899e-5917444e335c€35.00€0.50matched
81capture01a199e5-9d41-7ee5-94ae-da5079a74568€15.00€0.26matched
82capture01a199e5-b19d-72d3-9f8b-57ca667241e1€24.00€0.37matched
83capture01a199e5-be82-7314-bc77-dea7f0952604€49.00€0.67matched
84capture01a199e5-cfe5-7c67-b294-1a01f684076d€24.00€0.37matched
85capture01a199e5-cfec-75cb-bc5d-cf0ab447935e€35.00€0.50matched
86capture01a199e5-e5d1-75e0-9790-4633c160eb52€49.00€0.67matched
87capture01a199e5-eabc-7d05-ba2c-3de9dde77ee2€49.00€0.67matched
88refund01a199e5-f399-7dce-b965-392cb1e4ee22-€30.00€0.00matched
89capture01a199e6-111a-7d03-b51e-bf2256ef574b€24.00€0.37matched
90refund01a199e6-1dca-7fbf-bbdb-b3fcb4ee47d7-€45.00€0.00matched
91capture01a199e6-248a-7d12-a887-fa021645f9c6€35.00€0.50matched
92capture01a199e6-62c0-74e0-ab41-9b51cf845bb0€35.00€0.50matched
94capture01a199e6-9da8-7ecd-aae9-96d85fb427c3€24.00€0.37matched
95capture01a199e6-a642-71a2-a7d2-f5ebf7a74ae8€49.00€0.67matched
96capture01a199e6-b6fa-7498-9047-82bd3b9e0489€15.00€0.26matched
97refund01a199e6-bc4b-7e3d-8a55-4db95366985c-€19.00€0.00matched
98capture01a199e6-be0f-7472-988b-780caa15c724€49.00€0.67matched
99capture01a199e6-cab3-7da9-b644-036eefea6c69€9.00€0.19matched
100capture01a199e6-d0ba-7489-bb41-c57f86285b50€24.00€0.37matched
101capture01a199e6-d2bc-766b-9fcc-43db2e667e97€15.00€0.26matched
102capture01a199e6-edb8-765c-90be-1e7031e6be6f€9.00€0.19matched
103capture01a199e6-f2dc-7947-a235-655a8be48881€49.00€0.67matched
104refund01a199e6-faa7-7147-9aed-3c4a5514bfd1-€24.00€0.00matched
105capture01a199e7-0a3d-76ae-a69f-90f772be951c€49.00€0.67matched
106capture01a199e7-19df-75a3-befc-096b78e0c88b€15.00€0.26matched
107capture01a199e7-5fd8-76cf-bff4-64b390d83fcb€15.00€0.26matched
108capture01a199e7-d075-7184-b1b0-ebae52f8f659€49.00€0.67matched
110capture01a199e7-d6e0-7eb4-b1c4-7ac6e9c74fd2€24.00€0.37matched
111capture01a199e7-d87d-7333-846c-ee49ab66da3e€9.00€0.19matched
112capture01a199e7-dfc9-7935-92d8-9709e528cf4b€15.00€0.26matched
113capture01a199e7-e0dd-766f-a226-5985d570432b€15.00€0.26matched
114capture01a199e7-ee87-7aa3-9ea4-1d8b8140fc69€49.00€0.67matched
115capture01a199e8-0bf8-7dd1-87e5-f3a55db175c3€35.00€0.50matched
116capture01a199e8-1096-71f4-b81f-6a0e46f385b2€24.00€0.37matched
117refund01a199e8-1911-70c9-8c08-ae3a1e96b25f-€49.00€0.00matched
118refund01a199e8-3c7d-7563-badb-23f3210d7e4b-€12.00€0.00matched
119capture01a199e8-6a39-7844-83c1-2a056185c534€35.00€0.50matched
120capture01a199e8-80ca-7348-83f7-6c4373deb6c6€49.00€0.67matched
121capture01a199e8-9cd8-7716-9a7b-83dbf0a17959€35.00€0.50matched
122capture01a199e8-a976-741b-89e7-45cc61ade234€49.00€0.67matched
123capture01a199e8-af84-7097-81b8-1d5801e1cc81€24.00€0.37matched
124capture01a199e8-b8b2-7483-ae93-60c5ef67a8f7€15.00€0.26matched
125capture01a199e8-bd47-73ae-af67-fb8e5c32a9ed€35.00€0.50matched
126capture01a199e8-bd5a-7e09-b2c2-5761979bd77d€49.00€0.67matched
127capture01a199e8-cc50-7fd6-a2be-ced11805f618€49.00€0.67matched
128capture01a199e8-ce97-7e7b-8dad-bce533dbb2e5€49.00€0.67matched
129capture01a199e8-dce9-755e-964f-7e89e175cb21€35.00€0.50matched
130capture01a199e9-030f-7d10-8b6d-9d97fd99acb5€15.00€0.26matched
131capture01a199e9-17c9-7cce-b4f1-82eb9750b1de€15.00€0.26matched
132capture01a199e9-236a-7d59-909c-d91c89bf150a€49.00€0.67matched
133capture01a199e9-25bd-7dcd-8ac6-6d92ee987d57€15.00€0.26matched
134capture01a199e9-31e1-7d9e-9bf3-804ff1da1758€49.00€0.67matched
135capture01a199e9-4c25-7171-adca-8b9d34067b75€9.00€0.19matched
136refund01a199e9-6783-79b7-8799-121f2d8b1e16-€36.00€0.00matched
137capture01a199e9-6f1e-73af-a0bd-01b1e4c8e31e€9.00€0.19matched
138capture01a199e9-71ef-7732-a61f-868688acf18a€35.00€0.50matched
139capture01a199e9-bc89-7468-960e-0301475e893d€24.00€0.37matched
140refund01a199e9-c227-79e8-8077-1b1c7fa88008-€6.00€0.00matched