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

7 Nov, 12:10

Gross

€2,761.00

PSP fee

€43.29

Net to the bank

€2,717.71

Settlement journal

#434218

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b5ef-b3a4-7eaa-8953-98e3e1ee241b is already settled by stl_EUR_2990089 line 64
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
LineKindReferenceGrossFeeStatus
65capture01a1b5ef-b3c2-7d3c-a940-937b5b5206d4€9.00€0.19duplicate line
102refund01a1b5f2-53f9-7eb0-b8c7-4a50c36443f9-€15.00€0.02fee difference
105capture01a1b5f2-7a70-7646-8b72-e4859466f746€49.00€0.72fee difference
111capture01a1b5f3-18df-715a-99d7-ca198c544573€49.00€0.68fee difference
1capture01a1b5e2-e02f-7cce-9c10-b5fa9a6e4643€9.00€0.19matched
2capture01a1b5e8-20f3-74f9-804b-a6c22934dc06€35.00€0.50matched
3refund01a1b5e8-a90b-7fc8-9f8d-1db503bbc5e8-€19.00€0.00matched
4capture01a1b5e8-d75e-73ec-91e2-d21cc1d1a2b5€9.00€0.19matched
5capture01a1b5ea-6fcf-7553-adec-a627c45972c8€35.00€0.50matched
6capture01a1b5ea-942a-74cd-8647-8845be81700f€35.00€0.50matched
7capture01a1b5ea-a592-7a05-9547-fa36f5285cfa€9.00€0.19matched
8capture01a1b5ea-d399-7bcf-9823-2b371c1fe681€9.00€0.19matched
9capture01a1b5ea-f13e-77b4-b98a-5efe166ac4fa€35.00€0.50matched
10capture01a1b5eb-0eb5-73f1-82f8-63e0eca3221b€35.00€0.50matched
11capture01a1b5eb-4a11-7380-b2c6-396127f0249f€35.00€0.50matched
12capture01a1b5eb-6f9c-7317-8d7a-ca87d4ff9ac6€24.00€0.37matched
13capture01a1b5eb-6fe6-78d0-b7b5-f8f0f61266d3€49.00€0.67matched
14capture01a1b5eb-853b-761f-9749-01fd44063ccd€9.00€0.19matched
15capture01a1b5eb-9cb4-7a54-a468-6d54a4b9f127€35.00€0.50matched
16capture01a1b5eb-e67d-79ef-8b9d-e3aa2b4e8832€49.00€0.67matched
17capture01a1b5eb-ea1c-778c-834c-5cf9a47520c1€49.00€0.67matched
18capture01a1b5eb-ebb6-7de4-89cf-51025475df0a€49.00€0.67matched
19capture01a1b5ec-3f4f-757a-a4ee-92bdde2f2646€9.00€0.19matched
20capture01a1b5ec-4f2b-703c-80b4-0e195c225501€15.00€0.26matched
21capture01a1b5ec-5416-75aa-bb64-6729f338b754€9.00€0.19matched
22capture01a1b5ec-7784-7d95-a291-7b18f88e4dbf€24.00€0.37matched
23capture01a1b5ec-8f93-735b-97e4-725553a59b66€49.00€0.67matched
24capture01a1b5ec-906e-7608-9c89-7fc043e4d479€15.00€0.26matched
25capture01a1b5ec-9180-765a-b22a-1254343b8df8€35.00€0.50matched
26capture01a1b5ec-9449-7600-9e02-e5e187bb04e0€24.00€0.37matched
27capture01a1b5ec-9a9b-76c2-8b79-d41c8dbbf8f1€9.00€0.19matched
28capture01a1b5ec-a1a7-7928-84a6-f089d3f9db24€15.00€0.26matched
29capture01a1b5ec-ab63-754c-94e1-9f2eb72069f1€49.00€0.67matched
30capture01a1b5ec-bf4a-75c3-b147-eec435437af2€35.00€0.50matched
31capture01a1b5ec-d453-7da6-b5de-2055579b5a74€35.00€0.50matched
32capture01a1b5ec-de2f-7850-8020-89431cdd7928€9.00€0.19matched
33capture01a1b5ec-f1b1-7fed-bbf1-8b7ecb63358e€24.00€0.37matched
34capture01a1b5ed-0750-7367-97d9-26b70e3b2a34€49.00€0.67matched
35capture01a1b5ed-62a6-705c-8d9b-aba1d42dd029€9.00€0.19matched
36capture01a1b5ed-63d3-70c8-ad0a-4ba6de61f850€35.00€0.50matched
37capture01a1b5ed-8f5c-763b-9d6b-172c3d3bbf45€9.00€0.19matched
38capture01a1b5ed-b0d4-7008-84fc-bc64e91632ba€15.00€0.26matched
39capture01a1b5ed-d330-7b8b-a921-bcb85008bd0a€49.00€0.67matched
40capture01a1b5ed-e365-751c-a3f4-f146917c217f€9.00€0.19matched
41capture01a1b5ed-f560-707d-8d34-80d234de6f74€9.00€0.19matched
42capture01a1b5ed-fdd1-7b9b-a690-0ac5964fd9ac€49.00€0.67matched
43capture01a1b5ed-fdef-77e9-9794-e48fefa2a6d1€15.00€0.26matched
44capture01a1b5ee-3951-756a-83ce-eb56fe6047e8€24.00€0.37matched
45capture01a1b5ee-4034-772d-bca1-86a397f99dd8€35.00€0.50matched
46capture01a1b5ee-4826-7500-a683-c456b1345967€49.00€0.67matched
47capture01a1b5ee-520c-72d8-b566-9d4fc51e43a4€24.00€0.37matched
48capture01a1b5ee-5ad0-747a-9ce5-ac5b08a347bb€15.00€0.26matched
49capture01a1b5ee-5e44-742a-8563-dd6ac2ccbada€35.00€0.50matched
50capture01a1b5ee-6c25-73fc-9165-832dc7bc4df4€15.00€0.26matched
51capture01a1b5ee-712f-74d5-8db7-dd949ab84457€49.00€0.67matched
52capture01a1b5ee-8bbe-741b-b666-b34cd2c6d052€35.00€0.50matched
53capture01a1b5ee-be4c-70c0-af66-daab41c421af€24.00€0.37matched
54capture01a1b5ee-d7f4-7795-8153-c3e842234cca€9.00€0.19matched
55capture01a1b5ee-e8d2-7c7c-914a-f2f182cdf97e€9.00€0.19matched
56capture01a1b5ee-f88a-7f57-8793-da05f3c3218a€9.00€0.19matched
57capture01a1b5ef-2e9b-7f4c-a890-355bf145b61e€35.00€0.50matched
58capture01a1b5ef-4fce-79a0-92ae-b1e646212547€35.00€0.50matched
59capture01a1b5ef-6d81-712d-b9d0-38fb66c00ec7€24.00€0.37matched
60capture01a1b5ef-7885-722b-a7b4-36deb5e8c94c€9.00€0.19matched
61capture01a1b5ef-7f83-7312-a740-6586bd186c24€15.00€0.26matched
62capture01a1b5ef-81de-7374-be33-93fdfdde137d€9.00€0.19matched
63capture01a1b5ef-89bb-7340-9e91-40f883250d9a€49.00€0.67matched
64capture01a1b5ef-b3c2-7d3c-a940-937b5b5206d4€9.00€0.19matched
66capture01a1b5ef-bc07-7c1e-95ef-3bb3a53a656a€15.00€0.26matched
67capture01a1b5ef-e050-7767-a677-b6dc19fa4834€15.00€0.26matched
68capture01a1b5ef-fccb-7313-83d5-18a02dceed0f€35.00€0.50matched
69capture01a1b5f0-15b9-7762-93d6-34248dbfb0ec€35.00€0.50matched
70capture01a1b5f0-20bd-73c4-b17c-bf3e3179ab94€9.00€0.19matched
71capture01a1b5f0-29d8-758d-85b2-85ad7b10468f€9.00€0.19matched
72capture01a1b5f0-2e48-7835-9d1a-0c68f9ce8cac€9.00€0.19matched
73capture01a1b5f0-3042-7e5b-9501-e86ff2e57df3€35.00€0.50matched
74capture01a1b5f0-3431-7d99-988e-f5205bec4459€24.00€0.37matched
75capture01a1b5f0-4ff7-79f4-9857-99fa39fdd54e€24.00€0.37matched
76capture01a1b5f0-57fd-7fa3-b5d9-66873dd0041c€15.00€0.26matched
77capture01a1b5f0-a2b8-7067-a15e-c8578edd636b€24.00€0.37matched
78capture01a1b5f0-bb70-7436-894c-4333d1ed2be3€9.00€0.19matched
79capture01a1b5f0-c584-768d-8ecf-4b8117880bad€24.00€0.37matched
80capture01a1b5f0-cc15-7dfd-a2bb-071968fa4cda€24.00€0.37matched
81capture01a1b5f0-d609-77c6-b347-0810b0a1384a€9.00€0.19matched
82capture01a1b5f0-f0d1-75aa-8631-b9ff50ad3fe2€15.00€0.26matched
83capture01a1b5f1-1407-7e34-833b-ceda21a50ced€24.00€0.37matched
84capture01a1b5f1-216e-7685-924a-3c7e3fd77371€35.00€0.50matched
85refund01a1b5f1-21c0-7577-936a-102296ebe7cd-€15.00€0.00matched
86capture01a1b5f1-3328-7830-abdd-49fd261206fe€15.00€0.26matched
87capture01a1b5f1-35f5-7bed-8528-b6712ffd9170€24.00€0.37matched
88capture01a1b5f1-36b6-792e-8e5d-90556b083260€24.00€0.37matched
89capture01a1b5f1-40ec-7268-b546-121ca40d9147€15.00€0.26matched
90capture01a1b5f1-4a8e-7468-8026-569eb77f6b5d€35.00€0.50matched
91capture01a1b5f1-3d70-74b3-81a6-a3c15500521e€35.00€0.50matched
92capture01a1b5f1-6acb-767a-aa11-ddde5761f7f0€24.00€0.37matched
93capture01a1b5f1-7169-759b-87fc-e7e4bbdbc115€15.00€0.26matched
94capture01a1b5f1-a467-7cab-ab1c-335553df648b€35.00€0.50matched
95refund01a1b5f1-c6e2-7b55-8c3c-67b1cfdcec14-€16.00€0.00matched
96capture01a1b5f1-e17f-7764-bb0d-2f2df1353250€35.00€0.50matched
97capture01a1b5f2-0801-7e1f-a684-3cdcf2424b1c€9.00€0.19matched
98capture01a1b5f2-0a95-7c45-b54d-95b474158d4e€35.00€0.50matched
99capture01a1b5f2-228a-74b4-bc4a-5e04b8f79c92€9.00€0.19matched
100capture01a1b5f2-24f7-7db6-afaa-4a17f65d87a7€49.00€0.67matched
101capture01a1b5f2-32e2-7654-b077-370cdf962fb7€35.00€0.50matched
103capture01a1b5f2-655a-7478-838c-5be05e2ff7e7€15.00€0.26matched
104capture01a1b5f2-7a48-7393-be7d-590eb31e6a65€15.00€0.26matched
106capture01a1b5f2-84e7-7e60-b12a-c81ebf8bac11€35.00€0.50matched
107capture01a1b5f2-abd9-739b-ad47-508546183953€35.00€0.50matched
108capture01a1b5f2-bc73-754e-b8da-174ee8e57b9f€9.00€0.19matched
109refund01a1b5f2-d2f5-78a8-99bc-503c21442382-€24.00€0.00matched
110capture01a1b5f2-f5e4-73b7-982b-3ba873c42d76€9.00€0.19matched
112capture01a1b5f3-2137-7c38-b8a2-9ac4c1c1b806€49.00€0.67matched
113capture01a1b5f3-34b1-7069-b4f1-0359b23d28f2€15.00€0.26matched
114capture01a1b5f3-4041-79f7-b794-ec65288cfd1e€49.00€0.67matched
115capture01a1b5f3-4404-79b3-a3cb-77e7f56e0a30€49.00€0.67matched
116capture01a1b5f3-7f4d-7fe7-84cf-0957a36b42bd€49.00€0.67matched