<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Mike Rudolph</title>
    <description>The latest articles on DEV Community by Mike Rudolph (@kitfoundrymike).</description>
    <link>https://dev.to/kitfoundrymike</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4248459%2F25078cfd-f6d1-45d2-97a9-f8e9f0c4f767.jpg</url>
      <title>DEV Community: Mike Rudolph</title>
      <link>https://dev.to/kitfoundrymike</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/kitfoundrymike"/>
    <language>en</language>
    <item>
      <title>How to Build a Cross-Platform Home Maintenance and Warranty Tracker in 15 Minutes</title>
      <dc:creator>Mike Rudolph</dc:creator>
      <pubDate>Wed, 18 Nov 2026 01:51:43 +0000</pubDate>
      <link>https://dev.to/kitfoundrymike/how-to-build-a-cross-platform-home-maintenance-and-warranty-tracker-in-15-minutes-14mb</link>
      <guid>https://dev.to/kitfoundrymike/how-to-build-a-cross-platform-home-maintenance-and-warranty-tracker-in-15-minutes-14mb</guid>
      <description>&lt;p&gt;Deferred home maintenance is one of the fastest ways to turn a $30 filter swap into a $5,000 capital repair. Worse, many appliance and HVAC manufacturers void warranty claims if you cannot prove routine, documented upkeep.&lt;/p&gt;

&lt;p&gt;Most homeowners try to solve this with scattered paper receipts, calendar reminders, or bloated 11-tab spreadsheets downloaded from the internet. The problem is that complex templates often break across different spreadsheet applications, lack automated date math, and separate warranty expiration dates from actual repair costs.&lt;/p&gt;

&lt;p&gt;You do not need proprietary scripts or heavy software to fix this. You can build a reliable, cross-platform home operating system using three connected tables and a handful of universal spreadsheet formulas.&lt;/p&gt;

&lt;h2&gt;
  
  
  The 3-Table Architecture for Home Upkeep
&lt;/h2&gt;

&lt;p&gt;Keep your entire home log inside a single clean workbook with three focused sections:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Preventive Schedule:&lt;/strong&gt; Tracks recurring tasks (HVAC filters, water heater flushing, gutter cleaning) with automated next-due dates and status flags.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Warranty Ledger:&lt;/strong&gt; Logs purchase dates, manufacturer coverage terms, expiration countdowns, and links to stored digital receipts.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Repair &amp;amp; Cost Ledger:&lt;/strong&gt; Records every service call, part replacement, and DIY expense so you can spot failing appliances early.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Universal Formulas That Work in Any Spreadsheet App
&lt;/h2&gt;

&lt;p&gt;To ensure your tracker works identically whether you use desktop or web-based spreadsheet software, stick to standard functions like &lt;code&gt;TODAY()&lt;/code&gt;, &lt;code&gt;EDATE()&lt;/code&gt;, &lt;code&gt;IF()&lt;/code&gt;, and &lt;code&gt;MAX()&lt;/code&gt;.&lt;/p&gt;

&lt;p&gt;Assume your Preventive Schedule has these columns: &lt;code&gt;A&lt;/code&gt; (System/Asset), &lt;code&gt;B&lt;/code&gt; (Task), &lt;code&gt;C&lt;/code&gt; (Interval in Months), &lt;code&gt;D&lt;/code&gt; (Last Completed Date), &lt;code&gt;E&lt;/code&gt; (Next Due Date), and &lt;code&gt;F&lt;/code&gt; (Status).&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Next Due Date (Cell E2):
=IF(D2="", "", EDATE(D2, C2))

Automated Status Flag (Cell F2):
=IF(E2="", "NEEDS BASELINE", IF(E2&amp;lt;TODAY(), "OVERDUE", IF(E2&amp;lt;=TODAY()+14, "DUE SOON", "OK")))

