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, 20:20

Gross

€3,235.00

PSP fee

€52.20

Net to the bank

€3,182.80

Settlement journal

#367095

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a311-b591-7008-a33d-3c59ed1592b8 is already settled by stl_EUR_2989562 line 7
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • missing linein the books, not in the filecapture:01a1a311-9955-721f-82a9-22060437cd11 is in no file
  • missing linein the books, not in the filerefund:01a1a31a-9725-7687-bc06-9d6e56047e79 is in no file
LineKindReferenceGrossFeeStatus
6capture01a1a311-c7eb-719c-9452-98f0fe0fda87€49.00€0.68fee difference
8capture01a1a311-c939-704f-a488-9e9225e54b1d€49.00€0.67duplicate line
1capture01a1a30b-7dbd-7654-b68d-759e25ce5cf1€15.00€0.26matched
2capture01a1a30e-6d42-7aaa-a4de-3b03887ded45€35.00€0.50matched
3capture01a1a311-94b6-7f1d-b198-4417ace31ac9€24.00€0.37matched
4capture01a1a311-ba41-7253-9a63-aee83004b6ee€49.00€0.67matched
5capture01a1a311-bd3d-7c5f-8968-fd7ab2e21d31€35.00€0.50matched
7capture01a1a311-c939-704f-a488-9e9225e54b1d€49.00€0.67matched
9capture01a1a311-cf0c-7650-a533-0afc63dde36f€15.00€0.26matched
10capture01a1a311-dae7-7066-a728-b9b9c5839310€9.00€0.19matched
11capture01a1a311-e9aa-7e64-b20c-78bcfdb70714€49.00€0.67matched
12capture01a1a311-ff12-7a1b-9483-eb7cfaa3dae9€9.00€0.19matched
13capture01a1a312-035b-7a94-b864-47c0ab9fc1d4€24.00€0.37matched
14capture01a1a312-0fb3-704f-bd40-10805169c497€9.00€0.19matched
15capture01a1a312-1c73-777a-9ee3-d664bc89aa3d€49.00€0.67matched
16capture01a1a312-1eb3-770c-97e2-b2547d83da48€9.00€0.19matched
17refund01a1a312-2b70-7324-9f6a-c35ab451f16b-€15.00€0.00matched
18capture01a1a312-3c65-79b9-a3c7-1f0fc447b725€49.00€0.67matched
19refund01a1a312-580b-7b87-aa1e-f2c8e2f5d22a-€36.00€0.00matched
20capture01a1a312-607f-786c-aeef-62ba743223f0€49.00€0.67matched
21capture01a1a312-6504-77dd-8db9-35f9dec497b3€35.00€0.50matched
22capture01a1a312-7670-77c0-8e6f-65a5917e795d€49.00€0.67matched
23capture01a1a312-7fa9-7f23-8d56-00df8f05909c€49.00€0.67matched
24refund01a1a312-8b45-78e8-98fb-cf2c05c68842-€3.00€0.00matched
25capture01a1a312-9e01-7a02-af08-f2a527c09f77€24.00€0.37matched
26capture01a1a312-a1f9-7464-9d2a-d60f91b31c56€15.00€0.26matched
27capture01a1a312-c9e4-7a9d-a8a9-2b3c3cf240d4€49.00€0.67matched
28refund01a1a312-ccc5-779c-b488-057830c73b1e-€19.00€0.00matched
29capture01a1a312-e065-746b-baac-11ba9d511681€49.00€0.67matched
30capture01a1a312-ef56-773a-ac2a-1bd64385005c€15.00€0.26matched
31capture01a1a313-0027-7f8a-8890-69983274272e€24.00€0.37matched
32capture01a1a313-0111-7d98-b1e7-96778bd6e1cc€49.00€0.67matched
33capture01a1a313-154c-7128-afb7-6ccebd515bd2€9.00€0.19matched
34capture01a1a313-351d-7ed6-bae5-9b71adc2f7d1€24.00€0.37matched
35refund01a1a313-39ca-7640-99ae-666ed43133d3-€45.00€0.00matched
36capture01a1a313-3e09-7374-81c9-925011066c0d€9.00€0.19matched
37capture01a1a313-413c-7520-ae18-e8b314ca9174€35.00€0.50matched
38capture01a1a313-4e85-75c5-afde-8b0a70d63b83€49.00€0.67matched
39capture01a1a313-55f7-7ed0-aff4-88752409eaaf€9.00€0.19matched
40capture01a1a313-5b99-77cb-bc75-f0668228052f€24.00€0.37matched
41capture01a1a313-73a4-7a6b-8705-5956bd524d69€15.00€0.26matched
42capture01a1a313-abdd-7a13-b013-f75a6121f473€35.00€0.50matched
43capture01a1a313-bccf-7699-bd9b-1c08cd02658c€24.00€0.37matched
44capture01a1a313-bdab-782b-aa58-968c3af6342e€15.00€0.26matched
45capture01a1a313-dd36-7864-9a6f-bb57dc27848d€35.00€0.50matched
46capture01a1a313-e1ae-7ee1-aa84-335a579f636d€24.00€0.37matched
47refund01a1a313-eb23-7065-9468-29b94572cacf-€10.00€0.00matched
48capture01a1a314-161e-781f-b915-93010bd181f6€35.00€0.50matched
49refund01a1a314-262a-7c51-af00-d779e13ba690-€11.00€0.00matched
50capture01a1a314-2b05-7007-83ff-87b3a143d87a€9.00€0.19matched
51capture01a1a314-323e-7058-a5a3-7dc60e83e79d€15.00€0.26matched
52capture01a1a314-439a-718b-9cff-be5b233e8133€9.00€0.19matched
53capture01a1a314-4c9c-7383-9ace-ca0e2a60e338€49.00€0.67matched
54capture01a1a314-68b6-7cd9-9227-6b22a2366c4c€9.00€0.19matched
55capture01a1a314-6c89-78e5-8326-611eb7beb9e2€15.00€0.26matched
56capture01a1a314-838a-7d7c-8abd-b510e35bce4f€35.00€0.50matched
57capture01a1a314-db70-7d55-b9a2-07e22aad4ab1€15.00€0.26matched
58capture01a1a314-e699-705c-9e3e-0bddd39f1448€9.00€0.19matched
59capture01a1a314-f4ad-7d0c-be03-51ed94b7c099€9.00€0.19matched
60capture01a1a315-03a3-7861-9166-755eebebc7c0€24.00€0.37matched
61capture01a1a315-0b13-7961-8ea6-e0090c81c21d€35.00€0.50matched
62capture01a1a315-1fb3-7943-8c08-ad6185f7e1a1€35.00€0.50matched
63capture01a1a315-225b-7bce-bf63-36b21b18cc27€35.00€0.50matched
64capture01a1a315-2ecc-718f-9690-a9606b9bb92e€15.00€0.26matched
65capture01a1a315-54a4-77dd-a41d-4dbfb6611470€35.00€0.50matched
66capture01a1a315-5bf1-7483-8937-1314187cf0d1€15.00€0.26matched
67capture01a1a315-69ce-729e-bd5a-c3cb0e2ade60€15.00€0.26matched
68capture01a1a315-7392-74f2-93e1-7b6ee3475689€9.00€0.19matched
69refund01a1a315-c9f2-7e1d-b59e-766c274dd69e-€8.00€0.00matched
70capture01a1a315-cba9-7f79-a7ec-9f1ddaf1ff73€9.00€0.19matched
71capture01a1a315-cc7f-71a2-a402-9d567fe9395b€24.00€0.37matched
72capture01a1a315-d99d-7179-8514-d4ace1ec79c3€9.00€0.19matched
73capture01a1a315-e071-76a6-9806-6d03a8ffdfbe€15.00€0.26matched
74capture01a1a315-ec27-79ca-86c8-a6c547a90d33€35.00€0.50matched
75capture01a1a315-f251-7530-94de-c182738abc25€15.00€0.26matched
76capture01a1a316-10f7-784d-bfcc-c16ade70440c€9.00€0.19matched
77capture01a1a316-4f87-7669-9c55-e4b8e550a4ef€49.00€0.67matched
78capture01a1a316-55fb-7143-84ef-601e0cff9dd3€9.00€0.19matched
79capture01a1a316-6f26-7506-8c40-dc5dde7e1b2e€15.00€0.26matched
80capture01a1a316-7b67-7631-b412-5caa5ee701d5€35.00€0.50matched
81capture01a1a316-7d95-7302-9cb4-2b7a15518f50€9.00€0.19matched
82capture01a1a316-c32e-7c47-bad9-a6d72fe28050€15.00€0.26matched
83capture01a1a316-d13d-7dab-9935-37c55fcc70c0€35.00€0.50matched
84capture01a1a316-fbca-732f-a5a1-d1a22fb46a31€24.00€0.37matched
85capture01a1a317-09d1-7a7c-8791-656423235f41€49.00€0.67matched
86capture01a1a317-0ade-7f6e-b32e-26e7268f5238€24.00€0.37matched
87capture01a1a317-0c65-78d0-b86b-5851688e7c9b€15.00€0.26matched
88capture01a1a317-1d87-7a40-86f3-4937a93a132d€35.00€0.50matched
89capture01a1a317-1f0a-768b-bdd8-246abc1799d8€15.00€0.26matched
90capture01a1a317-3110-782f-8552-bff9f221151b€35.00€0.50matched
91capture01a1a317-3628-7ccb-9138-6869b8e1474d€24.00€0.37matched
92capture01a1a317-3837-7084-b7d4-3739a5c7d7ae€35.00€0.50matched
93refund01a1a317-46ac-79c1-8256-50a2b2a5e239-€6.00€0.00matched
94capture01a1a317-540a-7676-9297-faf9160deac5€24.00€0.37matched
95capture01a1a317-5450-7387-bed6-4bc4f0657c25€24.00€0.37matched
96capture01a1a317-5e80-71aa-b7d8-299dd805a891€35.00€0.50matched
97capture01a1a317-6873-7850-bd22-3d98239ef42b€15.00€0.26matched
98capture01a1a317-787a-7c3b-8b08-8046ea1889c0€49.00€0.67matched
99capture01a1a317-8b41-78e0-b6fe-df362cd51f0f€49.00€0.67matched
100capture01a1a317-8f64-76fb-93e3-109eb332ab57€15.00€0.26matched
101refund01a1a317-a918-7a18-a145-d4c024366496-€12.00€0.00matched
102capture01a1a317-c6d8-735b-be23-7c36cc8b02bf€49.00€0.67matched
103capture01a1a317-d4c9-716b-a351-18d88845046a€49.00€0.67matched
104capture01a1a317-de66-78b2-b38a-b8c49c374a96€15.00€0.26matched
105capture01a1a318-0366-7763-a3e1-02bbfbd61586€15.00€0.26matched
106capture01a1a318-0a10-7460-b150-eb2835d5a924€9.00€0.19matched
107capture01a1a318-0aea-7631-9dbf-4c3296acf33c€24.00€0.37matched
108capture01a1a318-193c-7de7-b3e4-f4bd331d87e5€24.00€0.37matched
109capture01a1a318-2bb3-78af-9c38-fc540e3e4a69€24.00€0.37matched
110capture01a1a318-2e2d-7150-a187-225b4fd848e5€35.00€0.50matched
111capture01a1a318-328f-726b-a7a7-e2948e9c389b€24.00€0.37matched
112capture01a1a318-525e-7254-8d52-8e674c6f19e7€9.00€0.19matched
113capture01a1a318-5791-74b0-a7bc-43aa6d86222a€24.00€0.37matched
114capture01a1a318-8e31-7b76-ab89-170107f45bdb€9.00€0.19matched
115capture01a1a318-9b87-76a9-be2b-f3254f90019a€15.00€0.26matched
116capture01a1a318-9dd4-7513-8b41-790e5a587f15€15.00€0.26matched
117capture01a1a318-c244-7de3-872e-d2042a4c1554€49.00€0.67matched
118capture01a1a318-efbb-7e97-a4b3-039cc32aa68a€15.00€0.26matched
119capture01a1a318-f65b-714d-94bc-eec7889bfe20€49.00€0.67matched
120capture01a1a319-10a8-7ca4-9864-fcf6b2853034€49.00€0.67matched
121capture01a1a319-1938-7207-b4cf-e76afd13650a€9.00€0.19matched
122capture01a1a319-25ea-7c16-a12a-14b7e2b7c7d4€9.00€0.19matched
123capture01a1a319-5ae3-7117-b71b-57e7351a3fd5€9.00€0.19matched
124capture01a1a319-6468-7ea4-ba68-92dbc5e59a4b€24.00€0.37matched
125capture01a1a319-783b-7c64-b191-d6e497ed4b3e€49.00€0.67matched
126capture01a1a319-7df3-7aa9-995a-814e7b205f5b€15.00€0.26matched
127capture01a1a319-a1fb-74d1-a6f4-b540a3fec007€49.00€0.67matched
128capture01a1a319-d830-7107-aa79-fcede6f35c2d€9.00€0.19matched
129capture01a1a319-e96d-70a4-ae64-1c373ca528ef€15.00€0.26matched
130capture01a1a31a-02e2-791c-b26e-40e198045b13€24.00€0.37matched
131capture01a1a31a-14f5-767a-80a3-4bccf2a106d7€24.00€0.37matched
132capture01a1a31a-1c13-7502-a2c1-7d2bd77e6e10€24.00€0.37matched
133capture01a1a31a-2169-73e4-bb30-e78f1f9caf3f€35.00€0.50matched
134capture01a1a31a-2695-7945-b1df-e67202ccb9d0€49.00€0.67matched
135capture01a1a31a-4230-7a16-a0a4-3f85577529e8€49.00€0.67matched
136capture01a1a31a-46cd-73d6-b95a-1c3a3aebfb27€24.00€0.37matched
137capture01a1a31a-4e7e-7b24-b0db-b06268642b85€35.00€0.50matched
138capture01a1a31a-5a22-7c89-b331-a38c0ccca384€49.00€0.67matched
139capture01a1a31a-89c1-7ee1-adc3-917f8126cb10€24.00€0.37matched
140capture01a1a31a-9664-7134-b23c-1ea408b8996b€24.00€0.37matched
141refund01a1a31a-a16e-7557-bb43-d1ff62f3fbd2-€45.00€0.00matched
142refund01a1a31a-b019-7860-b1d5-43dd30e3405a-€15.00€0.00matched
143refund01a1a31a-b816-749e-b508-48892e7386f6-€9.00€0.00matched