{"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-11-08T07:09:11","modified_gmt":"2026-11-08T07:09:11","slug":"small-business-bookkeeping-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/nl\/product\/small-business-bookkeeping-spreadsheet\/","title":{"rendered":"Small Business Bookkeeping Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 Two lists in, a P&#038;L out<\/span><\/p>\n<h2 id=\"a-small-business-bookkeeping-spreadsheet-that-writes-the-monthly-profit-and-loss-for-you\">A small business bookkeeping spreadsheet that writes the monthly profit and loss for you<\/h2>\n<p>The Small Business Bookkeeping workbook is for the self-employed, freelancers and small shops who want clean books without accounting software. On Settings, type your business name and check the categories fit your business: income such as product sales, services and wholesale orders; expenses from materials and packaging to software, rent and bank fees. Rename any of them and the logs and the P&amp;L follow.<\/p>\n<h3>How it works<\/h3>\n<p>Log money in on Income and money out on Expenses, one row per payment, with the category and how it was paid. Mark an invoice Unpaid until the money arrives and the Dashboard lists what is still owed. Monthly P&amp;L fills itself from the two logs: income, cost of sales, gross profit, operating expenses, net profit and margin, month by month and year to date.<\/p>\n<h3>Gross profit, then net<\/h3>\n<p>Each expense category is set as Cost of sales, what it takes to make or deliver what you sell, or Operating, everything else. That split turns income into gross profit and then net profit. The logs keep every year: type last year on Settings and the P&amp;L and Dashboard show it. The workbook keeps your books and files nothing; an accountant can work straight from the P&amp;L and the two logs.<\/p>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.<\/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":17031,"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","_templacity_copy_live":"1","_templacity_faq":[{"q":"Do I need to know accounting to use it?","a":"No. You log each payment in or out with a category. The profit and loss statement, margin and charts are worked out from the two lists."},{"q":"What is the difference between cost of sales and operating expenses?","a":"Cost of sales is what you spend to make or deliver what you sell: materials, packaging, shipping, contractors who do the work. Everything else is operating. You set which is which per category on Settings."},{"q":"Can I look at last year?","a":"Yes. The year follows today's date; type last year over it on Settings and the P&L and Dashboard show that year. The logs keep every year you enter."},{"q":"Does it file my taxes?","a":"No. It keeps the books; it does not file anything. Your accountant can work straight from the P&L and the two logs."},{"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."}]},"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\/nl\/wp-json\/wp\/v2\/product\/12964","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=12964"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media\/17031"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media?parent=12964"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/niche?post=12964"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/template_type?post=12964"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/templacity_topic?post=12964"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_brand?post=12964"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_cat?post=12964"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_tag?post=12964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}