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, 07:50

Gross

€2,652.00

PSP fee

€41.81

Net to the bank

€2,610.19

Settlement journal

#339242

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19b44-4da0-75b6-832a-4b9c0bcee2d6 is already settled by stl_EUR_2989343 line 94
  • duplicate linethe file lists it twicecapture:01a19b45-1b46-726f-a1c4-2752f29378c5 is already settled by stl_EUR_2989343 line 102
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
LineKindReferenceGrossFeeStatus
13capture01a19b3d-fd89-74bf-8703-6c1955f5c994€9.00€0.21fee difference
95capture01a19b44-4e2d-7008-93fa-feb94ae63240€15.00€0.26duplicate line
103capture01a19b45-1b6d-748d-a5b3-ba954259440e€9.00€0.19duplicate line
1capture01a19b34-0bf0-7883-be6b-dd8e3029f1ac€9.00€0.19matched
2capture01a19b3c-a450-7638-a219-60d997231401€49.00€0.67matched
3capture01a19b3c-aa97-714c-8101-a03c03d5eb56€49.00€0.67matched
4capture01a19b3c-a085-73af-9ea6-0959cd16c2d5€49.00€0.67matched
5capture01a19b3c-ddfd-703f-a071-1be9d7a27d41€49.00€0.67matched
6capture01a19b3c-ef75-76e1-ba3e-8da43489329c€24.00€0.37matched
7capture01a19b3d-1656-7221-9a3a-8189fe546266€49.00€0.67matched
8refund01a19b3d-17de-7a14-90f0-80aaee75b98d-€42.00€0.00matched
9capture01a19b3d-1b73-74c3-b94c-c56e66fb1903€15.00€0.26matched
10capture01a19b3d-27de-7d11-aa18-5fa7cf27533b€49.00€0.67matched
11capture01a19b3d-73f9-702f-860a-c4cfd5e4790b€24.00€0.37matched
12capture01a19b3d-c947-786d-b9d6-ec48bb6c5fdd€49.00€0.67matched
14capture01a19b3d-fee0-712a-a234-bca1adaa5dc4€49.00€0.67matched
15capture01a19b3e-13f7-7bec-9fbc-d0bb0d729e59€35.00€0.50matched
16capture01a19b3e-1c1b-7330-a63d-ba2fda067c3f€15.00€0.26matched
17capture01a19b3e-31f8-7988-bf37-da7522668032€49.00€0.67matched
18capture01a19b3e-4964-78de-a1d0-accf1c924cca€9.00€0.19matched
19capture01a19b3e-6eb9-7d24-b56e-f63b64c372ef€24.00€0.37matched
20capture01a19b3e-7367-7e14-9a2e-0c7288272831€24.00€0.37matched
21capture01a19b3e-9290-7133-8629-c2c3dcbafc3d€49.00€0.67matched
22capture01a19b3e-a76a-781f-beac-40c6d68df148€9.00€0.19matched
23refund01a19b3e-ad78-7389-a6d1-d08dfdac7c31-€22.00€0.00matched
24capture01a19b3e-b3a0-7915-9169-0ee54885e236€24.00€0.37matched
25refund01a19b3e-c2db-7719-937a-83482ddbc765-€17.00€0.00matched
26capture01a19b3e-d0f1-76f5-8640-5ef21074e830€15.00€0.26matched
27capture01a19b3e-e13f-7826-bac5-30c84740c64d€35.00€0.50matched
28capture01a19b3f-1d0e-772d-a9c5-1a36da3eaa7a€35.00€0.50matched
29capture01a19b3f-236b-7a44-a8fa-67de17b4b6b3€9.00€0.19matched
30capture01a19b3f-492d-7e27-ac65-e64ed933da60€9.00€0.19matched
31capture01a19b3f-4d6a-7840-b9b6-65c22ee4a975€15.00€0.26matched
32capture01a19b3f-67e2-7f20-9a92-5e41fc134908€35.00€0.50matched
33capture01a19b3f-910e-7aa6-9d0f-f8f11deb4cd9€49.00€0.67matched
34capture01a19b3f-94fa-7796-a905-4241b32b6f3c€24.00€0.37matched
35capture01a19b3f-9dd8-77ff-b3e3-0e7d0059e7e4€15.00€0.26matched
36capture01a19b3f-ba22-7c76-92f0-f60ef002f4ef€35.00€0.50matched
37capture01a19b3f-bbe4-77e1-94d0-b7c0ee960149€35.00€0.50matched
38capture01a19b3f-c304-7312-b148-99697ff9fa70€15.00€0.26matched
39capture01a19b3f-ce8c-7021-96dd-6e8320cccb46€24.00€0.37matched
40capture01a19b3f-dbde-79d3-ba76-bf51f63c9fbc€9.00€0.19matched
41capture01a19b3f-e334-73d7-bbb6-b4ce2f3ea8a8€15.00€0.26matched
42capture01a19b40-01d0-7dbe-838d-f5b16e5b782d€49.00€0.67matched
43capture01a19b40-2af3-7c5e-9ee3-250f9890d3e8€35.00€0.50matched
44capture01a19b40-2d0c-7878-a891-637ec9cd8b0d€9.00€0.19matched
45capture01a19b40-4852-76b8-ac58-84b054ace4c8€35.00€0.50matched
46capture01a19b40-4ef8-73d4-b76d-a9960f91a8bf€49.00€0.67matched
47capture01a19b40-6a4c-7ec7-ba12-0e004bac404e€49.00€0.67matched
48capture01a19b40-6b70-7caf-8e4f-06ad5247927a€49.00€0.67matched
49capture01a19b40-6cc3-73d2-b47d-dcd5bc5fc0db€15.00€0.26matched
50capture01a19b40-904e-7145-af61-8e77b367bbc1€9.00€0.19matched
51capture01a19b40-90dd-7c2e-8829-55612882e8a5€35.00€0.50matched
52capture01a19b40-b8b4-71eb-a563-cddf10ca19c8€9.00€0.19matched
53capture01a19b40-c543-7f6a-b191-0632331977ab€9.00€0.19matched
54capture01a19b40-fb87-75e1-93fc-3daea06f6c1b€15.00€0.26matched
55capture01a19b40-fc2a-753d-9191-485832294b9b€15.00€0.26matched
56capture01a19b41-2964-7521-8861-eb0438e53b5d€15.00€0.26matched
57capture01a19b41-2d52-76cf-81da-14c7260e052f€15.00€0.26matched
58capture01a19b41-36da-7cbe-b122-ad409d8413ec€24.00€0.37matched
59refund01a19b41-534d-7ab5-9299-6379b3acbaba-€10.00€0.00matched
60capture01a19b41-6589-75d7-bbb2-8369ffbcbe65€9.00€0.19matched
61capture01a19b41-6ae5-7401-a8ca-c5649f858b42€35.00€0.50matched
62capture01a19b41-85ff-7098-8a95-cafd62b6555f€15.00€0.26matched
63capture01a19b41-8e9a-7eb2-9046-0e18c3cfada8€35.00€0.50matched
64capture01a19b41-9829-749f-9ec5-0cb37c5f7220€24.00€0.37matched
65capture01a19b41-bec4-75f6-b221-ad6aa2838bd7€9.00€0.19matched
66capture01a19b41-bf3c-71c0-96a0-4bb76dc4e3f7€35.00€0.50matched
67capture01a19b41-e6b0-71d9-8369-fe94f773acca€9.00€0.19matched
68capture01a19b41-eac9-7e7c-aaea-71bb2b2a5602€15.00€0.26matched
69capture01a19b41-f08f-7475-993f-69a60d446ca4€49.00€0.67matched
70capture01a19b41-f6c5-77f5-9b25-297a4c94ade4€35.00€0.50matched
71capture01a19b42-0298-7391-a709-3f43f154c4aa€35.00€0.50matched
72capture01a19b42-0b51-7b83-b2b1-12e995b43b09€9.00€0.19matched
73capture01a19b42-37d1-7fdc-8c51-4aa075cab64f€24.00€0.37matched
74refund01a19b42-4ec1-7403-92c8-517019fb0447-€5.00€0.00matched
75capture01a19b42-59b9-7cb2-babe-ccb2f16c625f€35.00€0.50matched
76capture01a19b42-8107-7e4b-8fe6-577718c776a1€35.00€0.50matched
77capture01a19b42-82a3-70ce-83c2-04b8373d600a€24.00€0.37matched
78capture01a19b42-97e2-7d91-b31a-777b7cf23070€49.00€0.67matched
79capture01a19b42-a7f3-7303-bbc6-c5375670ee6a€15.00€0.26matched
80capture01a19b42-b7a6-792d-bc33-f1a2c0f393e0€35.00€0.50matched
81capture01a19b43-05d5-7fd0-8f50-60b76c56aebb€49.00€0.67matched
82capture01a19b43-1496-73c2-8059-bae0d86f5ab0€24.00€0.37matched
83capture01a19b43-3547-7dbd-8b94-1122f5e2dcb5€9.00€0.19matched
84capture01a19b43-3634-7fc6-a78f-53f1bdcea6eb€15.00€0.26matched
85capture01a19b43-3a7b-7858-a217-24861107b51c€24.00€0.37matched
86capture01a19b43-3e09-7780-a08b-6a9f912879c9€15.00€0.26matched
87capture01a19b43-3ee3-7d9d-9654-2730a00c9bd3€49.00€0.67matched
88capture01a19b43-607b-778a-9e10-634d7a66d33a€9.00€0.19matched
89capture01a19b43-61ec-7d0d-a005-5500a8187e37€15.00€0.26matched
90capture01a19b43-7599-799e-8717-cc55e5c2fd8c€35.00€0.50matched
91capture01a19b43-ecc0-7052-919d-cd3fce394fc1€24.00€0.37matched
92capture01a19b44-359d-709a-a501-ad27fdc00c8d€24.00€0.37matched
93capture01a19b44-4ca2-7994-b1c4-0c646aa6bfde€15.00€0.26matched
94capture01a19b44-4e2d-7008-93fa-feb94ae63240€15.00€0.26matched
96capture01a19b44-9b89-7ff8-9b41-2cf8ced2f3b2€49.00€0.67matched
97capture01a19b44-bb25-708d-bcdc-2f69fa097a74€9.00€0.19matched
98capture01a19b44-eee5-7e08-b843-09004e80c4c8€35.00€0.50matched
99capture01a19b44-fc93-7de7-971f-5bad21d74446€35.00€0.50matched
100capture01a19b45-012a-758a-a06d-3c9e758676e2€9.00€0.19matched
101capture01a19b45-0d13-71e2-a0cc-de3a9764f091€9.00€0.19matched
102capture01a19b45-1b6d-748d-a5b3-ba954259440e€9.00€0.19matched
104capture01a19b45-23dd-74c5-b070-19d595f84d4d€15.00€0.26matched
105capture01a19b45-2c44-72da-989d-42ea9abac23a€15.00€0.26matched
106capture01a19b45-3896-772c-aaec-00b27585d52d€24.00€0.37matched
107refund01a19b45-449d-7246-90ed-202e9476cca7-€11.00€0.00matched
108capture01a19b45-559b-77ec-a0f4-1873a4d2704d€15.00€0.26matched
109capture01a19b45-5d44-7487-aeaf-2f52f77ed140€15.00€0.26matched
110capture01a19b45-741e-7c36-b6b1-f5b8e511e57b€9.00€0.19matched
111capture01a19b45-8bdb-725f-9264-994aa7a36e7c€15.00€0.26matched
112capture01a19b45-8fb3-766c-8b64-f5169a49c6b7€49.00€0.67matched
113capture01a19b45-b71a-7970-9e92-43dfb92367f9€49.00€0.67matched