Warranty Days Remaining (Warranty Tab):
=IF(D2="", "", MAX(0, D2-TODAY()))
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Whenever you complete a task, you only update &lt;strong&gt;one cell&lt;/strong&gt;: &lt;code&gt;Last Completed Date&lt;/code&gt;. The next due date and status flag recalculate automatically. Filtering Column &lt;code&gt;F&lt;/code&gt; for &lt;code&gt;OVERDUE&lt;/code&gt; and &lt;code&gt;DUE SOON&lt;/code&gt; gives you an instant weekend action list.&lt;/p&gt;

&lt;h2&gt;
  
  
  Use the 50% Repair-vs-Replace Rule
&lt;/h2&gt;

&lt;p&gt;Tracking repair costs alongside appliance age prevents sunk-cost traps. As a general rule of thumb, if a repair costs more than 50% of the replacement price—and the appliance is past half of its expected lifespan—it is usually smarter to replace rather than repair.&lt;/p&gt;

&lt;p&gt;For example, if a 9-year-old water heater needs a $650 valve and thermostat service, and a comparable new unit costs $1,200, your Repair Ledger immediately shows you are crossing the 50% threshold on an aging asset.&lt;/p&gt;

&lt;h2&gt;
  
  
  A 10-Minute Monthly Operating Cadence
&lt;/h2&gt;

&lt;p&gt;A system only works if you actually use it. Set a recurring 10-minute review on the first Saturday of every month:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Filter your Preventive Schedule for &lt;code&gt;OVERDUE&lt;/code&gt; and &lt;code&gt;DUE SOON&lt;/code&gt; items.&lt;/li&gt;
&lt;li&gt;Complete quick tasks and update the &lt;code&gt;Last Completed Date&lt;/code&gt; column.&lt;/li&gt;
&lt;li&gt;Snap a photo of any receipt or service invoice and paste the cloud link into your Warranty or Repair Ledger.&lt;/li&gt;
&lt;li&gt;Check your Warranty Ledger for any coverage expiring within the next 60 days so you can schedule final inspections while still covered.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Want the Complete System Pre-Built?
&lt;/h2&gt;

&lt;p&gt;If you would rather skip building the tables, conditional formatting, and checklists from scratch, I put together the &lt;strong&gt;&lt;a href="https://kitfoundry.studio/p/preventive-home-maintenance-warranty-log" rel="noopener noreferrer"&gt;Preventive Home Maintenance, Appliance Warranty &amp;amp; Repair Log Kit&lt;/a&gt;&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;It includes copy-pasteable universal formulas, seasonal and annual maintenance checklists, warranty countdowns, a complete 1-year worked example, an appliance lifespan cheat sheet, and a 5-minute quick-start guide so you can set up your entire home log in under 15 minutes.&lt;/p&gt;

</description>
      <category>productivity</category>
      <category>spreadsheets</category>
      <category>workflow</category>
      <category>automation</category>
    </item>
    <item>
      <title>A Plain-Text Operations System for 1-to-10 Unit Landlords (Rent Rolls, Schedule E &amp; Turnovers)</title>
      <dc:creator>Mike Rudolph</dc:creator>
      <pubDate>Tue, 17 Nov 2026 20:58:26 +0000</pubDate>
      <link>https://dev.to/kitfoundrymike/a-plain-text-operations-system-for-1-to-10-unit-landlords-rent-rolls-schedule-e-turnovers-3chg</link>
      <guid>https://dev.to/kitfoundrymike/a-plain-text-operations-system-for-1-to-10-unit-landlords-rent-rolls-schedule-e-turnovers-3chg</guid>
      <description>&lt;p&gt;Managing 1 to 10 residential units sits in an awkward middle ground. Enterprise property management platforms are built for 100-unit commercial portfolios and bury you in monthly fees. On the other hand, a bare-bones income spreadsheet leaves you scrambling during tenant turnovers, calculating prorated rent by hand, and digging through receipts every April.&lt;/p&gt;

&lt;p&gt;If you self-manage a small portfolio, you do not need complex software. You need a unified operations system that connects daily property tasks directly to your year-end tax reporting. Below is a practical, plain-text framework you can set up in under 15 minutes.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Track Rent Rolls and Running Arrears Together
&lt;/h2&gt;

