{"id":201,"date":"2025-10-09T17:25:33","date_gmt":"2025-10-09T21:25:33","guid":{"rendered":"https:\/\/scootercam.net\/notes\/?p=201"},"modified":"2025-10-14T10:19:11","modified_gmt":"2025-10-14T14:19:11","slug":"michigan-llc-workflow","status":"publish","type":"post","link":"https:\/\/scootercam.net\/blog\/michigan-llc-workflow\/","title":{"rendered":"Michigan LLC Workflow"},"content":{"rendered":"\n<p>Here\u2019s a practical guide tailored for a single-member Michigan LLC like yours:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddfe 1. Separate All Business Finances<\/h2>\n\n\n\n<p><strong>Absolutely essential.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Get a business checking account<\/strong> in the LLC\u2019s name (you\u2019ll need your EIN and Articles of Organization).<\/li>\n\n\n\n<li><strong>Do not mix<\/strong> personal and business funds \u2014 even for small purchases.<\/li>\n\n\n\n<li>Use the LLC debit card or account for all income and expenses related to Scootercam.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcda 2. Decide on a Recordkeeping Method<\/h2>\n\n\n\n<p>Start simple \u2014 your main goal is accuracy and clarity. Three levels of effort:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Level<\/th><th>Method<\/th><th>What You Track<\/th><th>Pros<\/th><\/tr><\/thead><tbody><tr><td><strong>Basic<\/strong><\/td><td>Spreadsheet (Google Sheets or Excel)<\/td><td>Date, Category, Description, Amount<\/td><td>Free, simple, great for hobby-stage<\/td><\/tr><tr><td><strong>Intermediate<\/strong><\/td><td>Wave Accounting or Zoho Books (both free tiers)<\/td><td>Invoices, receipts, income\/expenses, bank feeds<\/td><td>Automates a lot, good for sponsors\/subscribers<\/td><\/tr><tr><td><strong>Advanced<\/strong><\/td><td>QuickBooks or FreshBooks<\/td><td>Full bookkeeping, reporting, tax prep<\/td><td>Paid, but professional-grade<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcb8 3. Track These Core Things<\/h2>\n\n\n\n<p>At minimum, record:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Category<\/th><th>Examples<\/th><\/tr><\/thead><tbody><tr><td><strong>Income<\/strong><\/td><td>Ad\/sponsor revenue, subscriptions, merch, donations<\/td><\/tr><tr><td><strong>Expenses<\/strong><\/td><td>Domain, hosting\/VPN, equipment (camera, sensors), web services, software, mileage (for maintenance trips), supplies<\/td><\/tr><tr><td><strong>Owner Contributions<\/strong><\/td><td>Money you personally invest in Scootercam<\/td><\/tr><tr><td><strong>Owner Draws<\/strong><\/td><td>Any money you take out for yourself<\/td><\/tr><tr><td><strong>Assets<\/strong><\/td><td>Equipment worth more than ~$500 (camera, computer, etc.)<\/td><\/tr><tr><td><strong>Liabilities<\/strong><\/td><td>Loans or credit cards in LLC\u2019s name<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Keep <strong>receipts<\/strong> (digital copies are fine) for <em>everything<\/em>. Cloud storage (Google Drive or Dropbox) works well \u2014 use folders by year\/month.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcc5 4. Keep a Simple Ledger<\/h2>\n\n\n\n<p>If you prefer a spreadsheet, include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Date<\/li>\n\n\n\n<li>Description<\/li>\n\n\n\n<li>Category (Hosting, Equipment, etc.)<\/li>\n\n\n\n<li>Payment Method<\/li>\n\n\n\n<li>Amount<\/li>\n\n\n\n<li>Notes<\/li>\n<\/ul>\n\n\n\n<p>That\u2019s all you need to generate totals for taxes or sponsors later.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udde0 5. For Tax Purposes<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>As a <strong>single-member LLC<\/strong>, you\u2019ll report income\/expenses on your personal return via <strong>Schedule C (Form 1040)<\/strong>.<\/li>\n\n\n\n<li>Keep an eye on:\n<ul class=\"wp-block-list\">\n<li><strong>Quarterly estimated taxes<\/strong> if income grows<\/li>\n\n\n\n<li><strong>Sales tax<\/strong> (not needed yet unless you sell merch or charge subscribers for services)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Track <strong>mileage<\/strong> if you drive for maintenance or filming (the IRS rate changes yearly \u2014 ~67\u00a2\/mile in 2024).<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddfe 6. When You Start Earning<\/h2>\n\n\n\n<p>Once sponsors or subscribers come aboard:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Issue <strong>invoices<\/strong> with your LLC name, address, and EIN.<\/li>\n\n\n\n<li>Keep a log of <strong>who paid, how much, and when<\/strong>.<\/li>\n\n\n\n<li>Use your accounting system to create <strong>Profit &amp; Loss<\/strong> statements \u2014 sponsors love seeing where their support goes.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udea3 7. Backups &amp; Habits<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reconcile your records monthly (match your ledger or software to your bank statement).<\/li>\n\n\n\n<li>Keep a separate folder for each fiscal year.<\/li>\n\n\n\n<li>Back up data to the cloud.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udded Recommended Next Steps for You<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u2705 Open a business checking account.<\/li>\n\n\n\n<li>\u2705 Get a free bookkeeping tool (Wave or a spreadsheet).<\/li>\n\n\n\n<li>\u2705 Log <strong>every<\/strong> business expense starting now.<\/li>\n\n\n\n<li>\ud83d\uddc2\ufe0f Create folders: <code>\/2025\/Income<\/code>, <code>\/2025\/Expenses<\/code>, <code>\/2025\/Receipts<\/code>.<\/li>\n\n\n\n<li>\ud83d\udcc5 Set a recurring monthly reminder: <em>\u201cReconcile Scootercam finances.\u201d<\/em><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>If you\u2019d like, I can make you a <strong>ready-to-use bookkeeping spreadsheet template<\/strong> customized for Scootercam (with categories for hosting, sensors, etc.) \u2014 would you like me to generate that for download?<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">You said:<\/h5>\n\n\n\n<p>yes<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">ChatGPT said:<\/h6>\n\n\n\n<p>Perfect \ud83d\udc4d \u2014 I\u2019ll build a simple, tailored bookkeeping spreadsheet for <strong>Scootercam Worldwide LLC<\/strong>, with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Separate tabs for <strong>Income<\/strong>, <strong>Expenses<\/strong>, and <strong>Summary<\/strong><\/li>\n\n\n\n<li>Predefined categories (hosting, sensors, cameras, travel, etc.)<\/li>\n\n\n\n<li>Automatic totals and year-to-date summaries<\/li>\n<\/ul>\n\n\n\n<p>Before I generate the file, a few quick choices so it fits your workflow:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Format preference:<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ud83d\udfe2 Google Sheets (shareable link, editable online)<\/li>\n\n\n\n<li>\ud83d\udd35 Excel (.xlsx file you can download and open locally)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Expense categories:<\/strong> I\u2019ll include standard ones (hosting, equipment, software, travel, marketing, office).<br>\u2013 Do you want me to add any <strong>Scootercam-specific<\/strong> ones like \u201cWeather API,\u201d \u201cWebcam Maintenance,\u201d \u201cBeach Operations,\u201d or similar?<\/li>\n<\/ol>\n\n\n\n<p>Once you confirm those two items, I\u2019ll generate your bookkeeping file right away.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">You said:<\/h5>\n\n\n\n<p>google sheets, and yes there are misc specific cost<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">ChatGPT said:<\/h6>\n\n\n\n<p>Excellent \u2014 we\u2019ll set it up for <strong>Google Sheets<\/strong>, optimized for Scootercam\u2019s mix of tech, weather, and creative expenses.<\/p>\n\n\n\n<p>Here\u2019s what I\u2019ll include by default:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83e\uddfe Tabs<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Income<\/strong> \u2013 date, description, category (sponsorship, subscription, donation, merch, other), payment method, amount<\/li>\n\n\n\n<li><strong>Expenses<\/strong> \u2013 date, vendor, category, description, amount, notes<\/li>\n\n\n\n<li><strong>Summary Dashboard<\/strong> \u2013 automatic totals, monthly and year-to-date profit\/loss, category charts<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83e\uddf0 Expense Categories (customized for Scootercam)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Domain &amp; Hosting<\/li>\n\n\n\n<li>Web Services \/ APIs (Visual Crossing, MoonAPI, etc.)<\/li>\n\n\n\n<li>Equipment (Cameras, Sensors, Weather Station)<\/li>\n\n\n\n<li>Repairs &amp; Maintenance<\/li>\n\n\n\n<li>Travel \/ Mileage<\/li>\n\n\n\n<li>Marketing \/ Branding<\/li>\n\n\n\n<li>Software &amp; Subscriptions<\/li>\n\n\n\n<li>Office Supplies<\/li>\n\n\n\n<li>Utilities \/ Internet<\/li>\n\n\n\n<li>Miscellaneous \/ Other<\/li>\n\n\n\n<li>Owner Contribution \/ Draw<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>To finalize before I generate the sheet:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>What <strong>fiscal year start<\/strong> do you want? (Most use <strong>January 1<\/strong>, but if you\u2019d rather start from when Scootercam LLC was formed, I can use that month instead.)<\/li>\n\n\n\n<li>And do you want the <strong>Summary Dashboard<\/strong> to include automatic charts (like a pie chart of expenses and bar chart of income by month)?<\/li>\n<\/ul>\n\n\n\n<p>Once I have those two answers, I\u2019ll create and share the ready-to-import Google Sheets template.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">You said:<\/h5>\n\n\n\n<p>We can use Jan 1. Summary is good<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">ChatGPT said:<\/h6>\n\n\n\n<p>Here\u2019s your customized bookkeeping starter file for <strong>Scootercam Worldwide LLC<\/strong>:<\/p>\n\n\n\n<p>\ud83d\udcca <a>Download Scootercam_Bookkeeping_Template.xlsx<\/a><\/p>\n\n\n\n<p>You can easily <strong>upload this file to Google Drive<\/strong>, then open it with <strong>Google Sheets<\/strong> to convert it into a live, editable format.<br>Once open, you can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add your transactions under <strong>Income<\/strong> and <strong>Expenses<\/strong><\/li>\n\n\n\n<li>Use <strong>Insert \u2192 Chart<\/strong> to build your Summary dashboard (pie chart for expenses, bar for income)<\/li>\n\n\n\n<li>Expand categories as your operations grow<\/li>\n<\/ul>\n\n\n\n<p>Would you like me to generate the ready-to-paste Google Sheets formulas and chart setup instructions next (so totals and visuals auto-update)?<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">You said:<\/h5>\n\n\n\n<p>yes<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">ChatGPT said:<\/h6>\n\n\n\n<p>Perfect \ud83d\udc4d \u2014 here\u2019s how to make your <strong>Scootercam Worldwide LLC<\/strong> bookkeeping sheet in Google Sheets <em>fully automatic<\/em> with totals and visuals.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddee 1. Basic Setup (after uploading the Excel file)<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Upload <code>Scootercam_Bookkeeping_Template.xlsx<\/code> to Google Drive.<\/li>\n\n\n\n<li>Open it \u2192 <strong>File \u2192 Save as Google Sheets.<\/strong><\/li>\n\n\n\n<li>You\u2019ll now have 3 tabs: <code>Income<\/code>, <code>Expenses<\/code>, and <code>Summary<\/code> (you can add the last manually if needed).<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcca 2. Formulas to Add Totals<\/h2>\n\n\n\n<p>In your <strong>Income<\/strong> sheet (assuming headers in row 1):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUM(E2:E)\n<\/code><\/pre>\n\n\n\n<p>Place that in any cell (e.g., top right corner) to see your total income.<\/p>\n\n\n\n<p>In your <strong>Expenses<\/strong> sheet:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUM(E2:E)\n<\/code><\/pre>\n\n\n\n<p>That gives you your total expenses.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcb0 3. Summary Sheet Structure<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Cell<\/th><th>Formula<\/th><th>Notes<\/th><\/tr><\/thead><tbody><tr><td><strong>B2<\/strong><\/td><td><code>='Income'!E2:E<\/code><\/td><td>Pulls income data<\/td><\/tr><tr><td><strong>B3<\/strong><\/td><td><code>='Expenses'!E2:E<\/code><\/td><td>Pulls expense data<\/td><\/tr><tr><td><strong>B5<\/strong><\/td><td><code>=SUM('Income'!E2:E)<\/code><\/td><td>Total Income<\/td><\/tr><tr><td><strong>B6<\/strong><\/td><td><code>=SUM('Expenses'!E2:E)<\/code><\/td><td>Total Expenses<\/td><\/tr><tr><td><strong>B7<\/strong><\/td><td><code>=B5-B6<\/code><\/td><td>Profit (or loss)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>You can label these:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>A5: Total Income\nA6: Total Expenses\nA7: Net Profit (Loss)\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udcc5 4. Monthly Totals (for charts)<\/h2>\n\n\n\n<p>In <strong>Summary<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Month<\/th><th>Income<\/th><th>Expenses<\/th><\/tr><\/thead><tbody><tr><td>Jan<\/td><td><code>=SUM(FILTER(Income!E:E, MONTH(Income!A:A)=1))<\/code><\/td><td><code>=SUM(FILTER(Expenses!E:E, MONTH(Expenses!A:A)=1))<\/code><\/td><\/tr><tr><td>Feb<\/td><td><code>=SUM(FILTER(Income!E:E, MONTH(Income!A:A)=2))<\/code><\/td><td><code>=SUM(FILTER(Expenses!E:E, MONTH(Expenses!A:A)=2))<\/code><\/td><\/tr><tr><td>\u2026<\/td><td>\u2026<\/td><td>\u2026<\/td><\/tr><tr><td>Dec<\/td><td><code>=SUM(FILTER(Income!E:E, MONTH(Income!A:A)=12))<\/code><\/td><td><code>=SUM(FILTER(Expenses!E:E, MONTH(Expenses!A:A)=12))<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Then add:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUM(B2:B13)  \u2192 Total Income\n=SUM(C2:C13)  \u2192 Total Expenses\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\uddc1 5. Adding Charts (Visual Dashboard)<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Highlight your month-income-expense table.<\/li>\n\n\n\n<li>Go to <strong>Insert \u2192 Chart<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Column Chart<\/strong> for month-over-month income vs. expenses.<\/li>\n\n\n\n<li>Add another:\n<ul class=\"wp-block-list\">\n<li>Select your <em>Expenses<\/em> table (Category vs. Amount).<\/li>\n\n\n\n<li><strong>Insert \u2192 Chart \u2192 Pie chart.<\/strong><\/li>\n\n\n\n<li>Title it \u201cExpense Breakdown.\u201d<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>Optional aesthetic touches:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Under <em>Customize \u2192 Chart style<\/em>, use Scootercam colors:\n<ul class=\"wp-block-list\">\n<li>Lake blue: <code>#38b6fe<\/code><\/li>\n\n\n\n<li>Beach gold: <code>#f3b02e<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Set currency format:<br><strong>Format \u2192 Number \u2192 Currency.<\/strong><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83e\udded 6. Suggested Workflow<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Log every transaction weekly (takes &lt;10 minutes).<\/li>\n\n\n\n<li>Reconcile monthly with your bank statement.<\/li>\n\n\n\n<li>Use the <strong>Summary<\/strong> chart at tax time or to show sponsors how funds are used.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Would you like me to generate a version of this <strong>Summary tab (with all the formulas prefilled)<\/strong> so you can just copy\/paste it directly into your Google Sheet?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here\u2019s a practical guide tailored for a single-member Michigan LLC like yours: \ud83e\uddfe 1. Separate All Business Finances Absolutely essential. \ud83d\udcda 2. Decide on a Recordkeeping Method Start simple \u2014 your main goal is accuracy and clarity. Three levels of effort: Level Method What You Track Pros Basic Spreadsheet (Google Sheets or Excel) Date, Category, &#8230; <a title=\"Michigan LLC Workflow\" class=\"read-more\" href=\"https:\/\/scootercam.net\/blog\/michigan-llc-workflow\/\" aria-label=\"Read more about Michigan LLC Workflow\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[9],"tags":[],"class_list":["post-201","post","type-post","status-publish","format-standard","hentry","category-notes"],"_links":{"self":[{"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/posts\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/comments?post=201"}],"version-history":[{"count":1,"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/posts\/201\/revisions"}],"predecessor-version":[{"id":202,"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/posts\/201\/revisions\/202"}],"wp:attachment":[{"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/media?parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/categories?post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scootercam.net\/blog\/wp-json\/wp\/v2\/tags?post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}