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

Gross

€2,464.00

PSP fee

€38.11

Net to the bank

€2,425.89

Settlement journal

#356107

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19ff7-9db0-75cc-a062-06c713ac867f is already settled by stl_EUR_2989475 line 32
  • duplicate linethe file lists it twicecapture:01a19ff8-2f2c-7d35-a277-95a640f59d84 is already settled by stl_EUR_2989475 line 37
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
LineKindReferenceGrossFeeStatus
33capture01a19ff7-b68d-7ce6-a5e1-0e209a366d82€24.00€0.37duplicate line
38capture01a19ff8-2f41-7e7c-9232-bd8a6a328cb1€24.00€0.37duplicate line
84capture01a19ffc-98ff-7dcb-a116-b475ec91a640€9.00€0.20fee difference
1capture01a19ff0-9c87-7422-af48-17b7be70ee3f€24.00€0.37matched
2capture01a19ff5-342c-7268-ae32-5c61c0743ccd€35.00€0.50matched
3capture01a19ff5-44e1-72eb-9392-65f00bf0b775€15.00€0.26matched
4capture01a19ff5-4a4f-753d-9ed7-bdfebac58208€9.00€0.19matched
5capture01a19ff5-5d21-7fe3-9903-e677669da3ad€35.00€0.50matched
6capture01a19ff5-6867-7bb0-aef2-2f5cfaa1fcc5€9.00€0.19matched
7capture01a19ff5-99d0-7e63-9573-60d89c97396c€15.00€0.26matched
8capture01a19ff5-cc94-7277-b4c6-272f79b29614€49.00€0.67matched
9capture01a19ff5-dca8-7cb0-8369-067bfeb5f990€35.00€0.50matched
10capture01a19ff6-0c03-7d78-b74a-024ea9f60d4e€49.00€0.67matched
11capture01a19ff6-0dcc-7c95-aa93-173ac22d58f6€35.00€0.50matched
12capture01a19ff6-162c-7056-b514-ddd04eae42de€49.00€0.67matched
13capture01a19ff6-4369-70a4-a07d-168cb5a6ce26€15.00€0.26matched
14refund01a19ff6-4c93-7992-be94-575409872697-€46.00€0.00matched
15capture01a19ff6-6ddd-75e2-ba0b-8f859ff04415€35.00€0.50matched
16capture01a19ff6-8090-7bc4-b492-6d02c6775a13€24.00€0.37matched
17capture01a19ff6-99ec-7e08-a4f1-78c5c493f3dd€9.00€0.19matched
18capture01a19ff6-b249-7dd8-9429-9deb17a08e3a€49.00€0.67matched
19capture01a19ff6-b9e4-770e-acc5-f873c8ac3791€35.00€0.50matched
20capture01a19ff6-b58e-7f9a-a366-3e7abd010a43€24.00€0.37matched
21capture01a19ff6-c86c-73c1-b391-1d09dda9296d€15.00€0.26matched
22capture01a19ff6-d466-7805-9803-9b16590c58ca€49.00€0.67matched
23capture01a19ff6-d7d9-77c5-b370-e6f2bf67cb96€49.00€0.67matched
24capture01a19ff6-d966-722f-9357-f9ce4673d1a1€15.00€0.26matched
25capture01a19ff6-fafd-787a-9598-454fd3a279cd€35.00€0.50matched
26refund01a19ff7-0f5e-71ef-91c6-7a309f665d77-€9.00€0.00matched
27capture01a19ff7-29a3-7b3d-8562-55d76aa5d301€24.00€0.37matched
28capture01a19ff7-771d-73b8-a16f-9906bdc08d99€15.00€0.26matched
29capture01a19ff7-90b3-786d-951e-4a1b33c195e8€49.00€0.67matched
30capture01a19ff7-a5cd-75fe-a2fe-cc566b254017€49.00€0.67matched
31capture01a19ff7-ae69-71ad-8f9a-7711ee53d721€9.00€0.19matched
32capture01a19ff7-b68d-7ce6-a5e1-0e209a366d82€24.00€0.37matched
34capture01a19ff7-dca0-79fc-957b-9d4ff80bd753€15.00€0.26matched
35capture01a19ff7-f9f7-76e2-adec-c5d6e8df0d1a€15.00€0.26matched
36capture01a19ff8-0825-79ba-9079-e1421acedba2€9.00€0.19matched
37capture01a19ff8-2f41-7e7c-9232-bd8a6a328cb1€24.00€0.37matched
39capture01a19ff8-2fef-7f62-a3f1-7ae020ac1625€24.00€0.37matched
40capture01a19ff8-523c-7bc1-8cdb-55f2c4a50e3e€35.00€0.50matched
41capture01a19ff8-55c9-7c93-9603-c3b41a72a726€35.00€0.50matched
42capture01a19ff8-60df-7482-815d-8e03a6cbfcc4€24.00€0.37matched
43capture01a19ff8-7441-775b-a9cd-98039f7aa291€24.00€0.37matched
44capture01a19ff8-756d-7048-b452-e345c696bf66€35.00€0.50matched
45capture01a19ff8-78de-7fac-a6f5-f93823ee9d90€49.00€0.67matched
46capture01a19ff8-9fa9-7533-9f66-ddef4d8443ea€9.00€0.19matched
47capture01a19ff8-c68d-7aa5-83c3-33ffe71af9f6€49.00€0.67matched
48capture01a19ff8-d9ee-73c5-8e6a-96f680a7e806€35.00€0.50matched
49capture01a19ff8-df04-785b-af3e-e029ae6547b4€9.00€0.19matched
50capture01a19ff9-0825-7a1e-94f5-f33e0cc14aa5€24.00€0.37matched
51capture01a19ff9-3353-79ca-861b-9ea3fdeef044€35.00€0.50matched
52capture01a19ff9-3a4d-761e-825f-b8b8612b0627€15.00€0.26matched
53capture01a19ff9-5e1c-736f-bfb8-2d2c7fdebe74€9.00€0.19matched
54capture01a19ff9-7311-7e8a-9fab-008a425c698b€15.00€0.26matched
55capture01a19ff9-8cad-7edc-9125-2760fb4ce04b€24.00€0.37matched
56capture01a19ff9-9bce-7c64-81eb-046c6d5b1414€49.00€0.67matched
57capture01a19ff9-c48c-7e3e-b47b-5120857c64fb€35.00€0.50matched
58capture01a19ff9-f708-779e-8ecc-a1a4feba83b1€9.00€0.19matched
59capture01a19ffa-09ac-7c18-a524-8fe6b51c72b7€49.00€0.67matched
60capture01a19ffa-15a5-7fe4-a40e-145fd6d3645b€24.00€0.37matched
61capture01a19ffa-1dbb-707a-9174-a21b74554b7d€24.00€0.37matched
62capture01a19ffa-218a-78cb-817a-c9ead6066a54€15.00€0.26matched
63capture01a19ffa-3515-7405-8679-33a2f44a381a€9.00€0.19matched
64capture01a19ffa-35bc-7999-8a11-f0cf83ee803a€15.00€0.26matched
65capture01a19ffa-4e84-7353-bf1a-524b478c28f2€9.00€0.19matched
66capture01a19ffa-e4e2-7f30-8777-c3a80167c085€24.00€0.37matched
67capture01a19ffa-e957-7d83-9b92-c66e17ee6609€49.00€0.67matched
68capture01a19ffb-0bde-75bc-affe-2a9e8a1ac31f€35.00€0.50matched
69capture01a19ffb-1748-77b6-bbc7-8d37daee3ccf€9.00€0.19matched
70capture01a19ffb-1c3e-73a3-af7d-f5b047e049f5€49.00€0.67matched
71capture01a19ffb-2382-7f06-bda7-c0f5524804dd€49.00€0.67matched
72capture01a19ffb-2c42-720d-90a4-69530c01038d€49.00€0.67matched
73capture01a19ffb-4d4d-763f-b2ec-a9ca1ba2b43a€24.00€0.37matched
74capture01a19ffb-5997-7e32-8a8b-8724acdb6cf5€9.00€0.19matched
75capture01a19ffb-9e3d-702b-aaef-b9ac040e3509€24.00€0.37matched
76capture01a19ffb-b820-7ef4-aea4-58c01ad8717a€15.00€0.26matched
77capture01a19ffb-cd28-7332-bae9-e42783108234€24.00€0.37matched
78capture01a19ffb-e1e0-7524-8408-308bb9061914€15.00€0.26matched
79capture01a19ffb-ed7c-75cc-a06d-7961517486d9€15.00€0.26matched
80capture01a19ffc-08e5-740a-b17b-079c6fb8dc27€9.00€0.19matched
81refund01a19ffc-1112-7f89-b126-fb4c958627be-€6.00€0.00matched
82capture01a19ffc-56e0-771c-af64-0ff0c1de7af3€9.00€0.19matched
83capture01a19ffc-6237-77b5-ac5b-cdb83e6a8286€24.00€0.37matched
85capture01a19ffc-cf5a-726d-a6a0-8d7fb83e6f6d€35.00€0.50matched
86capture01a19ffc-eb90-7a89-a209-288a53a0b268€15.00€0.26matched
87capture01a19ffd-0d35-7880-81fe-b2d0d988d33e€49.00€0.67matched
88capture01a19ffd-27e8-7502-bd5e-a6e7b650ac93€24.00€0.37matched
89capture01a19ffd-2d40-7825-a169-b68cec246160€15.00€0.26matched
90capture01a19ffd-58e1-75f3-8507-daef5bf6f5bc€49.00€0.67matched
91capture01a19ffd-71d8-7ea1-bcf3-14b5f60a104b€35.00€0.50matched
92capture01a19ffd-cbf7-7112-a759-8bcca5aea949€49.00€0.67matched
93capture01a19ffd-cf7b-75c1-9808-51c7bdb99c63€15.00€0.26matched
94capture01a19ffd-d63e-71d4-80e9-a13d21b2d1fc€9.00€0.19matched
95capture01a19ffd-ea26-7f8a-9a61-90785b691689€35.00€0.50matched
96capture01a19ffd-f3ad-74f7-8d07-205f00907850€9.00€0.19matched
97capture01a19ffe-26ad-7213-8724-bf16aa21c87a€24.00€0.37matched
98capture01a19ffe-2836-70e0-a7d1-d77d0a8cf7d3€24.00€0.37matched
99capture01a19ffe-29dd-7cab-816c-cf255a9f0e23€15.00€0.26matched