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

5 Nov, 06:50

Gross

€2,717.00

PSP fee

€42.34

Net to the bank

€2,674.66

Settlement journal

#393311

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aa79-f952-7e72-90c9-af1423685b58 is already settled by stl_EUR_2989769 line 10
  • 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 39, the contract says 37
LineKindReferenceGrossFeeStatus
11capture01a1aa79-fa71-7a78-880a-7b6373b259aa€15.00€0.26duplicate line
17capture01a1aa7a-47ce-7452-89c6-3d0a1fd96733€49.00€0.70fee difference
79capture01a1aa7e-7bf6-7332-82fa-6c0780af9a76€24.00€0.39fee difference
1capture01a1aa78-fc46-77ba-9e94-07bc727ba932€15.00€0.26matched
2capture01a1aa79-10b3-7ea5-8efb-51622e965c8c€24.00€0.37matched
3capture01a1aa79-131b-7336-b18f-206b201d99a2€49.00€0.67matched
4capture01a1aa79-1458-7208-8eb0-7d55ec770b31€35.00€0.50matched
5capture01a1aa79-224d-70ae-bef1-e92315fbd30c€9.00€0.19matched
6capture01a1aa79-5c6d-733b-b38c-1e60e4c52ad0€35.00€0.50matched
7capture01a1aa79-cf5c-7bd3-a0bf-eb54207bf710€9.00€0.19matched
8capture01a1aa79-db60-7432-b56c-ba3468464ecc€24.00€0.37matched
9capture01a1aa79-f02a-713d-ad54-d54f6876559f€9.00€0.19matched
10capture01a1aa79-fa71-7a78-880a-7b6373b259aa€15.00€0.26matched
12capture01a1aa79-fae2-7df8-bd88-27ad75254934€49.00€0.67matched
13capture01a1aa7a-2289-7035-b655-922b8b0dca41€24.00€0.37matched
14capture01a1aa7a-2fae-7d6e-ba6d-da7aed24e720€49.00€0.67matched
15capture01a1aa7a-2fd2-7d2f-af8c-13d279b5f5f9€9.00€0.19matched
16capture01a1aa7a-45d9-70db-bebf-0884bc6e16bd€24.00€0.37matched
18capture01a1aa7a-4cd3-7849-9f56-55bd6a18b9bb€24.00€0.37matched
19capture01a1aa7a-5f7f-7584-82e5-33fa69c76826€9.00€0.19matched
20capture01a1aa7a-5f99-7205-a9b0-964da01fd7bf€9.00€0.19matched
21capture01a1aa7a-6890-7838-b39e-68ecbd3d06b3€35.00€0.50matched
22capture01a1aa7a-6999-71c3-b60b-178a6b4a69e7€24.00€0.37matched
23capture01a1aa7a-817f-7eb8-ac69-b0dac588bbec€15.00€0.26matched
24capture01a1aa7a-82c5-703a-a8b2-0a98ee08fbbc€15.00€0.26matched
25capture01a1aa7a-9efb-73ae-9aa9-188d0a2da96e€35.00€0.50matched
26capture01a1aa7a-b1cb-7132-84c1-7dcaab0b6a3e€15.00€0.26matched
27capture01a1aa7a-b4f0-7c9d-9b20-a62a4491a329€49.00€0.67matched
28capture01a1aa7a-bac8-7ce4-b70d-d911a84493a8€24.00€0.37matched
29capture01a1aa7a-ea03-7993-bba7-423496c0b0bc€15.00€0.26matched
30capture01a1aa7b-0b48-7e0a-a53d-84fd812c3d91€15.00€0.26matched
31capture01a1aa7b-0f91-7834-abaf-d0592546c264€9.00€0.19matched
32capture01a1aa7b-3fdc-7637-aad8-8dd0cecae940€49.00€0.67matched
33refund01a1aa7b-4daa-77ff-93b5-f120e59751ed-€4.00€0.00matched
34capture01a1aa7b-5536-78bb-9eed-cdf4195d9ef5€15.00€0.26matched
35capture01a1aa7b-656a-7c1b-b0ce-3c6038afb7e3€35.00€0.50matched
36capture01a1aa7b-741b-7f72-8fb6-e685e14e3ce1€35.00€0.50matched
37capture01a1aa7b-7e33-7627-9ec9-09982e9117a1€49.00€0.67matched
38capture01a1aa7b-abad-7708-8fb7-f3acb6c524be€35.00€0.50matched
39capture01a1aa7b-b5ef-732a-b5e1-fa8e7e8b6f28€24.00€0.37matched
40capture01a1aa7b-c449-79d9-91f3-f1b759a9bae0€49.00€0.67matched
41capture01a1aa7c-06d0-7290-a85c-7564337a73ab€35.00€0.50matched
42capture01a1aa7c-16a0-725f-a6e9-61d92783041e€35.00€0.50matched
43capture01a1aa7c-1adc-79b7-8e9b-4ad2f438bd48€35.00€0.50matched
44capture01a1aa7c-1e9d-7268-87dc-bd13eb570ab1€15.00€0.26matched
45capture01a1aa7c-25b0-713e-b861-1c1e3caa8ad1€9.00€0.19matched
46capture01a1aa7c-2e11-7732-985f-35fc4765bda9€15.00€0.26matched
47refund01a1aa7c-3126-7f5f-b597-364e065eda83-€17.00€0.00matched
48capture01a1aa7c-4d63-7e30-86a5-9b484cdb6eb2€15.00€0.26matched
49capture01a1aa7c-548b-7963-bbd2-9a2477318890€9.00€0.19matched
50refund01a1aa7c-8192-75ae-8aef-efa2a8934ad4-€10.00€0.00matched
51capture01a1aa7c-8a25-7492-936d-f64f46ecb97e€9.00€0.19matched
52capture01a1aa7c-8cf5-70fc-b28c-27d0132aa994€24.00€0.37matched
53capture01a1aa7c-9163-7562-9e2f-967cf68af3fe€49.00€0.67matched
54capture01a1aa7c-b28f-7195-bd5f-b49d6d01c705€49.00€0.67matched
55capture01a1aa7c-c05f-7e0b-aaca-c14c04d5f046€15.00€0.26matched
56capture01a1aa7c-d508-7fed-b9ac-5f0d50665f55€49.00€0.67matched
57capture01a1aa7c-eb0f-75a8-8640-cccd1e684c2c€9.00€0.19matched
58capture01a1aa7c-f071-79a0-aaca-c7e85693c071€35.00€0.50matched
59capture01a1aa7c-f823-7114-bd63-be325abe406e€9.00€0.19matched
60capture01a1aa7d-05b9-7d07-a11e-d194d8b97492€24.00€0.37matched
61capture01a1aa7d-0e2b-7145-928a-855b15c866fe€24.00€0.37matched
62capture01a1aa7d-1739-794e-992b-9747e8b2b00f€35.00€0.50matched
63capture01a1aa7d-5676-7521-afb5-72aeaa439969€15.00€0.26matched
64capture01a1aa7d-580b-70cd-aee8-f8742c746f6e€49.00€0.67matched
65capture01a1aa7d-5a9f-76a1-8cd9-07ae385dce20€9.00€0.19matched
66capture01a1aa7d-711a-7a70-b573-c341cbf1a064€49.00€0.67matched
67capture01a1aa7d-72f9-72ba-81cc-571a9f0f5b1b€24.00€0.37matched
68capture01a1aa7d-a000-7f46-aa38-30d2685f4866€35.00€0.50matched
69capture01a1aa7d-ace6-7f05-afb6-ec46a9680d2d€15.00€0.26matched
70capture01a1aa7d-e666-77d8-9d4c-d50edd4283c6€9.00€0.19matched
71capture01a1aa7d-eaab-73c3-9eb8-730153ed9e8d€49.00€0.67matched
72capture01a1aa7e-0e56-74b8-b213-adadba7f7e90€15.00€0.26matched
73refund01a1aa7e-2da4-7480-849c-65f28f3c13ad-€3.00€0.00matched
74capture01a1aa7e-2cb8-7d06-a343-393767ac18df€15.00€0.26matched
75capture01a1aa7e-4f7d-7a2d-9bdf-6cad449ddd17€15.00€0.26matched
76capture01a1aa7e-5ae9-7ed0-ad78-3ef69e9e9d0f€9.00€0.19matched
77capture01a1aa7e-6290-718c-9069-6cc4c41749cf€24.00€0.37matched
78capture01a1aa7e-659c-7c87-9af9-fd1a81fda384€24.00€0.37matched
80refund01a1aa7e-8cde-7b31-8f66-876da16fc06e-€11.00€0.00matched
81capture01a1aa7e-9c02-71dc-90a0-10eb6be0a7e6€15.00€0.26matched
82capture01a1aa7e-9fda-7971-85a4-787a1676fb17€49.00€0.67matched
83capture01a1aa7e-a955-7d4b-a23a-76958a892053€35.00€0.50matched
84capture01a1aa7e-b42d-7088-b6fc-16836ec0ed4e€15.00€0.26matched
85capture01a1aa7e-c26c-7504-974a-8e31cb37da6d€15.00€0.26matched
86capture01a1aa7e-db4f-7b2a-b14e-af78b0ff62ec€9.00€0.19matched
87capture01a1aa7e-dd4b-73d5-9ccf-55293322c5c5€49.00€0.67matched
88refund01a1aa7e-fba1-7db3-a16b-c221be1e7308-€32.00€0.00matched
89capture01a1aa7f-00c1-7543-bda4-de7a0d7c0f04€49.00€0.67matched
90capture01a1aa7f-08f7-7e7e-8c68-52ca8fc2027c€15.00€0.26matched
91capture01a1aa7f-323d-76f5-a62a-00780e611c6b€35.00€0.50matched
92capture01a1aa7f-390b-7293-9408-394e25288f3c€35.00€0.50matched
93capture01a1aa7f-dcaa-7247-a629-9bf5df3e4e63€49.00€0.67matched
94capture01a1aa80-19d4-7561-a8bf-837d022f3f0c€49.00€0.67matched
95capture01a1aa80-1c07-743b-b2fe-e8fe48d38293€35.00€0.50matched
96capture01a1aa80-67f4-7086-ad98-446388b22ce4€24.00€0.37matched
97capture01a1aa80-914e-70f2-be24-21fe150ff6ff€15.00€0.26matched
98capture01a1aa80-b207-70d5-9da8-4ae5cc7b800d€24.00€0.37matched
99capture01a1aa80-b588-70da-83db-0be10361fa92€9.00€0.19matched
100capture01a1aa80-c702-7000-9cbf-2296e7f2bfea€24.00€0.37matched
101capture01a1aa80-ea84-70fb-b31e-efe6367a0a87€15.00€0.26matched
102capture01a1aa81-01e5-7371-bfa1-79b89c062064€9.00€0.19matched
103capture01a1aa81-0f10-7f9a-b592-4364c0761e8f€49.00€0.67matched
104capture01a1aa81-18b8-7951-ad34-f91427e04f05€15.00€0.26matched
105capture01a1aa81-2a49-7fb2-a1b5-61196b14972e€24.00€0.37matched
106capture01a1aa81-51bd-70a3-960e-26ae727a67d8€35.00€0.50matched
107capture01a1aa81-64c5-7faa-87d6-b092c7f2df7c€35.00€0.50matched
108capture01a1aa81-83ce-799e-8ee3-fdb32d177bba€15.00€0.26matched
109capture01a1aa81-9101-778f-b47a-b0d1d41ceece€9.00€0.19matched
110capture01a1aa81-9188-7ce0-943d-5515a7a0580e€15.00€0.26matched
111capture01a1aa81-b948-7a27-9fbf-882630e927ec€24.00€0.37matched
112capture01a1aa81-c678-7de1-99ba-23c0a985a58e€9.00€0.19matched
113capture01a1aa81-c9ca-74e7-a45c-2f21c3a6a225€35.00€0.50matched
114capture01a1aa81-c7fc-7ddc-8930-a491f9f30871€49.00€0.67matched