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:40

Gross

€3,103.00

PSP fee

€51.36

Net to the bank

€3,051.64

Settlement journal

#369590

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a3cd-41ff-7233-b4be-e507edb5db44 is already settled by stl_EUR_2989582 line 82
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a1a3d0-0196-7651-8292-2404383cd627 is in no file
  • missing linein the books, not in the filecapture:01a1a3c9-d9b1-78d3-bcf8-70279ecc06b5 is in no file
  • missing linein the books, not in the filerefund:01a1a3ca-e6c7-7be0-91d2-e67fb0579a16 is in no file
LineKindReferenceGrossFeeStatus
78capture01a1a3cd-0178-7a2f-ace5-bd28c92e9f19€35.00€0.54fee difference
83capture01a1a3cd-42e1-78d2-9ff5-37631e7db23b€9.00€0.19duplicate line
118capture01a1a3cf-bebb-7149-a57a-59fb49320281€49.00€0.72fee difference
1capture01a1a3c5-f18e-7042-a753-465de950e10c€35.00€0.50matched
2capture01a1a3c8-a39d-7807-bae9-0b918d58dd9f€24.00€0.37matched
3capture01a1a3c8-aca7-7838-a93a-0905a890b35f€49.00€0.67matched
4capture01a1a3c8-c89a-772b-88ab-e4df2547b2ee€49.00€0.67matched
5capture01a1a3c8-d110-7983-bfed-aa0d6f9b833e€49.00€0.67matched
6refund01a1a3c8-d58d-7f63-b8de-10e0f267e0b4-€37.00€0.00matched
7capture01a1a3c9-13a5-7703-ad47-99368011bb36€24.00€0.37matched
8capture01a1a3c9-1b95-7709-a62b-afc325e9f46a€24.00€0.37matched
9capture01a1a3c9-33bd-7f2b-ac6d-2bd321ee003c€35.00€0.50matched
10capture01a1a3c9-4e69-711a-92f9-857c50c34068€49.00€0.67matched
11capture01a1a3c9-5bd5-7fb0-8eaa-cf2fc63fdf9d€35.00€0.50matched
12capture01a1a3c9-696d-79f0-829a-c2bc918b2244€15.00€0.26matched
13capture01a1a3c9-8aa1-71f6-9bae-adf8aeb3c918€9.00€0.19matched
14capture01a1a3c9-9863-7e4c-a983-330802d9a009€24.00€0.37matched
15capture01a1a3c9-be16-7b34-ba21-bff50e165d4b€35.00€0.50matched
16capture01a1a3c9-d28d-7ab2-8800-74c2d11676c2€15.00€0.26matched
17capture01a1a3c9-f994-7f77-b3e5-2c4d3cf8da5f€35.00€0.50matched
18refund01a1a3ca-0699-74e9-a086-ba7c5d2362c0-€12.00€0.00matched
19capture01a1a3ca-0ee0-7c8a-bbc4-16c4560a4e7e€9.00€0.19matched
20capture01a1a3ca-106d-7807-82be-a624359095ab€35.00€0.50matched
21capture01a1a3ca-11a3-71ec-9e64-f46c4ea6dab1€35.00€0.50matched
22capture01a1a3ca-1503-7fe7-9fdf-bc1ac1687128€35.00€0.50matched
23capture01a1a3ca-26f0-75a7-b504-930c6c042dfa€49.00€0.67matched
24capture01a1a3ca-3029-77f4-b36a-007e277c26c9€24.00€0.37matched
25capture01a1a3ca-3193-756f-834b-78dfb86135e8€9.00€0.19matched
26capture01a1a3ca-3540-74dd-a75f-aa70f8432137€9.00€0.19matched
27capture01a1a3ca-4376-73f6-96af-0fcb5e9f39ec€9.00€0.19matched
28capture01a1a3ca-4ec7-7bcb-95d6-c00f47d64256€9.00€0.19matched
29capture01a1a3ca-5a48-75aa-adf1-a22eb6a2656d€9.00€0.19matched
30capture01a1a3ca-85d7-7797-832a-e070aa9162ff€49.00€0.67matched
31capture01a1a3ca-94d7-75ee-ac6e-05a020370535€24.00€0.37matched
32capture01a1a3ca-9a4d-7858-add7-a59694d08adc€9.00€0.19matched
33capture01a1a3ca-a3e7-7d07-a6d5-166e73607fe5€49.00€0.67matched
34capture01a1a3ca-aab6-700c-a91c-558d8633c197€24.00€0.37matched
35capture01a1a3ca-bbba-7c17-a579-266ba2df8ec9€24.00€0.37matched
36refund01a1a3ca-d141-78da-b061-d6e392dd0c78-€40.00€0.00matched
37capture01a1a3ca-d95b-7d29-8518-55c16ae8c185€35.00€0.50matched
38capture01a1a3ca-f37a-775c-bb47-e64c712a5d1e€15.00€0.26matched
39capture01a1a3ca-fb5d-7bfc-96ac-75962151e1e7€24.00€0.37matched
40capture01a1a3cb-0abf-76eb-b040-a32b96d77913€24.00€0.37matched
41capture01a1a3cb-0f5a-722e-827d-13f00451cffa€24.00€0.37matched
42capture01a1a3cb-3c93-77b9-90cc-45fa3da2597a€24.00€0.37matched
43capture01a1a3cb-44b1-75ce-9fff-28752352c03f€9.00€0.19matched
44capture01a1a3cb-5519-7f92-939b-257a54bf797a€35.00€0.50matched
45capture01a1a3cb-5a57-7c05-95bb-a2e328448485€35.00€0.50matched
46capture01a1a3cb-6227-737d-ba1d-3907e58ff474€15.00€0.26matched
47capture01a1a3cb-6329-7a38-9fc2-11a2333921dc€9.00€0.19matched
48capture01a1a3cb-6813-735c-96ee-c8ab29e0a6d7€15.00€0.26matched
49capture01a1a3cb-6e40-7846-968e-2e5ace6424cb€9.00€0.19matched
50capture01a1a3cb-704b-704d-b8fe-b5deadeea1b1€15.00€0.26matched
51capture01a1a3cb-82ff-7a51-96f3-eaf57a77e94f€24.00€0.37matched
52capture01a1a3cb-966d-7bbb-95d7-f2c593fa57f0€49.00€0.67matched
53refund01a1a3cb-ac5e-7635-b4d2-5a763c1b63f1-€20.00€0.00matched
54capture01a1a3cb-c55d-7561-900e-c77c7c47723c€15.00€0.26matched
55capture01a1a3cb-cf58-712b-832f-a5e412316c6c€9.00€0.19matched
56refund01a1a3cb-d25e-7e3c-8bb4-ab4525971e20-€26.00€0.00matched
57capture01a1a3cb-dd8e-77d7-b32f-0894fb4f5623€9.00€0.19matched
58capture01a1a3cb-e522-7dd6-960d-3de8084f0091€35.00€0.50matched
59capture01a1a3cb-f3ce-72c2-a31e-520877ff4c3d€9.00€0.19matched
60capture01a1a3cb-f3fe-7c61-9c10-c257ed008416€15.00€0.26matched
61capture01a1a3cc-0ddb-799d-8abc-e683d33e2071€9.00€0.19matched
62capture01a1a3cc-1753-75ac-bfb1-89761c4000f8€49.00€0.67matched
63capture01a1a3cc-228a-70b4-ac84-cec84e4c349b€35.00€0.50matched
64capture01a1a3cc-24da-7cdb-a527-9c4725d1feb5€15.00€0.26matched
65capture01a1a3cc-30f9-7d60-a9f9-63dbeec657ca€15.00€0.26matched
66capture01a1a3cc-314e-7062-8b47-d6e7530c0ce3€9.00€0.19matched
67capture01a1a3cc-5a68-7cf5-909a-2bb704e14c31€15.00€0.26matched
68capture01a1a3cc-6677-7732-986f-84895bdace40€15.00€0.26matched
69capture01a1a3cc-6c26-7d7f-91d6-063bca57404e€24.00€0.37matched
70capture01a1a3cc-7c14-7952-84ba-5bf8a4490620€35.00€0.50matched
71capture01a1a3cc-98fa-7c69-92b9-94664ccaa0c1€49.00€0.67matched
72refund01a1a3cc-b12c-7791-94d4-58765365a28c-€8.00€0.00matched
73capture01a1a3cc-c5f5-70d2-9d9f-c9147e4cc873€9.00€0.19matched
74refund01a1a3cc-d68d-7ee8-8692-3a4c7fe6ac94-€45.00€0.00matched
75capture01a1a3cc-dcee-7641-aa89-3ea3f5e1b2c5€35.00€0.50matched
76capture01a1a3cc-e8a3-7036-8e71-3a9a0b36039c€15.00€0.26matched
77capture01a1a3cc-f465-7169-91dc-e9560b87dc70€24.00€0.37matched
79capture01a1a3cd-13e8-7e64-9448-6468399c67cf€35.00€0.50matched
80capture01a1a3cd-255a-7d3d-af53-613fca2b2dde€24.00€0.37matched
81capture01a1a3cd-3d80-7151-957a-df04e080f1d8€15.00€0.26matched
82capture01a1a3cd-42e1-78d2-9ff5-37631e7db23b€9.00€0.19matched
84capture01a1a3cd-86e9-7951-a48f-731fc997087a€15.00€0.26matched
85capture01a1a3cd-99ea-7da0-a49b-8135a0d344a7€15.00€0.26matched
86capture01a1a3cd-a83b-7459-a00e-fcf78d2f7d1a€24.00€0.37matched
87capture01a1a3cd-a8e8-7786-930e-16152997bf73€15.00€0.26matched
88capture01a1a3cd-ba22-7a51-a24b-e07019f51609€49.00€0.67matched
89capture01a1a3cd-b3b1-792b-9396-40c1be3b6319€49.00€0.67matched
90capture01a1a3cd-c62c-7120-a267-3626e9bd69ff€9.00€0.19matched
91capture01a1a3cd-e0fc-75fc-88e1-fe44aadcee21€24.00€0.37matched
92capture01a1a3ce-020f-7ea9-9fb4-b9cf952bae45€15.00€0.26matched
93capture01a1a3ce-7751-7f9e-940f-f50c17304b7d€35.00€0.50matched
94capture01a1a3ce-856f-7790-8165-75fe3214d58a€9.00€0.19matched
95capture01a1a3ce-9af8-7d6d-a58b-2453a3ad8042€49.00€0.67matched
96capture01a1a3ce-af6f-7408-8e8a-402b9f9b98a6€24.00€0.37matched
97capture01a1a3ce-cc9c-72f4-99f3-7c3e122c87c0€24.00€0.37matched
98capture01a1a3ce-ea5f-7646-a7ac-3b6bb5bbe78c€15.00€0.26matched
99capture01a1a3ce-f2b9-7526-99a7-5725721332a5€35.00€0.50matched
100capture01a1a3ce-fdc3-77ee-b60f-111a91b62714€49.00€0.67matched
101refund01a1a3ce-fe67-738e-9288-551caac345e0-€26.00€0.00matched
102capture01a1a3cf-2369-71f2-9ecb-dc464a2e858d€35.00€0.50matched
103capture01a1a3cf-27d7-7f49-b7dc-014dbaa9e42a€49.00€0.67matched
104capture01a1a3cf-40f4-7285-bfdc-d80432e94ffb€9.00€0.19matched
105capture01a1a3cf-47fe-7c71-8010-7034c81990a8€49.00€0.67matched
106capture01a1a3cf-58db-710f-8168-f04eeab4cd16€24.00€0.37matched
107capture01a1a3cf-5bde-7bed-b27e-1df6c2c3fa55€49.00€0.67matched
108capture01a1a3cf-622c-721d-8fde-eecef57f4390€49.00€0.67matched
109capture01a1a3cf-6e60-7da6-b04d-f8ec1e681b3c€24.00€0.37matched
110capture01a1a3cf-71b1-7383-a4d5-eda4bc60f64b€35.00€0.50matched
111capture01a1a3cf-74c2-75db-a280-4e777fedad13€15.00€0.26matched
112capture01a1a3cf-76f6-73ea-9d2d-71b65c20bd51€9.00€0.19matched
113capture01a1a3cf-7fab-7fcf-86c1-5c99f5fa6413€9.00€0.19matched
114capture01a1a3cf-809c-7a56-abb1-5422096b5826€35.00€0.50matched
115capture01a1a3cf-8101-72ba-a360-34ed2b6eaf84€35.00€0.50matched
116capture01a1a3cf-8d09-7087-93cd-89620a63f80f€24.00€0.37matched
117capture01a1a3cf-baa5-7dca-b8a6-bd9c94ce0a8d€35.00€0.50matched
119capture01a1a3cf-d535-7261-9dc5-cf9145442c7f€24.00€0.37matched
120capture01a1a3cf-dc18-78df-ae04-7bf2653ee806€15.00€0.26matched
121refund01a1a3cf-dc79-70b1-be92-0a5f7d2aae21-€27.00€0.00matched
122capture01a1a3cf-f017-7124-8f58-627e94bfbf59€9.00€0.19matched
123capture01a1a3d0-04f0-70ad-81f7-53e426044388€49.00€0.67matched
124refund01a1a3d0-0a5f-71c0-a90e-a42a379503d7-€16.00€0.00matched
125capture01a1a3d0-28ca-71b2-bc10-4a5bff52ed22€49.00€0.67matched
126capture01a1a3d0-420a-79f7-91cd-8212f3474633€9.00€0.19matched
127refund01a1a3d0-73d8-769e-9186-555958dfe133-€19.00€0.00matched
128capture01a1a3d0-82ca-7236-a6ff-5ebc30f4ca1d€49.00€0.67matched
129capture01a1a3d0-8e56-7deb-862e-293fab87e9c6€15.00€0.26matched
130capture01a1a3d0-a1ba-7634-935e-c2ff48e9d603€24.00€0.37matched
131capture01a1a3d0-a306-72af-a1d6-b80145d5134e€9.00€0.19matched
132capture01a1a3d0-aa8b-73d8-84b5-42ef32eef239€9.00€0.19matched
133capture01a1a3d0-ba1e-73b9-a6a2-5fd3f45b5dd2€49.00€0.67matched
134capture01a1a3d0-e433-7504-b954-5c02b1e63fed€35.00€0.50matched
135capture01a1a3d0-eeae-7d61-a0da-cd1e8e95df25€35.00€0.50matched
136capture01a1a3d1-00a1-7d76-9511-b4d25610fb96€15.00€0.26matched
137capture01a1a3d1-2908-792b-a610-0785baed65b9€15.00€0.26matched
138capture01a1a3d1-455d-7388-865e-5be172684836€9.00€0.19matched
139capture01a1a3d1-5206-7bef-b90b-62bcb84a1f45€24.00€0.37matched
140capture01a1a3d1-b8ae-7cac-9654-a9d7819c5b1e€15.00€0.26matched
141capture01a1a3d1-bb7c-76ab-afeb-1d3e17e9c313€9.00€0.19matched
142capture01a1a3d1-bcb1-77e9-ae57-bb95170551d8€49.00€0.67matched
143capture01a1a3d1-bcb2-7dac-a807-e883934b1b28€24.00€0.37matched