&lt;p&gt;Most simple rent logs only record whether a tenant paid in full. Problems start when a tenant submits a partial payment, pays late, or carries a small balance into the next month. Instead of overwriting cells, use a running balance formula:&lt;/p&gt;

&lt;p&gt;&lt;code&gt;Ending Balance = Previous Balance + Monthly Rent + Late Fees - Payments Received&lt;/code&gt;&lt;/p&gt;

&lt;p&gt;For mid-month move-ins or move-outs, standardize your prorated rent calculation so there is never a dispute:&lt;/p&gt;

&lt;p&gt;&lt;code&gt;Prorated Rent = (Monthly Rent / Total Days in Month) * Occupied Days&lt;/code&gt;&lt;/p&gt;

&lt;p&gt;Here is a minimal Markdown table structure you can use for monthly reconciliation:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight markdown"&gt;&lt;code&gt;| Unit | Tenant | Prev Bal | Rent Due | Late Fee | Paid | Ending Bal |
| --- | --- | --- | --- | --- | --- | --- |
| 1A | Tenant A | $0.00 | $1,450.00 | $0.00 | $1,450.00 | $0.00 |
| 1B | Tenant B | $100.00 | $1,600.00 | $50.00 | $1,500.00 | $250.00 |
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  2. Map Expenses to Schedule E Buckets at Entry Time
&lt;/h2&gt;

&lt;p&gt;Tax panic happens when you log an expense as "Home improvement store - $184" and try to remember six months later whether it was a repair, a supply, or a capital improvement. Force every expense entry into a standardized Schedule E category the day you pay it:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Advertising:&lt;/strong&gt; Listing fees, yard signs, and tenant screening ads.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Cleaning and maintenance:&lt;/strong&gt; Turnover deep cleans, lawn care, and routine servicing.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Insurance:&lt;/strong&gt; Landlord hazard, liability, and loss-of-rent policies.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Legal and professional fees:&lt;/strong&gt; Lease reviews, eviction filings, and tax prep.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Repairs:&lt;/strong&gt; Fixing a leaking faucet, patching drywall, or replacing a broken lock.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Supplies:&lt;/strong&gt; Smoke detector batteries, furnace filters, and lightbulbs.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Taxes and Utilities:&lt;/strong&gt; Property taxes and landlord-paid water, trash, or electric.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Reconciling these buckets quarterly takes 20 minutes and eliminates the year-end receipt scramble.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. Use 60-Day and 30-Day Compliance Alerts
&lt;/h2&gt;

&lt;p&gt;Missed safety deadlines carry heavy fines and liability. Keep a dedicated compliance table for gas safety certificates, electrical inspections, and smoke or carbon monoxide detector checks. Calculate days remaining from today's date and flag two thresholds:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;60 Days Remaining:&lt;/strong&gt; Schedule the technician or inspector.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;30 Days Remaining:&lt;/strong&gt; Confirm appointment and notify the tenant.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  4. Standardize Move-In and Move-Out Inspections
&lt;/h2&gt;

&lt;p&gt;Security deposit disputes almost always come down to missing documentation. Never rely on memory or informal walkthroughs. Use a room-by-room condition checklist that records the exact state of walls, flooring, appliances, and fixtures at move-in, signed by both parties. When the tenant moves out, score the same list side-by-side and attach itemized repair invoices for any deductions beyond normal wear and tear.&lt;/p&gt;

&lt;h2&gt;
  
  
  Want the Complete, Ready-to-Use System?
&lt;/h2&gt;

&lt;p&gt;If you would rather not build these formulas, tables, and checklists from scratch, I put everything into the &lt;strong&gt;Small-Portfolio Landlord &amp;amp; Rental Turnover Operations Kit&lt;/strong&gt; ($19.00 one-time).&lt;/p&gt;

&lt;p&gt;It includes a 5-Minute Quick-Start Guide, copy-paste Rent Roll and Arrears templates, a Schedule E Expense Log, a Safety Certificate Tracker, a standardized turnover checklist, and a complete full-year worked example for a 3-unit portfolio.&lt;/p&gt;

