{"product_id":"photographer-bookkeeping-spreadsheet","title":"Photographer Bookkeeping Spreadsheet","description":"\u003cp\u003eThis photographer bookkeeping spreadsheet puts your shoots, albums and invoices in the same set of books. It is for photographers who want the client list, the invoices and the numbers in one file instead of three, and it works out your profit and tax set-aside as you go.\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\u003eClients that add themselves up\u003c\/h2\u003e\u003cp\u003eA client is a name you type once. What they were billed, how many shoots they booked, the average job and when they last paid all calculate themselves from the ledger, so your client tracker and invoice tracker never fall out of step with the money.\u003c\/p\u003e\u003ch2\u003eOne ledger, every report\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. Your income tracker, profit and loss and quarterly tax figures all come from the same two lists.\u003c\/p\u003e\u003ch2\u003eSixteen connected tabs\u003c\/h2\u003e\u003cp\u003eTwo registers do the work and every other tab reports on them.\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 and Loss:\u003c\/strong\u003e all calculated\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 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\u003eDashboard:\u003c\/strong\u003e six live figures and the four quarters\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here:\u003c\/strong\u003e walks you through setup in a few minutes\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eTwo years of demo data\u003c\/h2\u003e\u003cp\u003eThe filled copy holds two full years of demo data, so the comparison view has something real to compare. Click through a full photography year before you enter a single wedding or portrait session of your own.\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\u003eThe Excel workbook, filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for your own numbers\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with 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 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 workbook runs in Excel 2016 or later on Windows and Mac with no Google account needed, and the instruction guide holds two one-click links to the Google Sheets versions.\u003c\/p\u003e\u003ch3\u003eCan I see what each client has paid me?\u003c\/h3\u003e\u003cp\u003eYes. Type the client's name on each income line and billed, shoots, average and last paid calculate themselves.\u003c\/p\u003e\u003ch3\u003eDoes it handle sales tax on my sessions?\u003c\/h3\u003e\u003cp\u003eYes. Pick a tax rate per line and sales tax is split out, then netted against tax paid by rate and by quarter.\u003c\/p\u003e\u003ch3\u003eHow much should I put aside for tax?\u003c\/h3\u003e\u003cp\u003eThe Estimated Tax tab turns your profit into four quarterly set-asides at the percentage you choose. It is a bookkeeping tool, not tax or accounting advice.\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 Custom Range reports on any two dates.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597861978206,"sku":"OPX-033","price":29.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/photographer-bookkeeping-spreadsheet-01.jpg?v=1790832114","url":"https:\/\/opxviashop.com\/products\/photographer-bookkeeping-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}