Tweet

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

Written by: Carl Chesal

Article Overview: You have started a small business while still working or to create additional income for your household income. You know nothing about accounting or bookkeeping. This accounting administration part of business scares you a bit and is holding you back from 'Doing IT'. Here is a simple approach to achieve the recording of your business financial books. No prior accounting or bookkeeping knowledge required! Don't buy Quick Books or AccPac or some other accounting package. This simple bookkeeping approach is easy and FREE.

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.

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

Related Articles
  Why Accounting Outsourcing
  Outsource Accounting
  Outsourcing Accounting: Easy Accounting Outsourcing to India for Small Businesses in USA
  Small Business Accounting Services and Double Entry Bookkeeping
  Report presentations to provide clarification of your financial position

Article Tags: accounting spreadsheet, accpac, financial books, quick books, simple accounting, small business, spreadsheet template



Related Forum Posts
Wearing different hats in Business - I have a business that produces beautiful custom rugs for home and business environments. Different hats that I'm wearing... Rug Fabrication - 10 [i:21cr28m8](partially outsourced to an outfit here in the US)[/i:21cr28m8] Customer Service / Sales - 8-10 Bookkeeping - 1 Marketing - 6 Website development - 5 [i:21cr28m8](mainly outsourced)[/i:21cr28m8] SEO, SEM - 6-8 Accounting - [i:21cr28m8](outsourced)[/i:21cr28m8]
Re: New Infographic: Top Ten Reasons to Partner with Someone - I like it. Simple yet informative. I also RT'd it for you.
Re: Is being too connected pushing your business forward or back - Good advice, Terrycan! Simple but necessary.
Seek Venture Capital & Funding - Hello, Greetings from India. I am Seeking Venture Capital for Offshore Software Company Start-up. Need advise along with Business Model Sample. I have a basic outline for an offshore company. 1. Technology - like Microsoft Dot Net, Java, LAMP 2. Talent Team - Found Good Technology Developers. 3. Where I can get the leads/potential customers - Leads have been identified who are willing to move forward offshore projects. 4. I do not have resources like funding. It is a very critical factor to me Industries: Manufacturing, Real Estate, Retail, Insurance, Distribution & Logistics, Healthcare, Industry Associations and Software Product Development, Agricultural Industries and Etc. Services: Offshore Software Development Company. Offices to be located: Hyderabad, Andhra Pradesh, India and USA. Products/Services/Applications in areas like POS & Billing, Sales & Distribution, Production Planning, Material Management, Inventory Control, Plant Maintenance, Purchasing, Accounting and Logistics. Dynamic Web Programming with Database Driven Content Management Systems, Online Stores for E-Commerce, B2B Solutions, Community Portals, Website Redesign and Development, Custom ERP with Enterprise Wide Functional Modules such as Marketing, CRM, Accounting, Inventory Control, Sales & Distribution, Production Planning, Purchase & Stores, Logistics and Supply Chain. Seek your further questions and help. Thank you, Best Regards, Jayapratap.
My entry - 1. The Best Business Books Ever: The 100 Most Influential Business Books You'll Never Have Time to Read - this is a fascinating book about the history of Business theory, and I'd recommend it to anybody. 2. The Big Book of Small Business: You Don't Have to Run Your Business by the Seat of Your Pants, by Tom Gegax. Ditto. 3. PADI: The Business of Diving Book Okay, so this book won't be of use to anyone who doesn't want to start a scuba store, but I did, and this book was of course invaluable to me in reaching that goal.


Share this article with your friends. Fund someone's dream.

Leave a comment below or share on the left and you'll help support entrepreneurs in Africa through our partnership with Kiva. Over $50,000 raised and counting - Please keep sharing! Learn more.

Tweet

Newsletter

Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!

Name:
Email:

Popular Articles

3 Health Insurance Misconceptions

Track Your Time for Increased Productivity

How do you keep it together on a daily basis?

Suggestions

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.