&lt;p&gt;You can grab the full toolkit here: &lt;a href="https://kitfoundry.studio/p/small-portfolio-landlord-rental-turnover-kit" rel="noopener noreferrer"&gt;Small-Portfolio Landlord &amp;amp; Rental Turnover Operations Kit&lt;/a&gt;&lt;/p&gt;

</description>
      <category>productivity</category>
      <category>workflow</category>
      <category>operations</category>
      <category>finance</category>
    </item>
    <item>
      <title>How to Calculate True Unit Margin and Stacked Marketplace Fees for Micro-Batch Products</title>
      <dc:creator>Mike Rudolph</dc:creator>
      <pubDate>Tue, 17 Nov 2026 20:57:34 +0000</pubDate>
      <link>https://dev.to/kitfoundrymike/how-to-calculate-true-unit-margin-and-stacked-marketplace-fees-for-micro-batch-products-1k6d</link>
      <guid>https://dev.to/kitfoundrymike/how-to-calculate-true-unit-margin-and-stacked-marketplace-fees-for-micro-batch-products-1k6d</guid>
      <description>&lt;h2&gt;
  
  
  Why Simple 2x Markup Rules Break Down
&lt;/h2&gt;

&lt;p&gt;If you make and sell small-batch physical goods, pricing by doubling your material cost is one of the fastest ways to lose money on your best-selling items. A simple markup ignores packaging, batch labor, inbound freight, and—most importantly—the way marketplace and payment processing percentages stack on top of the shipping you collect from buyers.&lt;/p&gt;

&lt;p&gt;When you handle fewer than 50 orders a month across under 20 core SKUs, you do not need bloated enterprise accounting software. You just need an unbreakable unit-level formula that shows your true net profit before you list a product or run a sale.&lt;/p&gt;

&lt;h2&gt;
  
  
  The 4-Layer Unit Cost Breakdown (True COGS)
&lt;/h2&gt;

&lt;p&gt;Before you look at fees, calculate your actual Cost of Goods Sold (COGS) per unit by summing four components:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Raw Materials + Yield Loss:&lt;/strong&gt; Divide your batch material cost by the number of sellable units, not the theoretical yield. If a batch makes 10 units and 1 fails quality control, your cost per unit is 1/9th of the batch.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Packaging &amp;amp; Inserts:&lt;/strong&gt; Include boxes, jars, labels, tape, protective fill, and thank-you cards.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Direct Batch Labor:&lt;/strong&gt; Track total minutes spent prepping, making, curing, and packing a batch, multiplied by a realistic hourly rate.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Inbound Freight:&lt;/strong&gt; Divide the shipping you paid to receive raw materials by the number of units those materials produce.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  The Stacked-Fee Formula
&lt;/h2&gt;

&lt;p&gt;Most sellers accidentally calculate transaction fees on the item price alone. In reality, percentage-based marketplace fees and payment processing fees apply to the &lt;strong&gt;total order value&lt;/strong&gt; (item price plus buyer-paid shipping), plus any fixed per-order fee.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Total Revenue = Item Price + Buyer Shipping
Stacked Fees  = (Total Revenue * (Marketplace % + Processing %)) + Fixed Fee
True Net Profit = Total Revenue - True COGS - Actual Postage - Stacked Fees
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Worked Example: A $28 Micro-Batch Item
&lt;/h2&gt;

&lt;p&gt;Suppose you sell a handmade item for $28.00 and charge $6.00 for shipping (Total Revenue = $34.00). Your marketplace charges a 6.5% transaction fee, and your payment processor charges 3.0% + $0.30.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Raw Materials (with yield):&lt;/strong&gt; $5.40&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Packaging &amp;amp; Labels:&lt;/strong&gt; $1.60&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Batch Labor (10 mins @ $24/hr):&lt;/strong&gt; $4.00&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;True COGS:&lt;/strong&gt; $11.00&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Actual Postage Paid:&lt;/strong&gt; $6.20&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Stacked Fees (9.5% of $34.00 + $0.30):&lt;/strong&gt; $3.53&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;True Net Profit:&lt;/strong&gt; $34.00 - $11.00 - $6.20 - $3.53 = &lt;strong&gt;$13.27&lt;/strong&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Now watch what happens if you offer "free shipping" AND a 25% off promotion ($21.00 total revenue, $0 buyer shipping):&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;True COGS + Actual Postage:&lt;/strong&gt; $17.20&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Stacked Fees (9.5% of $21.00 + $0.30):&lt;/strong&gt; $2.30&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;True Net Profit:&lt;/strong&gt; $21.00 - $17.20 - $2.30 = &lt;strong&gt;$1.50&lt;/strong&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Without knowing your breakeven pricing floor, a well-intentioned promotion wipes out almost your entire margin.&lt;/p&gt;

