Business Tracking Spreadsheet
Download our Generic Business Tracking sheet that enables financial business tracking of your sole proprietorship. This business tracker is a comprehensive and powerful excel spread sheet specifically designed by Acton Accounting to calculate your chequing/cash purchases, credit card purchases (Visa, Master Card MC or American Express Amex), payroll, sales tracker, and income summary expenditures.
If you feel more comfortable tracking your business financial activities by yourself using an Excel spreadsheet, due to the fact that you may not be able to find time to learn a brand new accounting software system, then this could be the form you need to download!
You can track all your disbursements paid by the company’s bank account in the Chequing-Cash Purchases worksheet. Don’t forget to record the GST amount if you need to file your GST returns! Scroll to the farthest right column for a variance check.
Disbursements paid by the company’s credit card can be tracked in the Credit Card Purchases worksheet. Again, you can scroll to the farthest right column for a variance check.
All employee pay expenses need to be recorded in the Payroll worksheet.
Sales information can be recorded in the Sales Tracking worksheet. Remember to record the GST and/or PST collected on sales if you need to file your GST and/or PST returns.
To look at your business income statement, go to the Income Summary worksheet!
Please be advised that this Business Tracking Spreadsheet should only be used for sole proprietors and is not advisable for any business with over 100 business transactions per month.
Download the Generic Business Tracking sheet to keep track of all your business records today