JT Spunk | Photography

Simple Accounting for the Small Business – Synoptic Journal Bookkeeping Using a Simple Accounting Spreadsheet Template

Starting a small business out of your home, offering products or services like business consulting, photography, selling on the web or a MLM? You are now faced with tracking all your expenses and revenues for your business and you certainly don’t have the money yet to engage a bookkeeper or accountant. If your business is a sole proprietorship, whether it be a Canadian Proprietorship or a US-based Proprietorship, you do not require an accountant to submit your company financials (books) to the IRS (USA) or Revenue Canada). Your business revenue and losses are reported as part of your annual personal income tax. For this small business start-up, you won’t need to buy fancy accounting software, like Quick Books or AccPac to track your business.

Only as part of incorporating Bizfare Enterprise Inc in 2005 was it a requirement to engage an accountant. My accountant did insist on using Quick Books software for my business accounting. Up until then using a simple spreadsheet template served my business accounting needs for over ten years. This simple spreadsheet accounting stood the test of multiple audits by Revenue Canada (CRA and Revenue Canada Goods and Services Tax. Both the hardcopy columnar pad and an electronic spreadsheet version of my financial books were accepted by Revenue Canada. (BTW the audits disclosed more ways for me to claim back additional taxes for the previous three years! Now that’s my type of audit!)

In your new start-up business venture, you likely will generate somewhere between 10 to 30 accounting transactions per month. These transactions would be items like Expense, Revenue (sales), Liability (Loan) type transactions and Sales Tax (Federal + State/Provincial) Collection/Deductions. These transactions are further broken down into various Business Accounts. All the Accounts you set up for your business is called a Chart of Accounts. Recording your business financial transactions (Journal Entries) can be executed with pen and ink on an accounting columnar pad or electronically with your computer using a spreadsheet program (MS Excel, Open Office, Star Office).

Whether you employ electronic or hardcopy media, you need to develop a simple Journal template to create your Business Synoptic Journal. This Synoptic Journal format has the advantage of allowing you a complete view of all your individual journal entry transactions against all your various Business Accounts. Creating this Synoptic Journal is easier to do than you think and requires no prior accounting or bookkeeping knowledge.

TIP #1: You could further reduce the accounting line items (Journal Entries) by consolidating like items such as ‘all the Sales for the month’ and ‘all parking receipts for the month’ into one totaled line item for the month.

Where do you start to identify the various Business Accounts required for your Synoptic Journal?

If you currently work for a company or government, secure of one of their employee expense forms. Look at each of the areas identified as expenses – meals, mileage, hotel accommodations, taxi, car rental, telephone & cell phone, air fare, office supplies, etc. This is an excellent place to identify the various Business Expense Accounts you need to set up for your business accounting books. To complete your business Chart of Accounts, include a Business Bank Account, Sales, COGS (Cost of Goods Sold), Sales Tax Collection, Marketing Expense and others as required. Each of these Accounts will be a listed as a title across the top of each column of your Synoptic Journal. Each row (line item) will be the individual journal transactions entered by you. The journal transactions are grouped and summarized for each business month; usually, January through December.

So your Synoptic Journal would look something like this Sample Synoptic Journal at http://picasaweb.google.com/carl.chesal/BookkeepingTemplate.

The column headings might be in this order (from left to right):

DATE | DESCRIPTION | BANK DEPOSITS | BANK WITHDRAWALS | SALES REVENUE | COGS | SALES TAX COLLECTED & REMITTED | OFFICE SUPPLIES EXPENSE | EXPENSE #2 | EXPENSE #3 | ETC

TIP #2: Unless your business is Incorporated or an LLC, you don’t need to go through the expense of opening a business account with your bank. Usually Business accounts charge a higher monthly fee, charge for printing checks (cheques) and don’t offer any interest on your monthly account balance. Instead, open a separate personal bank account (maybe savings). This will show the ‘taxman’ that you are keeping the business separate from your personal banking. Remember you are a sole proprietor and all your business income (and losses) are to be applied directly to your personal income tax submission ( a s per IRS and CRA).

To save you time and make is very simple, I have already created a simple spreadsheet Synoptic Journal template that performs all the calculations for each month and rolls up the 12 business months so it can easily be included in your annual personal income tax preparation. This Synoptic Journal template has Debit/Credit checks and balances, tracks sales taxes, mileage and totals each account for your entire fiscal year. If you want this FREE Bookkeeping template, you can get it at Communicate Innovate. With a few key strokes, which will help identify yourself, I will gladly send you this FREE Synoptic Journal Template and also any future Small Business Tips.

TIP #3: One Rule of Accounting is that every time you record a journal entry (line item which applies the transaction against the appropriate business accounts) the Debits and Credits MUST REMAIN EQUAL at ALL Times. This Debit Equals Credit calculator is built into this FREE Bookkeeping Template. When you have completed entering a line item (journal transaction), check to ensure that the amount the the Debit cell equals the amount in the Credit cell. If they are not equal, you have not entered the amounts properly in your journal transaction. Correct the problem before entering your next journal entry.

You are now equipped to capture your business financial books with some simple accounting software. Happy bookkeeping! And Happy Selling!

About the Author

Carl Chesal is a business and channel development consultant, trainer, internet marketer and professional photographer. He operates BizFare Enterprise Inc, providing business development, marketing, and internet marketing services. Bizfare Enterprise also operates a number of secure on-line shopping sites.

ENTIRE COLLECTION – PHOTOGRAPHY TEMPLATES – 20 DISCS $153.99

Marketing your photography business, guide & templates $80.00

DIGITAL BACKGROUNDS PHOTO BACKDROPS PHOTOSHOP TEMPLATES PSD PHOTOGRAPHY ACTIONS $64.90

DIGITAL BACKGROUNDS PHOTOSHOP TEMPLATES GREEN SCREEN PHOTO BACKDROPS PHOTOGRAPHY $59.95

DIGITAL BACKGROUNDS PHOTOSHOP TEMPLATES GREEN SCREEN PHOTO BACKDROPS PHOTOGRAPHY $59.75

Digital Backgrounds Photography Backdrops Wedding Album Photo Book Templates 1F $49.50

Model Composites Zed Card Templates, Backgrounds, Fashion Photography, Seniors $44.99

Valentine Templates Photography Wedding Backgrounds $39.95

MS1 Mega Senior Digital Backgrounds Wedding Album Templates edges Photography $34.99

Digital Backgrounds Photography Backdrops Photoshop Templates Green Screen o $34.95

Digital Photography Backdrops Backgrounds Photoshop Wedding Album Templates **** $29.99

Photography Templates Senior Wedding Kids Family More $29.99

Grunge Photography Templates Backgrounds Gothic Senior $29.99

Digital Photography Senior Templates Grad KLO Bundle P $28.99

ORGANIC Collection Digital Photoshop Template for Kids and Newborn Photography! $29.99

Lanzar HR5.1 Heritage 5.25-Inch Two-Way Custom Component Speaker System $95.99 * This Custom Kit Contains: * 5.25” Midrange Driver * Chromed Mica-Poly Cone * Butyl Rubber Surround * 120 Watts RMS/ 240 Watts Peak * Frequency Response: 80-8KHz * Impedance: 4 Ohms * One Pair Tweeter: * 1” Silk Dome Tweeter * Neodymium Magnet * 3 Mounting Options: Flush / Swivel / Surface or Angle Mount * Frequency Response: 1.4-24KHz * Impedance: 4 Ohms * One Pair Passive Crossover …

Epson Ultra High Definition R260 Photo Inkjet Printer $129.99 The Epson Stylus Photo R260 photo printer delivers Ultra Hi-Definition photos and documents–at truly amazing speeds. Print photos like those you’ve come to expect from the lab–only better. With this powerful printer, it couldn’t be easier. Precision, 6-color printing and Claria Hi-Definition Ink provide the ultimate combination of photo quality and longevity. Display stunning, borderless photo…

Artograph 10-Inch-by-12-Inch LightTracer Light Box $34.50 LightTracer light box has a 10×12 opaque screen and plastic frame (lightweight). The interior bulb is the popular 12 8 watt bright white bulb. Top of box features a tool tray. Great for copying graphics photos templates anything! Applications for memory albums (trace templates mats borders die-cuts etc.) quilters (trace stencils stitching lines right to the fabric!) needle artists painters and…

Avery Note Cards, 4.25 x 5.5 Inches, Matte, White, Box of 60 (08315) $11.58 Avery Note Cards offer you the ability to reach out to people in your own special way. Avery Note Cards offer you the ability to reach out to people in your own special way. Maybe it’s to say “thank you” to that special client or friend, or perhaps to congratulate a fellow worker on a well-deserved promotion. Simply access easy-to-use, free templates from avery.com and design a customized note car…

1500+ Professional Digital Photo Backgrounds and Photography Frame Templates $49.95 This is EZbackgrounds’ premiere professional package. More than just digital backgrounds, we have frame templates optimized for Photoshop, graphic design elements, and digital templates such as magazine covers, sports cards, birth announcements and much more. All optimized for use with your image editing program including all versions of Photoshop. We offer one-on-one email technical support an…

Adobe Photoshop Elements 10 $63.99 Turn everyday memories into sensational photos you’ll cherish forever. Adobe Photoshop Elements 10–the newest version of the #1 consumer photo-editing software–makes it easy to edit and create using automated options. Make flawed photos phenomenal with a brush stroke, create perfect group shots, and easily add patterns and effects. Tell your stories in unique printed creations and Online Album…

Corel VideoStudio Pro X4 Ultimate $42.50 COREL VIDEOSTUDIO PRO X4 UL EN MINI-BOXVIDEOSTUDIO PRO X4 UL EN MINI-BOX Manufacturer : COREL UPC : 735163137040…

Adobe Photoshop Elements 10 Upgrade $73.24 Adobe Photoshop Elements 10 for Mac & Windows is a comprehensive yet simple solution to managing, enhancing, and sharing your digital photos and video clips. The software supplies all the tools you need to crop photos, add effects & text, create online albums, and upload photos & videos to your favorite social-networking sites. With Guided Edits, you get step-by-step assistance with many common ta…

Photoshop Compositing Secrets: Unlocking the Key to Perfect Selections and Amazing Photoshop Effects for Totally Realistic Composites $25.19 Unlocking the Key to Perfect Selections and Amazing Photoshop Effects for Totally Realistic CompositesCompositing is one of the hottest trends in Photoshop and photography today for portrait photographers, designers of all walks of life, and even retouchers. Everywhere you look, from group photos, to school graduation or sports portraits, to magazines, movie posters, and DVD covers, chances are, y…

Martha Stewart’s Encyclopedia of Crafts: An A-to-Z Guide with Detailed Instructions and Endless Inspiration $17.95 Book Description For nearly 20 years, home crafters have turned to the pages of Martha Stewart Living for all kinds of crafts projects, each presented in the magazine’s inimitable style. Now, the best of those projects, including step-by-step instructions and full-color photographs, have been collected into a single encyclopedia. Organized by topic from A to Z, Martha Stewart 

Travis Reuter – Rotational Templates $38.6 Rotational Templates

Setting Up a Successful Photography Business (Paperback) $32.02 Setting Up a Successful Photography Business is a practical handbook which covers everything you need to know to start your own photography business. Packed full of helpful information and advice on all the essentials from self-publicity, building a portfolio and setting up a website to terms and conditions of contracts and dealing with agents, business practice and finance, this book includes everything that a photographer needs to know to get their career off to a successful start. The book also contains useful templates for essential paperwork such as estimate forms, contracts and production sample templates- everything you need to help you get started.

Teaching and Learning With Digital Photography by Good, Linda Edition ILL, 0 $29.99 This all-in-one guide offers early childhood educators concrete examples for integrating digital photography into teaching and assessment and includes a CD-ROM with user-friendly forms and templates.

Photography by Zimberoff, Tom Edition ILL, 0 $13.99 By using the Photography: Focus on Profit package on the job, photographers will:* automatically calculate a profit whenever applicable* ensure a timely return of revenues through instant processing of bills, reminders, and invoices* create a ?virtual paper trail? in the office that can be easily accessed at every stage of the workflow* apply effective copyright licensing terms to all estimates, invoices, and confirmations* carry out customized promotions in time-efficient, professional manner* create documents and reports from cutting-edge, time-proven templates* instantly call up status reports, detailed client information, and track records* implement the ?best practices of photography? in their business procedures

Adobe Photoshop Lightroom 2: Streamlining Your Digital Photography Process $25.77 Professional advice that can revolutionize your workflow In this book, photographer Nathaniel Coalson teaches you the most efficient and effective ways to process images in Lightroom 2, allowing you to work smarter and faster to produce high quality images. You will learn professional techniques and shortcuts that let you spend less time in front of your computer and more time behind the camera, where creativity and vision begin. Save time by getting familiar with the Lightroom workspace Speed your processing with presets and templates Easily adjust tone, color, and contrast Apply localized adjustments including dodging/burning and retouching Convert color originals to black and white Shorten editing time by using the optimal camera settings at the time of capture

Adobe Photoshop Lightroom 4 (PC and Mac) $79 Adobe Photoshop Lightroom 4 (PC and Mac): Superior image processing Nondestructive environment Selective editing brushes Extended video support Advanced black and white conversion Advanced color editing Highlight and shadow recovery Superior noise reduction White balance brush Lens correction Perspective correction Film grain simulation Intelligent sharpening Dust busting Intuitive environment Develop presets Compatible with Windows Vista/7 and Mac OS X 10.6.8 or 10.7

Advanced Packaging [With CDROM] $29.74 STRUCTURAL PACKAGE DESIGN is a series of books, jam-packed with superb, 100% structurally accurate, scalable packaging templates. All designs are ready for immediate use and illustrated with 2-D and 3-D structural drawings and photographs. The CD contains the templates in various formats including EPS and PDF. Also included is a demos version of Illustrator -Plug-Ins that provide professional package design possibilities. This volume ADVANCED PACKAGING contains 200 more complex designs.

Basic Packaging [With CDROM] $29.74 STRUCTURAL PACKAGE DESIGN is a series of books, jam-packed with superb, 100% structurally accurate, scalable packaging templates. All designs are ready for immediate use and illustrated with 2-D and 3-D structural drawings and photographs. The CD contains the templates in various formats including EPS and PDF. Also included is a demos version of Illustrator?-Plug-Ins that provide professional package design possibilities. This volume ? BASIC PACKAGING ? contains 300 designs, including designs of all major industry standards.

Beginner’s Guide to Animation: Everything You Need to Know to Get Started $14 To beginners, making an animated movie can seem like voodoo magic. And in fact, until recently, animation was expensive and time-consuming. But now with the help of Beginner’s Guide to Animation, anyone can make animated movies, using a digital camera, basic software, and a computer. The book begins with an illustrated guide to setting up a simple animation studio at home, including a list of essential items. Then, new animators hit the ground running with six innovative, instructive projects designed to develop technical skills and explore the potential of animation. A full collection of scannable templates makes it even easier to get started and to finish up. Tips, tricks, and clear instructions on editing, scoring, even making your own show reels and shorts make this the complete one-volume guide to amazing friends and family–and everyone on YouTube!–with great I-made-it-myself animation.

CAD for Interiors Basics [With DVD] $48.89 CAD for Interiors: Basics is a practical guide to getting started in AutoCAD(r) for interior designers. Taking a hands-on approach, the reader is taken on a step-by-step process to draw a detailed building floor plan. Beginning with instruction on how to create project templates, the reader works their way up to a professional-quality presentation. The basics of Architectural Desktop(r) and 3-D CAD are also included. An included DVD complements the book, presenting videos of detailed AutoCAD(r) commands demonstrating the book’s instruction using a unique audio-visual approach. No other product for designers offers a blended approach to make learning visually exciting and effective.