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

Gross

€2,410.00

PSP fee

€39.64

Net to the bank

€2,370.36

Settlement journal

#376036

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a5a2-40ca-7890-a652-08fdfc52d5a7 is already settled by stl_EUR_2989633 line 78
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
10capture01a1a59c-0e18-7822-800d-fa816ffa40a1€9.00€0.23fee difference
79capture01a1a5a2-4161-75f6-9fdb-0ed697f72a5e€35.00€0.50duplicate line
108capture01a1a5a4-7764-744e-b779-7e57ff281207€35.00€0.51fee difference
1capture01a1a594-6f2c-7298-8529-99700db9cede€24.00€0.37matched
2capture01a1a59b-a4a0-7488-983c-d2691c57892d€35.00€0.50matched
3capture01a1a59b-ac28-7d3c-adae-305c40212597€9.00€0.19matched
4capture01a1a59b-b03b-7f3e-ace9-cda5f1aa0e3f€35.00€0.50matched
5refund01a1a59b-b83f-7d57-85db-577f7cb19261-€5.00€0.00matched
6capture01a1a59b-beb9-73fb-bc2d-6f9b0dc5eb4d€15.00€0.26matched
7capture01a1a59b-c206-73b8-a590-b5507a1bc38b€49.00€0.67matched
8capture01a1a59b-d247-74c9-ac7a-b49174596b23€35.00€0.50matched
9refund01a1a59b-fe03-7245-9cde-a15a85fffe19-€33.00€0.00matched
11capture01a1a59c-488d-71cc-80c3-c5eafacb8c1d€35.00€0.50matched
12capture01a1a59c-64cb-7617-b9f7-4c9dce0c83f4€35.00€0.50matched
13capture01a1a59c-708c-772e-994c-135db992bf29€15.00€0.26matched
14capture01a1a59c-9eb2-77ad-ba4a-3abe13becc34€35.00€0.50matched
15capture01a1a59c-ab7f-7f9d-9195-b5369a7aa6a9€35.00€0.50matched
16capture01a1a59c-aeba-7b6a-b993-695ffef02ab0€15.00€0.26matched
17capture01a1a59c-c332-73dc-9c0d-2cad98697440€49.00€0.67matched
18capture01a1a59c-dc69-7b6b-8cc9-401961854c19€24.00€0.37matched
19capture01a1a59c-f66b-7d99-8e6c-446d089d1ca5€9.00€0.19matched
20capture01a1a59d-0452-7607-9331-07318929cbe4€9.00€0.19matched
21capture01a1a59d-0808-7c9f-82e0-bb07e3d7e3c8€49.00€0.67matched
22refund01a1a59d-3d9f-7bcc-b812-298ff93f0636-€30.00€0.00matched
23capture01a1a59d-5478-7d25-ab13-8bac2f412ec8€35.00€0.50matched
24capture01a1a59d-581f-7fa4-9537-400d82d6cc31€24.00€0.37matched
25capture01a1a59d-6449-78cb-a6ba-514267d17a15€9.00€0.19matched
26capture01a1a59d-7c53-7e1b-a351-7a0bd9a2ab53€49.00€0.67matched
27capture01a1a59d-92b2-724e-a8cc-4b4dfb254dc0€9.00€0.19matched
28capture01a1a59d-e72b-7fa6-8243-8c5d92c1641d€35.00€0.50matched
29capture01a1a59d-ec71-7ba9-b1a4-dba4996e75a9€24.00€0.37matched
30capture01a1a59d-ef65-7a54-98f3-c79ba6a7832c€49.00€0.67matched
31capture01a1a59e-27b0-7d3b-b533-04af54b922d2€35.00€0.50matched
32refund01a1a59e-3ae3-77c3-b445-dca488805a9a-€30.00€0.00matched
33capture01a1a59e-3b76-73d7-be09-524a95d6ba3c€9.00€0.19matched
34capture01a1a59e-4c42-7c3a-a49c-a643f7359ef0€9.00€0.19matched
35capture01a1a59e-501e-75da-9eac-61a5ab78c83b€15.00€0.26matched
36refund01a1a59e-5f09-74f4-bbf3-b1198662d16e-€20.00€0.00matched
37capture01a1a59e-9828-7c50-a1a4-846799f39122€9.00€0.19matched
38capture01a1a59e-b0ec-7ed5-98b5-de45c097e579€35.00€0.50matched
39capture01a1a59e-e080-7038-bfc3-1600b57e9636€49.00€0.67matched
40capture01a1a59e-e806-7787-9b0f-3047c5a559c6€15.00€0.26matched
41capture01a1a59e-ef84-7586-bb6b-7d71bdba1a51€24.00€0.37matched
42capture01a1a59f-2d10-7e18-9db9-872072a14ed5€15.00€0.26matched
43capture01a1a59f-580b-7d2b-a343-3112d2720673€49.00€0.67matched
44refund01a1a59f-6c70-7e8e-aefc-011d5dba56be-€14.00€0.00matched
45capture01a1a59f-8557-70e3-aa30-cb8df09dac1b€35.00€0.50matched
46capture01a1a59f-9ae2-7c33-a344-d58fcab19f5a€35.00€0.50matched
47capture01a1a59f-ac66-7fb6-bf6e-7d3976270393€49.00€0.67matched
48capture01a1a59f-b283-765c-9319-3ec3944d14bf€15.00€0.26matched
49capture01a1a59f-b762-79a2-9e9d-a2271575f847€15.00€0.26matched
50capture01a1a59f-c367-7036-bfce-5dcfae44538a€15.00€0.26matched
51capture01a1a5a0-033f-75a5-bafe-331d2f2103c9€15.00€0.26matched
52capture01a1a5a0-0458-7ef2-8ab6-f471e908b4f0€49.00€0.67matched
53capture01a1a5a0-0aa4-7cfa-b77f-d21c0b09ce97€9.00€0.19matched
54capture01a1a5a0-1314-7410-a8ce-85839792002d€9.00€0.19matched
55capture01a1a5a0-24b9-7147-bdb9-94ed5437ac79€35.00€0.50matched
56capture01a1a5a0-2506-7303-a9e3-1dec34077d34€9.00€0.19matched
57capture01a1a5a0-4a4d-7bf2-b3f4-c47e927a3a9a€15.00€0.26matched
58refund01a1a5a0-4df2-701a-aa0e-4916b2ecdd61-€5.00€0.00matched
59refund01a1a5a0-6f92-71f8-869c-25d513e68827-€4.00€0.00matched
60capture01a1a5a0-8aa6-7893-96b5-c7b0453b0fa1€24.00€0.37matched
61capture01a1a5a0-b9b1-716a-b6e5-0f5c56e10c5d€35.00€0.50matched
62capture01a1a5a0-d157-7638-a43c-f79b3c557e74€9.00€0.19matched
63capture01a1a5a1-0a59-7431-8a0e-aaa525ed737f€15.00€0.26matched
64capture01a1a5a1-121d-70d0-9ff2-778f0d4c818f€9.00€0.19matched
65capture01a1a5a1-3add-77e5-bb44-1124d90eeb58€15.00€0.26matched
66capture01a1a5a1-441e-7ede-a4ce-a5ac28d9904a€35.00€0.50matched
67capture01a1a5a1-4ac1-73de-a710-26c5953b59b5€15.00€0.26matched
68capture01a1a5a1-4e4d-7e7b-91b2-88c7d61141dd€9.00€0.19matched
69refund01a1a5a1-7a77-709c-b9bc-1b2bc739d93a-€3.00€0.00matched
70capture01a1a5a1-8a99-7455-bf63-0c12caff73fe€35.00€0.50matched
71capture01a1a5a1-bfcc-72bf-aa9b-d8be6a38e6ff€49.00€0.67matched
72capture01a1a5a1-d89d-7601-b8b7-5002ce720c52€49.00€0.67matched
73capture01a1a5a1-e16e-71ac-926a-aeb2ceadd555€49.00€0.67matched
74refund01a1a5a2-2140-7f6f-b6e9-00bc644e73ea-€31.00€0.00matched
75capture01a1a5a2-26f9-7cb9-bf62-4a6f6266ec5a€35.00€0.50matched
76capture01a1a5a2-377f-79b8-ae6f-fb21cbfaf2bb€49.00€0.67matched
77capture01a1a5a2-3b19-7d27-8c81-780bcfa22ba7€9.00€0.19matched
78capture01a1a5a2-4161-75f6-9fdb-0ed697f72a5e€35.00€0.50matched
80capture01a1a5a2-45c1-7996-a3e6-95ccccac735f€24.00€0.37matched
81capture01a1a5a2-5a8a-78c0-b6d2-ff05f4e4bc7a€15.00€0.26matched
82capture01a1a5a2-6855-78e9-83b2-1ef0129972f2€35.00€0.50matched
83capture01a1a5a2-78b9-7677-8f37-fe94f645d37c€24.00€0.37matched
84capture01a1a5a2-7935-77cd-b55e-9bf6ac5811d6€24.00€0.37matched
85capture01a1a5a2-861e-7f34-a1fc-9ccce2f33189€9.00€0.19matched
86capture01a1a5a2-942d-736e-bf05-01cbfbae4b6e€9.00€0.19matched
87capture01a1a5a2-aabc-7883-8a9d-64937c5d0c3e€15.00€0.26matched
88capture01a1a5a2-b267-7277-94b5-2635d62f7184€24.00€0.37matched
89refund01a1a5a2-e0a5-742f-8d5b-457ad7d7aa94-€7.00€0.00matched
90refund01a1a5a3-0e1d-7401-995c-da70b6f92860-€12.00€0.00matched
91capture01a1a5a3-23d3-71d8-8911-9ae10a54816c€49.00€0.67matched
92capture01a1a5a3-4a2e-7699-898c-08880385eb0b€15.00€0.26matched
93capture01a1a5a3-5a32-7b74-bb51-acd1cf2c1cb7€15.00€0.26matched
94capture01a1a5a3-7167-7735-9c3d-a955423d6f0d€35.00€0.50matched
95capture01a1a5a3-829d-7ded-bdbd-b7785167f9f4€15.00€0.26matched
96capture01a1a5a3-cfda-7a78-8bfd-eea563576b9c€15.00€0.26matched
97capture01a1a5a3-d104-7d28-bc8a-9be2593a207b€35.00€0.50matched
98capture01a1a5a3-d6d7-74be-955c-207580cdd87e€24.00€0.37matched
99capture01a1a5a3-d8b5-71b5-a007-ebd2f5c88e5f€9.00€0.19matched
100capture01a1a5a3-e862-7bca-9970-ba15ac80e399€9.00€0.19matched
101capture01a1a5a3-f559-7002-8254-71675a1c20f5€35.00€0.50matched
102capture01a1a5a4-3335-77b5-8dcd-8343d84290b3€24.00€0.37matched
103capture01a1a5a4-346e-7be4-938f-fe2f08df0336€49.00€0.67matched
104capture01a1a5a4-5305-7aba-9b54-144a8d408b50€9.00€0.19matched
105capture01a1a5a4-5687-74dc-a5d9-52773fa340fe€15.00€0.26matched
106capture01a1a5a4-5ef6-739d-a162-a6c814e726fb€15.00€0.26matched
107capture01a1a5a4-7665-7001-b598-b5bee6e03b9a€24.00€0.37matched
109capture01a1a5a4-7a18-739e-9e63-a8b03c6a1390€24.00€0.37matched
110capture01a1a5a4-9a86-772b-ba76-22fcd0c1ffcb€35.00€0.50matched
111capture01a1a5a4-9c10-70eb-aeab-70ed2b4571a6€15.00€0.26matched
112capture01a1a5a4-b369-7f41-9755-a25b28e60fd4€35.00€0.50matched
113capture01a1a5a4-b69f-71f6-ac3c-38ef71796dca€15.00€0.26matched
114capture01a1a5a4-b82e-7fa5-b4f7-e4f9aa108690€24.00€0.37matched
115capture01a1a5a4-b91e-775e-b482-bcaa4ca538f6€15.00€0.26matched