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.