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

6 Nov, 07:10

Gross

€3,222.00

PSP fee

€51.19

Net to the bank

€3,170.81

Settlement journal

#411938

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1afb4-108a-7dfb-aeae-4c81fa8226b4 is already settled by stl_EUR_2989915 line 49
  • duplicate linethe file lists it twicecapture:01a1afb5-5723-7dd2-b9d9-2badd939c92f is already settled by stl_EUR_2989915 line 60
  • fee differencethe fee is not the contract feethe fee is 4, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
  • missing linein the books, not in the filecapture:01a1afb5-6b0c-73bf-a0c4-a173db8bd70a is in no file
LineKindReferenceGrossFeeStatus
14refund01a1afb2-353f-7536-8818-fb1080fc528b-€10.00€0.04fee difference
50capture01a1afb4-204a-7c53-99cf-2d54e4a0009c€9.00€0.19duplicate line
61capture01a1afb5-5768-7076-81ff-370853c4a60d€24.00€0.37duplicate line
65capture01a1afb5-bd97-7f4d-90a4-d83672963698€35.00€0.52fee difference
70capture01a1afb6-0503-7c7d-a7f5-06bb7ec7c41a€35.00€0.52fee difference
102capture01a1afb8-8bf8-7d16-a11b-5ecc6762225d€15.00€0.27fee difference
1capture01a1afac-71d7-7ea9-8f2d-ec5bb11fc163€15.00€0.26matched
2capture01a1afad-e201-772c-a08b-5dca9c4837b4€24.00€0.37matched
3capture01a1afae-5a48-73dc-aecf-966273a1275d€49.00€0.67matched
4capture01a1afaf-8b4d-71e3-8f9a-5d14e891b551€49.00€0.67matched
5capture01a1afb1-0bcc-79b3-8c08-347a2dce28d1€49.00€0.67matched
6capture01a1afb1-6a10-7c58-80d9-1de8717ef87a€15.00€0.26matched
7refund01a1afb1-800e-7fd2-a46b-726e9431e6b6-€8.00€0.00matched
8capture01a1afb1-8a4a-7c83-beb3-320813e8188d€15.00€0.26matched
9capture01a1afb1-bb7f-72db-9d56-fb75d0957b8b€49.00€0.67matched
10refund01a1afb1-cdca-7ff5-b57b-156a7bcf1d34-€15.00€0.00matched
11capture01a1afb1-dbe9-73d4-b3f5-b59afb38833f€49.00€0.67matched
12capture01a1afb1-e81b-71fd-999c-1377d823ddb2€35.00€0.50matched
13capture01a1afb2-1d5a-7165-ad4c-5f5b97f9c159€24.00€0.37matched
15capture01a1afb2-3d4b-73e5-991b-513bb173755b€15.00€0.26matched
16capture01a1afb2-3edc-73b8-9551-cc52b24ba320€49.00€0.67matched
17capture01a1afb2-4319-7288-b4ed-641c14664041€24.00€0.37matched
18capture01a1afb2-5009-7059-8392-d30122c97239€24.00€0.37matched
19capture01a1afb2-7042-7773-a0a4-4b600e84c06c€9.00€0.19matched
20capture01a1afb2-716c-7d2c-b2fd-37f93ba55328€35.00€0.50matched
21capture01a1afb2-8869-777b-936f-de0a8d6c2a0a€15.00€0.26matched
22capture01a1afb2-9003-76a2-aa3e-45f453cf7fd1€49.00€0.67matched
23capture01a1afb2-a89e-7918-a7b8-c411c83dbd48€15.00€0.26matched
24capture01a1afb2-aac3-793c-89f0-8fdd8e514058€49.00€0.67matched
25capture01a1afb2-b8c8-7fba-a493-cc32a1243d54€35.00€0.50matched
26capture01a1afb2-cb95-703b-b946-991f6feca501€35.00€0.50matched
27capture01a1afb2-cc73-76f8-ac03-bcecf454e21f€24.00€0.37matched
28capture01a1afb2-fb86-7572-9bb8-5b9e40fcc6b6€49.00€0.67matched
29capture01a1afb2-fdf9-7475-bf49-1746454c61a1€15.00€0.26matched
30capture01a1afb3-0409-7421-a2fe-08fb5573d964€35.00€0.50matched
31capture01a1afb3-3870-7dae-9c86-b78b2a8ff0cc€9.00€0.19matched
32capture01a1afb3-3cc5-7f85-bddc-160ecb46ab0f€35.00€0.50matched
33capture01a1afb3-4169-7417-9cf8-fa6e142bb92b€24.00€0.37matched
34capture01a1afb3-4a0c-7a85-ae66-370ba00bd354€35.00€0.50matched
35capture01a1afb3-4c3f-72d7-bf0d-e25e3d62b250€35.00€0.50matched
36capture01a1afb3-5385-753e-bf91-f6170de62090€24.00€0.37matched
37refund01a1afb3-6342-7ce0-94ba-c2d88ca6784a-€22.00€0.00matched
38capture01a1afb3-6fa5-7728-be9a-6ce6446fcf1c€9.00€0.19matched
39capture01a1afb3-76d6-7b94-8dd9-ba8f5ee34a23€15.00€0.26matched
40capture01a1afb3-7b93-7542-befe-6c7b1c9bd2d2€15.00€0.26matched
41capture01a1afb3-8330-7532-985a-c97f07f1f5b6€24.00€0.37matched
42capture01a1afb3-9230-702b-9dd2-59a9fcc3f18a€49.00€0.67matched
43capture01a1afb3-cac4-7521-b7fd-ecf7561b6a44€9.00€0.19matched
44capture01a1afb3-e590-70b3-b818-7bb4cbdda141€15.00€0.26matched
45capture01a1afb3-f7aa-7654-8368-bbe0b672666c€35.00€0.50matched
46capture01a1afb4-0444-70de-a590-3886a4eb0fd9€24.00€0.37matched
47capture01a1afb4-1975-78b6-a1e0-cc692eb3d24b€49.00€0.67matched
48capture01a1afb4-1a62-7522-9142-17b557e3fca0€35.00€0.50matched
49capture01a1afb4-204a-7c53-99cf-2d54e4a0009c€9.00€0.19matched
51capture01a1afb4-4403-7378-8436-9172f153f0cf€15.00€0.26matched
52capture01a1afb4-651d-7578-9cef-2cad9e300c41€49.00€0.67matched
53refund01a1afb4-6d86-7952-9a0e-21adf213b298-€9.00€0.00matched
54capture01a1afb4-aea0-72d9-a24d-6c884acf9471€15.00€0.26matched
55capture01a1afb4-c1bd-762b-b141-f992c0576c43€35.00€0.50matched
56capture01a1afb4-cd40-7bce-a863-ef58b3ef4153€9.00€0.19matched
57capture01a1afb4-d360-72c6-9562-85a239af7663€35.00€0.50matched
58capture01a1afb4-fcda-7f86-99bb-af8efc64ff05€49.00€0.67matched
59capture01a1afb5-55d7-7198-86c1-f77b17a84292€35.00€0.50matched
60capture01a1afb5-5768-7076-81ff-370853c4a60d€24.00€0.37matched
62capture01a1afb5-66fe-7d6f-b8ef-d583944fb00f€49.00€0.67matched
63capture01a1afb5-7951-783d-8203-265258991845€15.00€0.26matched
64capture01a1afb5-93dc-748f-b0e2-52a2a848f8d6€9.00€0.19matched
66capture01a1afb5-d2ce-767d-b76c-01415982209c€24.00€0.37matched
67capture01a1afb5-dd06-7664-a1ec-336b8937bec2€24.00€0.37matched
68capture01a1afb5-f797-7566-ba94-957f5acbbb1b€49.00€0.67matched
69capture01a1afb5-fe06-7998-b4d4-0dfdadf26d1d€35.00€0.50matched
71refund01a1afb6-3424-734d-8490-7b1ebabc9fed-€22.00€0.00matched
72capture01a1afb6-3bd4-7e59-b7ef-da347664d072€35.00€0.50matched
73refund01a1afb6-5917-7136-bbbf-cdf2396b3c4a-€31.00€0.00matched
74capture01a1afb6-6a1d-769c-b438-9d3bf8cdf8b7€9.00€0.19matched
75capture01a1afb6-8008-71a7-88b6-f69b21a51f5e€35.00€0.50matched
76capture01a1afb6-a0af-79a2-89fa-475f4f45cba9€35.00€0.50matched
77capture01a1afb6-dcf7-731c-b65e-84dfcc04253a€49.00€0.67matched
78capture01a1afb6-e287-726f-8320-b1b44cb72a3e€24.00€0.37matched
79capture01a1afb6-e918-741c-a105-80fbc57c46a1€15.00€0.26matched
80capture01a1afb7-29cc-7e33-b1ba-3d845a857666€9.00€0.19matched
81capture01a1afb7-34a5-72eb-9d65-8c0b197858c1€35.00€0.50matched
82capture01a1afb7-5c57-71f9-ac53-dada9399f099€35.00€0.50matched
83capture01a1afb7-75fd-74c3-ab66-7269c11d174f€9.00€0.19matched
84capture01a1afb7-77ed-74eb-a544-226f59cf6928€24.00€0.37matched
85capture01a1afb7-8295-7ded-9d95-a5a8f8d02c72€49.00€0.67matched
86capture01a1afb7-8fbd-724c-89bc-00dee3a1e751€9.00€0.19matched
87refund01a1afb7-a2c8-7de1-90af-4165c1ab42d1-€22.00€0.00matched
88capture01a1afb7-a2e7-7e94-bfa7-401ddeb43cdf€49.00€0.67matched
89capture01a1afb7-b4d4-7e9d-9d27-c112bb804f0b€35.00€0.50matched
90capture01a1afb7-b4e3-778d-a0fb-696285e3dc98€9.00€0.19matched
91capture01a1afb7-c0e1-74e1-8ab4-0b90d18447e2€35.00€0.50matched
92refund01a1afb7-d4c5-7822-9604-8c49ba8e286e-€26.00€0.00matched
93capture01a1afb7-d6a5-72cc-88c9-c897df6b2063€15.00€0.26matched
94capture01a1afb7-f130-78e3-b01f-4f2c0a34cbad€24.00€0.37matched
95refund01a1afb8-0b9c-7bd5-bfc3-d88d79ad9e52-€8.00€0.00matched
96capture01a1afb8-1315-7008-bb4f-1b446b16e50d€35.00€0.50matched
97capture01a1afb8-1105-7cb4-9693-b85f936aafe1€9.00€0.19matched
98capture01a1afb8-2ae5-7d2d-b805-1c50cb11bc5d€35.00€0.50matched
99capture01a1afb8-6762-76f7-b605-07817de8e139€15.00€0.26matched
100capture01a1afb8-6e06-7404-84f9-c647e6802264€9.00€0.19matched
101capture01a1afb8-87bf-7da6-88b3-78b1ec5715ed€35.00€0.50matched
103refund01a1afb8-9618-7b57-933e-2047bcc9d2bc-€14.00€0.00matched
104capture01a1afb8-b292-76ec-a26b-b592eb7bea49€15.00€0.26matched
105capture01a1afb8-b37d-7e58-af6c-ae31a7be860f€35.00€0.50matched
106capture01a1afb8-ceed-7789-8096-cca874d86bb9€24.00€0.37matched
107capture01a1afb8-d9f6-73ed-9d23-3b37ed498f07€15.00€0.26matched
108capture01a1afb8-ddd4-7446-af36-0f9c97bf5146€9.00€0.19matched
109capture01a1afb8-e7cf-7c8b-94d7-2c338743bcbd€15.00€0.26matched
110capture01a1afb9-26cf-7fa9-9340-e2fe49136e15€49.00€0.67matched
111capture01a1afb9-2d8b-7b5d-9cef-4621997954ba€35.00€0.50matched
112capture01a1afb9-3946-7bf7-9e71-ebf62399eede€24.00€0.37matched
113capture01a1afb9-5561-7abc-b963-4fc26c7dff6b€49.00€0.67matched
114capture01a1afb9-6bb8-707b-ab0c-09af64f4b1fa€35.00€0.50matched
115capture01a1afb9-792c-7853-a61b-6c8cd3459d62€49.00€0.67matched
116capture01a1afb9-79df-7f15-9baf-abaf31162014€9.00€0.19matched
117capture01a1afb9-81ee-7b9e-afdf-32ddf55ea68b€24.00€0.37matched
118capture01a1afb9-8c37-73e6-89de-aa3a856688bc€24.00€0.37matched
119refund01a1afb9-91db-700d-bd4b-3f4593bbfa48-€14.00€0.00matched
120capture01a1afb9-9d87-7977-8013-5dc6381ad675€9.00€0.19matched
121capture01a1afb9-b251-7dee-9f14-3f5fa0916e66€9.00€0.19matched
122capture01a1afb9-c440-7fd8-9577-04fe1ac229e4€35.00€0.50matched
123capture01a1afb9-c137-74e1-b6a3-7b2875cb1766€49.00€0.67matched
124refund01a1afb9-cd17-7242-af5c-f5b4c33d2fff-€4.00€0.00matched
125capture01a1afb9-ceb9-7d47-b8fa-c7c6f08f3ee5€9.00€0.19matched
126capture01a1afb9-ddb1-7fe7-a66a-1031a1335e8c€24.00€0.37matched
127capture01a1afb9-e461-73c5-981f-64c22f98680b€49.00€0.67matched
128capture01a1afb9-f8ec-756c-846b-766333dabf35€24.00€0.37matched
129capture01a1afb9-f8ff-7e84-b4dd-420198e912e9€49.00€0.67matched
130capture01a1afb9-ffe4-7594-9fb9-fb4d0b7f6712€49.00€0.67matched
131capture01a1afba-195f-7ee0-889c-6715968f693f€9.00€0.19matched
132capture01a1afba-384f-7495-8506-f594d3905596€35.00€0.50matched
133capture01a1afba-3e32-7ce1-bdc8-408fa76ebc78€15.00€0.26matched
134capture01a1afba-4fc3-778c-91a8-7cd15a1f3fed€35.00€0.50matched
135capture01a1afba-5095-773b-8cb6-8680a50e836c€15.00€0.26matched
136capture01a1afba-69b7-74f7-86da-29e3848df16f€35.00€0.50matched