&lt;h2&gt;
  
  
  5-Minute Monthly Pricing Audit Checklist
&lt;/h2&gt;

&lt;p&gt;Run this quick check once a month to catch margin leaks early:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Verify Postage Rates:&lt;/strong&gt; Compare your last 5 shipping labels against what you charged buyers.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Update Material Costs:&lt;/strong&gt; Check if supplier prices or inbound freight increased on your latest restock.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Test Your Promo Floor:&lt;/strong&gt; Confirm that a 15% or 20% discount still leaves a healthy net profit per unit.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Audit Your Top 5 SKUs:&lt;/strong&gt; Double-check that your highest-volume items are also your healthiest margin drivers.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Want a Ready-to-Use System Without Fragile Spreadsheets?
&lt;/h2&gt;

&lt;p&gt;If you want to skip building and debugging formulas from scratch, the &lt;strong&gt;Handmade &amp;amp; Micro-Batch True-Margin &amp;amp; COGS Calculator Bundle&lt;/strong&gt; ($19 one-time, zero subscriptions) gives you unbreakable COGS and fee-stacking templates, a 5-minute quick-start guide, a complete worked example, a troubleshooting playbook, and a one-page cheat sheet designed specifically for makers managing under 20 SKUs.&lt;/p&gt;

&lt;p&gt;Get the full toolkit here: &lt;a href="https://kitfoundry.studio/p/handmade-micro-batch-true-margin-cogs-calculator" rel="noopener noreferrer"&gt;Handmade &amp;amp; Micro-Batch True-Margin &amp;amp; COGS Calculator Bundle&lt;/a&gt;&lt;/p&gt;

</description>
      <category>pricing</category>
      <category>productivity</category>
      <category>spreadsheet</category>
      <category>ecommerce</category>
    </item>
    <item>
      <title>How to Build a Schedule E Rental Tracker and Operations System Without Monthly SaaS Fees</title>
      <dc:creator>Mike Rudolph</dc:creator>
      <pubDate>Mon, 16 Nov 2026 23:56:31 +0000</pubDate>
      <link>https://dev.to/kitfoundrymike/how-to-build-a-schedule-e-rental-tracker-and-operations-system-without-monthly-saas-fees-449j</link>
      <guid>https://dev.to/kitfoundrymike/how-to-build-a-schedule-e-rental-tracker-and-operations-system-without-monthly-saas-fees-449j</guid>
      <description>&lt;h2&gt;
  
  
  Why 1–10 Unit Landlords Overpay for Software (or Under-Track in Notes)
&lt;/h2&gt;

&lt;p&gt;If you self-manage 1 to 10 residential rental units, you sit in an awkward middle ground. Commercial property management platforms charge hefty monthly subscriptions packed with enterprise features you never touch. On the other hand, relying on bank statements, scattered notes, and generic income-expense templates leaves you guessing at your true unit-level cash flow and scrambling every spring to assemble Schedule E totals.&lt;/p&gt;

&lt;p&gt;You do not need recurring SaaS fees to run a tight portfolio. You need two things working together: a structured ledger that categorizes transactions at the moment of entry, and repeatable operational checklists for the workflows that actually protect your margins.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Tag Every Transaction to a Schedule E Category at Entry
&lt;/h2&gt;

