Example of Excel template used to keep records for a business with HST, see the business deduction file for a complete list of allowable expenses. In this example not all allowable deductions are included. You should create your own Excel file and post all expenses for which you have receipts in the appropriate cell. For a business that does not charge HST you can see an example here.
Gross Income	HST collected	Net Income	Gasoline	HST paid with gasoline	Car repairs	HST paid with car car repairs	Tolls	HST in tolls	Total HST paid out

HST that must be remitted to CRA A negative number means that you are entitled to a refund.