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

3 Nov, 06:00

Gross

€2,577.00

PSP fee

€41.75

Net to the bank

€2,535.25

Settlement journal

#356242

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a006-edfd-7c8e-8e2e-34497e32fa72 is already settled by stl_EUR_2989476 line 115
  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • missing linein the books, not in the filecapture:01a19fff-d44b-7515-ba7a-c0fe1065d2e1 is in no file
  • missing linein the books, not in the filerefund:01a1a003-f1dd-7536-9f2f-b5564120b0dc is in no file
LineKindReferenceGrossFeeStatus
47capture01a1a001-9516-7bcf-ad2f-1c737214d43a€15.00€0.27fee difference
90capture01a1a004-d08a-7c35-b43f-ef7f75765b62€24.00€0.40fee difference
116capture01a1a006-f0d4-70c6-9649-c25569cecb79€15.00€0.26duplicate line
1capture01a19ffb-44ad-7be7-a595-2a83fa4ee55f€49.00€0.67matched
2capture01a19ffe-3be0-7f82-9c31-4a0358978ee9€9.00€0.19matched
3capture01a19ffe-5e55-7fd3-b0fc-165b6dbb7e81€49.00€0.67matched
4capture01a19ffe-6a7a-7aa1-b8e2-522110d255e1€49.00€0.67matched
5capture01a19ffe-8d1c-7be1-98ac-72ad4e8856ae€15.00€0.26matched
6capture01a19ffe-a03c-78d3-9f9d-f5137dcc6889€24.00€0.37matched
7capture01a19ffe-a12d-7925-898c-93900afa764e€15.00€0.26matched
8capture01a19ffe-c3dd-71a1-9d52-e5ba71ad46ab€15.00€0.26matched
9refund01a19ffe-f8ef-7b92-98a9-c3f3e3e4cb15-€4.00€0.00matched
10capture01a19ffe-fb11-78dd-be9f-745ce3ff77cb€24.00€0.37matched
11capture01a19fff-018d-73e2-9fbb-96da1128fbad€24.00€0.37matched
12capture01a19fff-039a-7365-9fa4-b5732a53054a€24.00€0.37matched
13capture01a19fff-1990-7208-b5e7-bfed74ad1f09€49.00€0.67matched
14capture01a19fff-1f2d-7ee2-8a70-b1be1feebc50€9.00€0.19matched
15capture01a19fff-27b5-7ce2-b88d-874f5e957794€24.00€0.37matched
16capture01a19fff-4d3d-7e56-a2bb-3d6c1c3bd25f€9.00€0.19matched
17refund01a19fff-59d9-71ff-b7d0-0023dd077057-€49.00€0.00matched
18capture01a19fff-6955-733f-aa91-e5314add44f2€15.00€0.26matched
19refund01a19fff-737b-725e-b3d0-99fc1d719d9f-€23.00€0.00matched
20capture01a19fff-866d-7bd5-aaa9-acd37fc37e07€24.00€0.37matched
21capture01a19fff-8c9c-7694-ab54-99091254f0aa€24.00€0.37matched
22capture01a19fff-a6c4-7e4c-826f-33510449b349€49.00€0.67matched
23capture01a19fff-b80a-7dce-ae6e-0dd5ae563682€24.00€0.37matched
24capture01a19fff-babf-76a8-9619-ff061faf626f€15.00€0.26matched
25capture01a19fff-bae6-70ac-b229-725348c75613€9.00€0.19matched
26capture01a19fff-f464-7ef2-ba02-183d015883c4€49.00€0.67matched
27capture01a19fff-fcbc-70eb-b90a-5593d0383ad6€15.00€0.26matched
28capture01a1a000-1e2a-7a04-98b2-b84e54ef7ad2€49.00€0.67matched
29refund01a1a000-22a0-7a40-9ea2-5e886fe3d52c-€29.00€0.00matched
30capture01a1a000-28db-7efe-be89-e81883f3cbe2€15.00€0.26matched
31capture01a1a000-6281-7275-98d8-898b70a50860€15.00€0.26matched
32capture01a1a000-77af-7614-a175-58b33ef3f84f€15.00€0.26matched
33capture01a1a000-8981-784d-af2b-6668edd7dfc3€9.00€0.19matched
34capture01a1a000-b732-792f-8106-a498dd93eee8€9.00€0.19matched
35capture01a1a000-e25a-7ab0-9881-3319bde8e70f€49.00€0.67matched
36capture01a1a000-f876-75cc-a57d-0649a8eccafe€15.00€0.26matched
37capture01a1a001-0283-7a8b-a5d3-086121405ce2€24.00€0.37matched
38capture01a1a001-1d0c-730b-8b81-74ed488b1ae0€24.00€0.37matched
39capture01a1a001-2920-7186-a686-37099c8cec4a€9.00€0.19matched
40capture01a1a001-3b5a-7b88-adf4-f5644fb05f4b€24.00€0.37matched
41capture01a1a001-5994-7186-a355-29f09753b42b€49.00€0.67matched
42capture01a1a001-76d4-799f-803b-769b48ed2759€15.00€0.26matched
43capture01a1a001-74b5-7fd0-ac81-6ae0b3d7cd20€9.00€0.19matched
44capture01a1a001-7f67-7c73-b7fa-7562abdc8bb4€49.00€0.67matched
45capture01a1a001-86d1-7898-811c-d1afa9ed19c7€9.00€0.19matched
46capture01a1a001-9236-795b-9acd-22a4ea707f68€9.00€0.19matched
48capture01a1a001-b1b6-7573-a385-a4a753f340ac€9.00€0.19matched
49capture01a1a001-e2b3-7273-9205-8c9385799ac1€9.00€0.19matched
50capture01a1a001-e377-7752-997b-3367e6ce9f04€35.00€0.50matched
51capture01a1a001-ea48-7e8f-bc08-49cfe083ce4c€15.00€0.26matched
52capture01a1a001-ecba-779c-8322-e59110de81cc€9.00€0.19matched
53capture01a1a002-20f1-7d3a-9d5d-d9ac79dbd438€49.00€0.67matched
54capture01a1a002-23d0-7822-9407-1b7c5b54343d€49.00€0.67matched
55capture01a1a002-25e0-7644-a56b-86c7fca12e48€35.00€0.50matched
56capture01a1a002-3403-702b-a0a9-5d9715ca58c5€24.00€0.37matched
57capture01a1a002-3d7c-70d2-8c5e-411f80c9df8c€15.00€0.26matched
58capture01a1a002-3e2a-71ba-8781-a11ece4766a5€9.00€0.19matched
59capture01a1a002-8542-7d53-a5fa-5646cd243755€9.00€0.19matched
60capture01a1a002-ae3d-7dec-a1f2-36c32f72e9ae€9.00€0.19matched
61capture01a1a002-c2cb-7782-89a3-af3419f87c91€35.00€0.50matched
62capture01a1a002-c2d8-769b-96b7-7f0557a25cfa€15.00€0.26matched
63capture01a1a002-e209-783e-ac54-9a7ef6e6301c€35.00€0.50matched
64capture01a1a002-f59d-7dbe-ac02-9308a2be9058€24.00€0.37matched
65capture01a1a002-fae4-7e39-9f0c-a1ceeaab6ef0€9.00€0.19matched
66capture01a1a003-11fc-7f37-b07d-934920ba4df9€9.00€0.19matched
67capture01a1a003-18d0-79b0-9049-598c44528976€9.00€0.19matched
68capture01a1a003-1fb8-74cc-b7ec-35489db9a7ef€35.00€0.50matched
69capture01a1a003-2b74-7fe6-83bb-5b3a8e2929a2€9.00€0.19matched
70capture01a1a003-2f78-7519-964b-8474288e80a9€49.00€0.67matched
71capture01a1a003-2b7e-770f-a862-16fa1ae88306€35.00€0.50matched
72refund01a1a003-4098-7fb7-9dc1-8dcc26482f59-€5.00€0.00matched
73capture01a1a003-5062-7d93-b02d-3833090126c4€15.00€0.26matched
74capture01a1a003-6c66-77c7-a3b3-3a5d1c558c6c€24.00€0.37matched
75capture01a1a003-7f4f-792b-9724-c97d115c95bc€35.00€0.50matched
76capture01a1a003-88e7-7964-abf5-a149f4ea1449€35.00€0.50matched
77capture01a1a003-8cb8-7832-96c9-04ba59211deb€35.00€0.50matched
78capture01a1a003-e507-7045-b129-c96ddee6ec92€35.00€0.50matched
79capture01a1a003-fda2-76ca-891a-8cb48cd8e388€15.00€0.26matched
80capture01a1a004-2c51-75fc-80c4-155a163d67ad€15.00€0.26matched
81capture01a1a004-304d-7d90-9aed-0ae16d9f9768€9.00€0.19matched
82capture01a1a004-68fe-7ab8-894b-51c075324705€35.00€0.50matched
83capture01a1a004-70d5-72f5-838e-5bc01e0a0a2b€49.00€0.67matched
84capture01a1a004-8801-780b-852f-0ff9f56cddeb€35.00€0.50matched
85capture01a1a004-a0a0-7563-9db6-c780900da481€24.00€0.37matched
86capture01a1a004-a32e-7d95-be88-b607ef1ac708€49.00€0.67matched
87capture01a1a004-a9e6-7d08-90f6-13bfa13e8fec€24.00€0.37matched
88capture01a1a004-b450-7e04-9bb4-e1d5b5fc2c47€9.00€0.19matched
89capture01a1a004-c408-70ff-9131-89dd50991f0b€24.00€0.37matched
91capture01a1a004-d296-7a53-9762-563b3b5e390a€24.00€0.37matched
92capture01a1a004-dea8-7c4b-b4c1-b09f550aca60€24.00€0.37matched
93refund01a1a004-f1c2-7e1a-8e4c-d314428e08ca-€10.00€0.00matched
94capture01a1a004-f89b-73dd-88bc-3cb595f1110d€24.00€0.37matched
95capture01a1a005-03b8-7ea5-870f-590ee2aea3ea€15.00€0.26matched
96capture01a1a005-30d5-7653-b52a-7743f3e96fcc€15.00€0.26matched
97capture01a1a005-4651-74e9-b84a-5ddce06c6330€9.00€0.19matched
98capture01a1a005-4a99-7213-ada6-84af2a9e9fcb€49.00€0.67matched
99capture01a1a005-5673-72d4-a7ba-acf14c3e11b9€9.00€0.19matched
100capture01a1a005-609f-736f-a17a-291f4909112a€24.00€0.37matched
101capture01a1a005-616c-7511-b556-51b7e7972e0c€9.00€0.19matched
102capture01a1a005-71d7-763c-8bfa-285169de8766€24.00€0.37matched
103capture01a1a005-99d4-7602-a935-e8a1b98579ca€9.00€0.19matched
104capture01a1a005-aa02-75d1-bc3a-ad463fc6a533€9.00€0.19matched
105capture01a1a005-ad2e-7592-b8b7-b5084e285a1d€49.00€0.67matched
106capture01a1a005-b338-7045-a7dc-be41a3b7f425€49.00€0.67matched
107capture01a1a006-25f7-761e-aee6-6bf08425698a€9.00€0.19matched
108capture01a1a006-2cdc-7a47-b558-1695d1032c39€24.00€0.37matched
109capture01a1a006-5a5b-7952-95b8-ce99cf9e9d39€15.00€0.26matched
110capture01a1a006-7738-7a99-8736-1fbdb06aa96d€9.00€0.19matched
111capture01a1a006-823a-7a85-a595-20a90e26a865€24.00€0.37matched
112capture01a1a006-a865-7c96-be1c-a459173a31f3€15.00€0.26matched
113capture01a1a006-ab09-7169-b919-55030022f3a6€15.00€0.26matched
114capture01a1a006-d949-7dde-97bf-3c7c98f8e6a5€35.00€0.50matched
115capture01a1a006-f0d4-70c6-9649-c25569cecb79€15.00€0.26matched
117capture01a1a006-fdbf-7f0b-aab4-b48d5a87f1e9€35.00€0.50matched
118capture01a1a007-1455-7692-96e4-efe947851088€35.00€0.50matched
119capture01a1a007-2056-76d9-8408-fb8b608ffc25€24.00€0.37matched
120capture01a1a007-25c3-7a2a-bfa6-6f6ef63ffa87€15.00€0.26matched
121capture01a1a007-430f-7d02-bdaa-ef8cc58a5476€15.00€0.26matched