&lt;p&gt;Most landlords lose hours during tax prep because they record &lt;em&gt;what&lt;/em&gt; they bought ("hardware store - $142") instead of &lt;em&gt;which tax line&lt;/em&gt; it belongs to. By adding two columns to your transaction ledger—&lt;code&gt;Unit_ID&lt;/code&gt; and &lt;code&gt;Tax_Category&lt;/code&gt;—you can automate your year-end tax rollup with a single &lt;code&gt;SUMIFS&lt;/code&gt; formula.&lt;/p&gt;

&lt;p&gt;Here is a standard formula pattern that works in any modern spreadsheet application:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;=SUMIFS(Ledger!$E$2:$E$500, Ledger!$B$2:$B$500, $A2, Ledger!$D$2:$D$500, B$1)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;In this setup:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;code&gt;Ledger!$E$2:$E$500&lt;/code&gt; holds your transaction amounts.&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;Ledger!$B$2:$B$500&lt;/code&gt; holds the &lt;code&gt;Unit_ID&lt;/code&gt; (matched against &lt;code&gt;$A2&lt;/code&gt;, such as &lt;code&gt;Unit-1A&lt;/code&gt;).&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;Ledger!$D$2:$D$500&lt;/code&gt; holds the &lt;code&gt;Tax_Category&lt;/code&gt; (matched against &lt;code&gt;B$1&lt;/code&gt;, such as &lt;code&gt;Repairs&lt;/code&gt;, &lt;code&gt;Supplies&lt;/code&gt;, &lt;code&gt;Insurance&lt;/code&gt;, &lt;code&gt;Utilities&lt;/code&gt;, or &lt;code&gt;Taxes&lt;/code&gt;).&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;When every receipt is tagged once at entry, your Schedule E summary updates in real time throughout the year.&lt;/p&gt;

&lt;h2&gt;
  
  
  2. Separate Operating Expenses from Capital Expenditures (CapEx)
&lt;/h2&gt;

&lt;p&gt;A common bookkeeping mistake is lumping routine maintenance together with major replacements. If you replace a $6,500 roof on one unit and log it under &lt;code&gt;Repairs&lt;/code&gt;, that unit will look artificially unprofitable for the entire year.&lt;/p&gt;

&lt;p&gt;Keep these two buckets strictly separated in your ledger:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Operating Expenses (OpEx):&lt;/strong&gt; Recurring costs required to keep the unit habitable and leased (plumbing repairs, lawn care, insurance, property taxes, utilities).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Capital Expenditures (CapEx):&lt;/strong&gt; Long-term improvements that extend the useful life of the asset (roof replacement, HVAC unit, new appliances, flooring overhaul).&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Calculating true &lt;strong&gt;Net Operating Income (NOI)&lt;/strong&gt; per unit becomes straightforward:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Unit NOI = Gross Collected Rent - Unit Operating Expenses
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Keeping CapEx below the NOI line lets you evaluate operational efficiency accurately while still tracking total cash outflow.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. Standardize Turnovers with a Room-by-Room Inspection Log
&lt;/h2&gt;

&lt;p&gt;Spreadsheets alone will not protect you during a security deposit dispute. You need dated, room-by-room documentation comparing move-in condition against move-out condition. Use a consistent five-column log for every turnover:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;| Area / Item        | Move-In Condition | Move-Out Condition | Repair Cost | Photo ID |
|--------------------|-------------------|--------------------|-------------|----------|
| Kitchen - Flooring | Intact, clean     | 3 deep gouges      | $220.00     | IMG_0412 |
| Bath - Vanity      | Minor wear        | Cracked basin      | $185.00     | IMG_0419 |
| Living - Walls     | Fresh paint       | Unapproved holes   | $95.00      | IMG_0425 |
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Pairing this log with a security deposit deduction ledger ensures every dollar withheld is backed by objective evidence and an invoice.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. Run a Fixed Monthly Operating Cadence
&lt;/h2&gt;

