Saldencheck

0087003000, 2015-12


Datum
Saldo-
Bank
Saldo
berechnet

Differenz
----------------------------------------------------------
SELECT * FROM kontobuchung WHERE konto = '0087003000' AND buchungsdatum like '2015-12-%' AND stb_erloeskonto = '1210' ORDER BY buchungsdatum
UPDATE kontobuchung_saldo SET intern = '14116.11' WHERE id = '8846'
UPDATE kontobuchung_saldo SET intern = '8615.87' WHERE id = '8849'
UPDATE kontobuchung_saldo SET intern = '-23165.02' WHERE id = '8852'
UPDATE kontobuchung_saldo SET intern = '12857.33' WHERE id = '8855'
UPDATE kontobuchung_saldo SET intern = '-13031.81' WHERE id = '8858'
UPDATE kontobuchung_saldo SET intern = '8946.75' WHERE id = '8861'
UPDATE kontobuchung_saldo SET intern = '6951.74' WHERE id = '8864'
UPDATE kontobuchung_saldo SET intern = '-14592.62' WHERE id = '8867'
UPDATE kontobuchung_saldo SET intern = '6030.44' WHERE id = '8870'
UPDATE kontobuchung_saldo SET intern = '-6399.0500000001' WHERE id = '8873'
UPDATE kontobuchung_saldo SET intern = '15224.9' WHERE id = '8876'
UPDATE kontobuchung_saldo SET intern = '21770.28' WHERE id = '8879'
UPDATE kontobuchung_saldo SET intern = '9409.75' WHERE id = '8882'
UPDATE kontobuchung_saldo SET intern = '-47793.61' WHERE id = '8885'
UPDATE kontobuchung_saldo SET intern = '12507.79' WHERE id = '8888'
UPDATE kontobuchung_saldo SET intern = '-877.66000000004' WHERE id = '8891'
UPDATE kontobuchung_saldo SET intern = '-11721.45' WHERE id = '8894'
UPDATE kontobuchung_saldo SET intern = '36.079999999974' WHERE id = '8897'
UPDATE kontobuchung_saldo SET intern = '14575.95' WHERE id = '8900'
UPDATE kontobuchung_saldo SET intern = '6687.91' WHERE id = '8903'
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '%.11.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '3537.13' WHERE konto = '0087003000' AND date = '2015-11-30' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '1.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '17653.24' WHERE konto = '0087003000' AND date = '2015-12-01' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '2.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '26269.11' WHERE konto = '0087003000' AND date = '2015-12-02' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '3.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '3104.09' WHERE konto = '0087003000' AND date = '2015-12-03' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '4.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '15961.42' WHERE konto = '0087003000' AND date = '2015-12-04' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '5.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '6.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '7.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '2929.61' WHERE konto = '0087003000' AND date = '2015-12-07' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '8.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '11310.76' WHERE konto = '0087003000' AND date = '2015-12-08' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '9.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '18828.10' WHERE konto = '0087003000' AND date = '2015-12-09' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '10.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '4235.48' WHERE konto = '0087003000' AND date = '2015-12-10' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '11.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '10265.92' WHERE konto = '0087003000' AND date = '2015-12-11' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '12.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '13.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '14.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '3859.83' WHERE konto = '0087003000' AND date = '2015-12-14' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '15.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '19091.77' WHERE konto = '0087003000' AND date = '2015-12-15' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '16.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '40862.05' WHERE konto = '0087003000' AND date = '2015-12-16' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '17.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '50271.80' WHERE konto = '0087003000' AND date = '2015-12-17' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '18.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '2478.19' WHERE konto = '0087003000' AND date = '2015-12-18' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '19.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '20.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '21.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '14985.98' WHERE konto = '0087003000' AND date = '2015-12-21' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '22.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '14108.32' WHERE konto = '0087003000' AND date = '2015-12-22' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '23.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '2386.87' WHERE konto = '0087003000' AND date = '2015-12-23' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '24.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '10728.24' WHERE konto = '0087003000' AND date = '2015-12-28' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '25.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '26.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '27.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '28.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '2422.95' WHERE konto = '0087003000' AND date = '2015-12-28' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '29.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '16998.90' WHERE konto = '0087003000' AND date = '2015-12-29' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '30.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '24382.44' WHERE konto = '0087003000' AND date = '2015-12-30' AND (bank = 0 OR bank = '')
SELECT id, saldo, buchungsdatum FROM kontoauszug WHERE id = ( SELECT MAX(id) as max_id FROM kontoauszug WHERE kontonr = '0087003000' AND wertstellung like '31.12.2015' GROUP BY wertstellung ORDER BY id desc LIMIT 0,1)
UPDATE kontobuchung_saldo SET bank = '30315.49' WHERE konto = '0087003000' AND date = '2016-1-04' AND (bank = 0 OR bank = '')