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

4 Nov, 08:40

Gross

€2,740.00

PSP fee

€43.08

Net to the bank

€2,696.92

Settlement journal

#376407

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a5b7-debf-792b-b630-40389fab24e5 is already settled by stl_EUR_2989636 line 15
  • duplicate linethe file lists it twicecapture:01a1a5bb-743f-7ddd-b402-b27caaa4f240 is already settled by stl_EUR_2989636 line 56
  • missing linein the books, not in the filerefund:01a1a5be-8757-7454-9463-7be0b507c390 is in no file
LineKindReferenceGrossFeeStatus
16capture01a1a5b7-defc-75c3-9dcc-75762c3cc12d€9.00€0.19duplicate line
57capture01a1a5bb-745e-7216-bd05-ee7c9dcd6934€49.00€0.67duplicate line
1capture01a1a5b6-12ff-7718-80de-208233a22091€24.00€0.37matched
2capture01a1a5b7-2166-7a15-84f0-bc34f1989be5€49.00€0.67matched
3capture01a1a5b7-21f7-7b09-8979-c092a682b335€35.00€0.50matched
4capture01a1a5b7-3556-7252-9573-565087aef0fb€35.00€0.50matched
5capture01a1a5b7-3718-7160-bf45-3dfdd314b642€35.00€0.50matched
6capture01a1a5b7-3e57-7a0f-a1c1-093c3bec10a7€35.00€0.50matched
7capture01a1a5b7-54e2-723e-b098-26ec75ab1ed9€24.00€0.37matched
8capture01a1a5b7-55ab-737a-a6fd-64018bc33577€15.00€0.26matched
9capture01a1a5b7-5846-7bd6-b78b-11da894ee77b€35.00€0.50matched
10capture01a1a5b7-5c44-7070-96e5-edefb257b94d€15.00€0.26matched
11capture01a1a5b7-7b51-768a-95f8-35e03a94754d€9.00€0.19matched
12refund01a1a5b7-8dd4-74cc-8397-eabb849e078d-€13.00€0.00matched
13capture01a1a5b7-abb1-78a6-8fde-c24a760370dc€15.00€0.26matched
14refund01a1a5b7-cb3d-70e6-8dab-8eb0c05f6ac5-€7.00€0.00matched
15capture01a1a5b7-defc-75c3-9dcc-75762c3cc12d€9.00€0.19matched
17capture01a1a5b7-e397-773e-904c-4f4e0460ee66€24.00€0.37matched
18capture01a1a5b8-1e29-79a7-b5e1-0a71067d2031€24.00€0.37matched
19capture01a1a5b8-2fdb-7044-995d-a1faeee62aa9€35.00€0.50matched
20capture01a1a5b8-4ac1-71f3-8e03-44a31f0c5abd€24.00€0.37matched
21capture01a1a5b8-75e0-7277-8b71-fde974e232a2€49.00€0.67matched
22capture01a1a5b8-8cc2-7dcc-999f-39def03bc461€24.00€0.37matched
23capture01a1a5b8-9744-7d9c-9ee7-7f348513cfd4€49.00€0.67matched
24capture01a1a5b8-b1a7-7a37-a305-804ccfb6d7db€24.00€0.37matched
25capture01a1a5b8-cd87-7108-9f18-8ae67085a83b€9.00€0.19matched
26refund01a1a5b8-dd88-7a47-8698-6e004bbedff3-€23.00€0.00matched
27capture01a1a5b8-ddd3-7429-98b6-bf66c77d90d1€9.00€0.19matched
28capture01a1a5b8-ee3c-7128-b971-fa9b57355b94€9.00€0.19matched
29refund01a1a5b8-fc52-794f-a2e6-12783c335df2-€37.00€0.00matched
30capture01a1a5b9-0a7c-7f50-90cf-6a6a526c9f24€9.00€0.19matched
31capture01a1a5b9-4b55-703e-93e0-be342689924f€15.00€0.26matched
32capture01a1a5b9-5089-7894-8996-aeb077ff933d€35.00€0.50matched
33capture01a1a5b9-6fd7-71bc-b0b8-a93da3c28493€35.00€0.50matched
34capture01a1a5b9-7967-7432-84c5-a8abaf2b0424€9.00€0.19matched
35capture01a1a5b9-7a4b-709f-b833-b1ed24b3b344€9.00€0.19matched
36capture01a1a5b9-7c67-7974-96a7-3d9e3aaeb8a8€15.00€0.26matched
37refund01a1a5b9-7f14-78df-b173-a65fc61b3ef4-€2.00€0.00matched
38capture01a1a5b9-87f2-7373-91cc-d8128711146f€49.00€0.67matched
39capture01a1a5b9-8ab5-78e3-bd51-b53648bc8b72€15.00€0.26matched
40capture01a1a5b9-aed7-71a6-88e0-8768fe0231a3€35.00€0.50matched
41capture01a1a5b9-cff1-752c-bc53-c822e801c166€35.00€0.50matched
42capture01a1a5b9-d836-7729-9355-e0555480dfd3€24.00€0.37matched
43capture01a1a5ba-1e45-7ddd-adc0-466aed3271ea€35.00€0.50matched
44capture01a1a5ba-4186-7077-88ed-e8dfb06133f2€24.00€0.37matched
45capture01a1a5ba-44db-777e-9e62-566f379b13f0€24.00€0.37matched
46capture01a1a5ba-6eee-756e-8024-f02a85aa58e4€24.00€0.37matched
47capture01a1a5ba-72b0-7aa7-bd28-316e969ccf64€24.00€0.37matched
48capture01a1a5ba-9a73-75b1-9c23-67bc874609d6€49.00€0.67matched
49capture01a1a5ba-a9e6-797a-a666-5ef412b047a0€35.00€0.50matched
50capture01a1a5ba-e94d-75f1-914d-b380cd8454ae€49.00€0.67matched
51capture01a1a5ba-f1fe-7c04-933e-bf6204ab8d5b€35.00€0.50matched
52capture01a1a5bb-10bc-7d83-bca4-ffd91d622a2f€9.00€0.19matched
53capture01a1a5bb-15c6-70f1-939f-01a3a9648860€9.00€0.19matched
54capture01a1a5bb-4d25-7136-a262-33eb6d0809ea€24.00€0.37matched
55capture01a1a5bb-73b6-7931-a63f-a5a5345afe0c€35.00€0.50matched
56capture01a1a5bb-745e-7216-bd05-ee7c9dcd6934€49.00€0.67matched
58capture01a1a5bb-7cbc-7d92-9b94-24b6eb83b8f0€35.00€0.50matched
59capture01a1a5bb-a638-7a96-aad2-d2a93fae34cc€24.00€0.37matched
60capture01a1a5bb-ca52-73df-bc0a-14082fd4f82c€24.00€0.37matched
61capture01a1a5bb-d23a-73a8-933a-699ce89fdeb0€35.00€0.50matched
62capture01a1a5bb-e815-7678-8aa5-d3dfa65bd043€9.00€0.19matched
63capture01a1a5bb-f0e8-727d-9770-2206115cc211€35.00€0.50matched
64capture01a1a5bb-f333-765b-ae33-213f1f3adb6c€35.00€0.50matched
65capture01a1a5bc-2a05-721c-b028-d7a5f60befd0€24.00€0.37matched
66capture01a1a5bc-36a8-7d03-80e4-716e711e36eb€24.00€0.37matched
67capture01a1a5bc-4537-7094-8f52-6ac01b82326b€9.00€0.19matched
68capture01a1a5bc-4a92-75d0-b602-cb5f9f8e7433€9.00€0.19matched
69capture01a1a5bc-5dc4-7376-a9a8-1a63c8ea6076€9.00€0.19matched
70capture01a1a5bc-747f-75cf-ac67-7adedd57678a€24.00€0.37matched
71capture01a1a5bc-83ea-7ed7-bb44-5c9197ce59c8€35.00€0.50matched
72capture01a1a5bc-9287-7ea0-a86e-40e0c7f41b23€24.00€0.37matched
73capture01a1a5bc-a5ea-76b9-8d76-0205413b10e0€24.00€0.37matched
74capture01a1a5bc-c245-7967-93d5-5d453b92144a€49.00€0.67matched
75capture01a1a5bc-d365-72ad-bc21-0e9f8530d6d0€35.00€0.50matched
76capture01a1a5bc-dbc8-70a1-9088-65d73fa7447c€15.00€0.26matched
77capture01a1a5bc-e04b-7985-ac74-b0cb5d6b39ea€35.00€0.50matched
78refund01a1a5bc-e4fc-7185-b887-2a38a001be01-€6.00€0.00matched
79capture01a1a5bd-0037-7786-a443-b446c0e4fc72€35.00€0.50matched
80capture01a1a5bd-0341-7ec3-9425-a5b1444784a6€49.00€0.67matched
81capture01a1a5bd-1f9b-7629-9428-7a5161b41cc9€24.00€0.37matched
82capture01a1a5bd-2b39-7639-818a-579115ea4b18€15.00€0.26matched
83capture01a1a5bd-3d4a-7416-a324-5169518ebcf6€24.00€0.37matched
84capture01a1a5bd-3f21-7687-a5ef-5e1a6f946d46€49.00€0.67matched
85capture01a1a5bd-400c-7bc8-8947-fabf203f1f6f€15.00€0.26matched
86capture01a1a5bd-4bda-71f7-8fce-5eb5ee941626€15.00€0.26matched
87capture01a1a5bd-867f-7732-8c85-c4a69baabb85€9.00€0.19matched
88capture01a1a5bd-8b38-71b6-8226-1b723dcb1317€24.00€0.37matched
89capture01a1a5bd-982a-767b-97f8-9dc6e73412fe€24.00€0.37matched
90capture01a1a5bd-a098-7c71-b6db-3a330abba5f0€15.00€0.26matched
91capture01a1a5bd-c008-73fa-83f7-71e59e12b301€15.00€0.26matched
92capture01a1a5bd-c26e-72f5-b522-6d03559346d3€9.00€0.19matched
93capture01a1a5bd-c42c-797d-b4c9-d50ebb9373a9€35.00€0.50matched
94capture01a1a5bd-dca6-75a4-80ca-a6364093575c€49.00€0.67matched
95capture01a1a5bd-e1d4-7336-8edd-1ebafe2e363c€24.00€0.37matched
96refund01a1a5be-03b5-7d6b-8537-e7653da28da5-€13.00€0.00matched
97capture01a1a5be-38e9-7d6c-8f18-b05929e77fdb€24.00€0.37matched
98capture01a1a5be-5b86-7d2f-87dd-148d81fec9b8€49.00€0.67matched
99capture01a1a5be-7ce6-7f93-a3e0-88be176c73c0€15.00€0.26matched
100capture01a1a5be-a231-7a1a-9bd2-6d519a7c1906€24.00€0.37matched
101capture01a1a5be-a5d8-71e7-b877-ce16871e52d9€15.00€0.26matched
102capture01a1a5be-cd99-7023-968d-28196f3966de€35.00€0.50matched
103capture01a1a5be-d33d-767d-8827-f5a985443039€9.00€0.19matched
104capture01a1a5be-db56-7951-8d35-93b73624fcbb€24.00€0.37matched
105capture01a1a5bf-0acd-741d-9ab7-c1fb801f3a5d€35.00€0.50matched
106capture01a1a5bf-2def-72c9-9e8e-00bedbce1077€24.00€0.37matched
107capture01a1a5bf-3e16-7d43-b5db-3831c26eb614€24.00€0.37matched
108capture01a1a5bf-3eb3-77fc-9d3a-9fba351106b0€15.00€0.26matched
109capture01a1a5bf-4dbf-7518-8bfb-2a3cb57b1f1a€15.00€0.26matched
110capture01a1a5bf-56a0-7807-9093-158a437591c5€24.00€0.37matched
111capture01a1a5bf-5f68-730a-95de-56d8d07f98fb€24.00€0.37matched
112capture01a1a5bf-70fd-7b59-8a0f-5583a5b4c03e€24.00€0.37matched
113refund01a1a5bf-96bc-78cb-8a1f-02cc209749f4-€11.00€0.00matched
114capture01a1a5bf-9c4a-7052-a5c0-2a22bffc1733€49.00€0.67matched
115capture01a1a5bf-f15a-74b1-bc0d-6de2a02121e7€49.00€0.67matched
116capture01a1a5bf-faf3-7ff7-9ea4-7f6f32fe422a€24.00€0.37matched
117capture01a1a5c0-1b1d-7bc6-87f6-73cf40564462€24.00€0.37matched