Simple Accounting For The Small Business - Bookkeeping Using A Simple Spreadsheet Template

Starting a small business out of your home, offeringtelephone & cell phone, air fare, office supplies,
products or services like business consulting,etc. This is an excellent place to identify the various
photography, selling on the web or a MLM? You areBusiness Expense Accounts you need to set up for
now faced with tracking all your expenses andyour business accounting books. To complete your
revenues for your business and you certainly don'tbusiness Chart of Accounts, include a Business Bank
have the money yet to engage a bookkeeper orAccount, Sales, COGS (Cost of Goods Sold), Sales
accountant. If your business is a sole proprietorship,Tax Collection, Marketing Expense and others as
whether it be a Canadian Proprietorship or arequired. Each of these Accounts will be a listed as a
US-based Proprietorship, you do not require antitle across the top of each column of your Synoptic
accountant to submit your company financials (books)Journal. Each row (line item) will be the individual journal
to the IRS (USA) or Revenue Canada). Your businesstransactions entered by you. The journal transactions
revenue and losses are reported as part of yourare grouped and summarized for each business
annual personal income tax. For this small businessmonth; usually, January through December.
start-up, you won't need to buy fancy accountingSo your Synoptic Journal would look something like this
software, like Quick Books or AccPac to track yourSample Synoptic Journal at
business.The column headings might be in this order (from left
Only as part of incorporating Bizfare Enterprise Inc into right):
2005 was it a requirement to engage an accountant.DATE | DESCRIPTION | BANK DEPOSITS | BANK
My accountant did insist on using Quick BooksWITHDRAWALS | SALES REVENUE | COGS |
software for my business accounting. Up until thenSALES TAX COLLECTED & REMITTED |
using a simple spreadsheet template served myOFFICE SUPPLIES EXPENSE | EXPENSE #2 |
business accounting needs for over ten years. ThisEXPENSE #3 | ETC
simple spreadsheet accounting stood the test ofTIP #2: Unless your business is Incorporated or an LLC,
multiple audits by Revenue Canada (CRA andyou don't need to go through the expense of opening
Revenue Canada Goods and Services Tax. Both thea business account with your bank. Usually Business
hardcopy columnar pad and an electronic spreadsheetaccounts charge a higher monthly fee, charge for
version of my financial books were accepted byprinting checks (cheques) and don't offer any interest
Revenue Canada. (BTW the audits disclosed moreon your monthly account balance. Instead, open a
ways for me to claim back additional taxes for theseparate personal bank account (maybe savings). This
previous three years! Now that's my type of audit!)will show the 'taxman' that you are keeping the
In your new start-up business venture, you likely willbusiness separate from your personal banking.
generate somewhere between 10 to 30 accountingRemember you are a sole proprietor and all your
transactions per month. These transactions would bebusiness income (and losses) are to be applied directly
items like Expense, Revenue (sales), Liability (Loan)to your personal income tax submission ( a s per IRS
type transactions and Sales Tax (Federal + Stateand CRA).
Provincial) Collection/Deductions. These transactionsTo save you time and make is very simple, I have
are further broken down into various Businessalready created a simple spreadsheet Synoptic Journal
Accounts. All the Accounts you set up for yourtemplate that performs all the calculations for each
business is called a Chart of Accounts. Recording yourmonth and rolls up the 12 business months so it can
business financial transactions (Journal Entries) can beeasily be included in your annual personal income tax
executed with pen and ink on an accounting columnarpreparation. This Synoptic Journal template has Debit
pad or electronically with your computer using aCredit checks and balances, tracks sales taxes,
spreadsheet program (MS Excel, Open Office, Starmileage and totals each account for your entire fiscal
Office).year. If you want this FREE Bookkeeping template,
Whether you employ electronic or hardcopy media,you can get it at Communicate Innovate. With a few
you need to develop a simple Journal template tokey strokes, which will help identify yourself, I will gladly
create your Business Synoptic Journal. This Synopticsend you this FREE Synoptic Journal Template and
Journal format has the advantage of allowing you aalso any future Small Business Tips.
complete view of all your individual journal entryTIP #3: One Rule of Accounting is that every time you
transactions against all your various Businessrecord a journal entry (line item which applies the
Accounts. Creating this Synoptic Journal is easier to dotransaction against the appropriate business accounts)
than you think and requires no prior accounting orthe Debits and Credits MUST REMAIN EQUAL at
bookkeeping knowledge.ALL Times. This Debit Equals Credit calculator is built
TIP #1: You could further reduce the accounting lineinto this FREE Bookkeeping Template. When you have
items (Journal Entries) by consolidating like items suchcompleted entering a line item (journal transaction),
as 'all the Sales for the month' and 'all parking receiptscheck to ensure that the amount the the Debit cell
for the month' into one totaled line item for the month.equals the amount in the Credit cell. If they are not
Where do you start to identify the various Businessequal, you have not entered the amounts properly in
Accounts required for your Synoptic Journal?your journal transaction. Correct the problem before
If you currently work for a company or government,entering your next journal entry.
secure of one of their employee expense forms. LookYou are now equipped to capture your business
at each of the areas identified as expenses - meals,financial books with some simple accounting software.
mileage, hotel accommodations, taxi, car rental,Happy bookkeeping! And Happy Selling!