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

5 Nov, 17:30

Gross

€2,676.00

PSP fee

€43.20

Net to the bank

€2,632.80

Settlement journal

#401459

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1acc8-3e25-7622-a55c-9b619e66993b is already settled by stl_EUR_2989833 line 78
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
79capture01a1acc8-3e5e-75b8-baf0-25a2d5273b99€49.00€0.67duplicate line
83capture01a1acc8-6cbe-7889-8802-1dde48faf703€35.00€0.51fee difference
1capture01a1acc2-b782-7dfc-b90b-b83f6d23676b€9.00€0.19matched
2refund01a1acc2-c8b5-7a0c-996f-d6c37e79db39-€20.00€0.00matched
3capture01a1acc2-eddf-7ebd-824f-29b222e05900€24.00€0.37matched
4capture01a1acc2-f72c-7038-90ae-3b2b49b8805f€15.00€0.26matched
5capture01a1acc2-f7ce-73c9-bfbb-bfc35f3f3e3d€35.00€0.50matched
6capture01a1acc3-21cd-7455-b26b-f349fa2b78e6€24.00€0.37matched
7capture01a1acc3-3252-7028-aea0-6f7b1c60c6a4€9.00€0.19matched
8capture01a1acc3-4816-704c-85ea-c2d7f3aa5305€9.00€0.19matched
9refund01a1acc3-7528-7dcb-9886-c50fb8d755b0-€9.00€0.00matched
10capture01a1acc3-79b8-7486-a02c-4bca224d3f1f€9.00€0.19matched
11capture01a1acc3-8408-7001-8446-9fd71a64d8e4€49.00€0.67matched
12capture01a1acc3-9ba5-752b-a161-d4ed9130ca2f€9.00€0.19matched
13capture01a1acc3-9ba7-7dc7-8cc7-a7d3cef34ebc€9.00€0.19matched
14capture01a1acc3-9e4a-7330-9565-3bf9969b8b44€49.00€0.67matched
15capture01a1acc3-a783-7abc-bc82-a98353f77cea€15.00€0.26matched
16capture01a1acc3-c058-7862-847b-af81b4ab2296€15.00€0.26matched
17capture01a1acc3-dfdf-7ceb-97c2-5b3f784e1949€35.00€0.50matched
18capture01a1acc3-e061-7096-9a3d-a9c1fb9c10f0€24.00€0.37matched
19refund01a1acc3-e990-72be-8072-1c56e7ce7d79-€3.00€0.00matched
20capture01a1acc3-f9a5-7a5f-9c3a-e6867676d3c6€15.00€0.26matched
21capture01a1acc4-0afc-760c-ac0c-ff6fa58f8418€49.00€0.67matched
22capture01a1acc4-1e16-7a21-a47e-0dea102795b0€49.00€0.67matched
23capture01a1acc4-1eab-76b5-9285-a6dc4f4b9218€35.00€0.50matched
24capture01a1acc4-393f-76db-8005-789a0f24b38d€35.00€0.50matched
25capture01a1acc4-54e4-7914-a623-b549ce698ccf€15.00€0.26matched
26refund01a1acc4-56ce-7b94-bf36-4b84dc826840-€4.00€0.00matched
27capture01a1acc4-930a-7eed-b264-995acbae9d2c€49.00€0.67matched
28capture01a1acc4-95a2-7277-9c65-05ce8b63eba2€24.00€0.37matched
29capture01a1acc4-bf24-7307-baff-5e799c4b57d9€49.00€0.67matched
30capture01a1acc4-c31d-7435-8d94-52f15768da23€35.00€0.50matched
31capture01a1acc4-cc32-7d27-85ff-c601190983b6€49.00€0.67matched
32capture01a1acc5-15ab-7698-adca-34f79a7b8f1c€35.00€0.50matched
33capture01a1acc5-268f-7873-8a17-59a4f81b7ae8€9.00€0.19matched
34capture01a1acc5-2e25-7ed7-8f3b-16a14c314288€9.00€0.19matched
35capture01a1acc5-34c3-788c-abb4-818361067ccc€24.00€0.37matched
36capture01a1acc5-3960-760d-8171-0ef19d645c58€15.00€0.26matched
37capture01a1acc5-40a2-793d-876f-8c1abf3ca44c€9.00€0.19matched
38capture01a1acc5-41a0-723b-87de-de5f86212874€15.00€0.26matched
39capture01a1acc5-5cd7-7db6-87fa-c7aea745e387€35.00€0.50matched
40capture01a1acc5-5e58-7a5b-8726-94747e550ce6€35.00€0.50matched
41capture01a1acc5-6070-708f-a0fb-ff0f58001bda€49.00€0.67matched
42capture01a1acc5-82c2-7186-8c4f-244e74c09137€9.00€0.19matched
43capture01a1acc5-8777-743c-a0df-553eb07628c1€35.00€0.50matched
44capture01a1acc5-8de7-76e5-b5d6-1cb32bdc6590€9.00€0.19matched
45capture01a1acc5-968b-77fe-9c0a-30a77d0b19ce€24.00€0.37matched
46refund01a1acc5-9d20-7124-b0ec-b0d6c554cbde-€13.00€0.00matched
47refund01a1acc5-a57c-7922-8d34-ea1951e2e9ea-€13.00€0.00matched
48refund01a1acc5-cfe8-7db4-8991-1bd803608be0-€32.00€0.00matched
49capture01a1acc6-022b-7666-8aa3-53de595b7af1€15.00€0.26matched
50capture01a1acc6-1811-7790-925d-71b0e55d9b6c€15.00€0.26matched
51capture01a1acc6-362d-7588-bc45-7a210ba8150d€15.00€0.26matched
52capture01a1acc6-4016-70cd-8241-85481ad057ca€35.00€0.50matched
53capture01a1acc6-5576-7a0c-a695-441a8253a3b2€15.00€0.26matched
54refund01a1acc6-7c52-7330-8415-4d39bd91dd2d-€17.00€0.00matched
55capture01a1acc6-7dbb-78b0-a57b-adf537fa4cee€9.00€0.19matched
56capture01a1acc6-9168-7405-8d84-95f6fd1d62a6€15.00€0.26matched
57capture01a1acc6-963e-7bd3-abcd-ef53af30cdfb€49.00€0.67matched
58capture01a1acc6-b835-7cbe-9a5d-0aaa921c04da€9.00€0.19matched
59capture01a1acc6-b87c-728d-8562-d89c6556dfdd€15.00€0.26matched
60capture01a1acc6-bbe9-7bed-8724-6ef55976e5e6€24.00€0.37matched
61capture01a1acc6-cd8d-7031-9dfd-2984344ed717€49.00€0.67matched
62capture01a1acc6-ff9e-72f2-9bb9-c4d5a3a162c2€9.00€0.19matched
63capture01a1acc7-0cb9-7372-8b17-7238b28a08d1€49.00€0.67matched
64capture01a1acc7-1a8f-74d2-bf61-e0e8456cd5a0€24.00€0.37matched
65refund01a1acc7-2ca2-7f26-8269-6c21d075ba13-€7.00€0.00matched
66capture01a1acc7-4d3a-7ea1-b6cf-a3fe1ddc6ac8€15.00€0.26matched
67capture01a1acc7-5511-7417-976a-53c6c086c9a6€24.00€0.37matched
68capture01a1acc7-6e4a-71db-a776-9e8a1ce55b5f€49.00€0.67matched
69capture01a1acc7-8600-7f68-85ca-947a58002123€35.00€0.50matched
70capture01a1acc7-c9a9-79d2-92c6-569f4fc1a2dc€15.00€0.26matched
71capture01a1acc7-da81-760e-8d3f-04f92606b272€15.00€0.26matched
72capture01a1acc7-ec3c-714c-ac6c-0020cdb7ee26€9.00€0.19matched
73capture01a1acc7-fdd9-767b-b7ec-e8e305dced41€15.00€0.26matched
74capture01a1acc8-1cb2-7f88-b934-f25439ac6f3c€49.00€0.67matched
75capture01a1acc8-2561-71f7-a422-6c5b9c8b9bb1€15.00€0.26matched
76capture01a1acc8-28db-7762-b358-dcaad6d6f055€24.00€0.37matched
77capture01a1acc8-31d1-706b-a568-4914e736807f€15.00€0.26matched
78capture01a1acc8-3e5e-75b8-baf0-25a2d5273b99€49.00€0.67matched
80capture01a1acc8-4361-741b-9d4d-1bb61d6e9b3c€15.00€0.26matched
81capture01a1acc8-58a7-7465-8505-b7c54400701f€49.00€0.67matched
82capture01a1acc8-6558-713a-a2d9-0b45fd30ad0b€49.00€0.67matched
84capture01a1acc8-7fe2-75b8-85d4-2845d082162c€15.00€0.26matched
85capture01a1acc8-8408-7a2b-868b-15a411535ab6€49.00€0.67matched
86capture01a1acc8-9497-7fcf-8996-d831a3c04d76€15.00€0.26matched
87capture01a1acc8-c2b8-7a90-ba80-eb819ff751ca€15.00€0.26matched
88refund01a1acc8-c803-7310-b8de-4007161a0b75-€25.00€0.00matched
89capture01a1acc8-c84c-7d46-b7b9-799ca9cff077€15.00€0.26matched
90capture01a1acc8-d3a9-7c55-8f72-39c0a55fb2f3€35.00€0.50matched
91capture01a1acc8-eb77-7239-be95-553c4d76fba8€15.00€0.26matched
92capture01a1acc8-f1e4-729f-9528-760d255ce248€49.00€0.67matched
93capture01a1acc8-f3b9-7fb0-880d-74d2b222f9b2€15.00€0.26matched
94capture01a1acc8-fcd2-7f52-a760-33b482645ac1€24.00€0.37matched
95capture01a1acc9-1aa4-7188-9df0-4ed4dc58ba5f€35.00€0.50matched
96capture01a1acc9-29ba-7d72-884a-325b54f6ead5€15.00€0.26matched
97capture01a1acc9-38f6-7f52-a05e-6bc5d0ae7453€24.00€0.37matched
98capture01a1acc9-54d4-77c5-8f84-47e1cc5c680e€49.00€0.67matched
99capture01a1acc9-68c5-7b91-8cc0-ce8cc539eb74€35.00€0.50matched
100capture01a1acc9-6a09-79c3-8b7a-02d61742e29d€24.00€0.37matched
101capture01a1acc9-8f4f-75b1-9eeb-30081d6045d9€15.00€0.26matched
102refund01a1acc9-b807-7a3f-a042-439992cf999e-€23.00€0.00matched
103capture01a1acc9-eb90-7cd4-a830-09462bfbb10c€35.00€0.50matched
104capture01a1acca-2212-7dc0-a0cd-18a4c935f09b€35.00€0.50matched
105capture01a1acca-362a-76a9-a1e3-a98cd3849843€35.00€0.50matched
106capture01a1acca-38ef-7bff-84ab-2c7245bb3c1e€35.00€0.50matched
107capture01a1acca-46e3-7724-9698-8c787f380321€49.00€0.67matched
108refund01a1acca-899d-7975-add6-b428f3f1bbbc-€21.00€0.00matched
109capture01a1acca-a609-7d78-bae0-2480dba0bae8€15.00€0.26matched
110capture01a1acca-afea-7b4b-b529-20a1702543e3€9.00€0.19matched
111capture01a1acca-c7f9-77ea-abbc-82777a998a0c€24.00€0.37matched
112capture01a1acca-f416-79cb-89ad-5e765c67c200€35.00€0.50matched
113capture01a1accb-0fd2-747f-aedc-81ad4490327c€49.00€0.67matched
114capture01a1accb-4207-756e-8dc9-15ddb2b0e582€9.00€0.19matched
115capture01a1accb-4deb-706b-9ac3-fcfd83e5f8ad€24.00€0.37matched
116capture01a1accb-86a9-72b8-82d1-c99b4a64fd06€24.00€0.37matched
117capture01a1accb-89b9-78e8-bc88-cef39de2c2d3€35.00€0.50matched
118capture01a1accb-9824-7523-a8bc-001e2fa572f5€15.00€0.26matched
119capture01a1accb-a2e0-764b-96bd-ed147dcea370€15.00€0.26matched
120capture01a1accb-aac1-7f9d-bb33-468a88e66378€24.00€0.37matched
121capture01a1accb-c16c-793c-8e77-705bcfebab54€24.00€0.37matched