Example of Excel template used to keep records for a business with GST, 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 GST you can see an example here.


Gross Income GST collected Net Income Gasoline GST paid with gasoline Car repairs GST paid with car car repairs Tolls GST in tolls Total GST paid out


























































































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