Simple Accounting for the Small Business Synoptic Journal Bookkeeping using a Simple Accounting Spreadsheet Template
Simple Accounting for the Small Business Synoptic Journal Bookkeeping using a Simple Accounting Spreadsheet Template
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.
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!
selling and marketing
Simple Accounting for the Small Business Synoptic Journal Bookkeeping using a Simple Accounting Spreadsheet Template - To learn more about this author, visit Carl Chesal's Website.
Like this article? Share it with your friends
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.
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!
selling and marketing
Simple Accounting for the Small Business Synoptic Journal Bookkeeping using a Simple Accounting Spreadsheet Template - To learn more about this author, visit Carl Chesal's Website.
Like this article? Share it with your friends
 | |
 |
No article feedback found. |
| |
Leave Your Feedback |
 | |
| |||
Cheryl MatthynssensCheryl is a life skills coach, licensed Chemical Dependency Counselor and a 20 year entrepreneur. Cheryl's dedication to achieving a life of balance led to her expanding her teaching from the simple managing of life's daily challenges to adding financial well being as well. A direct marketer with DrinkACT, she is gaining ground in the online community with her concepts of making sure business owners, entreprenuers and employees have well rounded life styles. She opened up a small affiliate site - The Balance Guide- to help others find resources for mental and emotional well being. Visit Cheryl's blog to see more of the diversity beyond business she has began offering online at www.thebalanceguide.blogspot.com - Visit Cheryl Matthynssens's Website |
|||
Linda RichardsonLinda Richardson is the Founder and Executive Chairwoman of Richardson, a global sales training and performance improvement company. As a recognized leader in the industry, she has won the coveted Stevie Award for Lifetime Achievement in Sales Excellence and she was identified by Training Industry, Inc. as one of the “Top 20 Most Influential Training Professionals.” Ms. Richardson is credited with the movement to Consultative Selling and is the author of ten books on selling and sales management, including Sales Coaching — Making the Great Leap from Sales Manager to Sales Coach, and Stop Telling, Start Selling. She teaches sales and management at the Wharton Graduate School of the University of Pennsylvania and the Wharton Executive Development Center. Linda is a frequent speaker at industry and client conferences, has been published extensively in industry and training journals, and has been featured in numerous publications, including The Wall Street Journal, Forbes, Nation’s Business, Selling Power, Success, and The Conference Board Magazine. Learn more about Richardson's sales training and performance improvement solutions at http://www.richardson.com web - Visit Linda Richardson's Website |
|||
John AlexanderJohn has taught keyword research and SEO skills to small groups of business owners and Webmasters from over 80 different countries world wide since 2002. John is also the Director of Search Engine Academy ; Co-director of Training at Search Engine Workshops offering live, SEO Workshops with his partner SEO educator Robin Nobles, author of the very first comprehensive online search engine marketing courses at SEO Training Online and the SEO Workshop Resource Center. I look forward to hearing from you! - Visit John Alexander's Website |
|||
John BrennanJohn Brennan Ed.D. Dr. Brennan is President of Interpersonal Development, LLC, a training and development firm. Interpersonal Development has provided sales training and coaching to more than 3,000 sales reps from over 100 companies. A native of Australia, Dr. Brennan received his doctorate from the University of Rochester. His dissertation researched the effectiveness of Behavioral Modeling Technology in training people in interpersonal skills. While he has spent most of his career designing or delivering training, he was also a Vice-President of Sales of a training and development franchise with operations in 25 markets. Dr. Brennan has designed and delivered sales training in North America, Asia, Europe, Australia and the Middle East. He has been a guest speaker at numerous national and regional professional conferences. When Microsoft wanted Best Practices articles on sales for their web site, they called Dr. Brennan. The results are at http://office.microsoft.com/en-us/FX011387391033.aspx His firm’s clients have included Volvo, The Prudential, Merrill Lynch, Eastman Kodak, Gannett, Equifax Europe, the Economist Group and countless small businesses. - Visit John Brennan's Website |
|||
David BarrDavid Barr is the President of Venture Opportunities, Inc. David has been a professional business broker/intermediary since 1980 focusing on General Business Brokerage and Mergers and Acquisitions representing client transaction value from $400,000 to $20,000,000. Mr. Barr has handled the sale of over four hundred and fifty companies. David earned a university degree from the State University of New York majoring in economics and business. David holds the Mergers and Acquisition Master Intermediary and the Certified Business Intermediary designations from the International Business Brokers Association. He is also a Senior Business Analyst and a Texas licensed Real Estate Agent. For more information about David and Venture Opportunities, visit www.bizdealmaker.com. - Visit David Barr's Website |
|||
Anne BarrAnne Barr has over 26 years experience in sales and marketing, six years as a franchisee. She has assisted over 367 business owners and purchasers to achieve their goals in career change, transition and exit strategy. She holds the designation of Certified Franchise Executive from the International Franchise Association, Certified Business Intermediary from the International Business Brokers Association and Board Certified Broker from the Texas Association of Business Brokers. Anne is active in professional organizations, networking groups and volunteers for non-profit entities. As owner/operator of four successful businesses, Anne has proven people skills and enjoys helping clients find the right "fit" in business ownership. Visit www.FranchiseOpportunitySpecialist.com for more information about me and my company. - Visit Anne Barr's Website |
|||
Casey GollanCasey Gollan, Business Coaching & Mentoring Programs. Add $1 Million to $10 Million in the next 1 to 3 years. Since 1996 Casey has to added hundreds of millions of dollars to businesses. Watch a free video see client results Business Coaching website. - Visit Casey Gollan's Website |
|||
Kim CastleWith nearly two decades in the advertising and design business, with clients like Domino's Pizza, General Motors, Direct TV, Pedigree, Wolfgang Puck, Higher Octave Music, Hollywood Celebrity Products, Disney, and Paramount, as well as thousands of entrepreneurs around the world define, structure, communicate, and position their business for greater profits, BrandU(R) co-creators Kim Castle and W. Vito Montone discovered that entrepreneurs could experience the same power that big brands command for a fraction of the cost with the world's only process-based results-drive Integral approach to business creation. BrandU(R) is helping entrepreneurs grow with the power of extreme clarity from idea...to brand...to market(TM) and helping one million entrepreneurs become successful and whole so that they can make a difference in the world. Are you one of them? If you want to experience clarity all the way to the bank(TM), get started now at http://www.brandu.com. - Visit Kim Castle's Website |
|||
|
To learn more about the Evan Elite Author Program please contact us. | |||
 | |
