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

Gross

€3,133.00

PSP fee

€49.58

Net to the bank

€3,083.42

Settlement journal

#365949

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a2c3-13bc-768f-9d4b-7f2036aa9775 is already settled by stl_EUR_2989553 line 55
  • duplicate linethe file lists it twicecapture:01a1a2c5-18f6-7265-948d-f055bd97ebaf is already settled by stl_EUR_2989553 line 95
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
LineKindReferenceGrossFeeStatus
44capture01a1a2c2-29ea-7550-a118-699e1aae95b6€35.00€0.51fee difference
56capture01a1a2c3-1439-7b51-b58d-69a44dc6c6dc€24.00€0.37duplicate line
93capture01a1a2c4-ec61-7822-b900-89a11edd8fda€24.00€0.41fee difference
96capture01a1a2c5-1934-7ab9-9fe0-8d921e23f98f€15.00€0.26duplicate line
1capture01a1a2b7-242d-739e-83fa-9a18066d1c9b€35.00€0.50matched
2capture01a1a2b8-5606-712d-9af8-f23984a970e3€15.00€0.26matched
3capture01a1a2be-3fed-76b4-9dee-a016bef3e779€9.00€0.19matched
4capture01a1a2bf-60af-7003-b600-9892ff80a33a€15.00€0.26matched
5capture01a1a2bf-762e-715b-bd5e-9485a0cd3a2f€49.00€0.67matched
6capture01a1a2bf-a145-7e84-9bf4-01032fe4d859€49.00€0.67matched
7capture01a1a2bf-d995-7a5f-bc4d-9533ba699c72€15.00€0.26matched
8capture01a1a2bf-eb79-7bb4-88c1-84547e15e5e2€15.00€0.26matched
9capture01a1a2bf-f04d-7126-ad55-9a16c4eb7526€15.00€0.26matched
10capture01a1a2bf-f65a-7f58-9a97-8459eb28e27a€35.00€0.50matched
11refund01a1a2c0-2133-7a01-ac98-98ba8cabec2a-€6.00€0.00matched
12capture01a1a2c0-2344-7594-ac46-a277f154ef54€9.00€0.19matched
13capture01a1a2c0-3b40-77c0-b0d6-2cb5e1ccc0d1€9.00€0.19matched
14capture01a1a2c0-452d-772b-9844-3875cdf05a50€49.00€0.67matched
15capture01a1a2c0-5268-76a0-86b7-ebcb06062638€24.00€0.37matched
16capture01a1a2c0-53c5-7733-92d5-5130f3f29402€35.00€0.50matched
17capture01a1a2c0-6ceb-7c03-8c11-1af815532c92€9.00€0.19matched
18capture01a1a2c0-890c-7c32-88f3-a33b21a70f91€24.00€0.37matched
19capture01a1a2c0-9765-7295-839e-8c7d682efd44€35.00€0.50matched
20capture01a1a2c0-b0aa-7d45-ab86-116455b47dfd€24.00€0.37matched
21capture01a1a2c0-bbeb-71f1-8478-5baf35dc8948€9.00€0.19matched
22capture01a1a2c0-dfad-73c1-8e40-1890f7e02566€24.00€0.37matched
23capture01a1a2c0-fa15-79e8-a05d-ee359dd498aa€24.00€0.37matched
24capture01a1a2c1-024d-78b7-a23c-bd60514cd2f7€35.00€0.50matched
25capture01a1a2c1-174e-75ae-8bc5-db8b43c81a8f€49.00€0.67matched
26capture01a1a2c1-1866-771d-b998-11acbac4d4e5€35.00€0.50matched
27capture01a1a2c1-1b2b-7b79-a32b-89bf497108a4€49.00€0.67matched
28capture01a1a2c1-1dbc-70cf-92e3-26f5a612fae8€49.00€0.67matched
29capture01a1a2c1-263d-7744-ac03-b9f057d354fe€24.00€0.37matched
30capture01a1a2c1-45a7-7bab-9dbc-5bef9d8a8e92€15.00€0.26matched
31capture01a1a2c1-557e-784c-8466-e453732c3d9b€15.00€0.26matched
32capture01a1a2c1-73bf-76f6-9716-41273afb24d5€35.00€0.50matched
33refund01a1a2c1-8144-70a3-8b14-25bd480d1798-€21.00€0.00matched
34capture01a1a2c1-9de1-7692-b082-d549e40e6690€15.00€0.26matched
35capture01a1a2c1-a8e0-7c33-b963-fa33dbb29bb0€9.00€0.19matched
36capture01a1a2c1-be79-7f8a-b58c-72b67e8510d6€24.00€0.37matched
37capture01a1a2c1-d0b3-7796-bcbe-71bd9afeaee1€35.00€0.50matched
38capture01a1a2c1-f7b3-702d-9756-4779db82289a€24.00€0.37matched
39capture01a1a2c2-01c7-715b-aae1-15dcb83f236f€9.00€0.19matched
40capture01a1a2c2-02e2-7463-b0bc-24b38446ac1a€35.00€0.50matched
41capture01a1a2c2-1a40-7ce7-b5af-24df4e1501ed€24.00€0.37matched
42capture01a1a2c2-26ee-7a02-9b60-0f2294aec3f1€15.00€0.26matched
43capture01a1a2c2-2722-79cf-a34c-5ceb54d7cac3€35.00€0.50matched
45capture01a1a2c2-530e-7127-b37e-a52428f574a4€24.00€0.37matched
46capture01a1a2c2-6e9d-7278-a880-286a29be8d70€9.00€0.19matched
47capture01a1a2c2-6fbf-7602-b461-d0465b3088db€35.00€0.50matched
48capture01a1a2c2-729e-71e5-a5a7-3a6b6ee714ee€49.00€0.67matched
49capture01a1a2c2-b074-7513-bfcb-35769c14e890€15.00€0.26matched
50capture01a1a2c2-e68d-784f-9198-bb2a65715f39€15.00€0.26matched
51capture01a1a2c2-f042-7f1f-8d79-300b59ef38ca€24.00€0.37matched
52capture01a1a2c2-f3bd-76ff-be63-4e30619a6666€15.00€0.26matched
53capture01a1a2c3-0338-737c-aed8-03cc193d0611€9.00€0.19matched
54capture01a1a2c3-0408-72b7-8c3e-cff3fae0e17b€15.00€0.26matched
55capture01a1a2c3-1439-7b51-b58d-69a44dc6c6dc€24.00€0.37matched
57capture01a1a2c3-1962-7739-8ec2-0dbc7323ac78€24.00€0.37matched
58capture01a1a2c3-1caf-72af-a942-24a04f2b080a€15.00€0.26matched
59capture01a1a2c3-223f-7297-8422-a4b3abe371ac€49.00€0.67matched
60capture01a1a2c3-405c-712e-862c-6724c8f3b594€15.00€0.26matched
61capture01a1a2c3-4add-721f-8831-587fcb5591c2€15.00€0.26matched
62capture01a1a2c3-4bae-7be4-ab2e-fbddf447af44€15.00€0.26matched
63capture01a1a2c3-550e-7d63-a95e-f6c206873d69€49.00€0.67matched
64refund01a1a2c3-572f-77ce-b0d0-8b161a477080-€4.00€0.00matched
65capture01a1a2c3-860f-743b-9bf0-cbc1e04f0558€15.00€0.26matched
66capture01a1a2c3-9a74-76ad-8a2f-f072f823aae6€49.00€0.67matched
67capture01a1a2c3-9f57-7ec7-846e-3809c5ee413a€9.00€0.19matched
68capture01a1a2c3-b74e-743f-ad5a-647b028338e0€49.00€0.67matched
69capture01a1a2c3-bb6b-7dc2-a51c-fab880a72f9b€9.00€0.19matched
70capture01a1a2c3-c9fb-7727-aee5-efc43cbefe87€24.00€0.37matched
71capture01a1a2c3-dc84-75bc-a29b-88ef29525f3d€15.00€0.26matched
72capture01a1a2c3-defb-718b-bb7d-6d1392ada798€15.00€0.26matched
73capture01a1a2c3-f9d2-7d41-b923-7ecd85b7a37e€35.00€0.50matched
74capture01a1a2c3-f9de-7552-8ebd-90328d2473dc€15.00€0.26matched
75capture01a1a2c4-038d-7144-83e9-1556e70a53c0€15.00€0.26matched
76capture01a1a2c4-05a7-7507-9421-a8a8b2ef992a€15.00€0.26matched
77capture01a1a2c4-0ca5-7da2-8808-574f0057cb82€35.00€0.50matched
78capture01a1a2c4-2214-7854-a37c-b35d44aa2aab€24.00€0.37matched
79capture01a1a2c4-27ab-77ab-864b-b796a3dd44bf€15.00€0.26matched
80capture01a1a2c4-3fe2-7286-b6bc-7d36322baf03€35.00€0.50matched
81capture01a1a2c4-46ab-75f1-b132-fcbb631f11b7€9.00€0.19matched
82capture01a1a2c4-5338-78c9-bc84-86529e665be8€24.00€0.37matched
83capture01a1a2c4-5762-7304-a73b-78c845e9985b€15.00€0.26matched
84capture01a1a2c4-8911-7f79-b76b-4f8d294f6ea6€49.00€0.67matched
85capture01a1a2c4-96ec-7740-a2a0-9e64fee2ec1d€35.00€0.50matched
86capture01a1a2c4-996b-7a48-8e86-09e5fc14cced€49.00€0.67matched
87capture01a1a2c4-9cb2-7919-821b-aa54a1d3fa0d€49.00€0.67matched
88capture01a1a2c4-af35-7da9-bab5-fd6a62143148€24.00€0.37matched
89capture01a1a2c4-badb-70f8-924a-7242a32e2858€9.00€0.19matched
90capture01a1a2c4-ca80-7cb0-a85f-cf210e59b4cf€35.00€0.50matched
91capture01a1a2c4-dc91-73fe-913d-6ce6ad7a87fe€9.00€0.19matched
92capture01a1a2c4-e7ca-7c00-902f-972008d6a27c€49.00€0.67matched
94capture01a1a2c5-13ec-7ff4-93d6-e292ac7f60a7€9.00€0.19matched
95capture01a1a2c5-1934-7ab9-9fe0-8d921e23f98f€15.00€0.26matched
97capture01a1a2c5-1cc9-7a2d-9516-03e03f85436a€24.00€0.37matched
98refund01a1a2c5-2744-756f-80ea-a6dfd335724f-€14.00€0.00matched
99capture01a1a2c5-309b-76f6-8a04-abba9c61c078€35.00€0.50matched
100capture01a1a2c5-68a7-7fd3-8046-6216ff07629a€15.00€0.26matched
101capture01a1a2c5-69a6-7439-873c-5f440e82acac€24.00€0.37matched
102capture01a1a2c5-a155-743f-a76c-976164d21a37€35.00€0.50matched
103refund01a1a2c5-ad2f-75a4-93bf-a35828e7af85-€13.00€0.00matched
104capture01a1a2c5-c3c0-7037-8e9b-0706c1ca05d2€49.00€0.67matched
105capture01a1a2c5-d005-7e7c-a507-e26adf4694ba€24.00€0.37matched
106capture01a1a2c5-d493-7791-a92c-054edfd240c3€24.00€0.37matched
107capture01a1a2c5-f45a-7087-8d5c-a8e63fbf8ba9€49.00€0.67matched
108capture01a1a2c6-01a4-77f7-9f4a-ed3a601903c3€9.00€0.19matched
109capture01a1a2c6-12f1-788d-94b0-900aa3b25058€35.00€0.50matched
110capture01a1a2c6-240d-796a-8c6c-c4add1fc944b€15.00€0.26matched
111capture01a1a2c6-3689-721a-a2a3-087168f535c6€15.00€0.26matched
112capture01a1a2c6-3bb2-7f55-b8e4-92a4e74ae98d€35.00€0.50matched
113capture01a1a2c6-446b-7d65-9397-ecd751d67975€24.00€0.37matched
114capture01a1a2c6-4e6d-7968-8448-59cf8a94e121€24.00€0.37matched
115capture01a1a2c6-56a3-753e-abf3-3bb8ac8e7c7e€49.00€0.67matched
116refund01a1a2c6-6f33-7eec-81ac-f20ce7046c30-€26.00€0.00matched
117capture01a1a2c6-744b-7aa7-9871-e11899318553€24.00€0.37matched
118capture01a1a2c6-822d-7bb2-8110-6bf56093c102€24.00€0.37matched
119capture01a1a2c6-8b6c-7002-a52c-6937fba871fd€24.00€0.37matched
120capture01a1a2c6-b9e1-722a-ad30-76fbe8c2997d€15.00€0.26matched
121capture01a1a2c6-eba6-7187-8afc-95472c2beba9€49.00€0.67matched
122capture01a1a2c7-0d78-7441-99e6-73da0373c08c€9.00€0.19matched
123capture01a1a2c7-2acb-7172-b81c-46d1e2b9c868€49.00€0.67matched
124capture01a1a2c7-2bfb-78e0-8c49-9d1182a95685€9.00€0.19matched
125capture01a1a2c7-2cc4-7ff8-93bb-86289c0efae7€49.00€0.67matched
126capture01a1a2c7-345f-7fae-9d3b-b2a2606b1f29€9.00€0.19matched
127capture01a1a2c7-3949-7aa1-bbdf-3442544fe28a€15.00€0.26matched
128capture01a1a2c7-79bf-75a1-900b-5a2a6c12b0ed€9.00€0.19matched
129capture01a1a2c7-7c60-7284-b6ae-2207c058042e€49.00€0.67matched
130capture01a1a2c7-c84d-7092-b2db-8b1f3f62bfdb€49.00€0.67matched
131refund01a1a2c7-cb46-7a37-a9c0-5f21f33dfb48-€45.00€0.00matched
132capture01a1a2c7-ce28-75ad-8587-75c352aa12fe€9.00€0.19matched
133capture01a1a2c7-d3e7-7a33-a230-10b9bc1ce20e€15.00€0.26matched
134capture01a1a2c7-d68c-742a-a346-5496fe29334d€35.00€0.50matched
135capture01a1a2c8-1891-7c1c-929f-916ff00ce161€9.00€0.19matched