{"id":12964,"date":"2026-09-19T15:06:14","date_gmt":"2026-09-19T15:06:14","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=12964"},"modified":"2026-09-27T15:14:03","modified_gmt":"2026-09-27T15:14:03","slug":"small-business-bookkeeping-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/de\/product\/small-business-bookkeeping-spreadsheet\/","title":{"rendered":"Small Business Bookkeeping Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p>Simple bookkeeping for a small business or side business. Two logs, income and expenses, feed a month-by-month profit and loss statement and a dashboard.<\/p>\n<ul>\n<li><strong>Dashboard<\/strong>: income, expenses, profit and margin for the year to date and this month, by quarter, unpaid invoices, and two charts.<\/li>\n<li><strong>Monthly P&amp;L<\/strong>: income, cost of sales, gross profit, operating expenses, net profit and margin, month by month.<\/li>\n<li><strong>Income<\/strong>: every payment you receive: customer, category, amount and whether the invoice is paid.<\/li>\n<li><strong>Expenses<\/strong>: every payment you make: who to, category, amount, how you paid and whether the receipt is kept.<\/li>\n<li><strong>Settings<\/strong>: business name, the year, your categories and how you get paid.<\/li>\n<\/ul>\n<p><strong>What you get:<\/strong> a one-page PDF with two buttons. One makes a blank copy of the Google Sheet in your own Drive, the other a copy filled with an example so you can see every tab working first. The same workbook comes as two Excel files, blank and example, checked in Excel with every formula recalculated. No year is printed anywhere, so it starts the day you do.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Log what comes in and what goes out, and the monthly profit and loss statement writes itself, with margin, unpaid invoices and where the money goes.<\/p>\n","protected":false},"featured_media":12965,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Small Business Bookkeeping Spreadsheet, Sheets and Excel | Templacity","rank_math_description":"A bookkeeping spreadsheet for small businesses in Google Sheets and Excel: income and expense logs feeding a monthly profit and loss statement and dashboard.","rank_math_seo_score":"9"},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-12964","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\/de\/wp-json\/wp\/v2\/product\/12964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/comments?post=12964"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/media\/12965"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/media?parent=12964"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/niche?post=12964"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/template_type?post=12964"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/templacity_topic?post=12964"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product_brand?post=12964"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product_cat?post=12964"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product_tag?post=12964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}