// Bank feed and ledger reconciliation practice dataset (bank-feed-and-ledger-reconciliation-practice-dataset) v1 — Prisma seed
// Synthetic sample data, CC0-1.0. Generated deterministically; re-running the
// generator with the same spec and seed reproduces this file exactly.
//
// Delegates are named after the tables (prisma.bank_lines), which assumes models
// mapped to those table names. Rename the delegates if your models differ.
import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

async function main() {
    await prisma.bank_lines.createMany({
        data: [
            { id: 1, account: "main_current_account", posted_date: "2026-04-01", narrative: "FP IN LOWTHER SUPPLIES INV-20930", amount: "580.72" },
            { id: 2, account: "main_current_account", posted_date: "2026-04-01", narrative: "FP OUT BRIAR SUPPLIES BILL-8996", amount: "-822.45" },
            { id: 3, account: "main_current_account", posted_date: "2026-04-01", narrative: "ACCOUNT FEE", amount: "-15.00" },
            { id: 4, account: "main_current_account", posted_date: "2026-04-02", narrative: "BGC HARROW SUPPLIES", amount: "127.10" },
            { id: 5, account: "main_current_account", posted_date: "2026-04-02", narrative: "BGC CORVID SUPPLIES", amount: "125.97" },
            { id: 6, account: "main_current_account", posted_date: "2026-04-02", narrative: "FP OUT CORVID FREIGHT BILL-9468", amount: "-2604.91" },
            { id: 7, account: "main_current_account", posted_date: "2026-04-02", narrative: "FP OUT SEDGE JOINERY BILL-8414", amount: "-329.68" },
            { id: 8, account: "main_current_account", posted_date: "2026-04-02", narrative: "FP OUT CORVID FREIGHT BILL-8424", amount: "-2653.41" },
            { id: 9, account: "main_current_account", posted_date: "2026-04-03", narrative: "FP IN CORVID SUPPLIES INV-21169", amount: "742.63" },
            { id: 10, account: "main_current_account", posted_date: "2026-04-03", narrative: "FP IN HARROW SUPPLIES INV-20496", amount: "411.14" },
            { id: 11, account: "main_current_account", posted_date: "2026-04-03", narrative: "BGC CORVID SUPPLIES", amount: "2966.63" },
            { id: 12, account: "main_current_account", posted_date: "2026-04-03", narrative: "FP IN KESTREL TEXTILES INV-21876", amount: "3723.11" },
            { id: 13, account: "main_current_account", posted_date: "2026-04-03", narrative: "FP IN CORVID SUPPLIES INV-20773", amount: "513.38" },
            { id: 14, account: "main_current_account", posted_date: "2026-04-03", narrative: "BGC QUARRY FOODS", amount: "4702.42" },
            { id: 15, account: "main_current_account", posted_date: "2026-04-03", narrative: "FP IN JUNIPER PRINT INV-20690", amount: "205.01" },
            { id: 16, account: "main_current_account", posted_date: "2026-04-03", narrative: "FP OUT MARLOW PACKAGING BILL-8498", amount: "-2589.94" },
            { id: 17, account: "main_current_account", posted_date: "2026-04-03", narrative: "FP OUT DUNMORE LABS BILL-7667", amount: "-3049.91" },
            { id: 18, account: "main_current_account", posted_date: "2026-04-06", narrative: "FP IN LOWTHER SUPPLIES INV-20677", amount: "2122.66" },
            { id: 19, account: "main_current_account", posted_date: "2026-04-06", narrative: "BGC HARROW SUPPLIES", amount: "893.02" },
            { id: 20, account: "main_current_account", posted_date: "2026-04-06", narrative: "FP IN THISTLE PRINT INV-21717", amount: "123.43" },
            { id: 21, account: "main_current_account", posted_date: "2026-04-06", narrative: "CHEQUE 002960", amount: "-739.08" },
            { id: 22, account: "main_current_account", posted_date: "2026-04-06", narrative: "CARD MARLOW PACKAGING", amount: "-534.36" },
            { id: 23, account: "main_current_account", posted_date: "2026-04-06", narrative: "FP OUT JUNIPER FREIGHT BILL-7746", amount: "-285.37" },
            { id: 24, account: "main_current_account", posted_date: "2026-04-06", narrative: "CARD NETTLE CATERING", amount: "-527.85" },
            { id: 25, account: "main_current_account", posted_date: "2026-04-06", narrative: "FP OUT BRIAR SUPPLIES BILL-8568", amount: "-204.39" },
            { id: 26, account: "main_current_account", posted_date: "2026-04-06", narrative: "FP OUT JUNIPER CATERING BILL-9664", amount: "-115.05" },
            { id: 27, account: "main_current_account", posted_date: "2026-04-06", narrative: "FP OUT MARLOW PACKAGING BILL-9091", amount: "-82.64" },
            { id: 28, account: "main_current_account", posted_date: "2026-04-07", narrative: "CREDIT INV-21659", amount: "149.92" },
            { id: 29, account: "main_current_account", posted_date: "2026-04-07", narrative: "FP IN JUNIPER PRINT INV-20691", amount: "255.32" },
            { id: 30, account: "main_current_account", posted_date: "2026-04-07", narrative: "CARD PELLAM FOODS", amount: "-210.47" },
            { id: 31, account: "main_current_account", posted_date: "2026-04-07", narrative: "FP OUT PELLAM FOODS BILL-8309", amount: "-2400.29" },
            { id: 32, account: "main_current_account", posted_date: "2026-04-07", narrative: "CARD QUARRY PRINT", amount: "-1036.74" },
            { id: 33, account: "main_current_account", posted_date: "2026-04-07", narrative: "FP OUT JUNIPER CATERING BILL-8535", amount: "-1703.36" },
            { id: 34, account: "main_current_account", posted_date: "2026-04-07", narrative: "CHEQUE 002570", amount: "-1597.70" },
            { id: 35, account: "main_current_account", posted_date: "2026-04-07", narrative: "FP OUT NETTLE LABS BILL-7957", amount: "-534.60" },
            { id: 36, account: "main_current_account", posted_date: "2026-04-07", narrative: "FP IN KESTREL TEXTILES INV-21338", amount: "2793.17" },
            { id: 37, account: "main_current_account", posted_date: "2026-04-07", narrative: "FP IN SEDGE MOTORS INV-21564", amount: "3610.58" },
            { id: 38, account: "main_current_account", posted_date: "2026-04-07", narrative: "FP IN HARROW SUPPLIES INV-20664", amount: "3966.73" },
            { id: 39, account: "main_current_account", posted_date: "2026-04-07", narrative: "FP IN MARLOW PRINT INV-21875", amount: "4212.70" },
            { id: 40, account: "main_current_account", posted_date: "2026-04-08", narrative: "FP IN MARLOW PRINT INV-21129", amount: "268.90" },
            { id: 41, account: "main_current_account", posted_date: "2026-04-08", narrative: "FP OUT NETTLE LABS BILL-9096", amount: "-739.49" },
            { id: 42, account: "main_current_account", posted_date: "2026-04-08", narrative: "FP OUT BRIAR SUPPLIES BILL-8747", amount: "-1229.05" },
            { id: 43, account: "main_current_account", posted_date: "2026-04-08", narrative: "FP OUT SEDGE JOINERY BILL-9862", amount: "-1527.13" },
            { id: 44, account: "main_current_account", posted_date: "2026-04-08", narrative: "FP OUT DUNMORE LABS BILL-8288", amount: "-698.72" },
            { id: 45, account: "main_current_account", posted_date: "2026-04-09", narrative: "FP IN MARLOW PRINT INV-20985", amount: "4103.53" },
            { id: 46, account: "main_current_account", posted_date: "2026-04-09", narrative: "BGC KESTREL TEXTILES", amount: "1584.82" },
            { id: 47, account: "main_current_account", posted_date: "2026-04-09", narrative: "CREDIT INV-20450", amount: "1940.57" },
            { id: 48, account: "main_current_account", posted_date: "2026-04-09", narrative: "FP IN HARROW SUPPLIES INV-20709", amount: "1149.63" },
            { id: 49, account: "main_current_account", posted_date: "2026-04-09", narrative: "FP OUT MARLOW PACKAGING BILL-7195", amount: "-2635.21" },
            { id: 50, account: "main_current_account", posted_date: "2026-04-09", narrative: "CHEQUE 002955", amount: "-660.97" },
            { id: 51, account: "main_current_account", posted_date: "2026-04-09", narrative: "FP OUT MARLOW PACKAGING BILL-7961", amount: "-3038.05" },
            { id: 52, account: "main_current_account", posted_date: "2026-04-09", narrative: "FP OUT NETTLE CATERING BILL-7253", amount: "-526.62" },
            { id: 53, account: "main_current_account", posted_date: "2026-04-09", narrative: "FP IN THISTLE CATERING INV-20467", amount: "2061.79" },
            { id: 54, account: "main_current_account", posted_date: "2026-04-09", narrative: "CARD TERMINAL CHARGES", amount: "-8.40" },
            { id: 55, account: "main_current_account", posted_date: "2026-04-10", narrative: "FP IN JUNIPER PRINT INV-21158", amount: "1725.27" },
            { id: 56, account: "main_current_account", posted_date: "2026-04-10", narrative: "CREDIT INV-21279", amount: "269.33" },
            { id: 57, account: "main_current_account", posted_date: "2026-04-10", narrative: "FP IN MARLOW PRINT INV-21594", amount: "646.41" },
            { id: 58, account: "main_current_account", posted_date: "2026-04-10", narrative: "FP OUT KESTREL PRINT BILL-7019", amount: "-976.38" },
            { id: 59, account: "main_current_account", posted_date: "2026-04-10", narrative: "CARD BRIAR SUPPLIES", amount: "-1025.53" },
            { id: 60, account: "main_current_account", posted_date: "2026-04-10", narrative: "DD SEDGE JOINERY", amount: "-1017.43" },
            { id: 61, account: "main_current_account", posted_date: "2026-04-10", narrative: "BGC THISTLE PRINT", amount: "765.53" },
            { id: 62, account: "main_current_account", posted_date: "2026-04-10", narrative: "BGC KESTREL SUPPLIES", amount: "765.53" },
            { id: 63, account: "main_current_account", posted_date: "2026-04-13", narrative: "FP IN THISTLE CATERING INV-20718", amount: "122.60" },
            { id: 64, account: "main_current_account", posted_date: "2026-04-13", narrative: "BGC IVYWOOD PRINT", amount: "2277.59" },
            { id: 65, account: "main_current_account", posted_date: "2026-04-13", narrative: "BGC JUNIPER PRINT", amount: "2979.99" },
            { id: 66, account: "main_current_account", posted_date: "2026-04-13", narrative: "CREDIT INV-20573", amount: "1118.51" },
            { id: 67, account: "main_current_account", posted_date: "2026-04-13", narrative: "DD DUNMORE LABS", amount: "-77.00" },
            { id: 68, account: "main_current_account", posted_date: "2026-04-13", narrative: "FP OUT NETTLE LABS BILL-7172", amount: "-2743.77" },
            { id: 69, account: "main_current_account", posted_date: "2026-04-14", narrative: "BGC THISTLE CATERING", amount: "1511.36" },
            { id: 70, account: "main_current_account", posted_date: "2026-04-14", narrative: "CREDIT INV-21269", amount: "1310.90" },
            { id: 71, account: "main_current_account", posted_date: "2026-04-14", narrative: "FP IN SEDGE MOTORS INV-20783", amount: "1782.86" },
            { id: 72, account: "main_current_account", posted_date: "2026-04-14", narrative: "FP IN LOWTHER SUPPLIES INV-20688", amount: "3847.17" },
            { id: 73, account: "main_current_account", posted_date: "2026-04-14", narrative: "BGC JUNIPER PRINT", amount: "686.40" },
            { id: 74, account: "main_current_account", posted_date: "2026-04-14", narrative: "FP OUT IVYWOOD MOTORS BILL-7457", amount: "-1238.55" },
            { id: 75, account: "main_current_account", posted_date: "2026-04-14", narrative: "CHEQUE 002660", amount: "-414.66" },
            { id: 76, account: "main_current_account", posted_date: "2026-04-14", narrative: "CHEQUE 002801", amount: "-1418.98" },
            { id: 77, account: "main_current_account", posted_date: "2026-04-14", narrative: "CARD PELLAM FOODS", amount: "-357.53" },
            { id: 78, account: "main_current_account", posted_date: "2026-04-14", narrative: "DD ANGLIA UTILITIES", amount: "-184.20" },
            { id: 79, account: "main_current_account", posted_date: "2026-04-14", narrative: "DD FLEET INSURANCE", amount: "-296.50" },
            { id: 80, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP IN ALDER PRINT INV-20905", amount: "1365.12" },
            { id: 81, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP IN IVYWOOD PRINT INV-20740", amount: "120.01" },
            { id: 82, account: "main_current_account", posted_date: "2026-04-15", narrative: "CREDIT INV-20524", amount: "161.38" },
            { id: 83, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP IN CORVID SUPPLIES INV-21184", amount: "426.46" },
            { id: 84, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP OUT SEDGE JOINERY BILL-8759", amount: "-85.69" },
            { id: 85, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP OUT DUNMORE LABS BILL-7853", amount: "-1447.06" },
            { id: 86, account: "main_current_account", posted_date: "2026-04-15", narrative: "DD ALDER LABS", amount: "-62.99" },
            { id: 87, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP OUT BRIAR SUPPLIES BILL-9880", amount: "-3115.11" },
            { id: 88, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP OUT KESTREL PRINT BILL-7951", amount: "-97.90" },
            { id: 89, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP OUT KESTREL PRINT BILL-7315", amount: "-45.70" },
            { id: 90, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP OUT JUNIPER FREIGHT BILL-7594", amount: "-131.59" },
            { id: 91, account: "main_current_account", posted_date: "2026-04-15", narrative: "FP OUT JUNIPER FREIGHT BILL-7594", amount: "-131.59" },
            { id: 92, account: "main_current_account", posted_date: "2026-04-16", narrative: "FP IN LOWTHER TEXTILES INV-21329", amount: "217.17" },
            { id: 93, account: "main_current_account", posted_date: "2026-04-16", narrative: "FP IN HARROW SUPPLIES INV-21438", amount: "348.36" },
            { id: 94, account: "main_current_account", posted_date: "2026-04-16", narrative: "FP IN LOWTHER FREIGHT INV-20704", amount: "1105.04" },
            { id: 95, account: "main_current_account", posted_date: "2026-04-16", narrative: "FP IN KESTREL TEXTILES INV-21334", amount: "3758.65" },
            { id: 96, account: "main_current_account", posted_date: "2026-04-16", narrative: "CHEQUE 002966", amount: "-171.35" },
            { id: 97, account: "main_current_account", posted_date: "2026-04-16", narrative: "DD BRIAR SUPPLIES", amount: "-262.99" },
            { id: 98, account: "main_current_account", posted_date: "2026-04-16", narrative: "DD SEDGE JOINERY", amount: "-904.21" },
            { id: 99, account: "main_current_account", posted_date: "2026-04-16", narrative: "BGC UNIDENTIFIED REF 5531", amount: "240.00" },
            { id: 100, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP IN LOWTHER TEXTILES INV-21386", amount: "1811.23" },
            { id: 101, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP IN CORVID SUPPLIES INV-20742", amount: "987.64" },
            { id: 102, account: "main_current_account", posted_date: "2026-04-17", narrative: "CREDIT INV-20562", amount: "3319.48" },
            { id: 103, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP IN LOWTHER FREIGHT INV-21631", amount: "898.14" },
            { id: 104, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP IN QUARRY FOODS INV-20532", amount: "3513.24" },
            { id: 105, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP IN IVYWOOD PRINT INV-21063", amount: "1601.90" },
            { id: 106, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP IN THISTLE CATERING INV-20440", amount: "537.01" },
            { id: 107, account: "main_current_account", posted_date: "2026-04-17", narrative: "CREDIT INV-20774", amount: "714.26" },
            { id: 108, account: "main_current_account", posted_date: "2026-04-17", narrative: "DD BRIAR SUPPLIES", amount: "-127.51" },
            { id: 109, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP OUT IVYWOOD MOTORS BILL-9628", amount: "-156.28" },
            { id: 110, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP OUT JUNIPER FREIGHT BILL-7007", amount: "-3086.83" },
            { id: 111, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP OUT ALDER LABS BILL-7937", amount: "-2211.65" },
            { id: 112, account: "main_current_account", posted_date: "2026-04-17", narrative: "DD NETTLE CATERING", amount: "-341.15" },
            { id: 113, account: "main_current_account", posted_date: "2026-04-17", narrative: "FP IN KESTREL TEXTILES INV-21122", amount: "3571.79" },
            { id: 114, account: "main_current_account", posted_date: "2026-04-17", narrative: "BGC HARROW SUPPLIES", amount: "828.65" },
            { id: 115, account: "main_current_account", posted_date: "2026-04-17", narrative: "BGC LOWTHER SUPPLIES", amount: "828.65" },
            { id: 116, account: "main_current_account", posted_date: "2026-04-20", narrative: "BGC IVYWOOD PRINT", amount: "3865.03" },
            { id: 117, account: "main_current_account", posted_date: "2026-04-20", narrative: "CREDIT INV-21142", amount: "3467.47" },
            { id: 118, account: "main_current_account", posted_date: "2026-04-20", narrative: "FP IN LOWTHER TEXTILES INV-20438", amount: "1195.32" },
            { id: 119, account: "main_current_account", posted_date: "2026-04-20", narrative: "CREDIT INV-21742", amount: "121.95" },
            { id: 120, account: "main_current_account", posted_date: "2026-04-20", narrative: "CHEQUE 002743", amount: "-2549.23" },
            { id: 121, account: "main_current_account", posted_date: "2026-04-20", narrative: "CHEQUE 002536", amount: "-283.88" },
            { id: 122, account: "main_current_account", posted_date: "2026-04-20", narrative: "FP IN THISTLE PRINT INV-20503", amount: "197.63" },
            { id: 123, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN KESTREL TEXTILES INV-21406", amount: "151.57" },
            { id: 124, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN THISTLE PRINT INV-20479", amount: "1137.79" },
            { id: 125, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN THISTLE PRINT INV-21345", amount: "1743.63" },
            { id: 126, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN SEDGE MOTORS INV-20423", amount: "2328.80" },
            { id: 127, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN KESTREL TEXTILES INV-20574", amount: "3016.40" },
            { id: 128, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN LOWTHER TEXTILES INV-21661", amount: "127.56" },
            { id: 129, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP OUT QUARRY PRINT BILL-9623", amount: "-1725.16" },
            { id: 130, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP OUT QUARRY PRINT BILL-7986", amount: "-267.54" },
            { id: 131, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP OUT JUNIPER FREIGHT BILL-7139", amount: "-117.70" },
            { id: 132, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN JUNIPER PRINT INV-21365", amount: "4073.86" },
            { id: 133, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN THISTLE PRINT INV-21185", amount: "3229.43" },
            { id: 134, account: "main_current_account", posted_date: "2026-04-21", narrative: "CREDIT INV-20415", amount: "1167.22" },
            { id: 135, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN LOWTHER SUPPLIES INV-21816", amount: "2374.19" },
            { id: 136, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP IN MARLOW PRINT INV-21226", amount: "3799.33" },
            { id: 137, account: "main_current_account", posted_date: "2026-04-21", narrative: "FP OUT JUNIPER CATERING BILL-8357", amount: "-2207.28" },
            { id: 138, account: "main_current_account", posted_date: "2026-04-21", narrative: "BGC HARROW SUPPLIES", amount: "551.12" },
            { id: 139, account: "main_current_account", posted_date: "2026-04-21", narrative: "BGC THISTLE PRINT", amount: "551.12" },
            { id: 140, account: "main_current_account", posted_date: "2026-04-21", narrative: "DD OFFICE RENT", amount: "-1450.00" },
            { id: 141, account: "main_current_account", posted_date: "2026-04-22", narrative: "FP IN KESTREL SUPPLIES INV-21116", amount: "4255.23" },
            { id: 142, account: "main_current_account", posted_date: "2026-04-22", narrative: "BGC THISTLE CATERING", amount: "342.02" },
            { id: 143, account: "main_current_account", posted_date: "2026-04-22", narrative: "FP IN LOWTHER SUPPLIES INV-20790", amount: "3376.83" },
            { id: 144, account: "main_current_account", posted_date: "2026-04-22", narrative: "CREDIT INV-21371", amount: "3812.49" },
            { id: 145, account: "main_current_account", posted_date: "2026-04-22", narrative: "CREDIT INV-21498", amount: "1360.93" },
            { id: 146, account: "main_current_account", posted_date: "2026-04-22", narrative: "FP IN KESTREL SUPPLIES INV-20857", amount: "3125.24" },
            { id: 147, account: "main_current_account", posted_date: "2026-04-22", narrative: "BGC THISTLE PRINT", amount: "158.93" },
            { id: 148, account: "main_current_account", posted_date: "2026-04-22", narrative: "CREDIT INV-20739", amount: "2601.06" },
            { id: 149, account: "main_current_account", posted_date: "2026-04-22", narrative: "DD JUNIPER CATERING", amount: "-1104.35" },
            { id: 150, account: "main_current_account", posted_date: "2026-04-22", narrative: "CHEQUE 002303", amount: "-375.75" },
            { id: 151, account: "main_current_account", posted_date: "2026-04-22", narrative: "DD SEDGE JOINERY", amount: "-1278.01" },
            { id: 152, account: "main_current_account", posted_date: "2026-04-22", narrative: "DD MARLOW PACKAGING", amount: "-1976.28" },
            { id: 153, account: "main_current_account", posted_date: "2026-04-22", narrative: "FP OUT JUNIPER CATERING BILL-7900", amount: "-2344.24" },
            { id: 154, account: "main_current_account", posted_date: "2026-04-22", narrative: "FP OUT PELLAM FOODS BILL-9650", amount: "-147.67" },
            { id: 155, account: "main_current_account", posted_date: "2026-04-22", narrative: "FP OUT PELLAM FOODS BILL-9650", amount: "-147.67" },
            { id: 156, account: "main_current_account", posted_date: "2026-04-23", narrative: "FP IN IVYWOOD PRINT INV-21749", amount: "1834.61" },
            { id: 157, account: "main_current_account", posted_date: "2026-04-23", narrative: "BGC KESTREL SUPPLIES", amount: "641.63" },
            { id: 158, account: "main_current_account", posted_date: "2026-04-23", narrative: "FP OUT QUARRY PRINT BILL-7287", amount: "-71.39" },
            { id: 159, account: "main_current_account", posted_date: "2026-04-23", narrative: "FP OUT ALDER LABS BILL-8410", amount: "-1254.92" },
            { id: 160, account: "main_current_account", posted_date: "2026-04-23", narrative: "FP OUT BRIAR SUPPLIES BILL-7962", amount: "-1225.33" },
            { id: 161, account: "main_current_account", posted_date: "2026-04-23", narrative: "FP OUT SEDGE JOINERY BILL-7770", amount: "-77.87" },
            { id: 162, account: "main_current_account", posted_date: "2026-04-23", narrative: "FP OUT SEDGE JOINERY BILL-7770", amount: "-77.87" },
            { id: 163, account: "main_current_account", posted_date: "2026-04-23", narrative: "BGC JUNIPER PRINT", amount: "900.39" },
            { id: 164, account: "main_current_account", posted_date: "2026-04-23", narrative: "BGC MARLOW PRINT", amount: "900.39" },
            { id: 165, account: "main_current_account", posted_date: "2026-04-23", narrative: "BGC UNIDENTIFIED REF 5602", amount: "1150.00" },
            { id: 166, account: "main_current_account", posted_date: "2026-04-24", narrative: "FP IN MARLOW PRINT INV-21228", amount: "273.26" },
            { id: 167, account: "main_current_account", posted_date: "2026-04-24", narrative: "BGC KESTREL SUPPLIES", amount: "2567.36" },
            { id: 168, account: "main_current_account", posted_date: "2026-04-24", narrative: "BGC SEDGE MOTORS", amount: "159.33" },
            { id: 169, account: "main_current_account", posted_date: "2026-04-24", narrative: "BGC LOWTHER SUPPLIES", amount: "4289.58" },
            { id: 170, account: "main_current_account", posted_date: "2026-04-24", narrative: "FP IN HARROW SUPPLIES INV-20983", amount: "866.69" },
            { id: 171, account: "main_current_account", posted_date: "2026-04-24", narrative: "CARD NETTLE LABS", amount: "-2546.15" },
            { id: 172, account: "main_current_account", posted_date: "2026-04-24", narrative: "CHEQUE 002578", amount: "-1692.57" },
            { id: 173, account: "main_current_account", posted_date: "2026-04-24", narrative: "CHEQUE 002861", amount: "-160.84" },
            { id: 174, account: "main_current_account", posted_date: "2026-04-24", narrative: "DD NETTLE CATERING", amount: "-669.76" },
            { id: 175, account: "main_current_account", posted_date: "2026-04-27", narrative: "CREDIT INV-21110", amount: "1776.00" },
            { id: 176, account: "main_current_account", posted_date: "2026-04-27", narrative: "FP IN CORVID SUPPLIES INV-21854", amount: "204.57" },
            { id: 177, account: "main_current_account", posted_date: "2026-04-27", narrative: "BGC JUNIPER PRINT", amount: "1071.23" },
            { id: 178, account: "main_current_account", posted_date: "2026-04-27", narrative: "FP IN CORVID SUPPLIES INV-21364", amount: "1516.16" },
            { id: 179, account: "main_current_account", posted_date: "2026-04-27", narrative: "BGC QUARRY FOODS", amount: "120.50" },
            { id: 180, account: "main_current_account", posted_date: "2026-04-27", narrative: "FP OUT QUARRY PRINT BILL-8781", amount: "-424.28" },
            { id: 181, account: "main_current_account", posted_date: "2026-04-27", narrative: "FP OUT QUARRY PRINT BILL-9722", amount: "-146.09" },
            { id: 182, account: "main_current_account", posted_date: "2026-04-27", narrative: "CARD MARLOW PACKAGING", amount: "-881.74" },
            { id: 183, account: "main_current_account", posted_date: "2026-04-27", narrative: "RETURNED PAYMENT FASTER", amount: "-96.30" },
            { id: 184, account: "main_current_account", posted_date: "2026-04-28", narrative: "FP IN MARLOW PRINT INV-20477", amount: "453.15" },
            { id: 185, account: "main_current_account", posted_date: "2026-04-28", narrative: "FP IN ALDER PRINT INV-20864", amount: "3432.52" },
            { id: 186, account: "main_current_account", posted_date: "2026-04-28", narrative: "BGC MARLOW PRINT", amount: "2112.74" },
            { id: 187, account: "main_current_account", posted_date: "2026-04-28", narrative: "FP IN QUARRY FOODS INV-20966", amount: "4014.93" },
            { id: 188, account: "main_current_account", posted_date: "2026-04-28", narrative: "CHEQUE 002338", amount: "-169.59" },
            { id: 189, account: "main_current_account", posted_date: "2026-04-28", narrative: "CHEQUE 002819", amount: "-926.20" },
            { id: 190, account: "main_current_account", posted_date: "2026-04-28", narrative: "FP OUT NETTLE LABS BILL-8790", amount: "-466.52" },
            { id: 191, account: "main_current_account", posted_date: "2026-04-28", narrative: "FP IN QUARRY FOODS INV-20916", amount: "1391.62" },
            { id: 192, account: "main_current_account", posted_date: "2026-04-29", narrative: "FP IN JUNIPER PRINT INV-21141", amount: "1232.45" },
            { id: 193, account: "main_current_account", posted_date: "2026-04-29", narrative: "FP IN THISTLE PRINT INV-21425", amount: "3163.94" },
            { id: 194, account: "main_current_account", posted_date: "2026-04-29", narrative: "FP IN CORVID SUPPLIES INV-21020", amount: "173.47" },
            { id: 195, account: "main_current_account", posted_date: "2026-04-29", narrative: "FP OUT BRIAR SUPPLIES BILL-9380", amount: "-1463.79" },
            { id: 196, account: "main_current_account", posted_date: "2026-04-29", narrative: "FP OUT NETTLE LABS BILL-8182", amount: "-1378.25" },
            { id: 197, account: "main_current_account", posted_date: "2026-04-29", narrative: "FP OUT IVYWOOD MOTORS BILL-8539", amount: "-309.49" },
            { id: 198, account: "main_current_account", posted_date: "2026-04-29", narrative: "FP OUT NETTLE CATERING BILL-9367", amount: "-889.70" },
            { id: 199, account: "main_current_account", posted_date: "2026-04-30", narrative: "FP IN HARROW SUPPLIES INV-21016", amount: "264.84" },
            { id: 200, account: "main_current_account", posted_date: "2026-04-30", narrative: "FP OUT ORCHARD PACKAGING BILL-8534", amount: "-3141.70" },
            { id: 201, account: "main_current_account", posted_date: "2026-04-30", narrative: "FP OUT KESTREL PRINT BILL-7720", amount: "-2172.69" },
            { id: 202, account: "main_current_account", posted_date: "2026-04-30", narrative: "FP OUT NETTLE CATERING BILL-8385", amount: "-594.35" },
            { id: 203, account: "main_current_account", posted_date: "2026-04-30", narrative: "FP OUT MARLOW PACKAGING BILL-7508", amount: "-435.54" },
            { id: 204, account: "main_current_account", posted_date: "2026-04-30", narrative: "CHEQUE 002583", amount: "-2344.39" },
            { id: 205, account: "main_current_account", posted_date: "2026-04-30", narrative: "FP OUT JUNIPER FREIGHT BILL-8073", amount: "-1074.10" },
            { id: 206, account: "main_current_account", posted_date: "2026-04-30", narrative: "DD JUNIPER CATERING", amount: "-154.97" },
            { id: 207, account: "main_current_account", posted_date: "2026-04-30", narrative: "BANK INTEREST CREDIT", amount: "3.87" },
        ],
    });
    await prisma.ledger_entries.createMany({
        data: [
            { id: 1, book: "main_current_account", entry_date: "2026-04-01", reference: "INV-20523", counterparty: "Harrow Supplies", amount: "127.10", entered_by: "clerk_b", entered_at: new Date("2026-04-01T15:05:47Z") },
            { id: 2, book: "main_current_account", entry_date: "2026-04-01", reference: "INV-20930", counterparty: "Lowther Supplies", amount: "580.72", entered_by: "clerk_b", entered_at: new Date("2026-04-01T14:52:00Z") },
            { id: 3, book: "main_current_account", entry_date: "2026-04-01", reference: "INV-21876", counterparty: "Kestrel Textiles", amount: "3723.11", entered_by: "clerk_b", entered_at: new Date("2026-04-01T14:55:14Z") },
            { id: 4, book: "main_current_account", entry_date: "2026-04-01", reference: "INV-20726", counterparty: "Corvid Supplies", amount: "125.97", entered_by: "clerk_a", entered_at: new Date("2026-04-01T16:35:14Z") },
            { id: 5, book: "main_current_account", entry_date: "2026-04-01", reference: "CHQ 002960", counterparty: "Kestrel Print", amount: "-739.08", entered_by: "clerk_a", entered_at: new Date("2026-04-01T15:27:23Z") },
            { id: 6, book: "main_current_account", entry_date: "2026-04-01", reference: "BILL-8996", counterparty: "Briar Supplies", amount: "-822.45", entered_by: "clerk_a", entered_at: new Date("2026-04-01T09:18:56Z") },
            { id: 7, book: "main_current_account", entry_date: "2026-04-01", reference: "BILL-8414", counterparty: "Sedge Joinery", amount: "-329.68", entered_by: "clerk_c", entered_at: new Date("2026-04-01T14:41:00Z") },
            { id: 8, book: "main_current_account", entry_date: "2026-04-01", reference: "BILL-8498", counterparty: "Marlow Packaging", amount: "-2589.94", entered_by: "clerk_a", entered_at: new Date("2026-04-01T14:42:25Z") },
            { id: 9, book: "main_current_account", entry_date: "2026-04-01", reference: "INV-21185", counterparty: "Thistle Print", amount: "3229.43", entered_by: "clerk_b", entered_at: new Date("2026-04-01T14:22:39Z") },
            { id: 10, book: "main_current_account", entry_date: "2026-04-02", reference: "INV-20677", counterparty: "Lowther Supplies", amount: "2122.66", entered_by: "clerk_b", entered_at: new Date("2026-04-02T13:01:19Z") },
            { id: 11, book: "main_current_account", entry_date: "2026-04-02", reference: "INV-21169", counterparty: "Corvid Supplies", amount: "742.63", entered_by: "clerk_a", entered_at: new Date("2026-04-02T13:28:48Z") },
            { id: 12, book: "main_current_account", entry_date: "2026-04-02", reference: "INV-21203", counterparty: "Corvid Supplies", amount: "2966.63", entered_by: "clerk_b", entered_at: new Date("2026-04-02T15:46:06Z") },
            { id: 13, book: "main_current_account", entry_date: "2026-04-02", reference: "INV-20773", counterparty: "Corvid Supplies", amount: "513.38", entered_by: "clerk_c", entered_at: new Date("2026-04-02T10:55:26Z") },
            { id: 14, book: "main_current_account", entry_date: "2026-04-02", reference: "INV-21632", counterparty: "Quarry Foods", amount: "4702.42", entered_by: "clerk_a", entered_at: new Date("2026-04-02T16:16:25Z") },
            { id: 15, book: "main_current_account", entry_date: "2026-04-02", reference: "BILL-9468", counterparty: "Corvid Freight", amount: "-2604.91", entered_by: "clerk_a", entered_at: new Date("2026-04-02T15:37:58Z") },
            { id: 16, book: "main_current_account", entry_date: "2026-04-02", reference: "CHQ 002955", counterparty: "Orchard Packaging", amount: "-660.97", entered_by: "clerk_a", entered_at: new Date("2026-04-02T19:35:23Z") },
            { id: 17, book: "main_current_account", entry_date: "2026-04-02", reference: "CHQ 002570", counterparty: "Dunmore Labs", amount: "-1597.70", entered_by: "clerk_a", entered_at: new Date("2026-04-02T10:17:06Z") },
            { id: 18, book: "main_current_account", entry_date: "2026-04-02", reference: "BILL-8424", counterparty: "Corvid Freight", amount: "-2653.41", entered_by: "clerk_c", entered_at: new Date("2026-04-02T23:10:55Z") },
            { id: 19, book: "main_current_account", entry_date: "2026-04-02", reference: "INV-20415", counterparty: "Corvid Supplies", amount: "1167.22", entered_by: "clerk_a", entered_at: new Date("2026-04-02T11:50:55Z") },
            { id: 20, book: "main_current_account", entry_date: "2026-04-02", reference: "INV-21816", counterparty: "Lowther Supplies", amount: "2374.19", entered_by: "clerk_a", entered_at: new Date("2026-04-02T08:43:07Z") },
            { id: 21, book: "main_current_account", entry_date: "2026-04-02", reference: "INV-21072", counterparty: "Lowther Textiles", amount: "3009.07", entered_by: "clerk_c", entered_at: new Date("2026-04-02T09:47:53Z") },
            { id: 22, book: "main_current_account", entry_date: "2026-04-02", reference: "INV-20559", counterparty: "Marlow Print", amount: "120.72", entered_by: "clerk_a", entered_at: new Date("2026-04-02T13:10:52Z") },
            { id: 23, book: "main_current_account", entry_date: "2026-04-03", reference: "INV-20496", counterparty: "Harrow Supplies", amount: "411.14", entered_by: "clerk_b", entered_at: new Date("2026-04-03T08:20:05Z") },
            { id: 24, book: "main_current_account", entry_date: "2026-04-03", reference: "INV-20690", counterparty: "Juniper Print", amount: "205.01", entered_by: "clerk_a", entered_at: new Date("2026-04-03T14:17:15Z") },
            { id: 25, book: "main_current_account", entry_date: "2026-04-03", reference: "INV-21717", counterparty: "Thistle Print", amount: "123.43", entered_by: "clerk_c", entered_at: new Date("2026-04-03T10:26:40Z") },
            { id: 26, book: "main_current_account", entry_date: "2026-04-03", reference: "INV-20691", counterparty: "Juniper Print", amount: "255.32", entered_by: "clerk_a", entered_at: new Date("2026-04-03T09:07:48Z") },
            { id: 27, book: "main_current_account", entry_date: "2026-04-03", reference: "BILL-7746", counterparty: "Juniper Freight", amount: "-285.37", entered_by: "clerk_a", entered_at: new Date("2026-04-03T15:16:42Z") },
            { id: 28, book: "main_current_account", entry_date: "2026-04-03", reference: "BILL-7957", counterparty: "Nettle Labs", amount: "-534.60", entered_by: "clerk_a", entered_at: new Date("2026-04-03T10:53:29Z") },
            { id: 29, book: "main_current_account", entry_date: "2026-04-03", reference: "BILL-9664", counterparty: "Juniper Catering", amount: "-115.05", entered_by: "clerk_a", entered_at: new Date("2026-04-03T17:25:03Z") },
            { id: 30, book: "main_current_account", entry_date: "2026-04-03", reference: "BILL-9091", counterparty: "Marlow Packaging", amount: "-82.64", entered_by: "clerk_a", entered_at: new Date("2026-04-03T17:01:48Z") },
            { id: 31, book: "main_current_account", entry_date: "2026-04-03", reference: "BILL-7667", counterparty: "Dunmore Labs", amount: "-3049.91", entered_by: "clerk_b", entered_at: new Date("2026-04-03T14:54:07Z") },
            { id: 32, book: "main_current_account", entry_date: "2026-04-03", reference: "INV-20503", counterparty: "Thistle Print", amount: "197.63", entered_by: "clerk_c", entered_at: new Date("2026-04-03T14:27:46Z") },
            { id: 33, book: "main_current_account", entry_date: "2026-04-03", reference: "INV-21875", counterparty: "Marlow Print", amount: "4237.70", entered_by: "clerk_a", entered_at: new Date("2026-04-03T11:44:51Z") },
            { id: 34, book: "main_current_account", entry_date: "2026-04-06", reference: "INV-21205", counterparty: "Harrow Supplies", amount: "893.02", entered_by: "clerk_a", entered_at: new Date("2026-04-06T13:38:36Z") },
            { id: 35, book: "main_current_account", entry_date: "2026-04-06", reference: "BILL-8309", counterparty: "Pellam Foods", amount: "-2400.29", entered_by: "clerk_c", entered_at: new Date("2026-04-06T14:52:38Z") },
            { id: 36, book: "main_current_account", entry_date: "2026-04-06", reference: "BILL-9712", counterparty: "Marlow Packaging", amount: "-534.36", entered_by: "clerk_b", entered_at: new Date("2026-04-06T15:03:57Z") },
            { id: 37, book: "main_current_account", entry_date: "2026-04-06", reference: "BILL-7688", counterparty: "Nettle Catering", amount: "-527.85", entered_by: "clerk_a", entered_at: new Date("2026-04-06T09:37:02Z") },
            { id: 38, book: "main_current_account", entry_date: "2026-04-06", reference: "BILL-8568", counterparty: "Briar Supplies", amount: "-204.39", entered_by: "clerk_b", entered_at: new Date("2026-04-06T14:22:05Z") },
            { id: 39, book: "main_current_account", entry_date: "2026-04-06", reference: "BILL-8535", counterparty: "Juniper Catering", amount: "-1703.36", entered_by: "clerk_c", entered_at: new Date("2026-04-06T11:48:38Z") },
            { id: 40, book: "main_current_account", entry_date: "2026-04-06", reference: "INV-20664", counterparty: "Harrow Supplies", amount: "3978.73", entered_by: "clerk_b", entered_at: new Date("2026-04-06T14:16:51Z") },
            { id: 41, book: "main_current_account", entry_date: "2026-04-07", reference: "INV-21659", counterparty: "Harrow Supplies", amount: "149.92", entered_by: "clerk_a", entered_at: new Date("2026-04-07T15:40:27Z") },
            { id: 42, book: "main_current_account", entry_date: "2026-04-07", reference: "INV-20709", counterparty: "Harrow Supplies", amount: "1149.63", entered_by: "clerk_a", entered_at: new Date("2026-04-07T09:25:23Z") },
            { id: 43, book: "main_current_account", entry_date: "2026-04-07", reference: "BILL-9544", counterparty: "Pellam Foods", amount: "-210.47", entered_by: "clerk_c", entered_at: new Date("2026-04-07T15:40:12Z") },
            { id: 44, book: "main_current_account", entry_date: "2026-04-07", reference: "BILL-9096", counterparty: "Nettle Labs", amount: "-739.49", entered_by: "clerk_a", entered_at: new Date("2026-04-07T08:38:41Z") },
            { id: 45, book: "main_current_account", entry_date: "2026-04-07", reference: "BILL-8747", counterparty: "Briar Supplies", amount: "-1229.05", entered_by: "clerk_a", entered_at: new Date("2026-04-07T09:03:43Z") },
            { id: 46, book: "main_current_account", entry_date: "2026-04-07", reference: "BILL-9594", counterparty: "Quarry Print", amount: "-1036.74", entered_by: "clerk_b", entered_at: new Date("2026-04-07T10:09:20Z") },
            { id: 47, book: "main_current_account", entry_date: "2026-04-07", reference: "BILL-7195", counterparty: "Marlow Packaging", amount: "-2635.21", entered_by: "clerk_a", entered_at: new Date("2026-04-07T10:57:45Z") },
            { id: 48, book: "main_current_account", entry_date: "2026-04-07", reference: "BILL-9862", counterparty: "Sedge Joinery", amount: "-1527.13", entered_by: "clerk_b", entered_at: new Date("2026-04-07T14:48:10Z") },
            { id: 49, book: "main_current_account", entry_date: "2026-04-07", reference: "BILL-7253", counterparty: "Nettle Catering", amount: "-526.62", entered_by: "clerk_c", entered_at: new Date("2026-04-07T10:21:10Z") },
            { id: 50, book: "main_current_account", entry_date: "2026-04-07", reference: "INV-21365", counterparty: "Juniper Print", amount: "4073.86", entered_by: "clerk_a", entered_at: new Date("2026-04-07T08:41:38Z") },
            { id: 51, book: "main_current_account", entry_date: "2026-04-07", reference: "INV-21338", counterparty: "Kestrel Textiles", amount: "2795.67", entered_by: "clerk_a", entered_at: new Date("2026-04-07T12:45:11Z") },
            { id: 52, book: "main_current_account", entry_date: "2026-04-07", reference: "INV-21564", counterparty: "Sedge Motors", amount: "3617.83", entered_by: "clerk_a", entered_at: new Date("2026-04-07T09:34:23Z") },
            { id: 53, book: "main_current_account", entry_date: "2026-04-08", reference: "INV-21158", counterparty: "Juniper Print", amount: "1725.27", entered_by: "clerk_a", entered_at: new Date("2026-04-08T17:02:30Z") },
            { id: 54, book: "main_current_account", entry_date: "2026-04-08", reference: "INV-20850", counterparty: "Kestrel Textiles", amount: "1584.82", entered_by: "clerk_a", entered_at: new Date("2026-04-08T13:11:50Z") },
            { id: 55, book: "main_current_account", entry_date: "2026-04-08", reference: "INV-21129", counterparty: "Marlow Print", amount: "268.90", entered_by: "clerk_c", entered_at: new Date("2026-04-08T07:58:13Z") },
            { id: 56, book: "main_current_account", entry_date: "2026-04-08", reference: "INV-20450", counterparty: "Harrow Supplies", amount: "1940.57", entered_by: "clerk_a", entered_at: new Date("2026-04-08T14:59:44Z") },
            { id: 57, book: "main_current_account", entry_date: "2026-04-08", reference: "BILL-8288", counterparty: "Dunmore Labs", amount: "-698.72", entered_by: "clerk_a", entered_at: new Date("2026-04-08T11:59:37Z") },
            { id: 58, book: "main_current_account", entry_date: "2026-04-08", reference: "BILL-7449", counterparty: "Sedge Joinery", amount: "-1017.43", entered_by: "clerk_a", entered_at: new Date("2026-04-08T13:05:31Z") },
            { id: 59, book: "main_current_account", entry_date: "2026-04-08", reference: "INV-20467", counterparty: "Thistle Catering", amount: "2061.97", entered_by: "clerk_b", entered_at: new Date("2026-04-08T14:58:19Z") },
            { id: 60, book: "main_current_account", entry_date: "2026-04-09", reference: "INV-20985", counterparty: "Marlow Print", amount: "4103.53", entered_by: "clerk_a", entered_at: new Date("2026-04-09T10:02:06Z") },
            { id: 61, book: "main_current_account", entry_date: "2026-04-09", reference: "INV-21594", counterparty: "Marlow Print", amount: "646.41", entered_by: "clerk_b", entered_at: new Date("2026-04-09T11:41:05Z") },
            { id: 62, book: "main_current_account", entry_date: "2026-04-09", reference: "INV-20894", counterparty: "Ivywood Print", amount: "2277.59", entered_by: "clerk_c", entered_at: new Date("2026-04-09T15:29:12Z") },
            { id: 63, book: "main_current_account", entry_date: "2026-04-09", reference: "INV-21074", counterparty: "Juniper Print", amount: "2979.99", entered_by: "clerk_b", entered_at: new Date("2026-04-09T14:01:01Z") },
            { id: 64, book: "main_current_account", entry_date: "2026-04-09", reference: "CHQ 002966", counterparty: "Marlow Packaging", amount: "-171.35", entered_by: "clerk_b", entered_at: new Date("2026-04-09T17:01:19Z") },
            { id: 65, book: "main_current_account", entry_date: "2026-04-09", reference: "CHQ 002660", counterparty: "Quarry Print", amount: "-414.66", entered_by: "clerk_a", entered_at: new Date("2026-04-09T04:29:10Z") },
            { id: 66, book: "main_current_account", entry_date: "2026-04-09", reference: "CHQ 002801", counterparty: "Dunmore Labs", amount: "-1418.98", entered_by: "clerk_a", entered_at: new Date("2026-04-09T13:46:33Z") },
            { id: 67, book: "main_current_account", entry_date: "2026-04-09", reference: "BILL-7583", counterparty: "Briar Supplies", amount: "-1025.53", entered_by: "clerk_a", entered_at: new Date("2026-04-09T12:00:05Z") },
            { id: 68, book: "main_current_account", entry_date: "2026-04-09", reference: "BILL-7961", counterparty: "Marlow Packaging", amount: "-3038.05", entered_by: "clerk_c", entered_at: new Date("2026-04-09T09:43:52Z") },
            { id: 69, book: "main_current_account", entry_date: "2026-04-09", reference: "INV-20661", counterparty: "Thistle Print", amount: "765.53", entered_by: "clerk_b", entered_at: new Date("2026-04-09T16:54:31Z") },
            { id: 70, book: "main_current_account", entry_date: "2026-04-09", reference: "INV-21171", counterparty: "Kestrel Supplies", amount: "765.53", entered_by: "clerk_a", entered_at: new Date("2026-04-09T21:19:43Z") },
            { id: 71, book: "main_current_account", entry_date: "2026-04-10", reference: "INV-21279", counterparty: "Harrow Supplies", amount: "269.33", entered_by: "clerk_c", entered_at: new Date("2026-04-10T07:36:48Z") },
            { id: 72, book: "main_current_account", entry_date: "2026-04-10", reference: "BILL-7019", counterparty: "Kestrel Print", amount: "-976.38", entered_by: "clerk_a", entered_at: new Date("2026-04-10T13:35:02Z") },
            { id: 73, book: "main_current_account", entry_date: "2026-04-10", reference: "CHQ 002743", counterparty: "Orchard Packaging", amount: "-2549.23", entered_by: "clerk_c", entered_at: new Date("2026-04-10T09:24:54Z") },
            { id: 74, book: "main_current_account", entry_date: "2026-04-10", reference: "BILL-7172", counterparty: "Nettle Labs", amount: "-2743.77", entered_by: "clerk_b", entered_at: new Date("2026-04-10T11:33:31Z") },
            { id: 75, book: "main_current_account", entry_date: "2026-04-13", reference: "INV-20919", counterparty: "Thistle Catering", amount: "1511.36", entered_by: "clerk_b", entered_at: new Date("2026-04-13T14:27:05Z") },
            { id: 76, book: "main_current_account", entry_date: "2026-04-13", reference: "INV-20740", counterparty: "Ivywood Print", amount: "120.01", entered_by: "clerk_c", entered_at: new Date("2026-04-13T13:56:22Z") },
            { id: 77, book: "main_current_account", entry_date: "2026-04-13", reference: "INV-20718", counterparty: "Thistle Catering", amount: "122.60", entered_by: "clerk_a", entered_at: new Date("2026-04-13T08:14:50Z") },
            { id: 78, book: "main_current_account", entry_date: "2026-04-13", reference: "INV-20524", counterparty: "Thistle Catering", amount: "161.38", entered_by: "clerk_a", entered_at: new Date("2026-04-13T13:03:23Z") },
            { id: 79, book: "main_current_account", entry_date: "2026-04-13", reference: "INV-20783", counterparty: "Sedge Motors", amount: "1782.86", entered_by: "clerk_b", entered_at: new Date("2026-04-13T10:40:39Z") },
            { id: 80, book: "main_current_account", entry_date: "2026-04-13", reference: "INV-20688", counterparty: "Lowther Supplies", amount: "3847.17", entered_by: "clerk_c", entered_at: new Date("2026-04-13T07:28:49Z") },
            { id: 81, book: "main_current_account", entry_date: "2026-04-13", reference: "INV-20573", counterparty: "Lowther Freight", amount: "1118.51", entered_by: "clerk_c", entered_at: new Date("2026-04-13T11:42:54Z") },
            { id: 82, book: "main_current_account", entry_date: "2026-04-13", reference: "BILL-9056", counterparty: "Dunmore Labs", amount: "-77.00", entered_by: "clerk_b", entered_at: new Date("2026-04-13T14:44:25Z") },
            { id: 83, book: "main_current_account", entry_date: "2026-04-13", reference: "BILL-7457", counterparty: "Ivywood Motors", amount: "-1238.55", entered_by: "clerk_b", entered_at: new Date("2026-04-13T07:00:09Z") },
            { id: 84, book: "main_current_account", entry_date: "2026-04-13", reference: "BILL-7853", counterparty: "Dunmore Labs", amount: "-1447.06", entered_by: "clerk_a", entered_at: new Date("2026-04-13T10:37:29Z") },
            { id: 85, book: "main_current_account", entry_date: "2026-04-13", reference: "BILL-7951", counterparty: "Kestrel Print", amount: "-97.90", entered_by: "clerk_c", entered_at: new Date("2026-04-13T16:55:00Z") },
            { id: 86, book: "main_current_account", entry_date: "2026-04-13", reference: "BILL-7315", counterparty: "Kestrel Print", amount: "-45.70", entered_by: "clerk_c", entered_at: new Date("2026-04-13T02:49:06Z") },
            { id: 87, book: "main_current_account", entry_date: "2026-04-13", reference: "BILL-8363", counterparty: "Pellam Foods", amount: "-357.53", entered_by: "clerk_a", entered_at: new Date("2026-04-13T13:35:45Z") },
            { id: 88, book: "main_current_account", entry_date: "2026-04-14", reference: "INV-21269", counterparty: "Lowther Supplies", amount: "1310.90", entered_by: "clerk_b", entered_at: new Date("2026-04-14T12:51:59Z") },
            { id: 89, book: "main_current_account", entry_date: "2026-04-14", reference: "INV-20704", counterparty: "Lowther Freight", amount: "1105.04", entered_by: "clerk_a", entered_at: new Date("2026-04-14T14:36:22Z") },
            { id: 90, book: "main_current_account", entry_date: "2026-04-14", reference: "INV-21184", counterparty: "Corvid Supplies", amount: "426.46", entered_by: "clerk_a", entered_at: new Date("2026-04-14T09:39:13Z") },
            { id: 91, book: "main_current_account", entry_date: "2026-04-14", reference: "INV-20694", counterparty: "Juniper Print", amount: "686.40", entered_by: "clerk_c", entered_at: new Date("2026-04-14T09:58:01Z") },
            { id: 92, book: "main_current_account", entry_date: "2026-04-14", reference: "BILL-8759", counterparty: "Sedge Joinery", amount: "-85.69", entered_by: "clerk_a", entered_at: new Date("2026-04-14T17:18:23Z") },
            { id: 93, book: "main_current_account", entry_date: "2026-04-14", reference: "CHQ 002536", counterparty: "Quarry Print", amount: "-283.88", entered_by: "clerk_a", entered_at: new Date("2026-04-14T17:53:42Z") },
            { id: 94, book: "main_current_account", entry_date: "2026-04-14", reference: "BILL-9880", counterparty: "Briar Supplies", amount: "-3115.11", entered_by: "clerk_a", entered_at: new Date("2026-04-14T13:34:14Z") },
            { id: 95, book: "main_current_account", entry_date: "2026-04-14", reference: "BILL-7594", counterparty: "Juniper Freight", amount: "-131.59", entered_by: "clerk_a", entered_at: new Date("2026-04-14T11:59:26Z") },
            { id: 96, book: "main_current_account", entry_date: "2026-04-15", reference: "INV-20905", counterparty: "Alder Print", amount: "1365.12", entered_by: "clerk_c", entered_at: new Date("2026-04-15T11:07:05Z") },
            { id: 97, book: "main_current_account", entry_date: "2026-04-15", reference: "INV-21386", counterparty: "Lowther Textiles", amount: "1811.23", entered_by: "clerk_a", entered_at: new Date("2026-04-15T12:03:23Z") },
            { id: 98, book: "main_current_account", entry_date: "2026-04-15", reference: "INV-20742", counterparty: "Corvid Supplies", amount: "987.64", entered_by: "clerk_a", entered_at: new Date("2026-04-15T13:48:31Z") },
            { id: 99, book: "main_current_account", entry_date: "2026-04-15", reference: "INV-20562", counterparty: "Corvid Supplies", amount: "3319.48", entered_by: "clerk_a", entered_at: new Date("2026-04-15T17:49:55Z") },
            { id: 100, book: "main_current_account", entry_date: "2026-04-15", reference: "INV-21631", counterparty: "Lowther Freight", amount: "898.14", entered_by: "clerk_b", entered_at: new Date("2026-04-15T13:33:57Z") },
            { id: 101, book: "main_current_account", entry_date: "2026-04-15", reference: "INV-21334", counterparty: "Kestrel Textiles", amount: "3758.65", entered_by: "clerk_a", entered_at: new Date("2026-04-15T09:57:23Z") },
            { id: 102, book: "main_current_account", entry_date: "2026-04-15", reference: "INV-20440", counterparty: "Thistle Catering", amount: "537.01", entered_by: "clerk_b", entered_at: new Date("2026-04-15T10:45:18Z") },
            { id: 103, book: "main_current_account", entry_date: "2026-04-15", reference: "BILL-8822", counterparty: "Briar Supplies", amount: "-127.51", entered_by: "clerk_c", entered_at: new Date("2026-04-15T23:49:07Z") },
            { id: 104, book: "main_current_account", entry_date: "2026-04-15", reference: "BILL-9513", counterparty: "Alder Labs", amount: "-62.99", entered_by: "clerk_a", entered_at: new Date("2026-04-15T15:43:57Z") },
            { id: 105, book: "main_current_account", entry_date: "2026-04-15", reference: "BILL-7937", counterparty: "Alder Labs", amount: "-2211.65", entered_by: "clerk_a", entered_at: new Date("2026-04-15T12:20:50Z") },
            { id: 106, book: "main_current_account", entry_date: "2026-04-15", reference: "BILL-7685", counterparty: "Sedge Joinery", amount: "-904.21", entered_by: "clerk_a", entered_at: new Date("2026-04-15T14:14:11Z") },
            { id: 107, book: "main_current_account", entry_date: "2026-04-15", reference: "INV-21122", counterparty: "Kestrel Textiles", amount: "3571.97", entered_by: "clerk_c", entered_at: new Date("2026-04-15T15:44:12Z") },
            { id: 108, book: "main_current_account", entry_date: "2026-04-16", reference: "INV-21329", counterparty: "Lowther Textiles", amount: "217.17", entered_by: "clerk_c", entered_at: new Date("2026-04-16T15:12:17Z") },
            { id: 109, book: "main_current_account", entry_date: "2026-04-16", reference: "INV-21438", counterparty: "Harrow Supplies", amount: "348.36", entered_by: "clerk_b", entered_at: new Date("2026-04-16T11:26:01Z") },
            { id: 110, book: "main_current_account", entry_date: "2026-04-16", reference: "INV-20532", counterparty: "Quarry Foods", amount: "3513.24", entered_by: "clerk_a", entered_at: new Date("2026-04-16T15:25:09Z") },
            { id: 111, book: "main_current_account", entry_date: "2026-04-16", reference: "INV-21063", counterparty: "Ivywood Print", amount: "1601.90", entered_by: "clerk_c", entered_at: new Date("2026-04-16T13:10:37Z") },
            { id: 112, book: "main_current_account", entry_date: "2026-04-16", reference: "BILL-9628", counterparty: "Ivywood Motors", amount: "-156.28", entered_by: "clerk_c", entered_at: new Date("2026-04-16T09:24:19Z") },
            { id: 113, book: "main_current_account", entry_date: "2026-04-16", reference: "BILL-7422", counterparty: "Briar Supplies", amount: "-262.99", entered_by: "clerk_a", entered_at: new Date("2026-04-16T16:40:36Z") },
            { id: 114, book: "main_current_account", entry_date: "2026-04-16", reference: "INV-21081", counterparty: "Harrow Supplies", amount: "828.65", entered_by: "clerk_c", entered_at: new Date("2026-04-16T08:15:43Z") },
            { id: 115, book: "main_current_account", entry_date: "2026-04-16", reference: "INV-20877", counterparty: "Lowther Supplies", amount: "828.65", entered_by: "clerk_c", entered_at: new Date("2026-04-16T14:25:21Z") },
            { id: 116, book: "main_current_account", entry_date: "2026-04-17", reference: "INV-20756", counterparty: "Ivywood Print", amount: "3865.03", entered_by: "clerk_c", entered_at: new Date("2026-04-17T09:52:32Z") },
            { id: 117, book: "main_current_account", entry_date: "2026-04-17", reference: "INV-21142", counterparty: "Lowther Supplies", amount: "3467.47", entered_by: "clerk_b", entered_at: new Date("2026-04-17T15:39:14Z") },
            { id: 118, book: "main_current_account", entry_date: "2026-04-17", reference: "INV-21345", counterparty: "Thistle Print", amount: "1743.63", entered_by: "clerk_b", entered_at: new Date("2026-04-17T10:54:34Z") },
            { id: 119, book: "main_current_account", entry_date: "2026-04-17", reference: "INV-20574", counterparty: "Kestrel Textiles", amount: "3016.40", entered_by: "clerk_a", entered_at: new Date("2026-04-17T10:57:34Z") },
            { id: 120, book: "main_current_account", entry_date: "2026-04-17", reference: "INV-21742", counterparty: "Lowther Textiles", amount: "121.95", entered_by: "clerk_c", entered_at: new Date("2026-04-17T17:28:02Z") },
            { id: 121, book: "main_current_account", entry_date: "2026-04-17", reference: "INV-20774", counterparty: "Harrow Supplies", amount: "714.26", entered_by: "clerk_c", entered_at: new Date("2026-04-17T13:18:14Z") },
            { id: 122, book: "main_current_account", entry_date: "2026-04-17", reference: "BILL-7007", counterparty: "Juniper Freight", amount: "-3086.83", entered_by: "clerk_a", entered_at: new Date("2026-04-17T08:59:51Z") },
            { id: 123, book: "main_current_account", entry_date: "2026-04-17", reference: "CHQ 002303", counterparty: "Marlow Packaging", amount: "-375.75", entered_by: "clerk_b", entered_at: new Date("2026-04-17T10:07:06Z") },
            { id: 124, book: "main_current_account", entry_date: "2026-04-17", reference: "CHQ 002578", counterparty: "Kestrel Print", amount: "-1692.57", entered_by: "clerk_b", entered_at: new Date("2026-04-17T09:47:14Z") },
            { id: 125, book: "main_current_account", entry_date: "2026-04-17", reference: "CHQ 002861", counterparty: "Corvid Freight", amount: "-160.84", entered_by: "clerk_c", entered_at: new Date("2026-04-17T13:34:59Z") },
            { id: 126, book: "main_current_account", entry_date: "2026-04-17", reference: "CHQ 002819", counterparty: "Ivywood Motors", amount: "-926.20", entered_by: "clerk_b", entered_at: new Date("2026-04-17T13:13:21Z") },
            { id: 127, book: "main_current_account", entry_date: "2026-04-17", reference: "BILL-9179", counterparty: "Nettle Catering", amount: "-341.15", entered_by: "clerk_b", entered_at: new Date("2026-04-17T14:26:22Z") },
            { id: 128, book: "main_current_account", entry_date: "2026-04-20", reference: "INV-20479", counterparty: "Thistle Print", amount: "1137.79", entered_by: "clerk_a", entered_at: new Date("2026-04-20T12:41:57Z") },
            { id: 129, book: "main_current_account", entry_date: "2026-04-20", reference: "INV-20438", counterparty: "Lowther Textiles", amount: "1195.32", entered_by: "clerk_c", entered_at: new Date("2026-04-20T09:51:27Z") },
            { id: 130, book: "main_current_account", entry_date: "2026-04-20", reference: "INV-21498", counterparty: "Juniper Print", amount: "1360.93", entered_by: "clerk_a", entered_at: new Date("2026-04-20T10:00:28Z") },
            { id: 131, book: "main_current_account", entry_date: "2026-04-20", reference: "INV-20898", counterparty: "Thistle Print", amount: "158.93", entered_by: "clerk_a", entered_at: new Date("2026-04-20T10:17:51Z") },
            { id: 132, book: "main_current_account", entry_date: "2026-04-20", reference: "INV-21661", counterparty: "Lowther Textiles", amount: "127.56", entered_by: "clerk_c", entered_at: new Date("2026-04-20T15:52:14Z") },
            { id: 133, book: "main_current_account", entry_date: "2026-04-20", reference: "BILL-9623", counterparty: "Quarry Print", amount: "-1725.16", entered_by: "clerk_a", entered_at: new Date("2026-04-20T16:05:58Z") },
            { id: 134, book: "main_current_account", entry_date: "2026-04-20", reference: "BILL-8318", counterparty: "Juniper Catering", amount: "-1104.35", entered_by: "clerk_a", entered_at: new Date("2026-04-20T13:36:15Z") },
            { id: 135, book: "main_current_account", entry_date: "2026-04-20", reference: "BILL-7986", counterparty: "Quarry Print", amount: "-267.54", entered_by: "clerk_a", entered_at: new Date("2026-04-20T11:07:43Z") },
            { id: 136, book: "main_current_account", entry_date: "2026-04-20", reference: "CHQ 002338", counterparty: "Dunmore Labs", amount: "-169.59", entered_by: "clerk_b", entered_at: new Date("2026-04-20T13:38:23Z") },
            { id: 137, book: "main_current_account", entry_date: "2026-04-20", reference: "BILL-7900", counterparty: "Juniper Catering", amount: "-2344.24", entered_by: "clerk_b", entered_at: new Date("2026-04-20T08:31:31Z") },
            { id: 138, book: "main_current_account", entry_date: "2026-04-20", reference: "INV-21236", counterparty: "Harrow Supplies", amount: "551.12", entered_by: "clerk_a", entered_at: new Date("2026-04-20T19:12:12Z") },
            { id: 139, book: "main_current_account", entry_date: "2026-04-20", reference: "INV-20948", counterparty: "Thistle Print", amount: "551.12", entered_by: "clerk_b", entered_at: new Date("2026-04-20T16:33:44Z") },
            { id: 140, book: "main_current_account", entry_date: "2026-04-21", reference: "INV-21406", counterparty: "Kestrel Textiles", amount: "151.57", entered_by: "clerk_b", entered_at: new Date("2026-04-21T16:52:55Z") },
            { id: 141, book: "main_current_account", entry_date: "2026-04-21", reference: "INV-21116", counterparty: "Kestrel Supplies", amount: "4255.23", entered_by: "clerk_a", entered_at: new Date("2026-04-21T10:51:30Z") },
            { id: 142, book: "main_current_account", entry_date: "2026-04-21", reference: "INV-21591", counterparty: "Thistle Catering", amount: "342.02", entered_by: "clerk_b", entered_at: new Date("2026-04-21T07:57:17Z") },
            { id: 143, book: "main_current_account", entry_date: "2026-04-21", reference: "INV-20423", counterparty: "Sedge Motors", amount: "2328.80", entered_by: "clerk_b", entered_at: new Date("2026-04-21T14:10:41Z") },
            { id: 144, book: "main_current_account", entry_date: "2026-04-21", reference: "INV-20790", counterparty: "Lowther Supplies", amount: "3376.83", entered_by: "clerk_a", entered_at: new Date("2026-04-21T12:13:42Z") },
            { id: 145, book: "main_current_account", entry_date: "2026-04-21", reference: "INV-21371", counterparty: "Marlow Print", amount: "3812.49", entered_by: "clerk_b", entered_at: new Date("2026-04-21T14:13:26Z") },
            { id: 146, book: "main_current_account", entry_date: "2026-04-21", reference: "BILL-7287", counterparty: "Quarry Print", amount: "-71.39", entered_by: "clerk_a", entered_at: new Date("2026-04-21T11:26:57Z") },
            { id: 147, book: "main_current_account", entry_date: "2026-04-21", reference: "BILL-9019", counterparty: "Sedge Joinery", amount: "-1278.01", entered_by: "clerk_c", entered_at: new Date("2026-04-21T13:48:18Z") },
            { id: 148, book: "main_current_account", entry_date: "2026-04-21", reference: "CHQ 002583", counterparty: "Sedge Joinery", amount: "-2344.39", entered_by: "clerk_a", entered_at: new Date("2026-04-21T10:44:00Z") },
            { id: 149, book: "main_current_account", entry_date: "2026-04-21", reference: "BILL-7962", counterparty: "Briar Supplies", amount: "-1225.33", entered_by: "clerk_a", entered_at: new Date("2026-04-21T10:33:23Z") },
            { id: 150, book: "main_current_account", entry_date: "2026-04-21", reference: "BILL-7139", counterparty: "Juniper Freight", amount: "-117.70", entered_by: "clerk_b", entered_at: new Date("2026-04-21T12:52:44Z") },
            { id: 151, book: "main_current_account", entry_date: "2026-04-21", reference: "INV-21226", counterparty: "Marlow Print", amount: "3800.83", entered_by: "clerk_b", entered_at: new Date("2026-04-21T19:25:02Z") },
            { id: 152, book: "main_current_account", entry_date: "2026-04-21", reference: "BILL-8357", counterparty: "Juniper Catering", amount: "-2207.82", entered_by: "clerk_a", entered_at: new Date("2026-04-21T16:31:09Z") },
            { id: 153, book: "main_current_account", entry_date: "2026-04-21", reference: "BILL-9650", counterparty: "Pellam Foods", amount: "-147.67", entered_by: "clerk_b", entered_at: new Date("2026-04-21T16:13:22Z") },
            { id: 154, book: "main_current_account", entry_date: "2026-04-22", reference: "INV-21749", counterparty: "Ivywood Print", amount: "1834.61", entered_by: "clerk_b", entered_at: new Date("2026-04-22T10:40:36Z") },
            { id: 155, book: "main_current_account", entry_date: "2026-04-22", reference: "INV-20498", counterparty: "Sedge Motors", amount: "159.33", entered_by: "clerk_b", entered_at: new Date("2026-04-22T14:50:42Z") },
            { id: 156, book: "main_current_account", entry_date: "2026-04-22", reference: "INV-20857", counterparty: "Kestrel Supplies", amount: "3125.24", entered_by: "clerk_c", entered_at: new Date("2026-04-22T13:04:28Z") },
            { id: 157, book: "main_current_account", entry_date: "2026-04-22", reference: "INV-20739", counterparty: "Thistle Print", amount: "2601.06", entered_by: "clerk_a", entered_at: new Date("2026-04-22T10:38:00Z") },
            { id: 158, book: "main_current_account", entry_date: "2026-04-22", reference: "BILL-8845", counterparty: "Nettle Labs", amount: "-2546.15", entered_by: "clerk_a", entered_at: new Date("2026-04-22T09:14:31Z") },
            { id: 159, book: "main_current_account", entry_date: "2026-04-22", reference: "BILL-7229", counterparty: "Marlow Packaging", amount: "-1976.28", entered_by: "clerk_c", entered_at: new Date("2026-04-22T11:59:08Z") },
            { id: 160, book: "main_current_account", entry_date: "2026-04-22", reference: "BILL-7770", counterparty: "Sedge Joinery", amount: "-77.87", entered_by: "clerk_a", entered_at: new Date("2026-04-22T10:56:57Z") },
            { id: 161, book: "main_current_account", entry_date: "2026-04-22", reference: "INV-20867", counterparty: "Juniper Print", amount: "900.39", entered_by: "clerk_a", entered_at: new Date("2026-04-22T08:10:30Z") },
            { id: 162, book: "main_current_account", entry_date: "2026-04-22", reference: "INV-21692", counterparty: "Marlow Print", amount: "900.39", entered_by: "clerk_b", entered_at: new Date("2026-04-22T14:34:07Z") },
            { id: 163, book: "main_current_account", entry_date: "2026-04-23", reference: "INV-21110", counterparty: "Thistle Catering", amount: "1776.00", entered_by: "clerk_a", entered_at: new Date("2026-04-23T17:20:07Z") },
            { id: 164, book: "main_current_account", entry_date: "2026-04-23", reference: "INV-21463", counterparty: "Juniper Print", amount: "1071.23", entered_by: "clerk_b", entered_at: new Date("2026-04-23T13:46:21Z") },
            { id: 165, book: "main_current_account", entry_date: "2026-04-23", reference: "INV-20900", counterparty: "Kestrel Supplies", amount: "641.63", entered_by: "clerk_b", entered_at: new Date("2026-04-23T12:18:24Z") },
            { id: 166, book: "main_current_account", entry_date: "2026-04-23", reference: "INV-21364", counterparty: "Corvid Supplies", amount: "1516.16", entered_by: "clerk_b", entered_at: new Date("2026-04-23T14:15:21Z") },
            { id: 167, book: "main_current_account", entry_date: "2026-04-23", reference: "INV-21214", counterparty: "Kestrel Supplies", amount: "2567.36", entered_by: "clerk_c", entered_at: new Date("2026-04-23T08:39:35Z") },
            { id: 168, book: "main_current_account", entry_date: "2026-04-23", reference: "INV-20656", counterparty: "Quarry Foods", amount: "120.50", entered_by: "clerk_a", entered_at: new Date("2026-04-23T09:49:43Z") },
            { id: 169, book: "main_current_account", entry_date: "2026-04-23", reference: "INV-20983", counterparty: "Harrow Supplies", amount: "866.69", entered_by: "clerk_a", entered_at: new Date("2026-04-23T08:55:23Z") },
            { id: 170, book: "main_current_account", entry_date: "2026-04-23", reference: "BILL-8410", counterparty: "Alder Labs", amount: "-1254.92", entered_by: "clerk_c", entered_at: new Date("2026-04-23T10:21:37Z") },
            { id: 171, book: "main_current_account", entry_date: "2026-04-23", reference: "CHQ 002328", counterparty: "Orchard Packaging", amount: "-1200.64", entered_by: "clerk_b", entered_at: new Date("2026-04-23T07:56:47Z") },
            { id: 172, book: "main_current_account", entry_date: "2026-04-24", reference: "INV-21854", counterparty: "Corvid Supplies", amount: "204.57", entered_by: "clerk_a", entered_at: new Date("2026-04-24T14:49:30Z") },
            { id: 173, book: "main_current_account", entry_date: "2026-04-24", reference: "INV-21228", counterparty: "Marlow Print", amount: "273.26", entered_by: "clerk_a", entered_at: new Date("2026-04-24T14:47:00Z") },
            { id: 174, book: "main_current_account", entry_date: "2026-04-24", reference: "INV-21756", counterparty: "Lowther Supplies", amount: "4289.58", entered_by: "clerk_b", entered_at: new Date("2026-04-24T13:21:57Z") },
            { id: 175, book: "main_current_account", entry_date: "2026-04-24", reference: "BILL-9722", counterparty: "Quarry Print", amount: "-146.09", entered_by: "clerk_a", entered_at: new Date("2026-04-24T10:50:21Z") },
            { id: 176, book: "main_current_account", entry_date: "2026-04-24", reference: "BILL-7214", counterparty: "Marlow Packaging", amount: "-881.74", entered_by: "clerk_a", entered_at: new Date("2026-04-24T17:29:02Z") },
            { id: 177, book: "main_current_account", entry_date: "2026-04-24", reference: "BILL-8852", counterparty: "Nettle Catering", amount: "-669.76", entered_by: "clerk_a", entered_at: new Date("2026-04-24T15:05:29Z") },
            { id: 178, book: "main_current_account", entry_date: "2026-04-27", reference: "INV-21141", counterparty: "Juniper Print", amount: "1232.45", entered_by: "clerk_a", entered_at: new Date("2026-04-27T12:03:34Z") },
            { id: 179, book: "main_current_account", entry_date: "2026-04-27", reference: "INV-21020", counterparty: "Corvid Supplies", amount: "173.47", entered_by: "clerk_c", entered_at: new Date("2026-04-27T19:54:47Z") },
            { id: 180, book: "main_current_account", entry_date: "2026-04-27", reference: "BILL-8781", counterparty: "Quarry Print", amount: "-424.28", entered_by: "clerk_c", entered_at: new Date("2026-04-27T10:48:32Z") },
            { id: 181, book: "main_current_account", entry_date: "2026-04-27", reference: "CHQ 002591", counterparty: "Sedge Joinery", amount: "-1531.37", entered_by: "clerk_a", entered_at: new Date("2026-04-27T11:23:43Z") },
            { id: 182, book: "main_current_account", entry_date: "2026-04-27", reference: "BILL-8539", counterparty: "Ivywood Motors", amount: "-309.49", entered_by: "clerk_b", entered_at: new Date("2026-04-27T14:37:45Z") },
            { id: 183, book: "main_current_account", entry_date: "2026-04-27", reference: "CHQ 002832", counterparty: "Briar Supplies", amount: "-1794.18", entered_by: "clerk_a", entered_at: new Date("2026-04-27T17:44:43Z") },
            { id: 184, book: "main_current_account", entry_date: "2026-04-27", reference: "BILL-8790", counterparty: "Nettle Labs", amount: "-466.52", entered_by: "clerk_b", entered_at: new Date("2026-04-27T16:02:48Z") },
            { id: 185, book: "main_current_account", entry_date: "2026-04-27", reference: "INV-20916", counterparty: "Quarry Foods", amount: "1408.02", entered_by: "clerk_a", entered_at: new Date("2026-04-27T13:20:27Z") },
            { id: 186, book: "main_current_account", entry_date: "2026-04-27", reference: "BILL-9367", counterparty: "Nettle Catering", amount: "-889.07", entered_by: "clerk_a", entered_at: new Date("2026-04-27T10:06:59Z") },
            { id: 187, book: "main_current_account", entry_date: "2026-04-27", reference: "CHQ 002351", counterparty: "Ivywood Motors", amount: "-2414.52", entered_by: "clerk_a", entered_at: new Date("2026-04-27T17:16:35Z") },
            { id: 188, book: "main_current_account", entry_date: "2026-04-28", reference: "INV-20477", counterparty: "Marlow Print", amount: "453.15", entered_by: "clerk_c", entered_at: new Date("2026-04-28T12:09:01Z") },
            { id: 189, book: "main_current_account", entry_date: "2026-04-28", reference: "INV-21425", counterparty: "Thistle Print", amount: "3163.94", entered_by: "clerk_b", entered_at: new Date("2026-04-28T10:24:48Z") },
            { id: 190, book: "main_current_account", entry_date: "2026-04-28", reference: "INV-21016", counterparty: "Harrow Supplies", amount: "264.84", entered_by: "clerk_b", entered_at: new Date("2026-04-28T11:05:53Z") },
            { id: 191, book: "main_current_account", entry_date: "2026-04-28", reference: "INV-20864", counterparty: "Alder Print", amount: "3432.52", entered_by: "clerk_c", entered_at: new Date("2026-04-28T11:07:45Z") },
            { id: 192, book: "main_current_account", entry_date: "2026-04-28", reference: "INV-21404", counterparty: "Marlow Print", amount: "2112.74", entered_by: "clerk_c", entered_at: new Date("2026-04-28T17:10:36Z") },
            { id: 193, book: "main_current_account", entry_date: "2026-04-28", reference: "INV-20966", counterparty: "Quarry Foods", amount: "4014.93", entered_by: "clerk_a", entered_at: new Date("2026-04-28T11:17:44Z") },
            { id: 194, book: "main_current_account", entry_date: "2026-04-28", reference: "BILL-7720", counterparty: "Kestrel Print", amount: "-2172.69", entered_by: "clerk_c", entered_at: new Date("2026-04-28T11:48:59Z") },
            { id: 195, book: "main_current_account", entry_date: "2026-04-28", reference: "BILL-8385", counterparty: "Nettle Catering", amount: "-594.35", entered_by: "clerk_b", entered_at: new Date("2026-04-28T13:23:59Z") },
            { id: 196, book: "main_current_account", entry_date: "2026-04-28", reference: "CHQ 002678", counterparty: "Quarry Print", amount: "-2049.52", entered_by: "clerk_a", entered_at: new Date("2026-04-28T11:02:16Z") },
            { id: 197, book: "main_current_account", entry_date: "2026-04-28", reference: "BILL-9884", counterparty: "Juniper Catering", amount: "-154.97", entered_by: "clerk_c", entered_at: new Date("2026-04-28T13:11:54Z") },
            { id: 198, book: "main_current_account", entry_date: "2026-04-28", reference: "CHQ 002849", counterparty: "Nettle Labs", amount: "-2519.80", entered_by: "clerk_b", entered_at: new Date("2026-04-28T10:22:25Z") },
            { id: 199, book: "main_current_account", entry_date: "2026-04-29", reference: "CHQ 002597", counterparty: "Nettle Catering", amount: "-1736.84", entered_by: "clerk_c", entered_at: new Date("2026-04-29T10:32:13Z") },
            { id: 200, book: "main_current_account", entry_date: "2026-04-29", reference: "BILL-9380", counterparty: "Briar Supplies", amount: "-1463.79", entered_by: "clerk_b", entered_at: new Date("2026-04-29T10:56:58Z") },
            { id: 201, book: "main_current_account", entry_date: "2026-04-29", reference: "BILL-7508", counterparty: "Marlow Packaging", amount: "-435.54", entered_by: "clerk_a", entered_at: new Date("2026-04-29T15:15:57Z") },
            { id: 202, book: "main_current_account", entry_date: "2026-04-29", reference: "BILL-8182", counterparty: "Nettle Labs", amount: "-1378.25", entered_by: "clerk_a", entered_at: new Date("2026-04-29T10:41:46Z") },
            { id: 203, book: "main_current_account", entry_date: "2026-04-29", reference: "BILL-8564", counterparty: "Nettle Catering", amount: "-94.16", entered_by: "clerk_a", entered_at: new Date("2026-04-29T18:46:29Z") },
            { id: 204, book: "main_current_account", entry_date: "2026-04-29", reference: "CHQ 002982", counterparty: "Nettle Catering", amount: "-47.03", entered_by: "clerk_b", entered_at: new Date("2026-04-29T10:55:27Z") },
            { id: 205, book: "main_current_account", entry_date: "2026-04-29", reference: "CHQ 002429", counterparty: "Pellam Foods", amount: "-263.82", entered_by: "clerk_c", entered_at: new Date("2026-04-29T13:50:08Z") },
            { id: 206, book: "main_current_account", entry_date: "2026-04-29", reference: "INV-21846", counterparty: "Lowther Textiles", amount: "1159.29", entered_by: "clerk_a", entered_at: new Date("2026-04-29T12:16:49Z") },
            { id: 207, book: "main_current_account", entry_date: "2026-04-30", reference: "BILL-8534", counterparty: "Orchard Packaging", amount: "-3141.70", entered_by: "clerk_b", entered_at: new Date("2026-04-30T21:21:34Z") },
            { id: 208, book: "main_current_account", entry_date: "2026-04-30", reference: "BILL-8675", counterparty: "Marlow Packaging", amount: "-300.42", entered_by: "clerk_b", entered_at: new Date("2026-04-30T12:56:14Z") },
            { id: 209, book: "main_current_account", entry_date: "2026-04-30", reference: "BILL-7535", counterparty: "Juniper Freight", amount: "-2433.68", entered_by: "clerk_a", entered_at: new Date("2026-04-30T05:11:27Z") },
            { id: 210, book: "main_current_account", entry_date: "2026-04-30", reference: "BILL-8073", counterparty: "Juniper Freight", amount: "-1074.10", entered_by: "clerk_a", entered_at: new Date("2026-04-30T14:52:00Z") },
            { id: 211, book: "main_current_account", entry_date: "2026-04-30", reference: "CHQ 002744", counterparty: "Orchard Packaging", amount: "-108.60", entered_by: "clerk_b", entered_at: new Date("2026-04-30T12:47:08Z") },
            { id: 212, book: "main_current_account", entry_date: "2026-04-30", reference: "INV-21511", counterparty: "Corvid Supplies", amount: "2433.49", entered_by: "clerk_a", entered_at: new Date("2026-04-30T13:54:53Z") },
        ],
    });
    await prisma.match_key.createMany({
        data: [
            { id: 1, book: "main_current_account", ledger_entry_no: "1", bank_line_no: "4", kind: "exact" },
            { id: 2, book: "main_current_account", ledger_entry_no: "2", bank_line_no: "1", kind: "exact" },
            { id: 3, book: "main_current_account", ledger_entry_no: "3", bank_line_no: "12", kind: "exact" },
            { id: 4, book: "main_current_account", ledger_entry_no: "4", bank_line_no: "5", kind: "exact" },
            { id: 5, book: "main_current_account", ledger_entry_no: "5", bank_line_no: "21", kind: "exact" },
            { id: 6, book: "main_current_account", ledger_entry_no: "6", bank_line_no: "2", kind: "exact" },
            { id: 7, book: "main_current_account", ledger_entry_no: "7", bank_line_no: "7", kind: "exact" },
            { id: 8, book: "main_current_account", ledger_entry_no: "8", bank_line_no: "16", kind: "exact" },
            { id: 9, book: "main_current_account", ledger_entry_no: "9", bank_line_no: "133", kind: "late_posting" },
            { id: 10, book: "main_current_account", ledger_entry_no: "10", bank_line_no: "18", kind: "exact" },
            { id: 11, book: "main_current_account", ledger_entry_no: "11", bank_line_no: "9", kind: "exact" },
            { id: 12, book: "main_current_account", ledger_entry_no: "12", bank_line_no: "11", kind: "exact" },
            { id: 13, book: "main_current_account", ledger_entry_no: "13", bank_line_no: "13", kind: "exact" },
            { id: 14, book: "main_current_account", ledger_entry_no: "14", bank_line_no: "14", kind: "exact" },
            { id: 15, book: "main_current_account", ledger_entry_no: "15", bank_line_no: "6", kind: "exact" },
            { id: 16, book: "main_current_account", ledger_entry_no: "16", bank_line_no: "50", kind: "exact" },
            { id: 17, book: "main_current_account", ledger_entry_no: "17", bank_line_no: "34", kind: "exact" },
            { id: 18, book: "main_current_account", ledger_entry_no: "18", bank_line_no: "8", kind: "exact" },
            { id: 19, book: "main_current_account", ledger_entry_no: "19", bank_line_no: "134", kind: "late_posting" },
            { id: 20, book: "main_current_account", ledger_entry_no: "20", bank_line_no: "135", kind: "late_posting" },
            { id: 21, book: "main_current_account", ledger_entry_no: "23", bank_line_no: "10", kind: "exact" },
            { id: 22, book: "main_current_account", ledger_entry_no: "24", bank_line_no: "15", kind: "exact" },
            { id: 23, book: "main_current_account", ledger_entry_no: "25", bank_line_no: "20", kind: "exact" },
            { id: 24, book: "main_current_account", ledger_entry_no: "26", bank_line_no: "29", kind: "exact" },
            { id: 25, book: "main_current_account", ledger_entry_no: "27", bank_line_no: "23", kind: "exact" },
            { id: 26, book: "main_current_account", ledger_entry_no: "28", bank_line_no: "35", kind: "exact" },
            { id: 27, book: "main_current_account", ledger_entry_no: "29", bank_line_no: "26", kind: "exact" },
            { id: 28, book: "main_current_account", ledger_entry_no: "30", bank_line_no: "27", kind: "exact" },
            { id: 29, book: "main_current_account", ledger_entry_no: "31", bank_line_no: "17", kind: "exact" },
            { id: 30, book: "main_current_account", ledger_entry_no: "32", bank_line_no: "122", kind: "late_posting" },
            { id: 31, book: "main_current_account", ledger_entry_no: "33", bank_line_no: "39", kind: "net_of_fee" },
            { id: 32, book: "main_current_account", ledger_entry_no: "34", bank_line_no: "19", kind: "exact" },
            { id: 33, book: "main_current_account", ledger_entry_no: "35", bank_line_no: "31", kind: "exact" },
            { id: 34, book: "main_current_account", ledger_entry_no: "36", bank_line_no: "22", kind: "exact" },
            { id: 35, book: "main_current_account", ledger_entry_no: "37", bank_line_no: "24", kind: "exact" },
            { id: 36, book: "main_current_account", ledger_entry_no: "38", bank_line_no: "25", kind: "exact" },
            { id: 37, book: "main_current_account", ledger_entry_no: "39", bank_line_no: "33", kind: "exact" },
            { id: 38, book: "main_current_account", ledger_entry_no: "40", bank_line_no: "38", kind: "net_of_fee" },
            { id: 39, book: "main_current_account", ledger_entry_no: "41", bank_line_no: "28", kind: "exact" },
            { id: 40, book: "main_current_account", ledger_entry_no: "42", bank_line_no: "48", kind: "exact" },
            { id: 41, book: "main_current_account", ledger_entry_no: "43", bank_line_no: "30", kind: "exact" },
            { id: 42, book: "main_current_account", ledger_entry_no: "44", bank_line_no: "41", kind: "exact" },
            { id: 43, book: "main_current_account", ledger_entry_no: "45", bank_line_no: "42", kind: "exact" },
            { id: 44, book: "main_current_account", ledger_entry_no: "46", bank_line_no: "32", kind: "exact" },
            { id: 45, book: "main_current_account", ledger_entry_no: "47", bank_line_no: "49", kind: "exact" },
            { id: 46, book: "main_current_account", ledger_entry_no: "48", bank_line_no: "43", kind: "exact" },
            { id: 47, book: "main_current_account", ledger_entry_no: "49", bank_line_no: "52", kind: "exact" },
            { id: 48, book: "main_current_account", ledger_entry_no: "50", bank_line_no: "132", kind: "late_posting" },
            { id: 49, book: "main_current_account", ledger_entry_no: "51", bank_line_no: "36", kind: "net_of_fee" },
            { id: 50, book: "main_current_account", ledger_entry_no: "52", bank_line_no: "37", kind: "net_of_fee" },
            { id: 51, book: "main_current_account", ledger_entry_no: "53", bank_line_no: "55", kind: "exact" },
            { id: 52, book: "main_current_account", ledger_entry_no: "54", bank_line_no: "46", kind: "exact" },
            { id: 53, book: "main_current_account", ledger_entry_no: "55", bank_line_no: "40", kind: "exact" },
            { id: 54, book: "main_current_account", ledger_entry_no: "56", bank_line_no: "47", kind: "exact" },
            { id: 55, book: "main_current_account", ledger_entry_no: "57", bank_line_no: "44", kind: "exact" },
            { id: 56, book: "main_current_account", ledger_entry_no: "58", bank_line_no: "60", kind: "exact" },
            { id: 57, book: "main_current_account", ledger_entry_no: "59", bank_line_no: "53", kind: "transposed" },
            { id: 58, book: "main_current_account", ledger_entry_no: "60", bank_line_no: "45", kind: "exact" },
            { id: 59, book: "main_current_account", ledger_entry_no: "61", bank_line_no: "57", kind: "exact" },
            { id: 60, book: "main_current_account", ledger_entry_no: "62", bank_line_no: "64", kind: "exact" },
            { id: 61, book: "main_current_account", ledger_entry_no: "63", bank_line_no: "65", kind: "exact" },
            { id: 62, book: "main_current_account", ledger_entry_no: "64", bank_line_no: "96", kind: "exact" },
            { id: 63, book: "main_current_account", ledger_entry_no: "65", bank_line_no: "75", kind: "exact" },
            { id: 64, book: "main_current_account", ledger_entry_no: "66", bank_line_no: "76", kind: "exact" },
            { id: 65, book: "main_current_account", ledger_entry_no: "67", bank_line_no: "59", kind: "exact" },
            { id: 66, book: "main_current_account", ledger_entry_no: "68", bank_line_no: "51", kind: "exact" },
            { id: 67, book: "main_current_account", ledger_entry_no: "69", bank_line_no: "61", kind: "same_amount_same_day" },
            { id: 68, book: "main_current_account", ledger_entry_no: "70", bank_line_no: "62", kind: "same_amount_same_day" },
            { id: 69, book: "main_current_account", ledger_entry_no: "71", bank_line_no: "56", kind: "exact" },
            { id: 70, book: "main_current_account", ledger_entry_no: "72", bank_line_no: "58", kind: "exact" },
            { id: 71, book: "main_current_account", ledger_entry_no: "73", bank_line_no: "120", kind: "exact" },
            { id: 72, book: "main_current_account", ledger_entry_no: "74", bank_line_no: "68", kind: "exact" },
            { id: 73, book: "main_current_account", ledger_entry_no: "75", bank_line_no: "69", kind: "exact" },
            { id: 74, book: "main_current_account", ledger_entry_no: "76", bank_line_no: "81", kind: "exact" },
            { id: 75, book: "main_current_account", ledger_entry_no: "77", bank_line_no: "63", kind: "exact" },
            { id: 76, book: "main_current_account", ledger_entry_no: "78", bank_line_no: "82", kind: "exact" },
            { id: 77, book: "main_current_account", ledger_entry_no: "79", bank_line_no: "71", kind: "exact" },
            { id: 78, book: "main_current_account", ledger_entry_no: "80", bank_line_no: "72", kind: "exact" },
            { id: 79, book: "main_current_account", ledger_entry_no: "81", bank_line_no: "66", kind: "exact" },
            { id: 80, book: "main_current_account", ledger_entry_no: "82", bank_line_no: "67", kind: "exact" },
            { id: 81, book: "main_current_account", ledger_entry_no: "83", bank_line_no: "74", kind: "exact" },
            { id: 82, book: "main_current_account", ledger_entry_no: "84", bank_line_no: "85", kind: "exact" },
            { id: 83, book: "main_current_account", ledger_entry_no: "85", bank_line_no: "88", kind: "exact" },
            { id: 84, book: "main_current_account", ledger_entry_no: "86", bank_line_no: "89", kind: "exact" },
            { id: 85, book: "main_current_account", ledger_entry_no: "87", bank_line_no: "77", kind: "exact" },
            { id: 86, book: "main_current_account", ledger_entry_no: "88", bank_line_no: "70", kind: "exact" },
            { id: 87, book: "main_current_account", ledger_entry_no: "89", bank_line_no: "94", kind: "exact" },
            { id: 88, book: "main_current_account", ledger_entry_no: "90", bank_line_no: "83", kind: "exact" },
            { id: 89, book: "main_current_account", ledger_entry_no: "91", bank_line_no: "73", kind: "exact" },
            { id: 90, book: "main_current_account", ledger_entry_no: "92", bank_line_no: "84", kind: "exact" },
            { id: 91, book: "main_current_account", ledger_entry_no: "93", bank_line_no: "121", kind: "exact" },
            { id: 92, book: "main_current_account", ledger_entry_no: "94", bank_line_no: "87", kind: "exact" },
            { id: 93, book: "main_current_account", ledger_entry_no: "95", bank_line_no: "90", kind: "exact" },
            { id: 94, book: "main_current_account", ledger_entry_no: "95", bank_line_no: "91", kind: "duplicate_line" },
            { id: 95, book: "main_current_account", ledger_entry_no: "96", bank_line_no: "80", kind: "exact" },
            { id: 96, book: "main_current_account", ledger_entry_no: "97", bank_line_no: "100", kind: "exact" },
            { id: 97, book: "main_current_account", ledger_entry_no: "98", bank_line_no: "101", kind: "exact" },
            { id: 98, book: "main_current_account", ledger_entry_no: "99", bank_line_no: "102", kind: "exact" },
            { id: 99, book: "main_current_account", ledger_entry_no: "100", bank_line_no: "103", kind: "exact" },
            { id: 100, book: "main_current_account", ledger_entry_no: "101", bank_line_no: "95", kind: "exact" },
            { id: 101, book: "main_current_account", ledger_entry_no: "102", bank_line_no: "106", kind: "exact" },
            { id: 102, book: "main_current_account", ledger_entry_no: "103", bank_line_no: "108", kind: "exact" },
            { id: 103, book: "main_current_account", ledger_entry_no: "104", bank_line_no: "86", kind: "exact" },
            { id: 104, book: "main_current_account", ledger_entry_no: "105", bank_line_no: "111", kind: "exact" },
            { id: 105, book: "main_current_account", ledger_entry_no: "106", bank_line_no: "98", kind: "exact" },
            { id: 106, book: "main_current_account", ledger_entry_no: "107", bank_line_no: "113", kind: "transposed" },
            { id: 107, book: "main_current_account", ledger_entry_no: "108", bank_line_no: "92", kind: "exact" },
            { id: 108, book: "main_current_account", ledger_entry_no: "109", bank_line_no: "93", kind: "exact" },
            { id: 109, book: "main_current_account", ledger_entry_no: "110", bank_line_no: "104", kind: "exact" },
            { id: 110, book: "main_current_account", ledger_entry_no: "111", bank_line_no: "105", kind: "exact" },
            { id: 111, book: "main_current_account", ledger_entry_no: "112", bank_line_no: "109", kind: "exact" },
            { id: 112, book: "main_current_account", ledger_entry_no: "113", bank_line_no: "97", kind: "exact" },
            { id: 113, book: "main_current_account", ledger_entry_no: "114", bank_line_no: "114", kind: "same_amount_same_day" },
            { id: 114, book: "main_current_account", ledger_entry_no: "115", bank_line_no: "115", kind: "same_amount_same_day" },
            { id: 115, book: "main_current_account", ledger_entry_no: "116", bank_line_no: "116", kind: "exact" },
            { id: 116, book: "main_current_account", ledger_entry_no: "117", bank_line_no: "117", kind: "exact" },
            { id: 117, book: "main_current_account", ledger_entry_no: "118", bank_line_no: "125", kind: "exact" },
            { id: 118, book: "main_current_account", ledger_entry_no: "119", bank_line_no: "127", kind: "exact" },
            { id: 119, book: "main_current_account", ledger_entry_no: "120", bank_line_no: "119", kind: "exact" },
            { id: 120, book: "main_current_account", ledger_entry_no: "121", bank_line_no: "107", kind: "exact" },
            { id: 121, book: "main_current_account", ledger_entry_no: "122", bank_line_no: "110", kind: "exact" },
            { id: 122, book: "main_current_account", ledger_entry_no: "123", bank_line_no: "150", kind: "exact" },
            { id: 123, book: "main_current_account", ledger_entry_no: "124", bank_line_no: "172", kind: "exact" },
            { id: 124, book: "main_current_account", ledger_entry_no: "125", bank_line_no: "173", kind: "exact" },
            { id: 125, book: "main_current_account", ledger_entry_no: "126", bank_line_no: "189", kind: "exact" },
            { id: 126, book: "main_current_account", ledger_entry_no: "127", bank_line_no: "112", kind: "exact" },
            { id: 127, book: "main_current_account", ledger_entry_no: "128", bank_line_no: "124", kind: "exact" },
            { id: 128, book: "main_current_account", ledger_entry_no: "129", bank_line_no: "118", kind: "exact" },
            { id: 129, book: "main_current_account", ledger_entry_no: "130", bank_line_no: "145", kind: "exact" },
            { id: 130, book: "main_current_account", ledger_entry_no: "131", bank_line_no: "147", kind: "exact" },
            { id: 131, book: "main_current_account", ledger_entry_no: "132", bank_line_no: "128", kind: "exact" },
            { id: 132, book: "main_current_account", ledger_entry_no: "133", bank_line_no: "129", kind: "exact" },
            { id: 133, book: "main_current_account", ledger_entry_no: "134", bank_line_no: "149", kind: "exact" },
            { id: 134, book: "main_current_account", ledger_entry_no: "135", bank_line_no: "130", kind: "exact" },
            { id: 135, book: "main_current_account", ledger_entry_no: "136", bank_line_no: "188", kind: "exact" },
            { id: 136, book: "main_current_account", ledger_entry_no: "137", bank_line_no: "153", kind: "exact" },
            { id: 137, book: "main_current_account", ledger_entry_no: "138", bank_line_no: "138", kind: "same_amount_same_day" },
            { id: 138, book: "main_current_account", ledger_entry_no: "139", bank_line_no: "139", kind: "same_amount_same_day" },
            { id: 139, book: "main_current_account", ledger_entry_no: "140", bank_line_no: "123", kind: "exact" },
            { id: 140, book: "main_current_account", ledger_entry_no: "141", bank_line_no: "141", kind: "exact" },
            { id: 141, book: "main_current_account", ledger_entry_no: "142", bank_line_no: "142", kind: "exact" },
            { id: 142, book: "main_current_account", ledger_entry_no: "143", bank_line_no: "126", kind: "exact" },
            { id: 143, book: "main_current_account", ledger_entry_no: "144", bank_line_no: "143", kind: "exact" },
            { id: 144, book: "main_current_account", ledger_entry_no: "145", bank_line_no: "144", kind: "exact" },
            { id: 145, book: "main_current_account", ledger_entry_no: "146", bank_line_no: "158", kind: "exact" },
            { id: 146, book: "main_current_account", ledger_entry_no: "147", bank_line_no: "151", kind: "exact" },
            { id: 147, book: "main_current_account", ledger_entry_no: "148", bank_line_no: "204", kind: "exact" },
            { id: 148, book: "main_current_account", ledger_entry_no: "149", bank_line_no: "160", kind: "exact" },
            { id: 149, book: "main_current_account", ledger_entry_no: "150", bank_line_no: "131", kind: "exact" },
            { id: 150, book: "main_current_account", ledger_entry_no: "151", bank_line_no: "136", kind: "net_of_fee" },
            { id: 151, book: "main_current_account", ledger_entry_no: "152", bank_line_no: "137", kind: "transposed" },
            { id: 152, book: "main_current_account", ledger_entry_no: "153", bank_line_no: "154", kind: "exact" },
            { id: 153, book: "main_current_account", ledger_entry_no: "153", bank_line_no: "155", kind: "duplicate_line" },
            { id: 154, book: "main_current_account", ledger_entry_no: "154", bank_line_no: "156", kind: "exact" },
            { id: 155, book: "main_current_account", ledger_entry_no: "155", bank_line_no: "168", kind: "exact" },
            { id: 156, book: "main_current_account", ledger_entry_no: "156", bank_line_no: "146", kind: "exact" },
            { id: 157, book: "main_current_account", ledger_entry_no: "157", bank_line_no: "148", kind: "exact" },
            { id: 158, book: "main_current_account", ledger_entry_no: "158", bank_line_no: "171", kind: "exact" },
            { id: 159, book: "main_current_account", ledger_entry_no: "159", bank_line_no: "152", kind: "exact" },
            { id: 160, book: "main_current_account", ledger_entry_no: "160", bank_line_no: "161", kind: "exact" },
            { id: 161, book: "main_current_account", ledger_entry_no: "160", bank_line_no: "162", kind: "duplicate_line" },
            { id: 162, book: "main_current_account", ledger_entry_no: "161", bank_line_no: "163", kind: "same_amount_same_day" },
            { id: 163, book: "main_current_account", ledger_entry_no: "162", bank_line_no: "164", kind: "same_amount_same_day" },
            { id: 164, book: "main_current_account", ledger_entry_no: "163", bank_line_no: "175", kind: "exact" },
            { id: 165, book: "main_current_account", ledger_entry_no: "164", bank_line_no: "177", kind: "exact" },
            { id: 166, book: "main_current_account", ledger_entry_no: "165", bank_line_no: "157", kind: "exact" },
            { id: 167, book: "main_current_account", ledger_entry_no: "166", bank_line_no: "178", kind: "exact" },
            { id: 168, book: "main_current_account", ledger_entry_no: "167", bank_line_no: "167", kind: "exact" },
            { id: 169, book: "main_current_account", ledger_entry_no: "168", bank_line_no: "179", kind: "exact" },
            { id: 170, book: "main_current_account", ledger_entry_no: "169", bank_line_no: "170", kind: "exact" },
            { id: 171, book: "main_current_account", ledger_entry_no: "170", bank_line_no: "159", kind: "exact" },
            { id: 172, book: "main_current_account", ledger_entry_no: "172", bank_line_no: "176", kind: "exact" },
            { id: 173, book: "main_current_account", ledger_entry_no: "173", bank_line_no: "166", kind: "exact" },
            { id: 174, book: "main_current_account", ledger_entry_no: "174", bank_line_no: "169", kind: "exact" },
            { id: 175, book: "main_current_account", ledger_entry_no: "175", bank_line_no: "181", kind: "exact" },
            { id: 176, book: "main_current_account", ledger_entry_no: "176", bank_line_no: "182", kind: "exact" },
            { id: 177, book: "main_current_account", ledger_entry_no: "177", bank_line_no: "174", kind: "exact" },
            { id: 178, book: "main_current_account", ledger_entry_no: "178", bank_line_no: "192", kind: "exact" },
            { id: 179, book: "main_current_account", ledger_entry_no: "179", bank_line_no: "194", kind: "exact" },
            { id: 180, book: "main_current_account", ledger_entry_no: "180", bank_line_no: "180", kind: "exact" },
            { id: 181, book: "main_current_account", ledger_entry_no: "182", bank_line_no: "197", kind: "exact" },
            { id: 182, book: "main_current_account", ledger_entry_no: "184", bank_line_no: "190", kind: "exact" },
            { id: 183, book: "main_current_account", ledger_entry_no: "185", bank_line_no: "191", kind: "net_of_fee" },
            { id: 184, book: "main_current_account", ledger_entry_no: "186", bank_line_no: "198", kind: "transposed" },
            { id: 185, book: "main_current_account", ledger_entry_no: "188", bank_line_no: "184", kind: "exact" },
            { id: 186, book: "main_current_account", ledger_entry_no: "189", bank_line_no: "193", kind: "exact" },
            { id: 187, book: "main_current_account", ledger_entry_no: "190", bank_line_no: "199", kind: "exact" },
            { id: 188, book: "main_current_account", ledger_entry_no: "191", bank_line_no: "185", kind: "exact" },
            { id: 189, book: "main_current_account", ledger_entry_no: "192", bank_line_no: "186", kind: "exact" },
            { id: 190, book: "main_current_account", ledger_entry_no: "193", bank_line_no: "187", kind: "exact" },
            { id: 191, book: "main_current_account", ledger_entry_no: "194", bank_line_no: "201", kind: "exact" },
            { id: 192, book: "main_current_account", ledger_entry_no: "195", bank_line_no: "202", kind: "exact" },
            { id: 193, book: "main_current_account", ledger_entry_no: "197", bank_line_no: "206", kind: "exact" },
            { id: 194, book: "main_current_account", ledger_entry_no: "200", bank_line_no: "195", kind: "exact" },
            { id: 195, book: "main_current_account", ledger_entry_no: "201", bank_line_no: "203", kind: "exact" },
            { id: 196, book: "main_current_account", ledger_entry_no: "202", bank_line_no: "196", kind: "exact" },
            { id: 197, book: "main_current_account", ledger_entry_no: "207", bank_line_no: "200", kind: "exact" },
            { id: 198, book: "main_current_account", ledger_entry_no: "210", bank_line_no: "205", kind: "exact" },
        ],
    });
    await prisma.unmatched_key.createMany({
        data: [
            { id: 1, book: "main_current_account", side: "bank", record_no: "3", reason: "bank_fee" },
            { id: 2, book: "main_current_account", side: "bank", record_no: "54", reason: "bank_fee" },
            { id: 3, book: "main_current_account", side: "bank", record_no: "78", reason: "direct_debit_not_booked" },
            { id: 4, book: "main_current_account", side: "bank", record_no: "79", reason: "direct_debit_not_booked" },
            { id: 5, book: "main_current_account", side: "bank", record_no: "99", reason: "unidentified_credit" },
            { id: 6, book: "main_current_account", side: "bank", record_no: "140", reason: "direct_debit_not_booked" },
            { id: 7, book: "main_current_account", side: "bank", record_no: "165", reason: "unidentified_credit" },
            { id: 8, book: "main_current_account", side: "bank", record_no: "183", reason: "returned_item" },
            { id: 9, book: "main_current_account", side: "bank", record_no: "207", reason: "interest" },
            { id: 10, book: "main_current_account", side: "ledger", record_no: "21", reason: "never_cleared" },
            { id: 11, book: "main_current_account", side: "ledger", record_no: "22", reason: "never_cleared" },
            { id: 12, book: "main_current_account", side: "ledger", record_no: "171", reason: "outstanding_cheque" },
            { id: 13, book: "main_current_account", side: "ledger", record_no: "181", reason: "outstanding_cheque" },
            { id: 14, book: "main_current_account", side: "ledger", record_no: "183", reason: "outstanding_cheque" },
            { id: 15, book: "main_current_account", side: "ledger", record_no: "187", reason: "outstanding_cheque" },
            { id: 16, book: "main_current_account", side: "ledger", record_no: "196", reason: "outstanding_cheque" },
            { id: 17, book: "main_current_account", side: "ledger", record_no: "198", reason: "outstanding_cheque" },
            { id: 18, book: "main_current_account", side: "ledger", record_no: "199", reason: "outstanding_cheque" },
            { id: 19, book: "main_current_account", side: "ledger", record_no: "203", reason: "outstanding_cheque" },
            { id: 20, book: "main_current_account", side: "ledger", record_no: "204", reason: "outstanding_cheque" },
            { id: 21, book: "main_current_account", side: "ledger", record_no: "205", reason: "outstanding_cheque" },
            { id: 22, book: "main_current_account", side: "ledger", record_no: "206", reason: "deposit_in_transit" },
            { id: 23, book: "main_current_account", side: "ledger", record_no: "208", reason: "outstanding_cheque" },
            { id: 24, book: "main_current_account", side: "ledger", record_no: "209", reason: "outstanding_cheque" },
            { id: 25, book: "main_current_account", side: "ledger", record_no: "211", reason: "outstanding_cheque" },
            { id: 26, book: "main_current_account", side: "ledger", record_no: "212", reason: "deposit_in_transit" },
        ],
    });
}

main()
    .then(() => prisma.$disconnect())
    .catch(async error => {
        console.error(error);
        await prisma.$disconnect();
        process.exit(1);
    });