{"id":12985,"date":"2026-09-19T15:06:46","date_gmt":"2026-09-19T15:06:46","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=12985"},"modified":"2026-11-08T11:56:52","modified_gmt":"2026-11-08T11:56:52","slug":"check-register-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/nl\/product\/check-register-spreadsheet\/","title":{"rendered":"Check Register Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 Write it down once<\/span><\/p>\n<h2 id=\"a-check-register-spreadsheet-that-keeps-a-running-balance-per-account-and-reconciles-your-statement\">A check register spreadsheet that keeps a running balance per account and reconciles your statement<\/h2>\n<p>The Check Register is for people who still write checks, or who just want to know the balance before the bank does. On Settings, name your accounts, Checking and Savings to start, and type each one&#8217;s balance on the day you begin, with that date. The categories, from paycheck and housing to groceries, subscriptions and kids, are yours to rename.<\/p>\n<h3>One register for every account<\/h3>\n<p>Every check, card payment, deposit and transfer is one row on the Register: date, account, check number, payee, category, and the amount as a payment or a deposit, never both. Each row shows that account&#8217;s running balance, and inserting a row in the middle repairs every balance below it. Leave an item Pending until the bank shows it, then set it to Cleared. A check you tore up is Void: it stays listed and out of every total.<\/p>\n<h3>Reconcile in one step<\/h3>\n<p>Once a month, open Reconcile with your statement and type its closing date and balance. It shows the difference, the arithmetic, and every item not on the statement yet. Summary keeps the register balance beside the cleared balance, what is waiting to clear, the next check number and twelve months of money in and out.<\/p>\n<p>Want the budget on top of the register? That is the <a href=\"\/product\/budget-and-money-planner-spreadsheet\/\">Budget &amp; Money Planner<\/a>.<\/p>\n<p>The download is a short PDF with Google Sheets buttons: a blank copy in your own Drive and a copy filled with an example, each in a light edition and a Night edition for dark screens. The same workbook also comes as blank and example Excel files, and the Night edition is Google Sheets only. There is a one-page Quick Start for each app.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A checkbook register with a running balance per account, a month view, and a Reconcile tab that matches your bank statement in one step.<\/p>\n","protected":false},"featured_media":17033,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Check Register Spreadsheet for Google Sheets and Excel | Templacity","rank_math_description":"A checkbook register for Google Sheets and Excel: running balance per account, cleared items, a monthly view and one-step bank statement reconciling.","rank_math_seo_score":"13","_templacity_copy_live":"1","_templacity_faq":[{"q":"How do I balance it against my bank statement?","a":"Open Reconcile, type the statement's closing date and balance, and it shows the difference and every item still waiting to clear."},{"q":"How do I record a transfer between my accounts?","a":"Two rows with the Transfer category, a payment from one account and a deposit into the other. Both balances move and it stays out of your spending."},{"q":"What do I do with a voided check?","a":"Set its status to Void. It stays on the list, keeping the check numbers in order, and out of every total."},{"q":"Can I track more than one account?","a":"Yes. Name each on Settings with its opening balance; every row shows the running balance of its own account, and Month shows one account or all of them."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."},{"q":"Is there a year printed in it?","a":"No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year."}]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-12985","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product\/12985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/comments?post=12985"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media\/17033"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media?parent=12985"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/niche?post=12985"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/template_type?post=12985"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/templacity_topic?post=12985"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_brand?post=12985"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_cat?post=12985"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_tag?post=12985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}