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

Gross

€2,969.00

PSP fee

€46.73

Net to the bank

€2,922.27

Settlement journal

#407405

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • missing linein the books, not in the filecapture:01a1ae7a-016a-70b6-b58c-f4029cc4930e is in no file
LineKindReferenceGrossFeeStatus
9capture01a1ae71-de6b-72f2-a9c2-71764e257329€49.00€0.70fee difference
80capture01a1ae77-14cf-7d4f-93d2-5d37fdfeed2d€9.00€0.23fee difference
117capture01a1ae79-5a6d-730e-8503-c9b159bf1c81€9.00€0.23fee difference
1capture01a1ae69-0184-7c99-8b35-b0eb600713eb€49.00€0.67matched
2capture01a1ae6c-4686-7392-a094-b7b22f182277€24.00€0.37matched
3capture01a1ae6c-f1d7-7b65-b39d-6b024e9d5b90€9.00€0.19matched
4capture01a1ae6f-c048-754d-91c1-72e50aa28326€9.00€0.19matched
5capture01a1ae71-76e7-7ab6-b557-e87ffbbb4b72€15.00€0.26matched
6capture01a1ae71-a5dd-7108-8255-dd8279aea479€9.00€0.19matched
7capture01a1ae71-a7de-7872-abf7-1d2d5d6d9971€9.00€0.19matched
8capture01a1ae71-c9b8-78b2-9a1a-8f534f2b6508€24.00€0.37matched
10capture01a1ae71-e16c-735d-b3d4-0581d007d3b9€9.00€0.19matched
11refund01a1ae72-1115-7edc-aa4a-0cc3fe25ae18-€6.00€0.00matched
12capture01a1ae72-1199-701c-89dc-81b273d3dc0c€35.00€0.50matched
13refund01a1ae72-2670-78f0-88d5-dee7c8b46414-€20.00€0.00matched
14capture01a1ae72-4274-7c26-a63f-16e1a0c2b0cf€15.00€0.26matched
15capture01a1ae72-50c9-729c-96e7-d630cad0e73e€15.00€0.26matched
16capture01a1ae72-541a-7f13-8cbc-2d5e71f94e67€49.00€0.67matched
17refund01a1ae72-6c66-7135-9418-dc8e39bea3e8-€4.00€0.00matched
18capture01a1ae72-79cf-7a3b-8655-76c783a07cc5€35.00€0.50matched
19capture01a1ae72-7e48-7a74-9e7c-65e54d90c000€35.00€0.50matched
20capture01a1ae72-831f-725e-9325-8456e8d9173d€9.00€0.19matched
21capture01a1ae72-8a71-7fc3-8487-ef577ead4d58€24.00€0.37matched
22capture01a1ae72-97b1-7752-998f-46f43b19df02€49.00€0.67matched
23capture01a1ae72-f323-72d9-a9b5-a59422cb32cd€49.00€0.67matched
24capture01a1ae72-f43b-7f4c-ae83-ac5a01058704€24.00€0.37matched
25refund01a1ae73-094b-7457-9e29-8124b74d1486-€16.00€0.00matched
26capture01a1ae73-33cb-7ed6-98c9-8c15deea6256€49.00€0.67matched
27capture01a1ae73-40d2-7beb-b5a7-c77f66325714€15.00€0.26matched
28capture01a1ae73-7efa-7d6a-a02f-72e23e956f99€49.00€0.67matched
29capture01a1ae73-8a88-714d-a3a0-2bf119acdbe1€35.00€0.50matched
30capture01a1ae73-99df-707b-9e00-f60b0d4c5ff6€15.00€0.26matched
31capture01a1ae73-a7c4-79a1-8d64-b87c62d23853€35.00€0.50matched
32capture01a1ae73-c38f-7854-b75b-3cfa11ca9970€24.00€0.37matched
33capture01a1ae73-d162-7296-871c-536a8092cb00€35.00€0.50matched
34capture01a1ae73-dda8-75e8-951e-a90ce3be62f1€49.00€0.67matched
35capture01a1ae73-ea95-7738-9456-ec9227eab56d€9.00€0.19matched
36capture01a1ae73-fcf8-7cd7-ba0c-076d28b66231€35.00€0.50matched
37capture01a1ae74-0848-7300-8e68-aaafe316c8cb€15.00€0.26matched
38capture01a1ae74-1374-7fe0-811c-d3c79e3ce5bb€9.00€0.19matched
39capture01a1ae74-3cc6-77b9-ae11-e7d8a305db90€49.00€0.67matched
40capture01a1ae74-4b2c-7230-891b-eb0634cd4411€15.00€0.26matched
41capture01a1ae74-64c8-7214-b93f-e1ea671a0d87€49.00€0.67matched
42capture01a1ae74-6ae0-7356-a8bc-ef03c0288061€49.00€0.67matched
43capture01a1ae74-786a-7d01-8d9a-7bddaed58f26€49.00€0.67matched
44capture01a1ae74-8087-7d56-be5f-66da8ef8fbe8€15.00€0.26matched
45refund01a1ae74-9c8d-7cb7-ba30-206679357e6d-€31.00€0.00matched
46refund01a1ae74-b068-71a8-8507-a58ed36fec1d-€3.00€0.00matched
47capture01a1ae74-b236-78d2-a219-466398d719fa€24.00€0.37matched
48capture01a1ae74-d77f-74b2-a3cb-75a828486253€9.00€0.19matched
49capture01a1ae74-e642-7864-acd4-631f482c8e10€35.00€0.50matched
50capture01a1ae74-f536-73ee-8056-eebe1d66193e€24.00€0.37matched
51capture01a1ae74-f574-76c2-b9b7-1d29f570d9aa€24.00€0.37matched
52capture01a1ae74-f5a1-7be8-b1be-98e09012322e€49.00€0.67matched
53capture01a1ae75-00d0-79f8-9282-2b2061bd9ed3€9.00€0.19matched
54capture01a1ae75-1d6f-702f-b9d8-caf33b51666c€9.00€0.19matched
55capture01a1ae75-35c6-7fb3-849d-e7f0c1fcb444€49.00€0.67matched
56capture01a1ae75-3c23-770b-a58e-96c2651f7ed0€15.00€0.26matched
57capture01a1ae75-5677-7227-99e3-eb28a82b8dd5€9.00€0.19matched
58capture01a1ae75-5817-74e8-b4ed-e8090cd0cdaa€24.00€0.37matched
59capture01a1ae75-62f1-704c-a0d3-7f51a621baed€49.00€0.67matched
60capture01a1ae75-7b4b-7ca3-a4a1-bd7b823dae04€35.00€0.50matched
61capture01a1ae75-7def-7850-b35e-2bc6dd939fd7€49.00€0.67matched
62capture01a1ae75-7f40-7208-92a3-d6e5c1ad02ad€49.00€0.67matched
63capture01a1ae75-a541-717d-8cbe-7fd647880406€9.00€0.19matched
64capture01a1ae75-ce92-780b-af85-8a76a14e11dd€9.00€0.19matched
65capture01a1ae75-dd4c-7608-9d2c-599837088062€9.00€0.19matched
66capture01a1ae76-0485-7dd7-bec6-75b5a986246f€35.00€0.50matched
67capture01a1ae76-1918-7107-9c97-da1641e4a74a€15.00€0.26matched
68capture01a1ae76-2b83-7259-83b5-79f361ce6deb€35.00€0.50matched
69capture01a1ae76-3b38-7819-9ba8-70b982082b42€15.00€0.26matched
70capture01a1ae76-3f8e-7479-a5ce-e47f070eee52€35.00€0.50matched
71capture01a1ae76-4f27-78a7-93c1-04257fe394e2€9.00€0.19matched
72capture01a1ae76-568a-7f03-84e2-27e8a734e78d€49.00€0.67matched
73capture01a1ae76-82b2-7217-82b9-b4536763235a€9.00€0.19matched
74capture01a1ae76-9b8c-7d92-94c3-a44e5d5a2501€9.00€0.19matched
75capture01a1ae76-c657-7181-86fc-fd335ab7366b€24.00€0.37matched
76capture01a1ae76-d09a-7f49-999c-50ffbe6ec355€9.00€0.19matched
77capture01a1ae76-e82f-77ff-9274-5ea63ee20e8a€9.00€0.19matched
78capture01a1ae76-fbc7-7633-8be3-b2059e4a836b€24.00€0.37matched
79capture01a1ae76-fff8-7367-9a2a-e23ef7abe932€35.00€0.50matched
81capture01a1ae77-217e-78c9-b778-0e37c738fb48€49.00€0.67matched
82capture01a1ae77-25a0-7a87-8f1f-91db17e39487€49.00€0.67matched
83capture01a1ae77-6035-78e2-b671-418a087e4fd8€9.00€0.19matched
84capture01a1ae77-6fdc-7b88-aa5b-1e93c45c2bb0€15.00€0.26matched
85capture01a1ae77-7e1c-72cf-becd-1b93a417c8a7€35.00€0.50matched
86refund01a1ae77-aa7b-7e6b-adb1-fbc447243fa5-€29.00€0.00matched
87capture01a1ae78-02af-7c9f-8701-c27a48311b72€15.00€0.26matched
88capture01a1ae78-0952-7d3b-a0db-d84e443b3c1a€24.00€0.37matched
89capture01a1ae78-0e75-7d02-85d5-9ee8eefd2251€35.00€0.50matched
90capture01a1ae78-1061-756c-80c4-c643281604dc€24.00€0.37matched
91capture01a1ae78-1835-7f5a-a9e7-42760c50f4d3€24.00€0.37matched
92capture01a1ae78-2b02-7168-b6ef-c50859e9a9ff€35.00€0.50matched
93capture01a1ae78-3b0e-7d85-b696-ffb0ed2d88c5€35.00€0.50matched
94capture01a1ae78-576b-7cc2-8d18-b0367d7e3994€49.00€0.67matched
95capture01a1ae78-5972-7db0-98c6-46c6e06ddd02€35.00€0.50matched
96capture01a1ae78-72dc-786f-ba51-7ac8900c2edd€24.00€0.37matched
97capture01a1ae78-7378-7b3b-b893-03ae493fb9d2€9.00€0.19matched
98capture01a1ae78-7760-7ca2-b478-04a1ebc94a74€35.00€0.50matched
99capture01a1ae78-78f6-71f5-bd93-60f40b6c246f€15.00€0.26matched
100capture01a1ae78-7dff-7767-98a0-24313d4b8e12€9.00€0.19matched
101capture01a1ae78-80dd-7ce0-b580-79526cfb43ef€9.00€0.19matched
102capture01a1ae78-912f-77fc-8667-8ba566522d2e€49.00€0.67matched
103capture01a1ae78-a36f-76a5-8258-0b1f13e7b42c€24.00€0.37matched
104capture01a1ae78-a98c-78f8-8169-50970fd4d076€15.00€0.26matched
105capture01a1ae78-a9b9-7f4c-9369-d0d734edb94d€24.00€0.37matched
106refund01a1ae78-b59c-7f66-a33b-70e11f1723bf-€3.00€0.00matched
107capture01a1ae78-c00d-7b6c-9985-4f2b2f0b4964€15.00€0.26matched
108capture01a1ae78-c5e7-789d-b793-a6823b69fdb8€15.00€0.26matched
109capture01a1ae78-ca2e-7b54-ae33-48b2f6987a26€9.00€0.19matched
110capture01a1ae78-d981-7f84-bf0b-4431f2c4ca3c€24.00€0.37matched
111capture01a1ae78-eeb3-7272-9cce-e0bb61352896€9.00€0.19matched
112refund01a1ae78-f362-7288-a08e-4631891cae97-€13.00€0.00matched
113capture01a1ae79-1183-7935-a29f-3c6a7b89dca6€49.00€0.67matched
114capture01a1ae79-172f-7a0a-974c-ffd72622b3f9€15.00€0.26matched
115capture01a1ae79-2bb4-755c-b0ab-9311fd698fd5€15.00€0.26matched
116capture01a1ae79-48c8-7bd6-ba76-5a25d4cf41f8€24.00€0.37matched
118capture01a1ae79-6709-795c-ac55-74493b0a89b9€49.00€0.67matched
119refund01a1ae79-a3df-7d6a-9569-04f0c08dc64f-€5.00€0.00matched
120capture01a1ae79-ad49-750b-a5e3-8296670bdc88€24.00€0.37matched
121capture01a1ae79-be2f-74b2-84da-ca4b6cf2d356€35.00€0.50matched
122capture01a1ae79-cff2-7425-96c9-ca5723e630b0€49.00€0.67matched
123capture01a1ae79-d1b5-71db-a5d1-d1b7d2e4621a€35.00€0.50matched
124capture01a1ae79-d89b-732c-baf2-8e57ca7a3fb0€49.00€0.67matched
125capture01a1ae7a-0061-79b8-8511-8e07f4877f68€24.00€0.37matched
126capture01a1ae7a-0a64-7fce-810d-a6d2f2c4c49c€49.00€0.67matched