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

Gross

€2,890.00

PSP fee

€46.90

Net to the bank

€2,843.10

Settlement journal

#337379

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19abb-7ea7-772e-8e1a-a13e022ca809 is already settled by stl_EUR_2989328 line 114
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
13capture01a19ab4-0389-7d51-ba1a-9e0f96b1c2bf€24.00€0.40fee difference
19capture01a19ab4-97c7-72e7-852d-a46e029fdd80€35.00€0.51fee difference
115capture01a19abb-8c98-7325-a7e7-f29e01454280€35.00€0.50duplicate line
1capture01a19ab3-158f-7567-af09-611d78834de4€24.00€0.37matched
2capture01a19ab3-5976-77bb-9fdb-59682d0df7e2€15.00€0.26matched
3capture01a19ab3-65ea-7220-a20f-ccb93224d95c€15.00€0.26matched
4capture01a19ab3-6d05-7d90-9322-f05593f9bd13€15.00€0.26matched
5capture01a19ab3-70f9-75cc-bd35-5375f2ba06b3€35.00€0.50matched
6capture01a19ab3-8259-79d5-8989-c23b81e48a68€35.00€0.50matched
7capture01a19ab3-8265-79f2-8920-9c01de1a1e13€9.00€0.19matched
8capture01a19ab3-8d2c-7480-84e7-994ab45f87e0€49.00€0.67matched
9capture01a19ab3-96b7-7fca-a4f6-17d2fb636cf1€35.00€0.50matched
10capture01a19ab3-9f1d-7a4b-9671-d572646de111€49.00€0.67matched
11refund01a19ab3-bbf5-792e-930b-686ab43add02-€40.00€0.00matched
12capture01a19ab3-fa7b-73c2-8604-ea1f25f8d745€24.00€0.37matched
14capture01a19ab4-09be-78e1-93a5-44762d9845b2€35.00€0.50matched
15capture01a19ab4-2864-7381-87c5-a6beeb2ad307€15.00€0.26matched
16capture01a19ab4-5cdc-71e4-b5a4-ade5138f28b9€49.00€0.67matched
17capture01a19ab4-7459-7ba4-ba4e-b6c6040427ed€24.00€0.37matched
18capture01a19ab4-8d0a-77c6-990c-e9c368f4feee€9.00€0.19matched
20capture01a19ab4-982b-77d9-b97a-0b6acc3112f0€15.00€0.26matched
21capture01a19ab4-cf0e-7ab3-8fbd-8e9cc97be48b€35.00€0.50matched
22refund01a19ab4-d9c7-702e-90e5-35bb3f27b544-€22.00€0.00matched
23capture01a19ab4-db5f-7659-bf1f-3179bdd4b756€35.00€0.50matched
24capture01a19ab4-e0f8-76c9-be2c-633ce0053814€15.00€0.26matched
25capture01a19ab4-e953-7ecb-9adc-f7dc0b531e03€9.00€0.19matched
26capture01a19ab4-fb18-7443-be62-d102403909c9€15.00€0.26matched
27capture01a19ab5-2b9b-727d-9fca-6bd741df849b€24.00€0.37matched
28capture01a19ab5-4a9d-78e5-851c-9a55e764276d€9.00€0.19matched
29capture01a19ab5-5dd9-7039-b808-b383f817aff5€49.00€0.67matched
30capture01a19ab5-6839-7fad-999d-a3448c2d8bb2€15.00€0.26matched
31capture01a19ab5-7155-79d9-b45e-9577a4eb446b€15.00€0.26matched
32capture01a19ab5-9401-7dca-bbcb-d031e7797dbb€24.00€0.37matched
33refund01a19ab5-9e7a-72f5-8264-f584d3863ba3-€14.00€0.00matched
34capture01a19ab5-b2cf-7edf-99a6-a646494e9286€9.00€0.19matched
35capture01a19ab5-c6b6-753c-9cc5-2759636c7f10€9.00€0.19matched
36capture01a19ab5-c726-7121-b66d-20517cd05a9e€49.00€0.67matched
37capture01a19ab5-ccff-73ec-b503-2777b58d523c€24.00€0.37matched
38capture01a19ab5-e218-7c63-9d2c-ca412723717c€24.00€0.37matched
39capture01a19ab5-edc7-7f4e-ba3c-c3cb05f6d06a€35.00€0.50matched
40capture01a19ab6-1011-76bf-bb7e-76c50b8a38c8€35.00€0.50matched
41capture01a19ab6-1f09-7407-ad9d-095d29f56024€24.00€0.37matched
42capture01a19ab6-4283-7472-ab9c-d16cf61722f3€24.00€0.37matched
43capture01a19ab6-6bd3-7d18-9228-7b55edfd5764€49.00€0.67matched
44capture01a19ab6-6c44-76c4-b107-6c08b2d1b6b6€24.00€0.37matched
45capture01a19ab6-78ad-72fb-9242-4d853a528ede€49.00€0.67matched
46capture01a19ab6-9718-7ddf-803b-aa614101ab9d€49.00€0.67matched
47capture01a19ab6-cfad-7073-9e27-10dc077625c4€15.00€0.26matched
48capture01a19ab6-d3be-7876-a8e7-39244c4f3ab6€9.00€0.19matched
49capture01a19ab6-f59c-7097-8545-50fbbf0df902€15.00€0.26matched
50capture01a19ab7-0265-7242-b278-5d02b9f9c6be€35.00€0.50matched
51capture01a19ab7-3616-7404-a3a4-a5b86d509972€35.00€0.50matched
52capture01a19ab7-4e8f-7202-b3a4-1cfef39fc9f2€35.00€0.50matched
53capture01a19ab7-5f4a-7237-8e89-11b09807612f€24.00€0.37matched
54capture01a19ab7-8757-76f6-be2d-c8ac90ed95b9€9.00€0.19matched
55refund01a19ab7-8d4a-74bc-b6d1-8dcee76878df-€6.00€0.00matched
56capture01a19ab7-9e9a-7fbe-a6ce-0faa38ef9ac5€24.00€0.37matched
57capture01a19ab7-afb0-7c94-b8e6-5233518c7ec1€9.00€0.19matched
58capture01a19ab7-d979-7734-a4fe-7985209d7f04€35.00€0.50matched
59capture01a19ab8-074e-7672-9cdd-dca14593b59c€35.00€0.50matched
60capture01a19ab8-1d34-7923-8469-d04697a6c41d€24.00€0.37matched
61capture01a19ab8-2413-7ca0-aab0-51e0bb941d02€9.00€0.19matched
62capture01a19ab8-2a25-718e-87c2-6162de208f31€15.00€0.26matched
63capture01a19ab8-2aff-7dd6-88a3-af12a3fc9e5c€35.00€0.50matched
64capture01a19ab8-3ed5-7ef6-b1ac-8e7c0972506f€9.00€0.19matched
65capture01a19ab8-539f-7fd5-864e-0a22db8cb6e3€9.00€0.19matched
66capture01a19ab8-7bbc-7dfc-8fe6-d0b0ad3be4fb€15.00€0.26matched
67capture01a19ab8-8376-7864-a34b-83a00bb4652f€9.00€0.19matched
68refund01a19ab8-84c7-71d4-90f5-b2dd1153cee5-€8.00€0.00matched
69capture01a19ab8-96f0-741e-91ea-d7c2cd261e6e€15.00€0.26matched
70capture01a19ab8-9cc6-774c-9c9a-e5acbbac2cd0€35.00€0.50matched
71capture01a19ab8-a165-7050-84ad-c90aca45e5c4€9.00€0.19matched
72capture01a19ab8-a18e-7f8d-9e71-3d7dece7f688€24.00€0.37matched
73capture01a19ab8-d0a6-7979-b0a8-031a16119977€35.00€0.50matched
74capture01a19ab8-d408-75bd-96e9-24604e3b4050€49.00€0.67matched
75capture01a19ab8-eb5d-7106-b492-386312cb53d5€49.00€0.67matched
76refund01a19ab9-1333-7141-87e7-ae5de8ed17a2-€16.00€0.00matched
77capture01a19ab9-1f58-790f-b684-64a5813cdb80€35.00€0.50matched
78refund01a19ab9-21c1-7707-b41b-0de556c46579-€23.00€0.00matched
79capture01a19ab9-2a27-7677-9678-bb4aeee5b1f7€35.00€0.50matched
80capture01a19ab9-2e16-79f0-8ea2-6d5b5afdc517€24.00€0.37matched
81capture01a19ab9-3290-753f-9b41-b2a7d0c08eb5€24.00€0.37matched
82capture01a19ab9-49f4-7a2b-8466-d02bcf1c60e1€35.00€0.50matched
83capture01a19ab9-4ac0-7bec-9d17-53042bbdf679€35.00€0.50matched
84capture01a19ab9-4d73-7289-a8ed-068983177ee3€35.00€0.50matched
85refund01a19ab9-6afa-7e88-90c7-abd6ee2a185d-€23.00€0.00matched
86capture01a19ab9-70c6-7db8-9179-3d89bc0cdb13€35.00€0.50matched
87refund01a19ab9-7d7c-7a35-bf42-295e485f45a8-€28.00€0.00matched
88refund01a19ab9-7e4c-7f56-b9e3-58bfe534f524-€9.00€0.00matched
89capture01a19ab9-8583-7576-8ad0-f669a247182b€49.00€0.67matched
90capture01a19ab9-c477-7315-b5db-da72a80b956f€15.00€0.26matched
91capture01a19ab9-dc64-7ff3-9407-4647f91b58c4€49.00€0.67matched
92capture01a19ab9-dc75-72ee-9bba-35988076b014€15.00€0.26matched
93capture01a19ab9-e16f-7e2a-ade3-a57f2505e3f4€49.00€0.67matched
94capture01a19ab9-e7ef-7016-8dcf-74127033916b€49.00€0.67matched
95capture01a19aba-323f-7b88-8c5f-fa27de745e68€15.00€0.26matched
96capture01a19aba-32de-7468-996f-6bcad10dadca€9.00€0.19matched
97capture01a19aba-40e0-7f1b-bf18-769b90b4d5e7€24.00€0.37matched
98capture01a19aba-710a-7e06-bf84-ca8cc5640b75€49.00€0.67matched
99capture01a19aba-a266-719b-9cd2-be8dc7a2980d€35.00€0.50matched
100capture01a19aba-a429-7254-821c-019d057e91d1€15.00€0.26matched
101capture01a19aba-cbcb-7e73-94ef-f67f783781ec€9.00€0.19matched
102capture01a19aba-f66c-7590-ad68-777028cc4307€9.00€0.19matched
103capture01a19aba-ffea-7006-a726-247537f83145€9.00€0.19matched
104capture01a19abb-1641-780a-a46c-d30e2d6d91d2€24.00€0.37matched
105capture01a19abb-1d33-732c-b509-3c9104f97461€35.00€0.50matched
106capture01a19abb-1d53-7ca5-b537-014aa701269c€9.00€0.19matched
107capture01a19abb-1e8d-7127-a753-3d64fd97c89e€15.00€0.26matched
108capture01a19abb-32bc-76fe-b326-25347aed231a€15.00€0.26matched
109capture01a19abb-3830-7ea4-8e86-f756df27731c€9.00€0.19matched
110capture01a19abb-3ee2-706e-8fca-3f9e439ae98c€24.00€0.37matched
111capture01a19abb-5ece-7893-a089-f2e93942e6ca€35.00€0.50matched
112refund01a19abb-62ee-7d12-af4a-99fb73a50fcc-€3.00€0.00matched
113refund01a19abb-85f7-7b7d-a391-face49639c7a-€12.00€0.00matched
114capture01a19abb-8c98-7325-a7e7-f29e01454280€35.00€0.50matched
116capture01a19abb-8f0c-7d18-b1b9-dc299ab7a1fd€35.00€0.50matched
117capture01a19abb-993b-7378-ace5-1c323e1c0ba6€49.00€0.67matched
118capture01a19abb-9a03-725d-be0b-5604243193cd€24.00€0.37matched
119capture01a19abb-9e32-7788-9fef-c398fd4c5396€15.00€0.26matched
120capture01a19abb-b4c0-7ea2-a4a1-83b9fed0f313€24.00€0.37matched
121capture01a19abb-bf45-70d5-94d2-954ad6eb4056€24.00€0.37matched
122capture01a19abb-c050-772f-b9bd-1011f48246c6€15.00€0.26matched
123capture01a19abb-ee08-7dca-955d-27acb73abb81€15.00€0.26matched
124capture01a19abb-f357-7039-b670-9f86e59527a5€9.00€0.19matched
125capture01a19abc-0539-7bea-add4-4e43afe45e39€24.00€0.37matched
126capture01a19abc-0af1-7251-864f-84af55432ebf€9.00€0.19matched
127capture01a19abc-18db-74d6-b736-dc1f6da707da€15.00€0.26matched
128capture01a19abc-3315-7e19-880b-00e2d3bdb5e4€49.00€0.67matched
129capture01a19abc-3aad-795e-b5fb-cb53e21fb70f€24.00€0.37matched
130capture01a19abc-4c6a-7ed4-8534-b445baae402a€24.00€0.37matched
131capture01a19abc-55b1-799c-adc3-416f107f335a€15.00€0.26matched
132capture01a19abc-5b80-7628-a888-a147a9d54d0e€49.00€0.67matched