|  |
Subscribe to Carl's articles
 |
|
Communicate Innovate Collaborate - Business and Professional Development for Entrepreneurs wishing to make a positive difference in life and career. Discussions about Sales, Marketing, Internet Marketing underlined by motivating people. Leadership applied to all aspects of life and work.
|
|
 |
 | |
|
| |
 | ||
 |
||
 |
||
 |
||
|
| ||
 |
| Have you written articles that would be of value to entrepreneurs? Become an expert on our site by publishing them! Expose yourself to a wide audience, drive more traffic to your website and get more sales! Click Here for details. |
|
|
 |
| Modeling the Masters: Learn the true secrets behind Walt Disney's business success factors & grow your company! Video produced by Phanta Media |
|
|
 |
"Learn straight from Evan how you can Make a Full Time Income (And More) from a Website"
Click Here To Learn More |
|
|
|
|
Get advice & tips from famous business owners, new articles by entrepreneur experts, my latest website updates, & special sneak peaks at what's to come!
|
|
 |
 Making Networking Work Networking Difference In A Decade Disciplines of Success Free Marketing Plan Template Joint Ventures ebook |
|
 | ||
 |
Write The PR
Press Release Builder | |
 |
More PR Resources
Press Release Builder | |
| ||
 | ||||
| ||||
|
| ||||
| ||||
|
|
|
|
|
||||||||||||
|
Email us your ideas on how to make our website more valuable! Thank you Sharon from Toronto Salsa Lessons / Classes for your suggestions to make the newsletter look like the website and profile younger entrepreneurs like Jennifer Lopez and Sean Combs!
|
|
|
| ||||||||||||
| ||||||||||||
|
|
||||||||||||