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

Gross

€3,279.00

PSP fee

€50.72

Net to the bank

€3,228.28

Settlement journal

#356494

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • missing linein the books, not in the filecapture:01a1a014-b4dd-7c7b-8296-900efe214882 is in no file
LineKindReferenceGrossFeeStatus
28capture01a1a012-27ec-73f3-adaa-10257696fb80€35.00€0.53fee difference
93capture01a1a017-1f16-7e03-b219-d5a9c77924ff€9.00€0.24fee difference
1capture01a1a00a-851f-7bc1-aa05-a2c53d025fdf€35.00€0.50matched
2capture01a1a00e-a891-7208-b269-c224f7b7e30e€49.00€0.67matched
3capture01a1a010-0224-7303-a5c1-d0a9ffb7b501€15.00€0.26matched
4capture01a1a010-86ea-7f0c-b056-41b8558634c9€15.00€0.26matched
5capture01a1a010-8d90-79f4-8193-5e47bae4e324€49.00€0.67matched
6capture01a1a010-a74a-7f83-b6c0-2b9b78d2e67c€35.00€0.50matched
7capture01a1a010-ac14-768a-8058-69a587ce7362€9.00€0.19matched
8capture01a1a010-e116-784a-899c-f3624761a3fc€35.00€0.50matched
9refund01a1a010-ef7c-7e2d-82d5-ef239eb7d1e4-€18.00€0.00matched
10capture01a1a010-f7e5-7f4c-b842-de3b514f4529€49.00€0.67matched
11capture01a1a011-0ab4-79fa-adea-a26b7f91fd1c€9.00€0.19matched
12capture01a1a011-17ca-70fd-aa0f-b52bba3f2fb0€24.00€0.37matched
13capture01a1a011-245f-799b-87b2-918e254fbe73€35.00€0.50matched
14capture01a1a011-41b7-7a26-942c-50c183e29122€9.00€0.19matched
15capture01a1a011-67c4-704a-9320-41ec92c60725€9.00€0.19matched
16capture01a1a011-7633-7c6c-9ba6-e5fde1ffc2f6€9.00€0.19matched
17capture01a1a011-7e78-7835-b372-9b8a32501a03€49.00€0.67matched
18capture01a1a011-8890-7165-9f14-da0e55b512fb€24.00€0.37matched
19capture01a1a011-ab8f-7d0c-837b-eb4296b6b046€35.00€0.50matched
20capture01a1a011-af69-7357-8515-2766df031d66€9.00€0.19matched
21capture01a1a011-c085-7990-a1b7-447b9c444431€15.00€0.26matched
22capture01a1a011-c6e3-789a-ae63-a474594e13a6€24.00€0.37matched
23capture01a1a011-d486-7eb6-a17f-b94ff3d0e86f€15.00€0.26matched
24capture01a1a011-e3b7-796a-add5-4e9a940f9e0d€35.00€0.50matched
25capture01a1a011-f8ed-7404-b966-600b49315294€9.00€0.19matched
26capture01a1a012-02d5-74fe-9169-cd9d63d00a50€24.00€0.37matched
27capture01a1a012-0eeb-7c57-972c-d7c9ab50a322€15.00€0.26matched
29capture01a1a012-30c2-73b8-8100-57cc73aacd8b€15.00€0.26matched
30capture01a1a012-4097-776e-bd9d-1086eef72c1e€24.00€0.37matched
31capture01a1a012-634d-7674-83e8-9b062583b46e€24.00€0.37matched
32capture01a1a012-7348-7246-857e-9558adb95371€24.00€0.37matched
33capture01a1a012-7517-7b72-9718-276fc6023e10€15.00€0.26matched
34refund01a1a012-7987-7e05-9645-c06dfc081c9a-€9.00€0.00matched
35capture01a1a012-7d84-7f83-9da6-d307f2a0517c€35.00€0.50matched
36capture01a1a012-8301-7697-b2de-11bf9e9c0a89€35.00€0.50matched
37capture01a1a012-99f7-722f-81b1-9d52904ff9ec€9.00€0.19matched
38capture01a1a012-aa57-737a-ab78-a76912abf150€15.00€0.26matched
39capture01a1a012-c77b-7abb-861b-6bd7e8197344€49.00€0.67matched
40refund01a1a012-e2be-7503-ab24-8c0f583f7562-€20.00€0.00matched
41capture01a1a012-f930-7a59-b5ea-13665c92b011€35.00€0.50matched
42capture01a1a013-007f-73e0-bd77-14f1e2c05a4a€49.00€0.67matched
43capture01a1a013-17d0-76bf-bc05-f3a0f26aba06€35.00€0.50matched
44capture01a1a013-21cc-71b0-a561-e57341d6de7e€24.00€0.37matched
45capture01a1a013-56eb-70f4-8a4a-13eb87fe2b35€49.00€0.67matched
46capture01a1a013-5888-7815-a072-aa8ab20beaec€49.00€0.67matched
47capture01a1a013-73d9-7d7a-9ade-3112b22c3c6e€15.00€0.26matched
48capture01a1a013-7e6c-73fe-a7e2-232e66d3c485€35.00€0.50matched
49capture01a1a013-bc7e-7df6-b30c-903f599e44aa€35.00€0.50matched
50capture01a1a013-bf2f-757f-b376-ca32c963cf83€35.00€0.50matched
51capture01a1a013-c28a-72a1-a473-d52fadd50bba€49.00€0.67matched
52capture01a1a013-d53c-7634-a2fd-07ef1a3bd936€15.00€0.26matched
53capture01a1a013-f12c-7ab0-ac66-750f078399d5€24.00€0.37matched
54capture01a1a013-f8a5-74bd-bd85-34b84e52b51c€49.00€0.67matched
55capture01a1a014-0c82-74bb-a5db-c6170a105a32€49.00€0.67matched
56capture01a1a014-1add-75f1-9759-87353e28db1b€15.00€0.26matched
57refund01a1a014-3d34-7a87-a9fd-2376c11bbe86-€22.00€0.00matched
58capture01a1a014-445b-701c-af72-d2e199690070€24.00€0.37matched
59capture01a1a014-58b8-70ba-a604-aa2e2a5fca0f€49.00€0.67matched
60capture01a1a014-9866-7589-a403-76208ba3c6d1€24.00€0.37matched
61capture01a1a014-d8ac-7023-b1aa-1449d57fbaa6€49.00€0.67matched
62refund01a1a014-f935-757d-9555-3fb101fd938b-€23.00€0.00matched
63capture01a1a015-3c82-71c4-bc78-9d88e25d6457€35.00€0.50matched
64capture01a1a015-3ed6-7d50-b69a-cc2090e4b18d€15.00€0.26matched
65capture01a1a015-5b92-7276-a163-3176797415fe€35.00€0.50matched
66capture01a1a015-5b91-7c2b-8935-340e16a21b0e€15.00€0.26matched
67capture01a1a015-6478-75a8-a677-8ffc86e17cf6€49.00€0.67matched
68capture01a1a015-64de-7666-aa4e-20b020a93ec1€24.00€0.37matched
69capture01a1a015-a1c0-7eef-9400-64db1e17a670€9.00€0.19matched
70capture01a1a015-a770-7a5d-9ca6-0662fe3a2553€15.00€0.26matched
71capture01a1a015-b00f-75ea-8265-1c520407ecbc€15.00€0.26matched
72capture01a1a015-c41f-74e7-931b-9029c83b95a4€9.00€0.19matched
73capture01a1a015-c4ec-71e0-a418-f5c354d4305e€15.00€0.26matched
74capture01a1a015-e654-7c25-b618-774cc7522926€35.00€0.50matched
75capture01a1a015-e92a-7b27-aab3-646b0a6849c2€49.00€0.67matched
76capture01a1a015-eb91-707d-b0f0-884b5b32127a€49.00€0.67matched
77capture01a1a015-fd99-72a5-954e-5bf1445298b1€15.00€0.26matched
78capture01a1a016-096a-7797-ae9f-4d028f77559c€24.00€0.37matched
79capture01a1a016-2159-714d-83b4-f9338e57e5e3€9.00€0.19matched
80capture01a1a016-3be7-7a84-8770-a587526b9d66€49.00€0.67matched
81capture01a1a016-5f56-77c7-9f75-3fe39b790be2€24.00€0.37matched
82capture01a1a016-7ced-73fa-85f1-49c4b4f220d7€9.00€0.19matched
83capture01a1a016-95a4-790d-8dcb-04dc31cc39f3€9.00€0.19matched
84capture01a1a016-9a0b-7e04-a102-81afe08c3c17€9.00€0.19matched
85capture01a1a016-a53b-7f96-8ddf-e322dab0c394€15.00€0.26matched
86capture01a1a016-ac7e-7485-afd2-93ab40a8aa62€9.00€0.19matched
87capture01a1a016-ad2d-7ee2-94f6-4b2fab8985d5€9.00€0.19matched
88capture01a1a016-b3f4-7b8c-89a1-b476dd255eac€35.00€0.50matched
89capture01a1a016-c1c9-7a81-beb5-2a7c30b537e1€9.00€0.19matched
90capture01a1a016-e907-7dd2-be99-040022a62caa€9.00€0.19matched
91capture01a1a016-e9e5-70af-abc4-40476a89107b€9.00€0.19matched
92capture01a1a017-105d-78c0-b88f-ed6171da32f9€24.00€0.37matched
94capture01a1a017-237e-7773-bc7f-0759ca37bd8a€35.00€0.50matched
95capture01a1a017-3f30-793d-be45-97f485f6a680€35.00€0.50matched
96capture01a1a017-6b74-702b-88dd-d91560f36056€35.00€0.50matched
97capture01a1a017-78cc-76cd-93eb-4266be9c6f2d€49.00€0.67matched
98capture01a1a017-84e2-7e44-a2ad-c1df8187a1e0€35.00€0.50matched
99capture01a1a017-9a4b-7e90-9ce3-12b58a52587a€9.00€0.19matched
100capture01a1a017-d106-7df3-a86e-be9945d02bdd€49.00€0.67matched
101capture01a1a017-d9d7-745f-8c8e-500b28741098€49.00€0.67matched
102capture01a1a017-e4b7-7050-abf1-65c957c6dda8€15.00€0.26matched
103capture01a1a018-0153-736b-bb0a-315f00cf18df€49.00€0.67matched
104capture01a1a018-14de-747f-b1f4-a8471e089889€9.00€0.19matched
105capture01a1a018-1709-72fe-816f-f62e14c5a3a8€24.00€0.37matched
106capture01a1a018-1841-7597-912b-d1b49317e866€35.00€0.50matched
107capture01a1a018-196d-737e-80c7-8e920b862b49€49.00€0.67matched
108capture01a1a018-1e8b-757c-bfe6-07a629bacc12€24.00€0.37matched
109capture01a1a018-1fc4-76ed-85a9-a6fbc4a265ba€9.00€0.19matched
110capture01a1a018-2c68-7748-8756-85d0745f7d80€35.00€0.50matched
111capture01a1a018-2d95-758a-8fa4-254fe93248cd€49.00€0.67matched
112capture01a1a018-2f3a-70ee-bd3c-67cb253b4109€49.00€0.67matched
113capture01a1a018-454c-76c2-8695-ceb557466e6c€9.00€0.19matched
114capture01a1a018-4573-7d0f-806a-7cf9adb137cf€15.00€0.26matched
115capture01a1a018-5208-7eff-83bf-477e06a63a1b€9.00€0.19matched
116capture01a1a018-65fd-7a5b-8515-a1d4b9dbc64b€35.00€0.50matched
117capture01a1a018-7766-764f-9d94-cbfc205bcf56€49.00€0.67matched
118capture01a1a018-8da6-7a7f-94fb-b1d60831c837€49.00€0.67matched
119capture01a1a018-c399-76ef-87fb-a2baa9e07ab8€24.00€0.37matched
120capture01a1a018-f71e-7911-9573-08aff9ae3cf8€9.00€0.19matched
121capture01a1a019-020f-78b8-abb4-c607cc3479a8€24.00€0.37matched
122capture01a1a019-0b3a-78f6-a93b-0379f021b916€24.00€0.37matched
123capture01a1a019-2c43-7e25-a5e1-e9e7bfa5501a€35.00€0.50matched
124capture01a1a019-2c63-7cfc-9353-3a74cb53db2b€9.00€0.19matched
125capture01a1a019-45b2-774f-b356-655d6ef569fe€9.00€0.19matched
126capture01a1a019-4b2e-7e5d-b80b-5741341dd606€35.00€0.50matched
127refund01a1a019-50fc-73b4-ac04-6cd897aa7eff-€3.00€0.00matched
128capture01a1a019-693e-7db1-834a-1288491c0a57€15.00€0.26matched
129capture01a1a019-91a1-7cfb-a316-55e3da2ea670€24.00€0.37matched
130capture01a1a019-9ba1-757f-b369-a5c96e9a093b€49.00€0.67matched
131capture01a1a019-a479-7783-9407-0658df76a8d6€35.00€0.50matched