-
Five new bank CSV layouts: three were misread, now fixed
ai-bookkeeper now reads Qonto, Tide and Novo exports correctly. Before, Qonto and Tide gave wrong descriptions and Qonto and Tide swapped day and month.
-
Gap probe 22: 23 bank descriptors for five trades, 9 filed before the rules
ai-bookkeeper filed 9 of 23 made-up descriptors for mobile notaries, piano tuners, florists, tattoo artists and pool installers. New rules file all 23.
-
Why a Stripe export needs the payout column
A plain Stripe balance export can't be matched to a bank deposit. ai-bookkeeper now says which column to add instead of failing vaguely.
-
A damaged Excel file should not crash a bookkeeper
Random damage to two .xls bank statements found one crash in the reader: a corrupt date cell threw RangeError. Fixed, with the fuzz test.
-
A letterhead for the books: AI Bookkeeper's close pack, built but not for sale
AI Bookkeeper can render its close checks, P&L and balance sheet on a bookkeeper's own letterhead. Built behind a licence check, deliberately not on sale.
-
Bookkeeping rules for locksmiths, chimney sweeps, drone pilots, sign makers and brewers
A nineteenth probe of 25 made-up bank descriptors: 16 right before new rules, 25 after.
-
We fuzzed a bank-statement reader and it threw the wrong kind of error
Seeded damage to two .xlsx fixtures found that a corrupt worksheet leaked a raw stream TypeError instead of a readable message. Fixed, with a test.
-
Gap probe 20: 27 bank descriptors for five trades, 5 filed before the rules
ai-bookkeeper filed 5 of 27 made-up descriptors for acupuncturists, chiropractors, tailors, window cleaners and junk haulers. New rules file all 27.
-
Gap probe 21: 24 bank descriptors for five trades, 7 filed before the rules
ai-bookkeeper filed 7 of 24 made-up descriptors for carpet cleaners, appliance repairers, septic pumpers, welders and driving schools. New rules file all 24.
-
Testing a bank-file reader with files we generate
A BAI2 reader was tested on one hand-written file. Generating 300 files with known answers checks signs, dates and balances far harder.
-
Bookkeeping rules for wedding photographers, notaries, pool cleaners, court reporters and beekeepers
An eighteenth probe of 25 made-up bank descriptors: 16 right before new rules, 25 after.
-
Bookkeeping rules for freelance editors, podcast producers, virtual assistants, farriers and bounce-house renters
A seventeenth probe of 34 made-up bank descriptors: 14 right before new rules, 34 after.
-
Bookkeeping rules for drone pilots, mobile mechanics, cottage bakers, tutors and locksmiths
A sixteenth probe of 35 made-up bank descriptors: 21 right before new rules, 35 after.
-
Bookkeeping rules for pressure washers, jewelry makers, notaries, sign shops and beekeepers
An eleventh probe of 41 made-up bank descriptors: 17 right before new rules, 41 after. Two of the misses were wrong expectations of ours.
-
Bookkeeping rules for roofers, HVAC contractors, personal chefs, music teachers and massage therapists
A fifteenth probe of made-up bank descriptors: 15 of 30 right before new rules, 27 of 27 after.
-
Bookkeeping rules for house cleaners, landscapers, yoga teachers, potters and dog trainers
A fourteenth probe of 30 made-up bank descriptors: 18 right before new rules, 30 after.
-
Bookkeeping rules for florists, house painters, translators and process servers
A thirteenth probe of 40 made-up bank descriptors: 13 right before new rules, 40 after. Three misses were wrong expectations of ours.
-
Bookkeeping rules for florists, home inspectors, food trucks, translators and event planners
A twelfth probe of 34 made-up bank descriptors: 13 right before new rules, 34 after. Five of the misses were wrong expectations of ours.
-
Bookkeeping rules for truckers, farms, tattoo artists, trainers and wedding DJs
An eighth probe of 56 made-up bank descriptors: 33 right before new rules, 56 after. Three misses were our own bad expectations.
-
A fifth gap probe for ai-bookkeeper: 36 of 67 right before, 3 confidently wrong
We ran 67 bank descriptions for four kinds of small business through the built-in rules before changing anything: 36 right, 3 wrong, 28 no suggestion.
-
A fourth gap probe for ai-bookkeeper: 25 of 130 lines unsuggested
We ran about 130 common small-business bank descriptions through the built-in rules. 25 had no suggestion; we closed 11 and left 3 for a person on purpose.
-
Bookkeeping rules for rideshare drivers, photographers, pet groomers, home daycares and detailers
A ninth probe of 52 made-up bank descriptors: 32 right before new rules, 52 after. One miss was a clipper-card rule catching Wahl hair clippers.
-
Bookkeeping rules for salons, electricians, podcasters and print-on-demand shops
A seventh probe of 64 made-up bank descriptors: 46 right before new rules, 64 after. Most misses were our own wrong expectations.
-
A sixth gap probe for ai-bookkeeper: 47 of 79 right before, 4 confidently wrong
79 made-up bank descriptions for five more kinds of small business went through the built-in rules before any change: 47 right, 4 wrong, 28 no suggestion.
-
Bookkeeping rules for cottage bakers, drone pilots, locksmiths, streamers and locum clinicians
A tenth probe of 50 made-up bank descriptors: 22 right before new rules, 50 after. Two lines were dropped because an older test disagreed.
-
A 69-description probe found fifteen bank descriptions the bookkeeper left blank
Probing ai-bookkeeper's built-in rules with 69 common bank descriptions left 15 unsuggested; five were gaps we fixed, two we left blank on purpose.
-
A fifth gap probe: 16 more merchants the bookkeeper now files
We ran about 125 well-known merchant names through the built-in categorizer, found 16 it left blank, and added rules for 13 of them.
-
"Probing an AI bookkeeper with a German bank file and a property manager.
Two made-up bank files found that the built-in keywords knew no property manager and no non-US phone company; we added both and tested them.
-
Bookkeeping for movers and junk haulers, straight from a bank CSV
A new worked page for small moving crews: 13 of 14 lines in a synthetic November get an account with no rules taught.
-
Bookkeeping for pool service routes, straight from a bank CSV
A new worked page for pool route owners: 11 of 12 lines in a synthetic November get an account with no rules taught.
-
What happens when bookkeeping software learns your payees: 72% to 96% on a real bank file
A makerspace's real 2019-2023 bank exports, replayed in date order: built-in rules alone file 70% correctly, learning from each filed line reaches 96%.
-
150 random Stripe reports through the payout splitter: nothing broke
A seeded property test feeds made-up payout reports to ai-bookkeeper's splitter and checks parts add to net, the journal balances and a rerun finds nothing.
-
Pressure washing and window cleaning bookkeeping from a bank CSV
A new worked November for washing crews: Jobber payouts and HOA Zelles against gear, chemicals, fuel and insurance.
-
Probing a bookkeeper with 95 bank descriptions: what it missed
A cheap way to find gaps in a rules-based categorizer: feed it 95 common small-business descriptions and read what comes back blank.
-
Probing a bookkeeping categorizer with 90 everyday bank lines
Of about 90 common small-business bank descriptions, 15 got no suggestion; most were left blank on purpose, and four rule gaps were closed.
-
QuickBooks payroll debits were being filed as software
Probing the AI Bookkeeper rules with 70 common bank descriptions found a second payroll misfile: QuickBooks and Intuit payroll debits suggested as software.
-
A second gap probe: 139 more bank lines, 13 rule gaps closed
139 everyday descriptions from trades, restaurants, online shops and clinics: 23 got no suggestion; 13 were real gaps, now covered, 10 are blank on purpose.
-
Testing payment reminders on 150 random books
A seeded property test checks that every overdue-invoice reminder agrees with the ledger's aging report. It found no fault.
-
Yoga studio bookkeeping from a bank CSV, and a Gusto misfile we found on the way
A worked November for yoga and Pilates studios: ClassPass, Momence and Walla payouts against lease, payroll and props, plus a fix for payroll filed as software.
-
Fuzzing the bookkeeper's spreadsheet reader found a three-second stall
Mutating Excel and PDF fixtures byte by byte found one old .xls that stalled the free AI bookkeeper's reader for seconds. A two-line bound fixed it.
-
Bookkeeping for auto repair shops: six of thirteen lines had no account
ai-bookkeeper gets a worked October for an independent repair shop. Fleet-account payments, repair-data software, bay rent and the ASE fee had no rules.
-
Bookkeeping for massage therapists and estheticians, from a bank statement
A free worked October for a solo massage therapist: Square and Vagaro payouts against lotions, dues, a state licence and suite rent, booked from a bank CSV.
-
Cleaning business bookkeeping from a bank statement: nine lines, $837.20 profit
A synthetic September in AI Bookkeeper: $1,285.00 of Zelle, Thumbtack and Stripe deposits, $447.80 of costs, and one supply buy left for the owner to file.
-
A bookkeeping page for farmers-market and cottage-food vendors, and the three stores it had to learn
ai-bookkeeper gets a worked October for a market baker. Writing it exposed gaps: GFS, Sam's Club ingredient buys and packaging went unfiled.
-
Bookkeeping for food trucks: commissary rent, propane and festival fees
ai-bookkeeper gets a worked October for a food truck. Five of fifteen lines had no suggestion; a new rule block fills them.
-
A free tax calendar for freelancers and sellers, as an .ics file
AI Bookkeeper tax calendar is now a web page: federal, payroll, 1099-NEC and state sales tax dates as a list or an .ics file for your calendar.
-
We broke 11,100 bank statements and the reader never crashed
ai-bookkeeper's bank-statement reader was fed 85 fixtures cut, truncated, quote-injected and spliced with junk; none hit a programming error.
-
A bookkeeping page for home daycares, and the seven payees it had to learn
ai-bookkeeper gets a worked October for a solo home daycare. Half the lines went unfiled until tuition, craft supplies, NAFCC dues and CACFP fees got rules.
-
Bookkeeping for home inspectors: six of ten lines had no account
ai-bookkeeper gets a worked October for a solo home inspector. Software payouts, the thermal camera and the state licence had no rules.
-
Landscaping bookkeeping from a bank statement: ten lines, $1,357.30 profit
A synthetic September in AI Bookkeeper: $2,080.00 of HOA, Stripe and Square deposits, $722.70 of costs, and why a Home Depot receipt needs a second look.