{"product_id":"checkbook-register-spreadsheet","title":"Checkbook Register Spreadsheet, Bank Account Tracker and Daily Transaction Log, Simple Income and Expense Tracker, Google Sheets Excel","description":"\u003cp\u003eA checkbook register that works like the paper one and does the math for you: a running balance on every line, a tick for what has cleared at the bank, a warning before your balance drops too low, and a check against your bank statement to the cent.\u003c\/p\u003e\u003cp\u003e🔗 TRY THE LIVE DEMO before you buy (view only, nothing to install): \u003ca href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1fYBw1kuI7X2Aoe5vAK917woZqzQXcL-6Nmrju9I_uAs\/edit?gid=1379083332\"\u003ehttps:\/\/docs.google.com\/spreadsheets\/d\/1fYBw1kuI7X2Aoe5vAK917woZqzQXcL-6Nmrju9I_uAs\/edit?gid=1379083332\u003c\/a\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003e📊 WHAT IT DOES\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e✓ Register: one line for every payment and deposit, with the date, description, category, type and check number. The balance runs down the page by itself.\u003cbr\u003e✓ Tick Cleared when the line shows up at your bank. Balance today, the cleared balance and what has not cleared yet add up by themselves.\u003cbr\u003e✓ The check flags checks nobody has cashed after 10 days, a check number typed twice, and scheduled lines that would take you below your floor.\u003cbr\u003e✓ Reconcile: type your statement date and ending balance. Bank balance, plus what has not cleared, should equal your register, and it tells you Balanced or Off by.\u003cbr\u003e✓ A list of every line that has not cleared up to the statement date, with how long it has been waiting.\u003cbr\u003e✓ Months: deposits, payments, net and month-end balance for any month, your payments by category, and the year month by month.\u003cbr\u003e✓ Three charts: your balance day by day against your floor, deposits and payments month by month, and payments by category.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003e📂 WHAT'S INSIDE: 4 TABS AND 3 CHARTS\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e✓ Start here: your account, its balance on a date, and the floor to warn you at\u003cbr\u003e✓ Register: four cards and every payment and deposit\u003cbr\u003e✓ Reconcile: four cards, your statement and what has not cleared\u003cbr\u003e✓ Months: four cards, the year month by month and payments by category\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003e📝 HOW IT WORKS\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eOpen the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.\u003c\/li\u003e\n\u003cli\u003eOn Start here, add your account name, its balance on a date and the lowest balance you want to keep.\u003c\/li\u003e\n\u003cli\u003eOn Register, add every payment and deposit as it happens, and tick Cleared when your bank shows it.\u003c\/li\u003e\n\u003cli\u003eWhen your statement comes, open Reconcile and type its date and ending balance.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003e📥 WHAT YOU GET\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e✓ Google Sheets version (the link is in the PDF)\u003cbr\u003e✓ Excel version (.xlsx) for desktop Excel 2016 or newer and Microsoft 365, on Windows or Mac\u003cbr\u003e✓ A filled example to look around, and a blank copy for your own account\u003cbr\u003e✓ A PDF guide with screenshots, the links and the first steps\u003cbr\u003e✓ A video guide for this spreadsheet (the link is in the PDF)\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003e💻 GOOD TO KNOW\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e✓ Works with a free Google account. No app, no ads, no subscription.\u003cbr\u003e✓ Room for 200 lines per file. One file per account: make a copy for savings or a second checking account.\u003cbr\u003e✓ Add upcoming bills with their future date to see where your balance is heading.\u003cbr\u003e✓ Formulas are protected, so you can't break anything by accident.\u003cbr\u003e✓ Set it up on a computer in a few minutes. After that, the Google Sheets app works for quick entries on your phone.\u003cbr\u003e✓ The photos show Google Sheets. The Excel file has the same tabs and formulas.\u003cbr\u003e✓ Free updates for life.\u003c\/p\u003e\u003cp\u003eThis is a digital download, so nothing is shipped. If anything is unclear after you buy, message me and I'll help you set it up.\u003c\/p\u003e","brand":"GrowlyLab","offers":[{"title":"Default Title","offer_id":67797557837977,"sku":null,"price":2.98,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0738\/8613\/8521\/files\/il_fullxfull.8794899322_g52w.jpg?v=1793809898","url":"https:\/\/growlylabstudio.com\/products\/checkbook-register-spreadsheet","provider":"GrowlyLab","version":"1.0","type":"link"}