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, 23:10

Gross

€3,422.00

PSP fee

€53.77

Net to the bank

€3,368.23

Settlement journal

#369212

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • missing linein the books, not in the filecapture:01a1a3b1-90e2-7d6d-8ea7-1d72881265a5 is in no file
LineKindReferenceGrossFeeStatus
54capture01a1a3b0-6cdf-70a8-a814-b4385e4cc18a€24.00€0.39fee difference
127capture01a1a3b5-ced5-7850-b64d-4b8b0df2682e€15.00€0.28fee difference
1refund01a1a3a6-40ff-7de2-84c5-3a3bf37773a1-€3.00€0.00matched
2capture01a1a3a8-36af-72e2-8caf-f07382fbaf43€49.00€0.67matched
3capture01a1a3ab-5890-73eb-8f07-987b959da237€24.00€0.37matched
4capture01a1a3ab-c6e6-73fe-b651-c471088b5cf6€49.00€0.67matched
5capture01a1a3ad-43c1-75d7-a512-b54f2a456439€15.00€0.26matched
6capture01a1a3ad-6c35-7b39-b09a-625f16b7eb56€49.00€0.67matched
7capture01a1a3ad-7249-70b7-a7cc-d51592efac13€15.00€0.26matched
8capture01a1a3ad-7f1f-73e1-b34a-5afed61d8f31€49.00€0.67matched
9capture01a1a3ad-86f0-7385-891a-07355f9733f7€24.00€0.37matched
10capture01a1a3ad-903d-7c35-84ff-1e21db7227be€24.00€0.37matched
11capture01a1a3ad-9712-7d40-b84f-9efca5377839€24.00€0.37matched
12capture01a1a3ad-b445-7b52-b90b-b6142c0cc12e€49.00€0.67matched
13capture01a1a3ad-bd19-7e1b-861d-651868f4d0f8€35.00€0.50matched
14capture01a1a3ad-c51c-7143-b94f-917d8c22064c€24.00€0.37matched
15refund01a1a3ad-d307-7a8a-8fe4-09f8818e710f-€5.00€0.00matched
16capture01a1a3ad-d646-74b3-ae4c-27b369758463€35.00€0.50matched
17capture01a1a3ad-e286-7e44-aae3-e7486c4c9944€49.00€0.67matched
18capture01a1a3ad-e4b3-7210-b415-1f46510883a2€35.00€0.50matched
19refund01a1a3ad-e781-7d33-a3d9-6716e02f3c8b-€31.00€0.00matched
20capture01a1a3ad-ebd2-733c-ba2a-5704ca19af6a€15.00€0.26matched
21capture01a1a3ae-4eab-7d44-aa28-58416e7a76a7€49.00€0.67matched
22capture01a1a3ae-6b04-787d-8682-59bd26639dbc€49.00€0.67matched
23capture01a1a3ae-7263-74cc-b43a-3bc5ba9283f3€15.00€0.26matched
24capture01a1a3ae-7b1e-7f28-885d-0810a004f8ad€49.00€0.67matched
25capture01a1a3ae-a565-7857-ac3b-9aabe19c61b7€49.00€0.67matched
26capture01a1a3ae-d184-7d83-9f49-c8998b44e825€15.00€0.26matched
27capture01a1a3ae-d163-7197-a5bc-e7c3f6c8aae9€24.00€0.37matched
28capture01a1a3ae-fbd4-77da-b230-05d1e517e4da€9.00€0.19matched
29capture01a1a3af-1ebd-7ebc-b353-82cbb5cd0ec7€15.00€0.26matched
30capture01a1a3af-1ee2-7f24-80f3-1870571ba328€15.00€0.26matched
31capture01a1a3af-24a3-7b9f-87ac-66b966cdec64€35.00€0.50matched
32capture01a1a3af-300a-726f-a5ef-12ca1eaa8b0d€49.00€0.67matched
33capture01a1a3af-3ac6-7c0a-a2a0-ec8929a9d8b3€35.00€0.50matched
34capture01a1a3af-3be0-7108-b0b4-7b9608aa09dd€9.00€0.19matched
35capture01a1a3af-403d-7dff-88d0-4ee5b3372512€15.00€0.26matched
36capture01a1a3af-55ba-7147-b759-23cdd00a1db4€24.00€0.37matched
37capture01a1a3af-5c3e-74e8-bb3f-1567e53fed9f€35.00€0.50matched
38capture01a1a3af-5d44-7f28-96cd-09a944c210bc€49.00€0.67matched
39capture01a1a3af-603b-765b-859e-b884b37f3136€9.00€0.19matched
40capture01a1a3af-755a-7fa3-848b-50547333db1c€24.00€0.37matched
41refund01a1a3af-8b7c-7ddf-886f-3f39bde9ab0e-€15.00€0.00matched
42capture01a1a3af-8f95-74c5-8868-7e3d5d24cd6c€49.00€0.67matched
43capture01a1a3af-943e-75fe-9cf7-87a828bb390e€35.00€0.50matched
44capture01a1a3af-a3d8-706c-b451-c6192c7a3f9f€49.00€0.67matched
45refund01a1a3af-aff4-7eea-a7ca-9e54a46d4d09-€40.00€0.00matched
46capture01a1a3af-cbbe-7f66-9fdf-cf5b6394d15a€49.00€0.67matched
47refund01a1a3af-e7ff-7eb5-a1a9-dec91e995af1-€46.00€0.00matched
48capture01a1a3b0-01a8-7b93-8256-e63d6719a148€35.00€0.50matched
49capture01a1a3b0-0c3b-713c-8e33-3388720a1056€49.00€0.67matched
50capture01a1a3b0-19bd-7819-b293-060d9e5021c0€49.00€0.67matched
51capture01a1a3b0-2886-7dda-bc76-fcf152de44ef€24.00€0.37matched
52capture01a1a3b0-3d9f-7a97-a059-047eb8735a79€9.00€0.19matched
53capture01a1a3b0-3e3f-751a-b4ba-ed0c6c0875e5€49.00€0.67matched
55capture01a1a3b0-85c2-7806-adde-3cbbb9218364€24.00€0.37matched
56capture01a1a3b0-ac01-7101-ae17-ba8bb97c5017€35.00€0.50matched
57refund01a1a3b0-d09e-71fd-8a41-c8b3a4e40fce-€15.00€0.00matched
58capture01a1a3b0-d839-7cc8-b7b7-949bfe997d13€35.00€0.50matched
59capture01a1a3b0-eb13-75b7-acdc-c81cc59615a7€9.00€0.19matched
60capture01a1a3b1-0405-7836-a008-f663d8038016€15.00€0.26matched
61capture01a1a3b1-18ed-7832-9a58-c50a74e96389€35.00€0.50matched
62capture01a1a3b1-2917-7f6f-879c-d8b8245a6653€35.00€0.50matched
63capture01a1a3b1-2748-72f9-bee2-28bf6ce34703€24.00€0.37matched
64capture01a1a3b1-4601-7d1a-bc61-0be1f3bc5cea€15.00€0.26matched
65capture01a1a3b1-4c60-76f6-a168-6ab1aa6c2361€9.00€0.19matched
66capture01a1a3b1-56c4-7d8b-8d2a-4a2f21719c5a€49.00€0.67matched
67capture01a1a3b1-6077-7f1d-8628-d950b3c9a349€49.00€0.67matched
68capture01a1a3b1-63dc-7cdb-a70c-ca0df4200b16€24.00€0.37matched
69capture01a1a3b1-85b7-7bea-987d-0ae73a38592a€35.00€0.50matched
70capture01a1a3b1-d256-740b-84fa-c8dc93c89c5a€15.00€0.26matched
71capture01a1a3b1-f607-78cb-9655-b7f3fb20609c€9.00€0.19matched
72capture01a1a3b2-3088-7e1b-94ab-b5c005369893€9.00€0.19matched
73capture01a1a3b2-3a15-7784-9465-c5af651ba260€35.00€0.50matched
74capture01a1a3b2-4aac-78e7-acb7-26c71e71063f€24.00€0.37matched
75capture01a1a3b2-50ce-7600-b959-fcd49f0e0998€24.00€0.37matched
76capture01a1a3b2-68d9-7fc1-9e2f-21a3d697acb4€49.00€0.67matched
77capture01a1a3b2-7662-7fa7-ad1e-4549008b90d1€9.00€0.19matched
78capture01a1a3b2-7b35-7f4a-a892-9687b61ef69d€15.00€0.26matched
79capture01a1a3b2-92fc-786d-9be1-87ad0d2454f8€35.00€0.50matched
80capture01a1a3b2-99c3-7d9a-9ce7-b1546a963cc8€15.00€0.26matched
81capture01a1a3b2-a29c-72c4-b52a-09c577e582f0€49.00€0.67matched
82capture01a1a3b2-af28-7966-958b-ce05c65c6c38€24.00€0.37matched
83capture01a1a3b2-db4d-7531-b540-facefc8b8efd€24.00€0.37matched
84capture01a1a3b2-f1ff-7c13-b52d-5549afaa9b49€24.00€0.37matched
85capture01a1a3b2-f31d-73d4-8f96-7cfc69127a43€24.00€0.37matched
86capture01a1a3b2-f612-7e10-abc2-227adfc5cc44€49.00€0.67matched
87capture01a1a3b2-f9f0-7381-99f0-4112b2aab50c€35.00€0.50matched
88capture01a1a3b3-0167-7121-9997-7307a0834d13€49.00€0.67matched
89capture01a1a3b3-07d5-73e0-b3cc-93d5a55f368e€35.00€0.50matched
90capture01a1a3b3-15ad-748e-a232-d770580db902€9.00€0.19matched
91capture01a1a3b3-414b-7474-8a2d-fe4bc318c94f€49.00€0.67matched
92capture01a1a3b3-44de-786d-a22c-0a22e60faf5f€15.00€0.26matched
93refund01a1a3b3-4833-7e6d-9d2a-5af72e1d7559-€3.00€0.00matched
94capture01a1a3b3-57ed-75f3-b326-8ece73a6e040€9.00€0.19matched
95capture01a1a3b3-721f-79af-a215-60fae6e6db71€9.00€0.19matched
96capture01a1a3b3-7a84-736b-877d-e7aa1a6e77b8€49.00€0.67matched
97capture01a1a3b3-7b9d-759f-944a-d1817c614aa9€49.00€0.67matched
98capture01a1a3b3-7cce-7c9d-82ca-fad69a34910b€9.00€0.19matched
99capture01a1a3b3-8a86-752d-b724-c022d0a97d6c€9.00€0.19matched
100capture01a1a3b3-a6cf-7697-b66d-3834eb99d9bb€15.00€0.26matched
101capture01a1a3b3-b363-7ba0-a102-1aaf2191f30f€35.00€0.50matched
102capture01a1a3b3-be83-7a91-bd29-8875142929b7€24.00€0.37matched
103capture01a1a3b3-c120-7012-ba02-383d74f0a6a6€49.00€0.67matched
104refund01a1a3b3-d61d-741b-aa7c-acb8c0630200-€3.00€0.00matched
105capture01a1a3b3-db53-7f49-ba88-046d98fc9bf3€49.00€0.67matched
106capture01a1a3b3-eb8d-7772-af8c-a678b7841c7c€35.00€0.50matched
107capture01a1a3b3-f4e5-7430-9ac4-fc6f2de35fd2€15.00€0.26matched
108capture01a1a3b4-049c-76e3-85dc-39a5fd7c38aa€15.00€0.26matched
109capture01a1a3b4-0d87-7381-8e81-0995d81d0497€24.00€0.37matched
110capture01a1a3b4-1f97-7472-8210-65bbbcbef2c2€15.00€0.26matched
111capture01a1a3b4-21b5-7a8b-a476-daf5f9a5bc60€49.00€0.67matched
112capture01a1a3b4-2679-767c-ae4d-86a4549fec91€35.00€0.50matched
113capture01a1a3b4-4d48-75b1-acc4-2f2e14078aee€15.00€0.26matched
114capture01a1a3b4-70a6-74eb-996a-c2bf700270e8€49.00€0.67matched
115capture01a1a3b4-a7c7-76c7-bdc8-b020998a7437€15.00€0.26matched
116capture01a1a3b4-b4ca-7619-8938-339318242088€9.00€0.19matched
117capture01a1a3b4-d986-732b-b28f-a56ebf7a3d21€15.00€0.26matched
118capture01a1a3b5-0c1a-72d2-ad98-51513685d249€9.00€0.19matched
119capture01a1a3b5-1c85-736e-ae99-70a4087edb97€35.00€0.50matched
120capture01a1a3b5-4d87-7d9c-9faf-981022c090d7€15.00€0.26matched
121capture01a1a3b5-788a-75d7-93c0-381e537b974a€24.00€0.37matched
122capture01a1a3b5-98f8-76e3-9f55-1dc6cf987669€24.00€0.37matched
123capture01a1a3b5-a02c-7745-ae40-292d516793ea€9.00€0.19matched
124capture01a1a3b5-bb1b-7474-9e27-9536b0f92263€24.00€0.37matched
125capture01a1a3b5-bc52-7473-9f73-ff6d0f5ff350€15.00€0.26matched
126capture01a1a3b5-bfe2-7d92-a36d-7afef3ef0f24€15.00€0.26matched
128capture01a1a3b5-db01-7796-9c6f-31cad1f76b4e€24.00€0.37matched
129capture01a1a3b5-de59-71a3-967c-bdb3db45624e€24.00€0.37matched
130refund01a1a3b5-ed45-74b7-9c0f-ad10ef0d8f05-€11.00€0.00matched
131refund01a1a3b6-03c5-716d-84c8-c8448c874359-€10.00€0.00matched
132capture01a1a3b6-0819-7a80-8015-02adfc2c8f0d€9.00€0.19matched
133capture01a1a3b6-11de-7fad-937c-848d8a4590ee€9.00€0.19matched
134capture01a1a3b6-14cd-72ec-aba8-7f6d763f40db€24.00€0.37matched
135capture01a1a3b6-18e3-7165-8eb6-3a875ebb685f€35.00€0.50matched
136capture01a1a3b6-1c21-733d-b532-40c75d04c504€9.00€0.19matched
137capture01a1a3b6-44fd-78a9-91a4-1503bdf9e50a€24.00€0.37matched
138capture01a1a3b6-4568-73a8-ba19-6fcfe87dd627€15.00€0.26matched
139capture01a1a3b6-491a-7e4f-a575-455ba345da19€49.00€0.67matched
140capture01a1a3b6-4ecb-76f2-b200-d8df697708dc€24.00€0.37matched