Repository navigation
Expand file tree
/
Copy pathindex.html
More file actions
1 lines (1 loc) · 20.5 KB
/
Copy pathindex.html
File metadata and controls
1 lines (1 loc) · 20.5 KB
1
<!doctype html><html lang="en"><head><meta charset="utf-8"><link rel="icon" href="/favicon.ico" sizes="any"><link rel="icon" type="image/svg+xml" href="/favicon.svg"><link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png"><link rel="icon" type="image/png" sizes="192x192" href="/favicon-192x192.png"><link rel="apple-touch-icon" href="/apple-touch-icon.png"><meta name="theme-color" content="#4329AE"><meta name="msvalidate.01" content="07E5ED667F16F352F3E1015D80DF7AA1"><meta name="viewport" content="width=device-width,initial-scale=1"><title>ZeraBooks open data: bank statement formats, CSV specs and bookkeeping templates</title><meta name="description" content="Free, citeable bookkeeping reference files from ZeraBooks: bank statement layouts, CSV import specs, charts of accounts, reconciliation examples and month-end checklists."><link rel="canonical" href="https://zerabooks.github.io/"><style>body{font:16px/1.6 -apple-system,Segoe UI,Helvetica,Arial,sans-serif;max-width:860px;margin:0 auto;padding:24px 16px;color:#1f2328;background:#fff}a{color:#4329AE}table{border-collapse:collapse;display:block;overflow-x:auto}td,th{border:1px solid #d0d7de;padding:6px 10px}code{background:#f6f8fa;padding:2px 4px;border-radius:4px}pre{background:#f6f8fa;padding:12px;overflow-x:auto}header{border-bottom:1px solid #d0d7de;margin-bottom:24px;padding-bottom:12px}.box{background:#f6f8fa;border:1px solid #d0d7de;border-radius:8px;padding:12px 16px;margin:16px 0}footer{border-top:1px solid #d0d7de;margin-top:40px;padding-top:12px;font-size:14px;color:#57606a}</style></head><body><header><a href="https://zerabooks.github.io/">ZeraBooks open data</a> · <a href="https://www.zerabooks.com/">zerabooks.com</a></header><h1>ZeraBooks open data</h1><p>Free, citeable reference files for bookkeepers, accountants and developers: bank statement layouts, CSV import specs, charts of accounts, reconciliation examples, month-end checklists, industry bookkeeping kits, small checking scripts and sourced accounting statistics. Every sample file ties to its own totals, and every sample figure is fictional; the statistics datasets link each figure to its public source. Use them, change them and cite them.</p><table><thead><tr><th>Dataset</th><th>What is in it</th><th>Guide on zerabooks.com</th></tr></thead><tbody><tr><td><a href="/data/bank-statement-csv-standard/">Bank Statement CSV Standard</a></td><td>The field specification, 150 sample CSV files for QuickBooks Online, Xero, Sage, Zoho Books, Wave and FreshBooks across five countries, and a validator that checks a file before you import it.</td><td><a href="https://www.zerabooks.com/convert-bank-statement-to-csv">Bank statement to CSV</a></td></tr><tr><td><a href="/data/bank-statement-formats/">Bank statement formats</a></td><td>How Chase, Bank of America, Wells Fargo, Capital One, RBC and TD lay out their statement PDFs, with converted sample months that tie to the printed balances, plus fictional QFX and OFX samples.</td><td><a href="https://www.zerabooks.com/bank-statement-converter">Bank statement converter</a></td></tr><tr><td><a href="/data/us-bank-statement-layouts/">U.S. bank statement layouts</a></td><td>How Citi, U.S. Bank, TD Bank, PNC and American Express typically print their statement PDFs (columns, trailing minus signs, dates with no year, combined accounts, card members) and the check that catches each conversion error, with five fictional sample months that tie.</td><td><a href="https://www.zerabooks.com/bank-statement-converter">Bank statement converter</a></td></tr><tr><td><a href="/data/regional-bank-statement-layouts/">Regional bank statement layouts</a></td><td>How Regions, Truist, Huntington, Citizens and Fifth Third typically print their statement PDFs (activity split by kind, direction in the headings, separate credit and debit columns, analysis statements, daily balance pages) and the check that catches each conversion error, with five fictional sample months that tie.</td><td><a href="https://www.zerabooks.com/bank-statement-converter">Bank statement converter</a></td></tr><tr><td><a href="/data/fintech-business-bank-statements/">Fintech business bank statements</a></td><td>Where Chime, Bluevine, Mercury, Relay, Novo and Brex keep their statement PDFs, when each month is ready, which bank stands behind them and what their CSV exports leave out, with two fictional months.</td><td><a href="https://www.zerabooks.com/chime-bank-statement-to-excel">Chime bank statement to Excel</a></td></tr><tr><td><a href="/data/card-statement-proof/">Credit card statement proof</a></td><td>The balance formula Discover, American Express, Capital One and Citi card statements tie to, the printed lines that aren't transactions (Cashback Bonus, rewards, foreign spend, year-end summaries), and four fictional card statements that tie.</td><td><a href="https://www.zerabooks.com/credit-card-statement-to-excel">Credit card statement to Excel</a></td></tr><tr><td><a href="/data/statement-retention-by-bank/">Statement retention by bank</a></td><td>How long 23 U.S. banks, card issuers and fintechs keep statements online, from their own pages, with unknowns marked, plus a fictional 84-statement catch-up plan.</td><td><a href="https://www.zerabooks.com/blog/how-long-to-keep-bank-statements">How long to keep bank statements</a></td></tr><tr><td><a href="/data/bank-statement-converters-compared/">Bank statement converters compared</a></td><td>What nine bank statement converters publish about free limits, prices, output formats, scanned PDFs and balance checks, each from the vendor's own page, dated.</td><td><a href="https://www.zerabooks.com/bank-statement-converter">Bank statement converter</a></td></tr><tr><td><a href="/data/pdf-statement-reconciliation-worksheet/">PDF statement reconciliation worksheet</a></td><td>A fill-in CSV for reconciling a month from a PDF bank statement: the statement against its printed balances, then the book balance with deposits in transit and outstanding checks. Worked fictional example.</td><td><a href="https://www.zerabooks.com/bank-reconciliation-software">Bank reconciliation software</a></td></tr><tr><td><a href="/data/ai-bookkeeping-tools-pricing/">AI bookkeeping tools pricing</a></td><td>Published prices for 13 AI bookkeeping, accounting and document capture tools (Booke AI, Docyt, Digits, Puzzle, Zeni, Rillet, QuickBooks Online, Xero, Dext, Hubdoc, AutoEntry, Nanonets, ZeraBooks), each with the date it was checked and its source page.</td><td><a href="https://www.zerabooks.com/best-ai-accounting-software">Best AI accounting software</a></td></tr><tr><td><a href="/data/statement-to-csv-spec/">Statement to CSV spec</a></td><td>Column layouts for bank and credit card statements, Xero imports, invoices and financial statements, each with a fictional sample file and the formula that proves it is complete.</td><td><a href="https://www.zerabooks.com/convert-bank-statement-to-csv">Bank statement to CSV</a></td></tr><tr><td><a href="/data/chart-of-accounts-templates/">Chart of accounts templates</a></td><td>Starter charts of accounts as CSV files for nonprofits, restaurants, law firms, contractors, property managers, startups and trucking companies, numbered and ready to import.</td><td><a href="https://www.zerabooks.com/chart-of-accounts-template">Chart of accounts template</a></td></tr><tr><td><a href="/data/reconciliation-examples/">Reconciliation examples</a></td><td>Worked reconciliation examples, each a small fictional data file that adds up exactly: proof of cash, combined statements, a provider switch tie-out, scanned statement misreads, a sales tax roll-forward and more.</td><td><a href="https://www.zerabooks.com/how-to-do-a-bank-reconciliation">How to do a bank reconciliation</a></td></tr><tr><td><a href="/data/month-end-checklists/">Month-end checklists</a></td><td>Month-end close checklists for small businesses and restaurants in Markdown, each with a CSV tracker the bookkeeper fills in each month.</td><td><a href="https://www.zerabooks.com/month-end-close-checklist">Month-end close checklist</a></td></tr><tr><td><a href="/data/trucking-settlement-to-ledger/">Trucking settlement to ledger</a></td><td>A mapping table from weekly trucking settlement lines to accounts, two fictional settlements and a Python script that checks each settlement against its printed total and bank deposit before printing a balanced journal entry. A week that doesn't tie, or has a line nobody has mapped, waits instead of posting.</td><td><a href="https://www.zerabooks.com/trucking-bookkeeping-automation">Trucking bookkeeping automation</a></td></tr><tr><td><a href="/data/owner-operator-bookkeeping-kit/">Owner-operator bookkeeping kit</a></td><td>Files a one-truck owner-operator needs to keep books from the cab: a ten-account starter chart, the weekly routine as a checklist and log, and a cost per mile calculator as a script and a spreadsheet, worked on a fictional September. Also a list of records to keep and for how long.</td><td><a href="https://www.zerabooks.com/owner-operator-bookkeeping">Owner-operator bookkeeping</a></td></tr><tr><td><a href="/data/trucking-bookkeeping-checklist/">Trucking bookkeeping checklist</a></td><td>The monthly bookkeeping checklist for a small carrier or owner-operator in Markdown, from collecting settlements and fuel card statements to reviewing cost per mile, with a CSV tracker per month. Includes a calendar of IFTA, Form 2290, IRP and estimated tax dates and what the books supply for each.</td><td><a href="https://www.zerabooks.com/trucking-bookkeeping-checklist">Trucking bookkeeping checklist</a></td></tr><tr><td><a href="/data/bookkeeping-automation-task-map/">Bookkeeping automation task map</a></td><td>A map of 15 recurring bookkeeping tasks showing what software can do and the review step that stays with the bookkeeper. A time log and a small script show where one client's month actually goes.</td><td><a href="https://www.zerabooks.com/bookkeeping-automation-for-bookkeepers">Bookkeeping automation for bookkeepers</a></td></tr><tr><td><a href="/data/cas-monthly-close-templates/">CAS monthly close templates</a></td><td>Templates for CPA firms running client accounting services: the monthly cycle step by step, a service menu, and a close tracker across every client. A script shows each client's next step and flags months signed off before they tie.</td><td><a href="https://www.zerabooks.com/client-accounting-services-automation">Client accounting services automation</a></td></tr><tr><td><a href="/data/month-end-adjusting-entries/">Month-end adjusting entries</a></td><td>A CSV schedule and a script that drafts each month's depreciation, prepaid spreads and loan interest with the calculation in the memo, so a reviewer can check every entry. Includes a log for the questions only the client can answer.</td><td><a href="https://www.zerabooks.com/for-accountants">Accounting software for accountants</a></td></tr><tr><td><a href="/data/statement-workpaper-layouts/">Statement workpaper layouts</a></td><td>Column mappings and a script that rearrange a converted bank statement into the layout a firm's workpapers or import template expect. The script then proves the rows and balances still tie. Includes a checklist for testing a converter on real client statements.</td><td><a href="https://www.zerabooks.com/for-firms">Bank statement converter for accounting firms</a></td></tr><tr><td><a href="/data/bookkeeping-onboarding-checklist/">Bookkeeping onboarding checklist</a></td><td>The documents and account list a business needs before a new bookkeeper can start, with U.S. and Canada items. A script compares statements received against every account and lists the missing months.</td><td><a href="https://www.zerabooks.com/catch-up-bookkeeping">Catch-up bookkeeping</a></td></tr><tr><td><a href="/data/salon-spa-bookkeeping-kit/">Salon and spa bookkeeping kit</a></td><td>A salon and spa chart of accounts, a month-end checklist and a fictional October that pulls card deposits apart into services, retail and tips. A short script checks that tips payable nets to zero and that the deposits tie to the month.</td><td><a href="https://www.zerabooks.com/bookkeeping-for-salons-and-spas">Bookkeeping for salons and spas</a></td></tr><tr><td><a href="/data/veterinary-bookkeeping-kit/">Veterinary bookkeeping kit</a></td><td>A veterinary practice chart of accounts that keeps services, pharmacy, drugs and outside labs apart, with a month-end checklist. The fictional September shows card and patient financing deposits grossed up and an equipment loan payment split into interest and principal.</td><td><a href="https://www.zerabooks.com/bookkeeping-for-veterinary-practices">Bookkeeping for veterinary practices</a></td></tr><tr><td><a href="/data/therapist-bookkeeping-kit/">Therapist bookkeeping kit</a></td><td>A chart of accounts and month-end checklist for a solo or group therapy practice. The fictional October ties insurance EFTs to their remittances and works out each contract clinician's share of what they collected.</td><td><a href="https://www.zerabooks.com/bookkeeping-for-therapists">Bookkeeping for therapists</a></td></tr><tr><td><a href="/data/daycare-bookkeeping-kit/">Daycare bookkeeping kit</a></td><td>A daycare chart of accounts and month-end checklist that keeps tuition, state subsidy and CACFP food money apart. Two scripts check a subsidy remittance child by child and total each family's payments for parent year-end statements.</td><td><a href="https://www.zerabooks.com/bookkeeping-for-daycares">Bookkeeping for daycares</a></td></tr><tr><td><a href="/data/hvac-plumbing-bookkeeping-kit/">HVAC and plumbing bookkeeping kit</a></td><td>A chart of accounts and accrual month-end checklist for a residential HVAC or plumbing company. It includes a maintenance plan schedule that earns plans month by month, and a fictional October that keeps install deposits and plan money out of profit.</td><td><a href="https://www.zerabooks.com/bookkeeping-for-hvac-and-plumbing">Bookkeeping for HVAC and plumbing</a></td></tr><tr><td><a href="/data/forensic-bank-statement-analysis/">Forensic bank statement analysis</a></td><td>A Python script and checklist that first prove a set of bank statements is complete, each statement tied and each month chained to the next, then list transfers between accounts, cash withdrawals, duplicates and round amounts. The fictional sample production is missing an April statement, and the script finds the 3,664.55 gap.</td><td><a href="https://www.zerabooks.com/forensic-bank-statement-analysis">Forensic bank statement analysis</a></td></tr><tr><td><a href="/data/accounting-statistics-2026/">Accounting and bookkeeping statistics 2026</a></td><td>51 U.S. accounting and bookkeeping statistics for 2026 in one CSV, from wages and jobs to firm counts and the small businesses they serve. Every figure comes from BLS, Census, SBA or IRS and links to its source page.</td><td><a href="https://www.zerabooks.com/research/accounting-bookkeeping-statistics-2026">Accounting and bookkeeping statistics 2026</a></td></tr><tr><td><a href="/data/cpa-shortage-data/">CPA shortage data</a></td><td>39 figures on the CPA pipeline in one CSV: accounting graduates, CPA exam candidates and pass rates, licensed CPAs, accountants near retirement and what firms say about hiring. Every row links to its AICPA, NASBA or BLS source.</td><td><a href="https://www.zerabooks.com/research/cpa-shortage-statistics">CPA shortage statistics</a></td></tr><tr><td><a href="/data/statement-balance-check/">Statement balance check</a></td><td>A small Python script that checks a converted bank statement CSV against its printed opening and closing balances. When the running balance breaks, it names the first row and whether a sign is flipped or a line is missing.</td><td><a href="https://www.zerabooks.com/bank-statement-converter">Bank statement converter</a></td></tr><tr><td><a href="/data/bank-statement-excel-template/">Bank statement Excel template</a></td><td>An Excel workbook for one bank statement: type the printed opening and closing balances, paste the transactions, and a check cell shows whether the month ties to the cent. A difference column marks the first row where your running balance and the bank's stop agreeing.</td><td><a href="https://www.zerabooks.com/convert-bank-statement-to-excel">Bank statement to Excel</a></td></tr><tr><td><a href="/data/ai-bookkeeping-review-checklist/">AI bookkeeping review checklist</a></td><td>What a person should check after software categorizes a month and before it is closed: statements that tie, transfers and owner's draws kept off the profit and loss, and tax, cash and mixed-merchant lines confirmed rather than guessed. Includes a vendor rules file and a script that lists what is left for a person.</td><td><a href="https://www.zerabooks.com/ai-bookkeeping">AI bookkeeping</a></td></tr><tr><td><a href="/data/general-ledger-software-checklist/">General ledger software checklist</a></td><td>A checklist and a requirements sheet for choosing or switching general ledger software, plus a fictional test month you can enter in any ledger. The expected trial balance and reports are listed, and two test files show whether the software refuses an unbalanced batch and protects a closed month.</td><td><a href="https://www.zerabooks.com/general-ledger-software">General ledger software</a></td></tr><tr><td><a href="/data/iolta-three-way-reconciliation/">IOLTA three-way reconciliation</a></td><td>A three-way reconciliation template for an IOLTA or client trust account, with a fictional law firm's June and four client matters. A script works out the adjusted bank balance, compares it with the trust journal and the client ledgers, and flags any client that goes below zero.</td><td><a href="https://www.zerabooks.com/iolta-trust-accounting">IOLTA trust accounting</a></td></tr><tr><td><a href="/data/bank-statement-analysis-template/">Bank statement analysis template</a></td><td>A summary template and a script that turn converted bank statement rows into monthly deposits net of transfers between your own accounts, withdrawals, closing, lowest and average daily balances, NSF and overdraft items and large deposits. The fictional sample covers three months of a landscaping company's checking account.</td><td><a href="https://www.zerabooks.com/bank-statement-analysis">Bank statement analysis</a></td></tr><tr><td><a href="/data/catch-up-bookkeeping-tracker/">Catch-up bookkeeping tracker</a></td><td>A month-by-month catch-up tracker for every bank and card account, with a fictional shop nine months behind. A script lists missing statement months, works out each missing month's net change from the balance chain, and flags months that don't tie.</td><td><a href="https://www.zerabooks.com/catch-up-bookkeeping">Catch-up bookkeeping</a></td></tr><tr><td><a href="/data/loan-payment-split/">Loan payment split</a></td><td>A script that builds a loan amortization schedule from the amount, rate and term, and a second that turns each payment into a balanced journal entry with principal, interest and fees on their own lines. The sample is a fictional 36-month equipment loan, with notes on lines of credit and car loans.</td><td><a href="https://www.zerabooks.com/how-to-record-loan-payments">How to record loan payments</a></td></tr><tr><td><a href="/data/real-estate-agent-bookkeeping-kit/">Real estate agent bookkeeping kit</a></td><td>A chart of accounts and expense category list for a real estate agent or small team. A script ties each closing's commission, brokerage split and fees to the deposit, and a fictional October shows the month booked gross with the mileage log totaled.</td><td><a href="https://www.zerabooks.com/bookkeeping-for-real-estate-agents">Bookkeeping for real estate agents</a></td></tr></tbody></table><h2>About ZeraBooks</h2><p><a href="https://www.zerabooks.com/">ZeraBooks</a> is accounting software that does your books for you. Send your bank statements, and we set you up and catch up your past months for free. From then on, ZeraBooks keeps your books done automatically. It includes a free <a href="https://www.zerabooks.com/bank-statement-converter">bank statement converter</a> that checks every statement against its printed opening and closing balance.</p><h2>Where else we write</h2><p>Longer guides and notes on bookkeeping, statements and month-end work: <a href="https://zerabooks.substack.com/">the ZeraBooks newsletter on Substack</a>, <a href="https://zerabooks.blogspot.com/">worked examples on the ZeraBooks blog</a>, and technical write-ups on parsing statements and checking files on <a href="https://dev.to/zerabooks">dev.to</a>.</p><footer>Published by <a href="https://www.zerabooks.com/">ZeraBooks</a>, accounting software that does your books for you. All sample figures are fictional. Updated November 5, 2026.</footer></body></html>