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

Gross

€2,559.00

PSP fee

€41.93

Net to the bank

€2,517.07

Settlement journal

#344391

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19cb2-7284-7110-b2e7-ef3038828fee is already settled by stl_EUR_2989383 line 104
  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • missing linein the books, not in the filecapture:01a19caf-1596-78cf-b92a-d8796c4e16b3 is in no file
  • missing linein the books, not in the filecapture:01a19cb0-12ae-7b97-8f4b-57f9864c96e9 is in no file
  • missing linein the books, not in the filecapture:01a19cb2-a3fc-7dfb-9e1f-643175937201 is in no file
  • missing linein the books, not in the filecapture:01a19cb2-fbdf-763e-aae2-09cbbceaeb6e is in no file
  • missing linein the books, not in the filecapture:01a19cb3-0db7-78bb-b251-c55b4bbfc8b3 is in no file
LineKindReferenceGrossFeeStatus
33capture01a19cad-1360-7507-9b76-c0c54932d2f6€49.00€0.69fee difference
85capture01a19cb1-0bba-71aa-9226-07ca6029aaa0€35.00€0.53fee difference
105capture01a19cb2-72cd-739b-aa47-063d4bd650fc€9.00€0.19duplicate line
1capture01a19caa-dade-769e-9bd1-9ddb44da3c80€15.00€0.26matched
2capture01a19caa-ddf4-74cf-9e56-aea023936e0f€35.00€0.50matched
3capture01a19caa-e8b2-7f32-89a8-64346730f6c1€9.00€0.19matched
4capture01a19cab-00ab-7ba7-803e-9b6c2567dec1€9.00€0.19matched
5capture01a19cab-15b2-7a00-9281-cd16b727cf3d€24.00€0.37matched
6capture01a19cab-2129-78d6-b2bb-614323e23a9b€9.00€0.19matched
7refund01a19cab-2ffa-7838-a7fc-3f9367517849-€7.00€0.00matched
8capture01a19cab-4826-7cb9-bbd5-620fe63ed666€9.00€0.19matched
9capture01a19cab-5beb-766a-905e-2194bfb3d3af€15.00€0.26matched
10capture01a19cab-6242-7e04-ac02-17435a9affd2€35.00€0.50matched
11capture01a19cab-6bbb-7969-8898-f4db1e08ef3a€24.00€0.37matched
12capture01a19cab-7705-7504-a850-fb70d0d6f900€15.00€0.26matched
13capture01a19cab-7e60-7002-8b30-57c016a25095€15.00€0.26matched
14capture01a19cab-86ea-723b-a2cb-d85a3f623fb4€49.00€0.67matched
15capture01a19cab-8b27-789a-ac7b-c6082135c442€15.00€0.26matched
16capture01a19cab-8fec-73de-953b-2b4f96510f03€9.00€0.19matched
17capture01a19cab-bd97-7237-9b5f-610506763a2a€15.00€0.26matched
18refund01a19cab-bfa3-7dc0-9e24-13996e3a6e96-€30.00€0.00matched
19refund01a19cab-fd34-7eaf-8ad8-924ff33a0db8-€2.00€0.00matched
20capture01a19cac-0058-7c80-ad1a-0753edd86f08€49.00€0.67matched
21capture01a19cac-12fd-74c3-93e6-aa5f4c459e92€15.00€0.26matched
22capture01a19cac-170a-7ec5-aab4-5f894fb719a3€9.00€0.19matched
23capture01a19cac-30db-716a-884f-182520a21300€24.00€0.37matched
24capture01a19cac-46be-7b8f-8ce0-ee7c523b1214€24.00€0.37matched
25refund01a19cac-6082-7514-bd49-8f6cd6784f9f-€11.00€0.00matched
26refund01a19cac-68c9-747c-9642-810db585bcb4-€26.00€0.00matched
27capture01a19cac-6a3b-7109-a5ad-0dc7f518be27€35.00€0.50matched
28capture01a19cac-7718-741d-b782-bd9ab79fcc88€15.00€0.26matched
29capture01a19cac-8c95-7d45-ae31-3aa7f983f21d€35.00€0.50matched
30capture01a19cac-958c-7548-b947-4be3e99d5a29€35.00€0.50matched
31capture01a19cac-9bbc-7591-932a-33738230a11a€15.00€0.26matched
32capture01a19cac-bbee-7c07-b552-458a8504db0b€15.00€0.26matched
34capture01a19cad-8801-76bd-bbb6-bef71833728d€9.00€0.19matched
35capture01a19cad-8846-75c3-8e4b-750084e335c1€9.00€0.19matched
36capture01a19cad-87ec-7152-90db-510505e22995€9.00€0.19matched
37capture01a19cad-9617-76e3-abfa-e897ed43c2c1€9.00€0.19matched
38capture01a19cad-b99a-70aa-b135-aa1183f27113€15.00€0.26matched
39capture01a19cad-cb31-7e00-bd86-006c212911d9€49.00€0.67matched
40capture01a19cad-e685-79f5-ac12-68c3d378bdb5€15.00€0.26matched
41capture01a19cae-01b0-70ea-b394-154c6ae691a0€15.00€0.26matched
42capture01a19cae-0749-7ab7-abb9-54df62d7fa71€24.00€0.37matched
43refund01a19cad-ff80-72fc-9d64-4d0e8f98abca-€7.00€0.00matched
44capture01a19cae-19cd-725f-bcb0-d993edfcd488€9.00€0.19matched
45capture01a19cae-1834-7ef6-bc05-2e7532755206€35.00€0.50matched
46capture01a19cae-3979-7972-a686-baeca66323e0€15.00€0.26matched
47refund01a19cae-546d-7484-a77c-6ccbbb2306da-€4.00€0.00matched
48capture01a19cae-61f5-780f-98d7-2a52c22b9009€9.00€0.19matched
49capture01a19cae-6888-7cf2-b17b-a92b94e21b01€9.00€0.19matched
50capture01a19cae-6b9e-7e21-a0e5-533d2629c792€24.00€0.37matched
51capture01a19cae-682e-7720-b252-eab6e7dc9c33€35.00€0.50matched
52capture01a19cae-97c5-73dc-9c77-40712578772b€35.00€0.50matched
53capture01a19cae-9ddc-735c-bf4a-ad4580f354ba€24.00€0.37matched
54capture01a19cae-cc34-7252-bd6e-41ccda3aaa42€9.00€0.19matched
55capture01a19cae-cfff-7429-bef6-661721d351c6€49.00€0.67matched
56capture01a19cae-d766-7dfd-acc1-dc041e275c4e€9.00€0.19matched
57capture01a19cae-dab5-7e14-a6d2-c6b38c982542€15.00€0.26matched
58capture01a19cae-e82e-7e7e-b5e9-8eb4b94e2f99€49.00€0.67matched
59capture01a19cae-ee4a-7f9c-b331-b25e4024cda8€35.00€0.50matched
60capture01a19cae-fd47-76af-8517-bf51065a990a€24.00€0.37matched
61refund01a19caf-3bf6-7791-ad4f-fb20d1662b90-€6.00€0.00matched
62capture01a19caf-4f90-708e-85fa-8c25a2087d03€49.00€0.67matched
63capture01a19caf-744c-71a7-b3ff-6be9f055dc6a€49.00€0.67matched
64capture01a19caf-75af-739f-85c8-b71738316a98€15.00€0.26matched
65capture01a19caf-adbc-7d74-a06f-7366a0e71742€24.00€0.37matched
66capture01a19caf-b659-70cc-a186-4eddb6ac99b4€49.00€0.67matched
67capture01a19caf-d07e-7121-9393-c0a19991386d€35.00€0.50matched
68capture01a19caf-e034-7223-939c-f7b6e74140fa€24.00€0.37matched
69capture01a19caf-eed7-7225-8af3-3ea7ed6c5cda€15.00€0.26matched
70capture01a19cb0-0957-7b49-a206-5ac9b385568f€15.00€0.26matched
71capture01a19cb0-0d57-73e0-a785-dc1f154d77fb€49.00€0.67matched
72capture01a19cb0-2022-7e8b-b84c-dc439d56ee8d€24.00€0.37matched
73capture01a19cb0-2bbb-7636-a559-cca6681974ba€24.00€0.37matched
74capture01a19cb0-3830-75a0-bc53-863b476a20a7€9.00€0.19matched
75capture01a19cb0-5ff9-7779-81f8-c75da04eaa76€15.00€0.26matched
76capture01a19cb0-7d6b-7ac0-b9a0-f5176a065b02€49.00€0.67matched
77capture01a19cb0-9241-7cc8-87cd-de248545c908€49.00€0.67matched
78capture01a19cb0-b358-734f-bc57-58177f9887cb€24.00€0.37matched
79capture01a19cb0-cb89-7d6b-8f90-d9b840ca95d1€9.00€0.19matched
80capture01a19cb0-dce9-73c9-b780-f0c94fa7bf05€9.00€0.19matched
81capture01a19cb0-ed7d-76f1-b37c-1ffddd1ddf5a€35.00€0.50matched
82capture01a19cb0-f58f-7f66-aac9-d54b24c37652€24.00€0.37matched
83capture01a19cb1-01e4-717b-977f-8d66fdb486ef€9.00€0.19matched
84capture01a19cb1-02bc-7c31-954b-05e15fe0a298€49.00€0.67matched
86capture01a19cb1-0ec6-77c9-888b-e1e4cb5a407e€24.00€0.37matched
87capture01a19cb1-1864-7139-a65d-f4a33bb158c7€49.00€0.67matched
88refund01a19cb1-3c36-76e7-97fa-34b49a973781-€3.00€0.00matched
89capture01a19cb1-4627-747f-bcbb-c4555e1f61dd€15.00€0.26matched
90capture01a19cb1-6362-7cb0-a4d6-bcb054d1a426€35.00€0.50matched
91capture01a19cb1-776f-76a3-9714-58803d3a9d5e€15.00€0.26matched
92capture01a19cb1-7bb9-7f0e-8022-1e744ab683a5€15.00€0.26matched
93capture01a19cb1-a1e1-7001-ac21-e9c3a053783b€24.00€0.37matched
94capture01a19cb1-b55e-74ee-90d2-21d520f5d49a€15.00€0.26matched
95capture01a19cb1-df21-77b8-bd72-fedbb9c9a01e€15.00€0.26matched
96capture01a19cb2-000d-7c5e-ad3b-aa9738cfd468€49.00€0.67matched
97capture01a19cb2-369a-7aa2-a677-645db7a94de6€24.00€0.37matched
98refund01a19cb2-45b7-71aa-be34-fc0c7cd258aa-€29.00€0.00matched
99capture01a19cb2-4bd4-7c91-a69c-3473801f6d6d€9.00€0.19matched
100capture01a19cb2-6152-726a-984f-8c82ea7c96d1€35.00€0.50matched
101capture01a19cb2-6673-7c69-a563-4520c201aa2b€24.00€0.37matched
102capture01a19cb2-6a40-7d2e-a87b-507a29f7bb4f€49.00€0.67matched
103capture01a19cb2-72cb-7fa9-879f-3db69ff3fcdb€24.00€0.37matched
104capture01a19cb2-72cd-739b-aa47-063d4bd650fc€9.00€0.19matched
106capture01a19cb2-a134-79aa-bb8e-370b42195d8d€15.00€0.26matched
107capture01a19cb2-a6b1-7961-bc68-6311c2cc2ede€49.00€0.67matched
108refund01a19cb2-af11-72f0-97f4-f97acda9ccf9-€4.00€0.00matched
109capture01a19cb2-c83e-7d72-b860-b3721f0c0f25€24.00€0.37matched
110capture01a19cb2-e258-7a8f-b9b2-357c08738d0b€15.00€0.26matched
111refund01a19cb2-e8a0-70a8-ab41-138655fe50d9-€37.00€0.00matched
112capture01a19cb2-fbc2-73c1-908c-db12e1cc1c25€24.00€0.37matched
113capture01a19cb3-1b04-7ebe-9c7e-b6c80f5e92a4€49.00€0.67matched
114capture01a19cb3-1c0b-72b6-a9ec-f85946719c75€15.00€0.26matched
115capture01a19cb3-22c5-7309-9fa2-0f0cfc493303€9.00€0.19matched
116refund01a19cb3-2624-7b84-9e8f-fdf1fb4cb89f-€14.00€0.00matched
117capture01a19cb3-6681-7225-8c65-d5d2b0dc9bcf€35.00€0.50matched
118capture01a19cb3-7cc4-7feb-ba24-cb23ce47e0d4€24.00€0.37matched
119capture01a19cb3-84d5-7104-9939-90c26577ee3f€49.00€0.67matched
120capture01a19cb3-9e94-70ca-ba62-ab6c65924ec9€15.00€0.26matched
121capture01a19cb3-a815-7760-a483-8689c1a3460f€15.00€0.26matched
122capture01a19cb3-c7c4-73ef-95d7-1dcfc861d33b€49.00€0.67matched
123capture01a19cb3-d74a-72db-aeff-838d14f7050d€49.00€0.67matched
124capture01a19cb3-e060-780d-9868-b4eb84983c35€15.00€0.26matched