Our tax tracking feature allows you to apply a tax rate and tax amount to each expense. This feature is currently available on Team and Corporate policies.

Covered in this Article:

Setting up tax tracking

Tax tracking can be enabled in the policy settings (Admin > [Policy Name] > Tax)

If your policy is connected to Xero, QuickBooks Online or NetSuite enable Tax via the connection configuration page (Admin > [Policy Name] > Connections > Configure)

You can then:

  • Add tax names, rates, and codes (if your policy is directly connected to an accounting system then your taxes will instead be imported)
  • Enable/disable the taxes you would like to make available to users
  • Set a default tax for policy currency expenses and, optionally, another default tax (including exempt) for foreign currency expenses which will automatically apply to all new expenses

Applying simple tax to expenses

  • Once tax tracking has been enabled in the policy, the default taxes for the policy will automatically be added to all expenses
  • If the tax on your receipt is different to the default tax, select the appropriate tax from the tax drop down on the web expense editor or the mobile app
  • The tax amount will automatically be calculated.  If the tax amount on your receipt is different to the calculated amount, manually type in the correct tax amount.

Applying complex tax to expenses

  • If different taxes apply to different items on your receipt then use the Split Expense function and apply the correct tax to each part.
  • If you don't know the tax inclusive total amount that the tax amount on a receipt applies to, use the following formula to calculate this: (Tax amount x (100 / Tax rate)) + Tax amount.

Setting up multiple taxes (GST/PST/QST) on indirect connections

Expenses sometimes have more than one tax applied to them, for example in Canada expenses can have both a Federal GST and a provincial PST or QST.  

Expensify has a special method for handling these which is to create a single tax that combines both taxes into a single effective tax rate.  

For example, if you have a GST of 5% and PST of 7%, adding the two tax rates together gives you the effective tax rate of 12%.

Once you have your taxes added to Expensify, contact us and request that we add the MultipleTaxReport.ftl export template in your account. 

After the report is added to your account, select the Reports you want to export then click Export to > Tax Report. Expensify will generate a CSV containing all the expense information including the split out taxes.

Exporting tax

Tax information can also be included in the spreadsheet export of your expense reports. Learn more about customised spreadsheet exports on our reports export page.

For a live overview of the Policy Admin role, policy management and administration, register for our free Collect Webinar!

Still looking for answers? Search our Community for more content on this topic!

Did this answer your question?