blank spreadsheet

Thank you for visiting Centaur Accounting Online.
Sole proprietors can use this form to display their total revenues and expenses for the year. Clients who bring in this form will not be charged for hourly bookkeeping services as they are adding the expenses themselves. This form can also be useful for clients who rent out their home or have rental properties during the year.The file can be downloaded in Word format here,

Business Expense Spreadsheet

Name: _______________________________ Business Name: _______________________________________

Main Product or Service: ______________________________

Business Income:

Sales, Commissions, or Fees (without GST/HST)ЕЕЕЕЕЕЕ $ ________________

HST collected from income ЕЕЕЕЕЕЕЕЕЕЕ..ЕЕЕЕ. $_________________

Total gross sales ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ...Е $ ________________

Please note:
-If you are a HST registrant, (you charge HST) please provide amounts without HST tax on the spreadsheet.
-If you are not a HST registrant, (you do not charge HST) include the total, HST tax included amount.

Cost of Goods Sold: circle one: Without HST / or HST Included

Opening Inventory ЕЕЕЕЕЕЕЕЕЕЕ.Е..$________________ HST amount $________________

Purchases During the year ЕЕЕЕЕЕЕЕЕ...$________________ HST amount $________________
.
Closing Inventory ЕЕЕЕЕЕЕЕЕЕЕЕ.....$________________ HST amount $________________

Business Expenses

Advertising ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ.....$_________________ HST amount $________________

Meals & Entertainment ЕЕЕЕЕЕЕЕЕ......$_________________ HST amount $________________
.
Bad Debts ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ.......$_________________ HST amount $________________

Insurance ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ.....$_________________

Interest ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ...Е..$_________________

Business Tax, fees, licences, dues, memberships..$_________________ HST amount $________________

Office Expenses ЕЕЕЕЕЕЕЕЕЕЕЕЕ.....$_________________ HST amount $________________

Supplies/Purchases ЕЕЕЕЕЕЕЕЕЕЕ....Е.$_________________ HST amount $________________

Legal, Accounting, & Other Professional Fees Е$_________________ HST amount $________________

Management & Admin Fees ЕЕЕЕЕЕЕЕ....$_________________ HST amount $________________

Rent ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ.............$_________________ HST amount $________________

Maintenance & Repairs ЕЕЕЕЕЕЕЕЕ...Е.$_________________ HST amount $________________

Salaries, Wages and Benefits ЕЕЕЕЕЕЕЕ...$_________________ HST amount $________________

Subcontracts ЕЕЕЕЕЕЕЕЕЕЕЕЕЕ.......$_________________ HST amount $________________

Property Taxes ЕЕЕЕЕЕЕЕЕЕЕЕЕЕ..$_________________

Travel ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ......$_________________ HST amount $________________

Telephone & Utilities ЕЕЕ..ЕЕЕЕЕЕЕЕ$_________________ HST amount $________________

Fuel Costs (except for Motor Vehicles) ЕЕЕ...$_________________ HST amount $________________

Delivery, freight, postage ЕЕЕЕЕЕЕЕЕ....$_________________ HST amount $________________

Other Expenses ___________________Е..Е..$_________________ HST amount $________________

Other Expenses ___________________Е..Е..$_________________ HST amount $________________

Total Expenses ЕЕЕЕЕЕЕЕЕЕЕЕЕ..Е$_________________ HST amount $________________

Please list any Furniture, Equipment or Computer purchases:
Description Date Purchased Purchase Price HST Amount

Office in Home Expenses (if applicable)

Area of Home used for business activityЕЕЕЕ __________________ %

Total area of home ЕЕЕЕЕЕЕЕЕЕЕЕ __________________ sqТ

Heat ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ....$__________________ HST amount $________________

Electricity ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ..$__________________ HST amount $________________

Insurance ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ....$__________________ HST amount $________________

Maintenance ЕЕЕЕЕЕЕЕЕЕЕЕЕЕ......$__________________ HST amount $________________

Mortgage Interest ЕЕЕЕЕЕЕЕЕЕЕЕ.....$__________________

Property Taxes or RentЕЕЕЕЕЕЕЕЕЕЕ$__________________ HST amount $________________

Other Expenses ЕЕЕЕЕЕЕЕЕЕЕЕЕ.....$__________________ HST amount $________________

Personal Use area of the homeЕЕ..ЕЕЕЕ.... __________________ %

Note: Expenses for office-in-home cannot be used to increase a business loss. If your business has a loss through normal operating expenses (from the first page of this spreadsheet) your office-in-home expenses will be carried forward to apply against future business income. This carry-forward does not expire.

Motor Vehicle Expenses

Vehicle Make/Model/Year _____________________________________

KilometerТs driven to earn business income Е..$__________________

Total KilometerТs driven in the year ЕЕЕЕ..$__________________

Fuel & Oil ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ......$__________________ HST amount $________________

Insurance ЕЕЕЕЕЕЕЕЕЕЕЕЕЕЕ....Е$__________________

License & Registration ЕЕЕЕЕЕЕЕЕЕЕ$__________________ HST amount $________________

Maintenance & Repairs ЕЕЕЕЕЕЕЕЕЕ...$__________________ HST amount $________________

Leasing Costs / Financing InterestЕЕЕЕЕЕ..$__________________ HST amount $________________

Business Parking ЕЕЕЕЕЕЕЕЕЕЕЕЕ....$__________________ HST amount $________________

Other Expenses ЕЕЕЕЕЕЕЕЕЕЕЕЕ.....$__________________ HST amount $________________

Note: Claims for leasing and interest charges are subject to maximum figures allowed by Canada Revenue Agency.

Home

centaur.co й 2010 | Privacy Policy

Centaur Accounting Inc. London Ontario Bookkeeping , Personal , Business and Corporate Income Tax Preparation