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, 11:30

Gross

€3,133.00

PSP fee

€50.86

Net to the bank

€3,082.14

Settlement journal

#342093

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a19c08-1526-7244-b671-8bc5698add77 is already settled by stl_EUR_2989365 line 41
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
LineKindReferenceGrossFeeStatus
24capture01a19c07-206a-7447-8af0-d87ee7aa403c€15.00€0.29fee difference
42refund01a19c08-1527-7597-9a87-6762b457f7b2-€6.00€0.00duplicate line
1capture01a19bff-84d7-7c26-9220-dc4058c82fad€49.00€0.67matched
2capture01a19c04-f37f-71a9-9816-3c75fc0ef7be€24.00€0.37matched
3capture01a19c05-fc69-776d-b971-2fba476fb674€24.00€0.37matched
4capture01a19c06-1430-7e33-9c56-5a1c873a83c0€35.00€0.50matched
5capture01a19c06-1b38-75a8-811c-ece84f444646€15.00€0.26matched
6capture01a19c06-2d97-754a-9629-8dbb2027ac91€35.00€0.50matched
7capture01a19c06-3e36-7f0e-957f-d5bd422f9ed2€24.00€0.37matched
8capture01a19c06-50c6-70f0-b0b8-6007c3a36868€49.00€0.67matched
9capture01a19c06-52f6-7ec8-9d2e-ea076786bff9€35.00€0.50matched
10capture01a19c06-6117-7709-892c-209a92285423€9.00€0.19matched
11refund01a19c06-86d6-706d-85ba-650e678bcd96-€23.00€0.00matched
12capture01a19c06-9000-7047-97d5-e1ccf2a3e704€35.00€0.50matched
13capture01a19c06-9abb-7708-99b2-40d40dcad730€35.00€0.50matched
14capture01a19c06-a3f6-78d1-b33b-a904931a16e0€15.00€0.26matched
15refund01a19c06-b6b4-7bcd-aebb-ba47e5d9a4ac-€32.00€0.00matched
16capture01a19c06-c715-7028-a1fd-9a12dbf0e459€15.00€0.26matched
17capture01a19c06-cc65-7dee-a8f8-a9fad405c56e€35.00€0.50matched
18capture01a19c06-d0a1-7a6d-8307-ca2f0fb624e6€9.00€0.19matched
19capture01a19c06-e0c0-7e37-acd7-d1bd1b222cb9€49.00€0.67matched
20capture01a19c06-f521-7b6c-bcbd-c56335e57301€15.00€0.26matched
21capture01a19c06-fef9-7846-9c6d-b79f14aa77a5€35.00€0.50matched
22capture01a19c07-0409-71b7-990c-36a4b54f88e0€35.00€0.50matched
23capture01a19c07-0a75-79e4-82f9-f97ff35856dd€9.00€0.19matched
25refund01a19c07-2532-7388-902d-5953bf734976-€10.00€0.00matched
26capture01a19c07-29fa-7452-b9a4-f5d3df664e3b€35.00€0.50matched
27capture01a19c07-2b5f-7738-9bf9-ea46fca35d89€35.00€0.50matched
28capture01a19c07-3337-7d67-8ec8-669953f515be€24.00€0.37matched
29capture01a19c07-489f-7f94-afd1-2b187620634d€15.00€0.26matched
30capture01a19c07-607a-7a7a-90c1-5071867fe18b€49.00€0.67matched
31refund01a19c07-6bb0-7173-ba74-8310a771e862-€12.00€0.00matched
32capture01a19c07-a048-77ac-bd4a-83e18d95ab8e€24.00€0.37matched
33capture01a19c07-a0f2-7aa4-858b-f68ba4f5e023€15.00€0.26matched
34capture01a19c07-b01d-7bf8-a61d-6908a2d1a6fb€35.00€0.50matched
35capture01a19c07-c14b-7002-80ae-c2ff22f4810c€15.00€0.26matched
36capture01a19c07-d62e-7a22-92d2-58e8445e7c4b€15.00€0.26matched
37capture01a19c07-ed79-7565-8120-3a3fcb82776a€49.00€0.67matched
38capture01a19c07-f3c0-77d2-8ff6-1f41c250581e€9.00€0.19matched
39capture01a19c07-fdec-787d-ae5d-861952472570€9.00€0.19matched
40capture01a19c08-0c6c-7528-adfd-ce1f7e9fa31d€24.00€0.37matched
41refund01a19c08-1527-7597-9a87-6762b457f7b2-€6.00€0.00matched
43capture01a19c08-262b-78bb-849c-2632edd652f7€35.00€0.50matched
44capture01a19c08-318c-7d45-abd5-562c4068e9a4€24.00€0.37matched
45capture01a19c08-388e-7135-b01b-afcfc0d18ac0€24.00€0.37matched
46capture01a19c08-3adb-7f4a-ab77-ac13ff2f2a80€24.00€0.37matched
47capture01a19c08-4ca4-7f01-95a3-b716b26869b5€49.00€0.67matched
48capture01a19c08-5020-7aa8-a94a-2ace059a6678€24.00€0.37matched
49capture01a19c08-6cc5-7269-8635-cb5c4414561f€9.00€0.19matched
50capture01a19c08-70c5-78d2-a4b7-60f3c85adc8b€9.00€0.19matched
51capture01a19c08-7d0b-7c08-9650-0161014d10a7€15.00€0.26matched
52capture01a19c08-800d-7727-a2af-480864f82fff€9.00€0.19matched
53capture01a19c08-98d6-7eb6-99fb-c4de994eb33c€9.00€0.19matched
54capture01a19c08-a86b-7d42-837d-aa66868027f2€24.00€0.37matched
55capture01a19c08-b119-7e8f-bcae-9ac12e8ec2eb€9.00€0.19matched
56capture01a19c08-b63a-76d9-8f2c-8faab74930f1€49.00€0.67matched
57capture01a19c08-c0f1-754a-81e2-f6e78fc10413€24.00€0.37matched
58capture01a19c08-fbfa-709b-83cb-16574ec9a121€49.00€0.67matched
59capture01a19c09-0129-7e42-84dc-50e0f4d17e18€15.00€0.26matched
60capture01a19c09-07c8-7331-9e9a-545d39f6e5fc€35.00€0.50matched
61capture01a19c09-0810-7787-848c-bbe1f458bec1€24.00€0.37matched
62capture01a19c09-0ace-75dc-9b47-d6ffe9904599€49.00€0.67matched
63capture01a19c09-28f4-7fbc-800b-53294d147343€24.00€0.37matched
64capture01a19c09-39ee-72f1-a239-14636eb5c394€24.00€0.37matched
65capture01a19c09-3ee9-77b7-8518-5a426c54e4fd€9.00€0.19matched
66capture01a19c09-4f2a-73df-a0b4-1e578eec469d€15.00€0.26matched
67capture01a19c09-5889-7ff4-8803-40c5f3d15872€49.00€0.67matched
68capture01a19c09-5d41-7070-8147-b008e3d2f379€9.00€0.19matched
69capture01a19c09-7486-78a5-96ae-309333f8f43a€24.00€0.37matched
70capture01a19c09-7cd0-7f9d-8dae-a2492c64f894€24.00€0.37matched
71capture01a19c09-999c-713e-8eb6-2f3ea50f3f6b€9.00€0.19matched
72capture01a19c09-9c5c-7071-b0f7-477177119c20€24.00€0.37matched
73capture01a19c09-aae9-7f48-9a1b-31e32072b07b€35.00€0.50matched
74capture01a19c09-c6d7-7976-b9e9-1f3a0cc6e007€15.00€0.26matched
75capture01a19c09-ea48-708a-a319-3b1229d91f69€35.00€0.50matched
76refund01a19c0a-0421-7164-bad9-6f0e5cd731fd-€17.00€0.00matched
77capture01a19c0a-2a24-7958-af19-4e4c7ef8fc7e€35.00€0.50matched
78capture01a19c0a-3918-7484-9e35-3d9cb250926a€15.00€0.26matched
79capture01a19c0a-417b-7221-b00d-769488d9d7dd€49.00€0.67matched
80capture01a19c0a-5677-73f6-8c7d-d66cb6322346€35.00€0.50matched
81refund01a19c0a-5b20-7baa-a1ba-e1d6eea3ccb2-€25.00€0.00matched
82capture01a19c0a-6293-7e03-bbb1-d553492d5720€24.00€0.37matched
83capture01a19c0a-79ae-7864-8fc1-5691fdc23fa1€49.00€0.67matched
84capture01a19c0a-8de7-7e97-a19b-cd7f44d15d22€35.00€0.50matched
85capture01a19c0a-9985-76a7-a1ec-1b4a4759beac€15.00€0.26matched
86capture01a19c0a-a3a8-722e-b99e-f355f8c7f92d€24.00€0.37matched
87capture01a19c0a-f1b5-7c68-845b-317ee8e1ec35€49.00€0.67matched
88capture01a19c0a-f9f4-7728-91c8-2167fb3f2880€15.00€0.26matched
89capture01a19c0b-20ef-76a0-b956-25d34a7773ef€24.00€0.37matched
90capture01a19c0b-4f5b-7d4a-bb26-ce8d8036124a€35.00€0.50matched
91capture01a19c0b-54a7-72bb-b09a-b92417454094€35.00€0.50matched
92capture01a19c0b-5ce3-7a53-9414-01803483b340€49.00€0.67matched
93capture01a19c0b-6ba7-77a6-b8cb-ff336239862b€24.00€0.37matched
94capture01a19c0b-962c-732a-a4f3-567faa6efbc1€49.00€0.67matched
95capture01a19c0b-e10e-7c27-87df-cb02dabbe912€35.00€0.50matched
96capture01a19c0b-ec3a-7873-b9b0-544133d55084€15.00€0.26matched
97capture01a19c0b-fc0e-76e5-b6a1-33e0b0b34b25€49.00€0.67matched
98capture01a19c0b-fe13-7ca7-9d32-9770a40fe83c€24.00€0.37matched
99capture01a19c0c-08dc-7e75-94a6-6c9b9b933365€24.00€0.37matched
100capture01a19c0c-25fa-7987-8e61-f1637130860a€49.00€0.67matched
101capture01a19c0c-5891-77ed-b266-c661ed35d308€9.00€0.19matched
102capture01a19c0c-865f-7352-a827-9d78e5bd5818€49.00€0.67matched
103capture01a19c0c-8893-73fb-8c14-5a1041b4047a€49.00€0.67matched
104capture01a19c0c-8942-7bc7-8152-4021d19b58cf€49.00€0.67matched
105capture01a19c0c-90d8-7cf2-9807-86a05b5a9d74€35.00€0.50matched
106capture01a19c0c-9b03-7511-8bdc-0cb209148a98€35.00€0.50matched
107capture01a19c0c-a971-7e0c-ac27-937429db46bd€49.00€0.67matched
108refund01a19c0c-c920-7cd0-9488-4c4b5095fbec-€47.00€0.00matched
109capture01a19c0c-db88-7f39-a406-7ad7b5a3077e€24.00€0.37matched
110capture01a19c0d-2bcd-79ca-82cb-cf5a72bd2884€35.00€0.50matched
111capture01a19c0d-40ee-7f99-8e02-771e0ca44f45€24.00€0.37matched
112capture01a19c0d-4ce6-76e7-b59f-199fa2066d35€49.00€0.67matched
113capture01a19c0d-6211-7dd4-938e-058555bb20d6€24.00€0.37matched
114capture01a19c0d-6236-790c-94d6-cb0885147ef3€24.00€0.37matched
115capture01a19c0d-63f1-7cf2-8816-ee081d340ddd€49.00€0.67matched
116capture01a19c0d-6ffe-71bc-97bb-1e3f8e8bc1bc€49.00€0.67matched
117capture01a19c0d-9aeb-7b59-8d5b-e7fc193ee27d€9.00€0.19matched
118capture01a19c0d-a3c3-75b3-85a1-1e9898e767d8€35.00€0.50matched
119capture01a19c0d-a74e-74ae-83cf-28a5a887b523€24.00€0.37matched
120capture01a19c0d-ac4e-74d8-a5d8-154e779a1436€35.00€0.50matched
121refund01a19c0d-b494-788c-84d1-4c8afa32f3ec-€8.00€0.00matched
122refund01a19c0d-bba8-795c-8fc6-3d5872458497-€25.00€0.00matched
123capture01a19c0d-c5c5-7f8d-b81b-b6b96df38312€15.00€0.26matched
124refund01a19c0d-cd08-745d-8051-a0d29a884ff3-€19.00€0.00matched
125refund01a19c0d-d889-7965-b10d-0cb3237e56ca-€41.00€0.00matched
126capture01a19c0d-f4f3-70fc-a817-a3c119a2c57f€15.00€0.26matched
127capture01a19c0d-f741-7ebc-8c73-a4fe685a2a08€15.00€0.26matched
128capture01a19c0e-0ad4-7472-a2f1-96ae61e9ea2c€15.00€0.26matched
129capture01a19c0e-2ff8-75ef-9964-638c3781a323€15.00€0.26matched
130capture01a19c0e-6909-711f-9613-8f520e93e9b5€24.00€0.37matched
131capture01a19c0e-6cda-7eb4-81ef-9d6961c5735a€15.00€0.26matched
132capture01a19c0e-96ef-7f7a-a6eb-2910da979d0d€24.00€0.37matched
133capture01a19c0e-996b-7c93-b507-ee5d9d0a54f3€15.00€0.26matched
134capture01a19c0e-d229-78d4-936e-f8529d4834d6€9.00€0.19matched
135capture01a19c0e-e2eb-79ea-893f-0b4659672425€35.00€0.50matched
136capture01a19c0f-1bc8-7087-a030-70389d23edbd€35.00€0.50matched