{"product_id":"food-truck-bookkeeping-spreadsheet","title":"Food Truck Bookkeeping Spreadsheet","description":"\u003cp\u003eThis food truck bookkeeping spreadsheet keeps daily takings, pitch fees and event bookings in one set of books. It is built for food trucks and caterers who want to see, line by line and month by month, what the business actually keeps.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003ePitch fees you can see\u003c\/h2\u003e\u003cp\u003ePitch fees get their own expense category, so a pitch that never pays for itself shows up as a number instead of hiding inside general costs. For a catering business with event bookings on top of street trading, that is usually the first question worth answering.\u003c\/p\u003e\u003ch2\u003eTwo registers, everything else calculated\u003c\/h2\u003e\u003cp\u003eMoney in goes on one tab and money out on another, and you pick a tax rate for each line. The monthly view, the quarterly view, the profit and loss statement, the sales tax worksheet and the dashboard all read those two registers and recalculate. Nothing is typed twice, so no report can disagree with the ledger behind it.\u003c\/p\u003e\u003ch2\u003e16 connected tabs\u003c\/h2\u003e\u003cp\u003eThe workbook is split into these connected tabs, each reading the same two registers:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome:\u003c\/strong\u003e 500 rows, with the tax split out on every line\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eExpenses:\u003c\/strong\u003e 500 rows, split the same way\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e your categories, your tax rates and your set-aside percentage\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly, Quarterly and Profit \u0026amp; Loss:\u003c\/strong\u003e all calculated, nothing typed\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSales Tax:\u003c\/strong\u003e collected against paid, by rate and by quarter\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eEstimated Tax:\u003c\/strong\u003e four quarterly set-asides at your own rate\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCustom Range:\u003c\/strong\u003e pick any two dates and every figure follows\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eComparison:\u003c\/strong\u003e this year against last, month by month\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBalances:\u003c\/strong\u003e what each account took in and paid out\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e six live figures and the four quarters\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here:\u003c\/strong\u003e setup in a few minutes\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eThe Estimated Tax tab gives you four quarterly tax set-asides at the rate you choose, which makes the quarterly tax bill something you plan for rather than react to. Use it as an expense tracker day to day and as a year-end summary when you need one.\u003c\/p\u003e\u003ch2\u003eReal files, filled and blank\u003c\/h2\u003e\u003cp\u003eYou get real spreadsheet files, not a PDF with a link in it: Excel and Google Sheets, each filled with a worked example and each blank and ready for your own numbers. The filled copy is the file in the photos, with two full years of demo data so the Comparison tab has something real to compare.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros, no subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The Start Here tab walks you through setup in a few minutes. The files are for use in your own business; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes this work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. You download Excel files that run on Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eWhere do pitch fees go?\u003c\/h3\u003e\u003cp\u003ePitch fees have their own expense category, so you can see what each pitch costs against what it brings in rather than lumping it into general costs.\u003c\/p\u003e\u003ch3\u003eCan it handle sales tax at more than one rate?\u003c\/h3\u003e\u003cp\u003eYes. You pick a tax rate on every income and expense line, and the Sales Tax tab shows tax collected against tax paid by rate and by quarter.\u003c\/p\u003e\u003ch3\u003eCan I compare this year with last year?\u003c\/h3\u003e\u003cp\u003eYes. The Comparison tab sets this year against last, month by month, and the filled copy ships with two years of demo data so you can see it working.\u003c\/p\u003e\u003ch3\u003eDoes it connect to my bank or card reader?\u003c\/h3\u003e\u003cp\u003eNo. There is no bank connection, no add-ins and no macros. You type or paste your income and expenses into the two registers.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597862338654,"sku":"OPX-039","price":27.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/food-truck-bookkeeping-spreadsheet-01.jpg?v=1790832148","url":"https:\/\/opxviashop.com\/products\/food-truck-bookkeeping-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}