&lt;p&gt;Consistent workflows prevent small issues from becoming expensive emergencies:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Day 1–5 (Rent &amp;amp; Late Notices):&lt;/strong&gt; Reconcile incoming rent by unit. If a balance remains unpaid past your grace period, trigger a standardized written notice immediately rather than sending ad-hoc texts.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Mid-Month (Maintenance &amp;amp; Vendors):&lt;/strong&gt; Log every work order with vendor contact info, cost, and warranty notes so you never pay twice for the same repair.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;End of Month (Reconciliation):&lt;/strong&gt; Verify bank balances against your ledger and confirm every transaction has a &lt;code&gt;Unit_ID&lt;/code&gt; and &lt;code&gt;Tax_Category&lt;/code&gt;.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Skip the Blank-Sheet Setup
&lt;/h2&gt;

&lt;p&gt;If you want this entire system ready to use out of the box without spending a weekend building formulas and checklists from scratch, check out the &lt;strong&gt;Small Landlord &amp;amp; Self-Managing Property Operations Kit&lt;/strong&gt; for a one-time price of $19.00.&lt;/p&gt;

&lt;p&gt;Inside, you get a 5-Minute Quick-Start Guide, copy-pasteable templates and formulas for income/expense tracking and Schedule E rollups, a complete worked example of a full year of unit-level bookkeeping, an operating cadence playbook (covering move-in/out inspections, late-rent notices, and vendor management), and a quick-reference cheat sheet for tax-deductible categories.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://buy.stripe.com/test_4gMcN54jrdQN6wW22s0oM01" rel="noopener noreferrer"&gt;Get the Small Landlord &amp;amp; Self-Managing Property Operations Kit ($19)&lt;/a&gt;&lt;/p&gt;

</description>
      <category>productivity</category>
      <category>spreadsheet</category>
      <category>workflow</category>
      <category>finance</category>
    </item>
    <item>
      <title>How to Calculate Laser Kerf and Material Thickness for Press-Fit Finger Joints</title>
      <dc:creator>Mike Rudolph</dc:creator>
      <pubDate>Mon, 16 Nov 2026 23:54:12 +0000</pubDate>
      <link>https://dev.to/kitfoundrymike/how-to-calculate-laser-kerf-and-material-thickness-for-press-fit-finger-joints-1g55</link>
      <guid>https://dev.to/kitfoundrymike/how-to-calculate-laser-kerf-and-material-thickness-for-press-fit-finger-joints-1g55</guid>
      <description>&lt;h2&gt;
  
  
  Why Nominal 3mm Templates Fail on Real Workshop Stock
&lt;/h2&gt;

&lt;p&gt;If you have ever downloaded a free finger-jointed organizer file and watched the tabs either rattle loosely or snap during assembly, the culprit is almost never your laser cutter's mechanical accuracy. It is the gap between nominal labels and physical reality.&lt;/p&gt;

&lt;p&gt;Nominal 3mm or 1/8-inch birch plywood and cast acrylic routinely measure anywhere from 2.8mm to 3.2mm across different batches—and sometimes across opposite corners of the same sheet. On top of that, a laser beam removes 0.10mm to 0.20mm of material (kerf) along every cut line. Without compensating for both variables, your joints will never lock cleanly on the first pass.&lt;/p&gt;

&lt;p&gt;Here is a repeatable, four-step calibration method you can use before cutting any modular tray or drawer divider.&lt;/p&gt;

&lt;h2&gt;
  
  
  1. Measure Real Sheet Thickness, Not the Label
&lt;/h2&gt;

&lt;p&gt;Never plug &lt;code&gt;3.0mm&lt;/code&gt; into a parametric design without checking the physical sheet first.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Use digital calipers to measure all four corners and the center of your sheet.&lt;/li&gt;
&lt;li&gt;Average the readings to find your working thickness &lt;code&gt;T&lt;/code&gt; (for example, &lt;code&gt;3.05mm&lt;/code&gt;).&lt;/li&gt;
&lt;li&gt;If one edge varies by more than 0.15mm, place smaller compartments on the thinner zone and long divider spans on the uniform section.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  2. Run a 30-Second Scrap-Test Kerf Gauge
&lt;/h2&gt;

