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

2 Nov, 15:40

Gross

€3,367.00

PSP fee

€53.58

Net to the bank

€3,313.42

Settlement journal

#345244

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • missing linein the books, not in the filecapture:01a19cf2-5d3f-772a-a791-84fc41e896a5 is in no file
LineKindReferenceGrossFeeStatus
36capture01a19cec-d00c-72eb-b823-67e7e6cc07db€35.00€0.52fee difference
1capture01a19ce8-2c0a-7543-b35f-c29292ad80be€24.00€0.37matched
2capture01a19ce9-0c00-70d2-8e30-213bae05ad32€24.00€0.37matched
3capture01a19ce9-bb3e-7fbc-ba6d-27905286dbae€49.00€0.67matched
4capture01a19cea-e7ed-7db7-a121-3c8c4a632a2f€24.00€0.37matched
5capture01a19cea-f582-73d1-bb4f-c80a7f832821€49.00€0.67matched
6refund01a19cea-fad1-793d-8d89-4184ba78d3e9-€46.00€0.00matched
7capture01a19ceb-06c4-7648-a328-6f7f80e1edfd€49.00€0.67matched
8capture01a19ceb-0862-78a5-8287-881b911e9238€15.00€0.26matched
9capture01a19ceb-1173-79fc-b10f-8b673977b1ef€35.00€0.50matched
10capture01a19ceb-14a9-7be1-b502-1b5d1e55c44c€24.00€0.37matched
11capture01a19ceb-3965-742d-994d-17986ad611e1€35.00€0.50matched
12capture01a19ceb-3ac8-7fe9-ad8d-453085e6ff33€24.00€0.37matched
13capture01a19ceb-567b-706e-a0c6-2187158b14df€24.00€0.37matched
14capture01a19ceb-708b-77ab-8c85-032c50b3f048€15.00€0.26matched
15capture01a19ceb-7546-75f0-98b6-0a9a95d49bf6€35.00€0.50matched
16capture01a19ceb-799e-7221-bdd4-0d085346d88e€35.00€0.50matched
17capture01a19ceb-8c27-7e5d-b583-c6d51a8c5a1d€24.00€0.37matched
18capture01a19ceb-9888-792a-9d4e-e3b010d593cb€15.00€0.26matched
19capture01a19ceb-b3dd-7d0a-a18e-2ccf7f8e4f9a€35.00€0.50matched
20capture01a19cec-086e-74c1-93b8-139458d8c0f6€9.00€0.19matched
21capture01a19cec-0a71-7676-9e16-d07657860fdd€9.00€0.19matched
22capture01a19cec-1345-70d3-a3b1-b6de95ae74f3€35.00€0.50matched
23capture01a19cec-1ec9-734f-bb88-056a1f8a2273€49.00€0.67matched
24capture01a19cec-24cb-73fd-bc4b-f5edb23b13fa€9.00€0.19matched
25refund01a19cec-2760-7254-977c-db5f50668a22-€21.00€0.00matched
26capture01a19cec-43fa-7d5d-b0b6-e473d17a10d3€35.00€0.50matched
27capture01a19cec-4432-749f-9ca4-362f11e3e0a3€35.00€0.50matched
28capture01a19cec-4ef6-70cd-8abe-768bd4718340€49.00€0.67matched
29capture01a19cec-44cb-7c96-b57c-44c5b3067f18€9.00€0.19matched
30capture01a19cec-5fd9-73c0-bbe8-ef74a54e7ef6€49.00€0.67matched
31capture01a19cec-6359-7e40-ba53-3c20efd4dab4€49.00€0.67matched
32capture01a19cec-6781-75e3-b46d-c44106b4df55€49.00€0.67matched
33capture01a19cec-6d2f-7694-8fd3-e6807c5005f7€24.00€0.37matched
34capture01a19cec-7134-726c-91db-b68c8f14876a€9.00€0.19matched
35capture01a19cec-bc6d-7e89-82f6-113865339d9c€15.00€0.26matched
37capture01a19cec-d8bd-7d93-8d3a-ac3a8df5ecd6€24.00€0.37matched
38capture01a19cec-ee4e-73c3-a39a-4a1d8bbef7c4€9.00€0.19matched
39capture01a19cec-f216-7131-affd-e64c594e096c€9.00€0.19matched
40refund01a19ced-2a19-7c85-bdd3-782298febd97-€12.00€0.00matched
41capture01a19ced-3667-7fd5-babb-0637ce251a1a€49.00€0.67matched
42capture01a19ced-38b7-7327-913f-8aad2aad7d2b€9.00€0.19matched
43capture01a19ced-3a28-7452-9053-09e586dfafb5€9.00€0.19matched
44capture01a19ced-4a24-7bf4-abcd-8213aceb584b€24.00€0.37matched
45capture01a19ced-509b-7c58-bc92-01c99af6da87€24.00€0.37matched
46capture01a19ced-50af-799d-bba3-0878d54c8fc7€9.00€0.19matched
47capture01a19ced-609f-767a-b563-2c2b9d79470f€24.00€0.37matched
48capture01a19ced-65cb-7c48-9aad-fd10d2d825de€9.00€0.19matched
49capture01a19ced-6937-7e9a-bd5b-b19d6e4e6b19€9.00€0.19matched
50capture01a19ced-945a-7444-bc88-48dac686929c€24.00€0.37matched
51capture01a19ced-a75f-770f-87a6-90e9ccc889f1€49.00€0.67matched
52capture01a19ced-b858-70f4-9446-09b9a74fa076€49.00€0.67matched
53capture01a19ced-c46e-711a-a717-2bbc9a918775€24.00€0.37matched
54capture01a19ced-c9fb-7372-b99a-aaac9b93b78a€35.00€0.50matched
55capture01a19ced-d377-72ff-b6de-9aa1ac121e36€9.00€0.19matched
56capture01a19ced-d680-7911-b0b2-4021b7fc9c1b€24.00€0.37matched
57capture01a19ced-dac8-7a1b-9185-41bc8511656f€24.00€0.37matched
58capture01a19ced-e730-7693-9783-532ee5deaf47€35.00€0.50matched
59capture01a19ced-f78d-7e25-ab0f-8ff1cd238c53€24.00€0.37matched
60capture01a19cee-020d-7f6b-8627-468f2062572d€24.00€0.37matched
61capture01a19cee-0e6b-7894-a4e0-cf52b49ef3eb€24.00€0.37matched
62capture01a19cee-16f1-7e25-8d16-816f7bae5d17€49.00€0.67matched
63capture01a19cee-2add-77d6-8f44-8ef7b051f72e€9.00€0.19matched
64capture01a19cee-33a3-75e4-8a03-d22faa4dee9a€9.00€0.19matched
65capture01a19cee-373c-7a13-8571-b5a12c22fb14€49.00€0.67matched
66refund01a19cee-59eb-7eb4-aeda-1b237db2f20c-€19.00€0.00matched
67capture01a19cee-5fe5-7443-8985-1959c78a10c8€15.00€0.26matched
68capture01a19cee-6da2-71b6-af26-02bbd11f23a9€15.00€0.26matched
69capture01a19cee-71d0-7d98-b791-da22c912ff63€15.00€0.26matched
70capture01a19cee-9acd-7a15-b348-f14e45c26c1b€15.00€0.26matched
71capture01a19cee-a0ac-70ea-8514-abe17bca5edb€35.00€0.50matched
72capture01a19cee-ad8a-7c30-a384-ea7c42b37ada€15.00€0.26matched
73capture01a19cee-bb43-7241-8f6e-0fe92a0c7989€49.00€0.67matched
74capture01a19cee-c1a9-7a4d-9081-89af6893759a€49.00€0.67matched
75refund01a19cef-0149-789a-adae-138809a612f7-€5.00€0.00matched
76capture01a19cef-0227-7181-8d3b-4977dbac5dbe€35.00€0.50matched
77capture01a19cef-1bd9-7ab8-b25f-d116a88cd8c1€49.00€0.67matched
78capture01a19cef-3ae8-7fea-8ecb-86d767d1fb9e€9.00€0.19matched
79capture01a19cef-4e2b-7385-9f4d-37679b48288b€49.00€0.67matched
80capture01a19cef-5a83-75bf-91da-c43c19c3ec4f€49.00€0.67matched
81capture01a19cef-5df2-7236-9146-f326689a2879€35.00€0.50matched
82refund01a19cef-6ccd-7f54-b075-32b1cce3dfbc-€43.00€0.00matched
83capture01a19cef-7501-7059-a18c-2469cb052c77€49.00€0.67matched
84capture01a19cef-75a7-7464-86d1-3460df916d6b€9.00€0.19matched
85capture01a19cef-97ad-7249-b409-134b610f2c43€35.00€0.50matched
86capture01a19cef-9824-78d2-b9d4-a85748a2d8d4€24.00€0.37matched
87capture01a19cef-e28e-7868-89dc-8a9e8a4f503d€49.00€0.67matched
88capture01a19cef-e3da-74ff-b13a-383c8e8ae963€49.00€0.67matched
89capture01a19cef-e82f-759a-8d6a-c5dc9fb4cd2e€49.00€0.67matched
90capture01a19cef-f6c8-7f1f-9467-769ed6036c5d€24.00€0.37matched
91refund01a19cef-fa38-70f6-85af-819d9a174f9b-€10.00€0.00matched
92capture01a19cef-fb22-7206-bd46-ffd8c7020748€15.00€0.26matched
93capture01a19cf0-12f6-71d5-99df-745c61573be2€9.00€0.19matched
94capture01a19cf0-26c3-71a0-b002-78ed28767e98€9.00€0.19matched
95capture01a19cf0-3850-74ea-9d16-ef6249810e4c€24.00€0.37matched
96capture01a19cf0-3db0-7f68-9378-fe753017e8b0€24.00€0.37matched
97capture01a19cf0-4192-7ec0-814e-97a6e4d0fd8a€24.00€0.37matched
98capture01a19cf0-42aa-7fbf-8009-c241b80c9c40€15.00€0.26matched
99capture01a19cf0-4deb-7417-85c6-396b7a4b70d0€24.00€0.37matched
100capture01a19cf0-4eb9-7c6c-9317-bb6e11f9fdf3€49.00€0.67matched
101capture01a19cf0-5dac-7eb8-a9df-77b991902be7€9.00€0.19matched
102capture01a19cf0-7260-750c-bf32-1256c82e1128€15.00€0.26matched
103refund01a19cf0-7889-794e-8c1d-f0544ed894e1-€17.00€0.00matched
104capture01a19cf0-7ed9-746f-abb7-c4034dd45ad8€49.00€0.67matched
105capture01a19cf0-c372-7058-9717-a1ef3163046f€24.00€0.37matched
106capture01a19cf0-dbaf-7ed5-87b4-22bbbc0519eb€35.00€0.50matched
107capture01a19cf0-faad-7e95-af0e-c36a879db620€35.00€0.50matched
108capture01a19cf1-0428-7e31-94bb-b485fcebc656€49.00€0.67matched
109capture01a19cf1-0ab3-71dc-8a9f-739e69ba1539€15.00€0.26matched
110refund01a19cf1-0f6f-7b63-af3d-a712f5d12e18-€25.00€0.00matched
111capture01a19cf1-26f8-794d-b6b8-b57113719da6€24.00€0.37matched
112capture01a19cf1-7d2a-7955-add6-405823783043€35.00€0.50matched
113capture01a19cf1-94f3-7e08-aa92-d6f4630977c1€15.00€0.26matched
114capture01a19cf1-ba7e-7a76-bf73-c15b8eb482ae€24.00€0.37matched
115capture01a19cf1-ec36-764c-9917-7d7e2f23101a€9.00€0.19matched
116capture01a19cf1-f0e8-7dca-b9ad-318eea30814c€9.00€0.19matched
117capture01a19cf1-fd0d-7fd1-98b5-bd0cc2660fbb€49.00€0.67matched
118capture01a19cf1-fed8-70b6-bb69-2f462d3da07f€24.00€0.37matched
119capture01a19cf2-0411-7f26-bb4d-be28fa44d331€49.00€0.67matched
120capture01a19cf2-09ff-7cec-8dad-d50dd818de1b€35.00€0.50matched
121capture01a19cf2-0c3f-77dc-8adc-d981bcfe29f9€49.00€0.67matched
122capture01a19cf2-1695-7a6c-8087-71ce3ce3347f€35.00€0.50matched
123capture01a19cf2-2b85-74f2-9f41-3b37013ef069€9.00€0.19matched
124refund01a19cf2-31e8-77b6-8a66-095e0f537b34-€7.00€0.00matched
125capture01a19cf2-6241-7bbd-85e5-1dccf7083957€15.00€0.26matched
126capture01a19cf2-6e90-7feb-a481-2eca7d6451a9€49.00€0.67matched
127capture01a19cf2-e2eb-757f-a638-eb8caafdd72f€15.00€0.26matched
128capture01a19cf2-ef6b-7a8a-bed6-498c7981f327€49.00€0.67matched
129capture01a19cf3-148b-72af-8048-8d4cac652d22€49.00€0.67matched
130capture01a19cf3-2e53-7f1d-8461-db577e97207b€9.00€0.19matched
131capture01a19cf3-5be1-7886-b3d9-6e601eb93630€49.00€0.67matched
132capture01a19cf3-735d-716d-a8c4-a1df1a9cd862€9.00€0.19matched
133capture01a19cf3-8b53-77da-8eb8-5d77337d71f2€9.00€0.19matched
134capture01a19cf3-971e-72c2-93ba-42017e87ce20€9.00€0.19matched
135capture01a19cf3-9906-7e48-9a93-87896a1efce8€9.00€0.19matched
136capture01a19cf3-ae87-7146-83c6-6dbd55e3ceb7€49.00€0.67matched
137refund01a19cf3-b005-7666-bb68-3ce532d7129d-€16.00€0.00matched
138capture01a19cf3-dbd5-7b44-8c98-d8543909a6ba€35.00€0.50matched
139capture01a19cf3-f0ee-7f36-a52e-2ba58438eca9€24.00€0.37matched
140capture01a19cf3-fdcb-71d5-8c18-5b675b5f42cd€24.00€0.37matched