{"product_id":"small-business-bookkeeping-spreadsheet","title":"Small Business Bookkeeping Spreadsheet","description":"\u003cp\u003eThis small business bookkeeping spreadsheet keeps a whole year of your books in a file you own outright. Record money in and money out, and it produces your profit and loss, sales tax, quarterly set-aside and a live dashboard without a subscription.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose Full year or any month and the whole page follows. Nothing on the dashboard is typed; it fills itself from your two registers.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFive live cards: income, expenses, profit, margin and tax to set aside, each with twelve-month bars\u003c\/li\u003e\n\u003cli\u003eIncome against expenses every month, with your profit so far this year drawn as a line\u003c\/li\u003e\n\u003cli\u003eSales tax collected, tax claimed back and what is left owing\u003c\/li\u003e\n\u003cli\u003eSpending by category: the eight biggest and the rest\u003c\/li\u003e\n\u003cli\u003eQuarterly tax set-aside: what to put aside each quarter, with its due date\u003c\/li\u003e\n\u003cli\u003eBusiness miles by month and what they are worth\u003c\/li\u003e\n\u003cli\u003eProfit margin: how much of each month's income you kept\u003c\/li\u003e\n\u003cli\u003eTop clients: who pays you most, and how much of your income the top one makes up\u003c\/li\u003e\n\u003cli\u003eInvoices paid, waiting and overdue, and how many are still open\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eTwo registers in, seventeen tabs out\u003c\/h2\u003e\u003cp\u003eYou enter money in on one tab and money out on another, pick a tax rate for each line, and everything else reads those two. The monthly view, the quarterly view, the profit and loss statement, the sales tax worksheet and the dashboard all recalculate. Nothing is typed twice, and no number on a report can disagree with the ledger it came from.\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:\u003c\/strong\u003e twelve months of income, spending, profit and margin\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eQuarterly:\u003c\/strong\u003e the four quarters, with tax due and tax to set aside\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProfit and Loss:\u003c\/strong\u003e every category with its share and the margin\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\u003eCustom Range:\u003c\/strong\u003e pick any two dates and everything 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\u003eClients:\u003c\/strong\u003e billed, jobs, average and last paid, read from the ledger\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eInvoices:\u003c\/strong\u003e an invoice tracker for what is out, what is paid and what is overdue\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eInventory:\u003c\/strong\u003e unit cost, sell price, margin and stock value\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMileage:\u003c\/strong\u003e logged at your own rate\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eDashboard and Start Here\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eIt is built for anyone running a small business, or self employed, who wants their own numbers in an income tracker and expense tracker they control. It splits sales tax out of every line, nets it quarter by quarter, and compares any two years month by month.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download has a light edition and a dark edition, with every tab restyled, not only the dashboard, and the same formulas in both. The filled copy holds two full years of demo data, so the comparison view 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 needed, and no Google account needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. You get real spreadsheet files, not a PDF with a link in it.\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\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (light and dark, 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 as soon as payment clears. The template is for use in your own business; please do not share or resell the files. 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 it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The Excel workbooks run in Excel 2016 or later on Windows and Mac without a Google account, and the instruction guide has one-click links to the Google Sheets versions.\u003c\/p\u003e\u003ch3\u003eHow much do I have to type?\u003c\/h3\u003e\u003cp\u003eOnly two registers: money in on the Income tab and money out on the Expenses tab, 500 rows each, with a tax rate picked per line. Every other tab is calculated.\u003c\/p\u003e\u003ch3\u003eDoes it handle sales tax?\u003c\/h3\u003e\u003cp\u003eYes. It splits sales tax out of every line, nets tax collected against tax paid quarter by quarter, and shows what is left owing.\u003c\/p\u003e\u003ch3\u003eCan it help me put money aside for income tax?\u003c\/h3\u003e\u003cp\u003eYes. It turns your real profit into a quarterly set-aside at the percentage you choose, with each quarter's due date on the dashboard.\u003c\/p\u003e\u003ch3\u003eIs this accounting advice?\u003c\/h3\u003e\u003cp\u003eNo. It is a bookkeeping tool that records and calculates what you enter, not tax or accounting advice.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597861060702,"sku":"OPX-019","price":35.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/small-business-bookkeeping-spreadsheet-01.jpg?v=1790832031","url":"https:\/\/opxviashop.com\/products\/small-business-bookkeeping-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}