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, 10:30

Gross

€2,273.00

PSP fee

€37.55

Net to the bank

€2,235.45

Settlement journal

#359639

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a0f6-12c5-7dc8-a1cc-df731336f4ec is already settled by stl_EUR_2989503 line 6
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
LineKindReferenceGrossFeeStatus
7capture01a1a0f6-130f-7a32-8f94-9296e1c01c18€9.00€0.19duplicate line
85capture01a1a0fc-6f2b-792b-bffc-f2833cb11778€35.00€0.55fee difference
1capture01a1a0f5-b263-7d73-ba70-e9eca97a2126€35.00€0.50matched
2capture01a1a0f5-f381-73dd-b173-c1f3b2c52dae€15.00€0.26matched
3capture01a1a0f5-f943-7125-8280-253eede0a2f8€15.00€0.26matched
4capture01a1a0f5-f9ca-7944-9bd6-6a327cc1228c€15.00€0.26matched
5capture01a1a0f6-03f4-71aa-aa65-e28116af6a7a€9.00€0.19matched
6capture01a1a0f6-130f-7a32-8f94-9296e1c01c18€9.00€0.19matched
8capture01a1a0f6-461d-7233-a0e8-0400ef098e9a€35.00€0.50matched
9refund01a1a0f6-4c16-7cfc-89a6-42d48ccacc70-€14.00€0.00matched
10capture01a1a0f6-745d-7bac-a0b5-55029992edce€9.00€0.19matched
11capture01a1a0f6-94fc-703a-b0a6-adb3657e5f25€49.00€0.67matched
12capture01a1a0f6-9783-7c1e-9203-0ff997178aab€49.00€0.67matched
13capture01a1a0f7-0775-73c7-a52e-7846d807dc40€9.00€0.19matched
14capture01a1a0f7-0bc4-77c5-9862-bdad63c522ee€15.00€0.26matched
15capture01a1a0f7-12f4-784a-9425-8d12c9665033€15.00€0.26matched
16capture01a1a0f7-1b54-7226-87c2-14a35d81384b€9.00€0.19matched
17capture01a1a0f7-58fa-7a24-bed3-dd5a41a9866e€9.00€0.19matched
18capture01a1a0f7-6277-7bdd-8b03-4cf4e5cc0dfa€49.00€0.67matched
19capture01a1a0f7-761a-78ba-bafc-348322f825ba€9.00€0.19matched
20capture01a1a0f7-a658-7688-8480-678d2801b97f€15.00€0.26matched
21capture01a1a0f7-b938-7677-a374-12d32cdb4ac5€35.00€0.50matched
22capture01a1a0f7-bb00-7918-a2ec-faf0adeb1f97€15.00€0.26matched
23capture01a1a0f7-c0f8-738d-8186-b7d3dc24e74a€35.00€0.50matched
24capture01a1a0f7-ce9a-7fda-b103-8418290e7345€35.00€0.50matched
25capture01a1a0f7-e567-7fb7-ab0b-5b50cb39b7fe€9.00€0.19matched
26refund01a1a0f7-ed64-73ed-ac98-1292494f3330-€29.00€0.00matched
27capture01a1a0f7-f3e7-72e8-b2f9-e15ce2a905cf€15.00€0.26matched
28capture01a1a0f8-00af-7536-8959-f5b77e9466d4€9.00€0.19matched
29capture01a1a0f8-36af-7179-9559-11b921053acc€35.00€0.50matched
30capture01a1a0f8-3aed-7dc2-be5a-8fec5fb85b1b€49.00€0.67matched
31capture01a1a0f8-4ee4-7a55-97d2-c302978efe85€9.00€0.19matched
32capture01a1a0f8-5661-79fd-81dc-8b95c6ac7946€9.00€0.19matched
33capture01a1a0f8-58d0-7980-ae42-c9be9fe8e68a€49.00€0.67matched
34capture01a1a0f8-6617-79b2-9da4-1eb480324875€49.00€0.67matched
35capture01a1a0f8-876a-7dfd-8e07-161d78a8f74f€49.00€0.67matched
36refund01a1a0f8-8afd-733e-bf6f-fdeaea50fa3d-€14.00€0.00matched
37refund01a1a0f8-9cc9-78b3-be06-0c0e6acbed9b-€44.00€0.00matched
38capture01a1a0f8-a0c9-7f49-a2b4-04b620c43555€9.00€0.19matched
39capture01a1a0f8-b47b-7308-b926-3ce54ced5df0€35.00€0.50matched
40capture01a1a0f8-bdc7-76c8-9f2b-934d0d622be5€9.00€0.19matched
41capture01a1a0f8-d4ae-7ca3-8c4e-6d0b9bca00c7€49.00€0.67matched
42capture01a1a0f8-ea8a-7eb4-8102-887fb13a9ff8€35.00€0.50matched
43capture01a1a0f9-0d51-735d-bc2f-3fdb1fc9b5ca€35.00€0.50matched
44capture01a1a0f9-1082-77fc-b2d1-dde280e582b5€35.00€0.50matched
45capture01a1a0f9-1149-7978-acd7-f20ecea99e41€9.00€0.19matched
46capture01a1a0f9-281e-74f1-8759-e4e25a24761b€9.00€0.19matched
47capture01a1a0f9-4441-769e-8f0d-b67f7bfd10d6€9.00€0.19matched
48capture01a1a0f9-5467-755c-a9e4-2a5d68a4f56b€24.00€0.37matched
49capture01a1a0f9-8db7-7388-9536-8c27705e3ca1€9.00€0.19matched
50capture01a1a0f9-91f8-7748-b07f-1a0a3370419c€35.00€0.50matched
51capture01a1a0f9-b1f6-7551-beaf-cf61351c87ea€24.00€0.37matched
52capture01a1a0f9-be9e-7550-9c82-04c5a7791453€9.00€0.19matched
53capture01a1a0f9-c392-769b-be26-00a4af6919d8€35.00€0.50matched
54capture01a1a0f9-e4bb-754a-880d-59716bcfcad1€24.00€0.37matched
55capture01a1a0f9-faa4-7648-9df6-8dcf7fc85837€9.00€0.19matched
56capture01a1a0fa-0d27-7614-8b39-9d947c3dc4a6€15.00€0.26matched
57capture01a1a0fa-0f2d-7225-80a5-4ebcebd63855€9.00€0.19matched
58capture01a1a0fa-13c1-7696-8ff2-1ffadc7260a1€15.00€0.26matched
59refund01a1a0fa-3889-70f8-b6ac-c3912242115f-€6.00€0.00matched
60capture01a1a0fa-44a0-791b-973e-d5f4fa71513e€35.00€0.50matched
61capture01a1a0fa-5be3-770e-a70b-837d3f6069d5€24.00€0.37matched
62capture01a1a0fa-8407-71d1-bfcf-faf6450507be€49.00€0.67matched
63capture01a1a0fa-9159-74ec-8da1-242f27c6369c€9.00€0.19matched
64capture01a1a0fa-a9ed-7bb1-96cd-5817a94587f1€49.00€0.67matched
65refund01a1a0fa-b83a-7127-98a4-994d4014564e-€25.00€0.00matched
66capture01a1a0fa-cf42-74de-b5e0-24fe77c66a77€49.00€0.67matched
67capture01a1a0fa-cd32-7c80-b6b1-e1670ca7363b€9.00€0.19matched
68capture01a1a0fb-0be3-779b-af82-7946b13cb5f7€35.00€0.50matched
69capture01a1a0fb-3378-7387-8846-5bf5f68fa252€15.00€0.26matched
70capture01a1a0fb-4f96-7503-b374-172b3f7c3381€9.00€0.19matched
71capture01a1a0fb-941e-7bd6-b48e-e76fd0409249€24.00€0.37matched
72capture01a1a0fb-a9f6-7710-85c0-20268352effc€9.00€0.19matched
73capture01a1a0fb-c3c3-7220-84e8-1b63285185f9€9.00€0.19matched
74capture01a1a0fb-d0ea-7eea-b762-31665f035afb€24.00€0.37matched
75refund01a1a0fb-ea94-74ce-bc95-f7755a7e8ca6-€13.00€0.00matched
76capture01a1a0fb-ecda-70d9-ab28-d56f6a8bcc31€15.00€0.26matched
77refund01a1a0fc-0247-7a2e-b637-afd7ac6b89fe-€6.00€0.00matched
78capture01a1a0fc-0547-7828-bd74-2089a16011c3€15.00€0.26matched
79capture01a1a0fc-24e6-790d-969a-ec0b5489d52a€35.00€0.50matched
80capture01a1a0fc-3a1e-7a5b-911a-ddad594c072e€24.00€0.37matched
81capture01a1a0fc-3bcd-7c75-a249-b6a0503fde66€35.00€0.50matched
82capture01a1a0fc-40dd-7759-b58b-55dcd74ef176€24.00€0.37matched
83capture01a1a0fc-543f-7f90-9e17-7ded518629e0€49.00€0.67matched
84capture01a1a0fc-6a73-7ee5-b6c5-b872e0b449b5€15.00€0.26matched
86capture01a1a0fc-6fd1-767c-81aa-fa5d20fbed54€15.00€0.26matched
87refund01a1a0fc-7399-7f84-a435-cd17171fab1f-€4.00€0.00matched
88capture01a1a0fc-7c10-7988-b512-13e27c2a62c7€35.00€0.50matched
89refund01a1a0fc-88af-786a-8ee8-2772fb013e0c-€14.00€0.00matched
90capture01a1a0fc-8e1f-7cec-a2b1-1fcad110209e€35.00€0.50matched
91capture01a1a0fc-94eb-7f98-aef5-b8deecc7bf92€49.00€0.67matched
92capture01a1a0fc-a3ae-7b96-aef7-e13b4ec66e05€9.00€0.19matched
93capture01a1a0fc-b33a-74d4-bb6b-7dc6b61d1363€35.00€0.50matched
94capture01a1a0fc-df44-7641-a98f-991f9fc29427€9.00€0.19matched
95capture01a1a0fc-fe7e-75bb-94a2-37444b8aef54€24.00€0.37matched
96capture01a1a0fd-491a-77f9-8d99-91a894b1d1d8€24.00€0.37matched
97capture01a1a0fd-5a75-7789-ba0f-03147115d984€24.00€0.37matched
98capture01a1a0fd-5b41-79a1-b10e-95fbb0c46587€15.00€0.26matched
99capture01a1a0fd-6957-7e05-b3cd-5ce96fdc0e20€35.00€0.50matched
100capture01a1a0fd-69eb-758f-ba5f-15923e71c608€15.00€0.26matched
101capture01a1a0fd-87c8-77f8-bef2-f00c8d076976€24.00€0.37matched
102capture01a1a0fd-9549-7807-a9da-83c1c70c3e9a€15.00€0.26matched
103capture01a1a0fd-a95f-7524-86bd-cb3c7bd2e199€15.00€0.26matched
104capture01a1a0fd-b62a-7574-949d-a5048d49ad1a€24.00€0.37matched
105capture01a1a0fd-b62b-7727-98f8-f79b7a741562€49.00€0.67matched
106capture01a1a0fd-d436-7098-9a02-c8043600c601€35.00€0.50matched
107capture01a1a0fd-fa49-7f31-a101-844ecb4103ce€15.00€0.26matched
108capture01a1a0fe-01fb-73b1-956e-a887dc7bdbee€49.00€0.67matched
109capture01a1a0fe-404a-7344-80c6-f7343b6dda6a€49.00€0.67matched
110capture01a1a0fe-5ca5-7c00-a2e0-0069cdb0b9d7€15.00€0.26matched
111capture01a1a0fe-7057-74ef-b30c-535ecd4be351€9.00€0.19matched