&lt;p&gt;Because kerf shifts with focal height, lens cleanliness, air assist, and material density, measure it on scrap from the exact sheet you plan to cut.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Cut a 20.00mm x 20.00mm square out of scrap.&lt;/li&gt;
&lt;li&gt;Measure the physical square with calipers (for example, &lt;code&gt;19.85mm&lt;/code&gt;).&lt;/li&gt;
&lt;li&gt;Calculate total kerf &lt;code&gt;K&lt;/code&gt; using: &lt;code&gt;K = Drawn Width - Measured Width&lt;/code&gt; (&lt;code&gt;20.00 - 19.85 = 0.15mm&lt;/code&gt;).&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Because the laser beam removes half of &lt;code&gt;K&lt;/code&gt; (&lt;code&gt;0.075mm&lt;/code&gt;) from each side of the cut path, you must offset tabs outward and slots inward by &lt;code&gt;K/2&lt;/code&gt; per edge.&lt;/p&gt;

&lt;h2&gt;
  
  
  3. Apply the Kerf-Offset Formula to Tabs and Slots
&lt;/h2&gt;

&lt;p&gt;Once you have &lt;code&gt;T&lt;/code&gt; and &lt;code&gt;K&lt;/code&gt;, apply them to your finger-joint geometry. Here is a worked example for &lt;code&gt;T = 3.05mm&lt;/code&gt; plywood with &lt;code&gt;K = 0.15mm&lt;/code&gt;:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Target Nominal Tab Width:  10.00 mm
Target Press-Fit Factor:    0.02 mm (optional snugness)

Slot Depth = T = 3.05 mm
Drawn Tab Width  = Nominal Tab + K = 10.00 + 0.15 = 10.15 mm
Drawn Slot Width = Nominal Slot - K - Press-Fit = 10.00 - 0.15 - 0.02 = 9.83 mm
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;When the laser burns &lt;code&gt;0.075mm&lt;/code&gt; off both edges of the &lt;code&gt;10.15mm&lt;/code&gt; tab, the physical tab lands at &lt;code&gt;10.00mm&lt;/code&gt;. When it burns &lt;code&gt;0.075mm&lt;/code&gt; inside both edges of the &lt;code&gt;9.83mm&lt;/code&gt; slot, the physical opening lands at &lt;code&gt;9.98mm&lt;/code&gt;—giving you a crisp, rattle-free press fit that holds square without clamping.&lt;/p&gt;

&lt;h2&gt;
  
  
  4. Pre-Cut Vector Hygiene Checklist
&lt;/h2&gt;

&lt;p&gt;Even perfect math fails if your vector file has hidden geometry flaws. Before sending any job to your cutter, run this quick check:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Delete duplicate lines:&lt;/strong&gt; Overlapping paths double-burn edges, widening kerf and scorching plywood.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Close all open paths:&lt;/strong&gt; Unclosed nodes leave tiny bridges that force you to snap parts out with a blade.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Order inner cuts first:&lt;/strong&gt; Always cut divider slots and finger holes before outer perimeters so parts do not shift mid-job.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Check grain orientation:&lt;/strong&gt; Align long drawer divider walls parallel to the outer veneer grain for maximum stiffness.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Get the Complete Parametric Organizer System
&lt;/h2&gt;

&lt;p&gt;If you want to skip manual spreadsheet math and start cutting exact-fit workshop storage right away, grab the &lt;strong&gt;&lt;a href="https://buy.stripe.com/test_bJe6oHbLT5kh5sS7mM0oM00" rel="noopener noreferrer"&gt;Kerf-Compensated Modular Workbench &amp;amp; Drawer Organizer System&lt;/a&gt;&lt;/strong&gt; ($12.00 one-time). It includes a 5-Minute Quick-Start Guide, parametric kerf-offset formulas, modular tray and divider layout templates, a complete worked example, a troubleshooting playbook, and a one-page workshop cheat sheet.&lt;/p&gt;

</description>
      <category>lasercutting</category>
      <category>cnc</category>
      <category>woodworking</category>
      <category>workflow</category>
    </item>
  </channel>
</rss>
