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

Gross

€3,054.00

PSP fee

€47.74

Net to the bank

€3,006.26

Settlement journal

#374306

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a520-54ff-7d88-81e1-f6befdca63a7 is already settled by stl_EUR_2989619 line 67
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
LineKindReferenceGrossFeeStatus
34capture01a1a51e-4ba6-7492-a04d-fc613a84333b€35.00€0.54fee difference
68capture01a1a520-5518-741c-a93c-8ffd1629d6bf€9.00€0.19duplicate line
75capture01a1a520-dea3-7b11-ab5c-c6bc7e052a37€9.00€0.24fee difference
1capture01a1a513-58ee-748a-9620-e2fee1b8d578€35.00€0.50matched
2capture01a1a514-064d-746e-b9fb-35d6be2d3412€15.00€0.26matched
3capture01a1a51b-a614-7cd2-ad85-b6a040276d6f€49.00€0.67matched
4capture01a1a51b-c4e9-7527-b59e-e2076b682c3a€24.00€0.37matched
5capture01a1a51b-c9ef-764c-8306-22fabe75c86b€24.00€0.37matched
6capture01a1a51b-e2e2-7ec1-b39e-56e81727199a€9.00€0.19matched
7capture01a1a51b-f8b9-780c-b703-631c253a6599€49.00€0.67matched
8capture01a1a51c-0274-73db-a36c-d73b418fcc44€49.00€0.67matched
9capture01a1a51b-fe7f-7d45-bfb1-9f34556b9522€24.00€0.37matched
10capture01a1a51c-1b48-728f-bad4-337ca5fc4ec3€9.00€0.19matched
11capture01a1a51c-3170-7556-bab1-ff9ad87038bf€24.00€0.37matched
12refund01a1a51c-6192-7ba7-a190-49fa68f09f70-€9.00€0.00matched
13capture01a1a51c-cc18-71b5-901e-d3f3799eb2d5€35.00€0.50matched
14capture01a1a51c-d670-7c17-bbb6-75a445dd24e9€15.00€0.26matched
15capture01a1a51c-db1a-7486-9ef7-c83b195fe8e0€35.00€0.50matched
16capture01a1a51d-01c2-7de2-ad9f-c491503cf839€35.00€0.50matched
17capture01a1a51d-0329-78c0-8252-3b1d04700156€35.00€0.50matched
18capture01a1a51d-2146-7126-a9eb-c051b1d04633€35.00€0.50matched
19capture01a1a51d-21c1-7217-af7b-79422524beb3€49.00€0.67matched
20capture01a1a51d-2420-70c8-bc70-90da808c54a1€15.00€0.26matched
21capture01a1a51d-3276-7c8f-8846-1b4a977126d4€35.00€0.50matched
22capture01a1a51d-3b68-787a-9bb6-08c0fd26b7f3€24.00€0.37matched
23capture01a1a51d-4823-7353-964f-5d6dd0f17815€35.00€0.50matched
24capture01a1a51d-8719-75dc-821d-4563e5b1da28€9.00€0.19matched
25capture01a1a51d-8ed8-7a18-9ec7-354bd3be5881€9.00€0.19matched
26refund01a1a51d-9b89-7e1f-a614-0f2d4ae4f849-€13.00€0.00matched
27refund01a1a51d-b828-7152-be6f-f7c024ec7ec8-€22.00€0.00matched
28capture01a1a51d-b9c2-71aa-abd3-75e6966bad7d€24.00€0.37matched
29capture01a1a51d-ea40-7e64-911b-4bd71ee72a2d€15.00€0.26matched
30capture01a1a51d-f9a7-7696-8bc2-46c54324f583€35.00€0.50matched
31capture01a1a51e-0f36-7884-b144-c68ee59d375d€35.00€0.50matched
32capture01a1a51e-17bb-7d98-8543-7db6463a037e€35.00€0.50matched
33refund01a1a51e-2c51-713f-8569-8016a325a7b4-€21.00€0.00matched
35capture01a1a51e-5c3c-7773-91fd-3db662933c9e€49.00€0.67matched
36capture01a1a51e-6628-729a-9435-5f7229c94449€24.00€0.37matched
37capture01a1a51e-9a22-79b5-be58-7469c0f99d4f€24.00€0.37matched
38capture01a1a51e-b6eb-79dd-b1cf-83d5e417ef79€24.00€0.37matched
39capture01a1a51e-ceb8-73bc-a6cc-689f7ec46e19€15.00€0.26matched
40capture01a1a51e-cee0-7d0b-a67b-6112f0c98519€9.00€0.19matched
41capture01a1a51e-d301-7926-80ce-7bf282bc1616€24.00€0.37matched
42capture01a1a51e-ec0d-7bb5-925c-930177e3919e€9.00€0.19matched
43capture01a1a51e-f532-796a-b675-20a14ef09dcb€35.00€0.50matched
44capture01a1a51f-01fc-7106-9692-c4038acef72d€35.00€0.50matched
45capture01a1a51f-0451-7909-9184-8fa02250c38f€24.00€0.37matched
46capture01a1a51f-170f-7324-8b86-32455dabd90b€24.00€0.37matched
47capture01a1a51f-2d6d-7210-bac3-b7ef740f26f0€24.00€0.37matched
48capture01a1a51f-3a9b-76c8-8979-e56edc272da0€35.00€0.50matched
49capture01a1a51f-2f8e-7a28-8deb-6c2d574a12b1€15.00€0.26matched
50capture01a1a51f-4693-7d05-9696-8a5fa6e91072€9.00€0.19matched
51refund01a1a51f-6ca3-7599-8b2d-df7c9482c9fc-€8.00€0.00matched
52refund01a1a51f-6d02-7725-96a8-19932a419d0f-€10.00€0.00matched
53capture01a1a51f-7a98-737d-8376-72d08e2d4b02€15.00€0.26matched
54capture01a1a51f-8ac3-7492-a351-9e6d7621ac32€15.00€0.26matched
55capture01a1a51f-94d1-70f5-8a5b-8c5e19f43b09€24.00€0.37matched
56capture01a1a51f-a488-703c-a857-1554b29d3397€9.00€0.19matched
57capture01a1a51f-aeb8-7e7f-83e8-6d31653aa5c9€15.00€0.26matched
58capture01a1a51f-d720-798a-b8a7-393ec3302139€49.00€0.67matched
59capture01a1a520-02d2-7d8f-b8b0-34b5856b5e4b€15.00€0.26matched
60capture01a1a520-218e-70a6-ae60-1cd493f5b835€24.00€0.37matched
61capture01a1a520-2d99-780b-af28-67d789bf72e0€49.00€0.67matched
62refund01a1a520-32f1-70d3-a962-fa6fe2e74249-€26.00€0.00matched
63capture01a1a520-340b-7c2e-bc99-c13c47a068ae€35.00€0.50matched
64capture01a1a520-3871-7deb-837b-aeae3d0d1da0€35.00€0.50matched
65capture01a1a520-3e11-7419-a49d-c312bf6a9d67€35.00€0.50matched
66refund01a1a520-53a5-74bf-8c7c-76288dd85b24-€19.00€0.00matched
67capture01a1a520-5518-741c-a93c-8ffd1629d6bf€9.00€0.19matched
69capture01a1a520-59d8-7182-a86f-65c12ada69e9€24.00€0.37matched
70capture01a1a520-67e7-76a1-876e-93ddfafca0e8€49.00€0.67matched
71capture01a1a520-6de0-776b-8c63-c27463986f5b€15.00€0.26matched
72capture01a1a520-768a-7e11-98d3-6b5c063a2705€35.00€0.50matched
73capture01a1a520-7eb4-7b58-86aa-791d5a89864c€49.00€0.67matched
74capture01a1a520-c3ad-7672-917a-31926ddf2f50€15.00€0.26matched
76capture01a1a520-e17b-7abe-9642-c6aedaf07891€24.00€0.37matched
77capture01a1a520-ebc5-7a57-9dd2-a768e3ad5f5a€49.00€0.67matched
78capture01a1a520-f200-70c0-9afb-76254d00ad26€24.00€0.37matched
79capture01a1a521-1e56-7837-b8a5-25f515b68422€35.00€0.50matched
80capture01a1a521-2371-7624-b71c-a7dd30861128€49.00€0.67matched
81capture01a1a521-3904-7046-a17c-d3f1d60af01a€35.00€0.50matched
82capture01a1a521-418c-73b4-8320-b6e0c6c9eb7a€49.00€0.67matched
83capture01a1a521-47bd-735e-964d-cd70ac3fe441€35.00€0.50matched
84capture01a1a521-95fb-742a-affc-b522b33d3970€49.00€0.67matched
85capture01a1a521-9bf4-7972-b2b6-5231babfded4€15.00€0.26matched
86capture01a1a521-a530-78e6-9231-a001aabccea0€9.00€0.19matched
87capture01a1a521-a683-79b3-ad4c-332d793853b5€49.00€0.67matched
88capture01a1a521-c3e6-7744-8c42-63161373f77a€35.00€0.50matched
89capture01a1a521-c593-7fd4-b775-324c8840eb02€15.00€0.26matched
90capture01a1a521-f4fd-7760-bfa6-810a3a119eb8€9.00€0.19matched
91capture01a1a521-ff01-7f65-a15d-ddbe5340c2ad€15.00€0.26matched
92capture01a1a522-0f77-7bba-9f13-d5ac0f483c5a€9.00€0.19matched
93capture01a1a522-402f-72cd-bb07-98323be1c231€35.00€0.50matched
94capture01a1a522-4d9b-7098-a469-dfcb9024daf0€35.00€0.50matched
95capture01a1a522-4deb-7417-b6c4-1346e5d35d20€49.00€0.67matched
96capture01a1a522-607d-7277-ab98-aa090206eae0€15.00€0.26matched
97capture01a1a522-62bd-7b51-8691-e058235f1d13€9.00€0.19matched
98capture01a1a522-6e15-7f92-87cc-76742eadfe55€24.00€0.37matched
99capture01a1a522-83f4-7179-b09c-8e796826f5da€9.00€0.19matched
100capture01a1a522-880e-7f56-b54d-d1366a1aa105€24.00€0.37matched
101capture01a1a522-9163-74b6-abca-6577c1bbb546€35.00€0.50matched
102refund01a1a522-c718-77d4-a8fa-50eef42e6035-€7.00€0.00matched
103capture01a1a522-c895-7386-bce1-b73421f2e8bc€9.00€0.19matched
104capture01a1a522-d430-7619-b4ff-c832db65ec71€49.00€0.67matched
105capture01a1a522-e036-7678-a051-078e0972b8fb€9.00€0.19matched
106capture01a1a522-ed57-7e80-80c6-72510d760007€49.00€0.67matched
107capture01a1a522-f0f2-79c2-8baa-58da8f1abd6b€35.00€0.50matched
108capture01a1a523-00b0-72d8-85f7-3c4eb3b97b17€15.00€0.26matched
109capture01a1a523-0489-7dbf-99a7-43040dc312cc€15.00€0.26matched
110capture01a1a523-2207-7a23-9036-c22c4fb141f8€49.00€0.67matched
111capture01a1a523-322c-7ab4-95e6-70834b0120fa€9.00€0.19matched
112capture01a1a523-45f9-74e3-b5d7-7d576e74e1a9€24.00€0.37matched
113capture01a1a523-9503-7692-bdbb-d278caa0dc22€24.00€0.37matched
114capture01a1a523-9a61-770b-81b8-4ba3a832370e€49.00€0.67matched
115refund01a1a523-9b70-7fc9-a69d-8cab62ae10b5-€4.00€0.00matched
116capture01a1a523-9f87-7e27-9ce3-25eb1a40cb1f€49.00€0.67matched
117capture01a1a523-bddb-7142-931f-3844b4798c08€35.00€0.50matched
118capture01a1a523-cc3d-77cf-ad55-41bfe4209475€24.00€0.37matched
119capture01a1a523-d3e8-7f22-89ee-50d99f91bed6€49.00€0.67matched
120capture01a1a523-e1b6-7280-87f2-4afffcde38c1€24.00€0.37matched
121capture01a1a524-1ed0-7cc1-9b08-ec3c5c406743€24.00€0.37matched
122capture01a1a524-251e-75a4-bb09-c5206e2c79a7€35.00€0.50matched
123capture01a1a524-2aa7-7ed2-bd68-ff01377e8e29€24.00€0.37matched
124capture01a1a524-31e7-701f-95da-956fe0399ada€49.00€0.67matched
125capture01a1a524-6c0c-7d8d-9f9d-e3194a35c7cd€35.00€0.50matched